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.
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.
What tools in SQL Server will notify you about blocking and help track the queries behind your toughest blocking and deadlocking problems?
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?
You’re setting up SQL Server log shipping for disaster recovery. What else do you need to do to best prepare for a failure?
What do you do when your fellow DBA is a ticking time-bomb of bad decisions, waiting to explode your production environment?
Psssttt – I have an updated blog post on this called the Learner’s Guide to SQL Server Performance Tuning
The SQL Server is slow, what should you do? I answer a reader question and share my strategy for performance troubleshooting.
Microsoft recently updated their policies and recommendations for installing cumulative updates.