Browse by Tags

• beginners
• best practices
• Books
• FAQ
• new dba
• Northwind
• resources
• SQL Server

• FAQ: Error creating a Service-based database in Visual Studio 2008 SP1

  A few of you have run into problems when trying to add a new Service-based database to your project in Visual Studio 2008 SP1. This problem has been reported to Microsoft Connect and the Visual Studio team is working on a fix, but I thought I would provide Read More... Posted Friday, October 03, 2008 10:07 AM from SQL Server Express WebLog | (Comments Off) Filed under: FAQ, Samples

• 15 shopping days left at ALFKI

  I'm kicking off the next round of the SQL Server Bible series for Wiley. For the past two versions I used a few my own custom sample databases and skipped the MSFT sample databases (even though I feel that ALFKI's a friend and I'd love to shop there someday.) Read More... Posted Tuesday, December 11, 2007 4:52 AM from Paul Nielsen | (Comments Off) Filed under: Samples, Books, Northwind

• DIY SQL Express SP2 Bootstrapper

  I've waited far too long to communicate this disappointing news to everyone, so here it is… I'm not going to be releasing the SQL Express SP2 Bootstrapper manifests that I had discussed in a long ago blog posting . I'll spare you the sob story of my efforts Read More... Posted Friday, August 24, 2007 9:41 AM from SQL Server Express WebLog | (Comments Off) Filed under: FAQ, Samples

• Resources for beginners in MS SQL Server and new DBA

  " Give me some good resource that I can refer as new dba or beginner or new learner " this is the question asked by beginners and new learners in various forums I participate, thus I decide to post a blog referring the same, they are: Here are some good Read More... Posted Monday, August 20, 2007 6:36 PM from SSQA.net | (Comments Off) Filed under: SQL Server, Samples, best practices, resources, beginners, new dba

• Backup and Restore with User Instances

  Backup and Restore is an important part of any application, but when you're writing an application for an end-user, it becomes even more important that you do a good job of handling Backup and Restore in your code since you end-user will likely not know Read More... Posted Wednesday, March 21, 2007 6:14 AM from SQL Server Express WebLog | (Comments Off) Filed under: Samples

• Source code for Embedding Webcast (Finally)

  At long last, I've posted the code for the embedding web cast . I've made a few changes to the code from what I showed in the webcast, here are some details about implementation and alternatives you can consider when thinking about this. Alternative Databases Read More... Posted Tuesday, August 22, 2006 6:58 AM from SQL Server Express WebLog | (Comments Off) Filed under: Samples