SQL Server Performance

SQL Server 2005 CTP versions

Discussion in 'SQL Server 2005 General DBA Questions' started by satya, Dec 10, 2004.

  1. satya Moderator

    http://www.microsoft.com/presspass/press/2004/dec04/12-03ServerLowCostPR.asp -SQL Server 2005 CTP and Express Manager Now Available for Beta Testers; Customers Move to SQL Server for Lower Cost, Data Management and Business Intelligence

    .NET CLR v2.0.40903.27 version fromhttp://download.microsoft.com/download/9/A/4/9A47D72B-9D98-46CC-87F3-B92E97888E4B/dotnetfx.exe.

    SQL Server 2005 Express Edition v9.0.981
    http://www.microsoft.com/downloads/...6a-6c3b-47d2-9929-ecdc5a4d25ae&displaylang=en

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  2. pcsql New Member

    Hi Satya,

    My understanding is that the Express Manager is the final product. Am I right? I have taken a quick look at it. It is more a tool for users and developers. To me, it is similar to Query Analyzer. What is the main advantage using it comparing to Query Analyzer beside it is free?

    Thanks.
  3. satya Moderator

    It is still in Beta3 so there is no final information that this will be the fine tuned product, wait and see.

    True XM (express manager) is a tool that any database developer can get value out of so to that end, and ability to connect to and managed both local and remote SQL Server instances.

    This is what defined XM as from MS developers:
    One of the goals of SQL Server Express was to make it easy to develop applications with rich data access capabilities. There are some very useful features in SQL Express that I wanted to mention which can help you quickly get started with your database application. To begin with, SQL Express is small enough in size to download but still has many of the same powerful database features that are in SQL Server 2005.

    The installation process has been simplified to make setup easier. Databases can be deployed along with the application using just the familiar file copy mechanism without any added configuration necessary. There are also helpful database integration features built into the new VB Express product so that you can add data access capabilities to your app without having to write a lot of code.



    There is no difference between Query analyzer and XM when its compared to SQL server 2005.

    Check this demohttp://www.sqlservermobile.com/sqlexpress/dat307.wmv about XM.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page