Technical RollUp

Premier Field Engineering - Technical Rollup Mails

October 2006 - Technical Rollup Mail - SQL

October 2006 - Technical Rollup Mail - SQL

  • Comments 1
  • Likes

News

SQL Server 2005 Enterprise Capabilities

Explore various resources to see how SQL Server 2005 can power your enterprise

http://www.microsoft.com/sql/bigdata/default.mspx

Microsoft IT Showcase

Microsoft uses SQL Server to run mission critical applications, increase business intelligence, increase productivity and more. See how here:

http://www.microsoft.com/technet/itsolutions/msit/sql.mspx

SQL Server Customer Advisory Team Blog

Includes entries of best practices and lessons learned from the most demanding SQL Server implementations in the world.

http://blogs.msdn.com/sqlcat/

New Blog from SQL Server Customer Support Team

http://blogs.msdn.com/sqlblog/

Provide suggestions and bug reports on Microsoft SQL Server 2005

Send suggestions and bug reports about the features and user interface of SQL Server 2005, Send suggestions and report inaccuracies about the documentation, Choose to send error reports and feature usage data automatically to Microsoft for analysis.

http://msdn2.microsoft.com/en-us/library/ms166362.aspx

Documents

Physical Database Design

This whitepaper helps database architects and administrators configure Microsoft SQL Server 2005 systems for optimal I/O performance and space utilization. In this whitepaper, you will learn about:

  • Internals of SQL Server physical design storage
  • Reliability and performance requirements for the database system.
  • Deciding upon the hardware to suit the above requirements
  • Best practice recommendations for configuring SQL Server to take advantage of the above
  • Tracking and monitoring performance on an ongoing basis

http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx

Working With TempDB in SQL Server 2005

This white paper describes how SQL Server 2005 uses tempdb. Many improvements in SQL Server 2005 optimize tempdb usage and make it easier to manage and to troubleshoot. A case study that uses a workload similar to TPC Benchmark H (TPC-H)  shows new ways to manage and troubleshoot tempdb resources. This paper also includes items to consider when upgrading to SQL Server 2005 and configuring tempdb.

http://www.microsoft.com/technet/prodtechnol/sql/2005/workingwithtempdb.mspx

Downloads

SQL Server 2005 Virtual Backup Device Interface (VDI) Specification

The SQL Server 2005 Virtual Backup Device Interface Specification now contains updated information about the Virtual Backup Device interface. Independent software vendors (ISVs) can use the Virtual Backup Device Application Programming Interface (API) to integrate SQL Server into their products.

http://www.microsoft.com/downloads/details.aspx?familyid=416f8a51-65a3-4e8e-a4c8-adfe15e850fc&displaylang=en

SQL Server 2005 Systems View Map

The Microsoft SQL Server 2005 System Views Map shows the key system views included in SQL Server 2005, and the relationships between them.

http://www.microsoft.com/downloads/details.aspx?FamilyID=2ec9e842-40be-4321-9b56-92fd3860fb32&DisplayLang=en

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.

http://www.microsoft.com/sql/eval/webcast.mspx?wt.mc_id=sql.ad.01037

Free SQL Server 2005 Training

Whether you are interested in database administration, database development, or business intelligence, you can access the E-Learning topic you want, when you want it, and learn at your own pace. Each lesson includes hands-on virtual labs and offline functionality.  In addition, you may consider taking a free Microsoft Skills Assessment to help you meet your Microsoft SQL Server 2005 training goals. You'll receive a learning roadmap with additional skills resources including instructor-led classroom training and books.

https://www.microsoftelearning.com/sqlserver2005/default.aspx

Introduction To Data-Aware Windows Mobile Applications

How to create a simple SQL Server Mobile-based Pocket PC application.

http://msdn.microsoft.com/msdntv/episode.aspx?xml=episodes/en/20060831MobileRB/manifest.xml

Project Real – Business Intelligence In Practice

Project REAL is a cooperative effort between Microsoft and a number of technology partners in the business intelligence (BI) industry to build on actual customer scenarios to discover best practices for creating BI applications based on SQL Server 2005. The term REAL in Project REAL is an acronym for Reference implementation, End-to-end, At scale, and Lots of users. Listen to members of the Project REAL team through webcasts that target different levels of users.

TechNet Webcast: Real-World Experience with a Business Intelligence System on SQL Server 2005 (Part 1 of 3): Overview and Design (Level 200)

TechNet Webcast: Real-World Experience with a Business Intelligence System on SQL Server 2005 (Part 2 of 3): Data Engines (Level 300)

TechNet Webcast: Real-World Experience with a Business Intelligence System on SQL Server 2005 (Part 3 of 3): Presentation (Level 300)

Further on-demand webcasts are available here: http://www.microsoft.com/events/series/technetsqlserver2005.mspx

New KB’s

SQL Server 2000 Standard Edition

Query performance may decrease when you try to run a query in a parallel plan in SQL Server 2000

http://support.microsoft.com/?kbid=919638

FIX: You may receive an access violation error message when you run a linked server query that includes a subquery

http://support.microsoft.com/?kbid=911569

BUG: You may receive an access violation error message when you try to run an SSIS package in SQL Server 2005

http://support.microsoft.com/?kbid=924016

FIX: In SQL Server 2005, the sp_altermessage stored procedure does not suppress system error messages that are logged in the SQL Server error log and in the Application log

http://support.microsoft.com/?kbid=922578

SQL Server 2000 Enterprise Edition

FIX: You cannot uninstall SQL Server 2000 build 2187 when SQL Server 2000 build 2187 is configured as a Microsoft Cluster Service (MSCS) node

http://support.microsoft.com/?kbid=922040

SQL Server 2000 Analysis Services

FIX: In SQL Server 2000 Analysis Services, a memory leak may occur in the handle thread when you run an MDX query that uses formulas or recursions

http://support.microsoft.com/?kbid=911023

FIX: The connection that processes the cube stops responding, and the cube is locked in SQL Server 2000 Analysis Services

http://support.microsoft.com/?kbid=912468

SQL Server 2005 Standard Edition

BUG: When you click "Build Query" in the "Execute SQL Task Properties" dialog box of the SQL Server 2000 DTS package designer, SQL Server 2005 Management Studio unexpectedly closes

http://support.microsoft.com/?kbid=921929

FIX: A query plan is not cached in SQL Server 2005 when the text of the hint is a large object

http://support.microsoft.com/?kbid=918882

FIX: Log Reader Agent fails, and an assertion error message is logged when you use transactional replication in SQL Server 2005

http://support.microsoft.com/?kbid=923296

Support WebCast: Overview of database mirroring in SQL Server 2005

http://support.microsoft.com/?kbid=925067

Support WebCast: How to use the DataReader Source and the OLE DB Source objects in SQL Server 2005 Integration Services

http://support.microsoft.com/?kbid=925068

Use of detours by a third-party solution is not supported with SQL Server

http://support.microsoft.com/?kbid=920925

You obtain incorrect results when you run a full-text search query that uses a thesaurus file in SQL Server 2005

http://support.microsoft.com/?kbid=923317

FIX: You may receive an access violation error message when you run a query against a linked server in SQL Server 2005

http://support.microsoft.com/?kbid=922296

FIX: An access violation may intermittently occur when you run a SQL Server Integration Services package in SQL Server 2005

http://support.microsoft.com/?kbid=924346

FIX: Error message when you execute an MDX query that calls a VBA function in SQL Server 2005 Service Pack 1: "PFE_ASSEMBLY_NOT_SAFETOPREPARE"

http://support.microsoft.com/?kbid=919956

FIX: When you run a query that references a partitioned table in SQL Server 2005,  query performance may decrease

http://support.microsoft.com/?kbid=923849

FIX: You may receive different date values for each row when you use the getdate function within a case statement in SQL Server 2005

http://support.microsoft.com/?kbid=925153

FIX: System performance may be slow when an application submits many queries against a SQL Server 2005 database that uses simple parameterization

http://support.microsoft.com/?kbid=920206

SQL Server 2005 Mobile Edition

FIX: Error message when you try to insert a row or perform other database operations in a SQL Server 2005 Mobile Edition database: "Wrong page possible database corruption"

http://support.microsoft.com/?kbid=923979

SQL Server 2005 Analysis Services

FIX: Error message when you run a MDX query after you install the cumulative hotfix package for SQL Server 2005 Analysis Services for Itanium-based operating systems (build 9.0.2153): "Internal error: An unexpected exception occured"

http://support.microsoft.com/?kbid=923304

FIX: You receive an access violation error message on a server that is running SQL Server 2005 Analysis Services when you run a MDX query that contains a user-defined function

http://support.microsoft.com/?kbid=918753

FIX: You receive an access violation error message when you try to restore a SQL Server 2005 Analysis Services database

http://support.microsoft.com/?kbid=918747

FIX: A query may return incorrect results when you run the query against a SQL Server 2005 Analysis Services cube

http://support.microsoft.com/?kbid=920340

FIX: You may receive an error message when you try to use the Aggregation Design Wizard to design aggregations in SQL Server 2005 Analysis Services

http://support.microsoft.com/?kbid=922853

FIX: SQL Server 2005 Analysis Services continually generates minidump files when you try to deploy a new cube

http://support.microsoft.com/?kbid=923301

FIX: The calculated members are not returned in subsequence levels when you run an XML for Analysis (XMLA) script to retrieve child members at a level that is in a hierarchy in SQL Server 2005 Analysis Services

http://support.microsoft.com/?kbid=923300

FIX: A parent/child dimension contains duplicate calculated members under all the top-level members after you upgrade SQL Server 2000 Analysis Services to SQL Server 2005 Analysis Services

http://support.microsoft.com/?kbid=911997

FIX: You cannot connect to SQL Server 2000 Analysis Services when you configure the Office Web Components data source connection string to use OLE DB Provider for Analysis Services 9.0 to connect to SQL Server 2005 Analysis Services

http://support.microsoft.com/?kbid=912631

FIX: SQL Server Analysis Services 2005 system performance may be slow after you use the ADOMD.NET data provider to run an MDX query that returns a large result set from a cube

http://support.microsoft.com/?kbid=919731

SQL Server 2005 Reporting Services

FIX: Error message when you use Report Manager in SQL Server 2005 Reporting Services to view a report: "The request failed with an empty response"

http://support.microsoft.com/?kbid=918555

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment