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
- Low-rate recruiters – The bane of my existence
- Presentation Slides for Building an Effective Data Warehouse Architecture
- Levels in IT consultancy
- Building an Effective Data Warehouse Architecture Presentation
- Business Intelligence Maturity Assessment
- IT recruiter’s response
- SQL Server 2014!
- Power View for Multidimensional Models Released
- Ralph Kimball Books
- Business Intelligence Requirements Gathering
Recent Comments
Archives
- June 2013 (7)
- May 2013 (10)
- 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
- SQL Server 2014
- 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
- Low-rate recruiters - The bane of my existence
- Presentation Slides for Building an Effective Data Warehouse Architecture
- SQL Server 2014!
- Microsoft SQL Server Parallel Data Warehouse (PDW) Explained
- Data Warehouse Architecture - Kimball and Inmon methodologies
- SQL Server 2012: Multidimensional vs tabular
- Improving cube processing time
- Create SQL Server scripts with Visio 2010
- SSDT - Installation confusion
Favorite Blogs
Meta
Rockstar Blogger
Category Archives: Team Foundation Server
TFS vs SSIS project versioning
I had someone ask me the other day if they are using SSIS 2012 Project Versions, is there any benefit to using TFS? The answer is Yes! While Project Versions is a new feature that keeps prior versions of SSIS … 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
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
Managing Schemas And Source Control For Databases
Visual Studio has a project type called “Database Project” that is used to manage a database schema and allows for easy integration with source control. Visual Studio Database Projects have been known by a few different names down the years … Continue reading
System Center and Visual Studio Team Foundation Server 2010
Because the relationship between application development and the IT operations teams is critical, Microsoft has released a CTP of a new connector between System Center and Visual Studio Team Foundation Server (TFS) 2010 that helps the coordination between development and operations. The connector … Continue reading