January 2007 - Technical Rollup Mail - SQL
News
Check Out The Exciting New SQL Server Best Practices Website
Get the real-world guidelines, expert tips, and rock-solid guidance to take your SQL Server implementation to the next level. Drawing on the extensive experience and expertise from respected developers and engineers at Microsoft as they walk you through the specifics on solving particularly difficult issues.
https://www.microsoft.com/technet/prodtechnol/sql/bestpractice/default.mspx
Learn About SQL Server 2005 Compact Edition
Microsoft SQL Server 2005 Compact Edition offers essential relational database functionality in a compact footprint ideal for embedding in mobile and desktop applications including a new generation of occasionally connected dynamic applications.
https://www.microsoft.com/sql/editions/compact/default.mspx
Euan Garden’s Top 3 Posts of 2006
Welcome to 2007! As seems to be the trend, here is the list of most popular posts for the last year.
https://blogs.msdn.com/euanga/archive/2007/01/01/top-posts-for-2006.aspx
Get To Know The SQL Server 2005 Storage Engine
Take an in-depth look at the internals of the SQL Server Storage Engine - with advice from a popular author and SQL Server expert. Database developers and administrators get best practices, pragmatic advice, and code samples to help master the intricacies of creating and maintaining enterprise relational databases.
https://www.microsoft.com/mspress/books/7436.aspx
SQL Server Q & A From Latest TechNet Magazine
Data Archiving, Linked Servers, Measuring Bandwidth and More...
https://www.microsoft.com/technet/technetmag/issues/2007/01/SQLQA/default.aspx
January 2007 Edition of TechNet Magazine
https://www.microsoft.com/technet/technetmag/default.aspx
Documents
Choosing Between SQL Server 2005 Compact and Express Editions
Even in this new age of Internet connectivity, online services and wireless everywhere, architects, developers, and end users are realizing that betting their business and user productivity on a constant connection to a central location is a risky, frustrating, and costly endeavour. When the connection goes down for any reason, can you afford to have your business stop? Building resiliency, redundancy and the ability to work independently within your application architecture provides the ability to shield your users and company bottom-line from inevitable problems. Having a local data store to cache online data, enable offline functionality, or enable that stand alone application that just doesn’t need to serve data to the world asks the question; “What should I use for local storage?”
Monitoring and Analysing a Load Test Result
Microsoft Visual Studio Team Test Edition provides tools for running, monitoring, and analyzing load tests. The load test result viewer is capable of monitoring a running test or analyzing a completed test. This document describes the features of the load test result viewer. (23 printed pages).
https://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnvs05/html/MonAnalLTR.asp
Using SQL Server 2005 Reporting Services With SAP NetWeaver BI
This paper discusses the integration of SAP NetWeaver Business Intelligence (BI) with SQL Server 2005 Reporting Services Service Pack 1. The paper provides an overview of using the data provider and query designer to build high quality reports on SAP NetWeaver BI sources. For Reporting Services users who are new to working with SAP NetWeaver BI, this paper will help you get up and running quickly. For users already familiar with SAP NetWeaver, the paper will show how some of that system’s notable features can be leveraged in Reporting Services reports. It also presents some tips and tricks that can help you make the most of the integration between the two products.
Downloads
Visual Studio Team Edition for Database Professionals (DataDude) is Now Available to MSDN Customers
Visual Studio Team Edition for Database Professionals delivers a market-shifting database development product designed to manage database change, improve software quality through database testing and bring the benefits of Visual Studio Team System and life cycle development to the database professional. The full product download on MSDN is a full image only, so 2.9 GB or so, if you already own Visual Studio Team Suite, you can simply download the trial SKU (which is only 20MB) and install this on top of your Team Suite instance. The installer will detect that you have a full license instead of a trial license and do the right thing.
SQL Server 2005 Service Pack 2 CTP (December 2006)
Microsoft released a public Community Technology Preview of SQL Server 2005 Service Pack 2 (SP2) in December – this will be the LAST CTP for Service Pack 2. Applying this new customer collaboration model to service pack releases demonstrates our commitment to customer feedback and validation as an important aspect of a quality-focused development cycle. Also as part of this new model, we are introducing a separate release tree for any future SQL Server security fixes so that customers can take advantage of timely, targeted fixes that are streamlined for security specific updates.
Download SQL Server 2005 Service Pack 2 CTP (December 2006)
ReadMe Files and What’s New In SQL Server 2005 Service Pack 2 CTP (December 2006)
Before you install SQL Server 2005 Service Pack 2 (SP2), download, extract, and read the SP2 Setup documentation (sqlhotfix_setuphelp.exe), and review the SP2 readme file. Before you install SQL Server 2005 SP2 Express editions and tools, read the related readme files. This information can help you avoid common installation issues, and answers other installation questions.
SQL Server 2005 Readme Files and What's New
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
TechNet Webcast: Introduction to Data Mining with SQL Server 2005 (Level 200)
TechNet Webcast: Introduction to Data Mining with SQL Server 2005 (Level 200)
TechNet Webcast: Introduction to SQL Server 2005 Report Builder (Level 200)
Join this webcast to learn how Microsoft SQL Server 2005 Reporting Services is meeting the demands for self-service reporting with Report Builder, an ad hoc reporting tool that enables business users to create their own reports and explore corporate data. We illustrate the architecture behind Report Builder, demonstrate its capabilities, and explain how it helps you to build business data models for users with ease.
TechNet Webcast: Introduction to SQL Server 2005 Report Builder (Level 200)
Momentum Webcast: Microsoft Business Intelligence Solutions with SQL Server 2005 (Level 100)
Discover how you can transform your data from static reports to intelligence-based actions. In this webcast, we explore a variety of business intelligence solutions from Microsoft. Learn how to use tools and technologies such as Microsoft SQL Server 2005 Reporting Services, Office Business Scorecard Manager 2005, and the Microsoft Office system to create powerful business intelligence solutions for your business.
Momentum Webcast: Microsoft Business Intelligence Solutions with SQL Server 2005 (Level 100)
TechNet Webcast: Protecting SQL Server with System Centre Data Protection Manager (DPM) (Level 300)
Microsoft System Centre Data Protection Manager (DPM) 2006 is designed to help you manage your Windows environment. In this webcast, we focus on how DPM 2006 and DPM version 2 (DPM v2)can provide continuous data protection for Microsoft SQL Server. Currently, DPM 2006 protects Microsoft SQL Server logs for reliable backup; DPM v2 Beta 1 (just announced in September 2006) introduces a whole new level of SQL Server backup and recovery. Join us to see how both DPM 2006 and DPM v2 deliver continuous data protection for your Microsoft application and file servers through a seamlessly integrated secondary disk and tape solution on the DPM server. Discover how DPM enables better backups and rapid, reliable recoveries for both you and your end users, while helping you significantly reduce the costs and complexities associated with data protection.
TechNet Webcast: Protecting SQL Server with System Center Data Protection Manager (DPM) (Level 300)
Further on-demand webcasts are available here: https://www.microsoft.com/events/series/technetsqlserver2005.mspx
New KB’s
SQL Server 2000 Standard Edition
SQL Server performance counters may not appear when you use System Monitor to monitor the performance counters on a remote computer that is running SQL Server 2000
https://support.microsoft.com/?kbid=928322
SQL Server 2000 Enterprise Edition
You cannot uninstall a SQL Server 2000 IA-64 hotfix and an error message is logged in the setup log file
https://support.microsoft.com/?kbid=928321
FIX: Error message when you try to apply a hotfix on a SQL Server 2000-based computer that is configured as a MSCS node: "An error in updating your system has occurred"
https://support.microsoft.com/?kbid=915065
SQL Server 2005 Standard Edition
FIX: SQL Server 2005 may not send a message notification that is based on the specific string in the forwarded event when a computer that is running SQL Server 2000 forwards an event to a computer that is running SQL Server 2005
https://support.microsoft.com/?kbid=926611
FIX: When you call a SQL Server 2005 Integration Services package from a SQL Server Agent job step, the package may stop responding
https://support.microsoft.com/?kbid=928243
You must perform a full database backup before you back up the transaction log for a database in SQL Server 2005 and in SQL Server 2000
https://support.microsoft.com/?kbid=928317
Error message when you run a distributed transaction on a SQL Server 2005-based or SQL Server 2000-based failover cluster: "Resource Manager creation failed: result code = 0x8004d102"
https://support.microsoft.com/?kbid=924151
FIX: Error message when you run a .NET Framework 1.0 or .NET Framework 1.1 application on a computer that has SQL Server 2005 installed
https://support.microsoft.com/?kbid=928319
FIX: You may receive incorrect results when you use the bulk copy program command-line utility to import data in SQL Server 2005
https://support.microsoft.com/?kbid=924344
The SQL Server service cannot start after you configure an instance of SQL Server 2005 to use a Secure Sockets Layer (SSL) certificate using the Microsoft Enhanced Cryptographic Provider 1.0
https://support.microsoft.com/?kbid=928779
FIX: Error message when you trace the Audit Database Management event and you try to bring a database online in SQL Server 2005: “Msg 942, Level 14, State 4, Line 1”
https://support.microsoft.com/?kbid=926335
FIX: A script task or a script component is executed multiple times in duplicate when you run packages that contain script tasks or script components in parallel in SSIS
https://support.microsoft.com/?kbid=928323
SQL Server 2005 Standard Edition
FIX: An access violation is logged in the SQL Server Errorlog file when you run a query that uses a plan guide in SQL Server 2005
https://support.microsoft.com/?kbid=928539
You cannot use existing tables on a heterogeneous subscriber database when you configure a push subscription to a heterogeneous subscriber in SQL Server 2005
https://support.microsoft.com/?kbid=928320
FIX: You receive an error message, or you obtain an incorrect result when you query data in a partitioned table that does not have a clustered index in SQL Server 2005
https://support.microsoft.com/?kbid=924808
FIX: A query may take a long time to compile when the query contains several JOIN clauses against a SQL Server 2005 database
https://support.microsoft.com/?kbid=922438
Error message when you use the dtsrun command prompt utility (Dtsrun.exe) to run a DTS package in SQL Server 2005 Integration Services: "This application has failed to start because SQLResourceLoader.dll was not found"
https://support.microsoft.com/?kbid=928324
SQL Server 2005 Standard Edition x64
A service pack does not install on a x64-based passive node cluster computer that is running SQL Server 2005
https://support.microsoft.com/?kbid=929151
SQL Server 2005 Analysis Services
FIX: You receive an error message when you deploy a cube dimension that has a dimension description in Business Intelligence Development Studio
https://support.microsoft.com/?kbid=923478
FIX: The metadata of the Description object of a Key Performance Indicator appears in the default language after you define a translation for the Description object in SQL Server 2005 Business Intelligence Development Studio