Testing Microsoft Fabric - Part 4
After several discussions with the Microsoft team and chatting with Sunil Sabat about the testing I was conducting, the conclusion was...
top of page
Nov 30, 20232 min read
Testing Microsoft Fabric - Part 3
Sorry to disappoint you. In this post, we won't test Microsoft Fabric directly. We will compare Azure Data Factory (ADF) to Microsoft...
Nov 24, 20232 min read
Testing Microsoft Fabric - Part 2
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...
Nov 14, 20232 min read
Testing Microsoft Fabric - Part 1
Shortly after Microsoft Fabric came out a few months ago, I created an account and started playing around. I love to push technology to...
Aug 18, 20233 min read
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...
Feb 27, 20232 min read
Parquet, CSV, or SQL Server with PowerBI
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...
Nov 18, 20211 min read
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...
Jul 20, 20213 min read
Compile and Present DiskSpd Results Using PowerShell and PowerBI
Over my years consulting, I've done quite a few performance tests for clients using DiskSpd (formally SQLIO), and I usually manually...
Apr 13, 20212 min read
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...
Mar 15, 20213 min read
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...
bottom of page