Shredding XML in XEvents

One of the biggest pains with Extended Events is the thing we love to hate – XML. XML is so foreign...

Shredding XML in XEvents

One of the biggest pains with Extended Events is the thing we love to hate - XML. XML is so foreign to many DBAs. It's not relational and often...

PINTABLE

Compressing Outcomes

You find yourself cruising along, just doing your thing as a database administrator. Then the CIO plops down into a...

Compressing Outcomes

Find yourself struggling to determine the outcome of attempted compression settings in your database? This should help!
Related Posts:

Failed to Create the Audit File December 31, 2017

Disk Space and...

Tables, Columns and Defaults Oh My!

The joys of inheriting a new database and being thrown into the fire to quickly assimilate as much information about the database as possible can be troublesome. This script...

HealthySQL – A Review

How well do you know the health of your SQL Servers and databases? Ever wonder about the current health or...

Compressing Encrypted Backups

A common requirement, whether it be based out of pure want or truly out of necessity, is to make a...

Compressing Encrypted Backups

A common requirement, whether it be based out of pure want or truly out of necessity, is to make a large database backup file, that is encrypted, be much...

What is DBCC?

If I ask you what is DBCC, what would your answer be?
I want you to think about that one for...