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

All authors

Create Sparklines in SSRS

by Samuel Vanga

Sam Vanga

When creating a SSRS report, you want to add lines that display trends. Sparklines that were introduced in SQL Server 2008 R2...

2011-11-14

3,911 reads

#SSRS error – An item with the same key has already been added

by Samuel Vanga

Sam Vanga

Here is a simple yet annoying error I ran into while creating a dataset. Below is the query that I...

2011-11-10

2,201 reads

Column alias in order by and where

by Samuel Vanga

Sam Vanga

If you ever wonder why column alias can be used in order by and not in where clause, it’s the...

2011-11-08

6,878 reads

BI Pyramid (read categories of users in a BI solution)

by Samuel Vanga

Sam Vanga

Purpose of any business intelligence solution is to provide users information and enable them to make intelligent decisions that benefit their...

2011-11-01

809 reads

Hello…

by Samuel Vanga

Sam Vanga

Here i come… this is my first post at http://svangasql.wordpress.com. Here, you will see posts related to sql server, reporting...

2011-09-07

519 reads

All authors

Samuel Vanga

Create Sparklines in SSRS

#SSRS error – An item with the same key has already been added

Column alias in order by and where

BI Pyramid (read categories of users in a BI solution)

Hello…

Blogs

RANK() vs DENSE_RANK(): #SQLNewBlogger

Using CAT for Testing of Data Agents

Are you getting value from your reporting?

Forums

Fun with JSON

Creating JSON II

Engineer Lessons

Question of the Day

Creating JSON II