Tod1d's Thought Process

Browse by Tags

• Continuos Integration
• knowledge base

• What's Your Database Versioning Process?

  If you are not putting your database objects under source control, you should check out this article by Jeff Atwood . I have been investigating several methods and tools for database version control and I think I am going to settle on something as simple Read More... Posted Monday, February 25, 2008 5:17 PM by Tod Birdsall | 5 Comments Filed under: SQL Server

• How-To : Search table column names in SQL Server database

  Problem I have a SQL Server 2000 database with 50 tables. One of the tables is called Person and the primary key in that table is PersonID. I want to find out how many other tables reference the PersonID. Solution I used the following T-SQL code to search Read More... Posted Thursday, February 07, 2008 7:00 AM by Tod Birdsall | 2 Comments Filed under: SQL Server

• Article of the Week: Three Rules for Database Work

  Article: Three Rules for Database Work Author: K. Scott Allen Description: Short article on why database versioning is worthwhile. This article begins a whole series of articles on database versioning. They should come in handy while we continue to progress Read More... Posted Tuesday, February 05, 2008 7:05 AM by Tod Birdsall | 4 Comments Filed under: SQL Server, Continuos Integration

• How-To: Auto-Generate SQL 2000 Database Creation and Alteration Scripts

  I recently changed jobs and I am working with the rest of the software development team to streamline our deployment process. My primary focus, past few weeks has been in the area of database continuous integration. Yesterday I did my first push of one Read More... Posted Friday, January 25, 2008 6:28 AM by Tod Birdsall | 21 Comments Filed under: SQL Server, Continuos Integration

• Save Change Script Dialog: How to automatically generate SQL change scripts

  For some reason I had forgotten about the Save Change Script Dialog Box ; an excellent tool that automatically generates Microsoft SQL 2000 change scripts for you. I am trying to script out all SQL 2K DB changes, to make the migration of SQL 2K database Read More... Posted Wednesday, January 16, 2008 5:00 PM by Tod Birdsall | 2 Comments Filed under: SQL Server

• Managing SQL Server 2000 Transaction Log Growth

  I ran into a problem with one of my database's transaction logs growing to nearly 30 gigs on a 60 gig hard drive. Yikes! I have run into similar issues over the years and have never quite figured out what the root of these issues have been. The following Read More... Posted Tuesday, August 28, 2007 4:11 PM by Tod Birdsall | 15 Comments Filed under: knowledge base, SQL Server