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
- Data Warehouse Architecture - Kimball and Inmon methodologies
- SSDT - Installation confusion
- Salaried employee vs contractor
- Consultants: 1099 or W-2?
- Improving cube processing time
- I'm presenting at the PASS Summit!
- Create SQL Server scripts with Visio 2010
- Consultants: Corp-to-Corp vs 1099
Favorite Blogs
Meta
Rockstar Blogger
Category Archives: SSDT/Juneau
Visual Studio 2012 now supports BI!
My most popular blog has been Visual Studio 2012 does not support BI. In short, this means VS 2012 does not support SSAS, SSIS, or SSRS. Well, not anymore! Just released is Microsoft SQL Server Data Tools – Business Intelligence for … Continue reading
SSIS 2012: Empty toolbox?
This is an annoying problem I have had a few times: I open a SQL Server Integration Services (SSIS) project in SSDT, and see that the Toolbox pane is empty, displaying a “There are no usable controls in this group. … Continue reading
Posted in SQLServerPedia Syndication, SSDT/Juneau, SSIS
4 Comments
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
SQL Server Data Tools (SSDT) – December 2012 update
SQL Server Data Tools (SSDT) has a new update: VS 2010: December version: 10.3.21208.0, November version 10.3.21101.1, September version: 10.3.20905.0, initial version: 10.3.20225.0 VS 2012: December version: 11.1.21208.0, November version: 11.1.21101.1, September version: 11.1.20905.0, version shipped with VS 2012: 11.1.20627, initial version: … Continue reading
Posted in SQLServerPedia Syndication, SSDT/Juneau
Leave a comment
Can I use SSDT for the 2008 BI stack?
SQL Server Data Tools (SSDT) that was released with SQL Server 2012 obviously works with the BI stack (SSIS/SSAS/SSRS) for 2012. But does it also work with the BI stack from SQL Server 2008 R2? Can you use it with … Continue reading
Posted in SQLServerPedia Syndication, SSDT/Juneau
Leave a comment
SQL Server Data Tools (SSDT) – November 2012 update
SQL Server Data Tools (SSDT) has a new update: VS 2010: new version 10.3.21101.1, September version: 10.3.20905.0, initial version: 10.3.20225.0 VS 2012: new version: 11.1.21101.1, September version: 11.1.20905.0, version shipped with VS 2012: 11.1.20627, initial version: 11.1.20225.0 Download it here. Also updated is … Continue reading
Posted in SQLServerPedia Syndication, SSDT/Juneau
Leave a comment
SQL Server Data Tools (SSDT) – September 2012 update
SQL Server Data Tools (SSDT) has a new update (version 11.1.20905, with the previous version being 11.1.20225). The SSDT team is committed to delivering regular, frequent releases of SSDT, and this is the first in a long line of updates. This … Continue reading
Posted in SQLServerPedia Syndication, SSDT/Juneau
Leave a comment
Visual Studio 2012 does not support BI
UPDATE 3/6/13: VS 2012 now supports BI! Check out Microsoft SQL Server Data Tools – Business Intelligence for Visual Studio 2012 In the same vein as my post Watch out, Visual Studio 2010 does not support BI, Visual Studio 2012 does … Continue reading
SSDT – Installation confusion
SQL Server Data Tools (SSDT) is a Business Intelligence Development Studio (BIDS) replacement, meaning it has a suite of Visual Studio 2010 add-in tools for building Integration Services (SSIS), Analysis Services (SSAS) & Reporting Services (SSRS) solutions (let’s call that … Continue reading
Posted in SQLServerPedia Syndication, SSDT/Juneau
14 Comments
SQL Server 2012 and other PASS announcements
Some announcements and notes from SQL PASS Summit 2011, going on this week: It was announced that the official name of the SQL Server “Denali” product is SQL Server 2012 and will be released in the first half of the year 2012. There … Continue reading
