http://support.microsoft.com/Default.aspx?kbid=910378 This sounds really sweet. There have been instances where I could have used this feature over the years. Copied from the KB article: Scalable shared databases The scalable shared database feature allows you to attach a read-only reporting database...

http://www.microsoft.com/downloads/details.aspx?FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en From the download page: Overview Microsoft SQL Server Management Studio Express (SSMSE) provides a graphical management tool for SQL Server 2005 Express Edition (SQL Server Express) instances...

Subscribe – The fresh, quick, hip way to do things! Use iPodder or iTunes . Download – The boring way to do things. Show Notes More on the Alabama Code Camp. Speaker Event on Friday. Bruce Thomas. Joe Healy. Russ Fustino. Paul Lockwood. Wally and Laura Allison. Lori, the goddess of knowledge. David Silverlight...

I was trying to get a backup of my system done so that I could reformat and install everything as clean as possible. The problem is that the windows backup wouldn't run. By googling, I was able to find the knowledge base article that solved the problem for me. Here it is: http://support.microsoft.com...

Subscribe , its the good thing to do. iTunes and iPodder links. Download . Checkout the discussion from the Alabama CodeCamp on October 29th in Birmingham, AL. I did my talk on ADO.NET and SQL CLR Objects. I met a bunch of great people. Joe Healy and Russ Fustino (both from Microsoft) lead the CodeCamp...

When you change the network protocols, and other settings, you are using with Sql Server 2005, you might need to stop and restart the Sql Server 2005 Service. I find this a fairly simple thing to overlook when you have the really cool point and click interface. Wally

I have been working with the Sql Server 2005 Beta(s) for a while (read almost 2 1 / 2 years). I've always enabled the CLR using the TSql commands. Well, I was going through the Sql Server Configuration tool and I found that this can be enabled through a point and click interface using the Sql Server...

Sometimes you need to create a Sql Cursor within a trigger. I recently had a problem where that was the only way that I could get it to work reliably. I am putting this up here for my personal reference. I don't think that it is a particularly good example, just a skeleton that I would like to keep around...

Today, I had a need to programmatically update data in one database from another database. I wrote a quick .NET app to pull the data out of one table, process the data, and put it into another table in another database table. I just went to write a quick utility because I was running in two databases...

I've been doing a small amount of testing with the June CTP of Sql Server 2005 and ADO.NET V2. MARS is turned on by default in a SqlConnection. I would suggest turning MARS off, unless you need it. I am seeing a performance difference between having MARS turned on and off, just on regular ADO.NET commands...