A New Word: Midding
midding – n. the tranquil pleasure of being near a gathering but not quite in it – hovering on the perimeter of a campfire, talking quietly outside a party,...
2024-08-23
65 reads
The Voice of the DBA
Back to Syracuse for SQL Saturday
Syracuse is having their first SQL Saturday on Sept 7, 2024. I’ll be there and hope to see you there as well. If you’re anywhere close, come on over...
2024-08-22
30 reads
Creating a Test Pipeline in Azure DevOps using a Windows Agent
A customer was having some trouble getting started with Azure DevOps (AzDO) and building their database, so we took a step back and decided to create a simple test...
2024-09-06 (first published: 2024-08-21)
536 reads
Monday Monitor Tips: Changing the Fragmentation Alert
I had a customer that was concerned about the fragmentation alert for indexes and wanted to know how to change it. This post discusses the change. This is part...
2024-08-19
31 reads
SQL Saturday Denver 2024 Resources
Here are the resources from my talks today. Best Practices for Seamless Database Deployments PPTX slides Architecting Zero Downtime Deployments git repo: https://github.com/way0utwest/ZeroDowntime PPTX slides Some good questions today,...
2024-08-18 (first published: 2024-08-17)
47 reads
A New Word: Povism
povism – n. the frustration of being stuck inside your own head, unable to see your face or read your body language in context, only ever guessing how you...
2024-08-16
25 reads
Speaking at SQL Saturday Denver 2024
It’s just a couple of days away from SQL Saturday Denver 2024. This Saturday, come join me at the Lowry Convention Center in Aurora for some great talks. We...
2024-08-14
13 reads
Expanding Northwind with Prompt+
I was trying to do a little testing of our subsetter and needed a larger database. So I decided to ask Prompt + to help me with a little...
2024-09-02 (first published: 2024-08-14)
205 reads
T-SQL Tuesday #177–Keeping track of database code
This month’s invitation is from Mala Mahadevan, who has hosted 5 times. This latest one is one that is near and dear to my heart as I use source...
2024-08-13
13 reads
Grouping by Object Type in SQL Compare
A customer recently was asking about grouping objects by type to see all the differences in two databases for one set of objects, like all stored procedures. This post...
2024-08-21 (first published: 2024-08-12)
212 reads
Blogs
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
The FinOps Lifecycle: From Budgeting to Reporting
By HeyMo0sh
Working in DevOps long enough teaches you two universal truths: That’s exactly why I...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers