I am indeed very delighted to share my suggestion about MariaDB Learning Path. Five video courses published on the Pluralsight.
SQL SERVER – Find the Growth Size for All files in All Databases – Part 2
A few years ago, I had written a blog post Find the Growth Size for All files in All Databases. Today, we will post a small correction to it.
SQL SERVER 2019 – Supports Compatibility Level from 2008 to 2019
One thing impressed me about the latest version of SQL Server 2019 is its support to Compatibility Level from 2008 to 2019.
SQL SERVER – 5 Resources from SQLPASS 2019 – Seattle
I presented a session on Query Optimizer. In this blog post, we will see 5 important resources related to my session at SQLPASS 2019.Â
SQL SERVER – Error 17182: Unable to Initialize SSL Support. The Client and Server Cannot Communicate, Because They do Not Possess a Common Algorithm
Unable to Initialize SSL Support. The client and server cannot communicate, because they do not possess a common algorithm
How to Write INNER JOIN Which is Actually CROSS JOIN? – Interview Question of the Week #250
Question: How to Write INNER JOIN Which is Actually CROSS JOIN?
Experienced this question another day while working with a client.
Analyzing SQL Server Query Plans – Watch on Pluralsight
I have received some really great comments and feedback about this course. This entire week, I discussed various aspects of the query plans.
Configure Azure SQL Database Performance Insight – Analyzing SQL Server Query Plans – Part 5
Let us discuss different aspects of Analyzing SQL Server Query Plans. We will discuss how to configure Azure SQL Database Performance Insight.
Compare Estimated and Actual Query Plans and Related Metadata – Analyzing SQL Server Query Plans – Part 4
Let us discuss different aspects of Analyzing SQL Server Query Plans. We will discuss how to Compare Estimated and Actual Query Plans.
Create Efficient Query Plans Using Query Store – Analyzing SQL Server Query Plans – Part 3
I will be discussing different aspects of Analyzing SQL Server Query Plans. Today we will discuss how to Create Efficient Query Plans Using Query Store.