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
Recently I have been working on setting up baselining for my SQL Server lab environment. As part of baselining, I capture all the required Perfmon counters both at
As DBA, there are various scenarios where I display duration in results. More often, for visual effects, I like to convert the same duration into [DD hh:mm:ss] format.
As a DBA & instructor, very often I like to generate heavy workload on my SQL Server instances to re-produce scenarios like 100% CPU, zero PLE, high IO,
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
In my current organization, we have lot of postgres databases running on linux. So thought to learn the same by building my own CentOS 8 vm on VirtualBox.
Yesterday I was trying to install dbatools powershell module in one virtual machine that I created for online SQL Class. Resolution:- In order to solve this issue permanently,
Yesterday during my online SQL Server class, I was trying to attach 10 GB size version of StackOverflow database that I used previosly with another instance. When I
When I joined my current organization 2 years back, the biggest problem I faced as DBA was whenever there was Replication, log shipping, Mirroring, or AlwaysOn, the Index