SQLServerCentral Editorial

How can we standardize SQL Server Data Deployments?

Some change requests, such as deploying a new stored procedure or trigger, are relatively easy to manage whereas others, such as data deployments, tend to thwart all attempts at standardization. And yet, there must be a way, and Rodney Landrum believes that DBA-developer co-operation lies at the heart of it.

(2)

You rated this post out of 5. Change rating

2009-12-16

300 reads

SQLServerCentral Editorial

Had this been an actual emergency….

Rodney Landrum has lived through several simulated emergencies and one real one, in the form of Hurricane Ivan. The tests do not adequately prepare you for the real thing. Real emergencies bring tension, exhaustion and hunger pangs. Simulations bring lethargy, pre-determined end times, and warm pizza.

(1)

You rated this post out of 5. Change rating

2009-09-07

179 reads

Blogs

“We love to debate minutiae”

By

I am guilty as charged. The quote was in reference to how people argue...

Advice I Like: Knots

By

Learn how to tie a bowline knot. Practice in the dark. With one hand....

Shifting Mindsets: Why FinOps is Essential for Cloud Efficiency

By

As a DevOps practitioner, I’ve always focused on performance, scalability, and automation. But as...

Read the latest Blogs

Forums

how to write this query?

By water490

Hi everyone I asked this earlier but the desired outcome is a bit different...

Windows logins for users migrated from DomainA to DomainB

By a.koopman

Hi, I have a SQL Server instance where users connect to via Windows Authentication,...

Multiple Deployment Processes

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Multiple Deployment Processes

Visit the forum

Question of the Day

Upgrading Admin Queries

I have a query from a former DBA that we run on SQL Server 2025 to check on database metadata. This query references sys.sysaltfiles. I want to refactor this code to be more modern. Which DMV should I reference instead?  

See possible answers