PASS Presentation – Team Edition for Database Professionals

I am honored and so excited to be presenting a couple sessions at the PASS Summit in Denver next month! One presentation is entitled Applied Team Edition for Database Professionals. The focus is TEDP in action for database development. I cover a lot of the material in my Testing the Database chapter of the new Wrox book: Professional …
Continue reading PASS Presentation – Team Edition for Database Professionals

PASS Presentation – SSIS Development And Testing

I am honored and so excited to be presenting a couple sessions at the PASS Summit in Denver next month! One presentation is entitled Integrate Your SSIS Development. The focus is on SSIS development and testing. I touch on continuous integration and test-first development – using Team Foundation Server for the CI and Team Edition for Database Professionals to …
Continue reading PASS Presentation – SSIS Development And Testing

Everything Scales

The tune to a Bush song is running through my head as I type this… the band, not the president – although imagining the President singing the song is an interesting brain-stretch. It’s a fact of IT life that everything scales. Some successfully, even. Problems start when things do not scale successfully (or well). It …
Continue reading Everything Scales

Bad IT Project Management

My sister-in-law recently passed the PMP certification (congratulations Heather!). I’m waiting for a call from her asking if we need to add resources. The resources comment above is a joke, but it isn’t really that funny. It’s indicative of my decades of experience with bad IT project managers. I believe and hope I have worked …
Continue reading Bad IT Project Management

SSIS Design Pattern – ETL Instrumentation, Part 1

Introduction   SSIS is a fantastic ETL engine. When I build an ETL solution in SSIS, I like to collect runtime metrics. Why? I use the data initially to determine a baseline for performance and to determine, in some cases, if I’m loading within a defined window.   I refer to this process of collecting performance and runtime metrics as ETL …
Continue reading SSIS Design Pattern – ETL Instrumentation, Part 1

Iteration = Maturity

Introduction  I was recently reminded that iteration matures software. The History of Andy, Part 1  Like many DBAs, I was a software developer in another life. I built web applications – working my way up from HTML through DHTML and finally to ASP – and could regale (and bore) you young whipper-snappers with war-stories of …
Continue reading Iteration = Maturity

SSIS Design Pattern – Dynamic SQL

Introduction I sometimes miss the ActiveX task in DTS. It was cool because “if you could see it, you could change it.” I used the ActiveX Task to generate dynamic SQL. When To Use Dynamic SQL In SSIS There are lots of uses for dynamic SQL in SSIS. If you find yourself using the same SQL statements …
Continue reading SSIS Design Pattern – Dynamic SQL

A Follow-up to Database Professionals: An Enterprise Requirement

Eric Wise drew some heat from the developer community at CodeBetter.com with this post about the need for a DBA during development (see my post on the subject here). I think Eric makes a couple good points, one explicit, one implied: 1. (Explicit) A DBA – or Database Developer, more accurately (and there is a difference) – adds …
Continue reading A Follow-up to Database Professionals: An Enterprise Requirement

Database Professionals: An Enterprise Requirement

A friend (who shall remain nameless) recently told me his company interviewed a competent database developer and DBA. All seemed in agreement an offer would be forthcoming until the very end of the recruiting process. At that time, someone made the comment “we don’t need a DBA.” It would be notable if this sentiment wasn’t so …
Continue reading Database Professionals: An Enterprise Requirement