Category Archives: SQL Server 2016

SQL Server MAXDOP and effect on ConfigMgr

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 | 1 Comment

SQL Server 2005 End of Life resources

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

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