Programming Books C Java PHP Python Learn more Browse Programming Books
Microsoft SQL Server 2008 Management and Administration and over one million other books are available for Amazon Kindle. Learn more
Qty:1
  • List Price: $39.99
  • Save: $6.37 (16%)
FREE Shipping on orders over $35.
Only 8 left in stock (more on the way).
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
Want it Monday, April 21? Order within and choose One-Day Shipping at checkout. Details
FREE Shipping on orders over $35.
Condition: Used: Good
Add to Cart
Have one to sell?
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See all 2 images

Microsoft SQL Server 2008 Management and Administration Paperback

ISBN-13: 978-0672330445 ISBN-10: 067233044X Edition: 1st

See all 3 formats and editions Hide other formats and editions
Amazon Price New from Used from Collectible from
Kindle
"Please retry"
Paperback
"Please retry"
$33.62
$5.98 $5.59

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



Frequently Bought Together

Microsoft SQL Server 2008 Management and Administration + Microsoft SQL Server 2008 R2 Unleashed
Price for both: $74.08

Buy the selected items together

NO_CONTENT_IN_FEATURE

Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Paperback: 912 pages
  • Publisher: Sams Publishing; 1 edition (January 2, 2009)
  • Language: English
  • ISBN-10: 067233044X
  • ISBN-13: 978-0672330445
  • Product Dimensions: 8.5 x 5.5 x 2 inches
  • Shipping Weight: 2.2 pounds (View shipping rates and policies)
  • Average Customer Review: 4.1 out of 5 stars  See all reviews (14 customer reviews)
  • Amazon Best Sellers Rank: #603,741 in Books (See Top 100 in Books)

Editorial Reviews

About the Author

Ross Mistry, MVP, MCTS, MCDBA, MCSE Ross Mistry is a seasoned professional in the Silicon Valley and a technology advocate with more than a decade of experience in the computer industry. As a principal consultant and partner with Convergent Computing (CCO), Ross designs and implements SQL Server, Active Directory, and Exchange solutions for Fortune 500 organizations with a global presence. Some of the organizations in which Ross Mistry has taken on the role of lead global Microsoft architect include: Network Appliance, Ross Stores Dress for Less, CIBC, Gilead Sciences, Solectron, The Sharper Image, 2Wire, Infinera, and Wells Fargo’s small business Ecommerce site.

 

Ross had the opportunity to work with SQL Server 2008 two years prior to the product release. When he is not focused on his SQL Server specialties– high availability, migrations, and security–his attention turns to SQL Server development and Business Intelligence. Ross is an author, co-author, and technical editor of more than 10 books. Many of the books have been bestsellers. Recently, he coauthored Windows Server 2008 Unleashed and SQL Server 2005 Management and Administration. He was a contributing writer on Hyper-V Unleashed, Exchange Server 2007 Unleashed, and SharePoint Server 2007 Unleashed. Ross also took on the role of technical editor for SQL Server 2005 Unleashed and SQL Server 2005: Changing the Paradigm. In addition to being an author and consultant, Ross is a public speaker who conducts seminars on Microsoft topics around the world. He frequently speaks at local SQL Server user groups and international conferences. Most recently, he spoke at the SQL Server PASS Community Summit in North America, SQL Server Europe PASS, SQL Server Connections, and the

Microsoft campuses in San Francisco and the Silicon Valley. As a SQL Server Microsoft Most Valuable Professional (MVP), Ross is heavily involved with the SQL Server community and assists by responding to questions in newsgroups, writing articles for magazines, and blogging for networkworld. com and to IT managers on Microsoft’s TechNet Community Hub site. His blog site is http://www.networkworld.com/community/mistry.

 

Ross' blog can be viewed at http://www.networkworld.com/community/mistry and he can reached at Ross@cco.com.

 

Excerpt. © Reprinted by permission. All rights reserved.

Introduction

Introduction

SQL Server 2008 is Microsoft’s latest data platform providing data management and analytical solutions for the enterprise. The platform is trusted, ensures business continuity, and is more predictable and more scalable than ever before. Although similar to SQL Server 2005, SQL Server 2008 offers a tremendous number of new features and functionality for database administrators, developers, and business intelligence architects.

This book is designed to be the ultimate guide for database administrators as it provides detailed guidance in the areas of planning, installation, management, administration, security, high availability, monitoring, and performance tuning of a SQL Server environment. Moreover, this book includes industry best practices, tips, and step-by-step instructions based on real-world examples.

Some of the classic and new SQL Server 2008 topics covered in the book include: installation, upgrade and migration strategies, Policy Based Administration, Resource Governor, encryption, failover clustering, database mirroring, authorization, hardening, consolidation and virtualization, maintenance plans, monitoring, performance tuning, troubleshooting, log shipping, PowerShell scripting, replication, creating packages and transferring data, indexes, full-text catalogs, and backing up and restoring databases.

The book is also based on Microsoft’s latest award-winning server operating system—Windows Server 2008. As a result, not only will readers gain knowledge about SQL Server 2008, but they will also have the opportunity to understand the advantages of running SQL Server 2008 on Windows Server 2008.

What Is in This Book?

This book is organized into five parts, with each part made up of several chapters focusing on core SQL Server 2008 elements. The parts and chapters of the book are detailed in this section.

Part I: Installing, Administering, and Managing the Database Engine

The first part of the book begins by providing an overview of SQL Server 2008, including planning and installing the new platform. After you get SQL Server 2008 installed, the majority of your time will be spent managing and administering the new SQL Server infrastructure. Therefore, the remainder of Part I consists of chapters dedicated to SQL Server 2008 administration and management tasks.

Chapter 1: Installing or Upgrading to the SQL Server 2008 Database Engine

With the recent release of SQL Server 2008, organizations are eager to migrate to the new and improved database platform. However, many organizations feel challenged when trying to establish the best strategies for moving forward. This chapter focuses on the various SQL Server 2008 migration strategies that are available. It answers the question once and for all whether or not organizations should upgrade from a previous version or perform a new SQL Server 2008 installation from scratch and then conduct a migration.

Other topics highlighted in this chapter include: supported migration methodologies, hardware requirements, using the SQL Server 2008 Upgrade Advisor, supported legacy versions of SQL Server, and best practices, tips, and common pitfalls to look out for to achieve a successful migration. Moreover, this chapter describes the benefits associated with running SQL Server on Windows Server 2008, and it also includes upgrade strategies for moving to the latest server operating system.

Chapter 2: Administering the SQL Server 2008 Database Engine

After SQL Server 2008 is installed, it is necessary to configure and administer the server. This chapter focuses on administering the core features and components associated with the Database Engine. Topics include administering the SQL Server properties pages, Database properties pages, Database Engine folders, and the SQL Server Agent. Managing server and database configuration settings—such as memory, processor performance, auditing, compression, database files, and autogrowth—is also covered in depth.

Chapter 3: Creating Packages and Transferring Data with Integration Services

A common database administrator task is transferring data or databases between source and target environments. This chapter focuses on importing, exporting, and transforming data and databases via SQL Server Management Studio and Integration Services. The chapter also covers how packages are created, saved, and executed as well as the management of the Integration Services component.

Chapter 4: Managing and Optimizing SQL Server 2008 Indexes

Similar to an index found in a book, an index in SQL Server is utilized for fast retrieval of data from tables. This chapter explains index concepts, ways to design the appropriate index strategy to maximize performance, creating indexes with SQL Server Management Studio, and how to create indexes with Transact-SQL. The chapter also introduces new SQL Server 2008 index topics, such as creating spatial and filtered indexes, and shares best practices on implementing, managing, and optimizing indexes.

Chapter 5: Administering SQL Server 2008 Full-Text Search

With the data explosion and the ever-increasing amount of data being stored in its native format, full-text search is playing an increasingly important role in databases today. This chapter discusses the new features in SQL Server full-text search and provides step-by-step instructions on how to implement full-text search on your tables, and best practices for full-text search.

Chapter 6: SQL Server 2008 Maintenance Practices

For SQL Server to perform at optimal levels, a DBA should conduct routine maintenance on each database. This chapter focuses on best practices associated with maintaining databases within the SQL Server Database Engine.

The discussion includes creating maintenance plans to check database integrity, shrink databases, reorganize indexes, and update statistics. Additionally, this chapter provides recommendations on daily, weekly, monthly, and quarterly maintenance practices to be conducted on SQL Servers.

Chapter 7: Backing Up and Restoring the SQL Server 2008 Database Engine

Backing and restoring databases is one of the most critical duties of a DBA. It is important that the DBA understand the concepts associated with SQL Server backups, therefore, in the event of a disaster they can restore the database to the point of failure. This chapter covers the new backup compression feature, the importance of backups, creating a backup and recovery plan, storage architecture, transaction log files, recovery model, the various types of backups, backing up with SSMS, automating backups with a maintenance plan, backing up full-text catalogs, creating database snapshots, and of course, best practices.

Part II: SQL Server 2008 Security Practices

Part II of SQL Server 2008 Management and Administration is dedicated to SQL Server security. The first two chapters cover hardening techniques for both SQL Server 2008 and Windows Server 2008 and also discuss administering security and authorization. The next two chapters describe the new features, Policy Based Management, and encryption.

Chapter 8: Hardening a SQL Server Implementation

SQL Server is regularly targeted by hackers because it is a repository of sensitive data for organizations. If an organization’s system is breached, hackers can gain access to confidential information including, but not limited to, credit card numbers, social security numbers, and marketing information. As such, it is imperative that database administrators secure both the SQL Server implementation and the data residing in it. This chapter provides an overview of how to harden a SQL Server implementation based on industry best practices so that vulnerabilities and security breaches are minimized.

Some of the security and hardening topics that the chapter delves into include: choosing the appropriate authentication mechanism, hardening the SA account, enforcing strong passwords, leveraging the configuration tools to lock down a SQL Server, configuring the Windows Server 2008 advanced firewall for secure access, selecting the correct service account, and applying security templates with Active Directory.

Chapter 9: Administering SQL Server Security and Authorization

After the SQL Server installation is hardened, the next step involves administering security and granting authorization to the SQL Server environment. Chapter 9 is all about security administration topics: creating logons, granting access and authorization, understanding SQL Server roles, administering password policies, endpoint authentication, SQL Server and database principals, role-based security, and user and schema separation.

Chapter 10: Administering Policy Based Management

Enforcing best practices and standardization on large SQL Server installations was extremely difficult in previous versions of SQL Server. To ensure standardization, SQL Server 2008 introduces Policy Based Management, which allows a DBA to define policies that can be applied to one or more SQL Server instances, databases, and objects. Policy Based Management works on SQL Server 2000 and all its successors.

New concepts, components, terminology, and reporting with Policy Based Management as well as best practices are discussed in Chapter 1...


More About the Author

Ross Mistry is a Technical Architect with Microsoft. Ross provides executive briefings, architectural design sessions, and proof of concept workshops to organizations located in the Silicon Valley. His core speciality is SQL Server, however, he also focuses on Active Directory, Exchange and Hyper-V.

Ross is also an author on many books, articles and whitepapers. His recent books include; Introducing SQL Server 2008 R2 (MSPress), Windows Server 2008 R2 Unleashed (SAMS) and SQL Server 2008 Management and Administration (SAMS). Ross is a former SQL Server MVP, well known in the worldwide SQL Server community and frequently speaks at technology conferences and user groups around the world, such as PASS, SQL Connections, Europe PASS, SQL BITS and Microsoft.

Prior to joining Microsoft, Ross was a Managing Partner and Principal Consultant responsible for designing and implementing technology solutions for organizations with a global presence. Some of his customers included; EBay, MacAfee, Yahoo, Gilead Sciences, Ross Stores Dress for Less, The Sharper Image, McDonalds, CIBC, Radio Shack, Wells Fargo and TD Waterhouse.

You can follow and contact Ross on Twitter @RossMistry.

Customer Reviews

You would learn when it is best to upgrade and when it is best to migrate to SQL Server 2008.
S. Daruwala
You can use this book as a learning tool to pick up on technologies and methods you might not have such as Failover Clustering or the new Policy Based Management.
Grant Fritchey
I recommend this useful book to everyone; in particular those interested in learning SQL Server 2008 should start with this book.
Pinalkumar Dave

Most Helpful Customer Reviews

17 of 18 people found the following review helpful By Brent Ozar on February 25, 2009
Format: Paperback
Production database administrators have to know at least a little about a lot of things:
* How to install or upgrade SQL Servers
* How to build clusters
* How to plan for disaster recovery and high availability
* How to do performance tuning
* How to secure and protect databases

The production role revolves around management, not creation. Sure, they do need to know T-SQL and be able to debug problem code, but the majority of their day is making the trains run on time - not designing the seats inside the train cars.

Windows administrators who are forced into the SQL Server DBA role need this same type of information. They get handed a database server to manage, often with a database from a third party vendor like Citrix or Blackberry. They have to manage the server, make sure it performs as needed, and back it up safely - but they'll never touch a line of T-SQL code that runs on the server.

Ross Mistry and Hilary Cotter's book Microsoft SQL Server 2008 Management and Administration is a great companion for production DBAs and accidental DBAs. It covers this wide variety of topics in a good depth, and leaves topics like beginning T-SQL or how to write stored procedures out to other books.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback
Short Summary:
SQL SERVER 2008 is a trusted database platform that provides organizations a competitive edge by allowing them to obtain faster results and thus make improved business decisions. This book covers all the topics that can make Database Administrators efficient and successful.

Detail summary:

This information-rich book aims to enhance the experience of professionals working with SQL Server. It covers a wide array of topics and modules of the SQL Server 2008, for instance, database engine, Analysis Services, Integration Services, replication, Reporting Services, Notification Services, services broker, and full text search. The book provides elaborated guidance on management, administration, and monitoring. Besides, new features such as Policy-Based Management, Compressed Backup, and Fail-over Clustered are covered in depth. The book even has a few chapters dedicated to some of the newly introduced concepts including Powershell, Resource Governor, and Virtualization.

The latest version of SQL Server 2008 is a significant improvement on the previous version. People who have purchased the previous version know that it contains only 300 pages and does not provide comprehensive information. I had criticized the author Ross Mistry for the same. The author took my criticism positively and promised me that the next version of the book will be complete. I am extremely glad that the latest version lives up to my expectations! It is a complete book with over 850 pages and covers every topic related to SQL Server under the sun. So, there is no need to refer anything online. Not to forget that there is an online version this book available for free.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
8 of 9 people found the following review helpful By S. Daruwala on March 16, 2009
Format: Paperback
As a SQL Server expert, I have had the opportunity to read all of the new SQL Server 2008 books released to date. I must say the book that stood out the most was SQL Server 2008 Management and Administration.

I felt that this book did a deep dive on many topics that other books just briefly introduced. Specific chapters which stood out were failover clustering as it included step-by-steps starting from Windows Server 2008 failover clustering. I haven't seen this in any resource, book or even on SQL Server 2008 Books Online. The upgrade and migration chapter was solid. You would learn when it is best to upgrade and when it is best to migrate to SQL Server 2008. In addition, it included the steps to actually conduct a successful migration.

Ross Mistry and Hilary Cotter did a great job on covering new topics such as Policy Based Management, Resource Governor, Data Collector and much more. The book also included information on how to configure Operations Manager and the SQL Server 2008 Management Pack. I was very impressed with the technical knowledge the well known SQL Server MVPs put together on this title. 5 Stars!!!
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
17 of 22 people found the following review helpful By Robert J. Schwartz on June 1, 2009
Format: Paperback
Every chapter I read in this book raises more questions. This book is vague and incomplete in every respect. Not at the same level of excellence as SQL Server 2005 Unleashed or even the books online included with SQL 2008. This book leaves out a lot of important details for administrators planning a SQL 2008 deployment. The differences between Standard and Enterprise editions are outlined in a short, vague paragraph in the introductory chapter. From there on out the book refers to the Enterprise feature set without ever indicating that a given feature is only available in Enterprise. Policy Based Management? There is an embarrassment of a chapter which says click here then there to create a policy but not even a single word is said about the actual real world configuration options available via Policy Based Management. It's like explaining Moby Dick by telling you how to turn the pages of the book and never mentioning the whale. Surface Area Tool no longer exists and they don't explain how to perform equivalent the configuration using the new Policy tools. I was hoping for a resource to help me feel more confident about SQL 2008 but this isn't it.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Product Images from Customers

Most Recent Customer Reviews

Search
ARRAY(0xa2ae4270)

What Other Items Do Customers Buy After Viewing This Item?