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

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

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

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

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

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

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

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

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