Microsoft | JeffTaylor.io

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

Disable Activity is Finally Available in Azure Data Factory!

Since I first used Azure Data Factory, I looked for the 'disable' option on an activity, and it wasn't there! I quickly went to the ideas...

Have You Reviewed Your Azure Storage Bill Lately?

At the end of 2021, I started using the new SFTP preview feature on Azure Data Lake Storage Gen 2. It was a great new addition to the...

Max Degree of Parallelism - Does it Matter?

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

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

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