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.

Team-based Database Development: Playing Nice With Others

Here are the slides and links to awesome resources for my presentation, “Team-based Database Development: Playing Nice With Others

If you need a summary of what’s covered in the session, the abstract is as follows:

As soon as you have more than one person on a development effort,… Read more

2 comments, 1,162 reads

Posted in Sam Vanga on 29 April 2014

Read Flat File Contents to Variable – Write Variable Value to Flat File

When working with SSIS, you’ll often find the need to read the contents of a flat file to a variable, and write the value of a variable to a flat file. A script task can be used to accomplish both of these.

READ CONTENTS OF A FLAT FILE TO A… Read more

0 comments, 2,218 reads

Posted in Sam Vanga on 8 April 2014

Presenting Biml and Team-based Development at PASSDC and BSSUG

I’m excited to present two different sessions in April at DC SQL Server User Group and at Baltimore SQL Server User Group. I look forward to seeing you there if you’re in the area.

I’m passionate about these topics and enjoyed building these new sessions. Hopefully the attendees will… Read more

0 comments, 165 reads

Posted in Sam Vanga on 3 April 2014

Automate T-SQL Merge For Loading Dimensions

If you’re a data warehouse developer, chances are you use T-SQL Merge statement to process slowly changing dimensions. If you’ve coded a couple of Merge statements, you might’ve noticed that most of that code is redundant. By saving source to target data map and other metadata before hand, you can… Read more

2 comments, 147 reads

Posted in Sam Vanga on 5 February 2014

Get Rid of These 5 T-SQL Bad Habits with SQL Prompt

We all have bad habits. Maybe we eat too many snacks, spend too much time on the couch watching TV, don’t take enough breaks during the day. Some of these bad habits are harmless, but others, like not regularly taking database backups might give you constant headaches. Bad T-SQL writing… Read more

0 comments, 82 reads

Posted in Sam Vanga on 21 January 2014

Standardize Table Aliases

What's wrong with the following code?

  1. SELECT
  2.     a.[BusinessEntityID]
  3.     , b.[FirstName]
  4.     , b.[LastName]
  5. FROM [HumanResources].[Employee] a
  6.     INNER JOIN [

Read more

0 comments, 172 reads

Posted in Sam Vanga on 5 March 2013

Standardize Table Aliases

What’s wrong with the following code?

SELECT 
    a.[BusinessEntityID]
    , b.[FirstName]
    , b.[LastName] 
FROM [HumanResources].[Employee] a
	INNER JOIN [Person].[Person] b
	ON b.[BusinessEntityID] = a.[BusinessEntityID]

Nothing – except for my poor choice of using meaningless single characters as table aliases. Although it’s not a big deal with simpler queries like I’ve here,… Read more

0 comments, 100 reads

Posted in Sam Vanga on 5 March 2013

Sparklines and Conditional Formating in SSRS

When creating a SSRS report, you want to add lines that display trends. You want to show trends for more than one data point. And you want to conditionally format the data point.

In this example, I use Sparklines and a simple expression to create a sparkling report!

Below is… Read more

0 comments, 92 reads

Posted in Sam Vanga on 26 February 2013

Sparklines and Conditional Formating in SSRS

When creating a SSRS report, you want to add lines that display trends. You want to show trends for more than one data point. And you want to conditionally format the data point.

In this example, I use Sparklines and a simple expression to create a sparkling report!

Below is… Read more

0 comments, 276 reads

Posted in Sam Vanga on 26 February 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,048 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, 139 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, 172 reads

Posted in Sam Vanga on 15 January 2013

Every ebook from Apress for $15

Query Performance Tuning. Grant Fritchey. $15. If this doesn’t excite you, nothing will. Apress is offering every e-book for just $15 on Nov. 26. Here is a list of books I’m purchasing and recommend to you.

SQL Server 2012 Integration Services Design Patterns

I already bought this, and I love… Read more

0 comments, 426 reads

Posted in Sam Vanga on 26 November 2012

PASS SQL Saturday World Map

I had the pleasure of helping Karla Landrum (@Karlakay22) for the PASS Summit 2012 by creating two dashboards: SQL Saturday events and PASS Chapters on a world map. If you attended either SQL Saturday round table or Community Zone at the Summit, you may have seen them.

I… Read more

0 comments, 451 reads

Posted in Sam Vanga on 20 November 2012

PASS Summit 2012 Twitter Dashboard

As a business intelligence developer, my skills include taking the raw data, shaking it to remove all the junk, and presenting it to business users in the most sexiest way possible – smart people often use the words ETL, and BI to define this process, but I’m not smart –… Read more

3 comments, 866 reads

Posted in Sam Vanga on 12 November 2012

Create Several Shell SSIS Packages In Minutes Using BIML

What do i mean by shell packages? You’re spot on – that’s an excellent question to begin with. For the purpose of this post, I define shell package as an empty package that is renamed appropriately and contains all the required connection managers.

It is a common pattern among SSIS… Read more

2 comments, 2,714 reads

Posted in Sam Vanga on 16 October 2012

I’m Not Attending #sqlpass Summit 2012 and I’m Sorry For Myself

I really wanted to attent PASS Summit this year, I’ve never attended before. I was preparing myself mentally since the last summit, but things didn’t work out. Life happened. I’ve some personal obligations that I need to take care. I can’t talk much about these obligations here, but I can… Read more

0 comments, 342 reads

Posted in Sam Vanga on 12 October 2012

Generate Uniqueidentifier with SSIS

If you are trying to generate Uniqueidentifier/Newid() in SSIS data flow, you will soon realize that there is no out-of-the-box transformation you could use. Fear not. Script Component can be used to create Uniqueidentifier columns.

In the below package, I’ve an OLE DB source. Then, i dragged script component to… Read more

0 comments, 2,890 reads

Posted in Sam Vanga on 10 October 2012

Older posts