Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

James Serra's Blog

James is a big data and data warehousing technology specialist at Microsoft. He is a thought leader in the use and application of Big Data technologies, including MPP solutions involving hybrid technologies of relational data, Hadoop, and private and public cloud. Previously he was an independent consultant working as a Data Warehouse/Business Intelligence architect and developer. He is a prior SQL Server MVP with over 30 years of IT experience. James is a popular blogger (JamesSerra.com) and speaker, having presented at dozens of PASS events including the PASS Business Analytics conference and the PASS Summit. He is the author of the book “Reporting with Microsoft SQL Server 2012”. He received a Bachelor of Science degree in Computer Engineering from the University of Nevada-Las Vegas.

Archives: December 2012

PASS Summit 2012 session videos online

If you are interested in viewing the recorded sessions for the PASS Summit 2012, you can order them on a USB flash drive or view them online.  You can purchase the Regular Summit Sessions as well as the Pre-Conference Sessions.  However, if you are interested in the sessions from 2011… Read more

0 comments, 1,525 reads

Posted in James Serra's Blog on 27 December 2012

Introduction to Microsoft’s Master Data Services (MDS) Presentation Slides

Thanks to everyone who attended my “Introduction to Microsoft’s Master Data Services (MDS)” for the Data Architecture Virtual Chapter.  The recording of the session is available here.

Here is the PowerPoint presentation: Introduction to Microsoft’s Master Data Services (MDS)

I had some excellent questions at the end of… Read more

2 comments, 924 reads

Posted in James Serra's Blog on 21 December 2012

PASS SQLRally Nordic 2012 videos online

All the videos for the sessions at PASS SQLRally Nordic 2012 are available for free.  Lot’s of great BI info.  Check the videos here.  Enjoy!

Read more

0 comments, 629 reads

Posted in James Serra's Blog on 20 December 2012

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 such as datadude, DBPro, teamdata, TSData and Visual Studio Team… Read more

5 comments, 4,212 reads

Posted in James Serra's Blog on 18 December 2012

Introduction to Microsoft’s Master Data Services (MDS) Presentation

I will be presenting the session “Introduction to Microsoft’s Master Data Services (MDS)” at the Data Architecture Virtual Chapter on Thursday, Dec 20th, at Noon CST.  Below is the abstract.  It will be a remote presentation that you can join online.  Details are here.  I hope you can make… Read more

0 comments, 578 reads

Posted in James Serra's Blog on 17 December 2012

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: 11.1.20225.0

Downloads: For Visual Studio 2010, For… Read more

0 comments, 1,156 reads

Posted in James Serra's Blog on 14 December 2012

Solution to VSTA editor error in SSIS 2012

The script task in SSIS 2012 is a great tool when you need to use C# or VB code to perform a function that is not possible with the other SSIS built-in tasks.  It uses Visual Studio Tools for Applications (VSTA).  One of the limitations when using the script task… Read more

0 comments, 2,483 reads

Posted in James Serra's Blog on 13 December 2012

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 2008 projects and save it as 2008 versions (avoiding having… Read more

0 comments, 1,924 reads

Posted in James Serra's Blog on 11 December 2012

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 SSDT Power Tools.  Download it here Read more

0 comments, 2,099 reads

Posted in James Serra's Blog on 6 December 2012