Welcome to SQL-Blog

This site is about business intelligence related stuff which I learn and discover during my work and which I think is useful to remember.

About Me
  • Pentaho

    Pentaho

  • Microsoft Integration Services

    Microsoft Integration Services

Box heading

Nullam posuere felis a lacus tempor eget dignissim arcu adipiscing. Donec est est, rutrum vitae bibendum vel, suscipit non metus.
Read More

Box heading

Nullam posuere felis a lacus tempor eget dignissim arcu adipiscing. Donec est est, rutrum vitae bibendum vel, suscipit non metus.
Read More

Box heading

Nullam posuere felis a lacus tempor eget dignissim arcu adipiscing. Donec est est, rutrum vitae bibendum vel, suscipit non metus.
Read More

Box heading

Nullam posuere felis a lacus tempor eget dignissim arcu adipiscing. Donec est est, rutrum vitae bibendum vel, suscipit non metus.
Read More

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