Wiley Professional SQL Server 2005 Administration 978-0-470-05520-5 用户手册
产品代码
978-0-470-05520-5
SQL Server 2005
Architecture
The days of SQL Server being a departmental database are long gone, and SQL Server can now
easily scale to databases dozens of terabytes in size. In this chapter, we lay some of the ground-
work that will be used throughout the book. We first discuss how the role of the DBA has changed
since some of the earlier releases of SQL Server and then quickly jump into architecture and tools
available to you as an administrator. This chapter is not a deep dive into the architecture but pro-
vides enough information to give you an understanding of how SQL Server operates.
easily scale to databases dozens of terabytes in size. In this chapter, we lay some of the ground-
work that will be used throughout the book. We first discuss how the role of the DBA has changed
since some of the earlier releases of SQL Server and then quickly jump into architecture and tools
available to you as an administrator. This chapter is not a deep dive into the architecture but pro-
vides enough information to give you an understanding of how SQL Server operates.
Growing Role of a DBA
The role of the database administrator (DBA) has been changing slowly over the past few versions
of the SQL Server product. In SQL Server 2005, this slow transition of the DBA role has been accel-
erated immensely. Traditionally, a DBA would fit into one of two roles: development or adminis-
tration. It’s much tougher to draw a line now between DBA roles in SQL Server 2005. As lines blur
and morph, DBAs have to quickly prepare themselves to take on different roles. If you don’t posi-
tion yourself to be more versatile, you may be destined for a career of watching SQL Server alerts
and backups.
of the SQL Server product. In SQL Server 2005, this slow transition of the DBA role has been accel-
erated immensely. Traditionally, a DBA would fit into one of two roles: development or adminis-
tration. It’s much tougher to draw a line now between DBA roles in SQL Server 2005. As lines blur
and morph, DBAs have to quickly prepare themselves to take on different roles. If you don’t posi-
tion yourself to be more versatile, you may be destined for a career of watching SQL Server alerts
and backups.
Production DBA
Production DBAs fall into the traditional role of a DBA. They are a company’s insurance policy
that the production database won’t go down. If the database does go down, the company cashes
in its insurance policy in exchange for a recovered database. The Production DBA also ensures
the server is performing optimally and promotes database changes from development to QA to
production.
that the production database won’t go down. If the database does go down, the company cashes
in its insurance policy in exchange for a recovered database. The Production DBA also ensures
the server is performing optimally and promotes database changes from development to QA to
production.
04_055200 ch01.qxp 10/31/06 12:37 PM Page 1
COPYRIGHTED MATERIAL