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!
Tag: SQL Administration
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 smaller.
What is DBCC?
What is really mean by DBCC and what do people mean when they say DBCC?
HealthySQL – A Review
A quick look into the book by Robert Pearl: Healthy SQL.
Internal Tables and Space Used
Some of the beauty of SQL Server is the complexity that it holds. Some of that complexity is right before our eyes. And some of that requires a little bit of diving into the internals to figure out what is happening or even why it is complex.
What’s the Size of that Index?
When you need to figure out how indexes are contributing to the overall size of a table within a database, this script will help you!
Extended Events Removed from 2016
Extended Events continue to grow and improve – even with the removal of a few events.
SQL Server and Defaults
What is that default setting? SQL server does a fantastic job of having numerous settings at the server level and at the database level predefined for you. Additionally, the OS has a bunch of settings […]
Database Settings Changes – Red Handed
One of my pet-peeves (and consequently frequent topic of discussion) is finding database settings (or any setting that has changed) without knowing about it. Worse yet is finding that the change has occurred and nobody […]
New Extended Events for 2016
As we begin to get a grasp of all that is available with SQL Server 2016 and all of the new features, it is a great idea to see what else has been made available […]