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...
top of page
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...
Jul 7, 20221 min read
Code On The Beach - 2022
Join me for some Sun, Sand and Code in Atlantic Beach, Jacksonville, Florida for this years Code on the Beach event. I am excited to have...
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 13, 20213 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...
Apr 14, 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 16, 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...
Sep 29, 20202 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...
Jul 15, 20207 min read
How to build a PowerBI Report for Octopus Deploy
I recently performed an analysis of some data I pulled from my Octopus Deploy database using PowerBI Desktop. The reports I created,...
Jun 9, 20204 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...
Feb 17, 20204 min read
What to do when your Developers claim they need 'sysadmin' access
How many times has a developer come to you and informed you he must have 'sysadmin' rights to the database server(s) to do their job? How...
Jan 7, 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...
bottom of page