ANN: SQL Server 2005 Express Technical Preview

[Thomas Scheidegger [MVP]]

SQL Server 2005 Express Technical Preview

http://www.microsoft.com/downloads/details.aspx?familyid=2ccf2ab6-bfd9-4ac8-b31d-ddbad7d532a2

Download:
http://download.microsoft.com/download/c/f/8/cf872b5a-509b-44ce-b5ac-e693f7aec971/SQLEXPR.EXE


Web:
http://msdn.microsoft.com/sql/express/

http://lab.msdn.microsoft.com/express/sql/



PR:
http://www.microsoft.com/presspass/press/2004/jun04/06-29ExpressDebutPR.asp

 

[Ginny Caughey [MVP]]

Thomas,

This looks really cool. Do you know if the Express version has/will have any
tools associated with it?

--
Ginny Caughey
..Net Compact Framework MVP

Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know!
https://www.windowsembeddedeval.com/community/newsgroups

 

[Aaron [SQL Server MVP]]

Yes, did you see http://lab.msdn.microsoft.com/express/sql/ ?

--
http://www.aspfaq.com/
(Reverse address to reply.)

 

[Ginny Caughey [MVP]]

Hi Aaron,

Yes, thanks, I'm reading that now. Very cool indeed! Do you know anything
about the new way SQL 2003 Express manages performance limits? It appears
that the new scheme is different from the MSDE workload governor.

 

[Aaron [SQL Server MVP]]

Yes, thanks, I'm reading that now. Very cool indeed! Do you know anything

about the new way SQL 2003 Express manages performance limits? It appears
that the new scheme is different from the MSDE workload governor.

There is no longer a governor. But it comes at a cost: no SQL Agent.

A

 

[Jim Young]

I notice that the DTS runtime and SQL Server Agent are pulled from this
edition. :-(

Jim

 

[Ginny Caughey [MVP]]

Aaron,

That's only fair (that it comes at a cost). No governor is really generous!

 

[Aaron [SQL Server MVP]]

I notice that the DTS runtime and SQL Server Agent are pulled from this

edition. :-(

Yes. As mentioned above, improvements usually mean trade-offs. If these
features are more important to you than a GUI, database size and the
workload governor, then stay with 2000.

 

[Jim Young]

Don't get me wrong - I think this looks like a great product and good
initiative by Microsoft and I'm sure I'll evetually migrate my application
to it. It's just that I've built some processes around DTS, so I'll
eventually need to build another solution instead.

Jim

 

[Remus]

You can use Service Broker's activation feature to do the jobs ussualy done
with Server Agent (run tasks at certain date/time)

HTH,
Remus

 

[Cowboy \(Gregory A. Beamer\) [MVP]]

Currently no. There are plans for Express Manager, aka XM, in the future.
Right now, you run from command line type tools. The future XM tools will
allow basic control of SQL Server 2005 Express, as well as SQL Server
2000/MSDE/2005.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************

 

[Cowboy \(Gregory A. Beamer\) [MVP]]

They are future tools. Read The SQL Server 2005 Express Overview:
http://msdn.microsoft.com/library/?url=/library/en-us/dnsse/html/sseoverview.asp

<cite>
A new GUI tool called SQL Server Express Manager (XM) will be freely
available as a separate Web download.
</cite>

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************

 

[Cowboy \(Gregory A. Beamer\) [MVP]]

In the overview:
http://msdn.microsoft.com/library/?url=/library/en-us/dnsse/html/sseoverview.asp

it states that there is a 1GB cap and only 1 thread can be used (limiting
the engine to 1 CPU period).

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************

 

[Cowboy \(Gregory A. Beamer\) [MVP]]

Or wait until SQL Server 2005 (the non-express version).

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

************************************************
Think Outside the Box!
************************************************

 

[John Kane]

Still no SQL Full-text Search in SQL 2005 Express, but then neither was it
in MSDE 2000 as well, see:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsse/html/sseoverview.asp

Features not present in SQL Server Express
Some of the features available in other SQL Editions, but not in SQL Server
Express, include the following:

a.. Availability features such as data mirroring, clustering, etc.
b.. Full-text search
c.. SQL Agent
d.. Reporting Services
e.. Business Intelligence Platform, such as Notification and Analysis
Services
f.. SQL Management Studio, which is the new GUI tool replacing SQL 2000
Enterprise Manager
Regards,
John