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