The year 2019 has been wonderful for me as I was fortunate to publish 2 SQL Server Courses on Pluralsight.
If you are into the area of the SQL Server Performance Tuning, I suggest you check out the courses. They are built for individuals who would love to get started with the SQL Server Performance Tuning. Here are the details of the courses.
Analyzing SQL Server Query Plans
Every database server runs different workloads and queries, and it’s important for a SQL Server Performance Tuning Expert to identify queries that are negatively impacting performance. In this course, Analyzing SQL Server Query Plans, you will gain the ability to identify performance bottlenecks on your database. First, you will learn to analyze query plans. Next, you will discover and understand query execution plans. Finally, you will explore how to resolve the performance bottleneck. When you are finished with this course, you will have the skills and knowledge of analyzing the query plans needed to troubleshoot SQL Server performance problems.
Topics which we cover under this course are as following:
- Course Overview
- Capture Query Plans Using Extended Events and Traces
- Identify Poorly Performing Query Plan Operators
- Create Efficient Query Plans Using Query Store
- Compare Estimated and Actual Query Plans and Related Metadata
- Configure Azure SQL Database Performance Insight
- Summary
Using Memory-optimized Tables and Native Stored Procedures
The In-Memory OLTP feature adds a new memory-optimized RDBMS engine and a native compiled stored procedure. This new edition adds higher concurrency to the SQL Server and enables it to process a much higher amount of the workload than before. In this course, we will learn about how to get started with the memory-optimized tables and build a use case around its effectiveness. Additionally, we will also understand how the efficiency of the stored procedure is increased when we use the Native Stored Procedure along with Memory-Optimized Tables.
Topics which we cover under this course are as following:
- Creating Memory-Optimized Tables
- Optimizing Performance of In-Memory Tables
- Creating Natively Compiled Stored Procedures
- Collecting Execution Statistics for Natively Compiled Stored Procedure
- Summary
If you have a Pluralsight subscription, you can watch it for free. If you do not have a Pluralsight subscription, you can still watch the course for FREE by signing up for a trial account.
Reference:Â Pinal Dave (https://blog.sqlauthority.com)
