The Monthly Mentor - featuring Pinal Dave (SQL Authority)

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.

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 very important aspects of application development for businesses. Developers often come across situations where they face a slow server response, even though their hardware specifications are above par. This on-demand webcast is for all the developers and DBAs who want their server to perform at a blazing-fast speed but want to invest very little time to make it happen.

We will go over various SQL tuning tricks that require absolutely no time to master and require practically no SQL coding at all. After watching this on-demand webcast, you’ll only need 60 seconds to improve the performance of your database server. You’ll get scripts and knowledge you can immediately apply to improve server performance.