July 2008 - Technical Rollup Mail - SQL
News Technical RollUp https://blogs.technet.com/trm/default.aspx SQL Server 2008 RC0 Available for Everyone Downloads IDC Analysis Relational Database Systems IDC Analysis of worldwide Database Systems Source Code Analyzer for SQL Injection Microsoft Source Code Analyzer for SQL Injection is a static code analysis tool for finding SQL Injection vulnerabilities in ASP code. Customers can run the tool on their ASP source code to help identify code paths that are vulnerable to SQL Injection attacks. SQL Server 2008 RC0 Release Notes This Release Notes document contains information for Microsoft SQL Server 2008 Release Candidate 0 (RC0) that supplements the SQL Server 2008 RC0 Readme and Books Online documentation. This document describes behaviors that apply only to this release or that are not documented in this release of Books Onl Microsoft SQL Server 2008 Feature Pack RC0, June 2008 Download the June 2008 Feature Pack RC0 for Microsoft SQL Server 2008, a collection of stand-alone install packages that provide additional value for SQL Server 2008. SQL Server Reporting Services Add-in for SharePoint Technologies The Microsoft SQL Server 2008 Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of Windows SharePoint Services 3.0 or Microsoft Office SharePoint Server 2007. SQL Server 2008 RC0 Download Microsoft SQL Server 2008 Release Candidate 0 (RC0) and preview the latest features of SQL Server 2008! The SQL Server development team uses your feedback to help refine and enhance product features. Evaluate SQL Server 2008 RC0 today and send your feedback. Visio Add-In for SQL Server Visio Infrastructure for SQL Servers is a tool which is meant for IT administrators who require constant interactions with the users for the installations of the SQL server in any IT infrastructure. SQL Server 2008 Books Online Release Candidate (RC0) Download the release candiate (RC0) version of the documentation and tutorials for Microsoft SQL Server 2008. TechNet Security Series Seminar IV (5 Jun 2008) Presentation materials for the TechNet Security Series Seminar (29 Feb 2008) .NET Rocks! - Pablo Castro on Astoria Pablo Castro from the SQL Server Product Group at Microsoft talks about his work with Astoria, an infrastructure for bringing web technologies and data sources together. Astoria uses the Entity Framework, which Pablo is also involved with. SQL Server 2008 RC0 Readme The Readme document contains important information to read before installing Microsoft SQL Server 2008 Release Candidate 0 (RC0). Microsoft® Visual Studio Team System 2008 Database Edition GDR June CTP Microsoft® Visual Studio Team System 2008 Database Edition GDR implements support for SQL Server 2008. eConnect for Microsoft Dynamics GP 10.0 Article: eConnect Serialization Example Using Microsoft Visual Basic .NET and ADO.NET This article demonstrates how to serialize data from a custom Microsoft SQL Server table and use eConnect objects to integrate the records into Microsoft Dynamics GP 10.0. EPS English - Windows Server 2008 w/ SQL Server 2005 This download comes as a pre-configured VHD. This download enables testing of application designs on the Windows Server Platform. SQL Server 2005 Driver for PHP CTP (May 2008) Download the SQL Server 2005 Driver for PHP CTP for May 2008, a PHP 5 extension that allows for the reading and writing of SQL Server data from within PHP scripts. Documents SQL Server 2008 Product Overview https://www.microsoft.com/sqlserver/2008/en/us/wp-sql-2008-overview.aspx For organizations to be successful and thrive in today’s world of data, they need a vision that addresses key data trends. The data platform vision of Microsoft helps organizations meet these data explosion needs and the next generation of data-driven applications. Microsoft will continue to invest in and evolve the following key areas to support the Data Platform Vision: mission-critical enterprise data platform, dynamic development, relational data, and business intelligence. Read this paper to learn about the Microsoft Data Platform Vision and how SQL Server 2008 meets the needs of the next generation of data-driven applications. Accessing External Data Sources with Microsoft SQL Server Analysis Services 2005 https://msdn.microsoft.com/en-us/library/aa964120.aspx This white paper covers a variety of client object models supported by Microsoft SQL Server Analysis Services when connecting to relational data sources. The example problems and solutions were gathered by members of the Analysis Services team while working with users of Analysis Services. (5 printed pages) Events/Webcasts Webcast: 24 Hours of SQL Server 2008: Using the Microsoft Data Platform for Easy Data Access with SQL Server 2008 (Level 100) 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 webcast, we look at how Contoso LTD can take advantage of the Microsoft data platform to extend their applications. We concentrate on Microsoft .NET Language-Integrated Query (LINQ) and the ADO.NET Entity Framework with examples of how Contoso can use these technologies to access their data. Join us as we go into detailed coverage of data platform features, LINQ, and ADO.NET Entity Framework MSDN Webcast: Optimizing Online, Enabling Offline with SQL Server Compact and Sync Services for ADO.NET (Level 200) With Microsoft SQL Server Compact, developers can now easily cache data on the client in a compact, yet capable, transactional, queryable document-like database format. To maintain the cache, Sync Services for ADO.NET enables developers to easily cache data directly or over services using Windows Communication Foundation (WCF). Microsoft Visual Studio 2008 delivers new integrated, developer-oriented sync designers making caching an easy task to increase user productivity, decrease the server workload, and simplify data access. Using Sync Services for ADO.NET, developers can enable full offline scenarios as well. Join this webcast to find out what SQL Server Compact and Sync Services for ADO.NET have to offer for the "edge of the network" clients.
With Microsoft SQL Server Compact 3.5 and Microsoft Visual Studio 2008, developers have an easy-to-deploy solution for local data. Ranging from caching reference data to full offline scenarios, developers can use a single engine for their Windows Mobile-powered devices, or their full desktop clients–benefiting from the power of SQL Server in a compact footprint. Using Visual Studio 2008, we show how SQL Server Compact can be transparently deployed with unique features including updatable result sets and a custom document format, and how to manage the creation and maintenance of your local data. This session is packed with demonstrations that can get you started today. New KB's A maintenance plan that contains an Update Statistics task runs slowly after you install SQL Server 2005 Service Pack 2 https://support.microsoft.com/?kbid=953117 A CROSS JOIN clause is automatically inserted into an UPDATE statement that uses an INNER JOIN clause when you execute the statement in the SQL pane of SQL Server Management Studio https://support.microsoft.com/?kbid=953119 Changes to a SQL Server Agent job are lost when the job corresponds to a subplan in a maintenance plan that you created in SQL Server 2005 Service Pack 2 https://support.microsoft.com/?kbid=953118 Error message when you run the bcp utility to copy a result set of a stored procedure that contains a dynamic query in SQL Server 2005: "BCP host-files must contain at least one column" https://support.microsoft.com/?kbid=952734 FIX: A time series prediction query takes a long time to run in SQL Server 2005 Analysis Services https://support.microsoft.com/?kbid=953547 FIX: Error message when you run an UPDATE CUBE statement against a write-enabled cube in SQL Server 2005 Analysis Services: "Errors in the high-level relational engine" https://support.microsoft.com/?kbid=953552 FIX: An access violation occurs when you run an XMLA query in SQL Server 2005 Analysis Services https://support.microsoft.com/?kbid=953553 FIX: Error message when you run an MDX query by using the ADOMD.NET data provider in SQL Server 2005 Analysis Services: "Input string was not in a correct format" https://support.microsoft.com/?kbid=933266 FIX: Error message when you run an MDX query that includes a CROSSJOIN operation in SQL Server 2005 Analysis Services: "An unexpected exception occured" https://support.microsoft.com/?kbid=950967 FIX: An access violation occurs when you run two DMX queries against the same time series mining model at the same time in SQL Server 2005 Analysis Services https://support.microsoft.com/?kbid=953548 FIX: Duplicate data is written to other flat files in an SSIS package that contains a Foreach Loop container https://support.microsoft.com/?kbid=953491 Query performance is slow when you run a query that contains an ORDER BY clause on a table column of an SQL tertiary collation https://support.microsoft.com/?kbid=951935 FIX: The Replication Log Reader Agent may fail intermittently when a transactional replication synchronizes data in SQL Server 2005 https://support.microsoft.com/?kbid=952330 FIX: Error message when you restart the SQL Server service or the SQL Server Agent service in SQL Server 2005: "Unable to start mail session" https://support.microsoft.com/?kbid=953321 The DBCC CHECKDB statement does not raise exceptions in SQL Server when the DBCC CHECKDB statement detect a consistency error in the database https://support.microsoft.com/?kbid=953503 FIX: In SQL Server 2005, no databases are selected in the Database(s) list in the "Back Up Database Task" dialog box after you install critical update 933508 https://support.microsoft.com/?kbid=953116 FIX: E-mail replies are sent to the sender address instead of to the address that is specified in the database mail profile in SQL Server 2005 after you install the .NET Framework 2.0 Service Pack 1 https://support.microsoft.com/?kbid=953841 Supported method for applying updates to SQL Server 7.0 https://support.microsoft.com/?kbid=953743 FIX: You may receive the incorrect result when you query a calculated member that uses the Aggregate function or the Sum function and that uses another calculated member in SQL Server 2005 Analysis Services https://support.microsoft.com/?kbid=953676 SQL Server 2000 installers do not update disabled SQL Server instances https://support.microsoft.com/?kbid=953740 SQL Server 2005 installers do not update an instance of the SQL Server service that is in a disabled state https://support.microsoft.com/?kbid=953739 A tape device is not detected by SQL Server Management Studio in SQL Server 2005 or by SQL Server Enterprise Manager in SQL Server 2000 https://support.microsoft.com/?kbid=953122 FIX: You cannot register a 64-bit local instance by clicking "Update Local Server Registration" in SQL Server Management Studio in SQL Server 2005 https://support.microsoft.com/?kbid=953852 FIX: Error message when you run a query that contains many OR clauses in SQL Server 2005: "There is insufficient system memory to run this query" https://support.microsoft.com/?kbid=952624 FIX: The performance of a query in SQL Server 2005 Service Pack 2 Cumulative Update 6 is slow https://support.microsoft.com/?kbid=953721 FIX: Error message when you run an INSERT statement in SQL Server 2005: "Cannot insert an explicit value into a timestamp column" https://support.microsoft.com/?kbid=953950 FIX: Error message when SQL Server 2005 synchronizes a mirrored database: "Expression: result == LCK_OK" https://support.microsoft.com/?kbid=953625 FIX: Error message when you call a table valued function that uses a common language runtime (CLR) assembly in SQL Server 2005: "AppDomain <ApplicationDomain> is marked for unload due to memory pressure" https://support.microsoft.com/?kbid=953497 FIX: The compilation time of some queries is very long in an x64-based version of SQL Server 2005 |