Category:Uncategorized

Part 1 I grew up poor – the US version of poor. We never missed a meal but a few times it was only because we had a successful hunt. Suffice it to say that when we interacted with others, they always had more than us. More stuff, nicer houses and cars and toys. We …
Continue reading Me and the Man

An Overview of SSIS Parameters – Level 15 of the Stairway to Integration Services is now live at SQL Server Central! Enjoy! :{>

SQL Saturday #277 is going to be held 22 Mar 2014 in Richmond Virginia! There will be three day-long pre-conference sessions on Friday 21 Mar: Performance Tuning and Troubleshooting Like a Pro by Robert L. Davis (@sqlsoldier) Murder They Wrote by Wayne Sheffield (@DBAWayne) and Jason Brimhall (@sqlrnnr) SSIS Design Patterns by me (@AndyLeonard) You …
Continue reading SQL Saturday 277–Richmond Precons Are 21 Mar 2014!

I am excited to be presenting Using BIML as an SSIS Design Patterns Engine at SQL Saturday #241 – Cleveland on Saturday 8 Feb 2014! If you’re going to be in the Cleveland area, check out these smart presenters (plus me!) and consider attending! Register here. I hope to see you there! :{>

I am honored to present “I See A Control Flow. Now What?” at SQL Saturday Nashville on Saturday 18 Jan 2014! There are a bunch of really cool presentation scheduled, including a few Linchpins! I hope to see you there! Register here. :{>

I am about to break one of the rules of this blog. Years ago, I decided to never write about things that happen with clients until at least one year had passed. I am going to make an exception and write about something that happened very recently in the first part of this post. I …
Continue reading A Mistake, Responding Well, and a Public Call for a Public Apology

I am honored to present Using Biml as a Design Patterns Engine to the Midlands PASS Chapter Thursday 9 Jan 2014! Summary: Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns, demonstrates the flexibility of BIML in this session. …
Continue reading Presenting Using Biml as a Design Patterns Engine to Midlands PASS 9 Jan 2014!

When: Thursday, December 12th, 2013, 6:30 PM – 8:00 PM Social Time starts at 6:00 PM! SQL Server Extended Events Microsoft is deprecating Trace and Profiler, a staple for monitoring SQL server since forever, in favor of Extended Events, introduced in SQL 2008. Monitoring of some of the new features like AlwaysOn Availability Groups in …
Continue reading RichmondSQL Meeting Tonight! (12 Dec 2013) – Az Arunachalam on Extended Events

SQL Saturday #277 – Richmond Virginia will be held 22 Mar 2014. Last year’s event was awesome, thanks to the hard work of the volunteers, contributions of speakers, and participation of the RichmondSQL community! I expect this event to be equally (or more!) awesome. The call for speakers remains open until 21 Jan 2014 and …
Continue reading SQL Saturday #277–Richmond Virginia: 22 Mar 2014

John Sansom (Blog | @SqlBrit) is committed to sharing “what I believe it takes to be an outstanding Data Professional.” To that end, John shepherded a book project called DBA JumpStart. The concept of the (free!) e-book is: “If you could give a DBA just one piece of advice, what would it be?” The list …
Continue reading Great Advice (and Free!): DBA JumpStart