Learn how to deploy schema changes in an always-online SQL Server environment without a maintenance window. This utility reduces blocking and improves deployment success.
The problem
I attempted to deploy a...
2025-03-19 (first published: 2025-03-07)
228 reads
We get it. There’s no budget for a DBA on staff, or even a contract support firm like Dallas DBAs. You are not alone! There are thousands of firms...
2025-03-19 (first published: 2025-03-07)
627 reads
Don’t Panic! It’s a vague but common complaint, frequently with no additional details. Before blindly restarting SQL Server, let’s walk through quick checks that don’t require deep DBA skills....
2025-03-19
283 reads
I thought I didn’t care about linting, and lately, I haven’t written a lot of SQL, but for the SQL I do write, I have SQLFluff to help me...
2025-03-18
401 reads
I had someone reach out about generate_series() recently, saying they hadn’t realized this was a new feature in SQL Server 2022. They were wondering if it was better than...
2025-03-17 (first published: 2025-03-05)
390 reads
If you're a data analyst drowning in Excel, you know the pain. Endless filtering, formula nightmares, and the dreaded "file not responding" message. Excel's great for small stuff, but...
2025-03-17
364 reads
I’ve been working with SQL Server for a very long time. Out of the box, SQL Server works great, however there is regular care and feeding that needs to...
2025-03-17
27 reads
I recently took and passed the DP-700 exam, which is required for the Microsoft Certified: Fabric Data Engineer Associate certification. It’s the second Fabric certification, and it focuses more...
2025-03-17 (first published: 2025-03-05)
1,083 reads
Here’s a way to centralize management, rotate secrets conveniently without downtime, automate synchronization and reduce secret exposure risks.Secrets management is an essential aspect of modern application development. It is vital...
2025-03-15
139 reads
I grabbed this book over the 2024 holiday season as it was on sale and recommended by the DevOps practitioners over at ITRevolution. A Radical Enterprise looks at a...
2025-03-14 (first published: 2025-02-28)
143 reads
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
By Brian Kelley
Here is another short video (~ 15 minutes). This is by the author of...
By Steve Jones
I had a briefing for the 2026 PASS Data Community Summit, which is just...
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Hello everyone, I am planning to implement a data purging solution that is expected...
Comments posted to this topic are about the item SQL Server 2025 Server-level Roles
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers