Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

James Serra's Blog

James is currently a Senior Business Intelligence Architect/Developer and has over 20 years of IT experience. James started his career as a software developer, then became a DBA 12 years ago, and for the last five years he has been working extensively with Business Intelligence using the SQL Server BI stack (SSAS, SSRS, and SSIS). James has been at times a permanent employee, consultant, contractor, and owner of his own business. All these experiences along with continuous learning has helped James to develop many successful data warehouse and BI projects. James has earned the MCITP Business Developer 2008, MCITP Database Administrator 2008, and MCITP Database Developer 2008, and has a Bachelor of Science degree in Computer Engineering. His blog is at .

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,075 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, 707 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, 498 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, 2,844 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, 443 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, 853 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, 1,339 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,189 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, 1,237 reads

Posted in James Serra's Blog on 6 December 2012