Category Archives: SQL Server 2014

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

Installing and configuring SQL Server for Configuration Manager

This guide is intended to assist administration in properly configuring SQL Server prior to installing Configuration Manager. Too many make the mistake of miss-configuring SQL Server, then need to spend a LOT of time later, correcting it. Article Contents Installing … Continue reading

Posted in ConfigMgr, SQL Server, SQL Server 2012, SQL Server 2014 | 4 Comments

Configuration Manager SQL Server Backup guidelines

  As previously documented, using native SQL Server backup for ConfigMgr recovery has been supported since CM 2012 Sp1 and later. SQL backups are the preferred technique for backing up the ConfigMgr for a number of reasons. Here is my … Continue reading

Posted in ConfigMgr, SQL Server, SQL Server 2012, SQL Server 2014 | 11 Comments

SQL Server Database Migration Checklist

This guide is meant to provide general recommendations for migrating SQL Server databases from one server to another. Always test database migrations (and subsequent application connectivity) in a lab environment prior to the actual migration. Note: Server name ‘SOURCE’ is … Continue reading

Posted in Migration, SQL Server, SQL Server 2012, SQL Server 2014 | 3 Comments

The SQL Server 2014 Upgrade Advisor

  1.1 SQL Server Upgrade Readiness One of the best ways to proceed with SQL Server upgrades is by running the Upgrade Advisor. The SQL Server 2014 Upgrade Advisor analyzes the configuration of installed SQL Server components, and then generates … Continue reading

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

Practical Handbook for Configuration Manager 2012 R2 Reporting

This project has been in the works for a few months, very proud of this work. More details to follow.

Posted in ConfigMgr, SQL Server, SQL Server 2012, SQL Server 2014, SSRS | 10 Comments

Change SQL Server default backup compression

The default backup mode for SQL Server databases is no compression. When creating maintenance plans, you’d need to select enable database backup compression for each plan. In order to change the server default setting, use the following: — View current … Continue reading

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