When managing large databases or high-transactional databases, the performance of your underlying storage system is crucial, whether it...

Recently, one of my clients was experiencing performance issues with their SQL Server. Although the server was not underpowered from a...

Working with large databases, multi-terabyte in size, I've had clients who have wanted to move to the cloud. However, after testing and...

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...

Creating a data warehouse can be challenging. Identifying the grain is one of the most important parts of having a quality data...

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...