Loading…
This event has ended. Visit the official site or create your own event on Sched.
Back To Schedule
Monday, May 6 • 8:00am - 9:45am
SQL Queries: Back to the Basics

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Tweet Share
Feedback form is now closed.
Description:
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 Example
  • Finding existing Indexed Fields, and why that is useful to know.
Speakers
avatar for Matthew Hudson

Matthew Hudson

Desktop Engineering Manager, Schlumberger
Matthew is a Microsoft MVP in Enterprise Mobility, working in the Energy Sector. He has over 120,000 machines within his responsibility. Microsoft Configuration Manager, Windows OS, MacOS, packaging applications, Intune, Jamf, Azure VD, and Windows 365 all fall under my team. I have... Read More →
avatar for Sherry Kissinger

Sherry Kissinger

Cardinal Health
For ConfigMgr, talk to me about large hierarchies, inventory customizations, compliance settings, and reporting for the SQL and SRS-challenged.

SQLBasics zip
SQL Back to the Basics pptx
Monday May 6, 2019 8:00am - 9:45am CDT
MTKA A
  SQL, SQL
  • Skill Level Refresher

Attendees (50)