How to create a Columnstore Index

Each table can have only 1 columnstore index, data from the index is stored in memory in the xVelocity engine.  Once a columnstore index has been created on a table you cannot update the table.  Microsoft recommends you take the following actions to update the data in a table containing a columnstore index. Drop the … [Read more…]

Value of Business Intelligence

Regardless of the technology that you choose and there are more and more being developed each year. Asking for money to start or extend a Business Intelligence project is not about the technology. It is about the value that data can deliver to the business. Data laying in a database does not provide value. To … [Read more…]

Hortonworks Sandbox 1.3 – Hadoop

For those looking to learn Hadoop, the easiest method I found for experimenting is the Hortonworks Sandbox.  It is an all in one Virtual Machine that you can use to learn Hadoop instead of spending your time on trying to install and configure a Hadoop cluster. I installed the VM on a 64 bit laptop … [Read more…]