Empower enterprise stakeholders to use data assets strategically for data operations, data protection and data governance
Achieve identity-centric cybersecurity to protect the people, applications and data that are essential to business
Conquer your next migration (now and in the future) by making it a non-event for end users
Discover, manage and secure evolving hybrid workforce environments
Detect, defend against and recover from cyber attacks and insider threats
Prevent recovery downtime and ballooning storage costs.
Learn from Brent Ozar, Janis Griffin, Pinal Dave and Steph Locke and Boost your database management skills.
Our top tech experts are back again – and they want you to join them for five new, interactive sessions. Boost your SQL Server skills with free training from Microsoft Certified Master Brent Ozar, Oracle ACE Janis Griffin, Performance Tuning Expert Pinal Dave and Microsoft MVP Steph Locke.
You’ll see how to overcome your biggest tech challenges and have a lot of fun along the way.
Learn how to:
Check the boxes to save spots for all the sessions that interest you.
Your users are complaining that SQL Server is slow, but you can't fix the code or the database, and the company isn't throwing hardware at the problem yet. What can you do? Use specific configuration changes to reduce the hardware required to run queries.We'll discuss blocking and other scenarios where SQL Server's configuration switches make all the difference. Code and indexes may still need work, but you'll have a few options to help in the meantime.
SQL Server 2019 has been available for a while, but we’ve noticed many people don’t use it to its full potential. In this fast-paced, demo-oriented session, we’ll go over the new features that maximize SQL Server performance. We’ll also discuss what to do if you’ve recently upgraded SQL Server and your performance is missing the mark.
The SQL Server Query Optimizer creates an execution plan for every statement running in the database. But sometimes it chooses a bad query plan, slowing the query and eating resources, so other processing can’t get done. Learn how to read and fine-tune query plans for better performance. We’ll go over the types of execution plans and when to use them. We’ll also examine the different operators, their statistics and costs; then determine steps to focus on tuning. As an added bonus, you’ll also learn several troubleshooting techniques.
See the tools and capabilities that’ll make you an even more effective database developer. We’ll cover database projects, unit testing and Continuous Integration and Continuous Deployment. You’ll learn about data collaboration tools from erwin® by Quest® and coding tools like Github Copilot (AI code writing). You’ll find at least one solution that’ll help you get more done with your time.
See how to use native tools in SQL Server and scripts based on Dynamic Management Views to quickly identify and resolve SQL Server performance bottlenecks.