This event has ended. Visit the official site or create your own event on Sched.
Back To Schedule
Tuesday, November 12 • 8:00am - 9:45am
SQL Queries - Back to the Basics
Feedback form is now closed.

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 works for Softchoice as a Data Platform Practice Lead. Focused on developing Softchoice capabilities with data services (structured and unstructured), SQL, BI, Big Data, Advanced Analytics and machine learning for Public Cloud platforms. This includes hybrid solutions that integrate... 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 Microsoft Endpoint Configuration Manager and Intune.Garth started working with Systems Management Server (SMS) back in 1996. He is an MVP for System Center... Read More →

Tuesday November 12, 2019 8:00am - 9:45am CST
  ConfigMgr, SQL
  • Skill Level Refresher