Welcome to EMC Consulting Blogs

Browse by Tags

• SQL
• SQL Server
• SQL Server 2008

• 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

• 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