July 2008 – Technical Rollup Mail – SQL






 


News


Technical RollUp


http://blogs.technet.com/trm/default.aspx


 


SQL Server 2008 RC0 Available for Everyone


http://blogs.technet.com/dataplatforminsider/archive/2008/06/10/sql-server-2008-rc0-available-for-everyone.aspx


 


 


Downloads


IDC Analysis Relational Database Systems


IDC Analysis of worldwide Database Systems


http://www.microsoft.com/downloads/info.aspx?na=22&p=1&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dc6920f99-8a64-4049-9798-f5b33ebbff72%26displaylang%3den


 


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.


http://www.microsoft.com/downloads/info.aspx?na=22&p=2&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d58a7c46e-a599-4fcb-9ab4-a4334146b6ba%26displaylang%3den


 


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


http://www.microsoft.com/downloads/info.aspx?na=22&p=3&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3ddaf00920-7214-418a-a4b0-727f4ce08f81%26displaylang%3den


 


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.


http://www.microsoft.com/downloads/info.aspx?na=22&p=4&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d089a9dad-e2df-43e9-9cd8-c06320520b40%26displaylang%3den


 


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.


http://www.microsoft.com/downloads/info.aspx?na=22&p=5&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dc67a9276-bc20-444c-b60d-8500f4b8d713%26displaylang%3den


 


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.


http://www.microsoft.com/downloads/info.aspx?na=22&p=6&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d35f53843-03f7-4ed5-8142-24a4c024ca05%26displaylang%3den


 


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.


http://www.microsoft.com/downloads/info.aspx?na=22&p=7&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d779561de-c704-4584-80ac-7e4348c927c0%26displaylang%3den


 


SQL Server 2008 Books Online Release Candidate (RC0)


Download the release candiate (RC0) version of the documentation and tutorials for Microsoft SQL Server 2008.


http://www.microsoft.com/downloads/info.aspx?na=22&p=8&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d19db0b42-a5b2-456f-9c5c-f295cdd58d7a%26displaylang%3den


 


TechNet Security Series Seminar IV (5 Jun 2008)


Presentation materials for the TechNet Security Series Seminar (29 Feb 2008)


http://www.microsoft.com/downloads/info.aspx?na=22&p=9&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3debd6aeda-2121-4cc5-99e8-601b966f6ec7%26displaylang%3den


 


.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.


http://www.microsoft.com/downloads/info.aspx?na=22&p=10&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d38faf2b6-8a4c-4ba7-809d-caf887087e5f%26displaylang%3den


 


SQL Server 2008 RC0 Readme


The Readme document contains important information to read before installing Microsoft SQL Server 2008 Release Candidate 0 (RC0).


http://www.microsoft.com/downloads/info.aspx?na=22&p=11&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d298c5443-cc7c-4c22-8d73-fb70c96b5b04%26displaylang%3den


 


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.


http://www.microsoft.com/downloads/info.aspx?na=22&p=12&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3dbb3ad767-5f69-4db9-b1c9-8f55759846ed%26displaylang%3den


 


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.


http://www.microsoft.com/downloads/info.aspx?na=22&p=13&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3deff1b504-8877-4e3f-9029-b215501c247d%26displaylang%3den


 


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.


http://www.microsoft.com/downloads/info.aspx?na=22&p=14&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d3c113d55-af83-4abf-a1ba-0e44b7cfc318%26displaylang%3den


 


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.


http://www.microsoft.com/downloads/info.aspx?na=22&p=15&srcdisplaylang=en&srccategoryid=&srcfamilyid=&u=%2fdownloads%2fdetails.aspx%3ffamilyid%3d85f99a70-5df5-4558-991f-8aee8506833c%26displaylang%3den


 


Documents


SQL Server 2008 Product Overview


http://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


http://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) 


https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032370154&EventCategory=5&culture=en-US&CountryCode=US


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)


https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032364885&EventCategory=5&culture=en-US&CountryCode=US


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.


 










MSDN Webcast: Introducing SQL Server Compact 3.5 (Level 200) 


https://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032364883&EventCategory=5&culture=en-US&CountryCode=US


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


http://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


http://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


http://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"


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


 


FIX: A time series prediction query takes a long time to run in SQL Server 2005 Analysis Services


http://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"


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


 


FIX: An access violation occurs when you run an XMLA query in SQL Server 2005 Analysis Services


http://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"


http://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"


http://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


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


 


FIX: Duplicate data is written to other flat files in an SSIS package that contains a Foreach Loop container


http://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


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


 


FIX: The Replication Log Reader Agent may fail intermittently when a transactional replication synchronizes data in SQL Server 2005


http://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"


http://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


http://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


http://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


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


 


Supported method for applying updates to SQL Server 7.0


http://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


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


 


SQL Server 2000 installers do not update disabled SQL Server instances


http://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


http://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


http://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


http://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"


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


 


FIX: The performance of a query in SQL Server 2005 Service Pack 2 Cumulative Update 6 is slow


http://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"


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


 


FIX: Error message when SQL Server 2005 synchronizes a mirrored database: "Expression: result == LCK_OK"


http://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"


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


 


FIX: The compilation time of some queries is very long in an x64-based version of SQL Server 2005


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


 

Comments (0)

Skip to main content