top of page


How To Call Microsoft Graph API From SQL Server
Calling APIs directly from SQL Server has been available in Azure SQL DB since 2022, but now it's available in on-prem in SQL Server 2025...
Jul 22 min read
Â
Â
Â


How To Call APIs From SQL Server
Calling an API has been in Azure SQL since 2022, but it was only recently added to SQL Server 2025 Preview. This new feature...
Jul 14 min read
Â
Â
Â


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


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


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...
Aug 18, 20233 min read
Â
Â
Â


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


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...
Aug 2, 20232 min read
Â
Â
Â


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...
Jan 30, 20232 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
Â
Â
Â


SpeedPass
A new way to create the SpeedPass for SQL Saturday Events.
Jul 25, 20225 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
Â
Â
Â


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 20, 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...
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
Â
Â
Â


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


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,...
Jul 15, 20207 min read
Â
Â
Â


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, 20201 min read
Â
Â
Â


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...
Jun 3, 20201 min read
Â
Â
Â
bottom of page