Welcome to Salvo(z)

Book Review: Troubleshooting SQL Server A Guide for the Accidental DBA

Thursday, August 23, 2012
by jsalvo

Over the past few years, Adam and I have won several books at the local MadPASS chapter meetings.  I’ve intended to write a book review for quite awhile and thought I’d start off with this book for several reasons:

read more...

Data Transfers within an Azure Data Center

Tuesday, August 21, 2012
by asalvo

This is a quick post which illustrates the benefit of doing data transfers within a Azure Data Center. Instead of downloading files multiple times across each of my Azure VM’s, I created a secure FTP server on one of my VM’s. I then upload my files to this server and then share the contents.

read more...

Meme15: Top 5 Reasons I Like My Job

Wednesday, August 15, 2012
by jsalvo

This month’s Meme15 topic is ‘Top 5 Reasons I Like My Job’.  A little over a year ago, I started working as a Business Intelligence developer at Trek Bikes.  Working at Trek has been a great experience and I feel very fortunate to have the opportunity, so I thought I’d share a few of the things I like best. Smile

read more...

T-SQL Tuesday: Trick Shots (Currency Conversion in SSAS)

Tuesday, August 14, 2012
by jsalvo

Today is T-SQL Tuesday #33 hosted by Mike Fal.  The topic is SQL Server – Trick Shots.  This assignment involves blogging about a cool process or trick you implemented that is related to SQL Server and the lessons or insight gained from the experience.   As a BI developer, I thought I’d write about a topic related to SSAS.  The first topic that came to mind is currency conversion in SSAS using measure expressions.

read more...

T-SQL Tuesday: A Day in the Life of a BI Developer

Tuesday, July 17, 2012
by jsalvo

My name is Jennifer and I am a Business Intelligence developer at Trek Bicycles.  I’ve been a BI developer for a little over a year and work with the Microsoft BI tools: SSIS, SSAS and SSRS.   The BI team at Trek consists of 4 analysts (2 in US, 1 in UK, and 1 in Australia), 3 developers, 1 SharePoint developer/admin and 1 DBA.  We use an agile process to coordinate development and DBA work.

read more...