Skip to content

SQL Server 2005

I’ve downloaded and had a look at the SQL Server 2005 Express Edition, which is the replacement for MSDE 2000. I’m no SQL expert or a developer by any stretch of the imagination, but for an IT Pro, SQL Server 2005 has a number of tools that I find interesting:

  1. SQL Server Configuration Manager. This tool enables you to configure SQL Server services and network configuration as well the SQL client. I noticed that all network protocols for SQL Server 2005 are disabled by default too. Top stuff.
  2. SQL Server Surface Area Configuration. This tool helps to secure the SQL Server instance/s.
  3. SQL Server Management Studio Express. This is the administration tool for SQL Server 2005. The best part I thought though, was that you can connect to earlier versions of SQL, as well as MSDE. Finally, a simple way to install the management tools for MSDE without having to grab the SQL Server CD.

Comments closed — Trackback URI RSS 2.0 feed for these comments This entry (permalink) was posted on Tuesday, November 8, 2005, at 3:02 pm by Aaron Parker. Filed in General and tagged .