Wiley 978-0-470-24796-9 Datasheet download pdf

Knight c01.tex V2 - 09/30/2008 6:52am Page 1

SQL Server 2008

Architecture

The days of SQL Server being merely a departmental database are long gone. SQL Server can now

easily scale to databases dozens of terabytes in size. (For details see the results of the Winter survey

www.microsoft.com/sql/prodinfo/compare/wintercorp-survey.mspx

.) In this chapter, we lay

some of the groundwork that will be used throughout the book. We ﬁrst discuss how the role of the

database administrator (DBA) has changed since some o f the earlier releases o f SQL Server, a nd then

quickly jump into architecture and tools available t o you as an administrator. This chapter is not a

deep dive into the architecture but it provides enough information to give you an understanding of

how SQL Server operates.

The Expanding Role of a DBA

The role of the database administrator has been changing slowly over the past few versions of the

SQL Server product. Beginning with SQL Server 2005, this slow transition of the DBA role has

been accelerated immensely. Traditionally, a DBA would ﬁt into one of two roles: development or

administration. It’s much tougher to draw a line now between DBA roles in SQL Server 2008. In

addition, the new role of Business Intelligence DBA is on the rise. As lines blur and morph, DBAs

have to quickly prepare themselves to take on different roles. If you don’t position 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

COPYRIGHTED MATERIAL

1 2 3 4 5 6 ... 33 34

Summary of Contents

Page 1 - COPYRIGHTED MATERIAL

Knight c01.tex V2 - 09/30/2008 6:52am Page 1SQL Server 2008ArchitectureThe days of SQL Server being merely a departmental database are long gone. SQL

Page 2 - Development DBA

Knight c01.tex V2 - 09/30/2008 6:52am Page 10Chapter 1: SQL Server 2008 ArchitectureDynamic Management ViewsDynamic management views (DMVs) and functi

Page 3 - Hybrid DBA

Knight c01.tex V2 - 09/30/2008 6:52am Page 11Chapter 1: SQL Server 2008 ArchitectureWhen you convert to a data type that may be incompatible with your

Page 4 - New Things You Need to Learn

Knight c01.tex V2 - 09/30/2008 6:52am Page 12Chapter 1: SQL Server 2008 ArchitectureUnicode consumes 2 bytes per character. If you were to store the v

Page 5 - SQL Ser ver Architecture

Knight c01.tex V2 - 09/30/2008 6:52am Page 13Chapter 1: SQL Server 2008 ArchitectureData Type Description Storage SpacebigintWhole numbers from–9,223,

Page 6 - SQL Native Client

Knight c01.tex V2 - 09/30/2008 6:52am Page 14Chapter 1: SQL Server 2008 Architecturevarbinary(max), which can hold more than 8KB of binary data and ge

Page 7 - System Databases

Knight c01.tex V2 - 09/30/2008 6:52am Page 15Chapter 1: SQL Server 2008 ArchitectureData Type Description Storage SpaceDateJanuary 1, 1 to December 31

Page 8

Knight c01.tex V2 - 09/30/2008 6:52am Page 16Chapter 1: SQL Server 2008 ArchitectureData Type Description Storage SpaceTimestamp orRowversionUnique pe

Page 9 - Synonyms

Knight c01.tex V2 - 09/30/2008 6:52am Page 17Chapter 1: SQL Server 2008 ArchitectureCompact (32-bit Only)SQL Compact is a free edition which is intend

Page 10 - SQL Server 2008 Data Types

Knight c01.tex V2 - 09/30/2008 6:52am Page 18Chapter 1: SQL Server 2008 ArchitectureThe Evaluation Edition of SQL Server is a variant of SQL Server En

Page 11 - Character Data Types

Knight c01.tex V2 - 09/30/2008 6:52am Page 19Chapter 1: SQL Server 2008 Architecturethe edition of SQL Server you purchase. In some cases, your scalab

Page 12 - Exact Numeric Data Types

Knight c01.tex V2 - 09/30/2008 6:52am Page 2Chapter 1: SQL Server 2008 Architecturein its insurance policy in exchange for a recovered database. The P

Page 13 - Binary Data Types

Knight c01.tex V2 - 09/30/2008 6:52am Page 20Chapter 1: SQL Server 2008 ArchitectureHigh AvailabilityKeeping your data online and ready to use is of p

Page 14 - Date and Time Data Types

Knight c01.tex V2 - 09/30/2008 6:52am Page 21Chapter 1: SQL Server 2008 ArchitectureSecurityAs more data governance, auditability, and accountability

Page 15 - Other System Data Types

Knight c01.tex V2 - 09/30/2008 6:52am Page 22Chapter 1: SQL Server 2008 ArchitectureManageabilityWhile SQL Server databases have historically been eas

Page 16 - Editions of SQL Ser ver

Knight c01.tex V2 - 09/30/2008 6:52am Page 23Chapter 1: SQL Server 2008 ArchitectureFeature ExpressAdvancedExpress Web Workgroup Standard EnterpriseDa

Page 17

Knight c01.tex V2 - 09/30/2008 6:52am Page 24Chapter 1: SQL Server 2008 ArchitectureFeature ExpressAdvancedExpress Web Workgroup Standard EnterpriseVi

Page 18 - Operating System

Knight c01.tex V2 - 09/30/2008 6:52am Page 25Chapter 1: SQL Server 2008 ArchitectureFeature ExpressAdvancedExpress Web Workgroup Standard EnterpriseSp

Page 19 - Database Features by Edition

Knight c01.tex V2 - 09/30/2008 6:52am Page 26Chapter 1: SQL Server 2008 ArchitectureFeature ExpressAdvancedExpress Web Workgroup Standard EnterpriseIn

Page 20 - High Availability

Knight c01.tex V2 - 09/30/2008 6:52am Page 27Chapter 1: SQL Server 2008 ArchitectureData Warehouse CreationNew designers and auto-generation of stagin

Page 21 - Replication

Knight c01.tex V2 - 09/30/2008 6:52am Page 28Chapter 1: SQL Server 2008 ArchitectureMulti-Dimensional AnalyticsSpecial aggregations and intelligence,

Page 22 - Manageability

Knight c01.tex V2 - 09/30/2008 6:52am Page 29Chapter 1: SQL Server 2008 ArchitectureData MiningSerious data-mining efforts will require the Enterprise

Page 23 - Development Tools

Knight c01.tex V2 - 09/30/2008 6:52am Page 3Chapter 1: SQL Server 2008 Architecturenever have modiﬁcation access to a production database. They should

Page 24 - Programmability

Knight c01.tex V2 - 09/30/2008 6:52am Page 30Chapter 1: SQL Server 2008 ArchitectureReportingReporting Services (SSRS), supported in many environments

Page 25 - Integration Services

Knight c01.tex V2 - 09/30/2008 6:52am Page 31Chapter 1: SQL Server 2008 ArchitectureFeature ExpressAdvancedExpress Web Workgroup Standard EnterpriseRe

Page 26

Knight c01.tex V2 - 09/30/2008 6:52am Page 32Chapter 1: SQL Server 2008 Architecturea license fee for each device (client computer) that accesses the

Page 27 - Data Warehouse Creation

Knight c01.tex V2 - 09/30/2008 6:52am Page 33Chapter 1: SQL Server 2008 ArchitectureEnterprise license exists for the physical server, there are no ad

Page 28 - Multi-Dimensional Analytics

Knight c01.tex V2 - 09/30/2008 6:52am Page 34Chapter 1: SQL Server 2008 ArchitectureSummaryIn this chapter, we covered the basic architecture for SQL

Page 29 - Data Mining

Knight c01.tex V2 - 09/30/2008 6:52am Page 4Chapter 1: SQL Server 2008 ArchitectureIdeally, for regulatory reasons and for stability, the DBA’s backup

Page 30 - Reporting

Knight c01.tex V2 - 09/30/2008 6:52am Page 5Chapter 1: SQL Server 2008 ArchitectureSQL Ser ver ArchitectureIn older editions of SQL Server, you had to

Page 31 - Licensing

Knight c01.tex V2 - 09/30/2008 6:52am Page 6Chapter 1: SQL Server 2008 Architecture8KB data pages. You can specify how full each data page should be w

Page 32

Knight c01.tex V2 - 09/30/2008 6:52am Page 7Chapter 1: SQL Server 2008 ArchitectureSystem DatabasesThe system databases in SQL Server are crucial, and

Page 33

Knight c01.tex V2 - 09/30/2008 6:52am Page 8Chapter 1: SQL Server 2008 Architectureinmasterby running the following query, which returns information a

Page 34

Knight c01.tex V2 - 09/30/2008 6:52am Page 9Chapter 1: SQL Server 2008 ArchitectureSchemasSchemas enable you to group database objects together. You m

Comments to this Manuals

No comments

Wiley 978-0-470-24796-9 Datasheet

Browse online or download Datasheet for Software manuals Wiley 978-0-470-24796-9. Wiley Professional Microsoft SQL Server 2008 Administration User Manual

Summary of Contents

Comments to this Manuals

Related products and manuals for Software manuals Wiley 978-0-470-24796-9