top of page


How To Test SQL Server Disk IO Throughput
When managing large databases or high-transactional databases, the performance of your underlying storage system is crucial, whether it...
Jun 173 min read
Â
Â
Â


Are Your Disks Lagging?
Recently, one of my clients was experiencing performance issues with their SQL Server. Although the server was not underpowered from a...
Jun 165 min read
Â
Â
Â


New Azure VMs that perform close to on-prem servers?!
Working with large databases, multi-terabyte in size, I've had clients who have wanted to move to the cloud. However, after testing and...
Jun 122 min read
Â
Â
Â


Getting Started with SQL Server 2025 Public Preview: A Step-by-Step Installation Guide
A step-by-step guide to installing SQL Server 2025 Private Preview.
Jun 44 min read
Â
Â
Â


Uninstall PolyBase from SQL Server
If you have SQL Server 2019 or SQL Server 2022 installed with PolyBase and you try to install SQL Server 2025, it will fail during...
May 241 min read
Â
Â
Â


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


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...
Jun 16, 20232 min read
Â
Â
Â


Octopus Insiders - DevOp's Champions
I am excited and honored to have been asked to be an Octopus Insider for Octopus Deploy. This is a new program for those passionate about...
Nov 30, 20221 min read
Â
Â
Â


How We Ran SQL Saturday Jacksonville In 2022
2022 is the first year post PASS and the SQLSaturday.com website containing the tools created by PASS for SQL Saturdays. So, I wanted to...
Nov 27, 202212 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...
Nov 18, 20211 min read
Â
Â
Â


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


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


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


How To Restore TDE Keys and Database to a New or Different SQL Server
In this article, we will cover the specific steps to restore a set of TDE keys and a database to a new and or different server. This...
Sep 29, 20202 min read
Â
Â
Â


Where Are Your Tables And Indexes Stored?
Recently, I started receiving multiple database filegroup growth alerts from my Idera SQL Diagnostic Manager. As this wasn't usual, I...
Jun 9, 20204 min read
Â
Â
Â


Azure Data Studio - Import Wizard Fix - My Small Contribution
One of the features in Azure Data Studio is called the 'Import Wizard'. This feature allows you to quickly import a file and specify your...
Mar 23, 20202 min read
Â
Â
Â


SQL Cluster Disk Witness Errors
We recently upgraded our Production SQL Server Cluster. We started with the passive node and removed the old operating system, which was...
Jan 14, 20202 min read
Â
Â
Â


How To Move SQL Server Data Files
There always seems to be a need to move database files, whether it's a new system I'm setting up or an existing system that needs...
Jan 7, 20202 min read
Â
Â
Â
bottom of page