Category Archives: SQL Server 2016

SQL Server recommendations for Microsoft Endpoint Configuration Manager environment Whitepaper Review

Posted on June 5, 2020 by ConfigMgrMVP

The team at Microsoft has done a great job in outlining many of the important SQL Server settings for MEMCM. If you have not read it, I recommend downloading, reading and implementing these settings. Update [6-2020]: Here is the latest … Continue reading →

Posted in SQL Server, SQL Server 2016, SQL Server 2019 | Leave a comment

How to apply a SQL Server update for ConfigMgr

Posted on January 22, 2018 by ConfigMgrMVP

This example is used to illustrate applying the latest SQL Cumulative Update to SQL 2016, this CM Site server happens to be running current branch 1710. This same process would be used to update SQL Server with a service pack … Continue reading →

Posted in ConfigMgr, SQL Server, SQL Server 2016 | Leave a comment

Azure Data Migration Service Review

Posted on December 22, 2017 by ConfigMgrMVP

The Data Migration Service (DMS) is a new Azure service still in preview. DMS will help you migrate existing on-premises SQL Server, Oracle, and MySQL databases to Azure SQL Database, Azure SQL Database Managed Instance or SQL Server on an … Continue reading →

Posted in Azure SQL Server, Migration, SQL Server 2016 | Leave a comment

SQL Server MAXDOP and effect on ConfigMgr

Posted on November 4, 2016 by ConfigMgrMVP

What is MAXDOP? SQL Server MAX Degree Of Parallelism (MAXDOP) configuration option controls the number of processors that are used for the execution of a query in a parallel plan. This option determines the computing and thread resources that are … Continue reading →

Posted in ConfigMgr, SQL, SQL Server 2016 | 2 Comments

SQL Server 2005 End of Life resources

Posted on October 4, 2016 by ConfigMgrMVP

Received an email today from Microsoft with some useful links and resources.   Extended support for SQL Server 2005 ended on April 12, 2016, which means you’ll no longer get security updates and hotfixes and could be at risk of … Continue reading →

Posted in SQL Server, SQL Server 2014, SQL Server 2016 | Leave a comment

Upgrade from Oracle to SQL Server – free licenses

Posted on September 12, 2016 by ConfigMgrMVP

Just learned about an attractive offer from Microsoft to migrate Oracle, DB2 and a few others to SQL Server 2016 and get free licenses. You’ll need to purchase SA (Software Assurance), however, the cost savings can be fairly substantial! SQL … Continue reading →

Posted in SQL Server, SQL Server 2016 | Leave a comment