Tuesday, November 12 • 8:00am - 9:45am
SQL Queries - Back to the Basics

Log in to save this to your schedule and see who's attending!

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 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 B
  • Skill Level Refresher
Feedback form isn't open yet.

Attendees (43)