Sam Vanga

Presenting Biml and Team-based Development at PASSDC and BSSUG

• by Samuel Vanga

• Sam Vanga

I’m excited to present two different sessions in April at DC SQL Server User Group and at Baltimore SQL Server User Group. I...

2014-04-03

535 reads

Automate T-SQL Merge For Loading Dimensions

• by Samuel Vanga

• Sam Vanga

If you’re a data warehouse developer, chances are you use T-SQL Merge statement to process slowly changing dimensions. If you’ve...

2014-02-05

1,304 reads

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

• by Samuel Vanga

• Sam Vanga

We all have bad habits. Maybe we eat too many snacks, spend too much time on the couch watching TV,...

2014-01-21

568 reads

Standardize Table Aliases

• by Samuel Vanga

• Sam Vanga

What's wrong with the following code?
tsqlLine number Off | Hide | Select allSELECT    a.[BusinessEntityID]    , b.[FirstName]    , b.[LastName]FROM[HumanResources].[Employee] a    INNER JOIN [Person].[Person] b    ON...

2013-03-05

772 reads

Standardize Table Aliases

• by Samuel Vanga

• Sam Vanga

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...

2013-03-05

886 reads

Sparklines and Conditional Formating in SSRS

• by Samuel Vanga

• Sam Vanga

When creating a SSRS report, you want to add lines that display trends. You want to show trends for more...

2013-02-26

820 reads

Sparklines and Conditional Formating in SSRS

• by Samuel Vanga

• Sam Vanga

When creating a SSRS report, you want to add lines that display trends. You want to show trends for more...

2013-02-26

464 reads

Script to Populate Date Dimension, without Using a Cursor

• by Samuel Vanga

• Sam Vanga

Most of the scripts I've used to populate date dimension uses a cursor. Since data is loaded only once to...

2013-01-22

2,468 reads

Script to Populate Date Dimension, without Using a Cursor

• by Samuel Vanga

• Sam Vanga

Most of the scripts I’ve used to populate date dimension uses a cursor. Since data is loaded only once to...

2013-01-22

770 reads

SQL Server Views

• by Samuel Vanga

• Sam Vanga

This post is first of yet to come long series on basic concepts of SQL Server. I’ll begin with basic...

2013-01-22

739 reads