Create the tpc-h database schema for SQL Server

Last time we created some test data with the tpc-h tool. This time i just want to post a short t-sql to create the database schema.

Read More

Create test data with tpc-h for i.e. SQL Server or MongoDB

When you are testing databases (i.e. Microsoft SQL Server or MongoDB) or ETL-tools (like Pentaho or SSIS) you often need great amounts of data. The tool tpc-h from the „Transaction Processing Perfomance Council“ fits this needs and generates as much data as you need.  This should be a short tutorial how to compile the tool an generate some data.

Read More

Using Windows Server 2012 VHD with VMware Player

After searching on the Internet I found a pretty decent way to get an environment for testing tools and databases.  So here is a small tutorial how to use a Windows Server 2012 VHD with VMware Player.

Read More