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 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: 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...