SQL Server 2005 is the largest leap forward for SQL Server since its inception. With this update comes new features that will challenge even the most experienced SQL Server DBAs. Written by a team of some of the best SQL Server experts in the industry, this comprehensive tutorial shows you how to navigate the vastly changed landscape of the SQL Server administration. 
Drawing on their own first-hand experiences to offer you best practices, unique tips and tricks, and useful workarounds, the authors help you handle even the most difficult SQL Server 2005 administration issues, including blocking and locking. You'll learn how to fine-tune queries you've already written, automate redundant monitoring and maintenance tasks, and use hidden tools so that you can quickly get over the learning curve of how to configure and administer SQL Server 2005. What you will learn from this book <ul>
<li>How to use some of the more advanced concepts of installation</li> <li>Techniques for properly administering development features such as SQL CLR</li> <li>Ways to secure your SQL Server from common threats</li> <li>How to choose the right hardware configuration</li> <li>Best practices for backing up and recovering your database</li> <li>Step-by-step guidelines for clustering your SQL Server</li> </ul>
Who this book is for This book is for experienced developers and database administrators who plan to administer or are already administering an SQL Server 2005 system and its business intelligence features. Wrox Professional guides are planned and written by working technologists to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.

Professional SQL Server 2005 Administration

Computers & Technology

Knight, Brian

Snyder, Wayne

McGehee, Brad

Wort, Steven

Ji, Haidong

Salvatore, Joe

Patel, Ketan

LoForte, Ross

Armand, Jean-Claude

Databases & Big Data

Wrox

Written by a team of expert SQL users, this comprehensive resource approaches performance tuning from a new perspective by showing you a methodical scientific approach to diagnose performance problems. The book first walks you through how to discover bottlenecks when something is wrong and you’ll then learn how to identify and remove the problems that are causing poor performance. You’ll discover preventive measures you can take to try to avoid a performance problem entirely and you’ll learn how to achieve better performance.

Professional SQL Server 2005 Performance Tuning

Bolton, Christian

Langford, Justin

Cape, Michael

Jin, Joshua J.

Hinson, Douglas

Mestemaker, Paul A.

Sen, Arindam

Programming Languages

Professional Microsoft SQL Server 2008 Administration

SQL Server 2008 represents a sizable jump forward in scalability, performance, and usability for the DBA, developer, and business intelligence (BI) developer. It is no longer unheard of to have 20-terabyte databases running on a SQL Server. SQL Server administration used to just be the job of a database administrator (DBA), but as SQL Server proliferates throughout smaller companies, many developers have begun to act as administrators as well. Additionally, some of the new features in SQL Server are more developer-centric, and poor configuration of these features can result in poor performance. SQL Server now enables you to manage the policies on hundreds of SQL Servers in your environment as if you were managing a single instance. We've provided a comprehensive, tutorial-based book to get you over the learning curve of how to configure and administer SQL Server 2008. 
Whether you're an administrator or developer using SQL Server, you can't avoid wearing a DBA hat at some point. Developers often have SQL Server on their own workstations and must provide guidance to the administrator about how they'd like the production configured. Oftentimes, they're responsible for creating the database tables and indexes. Administrators or DBAs support the production servers and often inherit the database from the developer. This book is intended for developers, DBAs, and casual users who hope to administer or may already be administering a SQL Server 2008 system and its business intelligence features, such as Integration Services. This book is a professional book, meaning the authors assume that you know the basics about how to query a SQL Server and have some rudimentary concepts of SQL Server already. For example, this book does not show you how to create a database or walk you through the installation of SQL Server using the wizard. Instead, the author of the installation chapter may provide insight into how to use some of the more advanced concepts of the installation. Although this book does not cover how to query a SQL Server database, it does cover how to tune the queries you've already written.

Networking & Cloud Computing

A hands-on resource for SQL Server 2008 troubleshooting methods and toolsSQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book provides in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system.
You'll get a thorough look at the SQL Server database architecture and internals as well as Windows OS internals so that you can approach troubleshooting with a solid grasp of the total processing environment. Armed with this comprehensive understanding, readers will then learn how to use a suite of tools for troubleshooting performance problems whether they originate on the database server or operating system side.
Topics Covered:
<ul>
<li>SQL Server Architecture</li>
<li>Understanding Memory</li>
<li>SQL Server Waits and Extended Events</li>
<li>Working with Storage</li>
<li>CPU and Query Processing</li>
<li>Locking and Latches</li>
<li>Knowing Tempdb</li>
<li>Defining Your Approach To Troubleshooting</li>
<li>Viewing Server Performance with PerfMon and the PAL Tool</li>
<li>Tracing SQL Server with SQL Trace and Profiler</li>
<li>Consolidating Data Collection with SQLDiag and the PerfStats Script</li>
<li>Introducing RML Utilities for Stress Testing and Trace File Analysis</li>
<li>Bringing It All Together with SQL Nexus</li>
<li>Using Management Studio Reports and the Performance Dashboard</li>
<li>Using SQL Server Management Data Warehouse</li>
<li>Shortcuts to Efficient Data Collection and Quick Analysis</li>
</ul>
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Professional SQL Server 2008 Internals and Troubleshooting

Rowland-Jones, James

Kehayias, Jonathan

Ozar, Brent

Gross, Cindy

An essential how-to guide for experienced DBAs on the most significant product release since 2005!Microsoft SQL Server 2012 will have major changes throughout the SQL Server and will impact how DBAs administer the database. With this book, a team of well-known SQL Server experts introduces the many new features of the most recent version of SQL Server and deciphers how these changes will affect the methods that administrators have been using for years. Loaded with unique tips, tricks, and workarounds for handling the most difficult SQL Server admin issues, this how-to guide deciphers topics such as performance tuning, backup and recovery, scaling and replication, clustering, and security.
<ul>
<li>Serves as a must-have how-to guide on the new features of the 2012 release of Microsoft SQL Server </li>
<li>Walks you through ways to manage and monitor SQL Server and automate administration </li>
<li>Guides you through SQL Azure for cloud computing, data replication, and data warehouse performance improvements </li>
<li>Addresses client-connectivity enhancements, new features that ensure high availability of mission-critical applications, and tighter integration with Excel and SharePoint for data analysis and reporting </li>
<li>Highlights major changes to the suite of SQL Server BI tools, including integration, reporting, and analysis services </li>
<li>Includes real-world case examples and best practices from Microsoft insiders </li>
</ul>
If you're a database administrator eager to get started with the newest version of SQL Server, then this book is essential reading.

Professional Microsoft SQL Server 2012 Administration

Jorgensen, Adam

Learn to take advantage of the opportunities offered by SQL Server 2014 Microsoft's SQL Server 2014 update means big changes for database administrators, and you need to get up to speed quickly because your methods, workflow, and favorite techniques will be different from here on out. The update's enhanced support of large-scale enterprise databases and significant price advantage mean that SQL Server 2014 will become even more widely adopted across the industry. The update includes new backup and recovery tools, new AlwaysOn features, and enhanced cloud capabilities. In-memory OLTP, Buffer Pool Extensions for SSDs, and a new Cardinality Estimator can improve functionality and smooth out the workflow, but only if you understand their full capabilities. Professional Microsoft SQL Server 2014 is your comprehensive guide to working with the new environment. Authors Adam Jorgensen, Bradley Ball, Ross LoForte, Steven Wort, and Brian Knight are the dream team of the SQL Server community, and they put their expertise to work guiding you through the changes. <ul>
<li>Improve oversight with better management and monitoring</li> <li>Protect your work with enhanced security features</li> <li>Upgrade performance tuning, scaling, replication, and clustering</li> <li>Learn new options for backup and recovery</li> </ul>
Professional Microsoft SQL Server 2014 includes a companion website with sample code and efficient automation utilities, plus a host of tips, tricks, and workarounds that will make your job as a DBA or database architect much easier. Stop getting frustrated with administrative issues and start taking control. Professional Microsoft SQL Server 2014 is your roadmap to mastering the update and creating solutions that work.

Professional Microsoft SQL Server 2014 Administration

Ball, Bradley

See the best price to sell, buy, or rent books by Wort, Steven. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Wort, Steven