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.
Tag Archives: SQLServer
Introduction to Hadoop, Big Data and Data Warehousing
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.
Want to make SQLServer2008 R2 Scream?
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?
#datavault – interesting .NET ETL engine
Short overview / review of Rhino ETL – Microsoft SQLServer .NET based engine and libraries.
Dynamic Staging – an Interesting view
A very short review/entry on SQLServer dynamically generated ETL from structures defined in a table in the database.
Q: Moving a DV from SQLServer to Teradata?
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.
Q&A:What does the ETL for DV look like? Sample?
This post discusses in brief, what the ETL implementation for a Data Vault might look like.