Microsoft SQL Server 2008 Management and Administration at Dominant Systems Book Store

If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft’s flagship database platform. SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production environments to offer step-by-step solutions and powerful tips you won’t find anywhere else. Every chapter begins with a section identifying SQL Server 2008’s most significant new improvements, and concludes with a convenient summary of best practices. Each chapter also outlines the benefits of leveraging Windows Server 2008.

Understand how to:

Master DBA tips, tricks, and best practices proven in actual enterprise environments
Install, upgrade or transition to SQL Server 2008.
Harden and Secure an implementation.
Encrypt SQL Server from an end-to-end perspective.
Implement high availability–and leverage SQL Server 2008’s major improvements to failover clustering and database mirroring
Save time with SQL Server 2008’s new policy-based management tools
Performance tune and troubleshoot a SQL Server 2008 environment.
Optimize application performance and manage workloads with the powerful new Resource Governor
Implement Performance Studio, maintenance plans, Transparent Data Encryption and much more…

Bonus Content:

The book is based on Windows Server 2008
Step by step instructions of how to implement a failover cluster on Windows Server 2008
SQL Server PoweShell Administration Tasks
Consolidate and virtualize SQL Server with Hyper-V
Step by step instructions on how to install Hyper-V
Proactively Monitor SQL Server with Operations Manager
Install Windows Server 2008 certificates to encrypt SQL Server data

Contributing Writers include:

Hilary Cotter — SQL Server MVP

John Welch — SQL Server MVP

Marco Shaw — PowerShell MVP

Maciej Pilecki — SQL Server MVP

Shirmattie Seenarine — Technical Writer

Customer Reviews & Comments
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.

Back To Top