Attached script enables one to capture an object version history for all objects in a database...

Thanks to those that attended my talk this afternoon on SQL Server for the Web Developer at the SQL Live! conference in Orlando. Below are a few links from the talk and I've attached a zip w/ the demo scripts. SQL Database Publishing Wizard: http...

Hey folks. The Manageability team in SQL Server has just released a community technology preview of the SQL Server 2005 Best Practices Analyzer. This is a major reworking of the original Best Practices Analyzer for SQL 2000 and provides a host of new...

Hey folks. This week we posted the Release Candidate for the SQL Server Hosting Toolkit to the web! This includes both the Database Publishing Wizard and the Database Publishing Services . New in this release: - Integration into Visual Studio...

Today, we’re excited to announce the release of the 2nd CTP of the SQL Server Hosting Toolkit ! This CTP contains both a dramatically enhanced Database Publishing Wizard as well as the new Database Publishing Services . Major enhancements...

So you got a hosting account and you're ready to deploy your site/app to the web! (If you haven't yet, there are lots of great hosters out there offering Windows/ASP.NET/SQL hosting solutions) Pushing the ASPX pages has always been pretty straight...

I've recently come across a number of folks in different contexts who were trying to figure out how to acheive the equivalent of MySQL's "LIMIT" clause in SQL Server. The basic scenario is that you want to return a subset of the results in a query from...

The SQL Server group at Microsoft has just launched the SQL Server Hosting Toolkit with the release of the Database Publishing Wizard Community Technology Preview 1 . The objective of the SQL Server Hosting Toolkit is to enable a great experience around...

The folks at Teratrax posted a good set of instructions for troubleshooting any issues you might be having connecting to an instance of SQL Server 2005 Express: http://www.teratrax.com/articles/connecting_sql_server_express.html

I've attached the scripts used in this Teched session...

Hi folks. I'm giving a TechEd talk here in Boston titled "DAT421: Peeking Inside SQL Server 2005 Engine" tomorrow morning at 8:30 am in room 102AB. We'll be looking at how you can better understand what's happening and what's happened on your SQL Server...

We're launching the first CTP of SQL Server Everywhere today! SQL Server Everywhere is a new, lightweght database you can load within the process of your application. We first announced this new SKU a few months ago, and it's an exciting addition to...

If you work for a hoster that provides database services and will be at TechEd in Boston this coming week, shoot me a note. I'm interested in discussing ways we can improve your experience with SQL Server...

Thought I'd post a useful link for finding hosters that provide SQL Server 2005 services: http://www.asp.net/hosters/Default.aspx?PromotionID=23

Welcome to my new blog focusing on SQL Server! This blog should serve as a source of news and information about SQL Server from the perspective of an insider in the product team. A bit about me: I'm a Senior Program Manager in the SQL Server Strategy...