Keep your system up to date with the most recent cumulative update package for SQL Server 2008 SP1. This package contains all of the SQL Server 2008 hotfixes that have been released since the initial release of SQL Server 2008 SP1. Understanding Incremental...(read more).. more »

Dear Customers, Today marks the release of the Customer Technology Preview (CTP) for Microsoft SQL Server 2008 Service Pack 2. Microsoft SQL Server 2008 Service Pack 2 includes: All hotfixes released up to Microsoft SQL Server 2008 SP1 CU 8. Updates to...(read more).. more »

Keep your system up to date with the most recent cumulative update package for SQL Server 2005 SP3. This package contains all of the SQL Server 2005 hotfixes that have been released since the initial release of SQL Server 2005 SP3. CU#10 KB Article: http...(read more).. more »

Keep your system up to date with the most recent cumulative update package for SQL Server 2008 R2 RTM. This package contains all of the SQL Server 2008 R2 hotfixes that have been released since the initial release of SQL Server 2008 R2 RTM. CU#2 KB Article...(read more).. more »

Following the original release of SQL Server 2008 R2 we are pleased to announce the associated release of the SQL Server 2008 R2 Best Practices Analyzer (BPA). BPA is designed for administrators who want to determine the overall conformance of their SQL...(read more).. more »

Dear SQL Server 2008 SP1 Customers, On Monday, January 18 th , 2009 the SQL Server 2008 RTM CU 9 package were uploaded in place of the SQL Server 2008 SP1 CU 6 packages. The SQL Sustained Engineering team has immediately removed the packages from public...(read more).. more »

Keep your system up to date with the most recent cumulative update package for SQL Server 2008 R2 RTM. This package contains only hotfixes that were released in Cumulative Update 5, 6, & 7 for SQL Server 2008 SP1. Cumulative Update 1 for SQL 2008...(read more).. more »

Keep your system up to date with the most recent cumulative update package for SQL Server 2008 SP1. This package contains all of the SQL Server 2008 hotfixes that have been released since the initial release of SQL Server 2008 SP1. Understanding Incremental...(read more).. more »

The Data Services team has released a refresh of the ADO.NET Data Services Update for .NET Framework 3.5 SP1 today and provides fixes for issues reported to us in the update to .NET Framework 3.5 SP1. For Windows Vista, Windows XP, Windows Server 2003 and Windows Server 2008 the refresh can be downloaded . For Windows 7 and Server 2008 R2 the .. more »

Two months ago we released an OData Library for the Windows Phone 7 – see the blog post . If you have downloaded the recent April 2010 Refresh of the Windows Phone Developer Tools you will have found that there is an issue in the refresh of the tools with loading the OData library. If you reference the System.Data.Services.Client.dll assembly fr.. more »

All the samples in this document are based on the DAC module that you can download from the attached zip folder ( DACModule.zip) .To import the modules, Step 1) check your Module Path PS > dir Env:PSModulePath Step 2) chose any of the module paths...(read more).. more »

SQL injection attacks have been on the rise in the last two years, mainly because of automated tools. We first witnessed these automated attacks in December 2007, and since then very little has changed in the way that these attacks work. Attackers use these automated tools to query search engines for interesting URLs and blast each one with various .. more »

I had the pleasure of sitting down with Chris Woodruff, a host of the Deep Fried Bytes podcast, at MIX 2010 to talk about OData and some of the announcements around OData at the conference.  The podcast is available at: http://deepfriedbytes.com/podcast/episode-53-a-lap-around-odata-with-mike-flasko/   -Mike Flasko Lead Program Manager, Data Se.. more »

We are happy to announce that we have made the source code for the .NET Framework 3.5 SP1 and Silverlight 3.0 Open Data Protocol (OData) client libraries available for download on the Codeplex website. This release represents the OData team’s continued commitment to the OData protocol and the ecosystem that has been built around it. We have had re.. more »

The final release of SQL Server 2008 R2 was made publically available last week on April 21, 2010! SQL Server Express continues to ship in 4 different packages, but we made several changes to the installation wizard to simply the installation process. For the November CTP release, I documented the installation process at .. more »

namespace to expose the internal change tracking feature used by Sync Framework to track changes in the database. The SQL Server Compact change tracking infrastructure maintains information about inserts, deletes, and updates performed on a table that has been enabled for change tracking. This information is stored both in columns added to the .. more »

For those of you using Sync Framework 1.0, we've just released a service pack that transitions the SQL Server Compact database provider to use a public-facing change tracking API that is new in SQL Server Compact 3.5 SP2. In SQL Server Compact, the change tracking feature is used to track information about all changes that occur in a given da.. more »

Reviewers: Prem Mehra, Mark Souza, Kun Cheng, Nicholas Dritsas, Thomas Kejser : Detach/Attach. Detach the mirror database, move the transaction log file to a different location, and then attach the database. This won’t work because a mirror database (being in the “restoring” state) can’t be detached / attached. : Perform a manual failover to switc.. more »

In a recent customer engagement, I ran into an interesting situation, which I’d like to share, especially with SQL Server users using Microsoft JDBC drivers. It started with typical SQL Server performance tuning exercise to identify the most expensive queries running in SQL Server. The top query looks quite simple: SELECT contact FROM tb.. more »

Our colleagues over in the SQL Server Security team have developed an open tool for troubleshooting "Login Failure" errors. If you're having an issue with "Login Failure" errors and can't resolve it from the other SQL Protocols blog articles here, check out their blog post and give their tool a try: .. more »