You Need a DBA Pipeline
Steve notes that DBAs need a privileged pipeline, separate from what they might use to update database schema.
2026-09-30
274 reads
DevOps and Continuous Delivery (CI/CD)
Measuring Productivity
Today Steve wonders if the data professionals out there measure themselves on the job.
2026-09-02
133 reads
Limit the Blast Radius
AI can go off the rails, as we see in a recent story about an LLM deleting a production database.
2026-05-20
170 reads
2026-04-17
153 reads
DevOps anti-patterns: what they are and how to avoid them
In software development, DevOps promises faster delivery, increased collaboration, and more reliable deployments. However, many teams unknowingly fall into anti-patterns.
2026-04-10
Multiple Deployment Processes
Many organizations haven't standardized the way they deploy code to databases, even when they do so for applications. Steve has a few thoughts on this today.
2026-03-13
139 reads
A Full Shutdown
Steve used to shut down systems to upgrade them, but lately he makes changes while they're running.
2026-03-11
180 reads
Being Mindful of Design Time
Do you take the time to model and design your database? Steve thinks this is important, even while trying to make changes quicker to adapt to changing requirements.
2025-11-14
180 reads
DevOps is DevOps
DevOps includes a lot of practices, but no matter which technology that you use, the ideas are the same.
2025-10-27
176 reads
Requiring Technical Debt Payments
Steve found someone using an interesting approach to get developers to address some technical debt.
2025-09-08
249 reads
Blogs
Asking for Help Isn’t a Weakness
By Brian Kelley
During COVID, I attended training on software/enterprise architecture given by Mark Richards. One of...
The Proof of the Backup Is in the Pudding
For me, the objective is straightforward: have a backup strategy that is reliable, understandable,...
T-SQL Tuesday #204 – Are blogs still relevant?
By DesertDBA
Note: This post is the invitation for T-SQL Tuesday #204 on November 3rd, 2026....
Forums
The ##MS_DatabaseConnector## User
Comments posted to this topic are about the item The ##MS_DatabaseConnector## User
Planning for Change
Comments posted to this topic are about the item Planning for Change
Importing Excel files into SQL Server, Azure Edition
Comments posted to this topic are about the item Importing Excel files into SQL...
Question of the Day
The ##MS_DatabaseConnector## User
On SQL Server 2025, I run this code as a sysadmin:
CREATE LOGIN Demo WITH PASSWORD = 'Demo1234567' GO ALTER SERVER ROLE ##MS_DatabaseConnector## ADD MEMBER Demo GOI then login as Demo and run this:
USE sandbox go SELECT CURRENT_USERWhat is returned? See possible answers
