Skip to content

Instantly share code, notes, and snippets.

View alivarzeshi's full-sized avatar

Ali varzeshi alivarzeshi

6 followers · 6 following
View GitHub Profile
@alivarzeshi
alivarzeshi / Top Critical Components of Data Engineering
Last active October 4, 2024 10:39
Top Critical Components of Data Engineering
Top Critical Components of Data Engineering
@alivarzeshi
alivarzeshi / Alivarzeshi
Last active May 7, 2025 18:23
Optimizing WordPress performance
‎‎​
@alivarzeshi
alivarzeshi / prevent split-brain scenarios.txt
Last active July 5, 2024 08:56
What strategies does WSFC use to prevent split-brain scenarios?
What strategies does WSFC use to prevent split-brain scenarios?
@alivarzeshi
alivarzeshi / SQL_Server_Error_Logs_Part_01.txt
Last active June 21, 2024 22:08
Date/Time: 2023-06-22 09:00:00
Log Level: Information
Source: SQL Server
Message: Database 'MyNewDatabase' was created by user 'admin'.
Date/Time: 2023-06-22 10:00:00
Log Level: Information
Source: SQL Server
Message: Database 'OldDatabase' was deleted by user 'admin'.
@alivarzeshi
alivarzeshi / Main Folder Security.sql
Last active October 12, 2024 16:36
Main Folder Security
DECLARE @IsPrimary INT;
DECLARE @JobName NVARCHAR(128);
-- Check if the current node is the primary replica
SELECT @IsPrimary = CASE
WHEN role_desc = 'PRIMARY' THEN 1
ELSE 0
END
FROM sys.dm_hadr_availability_replica_states AS ars
JOIN sys.availability_replicas AS ar
@alivarzeshi
alivarzeshi / SQL_Server_Error_Logs_Part_08.txt
Last active June 21, 2024 22:02
Date/Time: 2023-06-22 14:00:00
Log Level: Warning
Source: SQL Server
Message: High CPU usage detected. SQL Server is utilizing 90% of the available CPU resources.
Date/Time: 2023-06-22 14:30:00
Log Level: Warning
Source: SQL Server
Message: SQL Server has detected memory pressure. The buffer cache hit ratio is below the recommended threshold.
@alivarzeshi
alivarzeshi / SQL_Server_Error_Logs_Part_07.txt
Created June 21, 2024 21:56
Date/Time: 2023-06-22 08:00:00
Log Level: Information
Source: Replication
Message: Publication 'SalesDataPublication' was created successfully.
Date/Time: 2023-06-22 09:00:00
Log Level: Information
Source: Replication
Message: Subscription to publication 'SalesDataPublication' was initialized successfully for subscriber 'SubscriberServer'.
@alivarzeshi
alivarzeshi / SQL_Server_Error_Logs_Part_06.txt
Last active June 21, 2024 21:55
Date/Time: 2023-06-22 10:23:54.32
Log Level: Information
Source: Always On
Message: The state of the availability group 'AG1' has changed from 'RESOLVING' to 'PRIMARY'.
Date/Time: 2023-06-22 10:25:03.78
Log Level: Warning
Source: Always On
Message: An automatic failover occurred in availability group 'AG1'. The primary replica is now 'Replica
@alivarzeshi
alivarzeshi / SQL_Server_Error_Logs_Part_05.txt
Created June 21, 2024 21:42
Date/Time: 2023-03-03 09:00:00
Log Level: Information
Source: SQL Server
Message: Login succeeded for user 'username'. Connection: Non-Trusted.
Date/Time: 2023-03-03 09:05:00
Log Level: Error
Source: SQL Server
Message: Login failed for user 'username'. Reason: Password did not match that for the login provided. [CLIENT: <local machine>]
@alivarzeshi
alivarzeshi / SQL_Server_Error_Logs_Part_04.txt
Created June 21, 2024 21:40
Date/Time: 2023-03-03 10:00:00
Log Level: Information
Source: Backup
Message: Database backed up. Database: MyDatabase, creation date(time): 2023/02/02(14:00:00), pages dumped: 350, first LSN: 73000000009200037, last LSN: 73000000009600001, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\Backups\MyDatabase.bak'}).
Date/Time: 2023-03-03 11:00:00
Log Level: Information
Source: Restore
Message: Database restored. Database: MyDatabase, backup start date(time): 2023/03/03(10:00:00), backup end date(time): 2023/03/03(10:30:00), number of backup devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\Backups\MyDatabase.bak'}).