The Book of Redgate: Do Your Best Work
One of our mission statements in the Book of Redgate says: attempt to do the best work of your life. I’d like to think that at most points in...
2025-05-16
82 reads
Blog Posts
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
17 reads
How To Restore Change Data Capture – CDC Tables When Restoring a SQL Server Database
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)
689 reads
Testing for End of Month in PowerShell
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)
439 reads
T-SQL Tuesday #186–Agent Jobs
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
25 reads
KDA: Echoes of Deception - Onboarding
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)
38 reads
SQL Saturday NYC Recap 2025
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
188 reads
SQL Server Index Primer
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)
265 reads
SSMS 21
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
208 reads
A New Word: Lookaback
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
20 reads
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers