I received an email from a database professional asking about re-executable T-SQL. I directed the developer to my series at SQL Server Central on Test-Driven Development: An Example of Test-Driven Development An Example of Test-Driven Development, Part 2 An Example of Test-Driven Development, Part 3 An Example of Test-Driven Development, Part ...

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 ...

Microsoft announces the release of Visual Studio Team System 2008 Team Foundation Server Power Tools! From the website: Team Foundation Server Power Tools includes the following tools: Team Foundation Power Tool command-line tool (TFPT.EXE) Build Notification Process Template Editor Custom Check-In Policy Pack Team Foundation Server ...

I'd like to thank the people that attended my sessions at the 2007 PASS Summit in Denver this week! I had a blast and hope you all did as well. The code will be available from the PASS website and on a DVD. For those in my sessions, I promised I would post the code here for my custom Counts test condition for Team Edition for Database ...

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 ...

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 how things ...

This re-post from my Applied Team System blog (which was a repost from my old SQL Server Central blog) was inspired by James Luetkehoelter's Agile Development and the ''DBA'' post a few days back. I'll have more to say about database developers, agile methodologies, and the need for a DBA in posts to ...