Upgrading SQL Server– Intel Xeon-W Family
On August 30, 2017, Intel released their new Intel Xeon Processor W Family of one-socket workstation processors (hence the W) based on the Skylake-SP Xeon
Menu
On August 30, 2017, Intel released their new Intel Xeon Processor W Family of one-socket workstation processors (hence the W) based on the Skylake-SP Xeon
Another useful, if somewhat complicated, free tool from Microsoft is the Database Experimentation Assistant (DEA). Microsoft released DEA version 2.1 on July 25, 2017, with
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
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.