Category Archives: SQL Server 2012

Installing and configuring SQL Server for Configuration Manager

Posted on July 25, 2016 by ConfigMgrMVP

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 | 6 Comments

Configuration Manager SQL Server Backup guidelines

Posted on May 31, 2016 by ConfigMgrMVP

  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 | 19 Comments

SQL Server Database Migration Checklist

Posted on May 2, 2016 by ConfigMgrMVP

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

SQL Server 2012 – Setup account privileges

Posted on October 6, 2015 by ConfigMgrMVP

Encountered a strange issue today, installing SQL Server 2012 on Windows Server 2012 and received the following condition during the Setup Support Roles. Setup Account Privileges – Failed. That’s weird, I’m an Administrator on the server (of course :). Checked … Continue reading →

Posted in SQL Server 2012, Windows Server 2012 | 1 Comment

Practical Handbook for Configuration Manager 2012 R2 Reporting

Posted on August 27, 2015 by ConfigMgrMVP

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

Posted on August 17, 2015 by ConfigMgrMVP

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

T-SQL Tuesday #66: Monitoring

Posted on May 12, 2015 by ConfigMgrMVP

Topic today is monitoring. Catherine Wilhelmsen (b|t) is hosting this month’s T-SQL Tuesday blog party. The party was started by Adam Machanic (b|t) in December of 2009. I’ve been looking a lot of SQL Server installations over the past year. … Continue reading →

Posted in SQL, SQL Server, SQL Server 2012, SQL Server 2014, SQLTuesday | 1 Comment

Migrating databases between SQL Server instances

Posted on March 12, 2015 by ConfigMgrMVP

If you ever have a need to migrate SQL Server databases between servers; particularly a backup/restore scenario, you need to be aware that the database security login ids are not automatically migrated. Here are some notes on this task. Once … Continue reading →

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

T-SQL Tuesday #62 – Healthy SQL

Posted on January 13, 2015 by ConfigMgrMVP

 SQL Health Checks Healthy SQL is an important topic… I’ve gotten involved in a number of SQL health checks and would like to share some of the key methodology, metrics investigated and tools/utilities used. There are at least two main … Continue reading →

Posted in SQL, SQL Server, SQL Server 2012, SQLTuesday | 2 Comments

Rollback procedure for SQL Server updates

Posted on January 2, 2015 by ConfigMgrMVP

As a follow-up to the post, how to install a service pack for a SQL Server cluster, it is important to have the ability to roll back an update. Fortunately, Microsoft has made this process fairly easy. The following process … Continue reading →

Posted in SQL Server, SQL Server 2012 | 1 Comment