About James Serra
I am a SQL Server MVP and 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, check out my consulting page or 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
- SQL Server Agent job steps vs SSIS
- IT books that should be on your shelf
- PASS BA Conference 2014: Sessions Recordings Now Available
- Presentation slides for Modern Data Warehousing
- Presentation slides for Houston SQLSaturday
- Presentation Slides for Building an Effective Data Warehouse Architecture
- SQLSaturday in Houston
- Hadoop and Data Warehouses
- Presentation Slides for Modern Data Warehousing
- Modern Data Warehousing Presentation
Recent Comments
- Steve Neumersky on SQL Server Agent job steps vs SSIS
- SQL Server Agent job steps vs SSIS - SQL Server - SQL Server - Toad World on When to use T-SQL or SSIS for ETL
- Rafael Barros on MDS: Copying models and data to another server
- Greg Sharrow on Can you query a SSAS cube while it is processing?
- Cheryl on SQL Server Data Tools BI (SSDT-BI) for SQL Server 2014
Archives
- July 2014 (2)
- June 2014 (1)
- May 2014 (6)
- April 2014 (3)
- March 2014 (6)
- February 2014 (8)
- January 2014 (7)
- December 2013 (8)
- November 2013 (8)
- October 2013 (10)
- September 2013 (10)
- August 2013 (12)
- July 2013 (9)
- June 2013 (10)
- 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
- Hadoop
- Introduction
- KPI
- MDS/MDM
- MDX
- Microsoft
- PASS
- PDW
- PerformancePoint
- Power BI
- Power Map
- Power Pivot
- Power Query
- Power View/Project Crescent
- 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 2013
- Visual Studio vNext
- White Paper
- Windows 8
Top Posts & Pages
- Consultants: 1099 or W-2?
- Why You Need a Data Warehouse
- Salaried employee vs contractor
- Consultants: Corp-to-Corp vs 1099
- SSDT - Installation confusion
- SQL Server 2012 (“Denali”): T-SQL Enhancements
- SSIS package taking forever to load when you open it?
- Microsoft SQL Server Parallel Data Warehouse (PDW) Explained
- Improving cube processing time
- Data Warehouse Architecture - Kimball and Inmon methodologies
Favorite Blogs
Meta
I’m a SQL Server MVP
I’m a Rockstar Blogger
Category Archives: Visual Studio 2010
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
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
BIDS Helper 1.6 for SQL Server 2012 released
BIDS helper is Visual Studio add-in with features that extend and enhance the functionality of the SQL Server 2005 and SQL Server 2008 BI Development Studio, and now supports SQL Server 2012 (including tabular mode) and Visual Studio 2010 (SSDT). Version 1.6 … Continue reading
Posted in SQLServerPedia Syndication, SSAS, SSIS, SSRS, Tools, Visual Studio 2008, Visual Studio 2010
1 Comment
SQL Server 2012 (“Denali”): SQL Server Data Tools (SSDT), codename ‘Juneau”
SQL Server Data Tools (SSDT), codename “Juneau”, is the name for the new SQL Server Development Tool to be released along with the next version of SQL Server 2012, codenamed “Denali“. Its purpose is to provide a single development environment for … Continue reading
Watch out, Visual Studio 2010 does not support BI
When Visual Studio 2010 was released about a year ago, I was very excited and wanted to quickly open up a SSAS project created in VS 2008 to see the new features that were available in VS 2010. So I copied … Continue reading