Как SQL Server 2000 - лучший инструмент для разработки реляционных баз данных из всех, когда-либо выпущенных компанией Microsoft, так и эта книга - лучшее и самое полное издание `Руководства администратора баз данных Microsoft SQL Server`. По сравнению с предыдущими изданиями настоящее существенно улучшено и дополнено. Причем многие улучшения были предложены читателями предыдущих изданий книги, приславшими отзывы по электронной почте или высказавшимися в группах новостей. В конце многих глав есть специальный раздел, в котором приведены ответы на распространенные вопросы. Прочитав эту книгу, администратор базы данных SQL Server получит теоретические знания, узнает важные сведения (советы, приемы и предложения), разбросанные в море документации, а также познакомится с практическими советами из опыта профессионалов. В книге приведен приблизительный список задач администратора базы данных SQL Server и методы их решения, а также подробно описаны задачи, выполнение которых входит в повседневные обязанности. Книга рассчитана на пользователей высокой квалификации и администраторов баз данных.

SQL - материалы по языку SQL и серверам данных
Interbase
SQL server шаг за шагом
Грубер М. Понимание SQL
Кириллов В.В. Громов Г.Ю. Структуризированный язык запросов (SQL)

Актуально и для версии 8.1
Язык запросов практически не изменился.
Методические материалы для слушателей сертифицированного курса от фирмы 1С.

Цикл видео уроков Oracle и SQL, от Дмитрия Пушкашу. Вам расскажут о компонентах архитектуры, покажут и разберут на конкретных примерах серию наиважнейших функций и многое другое. Видео курс рассчитан, как на новичков так и на более опытных пользователей.

The expansion of Web-based applications is driving the demand for information about SQL. As the need for programmers to manage vast amounts of data continues to grow, so too will the need for programmers to understand SQL - a tool that will greatly simplify their applications. Because of this book's broad base of tips, it covers SQL for users at all levels of expertise. The tips start at a level for first-time users, and the following tips build from this material. This book also serves as a valuable reference to mySQL.

Joe Celko has looked deep into the code of SQL programmers and found a consistent and troubling pattern - a frightening lack of consistency between their individual encoding schemes and those of the industries in which they operate. This translates into a series of incompatible databases, each one an island unto itself that is unable to share information with others in an age of internationalization and business interdependence. Such incompatibility severely hinders information flow and the quality of company data.

This is not an ordinary SQL Server Book. SQL Server MVP Deep Dives brings together the world's most highly-regarded SQL Server experts to create a masterful collection of tips, techniques, and experience-driven best practices for SQL Server development and administration. These SQL Server MVPs-53 in all-each selected a topic of great interest to them, and in this unique book, they share their knowledge and passion with you.

SQL Server MVP Deep Dives is organized into five parts: Design and Architecture, Development, Administration, Performance Tuning and Optimization, and Business Intelligence. Within each part, you'll find a collection of brilliantly concise and focused chapters that take on key topics like mobile data strategies, Dynamic Management Views, or query performance. The range of subjects covered is comprehensive, from database design tips to data profiling strategies for BI.

Additionally, the authors of this book have generously donated 100% of their royalties to support War Child International. War Child International is a network of independent organizations, working across the world to help children affected by war. War Child was founded upon a fundamental goal: to advance the cause of peace through investing hope in the lives of children caught up in the horrors of war. War Child works in many different conflict areas around the world, helping hundreds of thousands of children every year. Visit www.warchild.org for more information.

Key coverage includes

*
Using SQL Server 2005 as a .NET runtime host: extending the server while enhancing security, reliability, and performance
* Writing procedures, functions, triggers, and types in .NET languages
* Exploiting enhancements to T-SQL for robust error-handling, efficient queries, and improved syntax
* Effectively using the XML data type and XML queries
* Implementing native SQL Server 2005 Web Services
* Writing efficient, robust clients for SQL Server 2005 using ADO.NET, classic ADO, and other APIs
* Taking full advantage of user-defined types (UDTs), query notifications, promotable transactions, and multiple active result sets (MARS)
* Using SQL Management Objects (SMO), SQL Service Broker, and SQL Server Notification Services to build integrated applications

Execution plans show you what's going on behind the scenes in SQL Server. They can provide you with a wealth of information on how your queries are being executed by SQL Server, including which indexes are getting used and where no indexes are being used at all; how the data is being retrieved, and joined, from the tables defined in your query; how aggregations in GROUP BY queries are put together and the anticipated load, and the estimated cost, that all these operations place upon the system. All this information makes the execution plan a vitally important tool in the tool belt of database administrator, database developers, report writers, developers, and pretty much anyone who writes TSQL to access data in a SQL Server database. The goal with this book was to gather as much useful information on execution plans as possible into a single location, and to organize it in such as way that it provided a clear route through the subject, right from the basics of capturing plans, through their interpretation, and then onto how to use them to understand how you might optimize your SQL queries, improve your indexing strategy, spot some common performance issues, and more.

This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performance—but also branching into security, national language, and other issues—the book helps you deliver the most value for your company’s investment in Oracle Database technologies. You’ll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than letting it manage you.

* Rigorous and peer-reviewed content from the OakTable Network of Oracle scientists
* Strong emphasis upon managing for high performance
* Lays a strong foundation for advancing in the DBA profession