Why Not Just Use VARCHAR(MAX)?
A while ago I was looking into some odd errors that were cropping up in an application, when I spotted that all the columns in a table were defined...
2025-06-30
55 reads
Blog Posts
A Six Week Break
Today is my last day of work for six weeks. I start my sabbatical Monday, or maybe this afternoon, and will be gone. I may or may not blog,...
2025-06-27
63 reads
Advice I Like: Focus on what’s important
Don’t let someone else’s urgency becomes your emergency. In fact, don’t be governed by the urgent of any sort. Focus on the important. The urgent is a tyrant. –...
2025-06-27 (first published: 2025-06-13)
449 reads
Build a Snapshot Backup Catalog in Pure Storage with SQL Server 2025’s Native REST API
I’m really excited to share some new functionality in SQL Server 2025 combined with some innovations in FlashArray’s REST API.
In this post, I’m going to show you how to...
2025-06-27
112 reads
Speaking at the 2025 PASS Data Community Summit
I will be back in Seattle this year attending the 2025 PASS Data Community Summit. This will mark my fourth year attending the Summit (I also attended one year...
2025-06-27
45 reads
Starting Points for Quantum Computing Learning
I didn't have these in my slides for the Techno Security & Digital Forensics Conference, but brought them up the web browser during the presentation. If you're looking at...
2025-06-27 (first published: 2025-06-09)
372 reads
The Book of Redgate: Motivation
Another of our values is this: Motivation isn’t about carrots and sticks. Constant oversight and the threat of punishment are incompatible with great, fulfilling work. We believe in creating...
2025-06-27
70 reads
Using a GenAI to Help Brent
Brent had a query exercise recently about train stations moving in some order and having overrides to this order in emergencies. I suppose he’s been traveling a lot lately...
2025-06-27
22 reads
2 Tips to a Working Schedule
When I watched the following video from Justin Sung, I realized that I am often guilty of the two problems he cites with regards to making my schedule work...
2025-06-26
27 reads
Monitoring SQL Server Performance with the Pure Storage FlashArray OpenMetrics Exporter
I’m excited to share a new open-source project I’ve been working on that combines two of my favorite areas: SQL Server and Pure Storage FlashArray performance monitoring. If you’ve...
2025-06-26
34 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
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