Upgrading SQL Server in a Container
I decided to update software on my laptop recently during a trip. I’m loathe to do this on most trips, as I don’t want any instability before a presentation....
2025-07-07 (first published: 2025-06-25)
351 reads
Blog Posts
Sabbatical le Troisième: A Recharge Week
It’s been a week since I flew home from London and Redgate to begin my sabbatical. Actually, at this time last week I was just about to land in...
2025-07-05
14 reads
SQL Server Careers: Still a Goldmine, or a Dead End?
When you're searching about the future of a career in MS SQL Server, you're not just looking for a pat on the back. You want to know the truth....
2025-07-05
86 reads
AI Destroying Creativity or Creative Industry
In 2025, artificial intelligence is no longer a futuristic concept—it’s a central force in the creative world. From music and film to fashion, literature, and visual arts, AI is...
2025-07-04
20 reads
DP-300 : How to Pass Azure Database Administrator Certification
As businesses increasingly migrate their databases to the cloud, the demand for skilled database administrators is skyrocketing. The DP-300: Administering Microsoft Azure SQL Solutions certification is designed for professionals...
2025-07-04
69 reads
Exploring the Next Gen General Purpose Tier in Azure SQL Managed Instance
In a recent video, I took a hands-on look at the Next Gen General Purpose service tier in Azure SQL Managed Instance—and it brings some exciting advancements to the...
2025-07-04 (first published: 2025-06-19)
236 reads
Moving to Rancher Desktop
I’ve been very happy with Docker Desktop for years, running it on both laptop and desktop. However, a corporate decision was made to move to Rancher Desktop, so I...
2025-07-04 (first published: 2025-06-16)
346 reads
Speaking Engagements 2025
It’s been a minute since I’ve gotten out to speak at events, but the second half of 2025 is going to be packed.
2025-07-03
25 reads
ADF: Publish suddenly includes everything where it used to be incremental changes since the last publish
I recently encountered an interesting issue with ADF where the publish feature suddenly attempted to republish every single object, claiming they were new, despite having incrementally published changed objects...
2025-07-02 (first published: 2025-06-15)
207 reads
PASS Summit on Tour in New York City
The PASS Summit goes on tour this year, with an August stop in New York City. This is the first event in the series, and I’m excited to go...
2025-07-02
12 reads
Blogs
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...
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...
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