Prepping for Certification, Part 3 of ?
After I have understood the details for a certification test (part 1), including format and the rules for taking it and after I have taken time to learn how...
2025-12-01
16 reads
Blog Posts
Reverse Engineering a Physical Model Diagram
I recently wrote about a logical diagram with Redgate Data Modeler. That was interesting, but creating all the objects is a pain. I decided to try creating a physical...
2025-12-01
49 reads
Advice I Like: Failure
If it fails where you thought it would fail that is not a failure. – from Excellent Advice for Living This is a great quote, especially for those of...
2025-11-28 (first published: 2025-11-14)
430 reads
SQL Training Black Friday Deals
If you're looking for particular "Black Friday" deals, here is what I've seen advertised in the community. I have not taken any of these classes, so I can't give...
2025-11-28
38 reads
Why Databases Still Fascinate Me
I get asked a lot about why or how I began working with databases years ago. I did not wake up one day and decide, “I am going to...
2025-11-28 (first published: 2025-11-10)
415 reads
Happy Thanksgiving! (USA Holiday)
In the United States, today is Thanksgiving. The intent behind the holiday is to remember all that we have to be thankful. I have a lengthy list from friends...
2025-11-27
19 reads
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be downloaded. Well, it cannot be downloaded from the user interface, that is. Suppose you have...
2025-11-26 (first published: 2025-11-06)
351 reads
Microsoft Post-Quantum Crypto APIs Are Now Generally Available
I mentioned this in my talk on Quantum Computing at the PASS Data Community Summit: Microsoft has announced that the post-quantum cryptography APIs are now generally available.
2025-11-26
160 reads
Query Intelligence in SQL Server 2025: What Developers Need to Know
When Microsoft announced SQL Server 2025, I was curious about what would truly change the way developers and DBA’s interact with data. Over the years, we have seen incremental...
2025-11-26 (first published: 2025-11-05)
699 reads
The PASS Data Community Summit 2025 Recap
It’s Monday. I’ve been home since Fri night, but with a busy weekend, I’m still recovering from the PASS Data Community Summit. There’s a nice wrap from the crew,...
2025-11-26
11 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