User Instances

[bdi]

Just wanted to point out to everyone that with SQL Server Express you can now use User Instances. What are User Instances you say?

Well, a SQL database consists of two types of files, an MDF file which is the main data file, and an LDF file which is the log file. A user instance allows you to create these files when installing a program, and then attach them to the SQL Server Express engine already loaded on the machine. Therefore, the database is only running when you are using it (actually, by default it detaches one hour after it's last use).

So, what are the advantages to this?

Well, for one you can place the database files in a user's profile and the user does not need to have administrative rights to use it.

It also makes it easier to distribute with an application, or create on the fly.

By not running when not in use, this also creates a more secure environment.

With SQL Express being free, that's a whole lot of power you have behind your application without the cost.