Data blog

SelectCompare 1.3.5 has a number of improvements and the most important one is the ability to compare data using a new command line utility. The functionality allows for automation of data comparisons and reporting.

Excel is a de-facto standard for data exchange in 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 time spent on data validation.

This SelectCompare version 1.3 implements several performance improvements. Some of the users reported problems with excessive usage of memory during the 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 new charts providing visual statistics of the data comparison.

A short post describing the installation procedure of the Powershell utility package dbachecks that is making the job of a SQL Server DBA much easier. DBAChecks allow for the execution of numerous environment parameter verifications and complex reporting.

Table partitioning is dividing your data in a table into horizontal chunks, that can be (depending on the DB technology you use) indexed separately and stored on different disks. This allows you to address certain performance issues if a table is large, there are many inserts into it, and there is a requirement of providing reports on the data in this table. That table might be for example a transaction registry from your retail network.

John Ryan wrote an excellent post comparing different data architectures and their pros and cons. As it turns out there are four major options you can choose from, and you should...

I am delighted to announce that a new version of SelectCompare has been released. Version 1.2 contains several improvements and optimizations, and two of them are directly available to the...

The post illustrates the process of the setup of the Oracle InstantClient with ODBC drivers, the configuration of an ODBC data source, and the configuration of the SelectCompare Connection so you can use Oracle in your data comparison work.