Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

Archives: February 2013

Data Warehouse Architecture Presentation Slides

Thanks to everyone who attended my session “Data Warehouse Architecture” to the PASS DBA virtual chapter.  There were over 200 attendees!  The recording of the session is available here.

Here is the PowerPoint presentation: Building an Effective Data Warehouse Architecture

Data Warehouse Architecture

You’re a DBA and your… Read more

0 comments, 599 reads

Posted in James Serra's Blog on 28 February 2013

Data Warehouse Architecture Presentation

I will be presenting the session “Data Warehouse Architecture” this Wednesday, Feb 27th at 11:00am CST to the PASS DBA virtual chapter.  Below is the abstract.  It will be a remote presentation that you can join online.  Details are here.  This will be the same presentation that… Read more

0 comments, 507 reads

Posted in James Serra's Blog on 26 February 2013

I’m presenting at the PASS SQL Saturday in Chicago

I have been selected to present at the SQL Saturday in Chicago on April 13th.  This works out nicely as the previous day I will be presenting the same session at the PASS Business Analytics Conference, so if you can’t make that event, I hope to see you at… Read more

0 comments, 440 reads

Posted in James Serra's Blog on 21 February 2013

Using Team Foundation Service

Team Foundation Service (TFS) is the “cloud” version of Team Foundation Server 2012.  Up to 5 users are free, plus for a limited time all use is free (more info).

Below is my experience setting up Team Foundation Service and uploading my projects:

  1. Sign up for free…

Read more

0 comments, 636 reads

Posted in James Serra's Blog on 19 February 2013

“DBA: Transitioning to a BI Role” Presentation Slides

Thanks to everyone who attended my presentation “DBA: Transitioning to a BI Role” at the PASS Professional Development Virtual Chapter.  The recording of the session will be available here in the next day or two.

Here is the PowerPoint presentation: DBA: Transitioning to a BI Role

I had some… Read more

0 comments, 728 reads

Posted in James Serra's Blog on 14 February 2013

Introduction to Microsoft’s Master Data Services (MDS) Presentation Slides

Thanks to everyone who attended my presentation “Introduction to Microsoft’s Master Data Services (MDS)” at the Houston Area SQL Server User Group Monthly Meeting.

Here is the PowerPoint presentation: Introduction to Microsoft’s Master Data Services (MDS).

Introduction to Microsoft’s Master Data Services (MDS)

Companies struggle with consolidating the… Read more

0 comments, 709 reads

Posted in James Serra's Blog on 13 February 2013

“DBA: Transitioning to a BI Role” Presentation

Tomorrow (Wednesday, Feb 13th) at Noon CST I will be presenting the session “DBA: Transitioning to a BI Role” at the PASS Professional Development Virtual Chapter.  Below is the abstract.  It will be a remote presentation that you can join online.  Details are here.  I hope you… Read more

2 comments, 399 reads

Posted in James Serra's Blog on 12 February 2013

Introduction to Microsoft’s Master Data Services (MDS) Presentation

Tomorrow (Tuesday, Feb 12th) at 11:30am CST, I will be presenting the session “Introduction to Microsoft’s Master Data Services (MDS)” at the Houston Area SQL Server User Group Monthly Meeting.  Below is the abstract.  I will be presenting in person but you can join online.  Details are here Read more

0 comments, 379 reads

Posted in James Serra's Blog on 11 February 2013

24 Hours of PASS: Business Analytics Edition videos online

On January 30, BA and BI experts took to the virtual stage for the 24 Hours of PASS: Business Analytics Edition to deliver a series of one-hour webcasts, digging deep into the world of business analytics over five tracks.  All session recordings and slide presentations are now available for streaming Read more

0 comments, 427 reads

Posted in James Serra's Blog on 7 February 2013

Installing Team Foundation Server (TFS) 2012

My experience installing Team Foundation Server (TFS) 2012 to house my business intelligence projects built in Visual Studio 2010:

I am installing TFS 2012 on Windows Server 2012.  I am using Visual Studio 2010.  I will be using the standard installation for TFS 2012 which gives you Source Control, Work… Read more

2 comments, 2,544 reads

Posted in James Serra's Blog on 5 February 2013