Terraform Commands
I realized I never created a post to show how to deploy Terraform from VS Code. I haven’t done that in a while because I don’t do it at...
2025-08-13
96 reads
T-SQL Tuesday #189–AI and your Career
I’m late to the party this month. Taiob Ali has a great invite for a topic that is likely on most people’s minds: AI and your career. I constantly...
2025-08-13
60 reads
TSQL Tuesday #189: How is AI changing our careers
This month’s TSQL Tuesday invite is from my good friend, long standing MVP and community volunteer Taiob Ali – Taiob’s call is to blog on how AI, (the biggest...
2025-08-13
37 reads
Using SQL Compare to Revert a Stored Procedure
Imagine this situation, someone edits a stored procedure on a production server to “fix” something. However, they broke the procedure and you find out the next day. How do...
2025-08-13
144 reads
DBCC CHECKDB: Just Because It’s Quiet Doesn’t Mean It’s Safe
Corruption isn’t a “maybe someday” problem – what you need to do now. Stop. Don’t panic. You just ran DBCC CHECKDB for the first time in a while (or...
2025-08-13
34 reads
SQL Server 2025 Backups - New ZSTD Compression
Compression was introduced in SQL Server version 2008. While it helped, the compression ratios were frequently too low to justify the...
2025-08-13
27 reads
PASS Data Community Summit LinkedIn Contest
If you're not having success in convincing your organization to send you to this year's PASS Data Community Summit, you could win a 3-day registration by submitting some basic...
2025-08-29 (first published: 2025-08-12)
151 reads
Boost SQL Server Security with gMSA: Real-World Examples & PowerShell Scripts
When deploying SQL Server in enterprise environments, choosing the right service account model is critical for security, manageability, and scalability. Traditionally, DBAs have relied on standard domain accounts with static passwords,...
2025-08-12
71 reads
Andreas Wolter on Evading Data Access Auditing
There are always bad actors who will seek to get access to and, likely, exfiltrate (exfil) the data. But they don't want to get caught; they don't want to...
2025-08-11
41 reads
Adding a Named Default Constraint to a Table: #SQLNewBlogger
As part of a demo recently I was adding a default value to a new column with a simple DEFAULT and a value. Under the covers this creates a...
2025-09-03 (first published: 2025-08-11)
485 reads
Blogs
The Book of Redgate:A Prehistory
By Steve Jones
I’ve covered the values in a number of previous posts on the Book of...
Evidence-bound: what AgentDBA will and won’t link
By Arun Sirpal
When the evidence names the database, it says so. When it doesn’t, it stops....
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Forums
SQL Server 2025 section missing?
Hello, the title says it all. Is the SQL Server 2025 section missing?
A design question in a parent child relationship
I am not sure which is the best way to proceed. I have parent...
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers