Default Instance Reports – Configuration Changes History

Hey, who changed the max memory setting for the xyz instance? The good news is that this information is captured...

Default reports in SSMS

As DBAs our stock in trade is information and there is certainly an impressive amount available. The diagnostic views are...

Save and save often

It’s the second Tuesday of the month, and as I’m sure you remember that means it’s time for T-SQL Tuesday!...

What is the system_health extended events session?

Similar to the default trace the system_health session is automatically started up when the instance starts and collects information about...

SQL Homework – July 2017

For years Russ Thomas (b/t) has done a Monthly DBA Challenge and in fact I’ve used it as insperation a...

SQL Crossword : T-SQL Keywords : June 2017

I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked...

Temp table quiz

Brent Ozar (b/t) posted a pop quiz on twitter earlier today.

Go ahead and give it a shot .. I’ll wait.
So?...

Dynamically generate the command line DMA statement for each database

If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run...

Adding Identity to an existing column

A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He...

Turning ANSI_PADDING off, and why you shouldn’t

I ran into an interesting error the other day while doing a partition switch.
Partition switch failed because : column ‘xyz’...