|
|
You're in the
sql server msde
group:ANN: SQL Server 2005 Express Technical Preview
sql server msde:
edition. :-( Jim [quoted text, click to view] "Thomas Scheidegger [MVP]" <spam.netmaster@swissonline.ch> wrote in message news:uqwHCTbXEHA.3668@TK2MSFTNGP09.phx.gbl... > 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 > > > > > > -- > Thomas Scheidegger - MVP .NET - 'NETMaster' > http://www.cetus-links.org/oo_dotnet.html - http://dnetmaster.net/ > >
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 [quoted text, click to view] "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message news:uMLQvueXEHA.2388@TK2MSFTNGP11.phx.gbl... > > 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. > > -- > http://www.aspfaq.com/ > (Reverse address to reply.) > >
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 [quoted text, click to view] "Jim Young" <thorium48@hotmail.com> wrote in message news:ef6UWieXEHA.748@TK2MSFTNGP11.phx.gbl... > I notice that the DTS runtime and SQL Server Agent are pulled from this > edition. :-( > > Jim > > "Thomas Scheidegger [MVP]" <spam.netmaster@swissonline.ch> wrote in message > news:uqwHCTbXEHA.3668@TK2MSFTNGP09.phx.gbl... > > 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 > > > > > > > > > > > > -- > > Thomas Scheidegger - MVP .NET - 'NETMaster' > > http://www.cetus-links.org/oo_dotnet.html - http://dnetmaster.net/ > > > > > >
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 [quoted text, click to view] "Thomas Scheidegger [MVP]" <spam.netmaster@swissonline.ch> wrote in message news:uqwHCTbXEHA.3668@TK2MSFTNGP09.phx.gbl... > 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 > > > > > > -- > Thomas Scheidegger - MVP .NET - 'NETMaster' > http://www.cetus-links.org/oo_dotnet.html - http://dnetmaster.net/ > >
Yes, did you see http://lab.msdn.microsoft.com/express/sql/ ?
-- http://www.aspfaq.com/ (Reverse address to reply.) [quoted text, click to view] "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in message news:##lP$7dXEHA.716@TK2MSFTNGP11.phx.gbl... > 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 > > > > "Thomas Scheidegger [MVP]" <spam.netmaster@swissonline.ch> wrote in message > news:uqwHCTbXEHA.3668@TK2MSFTNGP09.phx.gbl... > > 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 > > > > > > > > > > > > -- > > Thomas Scheidegger - MVP .NET - 'NETMaster' > > http://www.cetus-links.org/oo_dotnet.html - http://dnetmaster.net/ > > > > > >
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. -- Ginny Caughey ..Net Compact Framework MVP [quoted text, click to view] "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message news:eukbaEeXEHA.1048@tk2msftngp13.phx.gbl... > Yes, did you see http://lab.msdn.microsoft.com/express/sql/ ? > > -- > http://www.aspfaq.com/ > (Reverse address to reply.) > > > > > "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in message > news:##lP$7dXEHA.716@TK2MSFTNGP11.phx.gbl... > > 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 > > > > > > > > "Thomas Scheidegger [MVP]" <spam.netmaster@swissonline.ch> wrote in > message > > news:uqwHCTbXEHA.3668@TK2MSFTNGP09.phx.gbl... > > > 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 > > > > > > > > > > > > > > > > > > -- > > > Thomas Scheidegger - MVP .NET - 'NETMaster' > > > http://www.cetus-links.org/oo_dotnet.html - http://dnetmaster.net/ > > > > > > > > > > > >
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 -- Thomas Scheidegger - MVP .NET - 'NETMaster' http://www.cetus-links.org/oo_dotnet.html - http://dnetmaster.net/
[quoted text, click to view]
> 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
Aaron,
That's only fair (that it comes at a cost). No governor is really generous! -- Ginny Caughey ..Net Compact Framework MVP [quoted text, click to view] "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message news:%23JUgfgeXEHA.2816@TK2MSFTNGP11.phx.gbl... > > 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 > >
[quoted text, click to view]
> 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. -- http://www.aspfaq.com/ (Reverse address to reply.)
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! ************************************************ [quoted text, click to view] "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in message news:%23%23lP$7dXEHA.716@TK2MSFTNGP11.phx.gbl... > 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 > > > > "Thomas Scheidegger [MVP]" <spam.netmaster@swissonline.ch> wrote in message > news:uqwHCTbXEHA.3668@TK2MSFTNGP09.phx.gbl... > > 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 > > > > > > > > > > > > -- > > Thomas Scheidegger - MVP .NET - 'NETMaster' > > http://www.cetus-links.org/oo_dotnet.html - http://dnetmaster.net/ > > > > > >
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! ************************************************ [quoted text, click to view] "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message news:eukbaEeXEHA.1048@tk2msftngp13.phx.gbl... > Yes, did you see http://lab.msdn.microsoft.com/express/sql/ ? > > -- > http://www.aspfaq.com/ > (Reverse address to reply.) > > > > > "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in message > news:##lP$7dXEHA.716@TK2MSFTNGP11.phx.gbl... > > 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 > > > > > > > > "Thomas Scheidegger [MVP]" <spam.netmaster@swissonline.ch> wrote in > message > > news:uqwHCTbXEHA.3668@TK2MSFTNGP09.phx.gbl... > > > 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 > > > > > > > > > > > > > > > > > > -- > > > Thomas Scheidegger - MVP .NET - 'NETMaster' > > > http://www.cetus-links.org/oo_dotnet.html - http://dnetmaster.net/ > > > > > > > > > > > >
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! ************************************************ [quoted text, click to view] "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in message news:%23Uq$eVeXEHA.3292@TK2MSFTNGP09.phx.gbl... > 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. > > -- > Ginny Caughey > .Net Compact Framework MVP > > "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message > news:eukbaEeXEHA.1048@tk2msftngp13.phx.gbl... > > Yes, did you see http://lab.msdn.microsoft.com/express/sql/ ? > > > > -- > > http://www.aspfaq.com/ > > (Reverse address to reply.) > > > > > > > > > > "Ginny Caughey [MVP]" <ginny.caughey.online@wasteworks.com> wrote in > message > > news:##lP$7dXEHA.716@TK2MSFTNGP11.phx.gbl... > > > 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 > > > > > > > > > > > > "Thomas Scheidegger [MVP]" <spam.netmaster@swissonline.ch> wrote in > > message > > > news:uqwHCTbXEHA.3668@TK2MSFTNGP09.phx.gbl... > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > Thomas Scheidegger - MVP .NET - 'NETMaster' > > > > http://www.cetus-links.org/oo_dotnet.html - http://dnetmaster.net/ > > > > > > > > > > > > > > > > > > > >
Or wait until SQL Server 2005 (the non-express version).
-- Gregory A. Beamer MVP; MCP: +I, SE, SD, DBA ************************************************ Think Outside the Box! ************************************************ [quoted text, click to view] "Jim Young" <thorium48@hotmail.com> wrote in message news:eqorH5eXEHA.2844@TK2MSFTNGP12.phx.gbl... > 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 > > "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message > news:uMLQvueXEHA.2388@TK2MSFTNGP11.phx.gbl... > > > 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. > > > > -- > > http://www.aspfaq.com/ > > (Reverse address to reply.) > > > > > >
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 [quoted text, click to view] "Cowboy (Gregory A. Beamer) [MVP]" <NoSpamMgbworld@comcast.netNoSpamM> wrote in message news:ubXlubfXEHA.3516@TK2MSFTNGP09.phx.gbl... > Or wait until SQL Server 2005 (the non-express version). > > -- > Gregory A. Beamer > MVP; MCP: +I, SE, SD, DBA > > ************************************************ > Think Outside the Box! > ************************************************ > "Jim Young" <thorium48@hotmail.com> wrote in message > news:eqorH5eXEHA.2844@TK2MSFTNGP12.phx.gbl... > > 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 > > > > "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message > > news:uMLQvueXEHA.2388@TK2MSFTNGP11.phx.gbl... > > > > 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. > > > > > > -- > > > http://www.aspfaq.com/ > > > (Reverse address to reply.) > > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
| home · blog · groups | Questions? Comments? Contact the dn |