Monthly 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 … Continue reading

Posted in PASS, SQL Server, SQLServerPedia Syndication, Videos | Leave a comment

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 … Continue reading

Posted in MDS/MDM, Presentation, Session, SQLServerPedia Syndication | Leave a comment

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!

Posted in PASS, SQLServerPedia Syndication, Videos | Leave a comment

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

Posted in SQLServerPedia Syndication, SSDT/Juneau, Team Foundation Server, Visual Studio 2010, Visual Studio 2012 | 5 Comments

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 … Continue reading

Posted in MDS/MDM, Presentation, Session, SQLServerPedia Syndication | Leave a comment

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: … Continue reading

Posted in SQLServerPedia Syndication, SSDT/Juneau | Leave a comment

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 … Continue reading

Posted in SQLServerPedia Syndication, SSIS | Leave a comment

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 … Continue reading

Posted in SQLServerPedia Syndication, SSDT/Juneau | Leave a comment

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 … Continue reading

Posted in SQLServerPedia Syndication, SSDT/Juneau | Leave a comment

SharePoint dependencies

Microsoft has made a big push the last few years to have all its end-user BI tools integrate with SharePoint, which is great if your company is using SharePoint.  Not so great if your company is not using SharePoint or … Continue reading

Posted in SharePoint, SQLServerPedia Syndication | Leave a comment