Kirk Haselden's Kirkapedia

Contract SSIS Developer

2013-03-27T18:55:47Z

Anyone here interested in a contract role with Blackbaud to develop a repeatable transformation solution using SSIS? Please contact me if you have availability this quarter. Kirk.Haselden@Blackbaud.com...(read more)

Sample Code for the SSIS Book

2012-11-27T18:53:00Z

Yes, I know I’ve been gone for a long time. I haven’t professionally blogged for years. But, the good folks here, Adam and Peter have out of the goodness of their hearts, left my blog around and well, I though I’d check in. Since then, I’ve changed jobs, gotten divorced, bought a few more laptops, bunches of guitars, a snowboard or two, iPads, iPhones, a few cars, travel to India, Europe, Middle East, backpacked Scotland (and still damp), Nepal and all over the US. I’m three roles away from the SSIS...(read more)

New Master Data Services Content (What Else?!)

2010-03-16T15:29:26Z

msdev is about to launch a series of training courses for Master Data Services that covers early concepts, setup, model building, configuration, security model setup and the object model. This should be a great series and promises to be a solid introduction to the product. http://www.msdev.com/Directory/SeriesDescription.aspx?CourseId=155 If you haven’t noticed lately, there is a great set of entries up on the SSIS team blog now. These are quality blog entries that really get into the details of...(read more)

Profisee Webinar

2009-12-21T17:57:00Z

For those of you wanting more information about Master Data Services, in 2010, Profisee is starting a series of webinars that should be great. Here’s the first one: http://www.profisee.com/newsevents/tabid/134/Default.aspx Merry Christmas and a Happy New Year!...(read more)

Master Data Services team blogging

2009-12-14T19:15:00Z

In a recent blog I mentioned that the Master Data Services team would be blogging soon. Matt Anderson has started and this should be a great resource for readers wanting to come up to speed on MDS quickly. We're planning some high level as well as in-depth blogging there. If you are interested in better understanding the newest addition to the SQL Server toolset, be sure to add this link to your blogroll! http://sqlblog.com/blogs/mds_team/archive/2009/12/14/welcome-to-the-sql-server-master-data-services-team-blog.aspx...(read more)

MDS Staging table error codes

2009-11-25T22:17:00Z

These kinds of things always seem to be the last to be added to the documents. I saw in a recent blog post that someone had gotten a staging table error and they weren't sure what it was. Here are the staging table error codes thanks to our great support engineer Pam Matthews ERR210000 OK ERR210001 Error - duplicate code in source data. ERR210003 Error - code does not exist or has been deactivated for selected domain attribute. ERR210004 Error - code does not exist for selected domain attribute....(read more)

Master Data Services miscellaneous

2009-11-25T20:16:00Z

As we head into the US holiday season, I wanted to catch up on some things I've wanted to blog for some time. Blogs Rolling First of all, it's good to see some blogging activity around MDS. As is the usual case around the first release of a product, it takes some time for blog activity to get momentum. But, we're beginning to see some action now as folks pick up the November CTP of SQL Server R2 and start to put it through it's paces. This one by Nick Barclay is a series of seven introducing MDS...(read more)

SQL Server 2008 Master Data Services November CTP Released

2009-11-09T20:21:00Z

Well, that's certainly a mouth full. I’m pleased to say that the SQL Server November CTP with Master Data Services is now available. http://www.microsoft.com/sqlserver/2008/en/us/R2.aspx If you’re interested in simply seeing the MDS documentation, you can find it here: http://msdn.microsoft.com/en-us/library/ee633763(SQL.105).aspx...(read more)

MDS Branding

2009-10-02T20:03:00Z

The branding is in. MICROSOFT SQL SERVER 2008 R2 MASTER DATA SERVICES, MONTH COMMUNITY TECHNOLOGY PREVIEW ( MONTH CTP) Where MONTH is the actual release month. Hooo! What a mouthful....(read more)

Master Data Services almost there...

2009-09-04T13:59:00Z

It's been a while since my last post so wanted to take some time and update folks on what's happening around Master Data Services. A little history To catch everyone up, I thought I'd start by giving a short history of the product and get everyone on the same page. In June, 2007 Microsoft acquired a company called Stratature. It was a small but well run company that built an analytical master data management solution. At the time, we were looking for a good solution to augment the PerformancePoint...(read more)

Master Data Services a new product in SQL Server

2009-05-13T22:35:00Z

As announced at TechEd earlier this week, Master Data Services will be shipping in SQL Server 2008 R2. I've blogged on SQL Insiders about it here: http://blogs.technet.com/dataplatforminsider/default.aspx I'm glad I can be out of the SQL Server closet again and finally say in public, "It's good to be back in SQL Server!"...(read more)

Whence Microsoft's Master Data Management Product?

2009-04-14T21:54:00Z

A while back I blogged about the Technology Preview for the Master Data Management product that we released to just about anyone that was interested. That was very early in the project and right after we had acquired the Stratature company. The preview was a success. In fact, we've had great response to it and many customers have actually used the preview edition in pre-production implementations and giving us great reports and feedback. Microsoft is also using the product for several internal implementations....(read more)

What's Going on Kirk?

2009-04-08T18:35:00Z

I've been vacant from blogging for some time. If the comments I've been getting in the blog, email and personally at conferences and in meetings is any indication, it's high time I started back again. Unlike some of the more successful and prolific bloggers out there, or those that aren't so prolific for that matter, I have no aspirations of consistently writing every day. The old blogging mantra "every day a blog entry" is not something I'm going to commit to doing. That way I set myself up for...(read more)

Fairfield/Westchester.Net User Group

2007-11-21T08:22:00Z

Last week I had the opportunity to speak to a user group about SQL Server and in particular Integration Services. It was a nice opportunity to clear out the cob webs and talk about one of my favorite topics. https://www.clicktoattend.com/invitation.aspx?code=122496 Initially, it wasn't going so well. I've found that the audiences vary for these events drastically. The closer one gets to Redmond, the more up to date the audience is on newer technologies. So, it's good to do a gut check sometimes and...(read more)

Surprise! MDM Technology Preview available tomorrow

2007-11-21T07:49:00Z

In a recent post I stated that we planned to have a technology preview available in February, '08. Most folks aren't used to hearing these words in the same sentence, but here goes: We're shipping early. Tomorrow I'll be sending out email to customers and partners alerting them to the availability of the technology preview (TP) for download from MSConnect. If you'd like to participate in the technology preview and haven't done so already, you can express interest by sending an email with "Interested...(read more)