Category Archives: SQL Server

A handy reference can be found here: http://www.sqlteam.com/article/sql-server-versions

Just released — Download

In October 2007 I wrote a review on the T-SQL Static Analysis feature provided in the Visual Studio Team Edition for Database Professionals Power Tools. In February this year Microsoft released Version 2 of the Power Tools, Visual Studio® Team … Continue reading →

UPDATE: 16 May 08 – This is available here. I’m working on a review for Version 2 and will update my original review soon… FTD

In the middle of August 07, Microsoft released the Visual Studio Team Edition for Database Professionals Power Tools (available here). T-SQL Static Analysis is one of the features in this first release. There are fourteen rules that it currently uses … Continue reading →

Virtual PC 2007 – shipped. SQL Server 2005 SP2 – shipped. SQL Server 2005 Books Online Update – shipped. UPDATE: SQL Server 2005 Express SP2 – shipped. FTD

This blog is still active! I’m spending most of my spare time working on a SQL tool (I’ll be posting more details and the tool itself up here some time) and part of my spare time working out Windows PowerShell and … Continue reading →

No such thing unfortunately. If you have moved to SQL server 2005, your world of Enterprise Manager and SQL Query Analyzer has been replaced with SQL Server Management Studio (SSMS). This is a great new IDE, but now I need to … Continue reading →

Spending a little time planning and researching can often extend a products economically sustainable lifespan by a substantial amount. Let’s take a quick look at this from a SQL perspective in this fictional example: Project A comes along and you … Continue reading →

  I’ve got quite a bit going on at the moment, so don’t expect a post here till around the weekend… I’m putting together a Team Build DeskSheet (like the SQL 2005 Query DeskSheet). Also looking into building a subscription application … Continue reading →