Home > T-SQL > SQL Server DBMS Top 1 Wish List

 

SQL Server DBMS Top 1 Wish List

December 8th, 2009
Goto comments Leave a comment

As an addition to Teo Lachev’s Top 10 Wishlists (SSAS and SSRS), I would like to contribute only 1 item to a possible SQL Server DBMS wishlist:

1. Source Control.

Not SourceSafe source control, but rather an automated version out-of-the-box, not relying on developers to check in/out. Rather, it should track the changes to the code as they are made, and a full version history should be available directly in the DBMS. It should not be too hard. After all, there is a nice database available, which can store code with its version numbers just like anything else.

This would make a lot of developers’ lives a bit less frustrating.

OK, a SQL code “beautifier” would also be nice, but it is not all that important…

Vote on Connect

If you enjoyed this post, make sure you subscribe to my RSS feed!

Related posts:

  1. Changes in SQL Server 2008 sysadmin group
  2. Fun with T-SQL
  3. Ordering Dimensions: Recursion vs Loops in T-SQL

 

Boyan Penev T-SQL , ,

  1. Steve
    December 9th, 2009 at 00:22 | #1
    Reply | Quote

    a couple of weeks ago, I wrote a blog on this, and for now, I just did it myself, automated source control from SQL using DDL triggers

    http://blog.stevienova.com/2009/11/24/sql-server-schema-automatic-revision-history-using-ddl-triggers-and-svn/

  2. Boyan Penev
    December 10th, 2009 at 00:34 | #2
    Reply | Quote

    I guess it would work, but I still think that SQL Server needs native support for source control. Thanks for sharing.

  1. No trackbacks yet.