Archive for the ‘SQLServer’ Category

SQL 2008 Cumulative Updates Released

Tuesday, July 21st, 2009

Two new CU updates have been released for SQL 2008

Things that stand out are:

  • [970399]  FIX: The MAXDOP option for a running query or the max degree of parallelism option for the sp_configure stored procedure does not work in SQL Server 2008
  • [969844] FIX: You receive inconsistent results when you run index-related DMVs to return statistical information about missing indexes in SQL Server 2005 or in SQL Server 2008
  • [969997] FIX: You receive an incorrect result when you query data from a linked server that is created by using an index OLE DB provider in SQL Server 2005 or in SQL Server 2008
  • [970507] FIX: Error message in SQL Server 2008 when you run an INSERT SELECT statement on a table: “Violation of PRIMARY KEY constraint ‘<PrimaryKey>’. Cannot insert duplicate key in object ‘<TableName>’”
  • [971064] FIX: Quotation marks are rendered incorrectly when you export a SQL Server 2008 Reporting Services report to a .csv file

Obviously you need to really read to understand if you have seen any of the problems the fixes address to be fully aware – and definitely don’t apply unless you need a fix!

Gareth

Microsoft SQL Services is now Microsoft SQL Azure

Wednesday, July 8th, 2009

Microsoft SQL Services is now Microsoft SQL Azure – let the rebranding process begin :-) After not initially supporting TDS the name is now changing to the Azure brand.

Microsoft is updating the branding for SQL Services and SQL Data Services. Effective immediately, SQL Services will be called Microsoft SQL Azure, and SQL Data Services will be Microsoft SQL Azure Database.

There will be more news and updates related to our Software + Services strategy next week at Microsoft’s Worldwide Partner Conference in New Orleans. For those of you not attending in person, all the news and information can be found at: http://www.digitalwpc.com/ . Check back often starting next Monday, July 13, for daily updates.

More about TSQL Support in SQL Data Services can be found here. Another announcement of this can be found at “SQL Azure – Same great platform, just a better aligned name

Apparently its a ‘Cloudy’ week :-)

Gareth

Want to install SQL2008 on Windows 2008 RC2 (or Windows 7)?

Thursday, June 25th, 2009

Unfortunately its not as simple as you would think, SQL Server 2008 install requires the .NET 3.5 framework to be installed or will install it as part of the pre-req checking.   Changes in Windows 7 can prevent SQL Server 2008 from installing the .NET 3.5 framework pre-requisite.   Instead you may need to install the framework separately using the “Run this program in compatibility mode”.  Read here for more information.

UPDATE 2009-06-29: It seems there are similar issues with SQL2005 as well, have a look SQL Server version has a known compatibility issues with Windows 7 RC. This warning is genuine and applies to all SQL Server editions, including all Express editions.

Gareth

Cumulative Update #4 for SQL Server 2005 Service Pack 3 Released

Tuesday, June 16th, 2009

Microsoft SQL Server Release Services have announced SQL 2005 CU#4 for Service Pack 3 is available here.

The full list of problems resolved in this CU can be found http://support.microsoft.com/kb/970279/en-us

Also for those running of SQL 2005 SP2 CU#14 has been released here

Gareth