Loading…
This event has ended. Visit the official site or create your own event on Sched.
Back To Schedule
Tuesday, October 26 • 1:00pm - 2:45pm
SELECT 'Intermediate Query Writing' FROM MMS_Sessions WHERE Language = 'SQL';
Tweet Share
Feedback form is now closed.
Description:
So you've got the basics down. You know how to join tables, use conditions, and group data for summaries but you want more. This is the session for you. We'll assume you know the basics and get into some intermediate to advanced stuff like variables, temp tables, common table expressions, logic flow, and tips on how to avoid common performance issues with queries.

What you will learn:
  • How to use Variables and Temp Tables
  • CTEs and recursion
  • SQL Logic flow
Speakers
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.
avatar for Benjamin Reynolds

Benjamin Reynolds

Sr. Service Engineer, Microsoft
Benjamin has been at Microsoft for over 10 years working on ConfigMgr and Intune. His expertise is on SQL Server and all things data (DBA, T-SQL, Reporting, Business Intelligence, KQL, ADF), Asset Management (Software/Hardware Inventory, Asset Intelligence, and Software Metering... Read More →

Intermediate Query Writing pdf
Presentation Demo Scripts zip
Tuesday October 26, 2021 1:00pm - 2:45pm EDT
Poinciana 1/2
  SQL

Attendees (14)