About James Serra
I am an independent consultant with the title of Business Intelligence/Data Warehouse/Master Data Management Architect and Developer, specializing in the Microsoft SQL Server BI stack.Need some help?
If you are looking for help in building a data warehouse or end-to-end BI solution, send me an email and we can discuss your needs. I am available for short or long-term projects.Follow Me!
Subscribe by email
-
Recent Posts
- I’m presenting at the PASS Summit!
- Consulting company: Perm/Salaried vs 1099/W2
- When the person you hire is not the person you hire
- Should placement companies use a markup %?
- Data cleansing in SSIS, DQS, and MDS
- Billing rates – other side of the fence, part 2
- Want me to do a presentation?
- Enhance your career by blogging!
- Consultants – Why pay more?
- Industry Expert Interview
Recent Comments
- Consulting company: Perm/Salaried vs 1099/W2 | James Serra's Blog on Salaried employee vs contractor
- I’m presenting at the PASS Summit! - SQL Server - SQL Server - Toad World on PASS Business Analytics Conference: the ultimate networking
- I’m presenting at the PASS Summit! - SQL Server - SQL Server - Toad World on How to become an expert in your field
- I’m presenting at the PASS Summit! - SQL Server - SQL Server - Toad World on Enhance your career by blogging!
- I'm presenting at the PASS Summit! | James Serra's Blog on DBA’s, want to earn the big bucks? Learn BI
Archives
- May 2013 (7)
- April 2013 (10)
- March 2013 (10)
- February 2013 (10)
- January 2013 (8)
- December 2012 (10)
- November 2012 (11)
- October 2012 (10)
- September 2012 (9)
- August 2012 (4)
- July 2012 (9)
- June 2012 (7)
- May 2012 (6)
- April 2012 (10)
- March 2012 (15)
- February 2012 (14)
- January 2012 (13)
- December 2011 (12)
- November 2011 (12)
- October 2011 (14)
- September 2011 (14)
- August 2011 (15)
- July 2011 (15)
- June 2011 (20)
- May 2011 (13)
- April 2011 (3)
Categories
- Active Directory
- Antivirus
- Appliance
- BISM
- Blog
- Business Intelligence
- Career
- Certification
- Columnstore indexes
- Consulting
- Data warehouse
- DAX
- Dimensions
- DNS
- DQS
- ETL
- Excel
- Fast Track
- Fuzzy Lookup
- Introduction
- KPI
- MDS/MDM
- MDX
- Microsoft
- PASS
- PDW
- PerformancePoint
- Power View/Project Crescent
- PowerPivot
- Presentation
- ProClarity
- Quick Tip
- Report Builder
- Security
- Session
- SharePoint
- SharePoint 2013
- SQL Azure
- SQL Server
- SQL Server 2012
- SQLServerPedia Syndication
- SSAS
- SSDT/Juneau
- SSIS
- SSMS
- SSRS
- Tabular
- Team Foundation Server
- Tools
- Training
- Videos
- Virtualization
- Visio
- Visual Studio 2008
- Visual Studio 2010
- Visual Studio 2012
- Visual Studio vNext
- White Paper
- Windows 8
Top Posts & Pages
- When the person you hire is not the person you hire
- SSDT - Installation confusion
- Salaried employee vs contractor
- Data Warehouse Architecture - Kimball and Inmon methodologies
- Improving cube processing time
- I'm presenting at the PASS Summit!
- Create SQL Server scripts with Visio 2010
- Consultants: Corp-to-Corp vs 1099
- Consultants: 1099 or W-2?
Favorite Blogs
Meta
Rockstar Blogger
Monthly 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 … Continue reading
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 … Continue reading
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 … Continue reading
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 … Continue reading
“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 is available here. Here is the PowerPoint presentation: DBA: Transitioning to a BI Role I had some excellent questions … Continue reading
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) … Continue reading
Posted in MDS/MDM, Presentation, Session, SQLServerPedia Syndication
Leave a comment
“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. … Continue reading
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 … Continue reading
Posted in MDS/MDM, Presentation, Session, SQLServerPedia Syndication
Leave a comment
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 … Continue reading
Posted in PASS, SQL Server, SQLServerPedia Syndication, Videos
Leave a comment
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 … Continue reading
