The Monthly Mentor - featuring Pinal Dave (SQL Authority)

Are you struggling with new open-source database platforms? Are you feeling pressure to work faster than ever as a result of DevOps? Pinal Dave has you covered in part two of his webcast series. In his signature conversational style that makes his webcasts feel as if you’re chatting with your favorite colleague, leading database expert Pinal Dave will discuss these issues and more. 

Pinal will cover the biggest pain points affecting DBAs who are dealing with open source and DevOps and offer invaluable guidance to help you overcome major obstacles with confidence. 

You’ll learn why you don’t need to be intimidated by open-source platforms, your heterogeneous database environment or even your ever-increasing workload.

SQL Server running slow? That can affect everyone in your organization. But as the DBA, it’s on you to take ownership, start SQL Server troubleshooting and resolve the performance bottlenecks. We all know it’s best to be proactive. Using preventative measures will help you avoid SQL Server running slow. But most of the time, we reactively respond to issues. 

In this open panel discussion, we talked with SQL Server performance tuning expert Pinal Dave about best practices to keep your database running at optimal speed. We also discussed his business secrets to run faster databases. 

Data and databases are critical components of application development for businesses. Yet, developers often encounter slow server responses, even with above-par hardware specifications. This on-demand webcast is designed for developers and DBAs who want their server to perform at blazing-fast speeds without investing a significant amount of time. Learn various SQL tuning tricks that require little to no time to master and practically no SQL coding. After watching this webcast, you’ll be able to improve your database server's performance in just 60 seconds with the scripts and knowledge provided.

Topics that will be discussed include:

• Quick SQL tuning tricks that require minimal time and effort
• Performance improvement techniques without extensive SQL coding
• Practical scripts to immediately enhance server performance
• Strategies for developers and DBAs to achieve fast server responses

Speakers:

• Pinal Dave, SQL Server Performance Tuning Expert and Independent Consultant
• Pini Dibask, Product Manager for Database Performance Monitoring

Every new release of SQL Server brings a load of new features you can add to your database management arsenal to increase efficiency. SQL Server 2019 has introduced many new features and Pinal Dave of SQL Authority will show you how to maximize them in this special session. 

Here’s a glimpse of the SQL Server features Pinal will cover:

• Adaptive query plans 
• Batch mode adaptive join
• New cardinality estimates for optimal performance 
• Adaptive query processing 
• Indexing improvements 
• Introduction to automatic tuning 
• Batch mode for rowstore storage 
• Accelerated database recovery 

This on demand session will provide invaluable guidance to help any DBA or developer who wants to get a jump start on SQL Server 2019 and its new features.