Welcome to Salvo(z)

Powershell FTP Scripts

Sunday, July 21, 2013
by jsalvo

I recently created some Powershell scripts to perform basic FTP commands.  A description and link to each script is included below. 

read more...

SSAS Data Mining: Time Series Algorithm

Tuesday, June 18, 2013
by jsalvo

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 predict the quantities of failed parts over the next few months.   To accomplish this, I created a Data Mining structure in SSAS using the Microsoft Time Series Algorithm.  This is my first attempt at data mining, so I thought I’d write a blog post to document what I’ve learned so far.

read more...

TechEd 2013: Favorite Sessions

Monday, June 10, 2013
by jsalvo

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:

read more...

TechEd 2013: Advice for First Time Attendees

Sunday, June 9, 2013
by jsalvo

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 a lot.  I thought I’d pass along a few of my observations and suggestions for other first time TechEd attendees – to help you get the most out of the conference.

read more...

Sum Result of SSRS LookupSet Function

Monday, May 27, 2013
by jsalvo

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 about the SSRS lookup functions check out this blog post

read more...