Database Training Days 101: Making SQL Server Faster with MSSQLTips

Ready to improve SQL Server performance? Get top SQL Server performance tuning tips from Microsoft MVP Denny Cherry and Oracle ACE Director Janis Griffin! In this on-demand session, we’ll explore various techniques to make your SQL Server queries run faster. Discover when to add indexes and the types of indexes that yield the best results. We’ll also dive into the different database engines available in SQL Server, including Row-Store, ColumnStore, and In-Memory OLTP, and discuss when each should be used or avoided. Finally, we’ll demonstrate how Foglight® for Databases can enhance SQL Server monitoring and performance across all your database platforms.

Topics that will be discussed include:

• Techniques for making SQL Server queries run faster
• Identifying when and what types of indexes to add
• Understanding and choosing the right SQL Server database engines: Row-Store, ColumnStore, and In-Memory OLTP
• Enhancing SQL Server monitoring and performance with Foglight® for Databases

Speakers:

• Janis Griffin, Oracle ACE Director at Quest Software
• Denny Cherry, Owner and Principal Consultant at Denny Cherry and Associates Consulting