Benjamin's blog

SQL & Inventory tips, tricks, and random thoughts (generally geared toward the Configuration Manager Admin)

Browse by Tags

Related Posts
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...