sql server programming: I'd like to learn more about SQL Server. I have 2000 on my work laptop
but not on my home computer. My job will be mostly working with SQL
Server and I'd like to learn as much as possible about it but I don't
really have much time at work to do so. Is there a way for me to learn
more about SQL Server at home? I have the option of taking my laptop
home with me but I'd rather not and I think they'd prefer that I
didn't. I know I can install the express edition of 2005 but isn't that
lacking a lot of features (like SQL Agent)?

Thanks for your input!

--
Jerry

[quoted text, click to view]

Express has a lot of stuff, but if you want all the features of Enterprise
edition for non-production use, you can get SQL Server Developer Edition for
about $50.

http://www.microsoft.com/sql/editions/developer/howtobuy.mspx

David

Dear Jerry,

You may consider purchasing a copy of Developer's Edition to use at home.

Peter

[quoted text, click to view]

[quoted text, click to view]

Yes. It lacks the full features of the other edition, but it's packed with
many of the same capabilities. As others have suggested, SQL Server 2000
Developer Edition is your best bet, since it has the same features as the
Enterprise Edition, yet only costs about $50 for developers. (It's for non-
production environments only.) However, if price is an issue, then you have
two choices, not just one, for a free edition. SQL Server 2005 Express is
available for download, and Microsoft SQL Server 2000 Desktop Engine (MSDE
2000) is also available for download:

http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en


MSDE 2000 is a scaled down version of SQL Server 2000 and doesn't provide the
interface of Enterprise Manager. OSQL is expected to be used to manage it,
but if you have a copy of Microsoft Access 2000, 2002 or 2003, then you can
use an ADP and use the built-in designer to design stored procedures. T-SQL
will work the same in MSDE 2000 as it does in SQL Server 2000, whereas there
are some changes in SQL Server 2005 Express T-SQL, so it might not hurt to
try out MSDE 2000 for practice. If you do try this version, make sure you
download and install the SQL Server 2000 BOL (books online):

http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200612/1

And if you're planning to migrate to Vista soon, don't install SQL Server
2000 Developer Edition or MSDE 2000 on your computer, because Vista won't
support these. Install SQL Server 2005, either the Developer Edition or the
Express Edition.

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200612/1

Jerry (jerryalan@gmail.com) writes:
[quoted text, click to view]

In addition to the other suggestions, there is also the Evaluation Edition
which has all the features of Enterprise Edition, and which is good for
180 days. You find it
http://www.microsoft.com/downloads/details.aspx?FamilyId=6931FA7F-C094-49A2-
A050-2D07993566EC

Overall, I would encourage to do your training at home with SQL 2005, even
if you are using SQL 2000 at work. Presumably, you will move on to SQL 2005
at work sooner or later, so take the chance to get a head start.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at

If you want 2000 (to mimick the work) then

http://sholliday.spaces.live.com/blog/
search for "msde"

msde is "2000 lite" or "2000 freebie".


Neither Express (2005) or MSDE2000 have sql agent.

So pay for a developers edition (check www.pricewatch.com) or use a freebie.




[quoted text, click to view]

Thanks for the suggestions. I'll take a look at purchasing the
developer edition. I didn't know that was a possibility!

Thanks again!

--
Jerry

[quoted text, click to view]

You're welcome. Prices are pretty reasonable:

http://www.pricegrabber.com/p__Microsoft_SQL_Server_2005_Developer_Edition,__13707346/search=microsoft+SQL+Server+Developer+Edition


http://froogle.google.com/froogle?q=SQL+Server+2000+Developer+Edition&btnG=Search&lmode=online&price1=20.00&price2=40.00&lnk=prsugg


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-programming/200612/1