adgedenkers

# BBallSchedule.py
#
# Author:  AdgeDenkers
# created: 2024-10-28
# updated: 2024-11-13
# Version: 1.1
# Note:    Get the current dates event if any


import requests

adgedenkers

{
    "manufacturer": "Samsung",
    "product_type": "Household Microwave Oven",
    "manufactured_in": "42000 Pelabuhan Klang, Selangor, W. Malaysia",
    "manufacture_date": "March 2022",
    "model_number": "ME19R7041FS",
    "serial_number": "OBQKTVTT301045Z",
    "power": {
      "voltage": "120 Vac",
      "frequency": "60 Hz",

adgedenkers

import pandas as pd

def compare_excel_sheets(file1, file2, sheet1, sheet2, columns_to_compare, unique_id_column):
    # Load the excel files
    df1 = pd.read_excel(file1, sheet_name=sheet1)
    df2 = pd.read_excel(file2, sheet_name=sheet2)

    # Merge the dataframes on 'Position Number'
    merged_df = pd.merge(df1, df2, on=unique_id_column, suffixes=('_file1', '_file2'))

adgedenkers

1. Data Volume
    Description: The amount of data being processed.
    Impact: Larger volumes of data require more processing time and resources.
2. Data Complexity
    Description: The complexity of the data structure (e.g., multiple tables, nested data).
    Impact: More complex data requires more sophisticated analysis techniques and tools, increasing workload.
3. Frequency of Data Updates
    Description: How often data is updated or refreshed.
    Impact: Frequent updates can increase the workload as data needs to be continuously processed and analyzed.
4. Analysis Type

adgedenkers

Capturing rain in photos can be challenging due to the movement and varying light conditions. Here are some tips to help you take better rain photos with your iPhone:

1. Use Burst Mode

• Why: Rain is in constant motion. Using burst mode allows you to take multiple shots quickly, increasing the chances of capturing a clear raindrop or the perfect moment.
• How: Hold down the shutter button to activate burst mode.

2. Adjust Exposure

• Why: Rain can cause your photos to be either too dark or too light. Adjusting the exposure can help balance this out.
• How: Tap on the screen to focus, then slide your finger up or down to increase or decrease the exposure.

adgedenkers

'''
File: mouse_move3.py
Project: auto-move mouse
Created Date: 2024-03-27
Author: Adge Denkers
Email: [email protected]
-----
Last Modified: 2024-04-03
Modified By: Adge Denkers
Email: [email protected]

adgedenkers

'''
File: mouse_automove2.py
Project: mouse_automove
Created Date: 2024-03-27
Author: Adge Denkers
Email: [email protected]
-----
Last Modified: 2024-04-02
Modified By: Adge Denkers
Email: [email protected]

adgedenkers

In SQL Server, the term "nesting level" refers to the depth of nested actions triggered by triggers. When a trigger on a table causes another trigger to be fired, this creates a nesting of triggers. The function TRIGGER_NESTLEVEL() is used to determine the level of nesting for the trigger currently being executed.

Here's a bit more detail on TRIGGER_NESTLEVEL():

Purpose: TRIGGER_NESTLEVEL() is a function in SQL Server that returns the number of triggers executed in a chain of nested triggers. This helps in managing and controlling recursive or nested triggers execution.

Usage: You can use TRIGGER_NESTLEVEL() to:

Prevent excessive nesting which could lead to stack overflow, performance degradation, or logical errors in the application. Control or limit the recursive behavior of triggers by setting a maximum allowed nesting level.

adgedenkers

CREATE TABLE table_name (
	 id INT PRIMARY KEY IDENTITY(1,1)
	,title VARCHAR(15)
	,created DATETIME NOT NULL DEFAULT GETDATE()
	,updated DATETIME NULL
	,is_active INT NOT NULL DEFAULT 1
);
GO
 
CREATE TRIGGER trg_UpdatedTableName

adgedenkers

'''
File:      build_dim_date.py
Project:   fz
Created:   2024-02-03
Author:    Adge Denkers
           https://github.com/adgedenkers/
License:   MIT License
'''

import psycopg2