Beginning SQL Server 2008 Administration

✍ Scribed by Robert E. Walters, Grant Fritchey, Carmen Taglienti (auth.)

Publisher: Apress
Year: 2009
Tongue: English
Leaves: 425
Edition: 1
Category: Library

No coin nor oath required. For personal study only.

✦ Synopsis

Beginning SQL Server 2008 Administration is essential for anyone wishing to learn about implementing and managing SQL Server 2008 database. From college students, to experienced database administrators from other platforms, to those already familiar with SQL Server and wanting to fill in some gaps of knowledge, this book will bring all readers up to speed on the enterprise platform Microsoft SQL Server 2008.

Clearly describes relational database concepts
Explains the SQL Server database engine and supporting tools
Shows various database maintenance scenarios

✦ Table of Contents

Front Matter....Pages i-xxii
The Database Administration Profession....Pages 1-8
Planning and Installing SQL Server 2008....Pages 9-40
What’s in the Toolbox?....Pages 41-73
Creating Tables and Other Objects....Pages 75-95
Transact-SQL....Pages 97-116
SQL Server Internals....Pages 117-126
Storage Management Strategies....Pages 127-149
Database Backup Strategies....Pages 151-182
Database Restore Strategies....Pages 183-210
Common Database Maintenance Tasks....Pages 211-238
Automation Through SQLCMD and PowerShell....Pages 239-262
Database Maintenance Plans....Pages 263-286
Performance Tuning and Optimization....Pages 287-326
SQL Server Security....Pages 327-345
Auditing, Encryption, and Compliance....Pages 347-371
SQL Server in the Enterprise....Pages 373-394
Where to Go Next?....Pages 395-399
Back Matter....Pages 401-410

✦ Subjects

Data Structures, Cryptology and Information Theory

📜 SIMILAR VOLUMES

Beginning SQL Server2005 Administration

📁 Beginning SQL Server2005 Administration

✍ Dan Wood, Chris Leiter, Paul Turley 📂 Library 📅 2006 🏛 Wrox 🌐 English

For the first time, SQL Server 2005 provides features that can support large-scale enterprise databases. With this powerful new release, you may find yourself being called upon to perform duties that are no longer strictly "administrative," duties that have become much more complicated and difficult

Beginning SQL Server 2005 Administration

📁 Beginning SQL Server 2005 Administration

✍ Dan Wood, Chris Leiter, Paul Turley 📂 Library 📅 2007 🏛 Wrox-Wiley Pub 🌐 English

Beginning Microsoft SQL Server 2008 Admi

📁 Beginning Microsoft SQL Server 2008 Administration

✍ Chris Leiter, Dan Wood, Michael Cierkowski, Albert Boettger 📂 Library 🌐 English

Beginning Microsoft SQL server 2008 admi

📁 Beginning Microsoft SQL server 2008 administration

✍ Chris Leiter, Dan Wood, Michael Cierkowski, Albert Boettger 📂 Library 📅 2009 🏛 Wiley Pub 🌐 English

Beginning Microsoft SQL Server 2008 Admi

📁 Beginning Microsoft SQL Server 2008 Administration

✍ Chris Leiter, Dan Wood, Michael Cierkowski, Albert Boettger 📂 Library 📅 2 🏛 Wrox 🌐 English

SQL Server 2008 introduces many new features that will change database administration procedures; many DBAs will be forced to migrate to SQL Server 2008. This book teaches you how to develop the skills required to successfully administer a SQL Server 2008 database; no prior experience is required. T

Beginning SQL Server 2012 Administration

📁 Beginning SQL Server 2012 Administration

✍ Rob Walters, Grant Fritchey (auth.) 📂 Library 📅 2012 🏛 Apress 🌐 English

<p><em>Beginning SQL Server 2012 Administration</em> provides the essential skills and knowledge needed to begin a successful career as an SQL Server database administrator. It's an ideal book for those new to database administration, as well for those moving to SQL Server from other database brands