Downloads from this Issue
Table of Contents
Yukon
Editorial:Approaching Yukon
by Steve Jones
Best New SQL Server 2005 Features for DBA's
by
Brian Knight
SQL Server 2005 is a huge improvement from SQL Server 2000 with lots of enhancements in all areas. Brian Knight looks at a few of the really cool features that DBAs will be most interested in when administering their servers.
What's New in SQL Server Integration Services
by
Darren Green and Allen Mitchell
DTS is gone in SQL Server 2005. Instead, newly renamed and apparently rewritten, Integration Services is the ETL tool for the newest version of SQL Server. The founders of SQLDTS.com and now SQLIS.com bring you a first look at this amazing new tool.
Row Numbers in SQL Server 2005
by
Joe Sack
Getting the row number seems to be a constant battle in SQL Server. Until now that is. With SQL Server 2005, Joe Sack brings a new technique to easily enable you to get the row number and use it in your queries.
SQL Server 2005 Name Resolutions - Owners and Schemas
by
Wendy Sue Williams
In SQL Server we've always had an owner for each object, somewhat analagous to the schema in other RDBMS. In SQL Server 2005, the product has matured and now truly has a schema separate from the object owner. Wendy Williams brings us a first look at how this differs from the owner and how you might use it in your design and applications.
The Next Evolution of Management Objects
by
Steve Jones
In it's now third evolution, the management objects for SQL Server have changed from DMO to System Management Objects (SMO) in SQL Server 2005. Steve Jones takes a first look at the new .NET enabled objects and their changes from DMO.
Encryption in Yukon
by
Brian Kelley
A tremendous number of security enhancements have changed in SQL Server 2005, but perhaps none with the impact that encrpytion has. Brian Kelley looks at a number of the new features in SQL Server 2005 that relate to it's ability to encrypt data.
(download now)
SQL Server Metadata
by
Anthony Bressi
Metadata is data about data. A confusing, but actually descriptive phrase. Much of the data about SQL Server itself is stored in tables that are accessable to you. Anthony Bressi brings us a look at the various ways in which you can get at this information.
(download now)
Introducing Database Mirroring
by
Rick Heiges
A look at the new database mirroring feature in SQL Server 2005 from one of the esteemed board members of PASS. This may be the most exciting new feature that DBAs are looking forward to working with.
Strengthening European Presence in 2005
by
PASS
A look at the new database mirroring feature in SQL Server 2005 from one of the esteemed board members of PASS. This may be the most exciting new feature that DBAs are looking forward to working with.
Editorial
Approaching Yukon
It's now known as SQL Server 2005 though I have to admit that I like Yukon much better. How interesting would it be if the code names were the actual names of the products? Wishful thinking, but I'd sure like to install SQL Server Yukon or SQL Server Shiloh or even SQL Server Sphinx rather than SQL Server 2000. Makes as much sense as the current naming. 2000 is v8, 2005 is v9?!??!!
This issue marks a change for SQL Server Standard. Not only is this the start of our second year, but we've also made a change in the way we build the magazine. When we started this last year, we looked at lots of layout ideas and designs. Since artistic ability isn't really one of our talents, we let someone else choose the look, and then scrambled to get content for the feel. A year of scrambling has left us looking like most other magazines. A theme and an article or two to support it, but mostly we're filling space with whatever interesting articles we can find. And we're trying to put something in each magazine for everyone.
No longer. This year our goal, and an ambitious one at that, is to dedicate each magazine to a theme and try to fill it with articles that support that theme. As you might have guessed, January is devoted to Yukon and we've got 6 articles. All on that very topic to get you ready for the next release of SQL Server. And we've got similar plans for the remainder of the year; each issue devoted to a topic: replication, performance, and a few others.
Hopefully you'll enjoy it and find some value in it. We're trying something new here at SQLServerCentral.com and we'd love to have some feedback on whether this meets your needs, you like it, any improvements you'd like to see, or even those topics that interest you. Send a note to articles@sqlservercentral.com and we'll take a look and see what we can do.
Steve Jones
|