Upgrading SQL Server– Microsoft Data Migration Assistant 3.2
One useful tool that you should definitely take advantage of during an upgrade and migration effort is the Microsoft Data Migration Assistant (DMA), which replaces
One useful tool that you should definitely take advantage of during an upgrade and migration effort is the Microsoft Data Migration Assistant (DMA), which replaces
One somewhat obscure issue you might encounter when upgrading from a legacy version of SQL Server to SQL Server 2016 or later is a change
Even though much of the development effort and resources in SQL Server 2017 has been used to get SQL Server running as a first-class citizen
On July 11, 2017, Intel formally released their new Xeon Scalable Processor Family of processors for data center usage. This new processor family has a
If you are planning a complete data platform upgrade, you should be planning on using Windows Server 2016 as your operating system (assuming you are
One valid argument for considering a SQL Server upgrade sooner rather than later is the fact that the version(s) of SQL Server you are using
One important factor to contemplate during an upgrade and migration effort are your database compatibility levels, which control certain database behaviors to be compatible with
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
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.