Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Sam Vanga

Sam Vanga helps business people solve their data problems and enables them make data-driven-decisions. His specialties include data integration, data warehouse and database development, and BI design. Sam blogs at http://SamuelVanga.com.

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,051 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, 140 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…

Read more

0 comments, 343 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, 113 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, 173 reads

Posted in Sam Vanga on 15 January 2013