About James Serra
I am a big data and data warehousing solution architect at Microsoft. Previously I was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. I am a prior SQL Server MVP with over 25 years of IT experience.Follow Me!
Subscribe by email
-
Recent Posts
- Cortana Intelligence Solutions
- Making sense of Microsoft technology
- The art of possible with the cloud
- SQL Server 2016 real-time operational analytics
- Azure SQL Database new performance level
- Azure SQL Database vs SQL Data Warehouse
- What is the Lambda Architecture?
- Multi-tenant databases in the cloud
- Azure SQL Data Warehouse is now GA
- Virtualization does not equal a private cloud
Recent Comments
- Srikant on Operational Data Store (ODS) Defined
- Azure SQL Database pricing – Cloud Data Architect on Cross-database queries in Azure SQL Database
- Really in deep trouble Memory Error allocation Failure on What happens when a SSAS Tabular model exceeds memory?
- Making sense of Microsoft technology – Cloud Data Architect on Relational databases vs Non-relational databases
- Making sense of Microsoft technology – Cloud Data Architect on Azure SQL Database vs SQL Data Warehouse
Archives
- September 2016 (3)
- August 2016 (4)
- July 2016 (3)
- June 2016 (2)
- May 2016 (5)
- April 2016 (4)
- March 2016 (5)
- February 2016 (5)
- January 2016 (2)
- December 2015 (2)
- November 2015 (1)
- October 2015 (1)
- September 2015 (2)
- August 2015 (3)
- July 2015 (3)
- June 2015 (1)
- May 2015 (5)
- April 2015 (2)
- March 2015 (1)
- February 2015 (5)
- January 2015 (2)
- December 2014 (2)
- November 2014 (4)
- October 2014 (2)
- September 2014 (1)
- August 2014 (3)
- 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
- Azure
- Azure SQL Database
- Azure SQL DW
- Big Data
- BISM
- Blog
- Business Intelligence
- Career
- Certification
- Cloud
- Columnstore indexes
- Consulting
- Cortana Intelligence Suite
- Data Lake
- Data warehouse
- DAX
- Dimensions
- DNS
- DQS
- ETL
- Excel
- Fast Track
- Fuzzy Lookup
- Hadoop
- Introduction
- KPI
- MDS/MDM
- MDX
- Microsoft
- PASS
- PDW/APS
- 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 Server
- SQL Server 2012
- SQL Server 2014
- SQL Server 2016
- 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
- Relational databases vs Non-relational databases
- Why You Need a Data Warehouse
- Data Warehouse Architecture - Kimball and Inmon methodologies
- Consultants: 1099 or W-2?
- Difference between ETL and ELT
- Why use a SSAS cube?
- Entity Data Modeling with Visual Studio
- Operational Data Store (ODS) Defined
- SSIS 2012: Empty toolbox?
- SSDT - Installation confusion
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