SSMS backup failed with ‘Cannot use the backup file because it was originally formatted with sector size 4096’. Here is why it happens and the easy fix.
Listing Last Night’s Failed Agent Jobs With One msdb Query
List failed Agent jobs and steps from msdb history, include retries and cancellations, and account for local times and trimmed records.
SQL SERVER – Creating a Copy of Database in Azure SQL DB
A client wanted to tune a slow query on a copy, not on production. Here is how to create a copy of a database in Azure SQL DB and work on it safely.
SQL SERVER – What is Deadlock Scheduler? How to Reproduce it?
If you have come on this page by internet search, then you must have seen below error in the ERRORLOG which is about deadlock scheduler.
SQL SERVER – Becoming a More Effective DAX Developer with DAX Studio – Notes from the Field #134
Bill Anton walks through DAX Studio, the tool that makes writing, testing and tuning DAX easier for Power BI, Power Pivot and Tabular developers.
SQL SERVER – System Stored Procedures I Use to Get Started
System Stored Procedures remain part of my troubleshooting toolbox. I use these familiar entry points before moving to more detailed views.
How to Find Outdated Statistics? – Interview Question of the Week #081
How do you find outdated statistics? The honest answer is that ‘outdated’ is subjective. I explain why, and how I look at statistics instead.