Data comparison using command line interface of SelectCompare. The CLI allows for quick listing of defined connections and data comparison projects as well as for comparison of the defined data project by their ID or by name. The CLI can also export data to Excel, so that you can automate the report generation.
Excel is a de-facto standard for data exchange in the offices. It is important to be sure that the data in the excel spreadsheets is correct. It is difficult and time consuming to analyze each line of a report, especially if reports contain dozens of columns and hundreds of lines. But how do you know that you collected all the data? How do you know that the report contains all the required inputs? SelectCompare can facilitate use cases that bring huge value to the organization by limiting the amount of time spent on validation of data.
This SelectCompare version 1.3 implements a number of performance improvements. Some of the users reported problems with excessive usage of memory during export of data to Excel spreadsheets and the speed of data comparison of larger data sets. These issues have been resolved. Excel workbooks also contain now charts providing visual statistics of the data comparison.
A short post describing installation procedure of the Powershell utility package dbachecks that is making the job of a SQL Server DBA much easier. DBAChecks allow for execution of numerous environment parameter verifications and complex reporting.