There's a problem with schemas in SQL2K5 that I encountered again this week, and I put my head to it and developed a very elegant solution that I thought I'd share with everyone. Problem: When you ...

I am looking for suggestions on an alternative product for comparing SQL schema and data with Microsoft SQL server (2012). Up to this point in time our company has used Red Gate SQL Compare and SQL ...

Idera, a provider of management and administration solutions for Microsoft SQL Server, has announced SQL comparison toolset v1.1, a solution that is aimed at helping DBAs save time in comparing and ...

One of the interesting new features in SQL Server 2008 is Change Data Capture. I wrote about Change Tracking in a previous blog entry. That will track the what, when and who but will not tell you ...