September 2009 – Technical Rollup Mail – SQL
News
SQL 2008
Microsoft Releases SQL Server 2008 Service Pack 1
Microsoft has released SQL Server 2008 Service Pack 1 with enhancements meant to ease deployment but no brand new features.
SQL Server to Get Real-Time Boost
The next release of Microsoft's SQL Server database, code-named "Kilimanjaro," will offer master data management (MDM) and support real-time data feeds for business intelligence (BI), reporting and analytics, the company revealed today.
Microsoft Announces SQL Server Fast Track Data Warehouse
New reference architectures from Bull, Dell and HP make it faster, easier, and more affordable for companies to deploy enterprise-class data warehousing projects.
Microsoft announces Microsoft SQL Server 2008, Windows Server 2008 Certification for SAP Business Suite 7, and new enterprise support and services.
Dave Campbell on SQL Server 2008, Cloud Services, and More
What he thinks about the latest SQL Server release, Kilimanjaro, Madison, and Azure.
Reduce IT Spending While Still Upgrading to SQL Server 2008
The latest features and functionality included out-of-the-box with SQL Server 2008 will allow IT managers to save a tremendous amount of money and at the same time reduce management costs, hence it is worth the investment and you should upgrade to SQL Server
2008.
The big stories in the database arena in 2008 included cloud databases, the release of SQL Server 2008 and acquisitions,...
Microsoft hires noted database researcher to help scale SQL Server
DeWitt to head research lab at UW-Madison, hopes to see results make their way into products.
Test Center review: Deep dive into SQL Server 2008
Microsoft unveils a road map for SQL Server "Kilimanjaro," which will contain new BI capabilities.
Have Microsoft's new tools made you the part-time DBA?
SQL Server 2008 isn't revolutionary by any stretch, but it includes a slew of new features that probably make this a no-brainer upgrade for most developers who rely on previous versions of SQL Server.
Microsoft Professional Developers Conference 2008 Virtual Pressroom
Check out the highlights from PDC 2008!
Microsoft Focuses on BI for SQL Server Kilimanjaro
Microsoft unveils a road map for SQL Server "Kilimanjaro," which will contain new BI capabilities.
Microsoft Empowers Enterprises to Think Bigger About Business Intelligence
Microsoft Corp. today kicked off its second annual Microsoft Business Intelligence (BI) Conference 2008 by announcing groundbreaking new technologies that will enable enterprises to bring the power of BI to information workers organization wide. New “managed self-service” business intelligence technologies and enhanced enterprise-class data warehousing capabilities usher in an era of truly pervasive BI.
For the majority of mission-critical applications today, SQL Server 2008 already has the strongest combination of price/performance, manageability, security, and DBA productivity. The latest version of SQL Server from Microsoft SQL Server 2008 offers hundreds of new DBMS features that boost the productivity of database administrators (DBAs) and developers, improve support for larger databases, and enhance security.
New Independent Study Finds 162% Risk-Adjusted ROI for SQL Server 2008 Deployment
An independent commissioned study conducted by Forrester Research explores the economic impact and ROI achieved by a healthcare customer after deploying SQL Server 2008
SQL Server 2008, the new version of the company’s acclaimed data management and business intelligence platform, has been released to manufacturing. This version of SQL Server provides powerful new capabilities such as support for policy-based management, auditing, large-scale data warehousing, geospatial data, and advanced reporting and analysis services. SQL Server 2008 provides the trusted, productive, and intelligent platform necessary for business-critical applications.
Other
Technical RollUp
https://blogs.technet.com/trm/default.aspx
Documents
Other
Microsoft® SQL Server® 2008 R2 August Community Technology Preview Feature Pack
The Microsoft SQL Server 2008 R2 Feature Pack is a collection of stand-alone packages which provide additional value for SQL Server 2008 R2.
Microsoft® SQL Server® StreamInsight CTP2
Microsoft® SQL Server® StreamInsight is Microsoft’s new Complex Event Processing technology to help businesses derive better insights by correlating event streams from multiple sources with near-zero latency.
SQL 2005
Microsoft SQL Server 2005 SP3 Release Notes
The Microsoft SQL Server 2005 Service Pack 3 (SP3) Release Notes describe known issues that you should read about before you install or troubleshoot SQL Server 2005 SP3.
SQL Server 2008 R2 Books Online CTP August 2009
Download the a community technology preview (CTP) release version of the documentation and tutorials for Microsoft SQL Server 2008 R2.
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.
Excel 2007 Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
This document outlines how to improve the end-user experience by optimizing the cube design for Microsoft Office Excel 2007 PivotTable dynamic views.
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.
SQL Server 2008 R2 Books Online CTP August 2009
Download the a community technology preview (CTP) release version of the documentation and tutorials for Microsoft SQL Server 2008 R2.
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.
Microsoft Assessment and Planning
The Microsoft Assessment and Planning Toolkit makes it easy to assess your current IT infrastructure for a variety of technology migration projects. This Solution Accelerator provides a powerful inventory, assessment, and reporting tool to simplify the migration planning process.
Microsoft SQL Server 2008 Books Online (July 2009)
Download the documentation and tutorials for Microsoft SQL Server 2008.
Events/Webcasts
Momentum Webcast: Emerge Stronger with Business Intelligence (Level 100)
Wednesday, September 23, 2009 11:00 AM Pacific Time (US & Canada)
Join us for this informative overview on how the Microsoft total business intelligence solution can help you to emerge stronger from the economic downturn. In this webcast, we help you understand how to take advantage of your existing technologies to identify cost cutting opportunities, streamline operations, and strengthen and grow your customer base. This is the first webcast in the four-part Emerge Stronger webcast series, which is specifically designed to address your business intelligence needs in the current marketplace.
Presenter: Dana Straw, Senior Product Manager - Server Application Platform, Microsoft Corporation
View other sessions from Momentum: Drive Your Midsize Business Forward
If you have questions or feedback, contact us.
In addition to Momentum webcasts, Microsoft offers a complimentary e-newsletter with real-world examples of how to align IT with your business strategy. You get tips and techniques on using Microsoft technologies and straight talk about solutions that work for mid-sized businesses. If you would like to receive the Business Insights newsletter, click here.
Regardless of any contact preferences you might have previously made on this Microsoft site or on other Microsoft sites or services, by registering for this webcast or virtual lab, you consent and agree to allow Microsoft or one of its third-party agents to contact you no more than three (3) instances for the purpose of soliciting feedback on the webcast or virtual lab or to supply you with special discounts and offers related to products and services presented in the webcast or virtual lab. Any other use of the personal information in your Microsoft Passport profile is subject to the Microsoft Privacy Statement. You can learn more about the privacy and security of Microsoft Passport Network at www.Passport.net
https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032423640&culture=en-US
New KB's
Other
SQL Svr Compact Edtn 3.5 AL: FIX: The application enters into an infinite loop when you run an application that uses Microsoft Synchronization Services for ADO.NET to synchronize a SQL Server Compact 3.5 database
https://support.microsoft.com/kb/972390/EN-US
SQL 2000
SQL Svr Standard Edtn 2000 EN: PRB: SQL Server Full-Text Search Does Not Populate Catalogs (Updated)
https://support.microsoft.com/kb/317746/EN-US
SQL Svr Standard Edtn 2000 EN: Diagnostics in SQL Server 2000 SP4 and in later versions help detect stalled and stuck I/O operations (Updated)
https://support.microsoft.com/kb/897284/EN-US
SQL Svr Standard Edtn 2000 EN: FIX: You receive an “Error: 8526, Severity: 16, State: 2” error message in SQL Profiler when you use SQL Query Analyzer to start or to enlist into a distributed transaction after you have installed SQL Server 2000 SP4 (Updated)
https://support.microsoft.com/kb/903742/EN-US
SQL 2005
JDBC Driver for SQL Server 2005: FIX: The getColumns method of the DatabaseMetaData object returns an incorrect column length if the column length is 24 in the SQL Server 2005 JDBC driver 1.2
https://support.microsoft.com/kb/972139/EN-US
SQL Svr 2005 Analysis Svcs EN: How to install SQL Server 2005 Analysis Services on a failover cluster (Updated)
https://support.microsoft.com/kb/910230/EN-US
SQL Svr Developer Edtn 2005 EN: How to use Kerberos authentication in SQL Server (Updated)
https://support.microsoft.com/kb/319723/EN-US
SQL Svr Developer Edtn 2005 EN: How to troubleshoot the "Cannot generate SSPI context" error message (Updated)
https://support.microsoft.com/kb/811889/EN-US
SQL Svr Standard Edtn 2005 EN: Changes to the readme file for SQL Server 2005 (Updated)
https://support.microsoft.com/kb/907284/EN-US
SQL Svr Standard Edtn 2005 EN: On a computer that has a 64-bit processor, you receive an error message in SQL Server Management Studio when you connect to SQL Server 2005 Integration Services or when you create or edit a maintenance plan (Updated)
https://support.microsoft.com/kb/919224/EN-US
SQL Svr Standard Edtn 2005 EN: Queries take a longer time to finish running when the size of the TokenAndPermUserStore cache grows in SQL Server 2005 (Updated)
https://support.microsoft.com/kb/927396/EN-US
SQL Svr Standard Edtn 2005 EN: You cannot specify a USB-based tape drive as a backup device in SQL Server 2005 and in SQL Server 2000 (Updated)
https://support.microsoft.com/kb/927797/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005 (Updated)
https://support.microsoft.com/kb/933564/EN-US
SQL Svr Standard Edtn 2005 EN: An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems (Updated)
https://support.microsoft.com/kb/935897/EN-US
SQL Svr Standard Edtn 2005 EN: When you install a SQL Server 2005 service pack or a SQL Server 2005 hotfix, the installation stops unexpectedly (Updated)
https://support.microsoft.com/kb/936488/EN-US
SQL Svr Standard Edtn 2005 EN: The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2 was released (Updated)
https://support.microsoft.com/kb/937137/EN-US
SQL Svr Standard Edtn 2005 EN: How to customize the quota for the TokenAndPermUserStore cache store in SQL Server 2005 Service Pack 3 (Updated)
https://support.microsoft.com/kb/959823/EN-US
SQL Svr Standard Edtn 2005 EN: The SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 was released (Updated)
https://support.microsoft.com/kb/960598/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you try to rebuild one partition of an index on an indexed view in SQL Server 2005: "A system assertion check has failed. Check the SQL Server error log for details."
https://support.microsoft.com/kb/970726/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you run a report in SQL Server 2005 SP2 Reporting Services by using a URL from a subscription: "Object reference not set to an instance of an object" (Updated)
https://support.microsoft.com/kb/971114/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you run a "BULK INSERT" statement on a table that does not have a clustered index in SQL Server 2005: "spid1005 Error: 5243, Severity: 22, State: 1 An inconsistency was detected during an internal operation"
https://support.microsoft.com/kb/972271/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you restore a SQL Server 2000 database by using SQL Server 2005 Management Studio or SQL Server 2008 Management Studio: "Cannot show requested dialog. Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)" (Updated)
https://support.microsoft.com/kb/972687/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: SQL Server 2008 Reporting Services Add-in for SharePoint removes the "Microsoft.SqlServer.Smo" assembly for SQL Server 2005 from the GAC
https://support.microsoft.com/kb/972694/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: Error message when you run the Distribution Agent to synchronize the subscribers with the publisher in Microsoft SQL Server 2005:" The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect"
https://support.microsoft.com/kb/973103/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: The execution of the "xp_readerrorlog" command in SQL Server 2005 stops responding and the usage of the CPU that is running the command increases to 100 percent
https://support.microsoft.com/kb/973524/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: An incorrect result is returned when you run a query against an XML column that contains XML data that is generated by the FOR XML clause and contains nested data sections in SQL Server 2005
https://support.microsoft.com/kb/973578/EN-US
SQL Svr Standard Edtn 2005 EN: FIX: A performance issue occurs when you run a query by using a Fast Forward cursor in SQL Server 2005
https://support.microsoft.com/kb/973877/EN-US
SQL Svr Standard Edtn 2005 EN: Some nodes are not updated as expected when you apply Service Pack 3 or a post-Service Pack 3 update in a SQL Server 2005 cluster that is based on Windows Server 2008 R2 failover clustering (Updated)
https://support.microsoft.com/kb/973993/EN-US
SQL 2008
SQL Svr Enterprise 2008 EN: You must specify the domain groups for the clustered SQL Server services when you install a SQL Server failover cluster (Updated)
https://support.microsoft.com/kb/910708/EN-US
SQL Svr Enterprise 2008 EN: How do I open the firewall port for SQL Server on Windows Server 2008? (Updated)
https://support.microsoft.com/kb/968872/EN-US
SQL Svr Enterprise 2008 EN: 'Microsoft SQL Server management studio' and 'SQL Server Profiler' report 'Evaluation period has expired' message even after upgrading to a licensed edition (Updated)
https://support.microsoft.com/kb/971268/EN-US
SQL Svr Standard 2008 EN: Description of the "access check bucket count" and "access check cache quota" options that are available in the sp_configure stored procedure in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/955644/EN-US
SQL Svr Standard 2008 EN: After you install a SQL Server 2008 failover cluster in a disk that contains a mounted volume, no dependencies are created between the mounted volume and the disk (Updated)
https://support.microsoft.com/kb/956008/EN-US
SQL Svr Standard 2008 EN: List of the bugs that are fixed in SQL Server 2008 Service Pack 1 (Updated)
https://support.microsoft.com/kb/968369/EN-US
SQL Svr Standard 2008 EN: FIX: An INSERT INTO <table name> EXEC <stored procedure name> statement generates error messages even if you set the ANSI_WARNINGS option to "OFF" in SQL Server 2005 and SQL Server 2008 (Updated)
https://support.microsoft.com/kb/971057/EN-US
SQL Svr Standard 2008 EN: FIX: Error message when you create a SharePoint subscription on a SQL Server 2008 Reporting Services report that uses cascading parameters: "This report requires a default or user-defined value for the report parameter '<Parameter>'" (Updated)
https://support.microsoft.com/kb/971068/EN-US
SQL Svr Standard 2008 EN: FIX: The removal of a transaction log file of the database on the principal server breaks a database mirroring session in SQL Server 2005 or in SQL Server 2008 (Updated)
https://support.microsoft.com/kb/972681/EN-US
SQL Svr Standard 2008 EN: FIX: Some columns are missing when you run a query against a table that is located on a linked server if the column names contain a period character in SQL Server 2008 Service Pack 1
https://support.microsoft.com/kb/972856/EN-US
SQL Svr Standard 2008 EN: The Full-Text Search component is not completely rolled back to the Service Pack 1 version after you uninstall Cumulative Update 3 for SQL Server 2008 Service Pack 1 that is applied by using a slipstream installation (Updated)
https://support.microsoft.com/kb/973888/EN-US
SQL Svr Standard 2008 EN: The default setting is used instead of the setting that is specified in the "Prepare Failover Cluster" stage when you perform an advanced cluster installation of a Microsoft SQL Server 2008 failover cluster
https://support.microsoft.com/kb/973992/EN-US
SQL Svr Standard 2008 EN: Microsoft Advisory Services Engagement Scenario - SQL Server Performance