Comparing SQL Indexes with Powershell

A common challenge I’ve faced is managing many SQL Server Indexes across multiple databases in multiple environments. There’s often a need to not only check that Indexes exist, but that they match. For example does your Test environment have the same Indexes as your Dev environment.  Traditionally I’ve always tackled this using SQL Management Studio, but after awhile I looked for a way to perform this faster through Powershell scripting.

read more
1 2 3 4 11
Page 2 of 11