Published Books
Practical Handbook for Reporting
Recommended Content
Recommended Blogs
-
Recent Posts
- SQL Performance Tips for MEMCM – Part 2
- SQL Performance Tips for MEMCM – Part 1
- Upgrade MEMCM site Windows Server 2012 to Server 2016 – Lessons learned
- Create the Optimize Database Solution using PowerShell and dbatools
- SQL Server recommendations for Microsoft Endpoint Configuration Manager environment Whitepaper Review
Visitor Info
Archives
- March 2022
- February 2022
- August 2021
- June 2020
- December 2019
- May 2019
- March 2019
- January 2019
- December 2018
- October 2018
- August 2018
- July 2018
- May 2018
- March 2018
- January 2018
- December 2017
- September 2017
- August 2017
- June 2017
- May 2017
- March 2017
- January 2017
- December 2016
- November 2016
- October 2016
- September 2016
- August 2016
- July 2016
- May 2016
- April 2016
- March 2016
- February 2016
- January 2016
- December 2015
- October 2015
- September 2015
- August 2015
- July 2015
- May 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- September 2014
- August 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- July 2013
- June 2013
- May 2013
- April 2013
- February 2013
Recent Comments
Categories
- 2015 Dev Connections
- Active Directory
- Always ON
- Android
- Azure
- Azure SQL Server
- ConfigMgr
- DBA
- GPO
- High Availability
- Intune
- Microsoft
- Migration
- MMS
- MMS 2013
- MMS 2014
- MMS 2018
- MMS 2019
- MSI
- MVP
- OSD
- Power BI Report Server
- PowerBI
- PowerShell
- SCCM
- Server 2012
- Softchoice
- Software Center
- SQL
- SQL Server
- SQL Server 2012
- SQL Server 2014
- SQL Server 2016
- SQL Server 2019
- SQLTuesday
- SSRS
- System Center 2012 R2
- T-SQL Tuesday
- TechEd 2014
- UD-B407
- Uncategorized
- VBScript
- Windows 10
- Windows 8
- Windows Server 2012
- WSUS
About
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
6 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
19 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
T-SQL Tuesday #66: Monitoring
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
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
ConfigMgr 2012 R2 support for SQL Server 2014
ConfigMgr 2012 R2 does support SQL Server 2014, but only if it had been installed with SQL Server 2012, then upgraded to SQL Server 2014. The interesting part arises, what if you have to perform a restore of ConfigMgr 2012 … Continue reading
Posted in ConfigMgr, SQL Server 2014
Leave a comment
Steve Thompson [MVP] 