Work through twenty practice queries on one small sales schema, with expected results for filters, joins, totals, windows, and gaps.
SQL SERVER – Fix: Configuration Manager- Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable
Let us learn how to solve Configuration Manager – Cannot Connect to WMI Provider. You Do Not Have Permission or The Server is Unreachable.
Weighted Averages in T-SQL
Calculate weighted averages with matching numerator and denominator populations, decimal arithmetic, NULL rules, and calendar windows.
SQL SERVER – Upgrade Failure – There are No More Endpoints Available From the Endpoint Mapper
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
Batch Requests and Compilations per Second From T-SQL
Calculate compilations per second from cumulative SQL Server counters, compare batch rates, and investigate single-use plans with context.
SQL SERVER – Msg 3254 – The Volume on Device Path\File is Empty. RESTORE DATABASE is Terminating Abnormally
Let us fix today – Msg 3254 The volume on device
SQL SERVER – Error 9002: The Transaction Log for Database ‘SQLAuthority’ is Full Due to ‘REPLICATION’
In this blog, I would explain the cause and fix of error: The transaction tog for database ‘SQLAuthority’ is full due to ‘REPLICATION’.