Pinal Dave - SQL Server Performance Tuning Expert

SQL SERVER 2019 – New Values in Sys.Configurations

January 8, 2020

I have written quite a few blogs about this release. In this blog, we would see the new options available in sys.configurations catalog view.

January 7, 2020

I came across very interesting technology, indeed a flagship Digital Experience Platform with Artificial Intelligence – known as Centralpoint.

January 7, 2020

I would talk about enhancement in SQL Server 2019 Configuration Manager. Let us learn how to enable lock paged in memory (LPIM).

January 6, 2020

In this blog, we would see the current setting of instant file initialization and how to make the modification. Let us learn about it today.

January 5, 2020

Question: How to Map Network Drive as Fixed Drive in SQL Server?
love little problems like this one as they are indeed a lot of fun to resolve.

January 4, 2020

I will be presenting a day-long training at SQLBits on 31 March 2020 at ExCel London on the topic SQL Server Performance Tuning Real-World Scenarios.

January 3, 2020

One of my clients migrated to SQL Azure Managed Instance and contacted me for an interesting situation. Let us resolve Restore Error.