April 2008 - Technical Rollup Mail - SQL
News Microsoft SQL Server Data Services – Your Data, Any Place, Any Time SQL Server Data Services (SSDS) are highly scalable, on-demand data storage and query processing utility services. Built on robust SQL Server database and Windows Server technologies, these services provide high availability, security and support standards-based web interfaces for easy programming and quick provisioning. https://www.microsoft.com/sql/dataservices/default.mspx https://www.microsoft.com/sqlserver/2008/en/us/overview.aspx
Microsoft SQL Server 2008 – Elevating Administrator Productivity Microsoft SQL Server 2008 provides a policy-based system for managing one or more instances of SQL Server, along with tools for performance monitoring, troubleshooting, and tuning that enable administrators to more efficiently manage their databases and SQL Server instances. https://www.microsoft.com/sqlserver/2008/en/us/manageability.aspx https://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx Microsoft SQL Server 2008 – Powerful Programmability Microsoft SQL Server 2008 enables developers to be more productive and more easily create the next generation of robust database solutions using the powerful SQL Server T-SQL programming language and rich data types that manage virtually any type of data. https://www.microsoft.com/sqlserver/2008/en/us/programmability.aspx https://www.microsoft.com/sqlserver/2008/en/us/default.aspx Microsoft SQL Server 2008 – Query your data LINQ is an exciting evolution in data programming that enables developers to build queries over data directly from within any .NET-based programming language. LINQ to Entities, LINQ to DataSet, LINQ to SQL, and LINQ to XML are key implementations of this powerful technology. https://www.microsoft.com/sqlserver/2008/en/us/linq.aspx https://www.microsoft.com/sql/2008/overviewdemo/ Microsoft SQL Server 2008 – Access your data Enhanced SQL Server 2008 Native Client provides a high-performance, versatile data access library that enables developers to take advantage of the new capabilities of SQL Server 2008. https://www.microsoft.com/sqlserver/2008/en/us/native-data-access.aspx https://www.microsoft.com/sqlserver/2008/en/us/learning.aspx
Documents Choosing Microsoft SQL Server 2008 for Data Warehousing The warehousing of corporate data into an architecture from which it can all be accessed is no longer an option for midmarket and large companies that want to be successful. Consolidating the information so that it is readily accessible, and to give the team visibility for reporting, analytics, spot queries, and predictive capabilities is now necessary. Fortunately, pioneers established this long ago and this requirement is met in the field of data warehousing (DW) and business intelligence (BI). https://www.microsoft.com/sql/techinfo/whitepapers/sql-for-datawarehousing_2008.mspx
White Paper: Microsoft Data Platform Development Microsoft SQL Server 2008 and the Microsoft data platform provide developers with a comprehensive programming framework in which to create data-centric solutions that target mobile devices, desktops, Web servers, and enterprise servers. This data programming environment improves developer productivity by integrating data access and management into the business logic of an application. It provides a comprehensive platform for data access and management from disparate data sources, and a scalable solution for data storage and applications. https://www.microsoft.com/sqlserver/2008/en/us/wp-sql-2008-data-development.aspx
White Paper: What's New for XML in SQL Server 2008 Microsoft introduced XML-related capabilities in Microsoft SQL Server 2000 with the FOR XML and OPENXML Transact-SQL keywords, which enabled developers to write Transact-SQL code to retrieve a query result as a stream of XML and to shred an XML document into a rowset. SQL Server 2005 extended these XML capabilities significantly with the introduction of a native xml data type that supports XSD schema validation, XQuery-based operations, and XML indexing. SQL Server 2008 builds on the XML capabilities of previous releases and provides enhancements to meet the challenges that customers have faced when storing and manipulating XML data in the database. https://www.microsoft.com/sqlserver/2008/en/us/wp-sql-2008-whats-new-xml.aspx
White Paper: Managing Unstructured Data with SQL Server 2008 The proliferation of digital content has significant implications for the way in which organizations store and access business data. Increasingly, databases that are at the core of business applications must be integrated with unstructured data in the form of documents, images, video content, and other multimedia formats. Organizations increasingly need to be able to store and manage digital data of all formats in order to manage the information life cycle, meet compliance requirements, and implement content management solutions. https://www.microsoft.com/sqlserver/2008/en/us/wp-sql-2008-manage-unstructured.aspx White Paper: Delivering Location Intelligence with Spatial Data The growing ability of businesses and consumers to quickly absorb large volumes of data, together with the increased availability of digital maps and spatially enabled applications, has created an unprecedented opportunity to incorporate geographic factors into decision-making processes and analyses. The new spatial support in Microsoft SQL Server 2008 can help you to make better decisions through visual analysis of location data that can be stored and manipulated in a SQL Server database. https://www.microsoft.com/sqlserver/2008/en/us/wp-sql-2008-spatial-data.aspx White Paper: Server Consolidation with SQL Server 2008 Microsoft SQL Server 2008 supports multiple options for server consolidation, providing organizations with the flexibility to choose the consolidation approach that best meets their requirements to centralize data services management and to reduce hardware and maintenance costs. By providing centralized management, auditing, and monitoring capabilities, SQL Server 2008 makes it easy to manage multiple databases and data services, which significantly reduces administrative overheads in large enterprises. https://www.microsoft.com/sqlserver/2008/en/us/wp-sql-2008-server-consolidation.aspx Downloads IT Showcase: Line of Business Client Application Compatibility Testing at Microsoft Provides an overview of the Microsoft IT Application Compatibility Testing Program, which enables Microsoft to smoothly upgrade desktop software and operating systems in its business units and to provide product development teams with feedback from real-world application compatibility testing.
SQL Server White Papers: Migration from MySQL, Oracle, Sybase, or Microsoft Access to Microsoft SQL Server This release contains the following white papers: · Guide to Migrating from MySQL to SQL Server 2005 (114 pages) · Guide to Migrating from Oracle to SQL Server 2005 (161 pages) · Guide to Migrating from Sybase ASE to SQL Server 2005 (97 pages) · Guide to Migrating from Microsoft Access to SQL Server 2005 (52 pages)
Efficient Upgrade Increases Productivity and Reduces Frustration With employees in New York and Argentina, Eriksen Translation Services, Inc. needed a reliable, efficient platform for Line of Business applications. Upgrading to Windows Server 2008 in four days, Eriksen found that Terminal Services provided the secure, dependable experience they needed.
Critical Business Intelligence Platform for the Agile Enterprise Critical BI Systems provide sustainable success in a dynamic environment by empowering information workers at all levels of the enterprise and enabling them to use actionable, real-time information in their day-to-day tasks. Critical BI systems also empower application developers and IT professionals, enabling them to continuously and effectively create and manage BI solutions for the global marketplace. From a business perspective, critical BI not only translates into more cost-effective solutions, but also results in improved productivity and agility across the enterprise. When agile enterprises design critical BI systems, they use the Microsoft® SQL Server™ 2005 BI platform as the standard. Recognized in the marketplace for providing cost-effective BI solutions for the enterprise, the SQL Server 2005 BI platform delivers industry-leading BI technologies that uniquely satisfy the broad and deep demands of information workers, application developers, and IT professionals. Microsoft SQL Server Compact 3.5 Books Online and Samples SQL Server Compact 3.5 Books Online provides in-depth information about the features of the product. In addition to the Books Online, the sample applications helps to ramp up quickly on SQL Server Compact technology and an easy way to build applications rapidly.
Microsoft SQL Server 2008 Feature Pack CTP, February 2008 The Feature Pack is a collection of stand-alone install packages that provide additional value for SQL Server 2008. It includes the latest versions of: · Redistributable components for SQL Server 2008 · Add-on providers for SQL Server 2008 · Backward compatibility components for SQL Server 2008
SQL: Upgrade Service for Microsoft SQL Server 2005 Datasheet Gets you up and running by using an upgrade engagement with a robust new data management platform with its advanced data analysis and reporting. You can benefit from all that SQL Server 2005 offers, such as higher availability, improved scalability, and increased security.
Readme File for SQL Server 2008 Community Technology Preview Before installing the SQL Server 2008 Community Technology Preview (CTP), please review the readme file. The readme file contains late-breaking information about installation and functionality issues that may affect your installation.
Microsoft SQL Server 2000/2005 Management Pack The SQL Server Management Pack monitors the availability and performance of SQL Server 2000 and 2005 and can issue alerts for configuration problems. Availability and performance monitoring is done using synthetic transactions. In addition, the Management Pack collects Event Log alerts and provides associated knowledge articles with additional user details, possible causes, and suggested resolutions. The Management Pack discovers Database Engines, Database Instances, and Databases and can optionally discover Database File and Database File Group objects.
Microsoft SQL Server 2008 and System Center Microsoft SQL Server 2008 delivers a safe, secure, and reliable platform for running your most mission critical, line-of-business applications. It is the platform for building scalable business intelligence, data warehousing, and transaction processing that allows your business to grow and expand. Learn how System Center Operations Manager 2007, System Center Configuration Manager 2007, and System Center Data Protection Manager 2007 can benefit your SQL Server deployments.
SQL Server 2005 Report Packs SQL Server 2005 Reporting Services is a comprehensive, server-based reporting solution designed to help you author, manage, and deliver both paper-based, ad hoc, and interactive Web-based reports. Each report pack consists of a set of predefined reports, a sample database, a readme file, and an End User License Agreement (EULA). You can use these sample reports as templates to quickly author and distribute new interactive reports.
SQL: Migration Service for Microsoft SQL Server 2005 (Oracle) Datasheet Gets you up and running by using a migration engagement with a robust new data management platform with its advanced data analysis and reporting. You can benefit from all that SQL Server 2005 offers, such as higher availability, improved scalability, and increased security.
SQL: Migration Service for Microsoft SQL Server 2005 (Sybase) Datasheet Gets you up and running by using a migration engagement with a robust new data management platform with its advanced data analysis and reporting. You can benefit from all that SQL Server 2005 offers, such as higher availability, improved scalability, and increased security.
SQL Server 2005 Driver for PHP Community Technology Preview (February 2008) In its continued commitment to interoperability, Microsoft has released a new SQL Server 2005 Driver for PHP. The SQL Server 2005 Driver for PHP Community Technology Preview (CTP) download is available to all SQL Server users at no additional charge. The SQL Server 2005 Driver for PHP is a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts. The extension provides a procedural interface for accessing data in all editions of SQL Server 2005 and SQL Server 2000.
SQL Server 2008 Books Online Community Technology Preview (February 2008) SQL Server 2008, the next release of Microsoft SQL Server, provides a comprehensive data platform. Books Online is the primary documentation for SQL Server 2008. Download a pre-release preview of Books Online for SQL Server 2008. If you were looking for the latest released version of Books Online, visit the SQL Server 2005 Books Online page on the Microsoft Download Center.
Microsoft SQL Server 2008 CTP, February 2008 Microsoft SQL Server 2008, the next release of Microsoft SQL Server, provides a comprehensive data platform that is more secure, reliable, manageable and scalable for your mission critical applications, while enabling developers to create new applications that can store and consume any type of data on any device, and enabling all your users to make informed decisions with relevant insights. Visual Studio 2008 Support for SQL Server 2008, Community Technology Preview This CTP resolves a problem that when you try to open a database connection to SQL Server 2008 by using Visual Studio 2008 design tools, you may receive the following error message: “This server version is not supported. Only servers up to Microsoft SQL Server 2005 are supported.” This CTP addresses this issue, and enables the following Visual Studio functionality for SQL Server 2008: · Server Explorer successfully connects to SQL Server 2008, and database objects such as stored procedures and table data can be viewed and edited. Note that table schemas still cannot be viewed or edited in this release. · SQL CLR projects that target SQL Server 2008 can be created and deployed to the server.
Microsoft® Visual Studio Team System 2008 Database Edition Power Tools This release updates the Power Tools for the Database Edition to work with Visual Studio 2008 and provides several new features. The new features include two custom unit test conditions, a new Data Generation Wizard, and new MSBuild tasks to support running TSQL Static Code Analysis from the command line. The updated features include 5 refactoring types, a dependency viewer, additional data generators and editors, 2 MSBuild tasks for Schema and Data Compare and the TSQL Static Code Analysis featureNew Test Conditions for Database Unit Tests• ChecksumCondition – You can use this test condition to verify that the checksum of the data set returned by a database unit test matches the checksum of an expected data set.• ExpectedSchemaTestCondition – You can use this test condition to verify that the column names and data types of the returned data set match expected values. Microsoft SQL Server Compact 3.5 SP1 Beta for ADO.Net Entity Framework Beta 3 SQL Server Compact 3.5 SP1 Beta release for the ADO.Net Entity Framework Beta 3 enables the following scenarios: · Applications can work in terms of a more application-centric conceptual model, including types with inheritance, complex members, and relationships · Applications are freed from hard-coded dependencies on a particular data engine or storage schema · Mappings between the conceptual application model and the storage-specific schema can change without changing the application code · Developers can work with a consistent application object model that can be mapped to various storage schemas, possibly implemented in different database management systems 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. TechNet Webcast: 24 Hours of SQL Server 2008: Securing Your System (Level 200) – Wednesday, April 02, 2008 11:30 AM Pacific Time (US & Canada) While it is extremely important to secure your data, it is also vital to secure your system also. One without the other is not a secure solution. In this webcast, we look at the systems on which Microsoft SQL Server relies and runs. Contoso made two major decisions concerning their data: the first was to use Microsoft SQL Server 2008, the second was to move to Windows Server 2008 at the back end and Windows Vista at the front end. These two operating systems together offered the best solution going forward. In this session, we focus on the Windows Server 2008 part of the combination to look at the features that enabled Contoso to secure their systems that run SQL Server and its required services. Key security features that we cover are: surface area configuration policies, external key management, Network Access Protection (NAP), and Windows BitLocker Drive Encryption. TechNet Webcast: 24 Hours of SQL Server 2008: Securing Your System (Level 200) MSDN Webcast: 24 Hours of SQL Server: Synchronize Your Data Using the Microsoft Sync Framework (Level 100) – Friday, April 04, 2008 11:30 AM Pacific Time (US & Canada) Join this series as we look at Microsoft SQL Server 2008 as a productive data platform. Throughout this series, we use Contoso (Container Overseas Shipping Operation) LTD as our scenario customer while we explore the features that make SQL Server 2008 this platform. Contoso is a shipping company; they arrange the shipping of all kinds of items around the globe, from small individual items to large manufactured items. Contoso has seen growth in its business over the past years, especially in the movement of goods from China around the world. While Contoso is happy with their in-house applications and believe they provide significant business advantage over competitors, Contoso wants to ensure that these applications are running on the best productive platform to maintain this advantage, especially as their business grows worldwide. In this session , we look at how Contoso is empowering its mobile workforce to work and synchronize data when away from the office. Contoso has agents and employees out in the field, either delivering or collecting consignments, inspecting consignments, or visiting customers to quote jobs. These field employees use a variety of devices, from Pocket PCs to tablet PCs. To ensure that these employees have the latest information, Contoso is updating its applications to take advantage of the Microsoft Sync Framework to let these devices store data locally, run executables, and sync the data later. Join us as we cover the Sync Framework and describe how to best create these types of applications. TechNet Webcast: 24 Hours of SQL Server 2008: Ensuring Business Continuity (Level 200) – Monday, April 07, 2008 11:30 AM Pacific Time (US & Canada) Contoso expansion over the past years increased the challenges the IT organization faced with regard to the increased number of offices and data growth. As jobs come in and consignments travel around the globe, different external organizations require information 24-7. The Microsoft SQL Server systems have to be available around the clock around the world. In this session, we look at high availability options in Microsoft SQL Server 2008 that help ensure that these systems are there when they are needed--regardless of what component has failed. TechNet Webcast: 24 Hours of SQL Server 2008: Ensuring Business Continuity (Level 200) Upgrade SQL Now - Live Meeting Series – Tuesday, April 08, 2008 12:00 PM Eastern Time (US & Canada) These sessions will cover the issues around upgrading SQL including features and tips. Feel free to register for all any number of the offered. Session will run from December 2007 through May 2008. SESSION V: SQL Analysis Services : The Unified Data Model (UDM) is a new model used in Analysis Services. This feature combined with proactive caching makes it possible to have timely information available to make better decisions. Join us to discuss the benefits of this new feature set. MSDN Webcast: 24 Hours of SQL Server 2008: Streamline Data Access with SQL Server 2008 (Level 100) TechNet Webcast: 24 Hours of SQL Server 2008: Scale Your Business (Level 200) – Monday, April 14, 2008 11:30 AM Pacific Time (US & Canada) Contoso, like most firms, found that once one database is deployed, others soon follow. Unless planned, these deployments can scale out of control. Microsoft SQL Server 2008 offers a number of features that provide solutions for Contoso to scale out and up, while maintaining control. In this webcast, we show you how to take advantage of the latest hardware, such as 64-bit, hot add memory, and CPU, as well as software features. Learn to speed up query processing with Partitioned Table Parallelism through backup and compression, and to speed up backup times and replication. TechNet Webcast: 24 Hours of SQL Server 2008: Scale Your Business (Level 200) TechNet Webcast: 24 Hours of SQL Server 2008: Predictable Response to Your Users (Level 200) – Wednesday, April 16, 2008 11:30 AM Pacific Time (US & Canada) At any given time, Contoso's servers provide multiple services to users and applications. Using Microsoft SQL Server 2008, Contoso would like to achieve better performance with its workloads. In this session, we look the Resource Governor, which enables administrators to define limits and assign priorities to individual workloads that are running on a SQL Server instance. We also look at Plan Freezing in SQL Server 2008, which enables greater query performance stability and predictability by providing new functionality to lock down query plans. This enables organizations to promote stable query plans across hardware server replacements, server upgrades, and production deployments. TechNet Webcast: 24 Hours of SQL Server 2008: Predictable Response to Your Users (Level 200) TechNet Webcast: 24 Hours of SQL Server 2008: Performance Troubleshooting (Level 200) – Monday, April 21, 2008 11:30 AM Pacific Time (US & Canada) An area of concern for Contoso is the monitoring and troubleshooting of any performance issues it may encounter on Microsoft SQL Server 2008. In this session, we cover the tools available for IT departments as they troubleshoot performance. We look at Performance Studio, the features available, and how to use them to analyze performance. We also cover how to use the Best Practice Analyzer for SQL Server, and utilizing the results it provides. TechNet Webcast: 24 Hours of SQL Server 2008: Performance Troubleshooting (Level 200) TechNet Webcast: 24 Hours of SQL Server 2008: Upgrade Your Database (Level 200) – Wednesday, April 23, 2008 11:30 AM Pacific Time (US & Canada) Unless you have never deployed Microsoft SQL Server, sooner or later you may look at upgrading to a new version. Contoso would like to move their existing SQL Server databases to Microsoft SQL Server 2008 and, at the same time, take advantage of the latest improvements in Business Intelligence (BI). In this session, we look at the methods that Contoso used to upgrade. TechNet Webcast: 24 Hours of SQL Server 2008: Upgrade Your Database (Level 200) Further on-demand webcasts are available here: https://www.microsoft.com/events/series/technetsqlserver2005.mspx
New KB's
SQL Server 2000 Standard Edition FIX: The SPACE function always returns one space in SQL Server 2000 if the SPACE function uses a collation that differs from the collation of the current database https://support.microsoft.com/?kbid=946584
SQL Server 2005 Standard Edition FIX: The Wmiprvse.exe host process may stop unexpectedly when you run an application that uses the WMI provider to monitor an instance of SQL Server 2005 https://support.microsoft.com/?kbid=942907
Performance counter data is not updated when you run a tool that uses SQL Server performance counters to collect performance data against an instance of SQL Server 2005 https://support.microsoft.com/?kbid=949115
FIX: Additional rows are deleted at the publisher in a merge replication if the merge replication contains join filters in SQL Server 2005 https://support.microsoft.com/?kbid=949108
Problems occur on a server that is running SQL Server 2005 when you upgrade Windows Server 2003 Service Pack 2 to Windows Server 2008 https://support.microsoft.com/?kbid=948594
FIX: Error message when you install the release version of SQL Server 2005 on a server that has Windows Internal Database SP2 installed: "The SQL Server service failed to start" https://support.microsoft.com/?kbid=942980
The latency of a transactional replication is high in SQL Server 2005 when the value of the "Initial Size" property and the value of the Autogrowth property are small https://support.microsoft.com/?kbid=949523
FIX: Error message when you run queries on a database that has the SNAPSHOT isolation level enabled in SQL Server 2005: "Unable to deallocate a kept page" https://support.microsoft.com/?kbid=949199
FIX: Some rows are not returned when you run a complex query that uses the DISTINCT keyword in Microsoft SQL Server 2005 https://support.microsoft.com/?kbid=948658
Error message when you execute a CLR routine or use an assembly in SQL Server 2005: "Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)" https://support.microsoft.com/?kbid=949080
FIX: Error message when you synchronize the data of a merge replication in SQL Server 2005: "The merge process is retrying a failed operation made to article 'ArticleName' - Reason: 'Invalid input parameter values. Check the status values for detail.'" https://support.microsoft.com/?kbid=949959
FIX: A query may return an incorrect result when the query contains a subquery and performs a Sort operation in SQL Server 2005 https://support.microsoft.com/?kbid=948367
FIX: No results are returned when you run a stored procedure in Server Explorer in Business Intelligence Development Studio if the stored procedure returns a column of the uniqueidentifier data type in SQL Server 2005 https://support.microsoft.com/?kbid=944682
FIX: SQL Server 2005 requests columns that you do not expect when you run a SELECT statement https://support.microsoft.com/?kbid=949200
FIX: Error message when you run a transaction from a remote server by using a linked server in SQL Server 2005: "This operation conflicts with another pending operation on this transaction" https://support.microsoft.com/?kbid=949687
FIX: Error message when you run a query that uses a join condition in SQL Server 2005: "Non-yielding Scheduler" https://support.microsoft.com/?kbid=949595
If you create a certificate on February 29 or you set the start date of a certificate to February 29, SQL Server 2005 sets the expiry date to an unexpected value https://support.microsoft.com/?kbid=950064 FIX: SQL Server 2005 is not installed on a Windows Web Server 2008-based system https://support.microsoft.com/?kbid=950636
SQL Server 2005 Reporting Services
FIX: Complex script characters appear incorrectly when you display a SQL Server 2005 Reporting Services report in the PDF format https://support.microsoft.com/?kbid=944358 FIX: Internal parameter unexpectedly appears when you subscribe to a report that was deployed to a report server that runs in the SharePoint integrated mode https://support.microsoft.com/?kbid=949121 SQL Server 2000 Analysis Services FIX: A handle leak issue occurs when you connect to an instance of Analysis Services that uses dynamic security https://support.microsoft.com/?kbid=943001 SQL Server 2005 Analysis Services FIX: Error message when you restore some databases from some backup files in SQL Server 2005 Analysis Services: “XML parsing failed at line 1, column 64914: '>' expected” https://support.microsoft.com/?kbid=949116 FIX: Error message when you try to create a currency conversion against an Oracle data source in SQL Server 2005 Analysis Services: "The following statement executed when creating named query: SELECT 'Reporting Currency'" https://support.microsoft.com/?kbid=949631
|