Toolbox - Just the Basics

There are many query sets out there to collect varying groups of configuration data - the ones I most frequently use...

Which Blogs Do I Recommend?

One of the most important parts of continuing learning as a DBA (or probably an IT Professional) is reading blogs. ...

Error 33206 - SQL Server Audit Failed to Create the Audit File

One of the joys of working with SQL Server is the descriptive and meaningful error messages, right?

https://vignette.wikia.nocookie.net/batmantheanimatedseries/images/a/a7/DiD_39_-_Joker_Vision.jpg/revision/latest?cb=20160610021326
Exhibit A - the 33206:
Error:...

Toolbox - Which Clerk Is Busy?

A few years ago I wrote what would turn out to be my most-hit blog post (so far) titled "Error...

Toolbox - Why is My Database So Big????

I have written previously (here)about how to tell which database files have free space in them when your drive starts...

T-SQL Tuesday #98 – Take Small Bites!

https://media.makeameme.org/created/mega-bytes-well.jpgIt's T-SQL Tuesday time again - the monthly blog party was started by Adam Machanic (blog/@AdamMachanic) and each month someone different...

Come to SQL Saturday Providence!

Tomorrow 12/09/2017 is SQL Saturday #694 in Providence, RI.

I will be presenting by SQL Server Health Check session first thing...

PASS Summit 2017 - Live and in Living Color!

UPDATE - the feed and schedule are live at http://www.pass.org/summit/2017/PASStv.aspx

http://rochistory.com/blog/wp-content/uploads/2014/09/NBC-logo.pngNot in Seattle for some reason this week?  Like maybe you stayed home...

But I Don't *Want* To "Restore from a backup of the database or repair the database!"

Do you like Log Shipping?
Before my time at Ntirety I had done quite a bit of work with failover clustering...

And YOU Get a Deadlock and YOU Get a Deadlock and EVERYBODY GETS A DEADLOCK!

https://memegenerator.net/img/instances/400x/59507872/you-get-a-deadlock-everybody-gets-a-deadlock.jpgWe all get them at one point or another - deadlocks.
I have Object 1 and need Object 2, you have Object...