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
- Aug 16
- 2 min
How To Identify The Grain
Creating a data warehouse can be challenging. Identifying the grain is one of the most important parts of having a quality data...
- Aug 2
- 2 min
Disable Activity is Finally Available in Azure Data Factory!
Since I first used Azure Data Factory, I looked for the 'disable' option on an activity, and it wasn't there! I quickly went to the ideas...
- Jan 30
- 2 min
SQL Saturday Jax 2023 Updates
We have a date and are planning SQL Saturday Jacksonville's 15th Anniversary event! Since my recent but late post on how we ran SQL...
- Nov 27, 2022
- 12 min
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 18, 2021
- 1 min
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, 2021
- 3 min
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...
- Jul 13, 2021
- 3 min
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, 2021
- 2 min
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...
- Sep 29, 2020
- 2 min
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, 2020
- 7 min
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 3, 2020
- 1 min
How To Configure PowerBI Template for Octopus Deploy Cloud Reporting
Click here to download the SQL Server PowerBI Template - OctopusDeployCloud.pbt (https://bit.ly/2ZAKLUr) Once you have downloaded the...
- Jun 3, 2020
- 1 min
How To Configure PowerBI Template for Octopus Deploy Local Instance Reporting
Click here to download the SQL Server PowerBI Template - OctopusDeploySQLServer.pbt (https://bit.ly/2C9iuvf) Once you have downloaded the...
- May 20, 2020
- 2 min
How to Connect To Your Octopus Deploy Cloud API
To start setting up your Octopus Deploy API connection you will need an API Key. First, you need to connect to your Octopus Deploy cloud...
- May 13, 2020
- 1 min
How to Install PowerBI Desktop
To download your copy of PowerBI Desktop, go here and download the latest version here https://www.microsoft.com/en-us/download/details.a...
- Jan 7, 2020
- 2 min
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