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

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