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

Compare database objects

I had posted a database object comparison script in technet gallery long back. I will be posting more updates here. At present this scripts compares tables, indexes and foreign keys. sample usage : Once you deploy the stored procedure you can just run this command to compare two databases exec… Continue Reading Compare database objects