Browsing Posts in SQL Server

I’ve been playing with SQL Server 2005 and like what I see so far. It’s especially nice for developers as everything now resides in VS 2005, whether you know it or not. (SQL Server Business Intelligence Development Studio and SQL Server Management Studio are really just the VS 2005 shell hosting the appropriate widgets.) One thing that I do miss from SQL Server 2000 is Service Manager for starting and stopping the various parts of SQL Server. (I don’t like to clutter my RAM with all the SQL Server bits when I’m not doing DB-related development.) You can start and stop SQL Server from the other tools, but I run as a non-admin and non-admins can’t start/stop services. (You could run SQL Server Management Studio as a local admin, but that’s rather heavyweight since all I want to do is start/stop the services.) The other option that I’ve been using is shelling out to an admin command prompt and typing “net start MsSqlServer” or “net stop MSSQL$SQLExpress” or similar.

Seems that Jasper Smith had the same problem and implemented a very nice Service Manager replacement called appropriately SQL 2005 Service Manager. It does everything the original did and a whole lot more that it should have. It supports all SQL Server 2000 and 2005 editions, including SQL Express instances. The list of services that you can manage includes SQL Server, SQL Agent, Analysis Services, Full Text Search, MSDTC, and Reporting Services. (My favourite is start/stopping Reporting Services, which the original never did.)

I even configured it to prompt for alternate credentials so I can run it as the local admin. (You can configure any shortcut to prompt you for credentials by Right-clicking the shortcut… Shortcut tab… Advanced… “Run with different credentials”.)

Very cool tool and highly recommended if you’re doing SQL Server 2005 development!

Now that VS 2005 and .NET 2.0 has been released, the torrential flow of tool updates to .NET 2.0 has started. Some of my favourite .NET tools have been updated to .NET 2.0:

I’m anxiously awaiting the next version TestDriven.NET, too. A beta of v2.0 is available for those who want to try it.
An interesting add-in for .NET Reflector is SQL 2005 Assembly Browser by Denis Bauer. It allows you to browse .NET assemblies stored in SQL Server 2005. This is something I’m definitely going to investigate more thoroughly.
In related news, WSE 3.0 just RTMed!!! This is great news because WSE 3.0 will be wire-compatible with Indigo — uhm, I mean Windows Communication Foundation (WCF). This gives us a good migration story to Microsoft’s next generation distributed communication platform.
And somehow I also missed the fact that the coding superhero, Lutz Roeder, has a blog for a number of years, even if it is rather sparse. Subscribed.

Coming to one of the Canadian Launch events? If so, you’ll get a Special Edition copies of Visual Studio 2005 and SQL Server 2005 for free! According to Mark Relph, these are not trial versions. These are fully functional non-evaluation versions of the products. I’m not sure which SKU they will be distributing, but even full versions of the Express SKU will be cool. (Can anyone confirm which SKU will be distributed?) If you haven’t signed up yet, there’s still space left in some of the cities. (Calgary and a few others have opened up waiting lists.) Hope to see you at the launch!

EDIT: Mark Relph just posted these pics of the Special Edition. Looks like Launch attendees will be receiving Visual Studio 2005 Standard Edition and SQL Server 2005 Standard Edition. Cool!!!