News

SQL Azure

New Features in SQL Azure

http://blogs.technet.com/b/dataplatforminsider/archive/2010/09/23/new-features-in-sql-azure-august-update.aspx

Other

SQL Server for the Oracle DBA - Free DVDs at OpenWorld

http://blogs.technet.com/b/dataplatforminsider/archive/2010/09/20/sql-server-for-the-oracle-dba-free-dvds-at-openworld.aspx

TRM

http://blogs.technet.com/trm/default.aspx

Documents

SQL 2008

Microsoft SQL Server Protocol Documentation

The Microsoft SQL Server protocol documentation provides technical specifications for Microsoft proprietary protocols that are implemented and used in Microsoft SQL Server 2008.

http://www.microsoft.com/downloads/en/details.aspx?familyid=91ef5106-944a-41e1-b3a0-5bd3f2356f32

Downloads

SQL 2005

Partial Database Availability

SQL Server 2005 features that enable appropriately designed solutions to achieve partial availability and remain online even after a disk subsystem hardware failure.

http://www.microsoft.com/downloads/en/details.aspx?familyid=11a7ae65-c792-47ea-8b4e-fb87d0ece9b6

SQL 2008

Partial Database Availability

SQL Server 2005 features that enable appropriately designed solutions to achieve partial availability and remain online even after a disk subsystem hardware failure.

http://www.microsoft.com/downloads/en/details.aspx?familyid=11a7ae65-c792-47ea-8b4e-fb87d0ece9b6

BizTalk Server 2010 - Evaluation

BizTalk Server 2010 is an integration server that provides connectivity, Business Process Management (BPM), and SOA/ESB capabilities. It also includes Business to Business (B2B) integration capabilities, Adapters, Accelerators, and an RFID platform.

http://www.microsoft.com/downloads/en/details.aspx?familyid=8b1069cf-202b-462b-8d10-bec65d315c65

BizTalk Server 2010 - Developer Edition

BizTalk Server 2010 is an integration server that provides connectivity, Business Process Management (BPM), and SOA/ESB capabilities. It also includes Business to Business (B2B) integration capabilities, Adapters, Accelerators, and an RFID platform.

http://www.microsoft.com/downloads/en/details.aspx?familyid=938102b8-a677-4c20-906d-f6ae472b3a6a

Events/Webcasts

SQLBits

SQLBits is the UK’s largest SQL Server conference, and will be taking place in York from September 30th to October 2nd.

We have 50 in-depth technical sessions presented by some of the leading experts in SQL Server and BI, and best of all, the main community conference on Saturday October 2nd is free to attend!

For more details and to register:

http://www.sqlbits.com

New KB's

Other

Azure SQL Developer: Solution Migration To Windows Azure

http://support.microsoft.com/kb/2221824/en-US

Azure SQL Service: Database Migration To Sql Azure

http://support.microsoft.com/kb/2212855/en-US

Azure SQL Service: Database Migration To Sql Azure

http://support.microsoft.com/kb/2212990/en-US

Azure SQL Service: Developing Applications For Sql Azure

http://support.microsoft.com/kb/2213496/en-US

SQL 2005

Microsoft SQL Server 2005 Developer Edition: Restoring Full-text Catalog in SQL Server 2005 removes SQLServer2005MSFTEUser ACL

http://support.microsoft.com/kb/2413104/en-US

Microsoft SQL Server 2005 Developer Edition: FIX: A query may take longer to run in SQL Server 2005 SP1 than it takes to run in the original release version of SQL Server 2005 or in SQL Server 2000

http://support.microsoft.com/kb/919905/en-US

Microsoft SQL Server 2005 Developer Edition: FIX: Error message when the Replication Merge Agent runs to synchronize a merge replication subscription in SQL Server 2005: “The merge process failed to execute a query because the query timed out”

http://support.microsoft.com/kb/934065/en-US

Microsoft SQL Server 2005 Enterprise Edition: FIX: You receive error 1456 when you add a witness to a database mirroring session and the database name is the same as an existing database mirroring session in SQL Server 2005 or SQL Server 2008

http://support.microsoft.com/kb/930283/en-US

Microsoft SQL Server 2005 Standard Edition: FIX: The SQL Server 2005 query optimizer may incorrectly estimate the cardinality for a query that has a predicate that contains an index union alternative

http://support.microsoft.com/kb/920347/en-US

Microsoft SQL Server 2005 Standard Edition: How to configure an IPv6 resource for a SQL Server 2005 cluster on a Windows Server 2008-based computer

http://support.microsoft.com/kb/923398/en-US

Microsoft SQL Server 2005 Standard Edition: Error message when you try to install a SQL Server 2005 service pack or a SQL Server 2005 hotfix package: "Error 29528. The setup has encountered an unexpected error while Setting Internal Properties"

http://support.microsoft.com/kb/925976/en-US

Microsoft SQL Server 2005 Standard Edition: FIX: The query performance is very slow when you use a fast forward-only cursor to run a query in SQL Server 2005

http://support.microsoft.com/kb/926024/en-US

Microsoft SQL Server 2005 Standard Edition: You cannot find SQL Server cluster resources in Failover Cluster Manager after you install a SQL Server 2005 failover cluster on a computer that is running Windows Server 2008

http://support.microsoft.com/kb/932897/en-US

Microsoft SQL Server 2005 Standard Edition: FIX: The W3WP.exe process of Internet Information Services stops unexpectedly when you configure a merge replication that uses Web synchronization in SQL Server 2005 and SQL Server 2008

http://support.microsoft.com/kb/942712/en-US

Microsoft SQL Server 2005 Standard Edition: The DHCP support is not available when you install SQL Server 2005 on a Windows Server 2008 failover cluster

http://support.microsoft.com/kb/945936/en-US

Microsoft SQL Server 2005 Standard Edition: An additional resource group that contains no resources is created after you install a second failover clustered instance of SQL Server 2005 on a Windows Server 2008-based server

http://support.microsoft.com/kb/948208/en-US

Microsoft SQL Server 2005 Standard Edition: Problems occur in Windows Server 2008 after you uninstall a SQL Server 2005 failover cluster, or after you install SQL Server 2005 Service Pack 2 or a Service Pack 2-based hotfix on a SQL Server 2005 failover cluster

http://support.microsoft.com/kb/948210/en-US

Microsoft SQL Server 2005 Standard Edition: Trace flag 4199 is added to control multiple query optimizer changes previously made under multiple trace flags

http://support.microsoft.com/kb/974006/en-US

Microsoft SQL Server 2005 Standard Edition: FIX: A DateTime value is replaced by a NULL value when a conflict is resolved by using a custom resolver in Microsoft SQL Server 2005, Microsoft SQL Server 2008 or Microsoft SQL Server 2008 R2 merge replication

http://support.microsoft.com/kb/979212/en-US

SQL 2008

Microsoft SQL Server 2008 Analysis Services: You get “A duplicate attribute key has been found when processing ..” error message when processing a dimension

http://support.microsoft.com/kb/2002757/en-US

Microsoft SQL Server 2008 Analysis Services: FIX: Error message when you run the ProcessAdd command after you make changes to the partition on a server that is running SQL Server 2008 Analysis Services: "Internal Error: An unexpected exception occurred"

http://support.microsoft.com/kb/2216454/en-US

Microsoft SQL Server 2008 Analysis Services: FIX: You experience decreased performance when you run an MDX query in SQL Server 2008 SP1 that has cumulative update 5 or a later version of the update package installed

http://support.microsoft.com/kb/2292725/en-US

Microsoft SQL Server 2008 Analysis Services: FIX: "An unexpected exception occurred" internal error and heap corruption occurs when you run a MDX query that is generated by third-party software in SSAS 2008

http://support.microsoft.com/kb/2316135/en-US

Microsoft SQL Server 2008 Analysis Services: FIX: An "UPDATE CUBE" statement returns an incorrect error message when you try to update a calculated measure or a calculated member in SSAS 2008

http://support.microsoft.com/kb/2399715/en-US

Microsoft SQL Server 2008 Developer: How to troubleshoot collation conflict errors when executing queries that involve columns with different collations

http://support.microsoft.com/kb/2026108/en-US

Microsoft SQL Server 2008 Developer: FIX: Shared components are installed in the wrong location when you implement a SQL Server 2008 Failover Cluster installation

http://support.microsoft.com/kb/2028830/en-US

Microsoft SQL Server 2008 Developer: You get "Failover instance 'MSSQLSERVER' cluster group not found" when you try to add a new node to a single node SQL Server Failover cluster.

http://support.microsoft.com/kb/2102055/en-US

Microsoft SQL Server 2008 Developer: SSIS 2008 Import Export Wizard can show numbers instead of data type

http://support.microsoft.com/kb/2152728/en-US

Microsoft SQL Server 2008 Developer: FIX: An SSIS package that uses the Unpivot transformation may produce inconsistent results in SQL Server 2008

http://support.microsoft.com/kb/2214666/en-US

Microsoft SQL Server 2008 Developer: FIX: A certain number of the last XML columns may not be replicated correctly if you use web synchronization for merge replication in SQL Server 2008

http://support.microsoft.com/kb/2256829/en-US

Microsoft SQL Server 2008 Developer: FIX: The "SQL Server:SSIS Pipeline 10.0" performance object does not appear in the "Performance object" list while another user accesses some SSIS pipeline counters in SQL Server 2008

http://support.microsoft.com/kb/2261403/en-US

Microsoft SQL Server 2008 Developer: FIX: The "CHANGETABLE" function is slow in SQL Server 2008

http://support.microsoft.com/kb/2276330/en-US

Microsoft SQL Server 2008 Developer: FIX: A derived column transformation may generate incorrect results in SSIS 2008 when a column is derived both in read-only usage and in read/write usage

http://support.microsoft.com/kb/2278042/en-US

Microsoft SQL Server 2008 Developer: FIX: An error message may occur when you run a "BULK INSERT" query on a database that uses the "BULK_LOGGED" or "SIMPLE" recovery model in SQL Server 2008

http://support.microsoft.com/kb/2297709/en-US

Microsoft SQL Server 2008 Developer: FIX: Poor performance and some occasional non-yielding scheduler errors occur when you create a complex view that references a large amount of nested views or tables in SQL Server 2008

http://support.microsoft.com/kb/2306162/en-US

Microsoft SQL Server 2008 Developer: FIX: Incorrect results if you use parentheses around SELECT in a statement that has a common table expression in SQL Server 2008

http://support.microsoft.com/kb/2322209/en-US

Microsoft SQL Server 2008 Developer: FIX: "Non-yielding Scheduler" error may occur when you use the "CONTAINSTABLE" function together with many "OR" and "AND" predicates in SQL Server 2008

http://support.microsoft.com/kb/2344600/en-US

Microsoft SQL Server 2008 Developer: FIX: The ANSI_NULLS property of an indexed view is changed to FALSE after the indexed view is replicated to the subscription database in SQL Server 2008

http://support.microsoft.com/kb/2384766/en-US

Microsoft SQL Server 2008 Developer: FIX: "A MOF syntax error occurred" error message occurs when you try to install SQL Server 2008

http://support.microsoft.com/kb/2387686/en-US

Microsoft SQL Server 2008 Developer: FIX: An exception occurs before the error output for invalid data of an "XML Source" task is redirected in SSIS 2008

http://support.microsoft.com/kb/2407172/en-US

Microsoft SQL Server 2008 Developer: Error message when you install SQL Server 2008 on a Windows Server 2008-based cluster: "The cluster either has not been verified or there are errors or failures in the verification report. Refer to KB953748 or SQL server books online"

http://support.microsoft.com/kb/953748/en-US

Microsoft SQL Server 2008 Developer: Analysis SQL Transactional Replication High Latency

http://support.microsoft.com/kb/982895/en-US

Microsoft SQL Server 2008 Enterprise: SQL Server 2008 setup fails to install on a Windows Server 2008-based cluster mount point

http://support.microsoft.com/kb/2216461/en-US

Microsoft SQL Server 2008 Enterprise: FIX: Error code 1456 when you add a witness to a new database mirroring session that has the same database name as an existing database mirroring session in Microsoft SQL Server 2008

http://support.microsoft.com/kb/2276717/en-US

Microsoft SQL Server 2008 Enterprise: FIX: The "Derived Column" transformation may produce incorrect results when you run a package in Microsoft SQL Server 2008 Integration Services

http://support.microsoft.com/kb/2287990/en-US

Microsoft SQL Server 2008 Enterprise: FIX: Query failure and an "Invalid column name" error message occur when you run a linked server query to another instance of SQL Server 2008

http://support.microsoft.com/kb/2352413/en-US

Microsoft SQL Server 2008 Enterprise: FIX: "0x84B10001" error code, SQL Server 2008 Setup failure, and an unhandled exception occur when you run SQL Server 2008 Setup

http://support.microsoft.com/kb/2379466/en-US

Microsoft SQL Server 2008 Enterprise: FIX: Error message when you run the "sp_createstats" stored procedure in SQL Server 2008 if the table contains a nondeterministic computed column

http://support.microsoft.com/kb/2380361/en-US

Microsoft SQL Server 2008 Enterprise: FIX: The query plan for a stored procedure is not cached if the stored procedure uses a BLOB variable and the variable is used in a string function in Microsoft SQL Server 2008

http://support.microsoft.com/kb/2380435/en-US

Microsoft SQL Server 2008 Reporting Services: FIX: Column group values are displayed in only the last child row group of the adjacent row groups in SSRS 2008

http://support.microsoft.com/kb/2028727/en-US

Microsoft SQL Server 2008 Reporting Services: FIX: The value of the "Axis" label appears in each column and the "Gridline Interval" value is not honored after a RDL file is upgraded from SSRS 2005 to SSRS 2008

http://support.microsoft.com/kb/2277207/en-US

Microsoft SQL Server 2008 Reporting Services: FIX: The special characters are displayed incorrectly in a "TextBox" control of a PDF file when you render a report in SSRS 2008

http://support.microsoft.com/kb/2282743/en-US

Microsoft SQL Server 2008 Reporting Services: FIX: The HTML format of a SQL Server 2008 Reporting Services report is not compliant with section 1194.22 standards in the Section 508 standards

http://support.microsoft.com/kb/971132/en-US

Microsoft SQL Server 2008 Standard: Error message when you run the Distribution Agent in SQL Server 2008 or in SQL Server 2008 R2: "The distribution agent failed to create temporary files"

http://support.microsoft.com/kb/956032/en-US

Microsoft SQL Server 2008 Standard: How to obtain the latest service pack for SQL Server 2008

http://support.microsoft.com/kb/968382/en-US

Microsoft SQL Server 2008 Standard: List of the bugs that are fixed in SQL Server 2008 Service Pack 2

http://support.microsoft.com/kb/979450/en-US

SQL 2008 R2

Microsoft SQL Server 2008 R2 Datacenter: FIX: Error message when you use the sqlcmd utility to execute the Transact-SQL query in SQL Server 2008 and SQL Server 2008 R2

http://support.microsoft.com/kb/2121407/en-US

Microsoft SQL Server 2008 R2 Datacenter: Bugs that are fixed in Microsoft SQL Server 2008 R2 Master Data Services June Update

http://support.microsoft.com/kb/2143880/en-US

Microsoft SQL Server 2008 R2 Datacenter: FIX: A full-text query that uses CONTAINS or FREETEXT predicate together with the "OR" operator takes a long time to run in SQL Server 2008

http://support.microsoft.com/kb/2264562/en-US

Microsoft SQL Server 2008 R2 Datacenter: FIX: "User 'guest' does not have permission to run DBCC checkdb for database 'mssqlsystemresource'" error message when you run the DBCC CHECKDB('master') command on a computer that is running SQL Server 2008 or SQL Server 2008 R2

http://support.microsoft.com/kb/2268122/en-US

Microsoft SQL Server 2008 R2 Enterprise: FIX: A SQL Server 2008 R2 Integration Services package does not run in SQL Server Business Intelligence Development Studio when you use a shared SQL configuration table

http://support.microsoft.com/kb/2142496/en-US

Microsoft SQL Server 2008 R2 Enterprise: FIX: Event ID 322 is logged when a server audit is output in SQL Server 2008 or SQL Server 2008 R2

http://support.microsoft.com/kb/2297903/en-US