New Utilities for SQL Server Released

The Microsoft SQL Server support team uses several internally-written utilities to make it easier to work on a typical customer support case. These utilities may also be useful to database developers and system administrators who work with Microsoft SQL Server 2000 and Microsoft SQL Server 2005. To learn more about these utilities, see the blog entry…


Try the puzzle!

our old friend and comrade Buck Woody has come up with a fun and challenging puzzle. Great way to spend some time on a Friday and test your knowledge. Check out his puzzle on his blog at Have a great weekend everybody! Tai YeeSQL Server User Education


Use the correct "Data Sources (ODBC)" service

On an 64-bit operating system (Itanium or x64), Windows installs two versions of the “Data Sources (ODBC)” service: a 32-bit version and a 64-bit version.  A 32-bit native (non-CLR) data application that will run under WOW64 needs to use a data source that was created with the 32-bit “Data Sources (ODBC)” service. If you will build…


SQL Server 2005 Books Online — latest release now available for download

Well, it’s been a long time coming. We finally got the technical issues resolved and have completed testing on the SQL Server 2005 Books Online release that we published to the MSDN and TechNet Libraries in September. The downloadable version is now available on the Microsoft Download Center at: Next steps for us are…


November CTP of SQL Server 2008 does not install SQL Server Native Client SDK files by default

To develop data access applications with SQL Server Native Client, you have to manually run sqlncli.msi to install sqlncli.h and sqlncli.lib.  sqlncli.msi is on your installation media. This installation bug in the November SQL Server CTP is schedule to be fixed in the next CTP.  David SchwartzSQL Server User Education


SQL Server 2008 CTP (November 2007) Available Now

I am pleased to announce that the SQL Server 2008 Community Technology Preview (CTP) for November 2007 is now available. The SQL Server development team uses your feedback to help refine and enhance product features. Download the CTP today and share your feedback. This CTP is available in two downloadable formats: an image file that…


Using OLE DB Extensions in SQL Server Native Client 10.0 (SQL Server 2008) to Change the Password of a SQL Server Authentication User Account

The SQL Server Native Client team received some feedback asking for a code sample that shows how to use OLE DB extensions in SQL Server Native Client to change a password for a SQL Server Authentication user account.   Here’s the code.  Note that before you run this code, you need to modify it to enter…


Feedback aliases for MDAC

Hi, My name is David Schwartz.  I am a technical writer in the SQL Server product group and I maintain the documentation for Windows Data Access Components, formerly known as Microsoft Data Access Components (MDAC). If MDAC users have any documentation comments, you can send them to There is also an alias just for…


Microsoft Sync Framework CTP Is Live!

Microsoft has now posted the first Community Technology Preview (CTP) release of Microsoft Sync Framework. Sync Framework is a comprehensive synchronization platform that enables collaboration and offline data access for applications, services and devices with support for any data type, any data store, any transfer protocol, and network topology. Documentation is available as a download and…


Let Us Know What You Think of the New Design for the SQL Server TechCenter

A new design for the SQL Server TechCenter has now been released. This design was based on the ones currently being piloted on the Visual Basic Developer Center and Visual C# Developer Center. When visiting the site, be sure to use the Rating Control near the top right of the page to tell us how much…