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
- Podcast: Big Data Solutions in the Cloud
- Cost savings of the cloud
- Podcast: Myths of Modern Data Management
- Webinar: Is the traditional data warehouse dead?
- Is the traditional data warehouse dead? webinar
- Public preview of Azure SQL Database Managed Instance
- It’s all about the use cases
- My latest presentations
- Azure Data Architecture Guide (ADAG)
- Conversations with Data Warehouse Experts – Podcast
Recent Comments
- Cloud Savings And TCO – Curated SQL on Cost savings of the cloud
- PowerBIProGuy on Cost savings of the cloud
- JRStern on Cost savings of the cloud
- Adil on Webinar: Is the traditional data warehouse dead?
- Public preview of Azure SQL Database Managed Instance - SSWUG.ORG on Public preview of Azure SQL Database Managed Instance
Archives
- April 2018 (3)
- March 2018 (4)
- February 2018 (4)
- January 2018 (1)
- December 2017 (1)
- November 2017 (3)
- October 2017 (4)
- September 2017 (2)
- August 2017 (4)
- July 2017 (2)
- June 2017 (4)
- May 2017 (4)
- April 2017 (3)
- March 2017 (6)
- February 2017 (1)
- January 2017 (2)
- December 2016 (4)
- November 2016 (8)
- October 2016 (3)
- 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 Analysis Services
- Azure Cosmos DB
- Azure Data Factory
- Azure Data Lake
- Azure Data Lake Analytics
- Azure Databricks
- 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
- HDInsight
- Introduction
- KPI
- MDS/MDM
- MDX
- Microsoft
- PASS
- PDW/APS
- PerformancePoint
- Podcast
- PolyBase
- 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
- SQL Server 2017
- 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
- Data Warehouse Architecture - Kimball and Inmon methodologies
- Consultants: Corp-to-Corp vs 1099
- Why You Need a Data Warehouse
- Operational Data Store (ODS) Defined
- Factless fact table
- Difference between ETL and ELT
- Why use a SSAS cube?
- What is Polyglot Persistence?
- Azure SQL Database pricing
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