Category Archives: SQL

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

ConfigMgr 2012 – Identify Custom SSRS Reports

Working through an upgrade / migration on a client site and needed to be able to identify custom reports created within the ConfigMgr 2012 reporting structure. The following query will provide that information, change the DOMAIN below to match your … Continue reading

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

System Center 2012 Configuration Manager: A Practical Handbook for Reporting

Since I’ve had a number of people ask where they can find it, this book is now available on Amazon. Thank you for your support! http://www.amazon.com/dp/9187445174 Print only at this point, Kindle version should be available in a week or … Continue reading

Posted in ConfigMgr, SQL, SSRS | Leave a comment

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

SQL Server – List SQL Agent Jobs

Recently, I had a need to list the SQL agent jobs, owner names and whether each job was enabled or not. Here is the result: SELECT j.name AS AgentTaskName, SUSER_SNAME(j.owner_sid) AS JobOwner, CASE WHEN (j.enabled = 1) THEN ‘True’ ELSE … Continue reading

Posted in SQL, SQL Server | 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