February 17th, 2012 
Periodically Microsoft refreshes their BI Demo virtual image that contains a fully configured instance of their latest BI tools with demo data. Last week they made the latest version available for download. They are calling it BI Image X and it contains SQL 2012 RC0 and it is available here. This one contains the new [...]
Archive for February, 2012
Integration Services EzAPI Updated to Support SQL 2012
Just got word from Matt Masson on the SSIS development team that EzAPI has been updated to support SQL 2012. This is greate news! I have been using EzAPI for the last couple of months and I am very satisfied with it as an API for SSIS that allows me to focus on solving the [...]
Posted in Development, Integration Services, SQL Server 
Tags: Development, EzAPI, SQL Server, SSIS 
Comments OffIndex of all SQL Server build numbers since 7.0 Beta
Stumbled across a nice SQL Server build number site a while back that has a comprehensive (I think?) list of every SQL Server build from the SQL 7 beta 3 up through SQL 2012 RC1 including every CU and hotfix along the way. There is also a link to download the KB that corresponds to [...]
#Meme15 Assignment #3 – Why and how Jason uses LinkedIn?
I saw Jason Strate’s (Blog|Twitter) recent call out for the February #Meme15 assignment, “Why and how you use LinkedIn?”, so I figured I’d chime in. “Why I use LinkedIn?’ Simply put, it is my online resume. While I try to update an actual resume in MS Word, having my information on LinkedIn allows me one [...]
101 LINQ Samples Published by Microsoft
While trying to work through various problems in LINQ that I could easily solve in T-SQL, I found a sample at code.msdn.microsoft.com (I hadn’t seen that sight before, but seems like a potential gold mine). It is called 101 LINQ Samples and at the time of this writing is the 3rd most popular download on [...]
Lync 2010 Web Presentations and Video Scaling
One of the biggest frustrations with Microsoft Live Meeting 2005/2007 is that there is no scaling built in to the screen share capabilities. If the presenter is running 1920×1080 and clients are running 1280×720 the presenter is not notified, but the viewers will not see the entire screen and instead have to scroll. We are [...]
A Better Starting Point for .Net Console Applications
Often when prototyping .Net applications, I end up starting with a console app (as things get more complicated or require interactivity, I move to Windows forms). It takes about 1 minute to get up and running with a console app. . . unless you want to start passing fancy parameters and things like that. It [...]
Using an Entity Framework Data Model in Multiple Projects
I’m starting to dig into Entity Framework 4 as part of a project that I am working on. It is great, much easier than the old school data access methods in terms of getting up and running (it takes about 3 minutes). There are a lot of articles out there, but I have still had [...]
Editing Existing SSIS Package via EzAPI or Standard SSIS API Doesn’t Update Layout in BIDS
As part of a project I am working on that requires me to programmatically alter existing packages, I ran into an annoyance (bug?) in SSIS that makes it hard to open packages after altering them. The Problem During an exchange on Codeplex forums with Matt Masson from the SSIS team, he summarized the workflow as [...]
Posted in Development, Integration Services, SQL Server Tags: .NET, BIDS, C#, EzAPI, SSIS Comments Off