MMS Desert Edition

Description:
Have a question about SQL, T-SQL, Reporting, or SQL/Site Server HA?
Now’s your chance to ask Steve and Benjamin anything you want!

What you will learn:
That is completely up to you and the other attendees! Some possible topics (but anything is possible):

• SQL (basic or advanced)
  • Joins
  • Cross Apply
  • XQuery (xml shredding/querying in SQL)
  • JSON (JSON shredding/querying in SQL)
  • Grouping
  • Performance Tips
  • CTEs (recursive?)
• SQL Server HA (Availability Groups)
• SSRS or Power BI questions
• SQL Tips & Tricks
• Site Server HA

Description:
Have you wondered about SQL Always On Availability Groups? What is it?
How does SQL Server High Availability benefit your environment?

What considerations are involved in the design? How do you install it?
Learn how can you use this to extend ConfigMgr high availability capabilities. Tips and tricks.
What you will learn:
SQL High Availability Opions

• FCI vs Always On Availability Groups
• Design considerations
• Important capabilities
• „„MS IT - Migrating ConfigMgr SQL Server to Azure
• „Efficiently moving the CM DB to an Availability Group „
• Lessons learned
• SCCM HA