More on Elegance in Database Design: Complexity

Introduction I wrote recently on the importance of elegance in database design (Art vs. Science). In that post I wrote “Elegance is a solution crafted to meet the need(s).” I’d like to elaborate on that point, as it is often the source of some confusion. Elegance vs. Complexity First, a couple statements: An elegant solution will be …
Continue reading More on Elegance in Database Design: Complexity

Art vs. Science

Introduction I read Phil Factor‘s Database Weekly editorial entitled Basically Available, Soft State, Eventually Consistent. I agree with Phil’s conclusions about special-purpose databases that purport to be “RDBMS killers.” Please. How Much Paint? Some argue our profession is science. I can see that. Some argue it’s a passion. I represent that remark. I consider the …
Continue reading Art vs. Science

Presenting Incremental Loads, CDC, and SSIS 2008 to Columbus SQL Server UG Tomorrow!

I’m honored to present Incremental Loads, Change Data Capture, and SSIS 2008 to the Columbus SQL Server Users Group tomorrow evening! This is the first remote presentation I’ve attempted in a while. I won’t be in physical attendance, only virtually. I’ll be in my office in Farmville, VA. Isn’t technology cool? :{> Andy

Speaking in Reston VA Monday 22 Jun!

I just learned I am presenting to NoVaSQL (Northern Virginia SQL Server User Group) Monday! Woo hoo! I’m looking forward to it – I always have a good time at NoVaSQL. I am honored and excited to present Database Development and Application Lifecycle Management – based on my articles An Example of Test-Driven Development and …
Continue reading Speaking in Reston VA Monday 22 Jun!

PASS Summit 2009 – A Tale of Careers and User Groups

I am deeply honored to present a session in the Professional Development track at the PASS Summit 2009. “Why Andy?” Because in this session I get to inspire folks! Little known fact: I was once a part-time instructor at ECPI. In fact, I was teaching a course there when I frist met Christy. The absolute coolest …
Continue reading PASS Summit 2009 – A Tale of Careers and User Groups

PASS Summit 2009 – Applied SSIS Design Patterns

A couple weeks ago, I learned my proposal for a spotlight session entitled “Applied SSIS Design Patterns” had been accpeted by the PASS Summit 2009 speaker selection committe. Cool! I’ve never done a PASS Summit spotlight session. The abstract for the presentation follows: Applied SSIS Design Patterns“Design Patterns” is more than a trendy buzz phrase; design patterns are a way of breaking down complex development …
Continue reading PASS Summit 2009 – Applied SSIS Design Patterns

PASS Summit 2009 – From Zero to SSIS

I learned a couple weeks back my proposal for a pre- or post-conference seminar entitled “From Zero to SSIS” had been selected as an alternate at the PASS Summit 2009. I was a little disappointed,  but then I looked at the incredible speakers and topics selected for pre- and post-conference seminars here.  These seminars offer a fantastic …
Continue reading PASS Summit 2009 – From Zero to SSIS

The Best Thing I Learned At PASS

I attended my first PASS Summit in 2004. I also attended a pre-conference (pre-con) led by Kalen Delaney. It was awesome! Kalen’s pre-con focused on performance tuning, and I learned a lot about both SQL Server 2000 and SQL Server 2005. The most important thing I learned was: I was not alone! There’s a whole lot of …
Continue reading The Best Thing I Learned At PASS

The Best Thing I Learned At PASS

I attended my first PASS Summit in 2004. I also attended a pre-conference (pre-con) led by Kalen Delaney. It was awesome! Kalen’s pre-con focused on performance tuning, and I learned a lot about both SQL Server 2000 and SQL Server 2005. The most important thing I learned was: I was not alone! There’s a whole lot of …
Continue reading The Best Thing I Learned At PASS

9 Jun 2009: Speaking at the SQL Server Innovators Guild in Greenville, SC!

I am honored and excited to present Database Development and Application Lifecycle Management – based on my article An Example of Test-Driven Development at SQLServerCentral.com) to the SQL Server Innovators Guild (what a cool name for a SQL Server user group!) in Greenville SC! I’ll be there the evening of 9 Jun 2009 (next Tuesday). If …
Continue reading 9 Jun 2009: Speaking at the SQL Server Innovators Guild in Greenville, SC!