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: March 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, 778 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, 1,084 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, 662 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,700 reads

Posted in Sam Vanga on 6 March 2012

Introducing SQL Roundup

Following in the foot steps of John Sansom (b|t), I’m going to post a roundup of links from other blogs every Friday. I’ll call this SQL Roundup. John calls his “Something for the Weekend“.

Each Roundup will have no more than 10 links.… Read more

0 comments, 880 reads

Posted in Sam Vanga on 2 March 2012