Subscribe to this blog
Sam Vanga
Archives: January 2013
Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I've used to populate date dimension uses a cursor. Since data is loaded only once to a date dimension in the ETL life cycle, using a cursor isn't a sin.
Still, when I was reviewing my own code the other day, I wanted to get rid… Read more
0 comments, 1,152 reads
Posted in Sam Vanga on 22 January 2013
Script to Populate Date Dimension, without Using a Cursor
Most of the scripts I’ve used to populate date dimension uses a cursor. Since data is loaded only once to a date dimension in the ETL life cycle, using a cursor isn’t a sin.
Still, when I was reviewing my own code the other day, I wanted to get rid… Read more
0 comments, 167 reads
Posted in Sam Vanga on 22 January 2013
SQL Server Views
This post is first of yet to come long series on basic concepts of SQL Server. I’ll begin with basic 101 introduction to SQL Server views. I wouldn’t recommend reading any further if you are an experienced sql server’er. I value your time
What are views?
- virtual tables
- named select…
0 comments, 360 reads
Posted in Sam Vanga on 22 January 2013
Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you’re infected; Database best practices protect your databases from bad things. But, we all make mistakes. It could be because we’re on a time crunch, or we’re lazy (which I’m guilty of by the way), or maybe it’s part… Read more
2 comments, 135 reads
Posted in Sam Vanga on 15 January 2013
Scripts to Detect Data Warehouse Issues
Standards and best practices are like flu shots you take before you're infected; Database best practices protect your databases from bad things. But, we all make mistakes. It could be because we're on a time crunch, or we're lazy (which I'm guilty of by the way), or maybe it's part… Read more
0 comments, 187 reads
Posted in Sam Vanga on 15 January 2013