Category Archives: SQL

Giving Back – T-SQL Tuesday

Posted on May 8, 2018 by ConfigMgrMVP

This month’s topic is giving back to the community, or if you routinely give back, how did you get started? For background information. I’ve been fortunate in many ways to be acknowledged as an MVP, now for about 23 consecutive … Continue reading →

Posted in MVP, SQL, T-SQL Tuesday | Leave a comment

Installing Power BI Report Server

Posted on August 16, 2017 by ConfigMgrMVP

Thought I’d post my initial impressions of installing Power BI Report Server. Unless you’ve been disconnected from the web for any length of time, you’ve heard of Power BI. In May 2017, Microsoft released the Power BI Premium service tier, … Continue reading →

Posted in Power BI Report Server, PowerBI, SQL, SQL Server | Leave a comment

Properly configure SQL Server ConfigMgr database

Posted on June 21, 2017 by ConfigMgrMVP

Ideally, this will take place before you install ConfigMgr! First, estimate size(s) of the databases: SCCM SUSDB TempDB – see prior article for more detail How? Use the  SCCM DB Sizing estimator! Shown is an example of the Database sizing … Continue reading →

Posted in ConfigMgr, SQL, SQL Server | 18 Comments

SQL Server MAXDOP and effect on ConfigMgr

Posted on November 4, 2016 by ConfigMgrMVP

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

ConfigMgr 2012 – Identify Custom SSRS Reports

Posted on October 7, 2015 by ConfigMgrMVP

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

Posted on September 18, 2015 by ConfigMgrMVP

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

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

SQL Server – List SQL Agent Jobs

Posted on May 14, 2015 by ConfigMgrMVP

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

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