Database-Administration

Tag: database-administration

Why Not Call Database DevOps Simply DevOps?

Why Not Call Database DevOps Simply DevOps?

Sometimes people are annoyed by the term ‘Database DevOps’. Why not call it simply ‘DevOps’? After all, Database DevOps follows the same core principles.

The answer is simple: implementing DevOps is tricky by itself, but most teams are set up to fail when it comes to implementing DevOps for databases. This makes it worth defining as a specialization.

Continue reading

SQL Server Management Studio Is as Relevant as Ever

SQL Server Management Studio Is as Relevant as Ever

๐Ÿ”ฅ UPDATE: Azure Data Studio (ADS) was retired on February 6, 2025, with support ending on February 28, 2026. Additionally, SSMS has been modernized and is no longer based on the legacy Visual Studio shellโ€”it's now built on Visual Studio 2022 with 64-bit support and improved performance.

For more details, see the Azure Data Studio retirement announcement and Erin Stellato's announcement about SSMS modernization..

Sometimes you keep a classic around.

Continue reading

Will the Cloud Eat My DBA Job? (Dear SQL DBA Episode 31)

Will the Cloud Eat My DBA Job? (Dear SQL DBA Episode 31)

Will cloud services render DBAs obsolete? Does the cloud mean that developers will use less of SQL Server? In this post I talkย about the future of database administration and give tips on strategizing your career.

Continue reading

Should I Upgrade to SQL Server 2016? (Dear SQL DBA Episode 22)

Should I Upgrade to SQL Server 2016? (Dear SQL DBA Episode 22)

It’s a big week for SQL Server! And it’s the perfect week to talk about this week’s question, which is about explaining to your management why it’s worth it to upgrade to SQL Server 2016, and which features you can use right away.

Continue reading

Setting up Free Blocking Alerts and Deadlock Monitoring (Dear SQL DBA Episode 17)

Setting up Free Blocking Alerts and Deadlock Monitoring (Dear SQL DBA Episode 17)

What tools in SQL Server will notify you about blocking and help track the queries behind your toughest blocking and deadlocking problems?

Continue reading

Why an Upgrade can Cause Performance Regressions (Dear SQL DBA Episode 9)

Why an Upgrade can Cause Performance Regressions (Dear SQL DBA Episode 9)

You finally got approval to move to new hardware and a fresher version of SQL Server. After months of work, ย you do the migration and then… performance gets worse. What can cause this, and what do you look for?

Continue reading

Fail Over, Fail Again, Fail Better - Preparing for Disaster Recovery (Dear SQL DBA)

Fail Over, Fail Again, Fail Better - Preparing for Disaster Recovery (Dear SQL DBA)

Youโ€™re setting up SQL Server log shipping for disaster recovery. What else do you need to do to best prepare for a failure?

Continue reading