SQL Server Live Health Check
Troubleshoot SQL Server Health using Live Health Check Query or SQLMonitor
Posted inDatabase Administration
SQL Server Lab 01 – MultiSubnet Availability Group with FCI
As a SQL Server DBA, it is very important to learn concepts by doing or implementing. Following this rule, I often create a SQL Server Lab setup for myself and…
Posted inBaseline-SQL-Server Errors SQL Alerts
Find TempDb Space Consumers in SQL Server
Troubleshoot SQL Server tempdb database space issue and find out what sessions are consuming tempdb space.
Posted inLinux
SQL Server on Linux Mint
Why Linux? To start with, I think everyone agrees that Linux is core skills, and no doubt every IT professional should be familiar with it. Almost all enterprise software solutions…
Posted inHealth Check TSQL
SQL SERVER – Blocking Tree – Identifying Blocking Chain Using sp_WhoIsActive
As a DBA, I often receive user requests to check server slowness. Quite often, slowness is directly linked with active blocking on the server. I find many scripts on internet…
Posted inPowershell
Error/Fix: PackageManagement\Install-PackageProvider : No match was found for the specified search criteria for the provider ‘NuGet’
Yesterday I was trying to install dbatools powershell module in one virtual machine that I created for online SQL Class. [crayon-6934739f38148393544137/] Resolution:- In order to solve this issue permanently, I…