Administration | JeffTaylor.io

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

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

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

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

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

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

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

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

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

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