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

After several discussions with the Microsoft team and chatting with Sunil Sabat about the testing I was conducting, the conclusion was...

Sorry to disappoint you. In this post, we won't test Microsoft Fabric directly. We will compare Azure Data Factory (ADF) to Microsoft...

To quickly summarize where we are, we started testing Microsoft Fabric with a 10GB tar file, which took over 20 hours to extract, and now...

Shortly after Microsoft Fabric came out a few months ago, I created an account and started playing around. I love to push technology to...

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

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

Over my years consulting, I've done quite a few performance tests for clients using DiskSpd (formally SQLIO), and I usually manually...

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