Upgrades

Tag: upgrades

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

Bleeding In Edgeville - When Upgrades Come Too Fast (Dear SQL DBA)

Bleeding In Edgeville - When Upgrades Come Too Fast (Dear SQL DBA)

In this episode of “Dear SQL DBA,” I answer a question about early adoption of SQL Server, discuss why testing in production isn’t necessarily crazy, and recommend how to handle requests to upgrade your SQL Server to use new features.

Continue reading

Required Testing for Installing SQL Server Cumulative Updates and Service Packs

Required Testing for Installing SQL Server Cumulative Updates and Service Packs

Microsoft recently updated theirย policies and recommendations for installing cumulative updates.

Continue reading