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,870 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

Claude Code Helps Analyze Test Data Manager Log Files

PowerPoint to HTML with Claude AI

Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!

Forums

SQL Server 2025 Query Performance Tuning: Troubleshoot and Optimize Query Performance

Is it uncommon for Dev's to have a data model of the source data

ROLLUP to calculate Month total for all Categories

Question of the Day

Creating JSON I