Previously, we talked about the single-threaded performance, CPU capacity and hardware cost difference between an extremely poor server model and processor SKU choice and a
One unfortunately common scenario is a situation where someone made a very poor processor choice sometime in the past for a database server that runs
Over the course of my career, I can’t remember too many people coming to me and initiating the conversation about upgrading to a new version
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
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.