A DevOps Workshop Tomorrow in Atlanta
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so do that if you can make it. Here’s the rough outline Vision Session – w/...
2025-05-14
9 reads
Tomorrow is the Redgate DevOps Day in Atlanta. You can still sign up, so do that if you can make it. Here’s the rough outline Vision Session – w/...
2025-05-14
9 reads
I have recently had the privilege of working with multiple clients who have been taking advantage of Change Data Capture “CDC”. Change Data Capture is a feature that utilizes...
2025-05-14 (first published: 2025-04-28)
680 reads
This is one of those blog posts you write so that 2 years later, you can look it up to remind yourself how to do something.
I found myself needing...
2025-05-14 (first published: 2025-04-28)
430 reads
It’s that time of the month again, when the T-SQL Tuesday blog party takes place. I manage this site, and am looking for hosts all the time. This month...
2025-05-13
19 reads
I’ll walk through the KDA UI and tackle the first challenge before diving into the real cases.
The UI layout
This is what your layout might look like:
LHS menu where you...
2025-05-12 (first published: 2025-04-26)
26 reads
My first time at SQL Saturday New York City was an absolute blast! Thank you so much to the organizers and the incredible people who chatted with me during...
2025-05-12
94 reads
Indexes 101: What, Why, and When? “What Is an Index?” I get this question a lot, especially from developers and sysadmins who’ve been handed a SQL Server and told,...
2025-05-12 (first published: 2025-04-23)
255 reads
Just a quick one this morning. I’m on the road and haven’t worked up a full blog post, apologies. I’ve been using the preview for SQL Server Management Studio...
2025-05-12
113 reads
lookaback– n. the chock of meeting back up with someone and learning that your mental image of them had fallen wildly out of date – having grown up or...
2025-05-09
13 reads
I do believe most people know about the ability to backup your SQL server databases to URL (from Azure VMs). If you recall you would use the storage key...
2025-05-09 (first published: 2025-04-23)
368 reads
By Chris Yates
For decades, enterprises have approached data management with the same mindset as someone stuffing...
Truncate Table Pitfalls Truncating a table can be gloriously fast—and spectacularly dangerous when used carelessly....
You can find all the session materials for the presentation “Indexing for Dummies” that...
Comments posted to this topic are about the item Technological Dinosaurs or Social Dinosaurs?
Comments posted to this topic are about the item DBCC CHECKIDENT
Comments posted to this topic are about the item Distributed Availability Group Health: T-SQL...
What is returned as a result set when I run this command without a new seed value?
See possible answers