Wiley Professional SQL Server 2005 Programming 978-0-7645-8434-3 ユーザーズマニュアル
製品コード
978-0-7645-8434-3
Being Objective:
Re-Examining Objects
in SQL Server
Well, here we are. We’re at the beginning, but, if you’re someone who’s read my Professional level
titles before, you’ll find we’re not quite at the same beginning that we were at in previous editions.
SQL Server has gotten just plain too big, and so the “Pro” is going to become a little bit more “Pro”
in level right from the beginning.
titles before, you’ll find we’re not quite at the same beginning that we were at in previous editions.
SQL Server has gotten just plain too big, and so the “Pro” is going to become a little bit more “Pro”
in level right from the beginning.
So, why am I still covering objects first then? Well, because I think a review is always in order on
the basics, because you may need the see what’s changed versus previous editions, and, last but
not least, I still want this book to retain some of its use as a reference (I hate having to use 25 books
to get all the info that seems like it should have been in just one).
the basics, because you may need the see what’s changed versus previous editions, and, last but
not least, I still want this book to retain some of its use as a reference (I hate having to use 25 books
to get all the info that seems like it should have been in just one).
With this in mind, I’m going to start off the same way I always start off — looking at the objects avail-
able on your server. The difference is that I’m going to assume that you already largely know this
stuff, so we’re going to move along pretty quickly and make a rather short chapter out of this one.
able on your server. The difference is that I’m going to assume that you already largely know this
stuff, so we’re going to move along pretty quickly and make a rather short chapter out of this one.
So, What Exactly Do We Have Here?
What makes up a database? Data for sure. (What use is a database that doesn’t store anything?)
But a Relational Database Management System (RDBMS) is actually much more than data. Today’s
advanced RDBMSs not only store your data, they also manage that data for you, restricting what
kind of data can go into the system, and also facilitating getting data out of the system. If all you
want is to tuck the data away somewhere safe, you can use just about any data storage system.
RDBMSs allow you to go beyond the storage of the data into the realm of defining what that data
should look like. In the case of SQL Server, it doesn’t just stop there. SQL Server provides additional
services that help automate how your data interacts with data from other systems through such
powerful features as the SQL Server Agent, Integration Services, Notification Services, and more.
But a Relational Database Management System (RDBMS) is actually much more than data. Today’s
advanced RDBMSs not only store your data, they also manage that data for you, restricting what
kind of data can go into the system, and also facilitating getting data out of the system. If all you
want is to tuck the data away somewhere safe, you can use just about any data storage system.
RDBMSs allow you to go beyond the storage of the data into the realm of defining what that data
should look like. In the case of SQL Server, it doesn’t just stop there. SQL Server provides additional
services that help automate how your data interacts with data from other systems through such
powerful features as the SQL Server Agent, Integration Services, Notification Services, and more.
04_584340 ch01.qxp 10/18/06 2:11 PM Page 1
COPYRIGHTED MATERIAL