Social: Growing Up with the Dukes of Hazzard
I grew up in the South. The capital of the Confederacy was a short drive from my house. We studied the Civil War. I watched the Dukes on TV,...
2020-06-19
14 reads
Blog Posts
Use Chocolatey to Install Multiple SQL Server 2019 Instances for Testing
I’m working on a project where it’s useful to automate environment setup and teardown for testing some devops deployment scenarios for databases using transactional replication. To make this easier,...
2020-06-19 (first published: 2020-06-05)
853 reads
Adding people’s names to a blog post can be rather tedious.
I blog a fair amount and do you want to know what the most annoying part of the process is? ... Continue reading
2020-06-18
22 reads
Combining DMVs, Query Store and Extended Events Is Challenging
I was recently asked a question on a forum by a person who was frustrated with all the tool choices we have for measuring performance. Moreover, they were frustrated...
2020-06-18
12 reads
Daily Coping 18 Jun 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-06-18
7 reads
Data Visualization, Context, and Domain Expertise
I recently posted a graph to twitter and asked people to explain it. Let’s look at the graph. The graph is from Fitbit. It shows the number of steps...
2020-06-18 (first published: 2020-06-04)
424 reads
My Experience Switching To A Macbook Pro From Windows
My background
My background has been very strongly focused on the .NET world, with a focused start on SQL Server, later branching into learning PowerShell.
This world was heavily focused on...
2020-06-18
12 reads
Podcast recording with Dallas DBAs
I’m thrilled to have recently recorded a podcast with Kevin3NF of Dallas DBAs called Data Bits. I had an absolute blast with it, and we laughed for over an...
2020-06-18
8 reads
Power BI Data Viz Makeover: From Drab to Fab
On July 11 at 3pm MDT, Rob Farley and I will be hosting a webinar on report design in Power BI. We will take a report that does not...
2020-06-18
14 reads
Secure Your Data Prep Area
I’ve been building ETL processes for many years, and I’ve learned two universal truths: data preparation is messy, and you must always secure your data prep area. A data...
2020-06-18
7 reads
Blogs
ISACA AI Material/Exam Prep Discount (May 18 – June 30, 2026)
By Brian Kelley
If you are considering any of the ISACA AI certs like the Advanced Artificial...
A Fabric solution can be very cost effective
By ChrisJenkins
Are you currently using Microsoft Fabric or considering migrating to it? If so, there...
Track SQL Server Configuration Changes Using the Error Log
By SQLPals
Track SQL Server Configuration Changes Using the Error Log If you...
Forums
Before Using AI with Business Data, Read This
Artificial intelligence tools are quickly becoming part of daily business operations, from document analysis...
Designing SQL Server ETL Pipelines That Don't Break at Scale
Comments posted to this topic are about the item Designing SQL Server ETL Pipelines...
Detecting Deadlocks Quickly
Comments posted to this topic are about the item Detecting Deadlocks Quickly
Question of the Day
Detecting Deadlocks Quickly
In the Database Engine, when a deadlock is detected, what does the detection interval shrink to (in time)?
See possible answers