Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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.

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, 380 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, 786 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, 383 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, 446 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, 409 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, 326 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, 568 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,785 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, 410 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, 548 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, 341 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, 379 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, 760 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, 728 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

4 comments, 1,215 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, 3,653 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, 539 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, 4,385 reads

Posted in Sam Vanga on 10 October 2012

Book Review: SQL Server 2012 Integration Services Design Patterns

This book is written by Andy Leonard, Matt Masson, Tim Mitchell, Jessica Moss, and Michelle Ufford. These are all highly talented people we are talking about. Andy is constantly teaching SSIS patterns in his training classes and articles. Matt, for me, is the face of SSIS team at Microsoft. Same… Read more

2 comments, 2,030 reads

Posted in Sam Vanga on 14 September 2012

SCRIPT: Find the row count of all tables and views

Today I’m sharing another script that I often find useful – Queries to find the count of rows from tables and views in a SQL Server database.

Count Rows In All Tables:

This query returns the count of rows from all tables in a database. The results can be seen… Read more

2 comments, 4,563 reads

Posted in Sam Vanga on 15 August 2012

Newer posts

Older posts