Welcome to EMC Consulting Blogs

Browse by Tags

• Katmai
• SQL
• SQL Server 2008

• UPDATE FROM the Sybase code museum

  UPDATE FROM is dead … or it should be. Hugo Kornelis has done a good job of explaining why. Apart from a badly thought out and non-portable syntax, UPDATE FROM suffers a notorious bug/feature. I say “notorious” but it’s probably not notorious enough because Read More... Posted 24 June 2009 22:57 by David.Portas | 0 Comments Filed under: SQL, SQL Server

• SQL Server 2008 RTM

  SQL Server 2008 is out! All editions are on MSDN now except for Express, which should hopefully follow soon. Enjoy! Read More... Posted 06 August 2008 19:29 by David.Portas | 1 Comments Filed under: SQL Server, Katmai, SQL Server 2008

• Update on T-SQL MERGE

  The MERGE syntax I used here has changed. In 2008 RC0 the "WHEN SOURCE NOT MATCHED" clause is replaced with "WHEN NOT MATCHED BY SOURCE" which is supposed to make the meaning clearer. Although MERGE is part of standard SQL 2003 it's worth noting that Read More... Posted 09 June 2008 18:21 by David.Portas | 0 Comments Filed under: SQL, SQL Server, Katmai, SQL Server 2008

• SQL Server 2008 RC0

  SQL Server 2008 Release Candidate 0 (build 10.0.1442.32) was released to MSDN and TechNet subscribers on Friday. It should be available to everyone else very soon via the Connect site. http://msdn.microsoft.com/en-us/subscriptions/default.aspx http://technet.microsoft.com/en-us/subscriptions/default.aspx Read More... Posted 09 June 2008 17:50 by David.Portas | 2 Comments Filed under: SQL Server, Katmai, SQL Server 2008

• SQL Server 2008 November CTP

  CTP5 is available today! http://www.microsoft.com/downloads/details.aspx?FamilyId=3BF4C5CA-B905-4EBC-8901-1D4C1D1DA884 Jamie has already blogged about some of the new goodies in CTP5, which include Intellisense for Management Studio. Also new in this Read More... Posted 19 November 2007 18:37 by David.Portas | 0 Comments Filed under: SQL Server, Katmai, SQL Server 2008

• SQL Server 2008 MERGE

  MERGE is a new DML statement in SQL Server 2008. Microsoft have implemented the ISO SQL 2003 and 2007 standard MERGE statement (as seen in Oracle and DB2) and added some extensions of their own. In a nutshell, MERGE allows you to perform simultaneous Read More... Posted 14 November 2007 21:52 by David.Portas | 3 Comments Filed under: SQL, SQL Server, Katmai, SQL Server 2008

• A note on Updateable CTEs

  One of my regular gripes about SQL Server concerns the number of Transact SQL features that give nondeterministic results. Unfortunately SQL Server 2005 added to the list of those. One of the new ones is ROW_NUMBER(), which is strictly due to ANSI/ISO Read More... Posted 26 July 2007 21:47 by David.Portas | 2 Comments Filed under: SQL, SQL Server

• SQL Server 2008 June CTP

  The Katmai CTP goes public today. The download hasn't appeared on Connect yet but the link is here: http://connect.microsoft.com/sqlserver Microsoft is previewing Katmai at TechEd and there is also a webcast you can join from the TechEd site: http://www.microsoft.com/events/series/teched07.asp Read More... Posted 04 June 2007 15:16 by David.Portas | 0 Comments Filed under: SQL Server, Katmai

• SQL Server 2008

  Microsoft have officially announced their intention to have Katmai available in 2008. (The title of this post is nothing more than idle speculation. Katmai doesn't have an official name yet.) http://www.microsoft.com/presspass/press/2007/may07/05-09KatmaiPR.mspx Read More... Posted 09 May 2007 17:57 by David.Portas | 2 Comments Filed under: SQL Server, Katmai

• MVP Summit, SQL Server "Katmai"

  Last week I was at the MVP Summit in Seattle and Redmond, mainly learning about "Katmai" - the next version of SQL Server - from the SQL Server development team. The details of Katmai aren't in the public domain yet but some of the key themes Read More... Posted 25 March 2007 10:14 by David.Portas | 0 Comments Filed under: SQL Server