Many of you are working with User Instances , sometimes without even realizing it. Briefly, a User Instances is special process of SQL Express that can be started by an application at runtime and allows SQL Express to emulate some of the characteristics...

Now that SQL Server 2005 SP2 has been released I thought I should make good on my promise to explain more about how we handle Windows Vista User Access Control in SQL Express SP2. I explained earlier that UAC works by removing the administrator ACEs from...

Our web hosting team within SQL Server has reached another milestone with the second CTP of the Database Publishing Wizard. Congratulations to the team! Here is the announcements in their own words explaining some of the updates and changes. - Mike...

The November CTP of SQL Express SP2 is available at a download center near you. As I've written before , SQL Express SP1 has a few known issues when running on Windows Vista, SP2 is where we've addressed these issues and is what we recommend using for...