TechEd 2008 – DAT 407

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


SQL Server for the Web Developer (SQL Live! Talk)

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: Astoria:  demo scripts in attachment…


"SQL Server 2005 Best Practices Analyzer" Feb 2007 CTP released

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 features, including support for other SQL services such as Analysis Services.  You…


RC of SQL Server Hosting Toolkit released!

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 2005 and Visual Web Developer Express 2005.  You can now right-click on a database in the VS…


New CTP of SQL Server Hosting Toolkit released

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 to the Database Publishing Wizard include support for almost all database-level objects and data types, a wizard-based GUI,…


Deploying a DB to your Hoster

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-forward, but moving the database (along with its data) from a dev box up to a hoster…


"LIMIT" in SQL Server

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 row number X to row number Y. The…


SQL Server Hosting Toolkit Launched

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 hosted SQL Server.  The Database Publishing Wizard works toward this mission by making it easy to upload a…


Troubleshooting SQL Server 2005 Express Connection Issues

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: