xp_fixeddrives ignores SAN mount points

Recently I was working with a customer on a drive space issue and the disk space alert function failed to alert DBAs about this on time. I was just amused why the alert didn’t work at all. After some research it turned out that the customer had recently added a… Continue Reading xp_fixeddrives ignores SAN mount points

Find SQL Instances – Powershell

DBAs working in data centers would often want to find all the SQL Server instances in the network. How this can be done using few simple powershell scripts? There are multiple ways you can achieve this using powershell. First we just trust the SQL browser services and assume that it… Continue Reading Find SQL Instances – Powershell