A look at NoSQL, BigData, and Data Vault with regards to Transactions Per Second – the hype around ingestion rates, and questions around why / when you would or wouldn’t need to switch to NoSQL platforms to handle bigdata.
An introductory discussion on Data Warehousing, Hadoop, and Big Data. How it works, the differences between it and a relational system, and what some of the benefits/drawbacks are to plugging a Hadoop system IN to your architecture.
Ok, so you’re using SQLServer2008 R2, but you can’t afford, or haven’t invested in the Enterprise Edition (which by the way, I think is an awesome product). So in other words, you can’t take advantage of compression, and you can’t take advantage of partitioning. If you are struggling for SQLServer performance, what do you do?
Short overview / review of Rhino ETL – Microsoft SQLServer .NET based engine and libraries.
A very short review/entry on SQLServer dynamically generated ETL from structures defined in a table in the database.
A very short entry on migrating a Data Vault from SQLServer to Teradata, there’s really not much to do to make this work properly.
This post discusses in brief, what the ETL implementation for a Data Vault might look like.