Change Tracking (aka Syscommittab) Issues and Cleanup - Part 1

Replication in Configuration Manager is talked about pretty frequently. It’s a pretty awesome feature, but also a pain at times. One of the reasons I find it to be so cool is that it takes advantage of a SQL feature called Change Tracking. This feature is the fundamental basis for replication – and is a…

0

SQL Tip: Creating a Grand Total (and additional subtotals)

This was originally created in 2011/2012 in a series I dubbed “SQL Tips” for my team (via email and an internal blog site). I’ve decided to add these SQL Tips to my external blog. These are being posted exactly how they were written ~6 years ago…unless I found someone’s name being called out…I may have…

0

SQL Tip: Creating a PIVOT table (Part 2)

This was originally created in 2011/2012 in a series I dubbed “SQL Tips” for my team (via email and an internal blog site). I’ve decided to add these SQL Tips to my external blog. These are being posted exactly how they were written ~6 years ago…unless I found someone’s name being called out…I may have…

0

SQL Tip: Creating a Pivot table via T-SQL

This was originally created in 2011/2012 in a series I dubbed “SQL Tips” for my team (via email and an internal blog site). I’ve decided to add these SQL Tips to my external blog. These are being posted exactly how they were written ~6 years ago…unless I found someone’s name being called out…I may have…

0

SQL Tip: The DENSE and DENSE_RANK Functions

This was originally created in 2011/2012 in a series I dubbed “SQL Tips” for my team (via email and an internal blog site). I’ve decided to add these SQL Tips to my external blog. These are being posted exactly how they were written ~6 years ago…unless I found someone’s name being called out…I may have…

0

Moving the ConfigMgr site database to an Always On Availability Group

Back in 2012 I really wanted to be able to have the ConfigMgr database in an Always On Availability Group (I’ll refer to this as an “Availability Group” or an “AG” from now on). So, a coworker and I made that happen – sure, it wasn’t supported and auto-failover didn’t work but nevertheless we had…

4

SQL Tip: Creating Row Numbers

ConfigMgr Admins have asked about this before and I once wrote an internal post on this…here it is for anyone to see. Sometimes when writing a query it is helpful (or necessary) to have row numbers. In this SQL tip we’ll learn about “ROW_NUMBER”. Not surprisingly, ROW_NUMBER allows you to create a row number for…

0

SQL Tip: JOINs

Joins are an essential part to writing queries. When creating a result set from 2 or more tables the tables are joined. This tip will help describe the types of joins and why you’d use one over another. The JOIN types we will talk about are: INNER JOIN (aka JOIN) LEFT OUTER JOIN (aka LEFT…

2

Adding Summaries to ConfigMgr 2012 SSRS Reports

Technorati Tags: ConfigMgr,SCCM,System Center Configuration Manager,SSRS,Reports The ConfigMgr 2007 reports have a record count at the top of the reports. The reports in ConfigMgr 2012 do not. I'll be walking through the steps of how to add this to your 2012 reports. Additionally, if you're unfamiliar with SSRS or "Report Builder" this will be a…

3

SQL Tip: COUNTing NULL values

I've been asked about counting NULL values several times so I'm going to blog about it in hopes others will be helped by this explanation of NULL values in SQL and how to COUNT them when necessary. Note, my examples make use of a table found in the System Center Configuration Manager database. First, it’s…

16