April 5th, 2012 
I have used both the Teradata and Oracle connectors in the past. While there are some “gotcha’s” (for example you must have SQL Enterprise), overall they provide the fastest possible way to extract data from either of those two sources. v2.0 brings support for SQL 2012 and the latest releases of Teradata and Oracle, as [...]
Author Archive
Complete SQL 2012 Demo Build Script
There is no need to download the 28GB BI Image X (which at the time of this writing hasn’t been updated to SQL 2012 RTM). There are instructions on how to build an all-up SQL 2012 and SharePoint 2010 demo VM with instructions for configuring all of the latest SQL 2012 tools including DQS, MDM, [...]
Fix for Excessive VMWare Disk Activity On Host After Suspend or Shutdown
I use VMware to run 64-bit guest OS’s for development and testing on my laptop. (Windows 7 only allows 32-bit guests, Windows 8 incorporates Hyper-V so this limitation will go away soon). One of the nice benefits of running a VM is that I can suspend and bring it back online in a matter of [...]
Microsoft BI Image X: SQL 2012 RC0 Available for Download
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 [...]
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 [...]
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 [...]
