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
Recently I was working on one user request to create a linked server for Oracle database in SQL Server 2014 instance. After installing the correct Oracle ODBC drivers,
Within my organization, we work in a controlled environment. That means, with each SQL Instance migration, we have strict rules to script out everything including System database user
As a DBA/Developer, there have been many occasions where I had to write my own scripts/automation to fulfill specific business requirements. Below are some of those useful scripts
In my organization, we have many SQL Agent jobs that are expected to execute within a particular time window. But there are times when some of them take
Remove High Virtual Log File (VLF) (@OptimizeLogFiles)
This generates TSQL code for removing huge virtual log files (VLFs) from SQL Server database log files. By default, @vlfCountThreshold is