• Title: SQL Server Hardware Choices Made Easy
• Author(s) Glenn Berry
• Publisher: Redgate Books
• Paperback: 340 pages
• eBook: PDF
• Language: English
• ISBN-10: 1906434638
• ISBN-13: 978-1906434632
• Share This:  

Book Description

This book is designed to provide the fundamental knowledge and resources you need to make intelligent choices about optimal installation and configuration of SQL Server hardware, operating system and the SQL Server RDBMS. With what you learn in this book, you'll be able to ensure that your SQL Server instances can handle gracefully the CPU, memory and IO workload generated by your applications, and that the operating system and SQL Server itself are installed, patched, and configured for maximum performance and reliability.

Relational databases place heavy demands on their underlying hardware and many of these databases are mission-critical resources for multiple applications, where performance bottlenecks are immediately noticeable and often very costly to the business. Despite this, many database administrators are not very knowledgeable about server hardware. Many medium-to-large companies have completely separate departments that are responsible for hardware selection, configuration, and maintenance, and the DBA with no knowledge of hardware is often completely at their mercy. Likewise, many DBAs are also unaware of the performance implications of the various options and configurations for SQL Server, and the Operating System on which it is installed.

• Glenn Berry works as a Database Architect at NewsGator Technologies in Denver, CO. He is a SQL Server MVP, and has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves he likes to take tests. He is also an Adjunct Faculty member at University College, University of Denver, where he has been teaching since 2000, and he has completed the Master Teacher Program.

• Amazon

• Miscrosoft SQL Server
• Database, Data Warehouse and Data Management
• Data Management White Papers
• Microsoft Windows and .NET

• SQL Server Hardware Choices Made Easy (Glenn Berry)
• The Mirror Site (1) - PDF
• The Mirror Site (2) - PDF

• Inside the SQL Server Query Optimizer (Benjamin Nevarez)

  The author's insight will leave you with an excellent foundation in the practicalities of the Query Optimizer, and everything you need to know to start tuning your queries to perfection.

• Transact-SQL: The Building Blocks to SQL Server Programming

  This book will cover different aspects of the Transact SQL (TSQL) language. It takes the readers step by step through the TSQL language, one concept at a time. Each topic covers a particular aspect of TSQL with discussion and examples.

• SQL Server Execution Plans, 3rd Edition (Grant Fritchey)

  This book is the only in-depth look at how to improve your SQL query performance through careful design of execution plans, leads you right from the basics of capturing plans to diagnose the most common causes of poor query performance, and so optimize your SQL queries, and improve your indexing strategy.

• SQL Server Concurrency: Locking, Blocking and Row Versioning

  This book is for anyone using SQL Server as a programmer, an administrator, or even a user, who wants to understand how SQL Server manages multiple sessions, and what causes excessive blocking.

• SQL Server Backup and Restore (Shawn McGehee)

  This book shows you how to set-up a reliable, tested, SQL Server backup and restore plan. Get tips for recovering your data with minimum downtime. Learn how to minimize data loss when disaster strikes.

• SQL Server Team-based Development

  How to use of mixture of home-grown scripts, native SQL Server tools, and tools from the Red Gate SQL Toolbelt, to successfully develop database applications in a team environment, and make database development as "normal" development.

• Performance Tuning with SQL Server Dynamic Management Views

  This book investigates all of the DMVs that are most frequently useful to the DBA in investigating query execution, index usage, session and transaction activity, disk IO, and how SQL Server is using or abusing the operating system.

• Learn T-SQL Querying (Pedro Lopes, et al)

  The book will get you started with query processing fundamentals to help you write powerful, performant Transact-SQL (T-SQL) queries. You will then focus on query execution plans and learn how to leverage them for troubleshooting.

• 45 Database Performance Tips for Developers (Phil Factor, et al)

  Speed up your development with ORMs and discover the gotchas' involved. Learn the best practices for efficiently indexing tables. Get expert advice on writing well-formed SQL queries. Topics covered: ORM Tips, T-SQL Tips, Index Tips, Database Design Tips.

• SQL Server Integration Services (SSIS) Succinctly (Rui Machado)

  With this book, you will learn how to build and deploy your own ETL solution in a drag-and-drop development environment by using SSIS packages, control flows, data flows, tasks, and more.