Tuesday, November 12 • 8:00am - 9:45am
SQL Queries - Back to the Basics
Often a ConfigMgr admin is also called upon to be a SQL or reporting expert as well. This session will show the Configmgr admin the basics of doing direct queries using SQL Server Management Studio (SSMS). Examples will be shown, and explained, regarding tables vs. views, joining data from multiple views, discussing built-in indexes (and how to find them), demonstrating subselect queries and why one would use them; as well as other basic tips and tricks for the "accidental reporting person".

What you will learn:
  • Understanding Tables vs. Views
  • Subselect Query Examples
  • Finding existing Indexed Fields, and why that is useful to know.

avatar for Steve Thompson

Steve Thompson

Microsoft MVP, Practice Lead Softchoice, Softchoice
Steve Thompson has developed numerous applications, honing his skills on SQL Server development and client/server applications. With a background in SQL Server, as DBA and advocate for SQL Server technology, Steve started working with Systems Management Server when it was a v1.1 release... Read More →
avatar for Garth Jones

Garth Jones

Microsoft MVP, Chief Architect, Enhansoft
Garth Jones is Chief Architect at Enhansoft, an Ottawa-based company that develops products and services to extend the value of System Center 2012 Configuration Manager (CM12), System Center Configuration Manager 2007 (CM07) and System Center Intune.Garth started working with Systems... Read More →

Tuesday November 12, 2019 8:00am - 9:45am
Royal Room B
  • Skill Level Refresher
Feedback form isn't open yet.

Attendees (1)