February 2007 - Technical Rollup Mail - SQL
News
SQL Server 2005 Best Practice Analyser
SQL Server 2005 Best Practice Analyser to Ship with SP2 in Q1 2007
https://blogs.msdn.com/sqlrem/archive/2007/01/12/SP2-and-BPA-FAQ.aspx
SQL Server Compact Edition Launches
Microsoft SQL Server 2005 Compact Edition is the next version of SQL Server Mobile adding the desktop platform. SQL Server Compact extends the SQL Server Mobile technology by offering a low maintenance, compact embedded database for single-user client applications for all Windows platforms including tablet PCs, pocket PCs, smart phones and desktops. Just as with SQL Server Mobile, SQL Server Compact is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2005 for developing desktop and mobile applications.
https://www.microsoft.com/sql/editions/compact/default.mspx
Microsoft’s SQL Server 2005 Wins Developer.Com’s Database Tool Product of the Year
SQL Server 2005 took the award as Best Database Tool in Developer.com's annual Product of the Year contest, with the winner in each category determined by the readers of the site voting for their choice as the best in their field.
https://www.developer.com/db/article.php/3653956
Documents
Printing Services Firm Creates 1 Terabyte Data Warehouse with SQL Server 2005
WorkflowOne helps organizations as diverse as the American Red Cross, Roto-Rooter, and Toys “R” Us save on their printing costs by providing end-to-end solutions for printing projects, with services including design, sourcing, production, warehousing, marketing, fulfilment, and delivery. After acquiring another company, Relizon, WorkflowOne IT needed to create a centralized data store that would provide richer and more flexible reporting than what was available from its AS/400 systems. The company created an operational data store (ODS) using Microsoft® SQL Server™ 2005 Enterprise Edition (64-bit) and SQL Server 2005 Reporting Services running on an AMD Opteron™ based Egenera® BladeFrame™ system. The solution has worked so well that WorkflowOne plans to add multidimensional analytics using SQL Server 2005 Analysis Services, and expand the ODS into a 1 terabyte data warehouse.
Scandinavian Airlines Moves Data Warehouse From Mainframe to SQL Server 2005
Scandinavian Airlines, which carries 40 million passengers a year, was a pioneering in generating business intelligence (BI) from its data to more efficiently meet customer needs. But its original data warehouse, which was deployed on an IBM mainframe and the DB2 database, had become expensive to run and maintain, and its batch-based system made it difficult to provide analysts and other users with the timely information they needed. After completing a successful proof of concept project, the company is moving its data warehouse to Microsoft® SQL Server™ 2005 Enterprise Edition hosted on HP DL585 servers with Intel Dual-Core Xeon 5170 processors. Micro Focus International, a Microsoft Gold Certified Partner, provided an emulation program for running extract, transform, and load processes that had been written in COBOL for the mainframe, simplifying the migration to SQL Server 2
Questions and Answers in this Month’s TechNet Magazine
https://www.microsoft.com/technet/technetmag/issues/2007/02/SQLQA/default.aspx
White Paper: Business Intelligence Meets Business Process Management
Whether they involve distributing goods to customers, collaborating with suppliers, or coordinating the efforts of employees, business processes are the foundation on which rest a business’s products, services, and brands. They are the essential underpinning of an organization’s ability to function. In successful companies, business processes align resources to support the achievement of goals.
Business process management (BPM) is a methodology to ensure that those processes support a common set of goals and objectives. It involves automating and improving the effectiveness of process activities, tasks, and outcomes to accomplish particular business purposes. Its goals include not only efficiency and productivity, but also control, responsiveness, and improvement. Efficiency enables individuals to maximize the time they can devote to priority business tasks and to maximize throughput. Control assures that company resources are aligned optimally to execute strategies. Responsiveness and improvement support the competitive differentiation that enables a company to excel over others.
https://www.microsoft.com/sql/techinfo/whitepapers/bimeetsbpm.mspx
Downloads
Video Series: SQL Server 2005 Express Edition for Beginners
This video series is designed specifically for SQL Server beginners—individuals who are interested in learning the basics of how to create, manage, and connect to SQL Server Express databases. Whether you’re just a beginner or somewhat familiar with databases, these video lessons will help you get better acquainted with SQL Server 2005 Express.
https://msdn.microsoft.com/vstudio/express/sql/learning/default.aspx
Microsoft SQL Server 2005 Compact Edition Overview
A new generation of applications is on the horizon for businesses and consumers, driven by market changes such as a growing mobile workforce and its need for productivity even when not “connected.” This need is creating an explosive growth of new devices such as personal digital assistants (PDAs), portable music players, and gaming consoles, creating exciting possibilities for new applications. These new applications place new demands on the data platform on which they are developed. To meet the needs of this changing application landscape, Microsoft introduces its newest edition of the SQL Server database product line—SQL Server 2005 Compact Edition—a maintenance-free, compact embedded database for single-user client applications for all Windows platforms, including tablet PCs, pocket PCs, smart phones and desktops. Compact Edition is available to deploy and redistribute free of charge.This white paper outlines the current business and consumer environment and the key factors that influence the need for this new generation of applications. It describes how SQL Server Compact Edition can be used to satisfy the data platform demands of these applications.
https://www.microsoft.com/sql/editions/compact/ssceoverview.mspx
Microsoft SQL Server Database Publishing Wizard 1.0
SQL Server Database Publishing Wizard enables the deployment of SQL Server databases into a hosted environment on either a SQL Server 2000 or 2005 server. It generates a single SQL script file which can be used to recreate a database (both schema and data) in a shared hosting environment where the only connectivity to a server is through a web-based control panel with a script execution window. If supported by the hosting service provider, the Database Publishing Wizard can also directly upload databases to servers located at the shared hosting provider. Optionally, SQL Server Database Publishing Wizard can integrate directly into Visual Studio 2005 and/or Visual Web Developer 2005 allowing easy publishing of databases from within the development environment.
Microsoft SQL Server Database Publishing Services 1.0
SQL Server Database Publishing Services are ASP.NET web services designed for shared hosting providers to enable the deployment of SQL Server databases without directly exposing SQL Server to the Internet. This web service is designed to be used with the Microsoft SQL Server Database Publishing Wizard Client (above).
Visual Studio 2005 Team Edition for Database Professionals Add-on for Visual Studio 2005 Team Suite Edition
This add-on provides Visual Studio 2005 Team Suite users with the additional functionality provided by Visual Studio 2005 Team Edition for Database Professionals. Visual Studio 2005 Team Suite is required to use this add-on. If you do not currently own Visual Studio 2005 Team Suite Edition but would like to evaluate Visual Studio 2005 Team Edition for Database Professionals in a trial mode, you may do so by first installing the Visual Studio 2005 Team Suite Trial Edition and then installing this add-on which will function until the Team Suite trial period expires.
Feature Pack for Microsoft SQL Server 2005 Service Pack 2 - Community Technology Preview (CTP) December 2006
The Community Technology Preview (CTP) version of the Feature Pack for SQL Server 2005 Service Pack 2 (SP2) is now available. The Feature Pack is a collection of standalone install packages that provide additional value for SQL Server 2005. It includes:
Latest versions of redistributable components for SQL Server 2005
· Latest versions of add-on providers for SQL Server 2005
· Latest versions of backward compatibility components for SQL Server 2005
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: Protecting SQL Server with System Centre Data Protection Manager (DPM) (Level 300)
Microsoft System Center 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)
Technet Webcast: Achieving Higher Scalability with SQL Server on Windows Server 2003 R2 Enterprise Edition (Level 300)
In this webcast, we focus on planning, implementing, and administering a Microsoft SQL Server 2005 failover cluster on Microsoft Windows Server 2003 R2 Enterprise Edition. To ease the upgrade process for existing users of Microsoft SQL Server 2000 failover clustering, we also point out the differences between a SQL Server 2005 failover cluster and a SQL Server 2000 failover cluster.
Further on-demand webcasts are available here: https://www.microsoft.com/events/series/technetsqlserver2005.mspx
New KB’s
SQL Server 2000 Standard Edition
FIX: Error message when you run a full-text query in SQL Server 2000: "Error: 17883, Severity: 1, State: 0"
https://support.microsoft.com/?kbid=929410
FIX: Data in a subscriber of a merge publication in SQL Server 2000 differs from the data in the publisher
https://support.microsoft.com/?kbid=923796
FIX: SQL Server 2000 stops responding when you cancel a query or when a query time-out occurs, and error messages are logged in the SQL Server error log file
https://support.microsoft.com/?kbid=928568
SQL Server 2000 Reporting Services
FIX: You cannot install SQL Server 2000 Reporting Services on a computer that has more than 16 processors
https://support.microsoft.com/?kbid=929639
FIX: Error message when you open the Excel workbook after you export a report in SQL Server 2000 Reporting Services: "Name cannot be the same as built in name"
https://support.microsoft.com/?kbid=913265
SQL Server 2005 Standard Edition
How to improve concurrency in a SQL Server 2005 application by using built-in functions
https://support.microsoft.com/?kbid=928907
FIX: You may experience very large growth increments of a principal database after you manually fail over a database mirroring session in SQL Server 2005
https://support.microsoft.com/?kbid=925277
FIX: Error message in the database mail log when you try to use the sp_send_dbmail stored procedure to send an e-mail in SQL Server 2005: "Invalid XML message format received on the ExternalMailQueue"
https://support.microsoft.com/?kbid=928789
Some menu items in Visual Studio 2005 are missing when you open or create a project in Visual Studio 2005 after you install SQL Server 2005 Business Intelligence Development Studio
https://support.microsoft.com/?kbid=929664
FIX: SQL Server Agent does not send an alert quickly or does not send an alert when you use an alert of the SQL Server event alert type in SQL Server 2005
https://support.microsoft.com/?kbid=926612
Error message when you use XML functionalities against an instance of SQL Server 2000 after you upgrade an instance of SQL Server 2000 to SQL Server 2005: "Failed to load msxmlsql.dll"
https://support.microsoft.com/?kbid=929668
The value of the Collation registry entry is changed to the SQL_Latin1_General_CP1_CI_AS value after you install SQL Server 2005 Service Pack 2 Community Technology Preview or SQL Server 2005 Service Pack 1
https://support.microsoft.com/?kbid=929666
FIX: Error message when you restore a transaction-log backup that is generated in SQL Server 2000 SP4 to an instance of SQL Server 2005: "Msg 3456, Level 16, State 1, Line 1. Could not redo log record"
https://support.microsoft.com/?kbid=926493
FIX: The CPU usage of the server reaches 100% when many DML activities occur in SQL Server 2005
https://support.microsoft.com/?kbid=915308
FIX: The merge agent fails and a "permission denied" error message is logged when you synchronize a SQL Server 2005-based merge publication
https://support.microsoft.com/?kbid=915306
How to configure an IPv6 resource for a SQL Server 2005 cluster on a Windows Longhorn Server-based computer
https://support.microsoft.com/?kbid=923398
FIX: A memory leak may occur every time that you synchronize a SQL Server Mobile subscriber in SQL Server 2005
https://support.microsoft.com/?kbid=929179
FIX: Updates to the SQL Server Mobile subscriber may not be reflected in the SQL Server 2005 merge publication
https://support.microsoft.com/?kbid=927289
FIX: You experience a slow uploading process if conflicts occur when many merge agents upload changes to the publishers at the same time in SQL Server 2005
https://support.microsoft.com/?kbid=915307
FIX: The full-text index population for the indexed view is very slow in SQL Server 2005
https://support.microsoft.com/?kbid=928537
FIX: The sp_MSinitDynamicSubscriber stored procedure is called more than one time by using the same parameters in SQL Server 2005
https://support.microsoft.com/?kbid=919949
Error message when you try to upgrade from SQL Server 2000 to SQL Server 2005: "Cannot insert duplicate key row in object 'dbo.syscategories' with unique index 'clust'"
https://support.microsoft.com/?kbid=928956
FIX: When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL Server 2005
https://support.microsoft.com/?kbid=915309
FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005
https://support.microsoft.com/?kbid=913494
SQL Server 2005 Developer Edition
FIX: The output rows of the Aggregate transformation are divided into multiple rows in SQL Server 2005 Integration Services
https://support.microsoft.com/?kbid=928792
FIX: The SQL Native Client OLE DB provider (SQLNCLI) leaks memory when you call the IRowsetFastLoad::Commit method in a SQL Server 2005-based application
https://support.microsoft.com/?kbid=929375
SQL Server 2005 Enterprise Edition
FIX: You receive an error message when you try to create a full-text schedule by using SQL Server Management Studio in localized versions of SQL Server 2005
https://support.microsoft.com/?kbid=917426
SQL Server 2005 Enterprise Edition
Error message when you install SQL Server 2005 Express Edition with Advanced Services: "SQL Server Setup failed to retrieve the SSL Certificate Name"
https://support.microsoft.com/?kbid=929589
Error message when you install SQL Server 2005 Express Edition Service Pack 2 Community Technology Preview: "An installation package for the product Microsoft SQL Server Native Client cannot be found"
https://support.microsoft.com/?kbid=929667
FIX: Indexes may grow very large when you insert a row into a table and then update the same row in SQL Server 2005
https://support.microsoft.com/?kbid=916046
SQL Server 2005 Analysis Services
FIX: Some cells return the NULL value instead of returning the actual value when you query a dimension that contains a parent/child hierarchy in a SQL Server 2005 Analysis Services cube
https://support.microsoft.com/?kbid=919957
FIX: Error message when you run a query against a cube that contains linked objects in SQL Server 2005 Analysis Services: "Internal error An unexpected error occurred"
https://support.microsoft.com/?kbid=925566
Error message when you run a Multidimensional Expressions (MDX) query from a linked server in SQL Server 2005 against a SQL Server 2005 Analysis Services database: "Msg 7341, Level 16, State 2, Line 1 Cannot get the current row value of column"
https://support.microsoft.com/?kbid=925869
BUG: Error message when you try to use a data mining model in a SQL Server 2005 Analysis Services project: "Errors in the metadata manager The data type of the 'Customer_Integer ~MC' measure must be the same as its source data type"
https://support.microsoft.com/?kbid=926045
FIX: Processing is never completed and cannot be stopped when you process a cube in SQL Server 2005 Analysis Services