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

Archives: December 2011

Why doesn’t my gauge show correct values?

Here is an issue I encountered recently while using gauge in reporting services.
There are three gauges in the report one for each product; bikes, computers, and hardware. The value being showed is YTD sales and all gauges show a value of 100 for YTD Sales as seen below:

However… Read more

0 comments, 953 reads

Posted in Sam Vanga on 27 December 2011

Full Load. Incremental Load. Whaaat?

Back when i was in school, me and a bunch of friends used to hangout at a diner. The diner was popular for its specials, which were displayed on a board outside the entrance.

 The manager would roll in every day, wipe the board clean and list all the specials… Read more

5 comments, 4,514 reads

Posted in Sam Vanga on 20 December 2011

CONCAT() string function–SQL Server 2012

As the name indicates, CONCAT() will concatenate two or more strings. This is one of the two string functions introduced in SQL Server 2012, FORMAT() being the other one.

New? Wait. Concatenating isn’t new. It’s always been there. Yeah. you are right. No, concatenating isn’t new.Yes, CONCAT()… Read more

4 comments, 3,857 reads

Posted in Sam Vanga on 19 December 2011

Why did I start blogging?

This post is in response to #meme15 started by Jason Strate (b|t). Two questions were asked in the first assignment. Why did you start blogging, and why do you currently blog?

I recently started writing. My blog is still a baby. I started because I… Read more

0 comments, 631 reads

Posted in Sam Vanga on 16 December 2011

T-SQL Tuesday #025 – Tips and Tricks

And the trick i share for this month’s T-SQL Tuesday is… Distraction free management studio.

If you’re an avid writer, you might be using Writeroom. It’s a full screen distraction free writing application, which gets your computer out-of-the-way so that you can focus on your work. Dark Room Read more

3 comments, 673 reads

Posted in Sam Vanga on 13 December 2011

Create Drillthrough Reports

Use Actions!

Your user wants a summary report, containing sales for calendar year, for example. When the user clicks on the report, another detail report should be visible, containing sales for each month of the year, suppose. These type of reports are called drillthrough reports. How a drillthrough report… Read more

2 comments, 850 reads

Posted in Sam Vanga on 6 December 2011