Upgrading SQL Server–Mitigating Performance Regressions
As I discussed yesterday, it is sometimes possible to experience performance regressions after upgrading to a new version of SQL Server, even when it is
Menu
As I discussed yesterday, it is sometimes possible to experience performance regressions after upgrading to a new version of SQL Server, even when it is
One fairly common issue you might encounter when upgrading to SQL Server 2014 or later are performance regressions with some queries. SQL Server 2014 introduced
One of the interesting new features that was added in SQL Server 2014 was delayed durability. This feature lets you trade some transaction durability for
One upgrade opportunity that you can take advantage of pretty easily, whether or not you are actually upgrading your actual database servers, is to use
Another relatively quick and easy way to do a Production migration of data from one place to another or from an older version of SQL
One easy and quick way to do a Production migration of data from one place to another or from an older version of SQL Server
Yesterday I talked about the critical importance of thoughtful processor selection for SQL Server as part of the upgrade and migration process, and I supplied
One crucial part of doing a complete data platform upgrade is proper hardware and processor selection. Because of how SQL Server 2012 and newer core-based
Part of the upgrade and migration process is keeping your existing SQL Server instances properly patched. Being on a minimum Service Pack level is often
Back in December of 2012, I wrote a fairly long article called Making the Case for a SQL Server Platform Refresh that made the argument
This month, there are more minor updates to the all of the versions of the queries, primarily in the comments and documentation. I often make
When it comes down to actually migrating from a legacy version of SQL Server to SQL Server 2016/2017, there are several different methods for performing
With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.