is there a good article or book or faq which highlights the
differences between sql2k and sql2005?
tia,
dkYes. 2005 Books Online details the differences pretty explicitly. Be
prepared to spend several hours, because the information is several hundred
pages deep.
--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"dk" <dk@.discussions.microsoft.com> wrote in message
news:215A1B80-81D1-4788-96A2-A63153EEB5C1@.microsoft.com...
> is there a good article or book or faq which highlights the
> differences between sql2k and sql2005?
> tia,
> dk|||There is no simple answer as 2005 is a major upgrade and there are lots of
new features. One of the most interesting features involves CLR integration,
which lets you can code your stored procedures, functions, and triggers in
the .NET Framework language of your choice. Microsoft Visual Basic .NET and
the C#. Another major new feature is Database Mirroring and a complete
rewrite of DTS. DTS is now called SSIS (SQL Server Integration Services )
Lots of new features in reporting services and Business Intelligence. See
www.sqlservercentral for a bunch of great articles on 2005.
For the Microsoft perspective see
http://www.microsoft.com/sql/prodinfo/overview/whats-new-in-sqlserver2005.mspx
"dk" wrote:
> is there a good article or book or faq which highlights the
> differences between sql2k and sql2005?
> tia,
> dk|||This is a multi-part message in MIME format.
--020109090507080508080807
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
In addition, Michael Otey (the Technical Director for SQLMag) wrote a
book about a year & a half ago (so it will be based on a Beta version I
think) published by Osborne called Microsoft SQL Server 2005 New
Features
<http://www.amazon.com/gp/product/0072227761/sr=1-1/qid=1138921308/ref=sr_1_1/102-3661316-4174542?%5Fencoding=UTF8>.
I haven't read it myself but it sounds like it might be right up your alley.
--
*mike hodgson*
http://sqlnerd.blogspot.com
Michael Hotek wrote:
>Yes. 2005 Books Online details the differences pretty explicitly. Be
>prepared to spend several hours, because the information is several hundred
>pages deep.
>
>
--020109090507080508080807
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>In addition, Michael Otey (the Technical Director for </tt><tt>SQLMag</tt><tt>)
wrote a book about a year & a half ago (so it will be based on a
Beta version I think) published by Osborne called <a
href="http://links.10026.com/?link=Microsoft">http://www.amazon.com/gp/product/0072227761/sr=1-1/qid=1138921308/ref=sr_1_1/102-3661316-4174542?%5Fencoding=UTF8">Microsoft
SQL Server 2005 New Features</a>. I haven't read it myself but it
sounds like it might be right up your alley.</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Michael Hotek wrote:
<blockquote cite="midesC9ngBKGHA.3728@.tk2msftngp13.phx.gbl" type="cite">
<pre wrap="">Yes. 2005 Books Online details the differences pretty explicitly. Be
prepared to spend several hours, because the information is several hundred
pages deep.
</pre>
</blockquote>
</body>
</html>
--020109090507080508080807--
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment