SQL Script | SQL RNNR

BIT9 PathNames

We live in a day and age when security (data, network, server, etc) is seemingly at the forefront of the daily news.

Easily Shred Event Data

Parsing XML is the epitome of salt in a wound for a DBA. Parsing the XML from Extended Events need not be so painful. Read further to discover how to remove the pain from the task of XML parsing.

SQL Server CTE – Back to Basics

Of all the fundamental concepts within SQL Server, this one drives me a bit batty from time to time. Think about that statement for just a moment.

SQL Server Select – Back to Basics

Of all the fundamental concepts within SQL Server, nothing is potentially more basic and fundamental than the often overlooked Select statement.

SQL Agent Job Schedules

SQL Agent job schedules should be easy to read for humans if for nothing else than the fact that you have to provide this information to the auditors from time to time.

Shredding Extended Event Actions

Are you rolling the dice with your love/hate relationship with XML? Tune in to see how you can ease your XML frustration along with increasing your free time to do more important things.

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 brings nightmares of parsing and performance issues.

Compressing Outcomes

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

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 will help with that!