SQL Server Archives - Page 56 of 420 - SQL Authority with Pinal Dave

SQL SERVER – Fix: Configuration Manager- Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable

March 31, 2020

Let us learn how to solve Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable.

March 28, 2020

Calculate weighted averages with matching numerator and denominator populations, decimal arithmetic, NULL rules, and calendar windows.

March 27, 2020

When my client was trying to patch the other node, it failed with an error – There are No More Endpoints Available From The Endpoint Mapper

March 26, 2020

Calculate compilations per second from cumulative SQL Server counters, compare batch rates, and investigate single-use plans with context.

March 25, 2020

Let us fix today – Msg 3254 The volume on device is empty. Followed by Msg 3013 – RESTORE DATABASE is terminating abnormally.

March 23, 2020

In this blog, I would explain the cause and fix of error: The transaction tog for database ‘SQLAuthority’ is full due to ‘REPLICATION’.

March 22, 2020

Question: What is the Difference Between sql_handle and plan_handle?
Answer: I was recently asked this question. Let us see the answer today.