Red Gate rocks. If you didn’t know that already, you know it now. The latest evidence to support this claim is the publication of the schedule for US SQL in the City events. They are: 9 Oct – Pasadena 11 Oct – Atlanta 14 Oct – Charlotte Registration for these events opens 24 May. :{>

When: October 15, 2013 8:45 am - 4:45 pm Charlotte, NC Where: Wake Forest University Charlotte Center 200 North College Street Charlotte, NC 28202 What: Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your time. Come see why BI professionals ...

Matt Masson and I are co-presenting Developing Extensions for SSIS 22 May 2013 at 11:00 AM EDT. If you’ve never heard Matt present, you are in for a treat. Matt is knowledgeable (he helped build Integration Services 2012!) and entertaining. This is going to be a good one, folks! Abstract Join Matt Masson and Andy Leonard for a discussion and ...

Let’s begin with an assertion: “People are more important than process.” – Andy, circa 2008 Whenever an enterprise or institution adopts a new process or policy, that policy should serve people and not shackle them. The nicest thing that can be said about a policy that binds people is, “It wasn’t well thought out.” It’s a bad idea, in other ...

In his article Healthcare's Big Problem With Little Data, author Dan Munro raises salient points about the state of health-related data. Electronic Health Records (EHR) were promoted as the end-all-be-all solution for the industry – a standardization that, I suppose, many thought would organically and naturally occur, stabilize, and be ...

Hi Jane,   There are a couple ways to approach this. One example is: LEFT(RIGHT(EmailAddress,LEN(EmailAddress) - FINDSTRING(EmailAddress,"@",1)),LEN(RIGHT(EmailAddress,LEN(EmailAddress) - FINDSTRING(EmailAddress,"@",1))) - 4) Hope this helps, Andy

Hi Jane,   I use an expression like: LEFT(EmailAddress,FINDSTRING(EmailAddress,"@",1) - 1)   to obtain the email recipient, and like: RIGHT(EmailAddress,LEN(EmailAddress) - FINDSTRING(EmailAddress,"@",1))   to obtain the domain information. Hope this helps, Andy

You are not blind, there was no date. I added it! :{>

Join SQL Server MVP Tim Mitchell (blog | @Tim_Mitchell) and I as we demonstrate and discuss the many uses of scripting in SQL Server 2012 Integration Services 8 May 2013 at 11:00 AM EDT! In this demo-packed session, two co-authors of the book SSIS Design Patterns share their experience using the Script Task and Script Component to accomplish ...

Thank you, Eugene! Steve: Yes! the recording is available at http://linchpinpeople.com/2013/04/medical-data-integration-with-ssis-2012-part-1-loading-claims-data/ :{>