Salvoz - salvoz.com
General Information:
Latest News:
SSRS: Report Actions, URL Actions and SharePoint 7 Aug 2013 | 10:00 am
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...
SSRS: Display Average on SSRS Chart Based on Parameter Value 6 Aug 2013 | 12:41 am
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 a...
Windows Azure ACS and AD 31 Jul 2013 | 02:27 am
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 ...
Powershell FTP Scripts 22 Jul 2013 | 04:46 am
I recently created some Powershell scripts to perform basic FTP commands. A description and link to each script is included below. Disclaimer: These scripts are intended for learning / demonstratio....
SSAS Data Mining – Time Series Algorithm 19 Jun 2013 | 09:02 am
At TechEd 2013, I attended a few sessions on the topics of Data Mining and Predictive Analytics. I thought I’d try out the data mining functionality in SSAS using warranty data from a data mart to pr...
TechEd 2013–Favorite Sessions 11 Jun 2013 | 07:43 am
At TechEd 2013, I attended many excellent Business Intelligence / Data Platform sessions and thought I’d share an overview of a few of my favorites: 1. Overview of Business Intelligence in Microsoft ...
TechEd 2013–Advice for First Time Attendees 9 Jun 2013 | 11:03 pm
I attended TechEd North America for the first time this year. This was my first technical conference, so I wasn’t sure what to expect. Overall, I had a great time, met many new people and learnt ...
Sum Result of SSRS LookupSet Function 28 May 2013 | 04:45 am
SSRS provides several built-in Lookup functions: Lookup, MultiLookup and LookupSet. Lookup returns a single value while MultiLookup and LookupSet return a set of values. If you want to learn more ab...
SSAS Event Type Calculation Dimension 22 May 2013 | 08:25 am
Calculation dimensions in SSAS are used to store calculations that can be applied to any measure in the cube. For example, we can define a ‘Year to Date’ calculation in a calculation dimension and it...
SSAS 2012 Tabular Cubes PowerPoint Presentation 6 May 2013 | 07:01 am
I presented an introduction to SSAS 2012 Tabular Cubes at a few PASS chapter meetings and SQL Saturday 206 in Madison, WI. A few individuals have asked for the PowerPoint slides, so I am posting them...
