top of page
Widget Didn’t Load
Check your internet and refresh this page.
If that doesn’t work, contact us.

SQL Server Autogrowth Settings Changes
Today, I want to discuss a topic that has been a bit of a headache for database administrators and consultants: the changes to SQL...
Feb 1, 20242 min read
0 comments

Data Types - Does size really matter? - nvarchar vs. varchar
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...
Aug 18, 20233 min read
1 comment


How To Identify The Grain
Creating a data warehouse can be challenging. Identifying the grain is one of the most important parts of having a quality data...
Aug 16, 20232 min read
0 comments

SQL Cluster Issues with Storage Spaces Direct - (S2D)
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...
Jul 13, 20213 min read
0 comments

Trace Flag 1117 and SQL Server 2019
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...
Apr 14, 20212 min read
0 comments

Data Types - Does size really matter? - DateTime vs. DateTime2
How many of us have just created a new table and put a Created Datetime and Modified Datetime field in with the default DateTime...
Mar 16, 20213 min read
0 comments
bottom of page