Posted inBaseline-SQL-Server Errors SQL Alerts TSQL
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…
How to Baseline Microsoft SQL Server with Open Source Tools
Are you tired of not knowing what is usual workload of your server? Do you…
Posted inBaseline-SQL-Server TSQL
Time conversion from local to UTC and vice-versa
Recently I have been working on setting up baselining for my SQL Server lab environment.…
![Waits Stats Duration in [dd hh:mm:ss]](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2020/08/Blog_WaitStats_01.png?fit=1002%2C648&ssl=1)
Posted inBaseline-SQL-Server TSQL
Get Time Duration in [DD hh:mm:ss] format
As DBA, there are various scenarios where I display duration in results. More often, for…
Posted inTSQL
Create & Populate StackOverflow.dbo.PostTags table
As a DBA & instructor, very often I like to generate heavy workload on my…
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…
Posted inLinux PostgreSQL
Install/Configure PostgreSQL on CentOS 8
In my current organization, we have lot of postgres databases running on linux. So thought…
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…
Posted inErrors
Error/Fix: Database cannot be upgraded because it is read-only or has read-only files
Yesterday during my online SQL Server class, I was trying to attach 10 GB size…
