Category Archives: SQL

Installing Power BI Report Server

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

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

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