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:
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.
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.
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.
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.
- Newer
- Older