We live in a day and age when security (data, network, server, etc) is seemingly at the forefront of the daily news.
BIT9 PathNames
Tag: Scripts
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 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!
Minor ailments and Healthy SQL
One of the things that DBAs love to do is keep their servers running and healthy. A healthy server, after all, is your ticket to a stress free day and a full night’s sleep. Granted […]
Supported Compatibility Levels in SQL Server
It has been well documented and is well known that SQL Server supports certain older versions of SQL Server in a compatibility mode. This setting is something that can be configured on the database properties […]
Missing Indexes Script v2
As is the case for many DB professionals, I am always tweaking (not twerking) and refining the missing indexes script to try and make it more robust and a little more accurate.