March 2007 - Technical Rollup Mail - SQL
News
Now Available – SQL Server 2005 Service Pack 2 With New Features, Increased Performance
Microsoft SQL Server 2005 Service Pack 2 (SP2) enables all editions of SQL Server 2005 to take advantage of the enhancements within Windows Vista and the 2007 Office System including SQL Server Analysis Services and Reporting Services improvements for Office 2007; increased interoperability; and enhanced manageability and data compression.
https://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/servicepacks/sp2.mspx
SQL Server 2005 Service Pack 2 Press Release Here:
https://www.microsoft.com/presspass/press/2007/feb07/02-19SQLSP2PR.mspx
What’s New In SQL Server 2005 Service Pack 2
https://msdn2.microsoft.com/en-us/library/bb283536.aspx
A List Of The Bugs That Have Been Fixed In SQL Server 2005 Service Pack 2
This article contains information about the bugs fixed in SQL Server 2005 SP2. Please note: (1) other fixes that are not documented may be included in the service pack and (2) this list will be updated when more articles are released.
https://support.microsoft.com/default.aspx?scid=kb;en-us;921896
Documents
SQL Server Questions and Answers From The Latest Technet Magazine
Database Size, Mirroring, Marked Transactions and More…
https://www.microsoft.com/technet/technetmag/issues/2007/02/SQLQA/default.aspx
Case Study: Denmark Telecom Leader Slashes Costs with 6 Terabyte Data Warehouse on SQL Server 2005
https://www.microsoft.com/casestudies/casestudy.aspx?casestudyid=200154
Downloads
SQL Server 2005 Service Pack 2 – Related Downloads
SQL Server 2005 SP2
To update SQL Server 2005 with Service Pack 2, click the link below and download the files most appropriate for you.
SQL Server 2005 Express Edition SP2 (February 2007)
Download SQL Server 2005 Express Edition SP2
Update For Books Online (February 2007)
Download an updated version of Books Online for Microsoft SQL Server 2005, the primary documentation for SQL Server 2005. The February 2007 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to "New and Updated Books Online Topics" for a list of topics that are new or updated in this version. Topics with significant updates have a Change History table at the bottom of the topic that summarizes the changes.
https://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Samples and Sample Databases (February 2007)
The February 2007 release is compatible with SQL Server 2005 SP2. There are several new samples in this release, and many bug fixes. See the SQLServerDatabasesAndSamplesOverview.htm file included with this download for a description of the new samples available in this release.
SQL Server 2005 Feature Pack (February 2007)
Download the SQL Server 2005 Feature Pack (February 2007)
Reporting Services Add-in for Microsoft SharePoint Technologies (February 2007)
SQL Server 2005 Reporting Services Add-in for SharePoint Technologies allows you to take advantage of SQL Server 2005 SP2 report processing and management capabilities in SharePoint. The download provides a Report Viewer web part, web application pages, and support for using standard Windows SharePoint Services.
Download SQL Server 2005 Reporting Services Add-in for Microsoft SharePoint Technologies
Data Mining Add-ins for Microsoft Office 2007 (February 2007)
SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007 allow you take advantage of SQL Server 2005 predictive analytics in Office Excel 2007 and Office Visio 2007. The download includes Table Analysis Tools for Excel, Data Mining Client for Excel, and Data Mining Templates for Visio.
Download SQL Server 2005 Data Mining Add-ins for Microsoft Office 2007
Events/WebCasts
SQL 2005 Webcasts and Virtual Labs
SQL Server 2005 is data management and analysis software that delivers enhanced security, availability, and scalability to mission-critical data applications—while making them easier to develop, deploy, and manage. Choose from a wide range of live and on-demand webcasts. Or take part in a virtual lab, which allows you to cut your teeth on the new platform by experimenting with its different capabilities.
https://www.microsoft.com/sql/eval/webcast.mspx?wt.mc_id=sql.ad.01037
SQL Server 2005 Service Pack 2 Webchat
Join the SQL Server 2005 development team to learn more and ask technical questions about the Service Pack 2 release made available for public download on 2/19/2007.
Microsoft Webcast: Selecting the Right SQL Server 2005 Edition to Fit Your Business (Level 200)
Microsoft SQL Server 2005 is a collection of components, and each component has a number of features to support various aspects of a database application. Microsoft has packaged these components and features into various editions to better accommodate the system availability, performance, and price requirements of different customers. Before you acquire and install SQL Server 2005, attend this webcast to compare editions and find the best match for your application and business needs. We explore the key differences between SQL Server 2005 Enterprise and Standard editions in the areas of availability, scalability, manageability, and business intelligence (BI) to help you determine which edition is right for you.
Thursday, March 8, 2007
11:00 A.M.–12:00 P.M. Pacific Time
Microsoft Webcast: Selecting the Right SQL Server 2005 Edition to Fit Your Business (Level 200)
TechNet Webcast: SQL Server 2005 SP2 Tools and Improvements (Level 200)
In this webcast, we discuss the broad range of tools available for Microsoft SQL Server 2005 Service Pack 2 (SP2). If you are a database administrator or IT professional who is new to SQL Server 2005 or would like to see a few of the great scenarios enabled by SP2, you should attend this session. We cover several tools and features that are new or improved in SP2, including Management Studio, Best Practices Analyzer, multi-instance maintenance plans, custom reports, script generation, and the Copy Database Wizard.
Tuesday, March 20, 2007
1:00 P.M.–2:00 P.M. Pacific Time
TechNet Webcast: SQL Server 2005 SP2 Tools and Improvements (Level 200)
MSDN Webcast: Building Data-Driven Web Applications with SQL Server Express (Part 1 of 3) (Level 200)
Join this three-part webcast series as we highlight graphical techniques for building Web sites that create data-bound solutions with Microsoft SQL Server 2005 Express Edition and Visual Web Developer 2005 Express Edition. In this first presentation, we focus on creating Web sites that use the new Microsoft ASP.NET login controls. Be sure to attend the second installment of our series to learn techniques for displaying and manipulating data from ASP.NET controls on Web pages. In the third part our series, we describe using a single middle-tier data object on multiple Web pages, in addition to master page and site navigation techniques.
Thursday, March 1, 2007
1:00 P.M.–2:00 P.M. Pacific Time
TechNet Webcast: Introduction to SQL Server 2005 Integration Services (Level 200)
Microsoft SQL Server 2005 Integration Services is a completely redesigned, feature-rich, enterprise data integration platform. In this session, we introduce you to the enterprise-class capabilities of Integration Services, including dedicated management functionality, collaborative development environment, and high scalability and reliability. Also, learn how you can use SQL Server 2005 Integration Services to implement data quality, data profiling, and custom transforms in your organization.
Monday, March 5, 2007
1:00 P.M.–2:30 P.M. Pacific Time
TechNet Webcast: Introduction to SQL Server 2005 Integration Services (Level 200)
TechNet Webcast: Measuring the Security Quality of SQL Server 2005 and the Security Development Lifecycle (Level 200)
Every vulnerability in a database infrastructure means attacks are that much more likely to succeed. With that in mind, the Enterprise Strategy Group (ESG) compiled data to compare security vulnerabilities in Microsoft SQL Server 2005, the first Microsoft product to run through the Security Development Lifecycle (SDL), with those in competing products. Join this webcast as we review the highlights of the SDL, illustrate the process of quantifying security quality, and explain what you can learn from the experiences that Microsoft had.
Thursday, March 8, 2007
1:00 P.M.–2:00 P.M. Pacific Time
TechNet Webcast: Introducing a New Storage Format for Decimal and Numeric Data in SQL Server 2005 (Level 200)
Do you have an application that depends on a Microsoft SQL Server 2005 database? Are there tables in that database with columns that contain decimal values? If so, you may be able to reduce the size of those tables, and thereby reduce the size of the database. This webcast provides the details you need to use a new, more efficient storage format for decimal and numeric data. We also discuss the database size reduction you can expect, and the effect this may have on the performance of your applications.
Wednesday, March 28, 2007
1:00 P.M.–2:00 P.M. Pacific Time
Further on-demand webcasts are available here: https://www.microsoft.com/events/series/technetsqlserver2005.mspx
New KB’s
SQL Server 2000 Standard Edition
FIX: CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statement
https://support.microsoft.com/?kbid=930484
SQL Server 2005 Standard Edition
How to schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005
https://support.microsoft.com/?kbid=930615
SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies
https://support.microsoft.com/?kbid=931279
BUG: Error message when you use Database Mail in SQL Server 2005: "Error 14667, Severity 16, State 1"
https://support.microsoft.com/?kbid=931175
FIX: You may receive an error message when you run a CLR stored procedure or CLR function that uses a context connection in SQL Server 2005
https://support.microsoft.com/?kbid=928083
You may be prompted to enter the old password when you try to reset the password of a SQL Server login by using a SQL Server login that is a member of the securityadmin fixed server role in SQL Server 2005
https://support.microsoft.com/?kbid=931976
FIX: The restore operation may take a long time to finish when you restore a database in SQL Server 2005
https://support.microsoft.com/?kbid=924807
How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007
https://support.microsoft.com/?kbid=931975
The remote instance of SQL Server 2000 does not stop when you use SQL Server Management Studio on the server that is running SQL Server 2005
https://support.microsoft.com/?kbid=930878
Error message when you try to configure SQL Server Agent to interact with Database Mail in SQL Server 2005 64-bit editions: "An attempt was made to send an email when no email session has been established"
https://support.microsoft.com/?kbid=931631
FIX: SQL Server 2005 may not perform histogram amendments when you use trace flags 2389 and 2390
https://support.microsoft.com/?kbid=929278
FIX: Error message when you use the Bcp.exe utility to import data into a table from a text file in SQL Server 2005: "The memory could not be written"
https://support.microsoft.com/?kbid=923008
FIX: Some rows in the Text Data column are always displayed for a trace that you create by using SQL Server Profiler in SQL Server 2005
https://support.microsoft.com/?kbid=919243
FIX: Error message when you use SQL Server 2005: "High priority system task thread Operating system error Exception 0xAE encountered"
https://support.microsoft.com/?kbid=922594
FIX: I/O requests that are generated by the checkpoint process may cause I/O bottlenecks if the I/O subsystem is not fast enough to sustain the IO requests in SQL Server 2005
https://support.microsoft.com/?kbid=929240
FIX: SQL Server Profiler stops monitoring the instance after a time when you use SQL Server Profiler to monitor an instance of SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=930691
FIX: Some search results are missing when you perform a full-text search operation on a Windows SharePoint Services 2.0 site after you upgrade to SQL Server 2005
https://support.microsoft.com/?kbid=927643
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
https://support.microsoft.com/?kbid=930283
FIX: A "17187" error message may be logged in the Errorlog file when an instance of SQL Server 2005 is under a heavy load
https://support.microsoft.com/?kbid=929376
BUG: You may receive incorrect results when you run a query against the target partitioned table after you insert data from a partitioned table to another partitioned table in SQL Server 2005
https://support.microsoft.com/?kbid=931291
SQL Server 2005 Analysis Services
FIX: You may receive unexpected results when you run an MDX query in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=926515
FIX: The query runs much slower than you expect when you use the InStr function in a calculated member of an MDX query in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=927455
You may unexpectedly receive a NULL value when you run a Multidimensional Expressions (MDX) query in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=930410
You may experience decreased performance when you run queries against a cube that contains linked dimensions in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=931292
FIX: Error message when you run a Multidimensional Expressions (MDX) query that uses a calculated member in SQL Server 2005 Analysis Services: "Internal error An unexpected exception occurred"
https://support.microsoft.com/?kbid=930409
FIX: You may receive incorrect results when you run a Multidimensional Expressions (MDX) query that involves a calculated member and the autoexist functionality in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=919955
FIX: Unfiltered results may be generated when you use a drillthrough action on a dimension that is stored in the ROLAP storage mode in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=923477
FIX: The MDX query may never finish when you run the MDX query against a parent/child dimension in SQL Server 2005 Analysis Services
https://support.microsoft.com/?kbid=923476
SQL Server 2005 Reporting Services
FIX: You may receive "UnavailableException" and "LogonFailedException" error messages when you perform a stress test on the report server in SQL Server 2005 Reporting Services
https://support.microsoft.com/?kbid=922577
FIX: Error message when you open a report in Report Manager in SQL Server 2005 Reporting Services: "An error has occurred during report processing. There is already an open DataReader associated with this Command which must be closed first"
https://support.microsoft.com/?kbid=927290
FIX: SQL Server 2005 Reporting Services cannot generate an error message in a report when the data source of the report calls a stored procedure that contains the RAISERROR statement
https://support.microsoft.com/?kbid=919538
FIX: You cannot select a multivalued parameter from a drop-down list when you view a report in Report Manager in SQL Server 2005 Reporting Services
https://support.microsoft.com/?kbid=919556
FIX: The Report Server Windows service may stop responding, and you may receive the following error message in SQL Server 2005 Reporting Services: "An internal error occurred on the report server"
https://support.microsoft.com/?kbid=928538
FIX: Error message when you use Report Builder after you install SQL Server 2005 Reporting Services SP1: "Short time pattern does not include hours and minutes"