Database Design: 3-State Bits

I can hear you thinking, “Andy, you’re off your old rocker. There are only two states for bit values!” And you are correct. Almost. What if I’m storing a truly binary value – a value that possesses only two possible states – but there’s the possibility of a third state to indicate that I do …
Continue reading Database Design: 3-State Bits

Real World SSIS: A Survival Guide, 8 May, Baltimore

My friend and fellow Linchpin, Tim Mitchell (blog | @Tim_Mitchell) will deliver a day-long seminar titled Real World SSIS: A Survival Guide the day before SQL Saturday – Baltimore (9 May). Attend and learn more about: Handling warnings, errors, and other bad stuff Data cleansing using SSIS, T-SQL, and DQS More than just a green …
Continue reading Real World SSIS: A Survival Guide, 8 May, Baltimore

Software Economics and Testing

“There are two types of developers: those who test their software and those who will.” – Andy, circa 2015 It’s April Fool’s Day in the US, but I’m going to act like it’s Halloween. Software testing is no joke, and not testing should scare you. In 1996 (yes kids, years used to begin with a …
Continue reading Software Economics and Testing

Varigence Announces Biml Hero Certification

“Do we get a super suit?” was Kent Bradshaw’s first response after reading the Biml Hero announcement from Varigence. Short answer: Yes. Well, not an entire suit, “a complementary Biml Hero t-shirt, polo, and jacket.” (Sorry Kent, no capes… yet…) But cool! From Varigence’s press release: Earning the Biml Hero certification will not be easy; …
Continue reading Varigence Announces Biml Hero Certification

If Your Name Were a Verb

Like my maternal grandfather, Buck Mayhew, did for his grandchildren; my friend Brian Kelley (blog | @kbriankelley) gives his children nicknames. A member of an SSIS team where I once worked was known for his tendency to rewrite SSIS packages. Any package, partially complete, assigned to him would be summarily replaced. It didn’t matter how …
Continue reading If Your Name Were a Verb

Biml: An Official Topic for PASS Summit 2015 Presentations

I have waited (again) until the last minute to submit presentations for the PASS Summit. I’m submitting “Using Biml as an SSIS Design Patterns Engine” – a presentation based on a chapter in SSIS Design Patterns and Levels 2-4 of the Stairway to Biml – and I am pleasantly surprised to see Biml included in …
Continue reading Biml: An Official Topic for PASS Summit 2015 Presentations

Announcing SSIS Design Patterns Training in London 7-10 Sep 2015!

I am honored to work alongside TechniTrain to deliver SQL Server Integration Services Design Patterns in London 7-10 Sep 2015! Register before 31 Mar to save £100. Who is it for? The target audience for this course is intermediate SQL Server Integration Services developers (or quick learners) who wish to learn best practices and design …
Continue reading Announcing SSIS Design Patterns Training in London 7-10 Sep 2015!