|
|
|
| How to Become an Exceptional DBA | |
| This free ebook by Brad McGehee is a career guide that will show you, step-by-step, specifically what you can do to differentiate yourself from the crowd, so that you can be an Exceptional DBA. While this book focuses on how to become an Exceptional SQL Server DBA, the advice applies to any DBA, no matter what database software they use. |  |
| SQL Server DBA Best Practices | |
| SQL Server DBA Best Practices by Brad McGehee provides many best practices covering the following areas: General DBA Best Practices, High Availability Best Practices, Performance Tuning Best Practices, Application Design and Coding Best Practices, SQL Server Component Best Practices. |  |
| Dissecting SQL Server Execution Plans | |
| Free eBook Dissecting SQL Server Execution Plans: Writing High Performance SQL Code By Grant Fritchey. Why is this query running slow? Is my index getting used? Why does this query run faster than this query? Well, have you even looked at the execution plan?. Over 200 pages of SQL code performance magic. Broaden your optimization and tuning skills. 18 years of professional experience distilled. |  |
| Optimizing HP Servers with Microsoft SQL Server 2008 | |
| When implementing a hardware consolidation project, one major step involves consolidating corporate data, which is mostly managed by multiple database engines. This activity requires high-performance servers with multiple CPUs and addressable memory capacity. The objective of this white paper is to show how Microsoft SQL Server 2008, specifically on 64-bit platforms, together with the resources and technologies available on HP servers offer unique solutions for consolidating corporate data. (For visitors from USA only.) |  |
| Concurrency Control and Recovery in Database Systems | |
| This book is about techniques for concurrency control and recovery. It covers techniques for centralized and distributed computer systems, and for single copy, multiversion, and replicated databases. These techniques were developed by researchers and system designers principally interested in transaction processing systems and database systems. Such systems must process a relatively high voIume of short transactions for data processing. Example applications include electronic funds transfer, airline reservation, and order processing. | |
| Brad's Sure Guide to SQL Server 2008 | |
| Free eBook Brad's Sure Guide to SQL Server 2008: The Top Ten New Features for DBAs by Brad McGehee. SQL Server 2008 has hundreds of new features and improvements for Production DBAs, Developer DBAs, and Business Intelligence specialists. Some of the changes are significant, while others are minor, but still important. Topics covered: Management Studio Improvements, Policy-Based Management, Data Compression, Resource Governor, Performance Data Collector, Transparent Data Encryption, SQL Server Audit, New Data Types, Extended Events, Change Data Capture. |  |
|
|
