Professional SQL Server 2005 Administration
Author: Brad McGehe
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
• How to use some of the more advanced concepts of installation
• Techniques for properly administering development features such as SQL CLR
• Ways to secure your SQL Server from common threats
• How to choose the right hardware configuration
• Best practices for backing up and recovering your database
• Step-by-step guidelines for clustering your SQL Server
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 thereal-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.
New interesting textbook: How to Avoid Falling or So Youre Having Prostate Surgery
The Definitive Guide To Sqlite
Author: Michael Owens
The Definitive Guide to SQLite is the perfect book about SQLite. It covers everything needed to start working with SQLite including installation, using the SQLite shell, and programming with SQLite using six different language extensions.
— Joe Topjian, Adminspotting
Traditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So for many people, the solution resides in SQLite, an open source embeddable database with an amazingly small footprint (less than 250 kilobytes). SQLite packs a powerful array of features and can handle databases as large as 2 terabytes. It offers a flexible set of datatypes and the ability to perform transactions, and it is supported by languages like C, PHP, Perl, and Python. And because SQLite's databases are completely file based, privileges are granted at the operating system level, allowing for easy and fast user management.
The Definitive Guide to SQLite is the first book to devote complete coverage to the latest version of this powerful database. It offers you a thorough overview of SQLite capabilities and APIs, while remaining cognizant of newcomers who may be making their first foray into a database environment with SQLite. This book serves as both a first-time tutorial and future reference guide.
- You'll learn about SQLite extensions available for C, Java, Perl, PHP, Python, Ruby, and Tcl.
- The book thoroughly covers SQLite internals to help you take full advantage of its features while minimally impacting resource consumption.
- Author Mike Owens is the original creator of Pysqlite, the popular Python extension for SQLite.
Table of Contents:
| Ch. 1 | Introducing SQLite | 1 |
| Ch. 2 | Getting started | 17 |
| Ch. 3 | The relational model | 47 |
| Ch. 4 | SQL | 73 |
| Ch. 5 | Design and concepts | 171 |
| Ch. 6 | The core C API | 205 |
| Ch. 7 | The extension C API | 255 |
| Ch. 8 | Language extensions | 301 |
| Ch. 9 | SQLite internals | 341 |
No comments:
Post a Comment