Tuesday, April 25, 2006
15 megs of fame
Go check out 15 Megs of Fame. It's a music site that contains many Creative Commons licensed songs that you can stream off the website and then download if they suit your fancy. I've already found several great artists there including: Nicolle Chirino, Seven Ender, and Case of the Mondays. I'm still working my way through some of the songs, so I'm sure I'll run across a few other great artists too. It's a great place to go to find some good music that you don't hear everywhere you go. Let me know if you run across some artists I haven't found!
Friday, April 07, 2006
sql express
I just recently installed a version of SQL Server 2005 Express Edition. I'm quite pleased with SQL Server 2005 so far. At least, given what little chance I've had to mess around with it lately. What I'm particularly fond of however is it's ability to work well alongside my installation of SQL Server 2000. Also, installing both the regular and Express edition of 2005 seems to work just fine also. Everything plays together nicely, and I love having the new SQL Management Studio instead of having to drudge through Enterprise Manager.
Why would I install three versions of SQL Server, you ask? Well, 2000 is there for current development. 2005 is there just because, and I installed the Express edition to play around with user instances. User instances seem like a great way to develop client-side database applications. Basically, a user instance spawns a copy of the parent database instance, but makes it specific to the current user. Anything he does in this instance is essentially in a sandbox, which means if he (or more likely, the program he's running) wants to hose his server instance, it's not going to affect any other databases or instances. I'm also intrigued by the AttachDbFilename attribute in the SQL connection string. You could use this attribute in a SQL 2000 connection string, but after doing so, the database remained attached to the instance, and you had to manually detach it in order to make it portable again. I'm thinking that's probably not the case in 2005, especially when using the user instances. I've been hard pressed to find any concrete documentation that would answer that question for me, so I guess I'm just going to have to play with it and find out for myself.
Why would I install three versions of SQL Server, you ask? Well, 2000 is there for current development. 2005 is there just because, and I installed the Express edition to play around with user instances. User instances seem like a great way to develop client-side database applications. Basically, a user instance spawns a copy of the parent database instance, but makes it specific to the current user. Anything he does in this instance is essentially in a sandbox, which means if he (or more likely, the program he's running) wants to hose his server instance, it's not going to affect any other databases or instances. I'm also intrigued by the AttachDbFilename attribute in the SQL connection string. You could use this attribute in a SQL 2000 connection string, but after doing so, the database remained attached to the instance, and you had to manually detach it in order to make it portable again. I'm thinking that's probably not the case in 2005, especially when using the user instances. I've been hard pressed to find any concrete documentation that would answer that question for me, so I guess I'm just going to have to play with it and find out for myself.
Subscribe to:
Posts (Atom)