Posted inDatabase Administration
OlaHallengren Maintenance Solution – DatabaseBackup – Configurable Backup Directory folder names
If you are a DBA then you understand the importance of having robust Database Maintenance…
Posted inHealth Check TSQL
SQL Server – Stop Agent Job After Threshold Time and Log the Query Metrics
Being a DBA, I know the pain of a long running job creating performance issues…
Posted inTSQL
SQL Server – Get Database Backup History for Crash Recovery
It is not easy to find out right backups for restore activity when people are…
Error/Fix: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation
Recently I was working on a SQL query in my inventory database, and was greeted…
Posted inTSQL
Script-SQLDatabaseRestore cmdlet in SQLDBATools Module
Restoring multiple databases can be painful especially when each of them have multiple database file(s).…
![[sp_HealthCheck] – Get SQL Server Health Details](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2018/03/sp_HealthCheck.gif?fit=1024%2C500&ssl=1)
Posted inExecution Plan Health Check
[sp_HealthCheck] – Get SQL Server Health Details
Hi Friends, Ever wanted to check the heartbeat of SQL Server. It is a very…
Posted inExecution Plan Health Check Performance Tuning TSQL
What’s Running – Find All Details of Running Queries
I often see DBAs/developer struggling to find what's wrong with query. The first step in…
Posted inPerformance Tuning TSQL
Common Myth: Loop is Always Faster than Cursor
From past few weeks, I have been taking interview for Sr. SQL DBA position in…
Posted inPerformance Tuning Powershell TSQL
Deploy SQL-Server-First-Responder-Kit with Powershell
There are many tools in market that can help you troubleshoot in specific situations. My…
Posted inInternals Performance Tuning TSQL
Non – Trusted Foreign Keys in SQL Server
Today, I was working with one user to troubleshoot their query timeout issues. Analyzing wait…