November 2005 - Posts

Microsoft SQL Server Management Studio Express - CTP - November 2005

Microsoft have been working on a free management tool for SQL Server 2005 Express, and what they were working on during the betas was mostly tossed away in the July timeframe.

Now, the CTP for the new tool, Microsoft SQL Server Management Studio Express is available.

Something that looks and works like the full Microsoft SQL Server Management Studio is really the right choice.

http://www.microsoft.com/downloads/details.aspx?FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en

Posted by Mike Epprecht | with no comments
Filed under:

Scalable shared databases are supported by SQL Server 2005

Something that seems to have been added to SQL Server 2005 Enterprise Edition, very late in the development cycle, seems to be on of it's best features.

The ability to have one DB, located on SAN, available to multiple SQL Servers at the same time, as a read only DB is just incredible.

You can really scale out reporting, and might save you from having to flatten the data so that it is report friendly. Just throw more servers at the problem now. You need a bit of effort to update it, but it is really worth the while for those scenarios where data is loaded on a daily or weekly basis.

As long as your SAN can handle the throughput, it think it is a great feature.

The documentation in not in the SQL Server 2005 RTM BOL, but is available as a KB article: http://support.microsoft.com/?kbid=910378

Well done Microsoft!

Posted by Mike Epprecht | 1 comment(s)
Filed under: