What version of SQL Server to buy?

#11

On Sat, 4 Aug 2007 15:30:02 -0400, Charlie wrote:

Quote:

I have the free version. What advantage is the developer version over the
free version? I am having trouble creating table relationships in the free
version. Any advice?

Hi Charlie,

WRT relationships, the Express Edtion has the same features as any of
the other editions.

In case you haven't yet done so, you might want to download and install
Management Studio Express, a graphical interface exposing many of SQL
Server Express' features. For some, using a GUI is great. For many other
features, I wouldn't want to touch a GUI with a 10' pole, since writing
straight SQL gives me so much more control.

Using a GUI and then checking the generated SQL *can* be a way to learn
writing SQL, but beware that it's also a great to to learn to write bad
SQL, as some of the stuff that the GUI generates is terrible. You might
be better off buying (or borrowing) and reading a text book to write to
learn SQL.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

#12

Thanks. I've been writing SQL in Access for years (for what it's worth). It
may be more of a hindrance than an asset. I have installed Management Studio
Express, and like it so far.

I have two text books so far, but they are for SQL 2000.

Charlie

"Hugo Kornelis" <hugo (AT) perFact (DOT) REMOVETHIS.info.INVALID> wrote

Quote:

On Sat, 4 Aug 2007 15:30:02 -0400, Charlie wrote:

I have the free version. What advantage is the developer version over the
free version? I am having trouble creating table relationships in the free
version. Any advice?

Hi Charlie,

WRT relationships, the Express Edtion has the same features as any of
the other editions.

In case you haven't yet done so, you might want to download and install
Management Studio Express, a graphical interface exposing many of SQL
Server Express' features. For some, using a GUI is great. For many other
features, I wouldn't want to touch a GUI with a 10' pole, since writing
straight SQL gives me so much more control.

Using a GUI and then checking the generated SQL *can* be a way to learn
writing SQL, but beware that it's also a great to to learn to write bad
SQL, as some of the stuff that the GUI generates is terrible. You might
be better off buying (or borrowing) and reading a text book to write to
learn SQL.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

#13

Thanks for the info. I t is appreciated.

Charlie

"Hugo Kornelis" <hugo (AT) perFact (DOT) REMOVETHIS.info.INVALID> wrote

Quote:

On Sun, 5 Aug 2007 12:17:04 -0400, Charlie wrote:

Interesting that the Microsoft web site doesn't include the developer
version in the comparison.

Hi Charlie,

Yeah, I've been bitten by that one as well. Actually, the reason is (or
was, last time I looked) mentioned on one of the comparison pages, but
buried deep in the small print so I can't blame you for not finding it!

The reason that developer edition is not included on the feature
comparison pages, is that developer edition has the exact same features
as the enterprise edition! The only differences are price, license, and
(as Bucky points out) supported operating systems - but those
characteristics are mentioned on other pages, where developer edition is
indeed included!

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

#14

Thanks. Later this year, I'll probably use a second computer to act as a
server for testing. I'll get it with Windows Server.

Charlie

"Bucky" <uw_badgers (AT) email (DOT) com> wrote

Quote:

On Aug 3, 3:21 pm, "Charlie" <jadki... (AT) yahoo (DOT) com> wrote:
I am a single developer, and new to SQL Server. I have Windows XP Pro,
and
my system has a couple gigs RAM. I would like to know what version of SQL
Server I should buy. Any advice is appreciated.

yeah, developer version is probably the best choice. The enterprise
actually won't install on XP (only Windows Server)

#15

Charlie wrote:

Quote:

Thanks. I've been writing SQL in Access for years (for what it's worth). It

Jet SQL (Access) and T-SQL (SQL Server) are quite different.

Caused me a lot of frustration learning Access when I couldn't
do what the SQL books said. Then more frustration trying to
unlearn the "wrong" way in switching to Server.

--
Wes Groleau

Always listen to experts. They'll tell you
what can't be done and why. Then do it.
-- Robert A. Heinlein

#16

On Sun, 5 Aug 2007 19:10:23 -0400, Charlie wrote:

Quote:

I have two text books so far, but they are for SQL 2000.

Hi Charlie,

AFAIK, everything that worked in SQL 2000 and was not deprecated will
also work in SQL 2005. And I expect (hope?) that no serious book will
describe deprecated features, at least not without due warning.

I'd recommend finishing those books first before spending money on new
books.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

What version of SQL Server to buy?

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

Re: What version of SQL Server to buy? - 08-05-2007 , 02:49 PM

Re: What version of SQL Server to buy? - 08-05-2007 , 06:10 PM

Re: What version of SQL Server to buy? - 08-05-2007 , 06:11 PM

Re: What version of SQL Server to buy? - 08-05-2007 , 06:14 PM

Re: What version of SQL Server to buy? - 08-05-2007 , 11:16 PM

Re: What version of SQL Server to buy? - 08-06-2007 , 04:18 PM