Welcome to Salvo(z)

PASS Summit 2013

Tuesday, October 22, 2013
by jsalvo

Adam and I attended PASS Summit for the first time this year in Charlotte, NC. We had a great time and enjoyed meeting new people. The following are a few highlights from our trip:

read more...

SSRS: Ignore Series Grouping in Chart

Friday, August 30, 2013
by jsalvo

In SSRS, when you add a Series Group to a chart the data for each series is aggregated based on the series grouping specified. In some situations, you may have a series that you want aggregated differently than the series grouping. 

read more...

SSRS: Report Actions, URL Actions and SharePoint

Tuesday, August 6, 2013
by jsalvo

I recently encountered a scenario involving a SSRS report that contains a report action to launch a sub-report.  The child / sub-report originally had two mandatory parameters and the values for these parameters were passed from the parent report to the child.  I wanted to add a third parameter to the child report that instead of being passed form the parent would default to a specific value that could be modified by the user. 

read more...

SSRS: Display Series on SSRS Chart Based on Parameter Value

Monday, August 5, 2013
by jsalvo

I recently modified an SSRS report to display average run times for various SQL Agent jobs over the past 30, 14 and 7 days.  Displaying all the averages simultaneously would make the chart cluttered and confusing; instead, I opted to control the displayed average via a parameter that the user can adjust if desired.  I also wanted to shade the area of the chart beneath the series to make it easy to identify the job executions over the average run time.  The result looks like this:

read more...

Windows Azure ACS and AD

Tuesday, July 30, 2013
by asalvo

Windows Azure Access Control Services (ACS), and Windows Azure Active Directory (WAAD) are part of the identity application service offerings provided by the Windows Azure platform. Both ACS And WAAD provide authentication and can return a list of claims, which can be used to identify users, and perform authorization. Windows Azure Active Directory is the same service which Microsoft’s SaaS offerings, such as Office 365 use.

read more...