Get the end-to-end instruction you need to design, develop, and deploy more effective data integration, reporting, and analysis solutions using SQL Server 2008—whether you’re new to business intelligence (BI) programming or a seasoned pro. With real-world examples and insights from an expert team, you’ll master the...
Microsoft SQL Server 2008 introduces new geography and geometry spatial datatypes that enable the storage of structured data describing the shape and position of objects in space. This is an interesting and exciting new feature, with many potentially useful applications.
Книга подробно рассказывает о Microsoft's SQL Server Modeling и содержит информацию, необходимую для успешного создания и внедрения моделирования рабочих процессов.
Server bottlenecks and failures are a fact of life in any database deployment, but they don’t have to bring everything to a halt. MySQL has several features that can help you protect your system from outages, whether it’s running on hardware, virtual machines, or in the cloud. MySQL High Availability explains how to...
Ever wished for a tool that can turn enterprise data into meaningful reports that could be shared easily with co-workers, customers, and partners?
Microsoft SQL Server 2008 Reporting Services is the “magic wand” you need to unleash the hidden power of data. The author, who has worked closely with the...
Эта книга предназначена для разработчиков и администраторов баз данных и хранилищ данных, заинтересованных в эффективном использовании средств бизнес-анализа в SQL Server 2005. Написанная сотрудниками отдела разработки Analysis Services компании Microsoft,
Each chapter in this book helps you identify, explain, and correct a unique and dangerous antipattern. The four parts of the book group the antipatterns in terms of logical database design, physical database design, queries, and application development.
Every business has a reams of business data locked away in databases, business systems, and spreadsheets. While you may be able to build some reports by pulling a few of these repositories together, actually performing any kind of analysis on the data that runs your business can range from problematic to impossible....
Pro SQL Server 2008 Policy-Based Management is critical for database administrators seeking in-depth knowledge on administering servers using the new policy-based management features introduced in SQL Server 2008. This book will cover everything from a basic introduction to policy-based management to creating your own...
Когда поднимается вопрос рефакторинга кода, специалист может быть уверен, что либо возникла серьезная проблема, либо предполагается, что она проявится в ближайшее время. Как правило, при этом известно, что следует улучшить в плане функциональности, но прежде необходимо понять природу проблемы.
В книге ...
A lucid guide to SQL which provides the tools to put practical instruction to work immediately!
SQL Clearly Explained is one of those rare books that delivers 100 percent what its title promises. If you need to use SQL on the job, and who doesn't, then this book should be on your desk.
This book...
The book is divided into five parts: Getting Starated with MySQL and Relational Databases; Understanding SQL Through MySQL; MySQL Administration; MySQL Developer Guide; and Advanced and Specialized MySQL Topics.
This Bible covers both beginning-level and advanced topics. Topics covered include: introduction...
Microsoft® SQL Server® 2008 Administrator’s Pocket Consultant, 2nd Edition is the ideal concise, immediate reference you’ll want with you at all times as you deal with Microsoft® SQL Server® 2008 and SQL Server® 2008 R2 administration. Whether you handle administration for 50 users or 5000, this hands-on, fast answers...
Изначально, SQL был основным способом работы пользователя с базой данных и представлял собой небольшую совокупность команд (операторов) допускающих создание таблиц, добавление в таблицы новых записей, извлечение записей из таблиц (в соответствии с заданным условием), удаление записей и изменение структур таблиц. В...
Learn to design more effective and sophisticated business reports
While most users of SQL Server Reporting Services are now comfortable designing and building simple reports, business today demands increasingly complex reporting. In this book, top Reporting Services design experts have contributed...
