Today, I want to discuss a topic that has been a bit of a headache for database administrators and consultants: the changes to SQL...

How many of us have created a new table and used the default and first data type nvarchar for all of the text/alphanumeric fields, or had...

Recently a question came up on the various file types that would be best to load into PowerBI, so I ran a few tests to see how it would...

A new way to create the SpeedPass for SQL Saturday Events.

Join me for some Sun, Sand and Code in Atlantic Beach, Jacksonville, Florida for this years Code on the Beach event. I am excited to have...

Recently I encountered a Microsoft SQL Server with relatively high and very consistent CPU usage with few peaks and valleys. When...

Bottom line? Don't use it! At least don't use it for a SQL cluster directly. Recently I stumbled on a configuration using S2D (Storage...

For VLDBs I've always created multiple files for each file group and had to set the trace flag 1117 on to ensure that all files grow at...

How many of us have just created a new table and put a Created Datetime and Modified Datetime field in with the default DateTime...

In this article, we will cover the specific steps to restore a set of TDE keys and a database to a new and or different server. This...

I recently performed an analysis of some data I pulled from my Octopus Deploy database using PowerBI Desktop. The reports I created,...

Recently, I started receiving multiple database filegroup growth alerts from my Idera SQL Diagnostic Manager. As this wasn't usual, I...

How many times has a developer come to you and informed you he must have 'sysadmin' rights to the database server(s) to do their job? How...

There always seems to be a need to move database files, whether it's a new system I'm setting up or an existing system that needs...