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