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

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, 1,221 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, 2,475 reads

Posted in Sam Vanga on 15 August 2012

SQL Saturday US Map

Apparently, SQL Saturday isn’t popular in the west. See for yourself. I wanted to see what cities frequently host SQL Saturday and ended up creating this dashboard. There are some interesting findings. Look at how the events are primarily confined to only (right) half of United States. There are several… Read more

9 comments, 1,062 reads

Posted in Sam Vanga on 3 August 2012

SCRIPT: Basic Information About Indexes

I’m having a little fun with documenting basic information about indexes in my current project. I’m posting the scripts here mostly for me to come back when I need them in the future, but hopefully some of you might find them useful.

Find tables without any index:

This script… Read more

0 comments, 1,004 reads

Posted in Sam Vanga on 31 July 2012

Parallel Execution in SSIS with MaxConcurrentExecutables

MaxConcurrentExecutables, a package level property in SSIS determines the number of control flow items that can be executed in parallel. The default value is -1. This is equivalent to number of processors (logical and physical) plus 2.

For example, in the below package running on my machine with 4 processors… Read more

0 comments, 3,540 reads

Posted in Sam Vanga on 20 July 2012

Generating Surrogate Keys With SSIS

A surrogate key is an auto generated value, usually integer, in the dimension table. It is made the primary key of the table and is used to join a dimension to a fact table. Among other benefits, surrogate keys allow you to maintain history in a dimension table. Despite of… Read more

5 comments, 3,774 reads

Posted in Sam Vanga on 24 June 2012

Status Column in SSISDB Catalog Database

I occasionally review the search terms people use to get to this blog and secretly celebrate knowing my post helped them. If i know it didn’t, i add it to the list of items i should write about. This post is a result of one such thing.

Note: If you… Read more

0 comments, 650 reads

Posted in Sam Vanga on 19 June 2012

T-SQL Tuesday 31: SSIS 2012 Logging

Topic for this month’s T-SQL Tuesday, hosted by Aaron Nelson (@SQLVariant) is Logging.

I like to think of logging as a Flight Data Recorder (FDR) to an aircraft. FDR records data about functioning of an aircraft. No one cares what is in there as long as the aircraft… Read more

3 comments, 2,665 reads

Posted in Sam Vanga on 12 June 2012

Tips to improve your blog, really!

As I learnt a few things about blogging, I made a list of tips to get better at blogging. Thought I would share.

  1. Pour your heart out to answer a question. When someone asks a question, it means they followed your post hoping they would find an answer to…

Read more

8 comments, 536 reads

Posted in Sam Vanga on 17 May 2012

Workspace database server was not found

You might constantly see a warning message that appears like the one below when creating Analysis Services Tabular projects. It basically says, workspace database server ‘ServerName’ was not found.

You’ll have to change this setting from the model properties. The server should be an Analysis Services Server running in Tabular… Read more

0 comments, 575 reads

Posted in Sam Vanga on 8 May 2012

How to execute a package from another package?

I hear you. You’ll use the Execute Package Task. This mechanism of executing one package from another is popularly knows as Parent Child paradigm. Let me tell you, this isn’t new in 2012. There are, however, a few changes to the Execute Package Task. Let’s take a look.


Read more

1 comments, 1,197 reads

Posted in Sam Vanga on 1 May 2012

Change Package Properties Using Parameters–SSIS 2012

In DTS, changing package properties was close to impossible (the less we talk about DTS, the better). Package configurations introduced in 2005 solved most of the problems. In 2012, SQL Server Integration Services introduces parameters to make this process even easier. Parameters allow you to change package properties without the… Read more

5 comments, 7,762 reads

Posted in Sam Vanga on 24 April 2012

Do You Know These Free Events?

I frequently attend a few online training events that greatly help me learn new things. Thought I would share, if may be you are interested too. These are all cool people sharing information for free to the community.

Go get'em!

Read more

2 comments, 425 reads

Posted in Sam Vanga on 23 April 2012

Why Isn’t There A Deployment Server Edition For SSIS Projects?

Andy Leonard blogged about a gotcha when creating SSIS projects using SSDT yesterday. He showed that you can use any component in SSDT whether or not your SQL Server supports that component. For example, you can create a package with Fuzzy Lookup and deploy to a server running Business Intelligence… Read more

0 comments, 877 reads

Posted in Sam Vanga on 19 April 2012

Execute T-SQL Statement Task

I spotted a new task in SSIS 2012Execute T-SQL Statement Task. It executes T-SQL statements, only Transact-SQL statements against SQL Server databases. Cool, but don’t get too excited. Why? Because you can neither parameterize the SQL nor save the results to a variable.

The task editor looks… Read more

3 comments, 686 reads

Posted in Sam Vanga on 17 April 2012

Simple Tips To Speed Up Your SSIS Data Flow

There are a few design choices that can make your SSIS packages run super fast when loading data from table A to table B.

SQL Command at Source

OLE DB source editor allows you to choose either a table or a view from a drop down if data access mode… Read more

4 comments, 1,914 reads

Posted in Sam Vanga on 10 April 2012

SQL Roundup – 03/16-2012

Howdy! I was flying last week, and for the first time i sat facing a flight attendant. You don’t actually sit face to face with anybody in a flight, because, you know all the seat rows are facing in only one direction. But attendants sit in the opposite direction. That… Read more

0 comments, 493 reads

Posted in Sam Vanga on 16 March 2012

Distinct Count in Analysis Services

Business users are often interested in finding distinct counts in addition to other aggregations. They may want to know the number of distinct customers calling customer support, the number of distinct employees selling business, or the number of distinct products that are being sold. Note the difference between distinct count… Read more

1 comments, 608 reads

Posted in Sam Vanga on 14 March 2012

SQL Roundup – 03/09/2012

Welcome to another week of SQL Roundup. Just in case you missed, SQL Server 2012 was released this week and you can download the evaluation edition here.

Clever and great improvisation. Create tag cloud style reports using SSRS. (Jason Thomas).

Jen McCown summarizes the agony caused during the… Read more

0 comments, 429 reads

Posted in Sam Vanga on 9 March 2012

SSRS NoRows – Display a custom message when there is no data

In this short post, I’ll discuss NoRowsMessage property. When there is no data for a data region, the message you specify for the NoRowsMessage property will displayed to the user instead of a blank report.

I created a report with a tablix and configured the NOROWS property from the tablix… Read more

2 comments, 1,109 reads

Posted in Sam Vanga on 6 March 2012

Newer posts

Older posts