Скачать книги бесплатно

"A great resource to help you unlock the hidden gems in SQL Server Reporting Services."
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services

With Microsoft SQL Server 2005 you can structure and store terabytes of data-but how do you make sense of that much information? Reporting Services transforms raw data into meaningful reports and puts your valuable information to work.

SQL Server 2005 Reporting Services in Action shows you how to build effective Windows and Web-based reporting solutions using SQL Server 2005. Using this example-driven book, you'll build Reporting Services-centric solutions, including report forecasting, RSS feeds, ASP.NET web controls for server-side report generation, extending Reporting Services to report on ADO.NET datasets, delivering reports to Web services, authenticating users, performance testing, and capacity planning.

You'll quickly move beyond canned reports and put the Report Designer through its paces. The book will show you how to add interactive features to your tabular reports and how to improve performance by using external images without taking up valuable database real estate.

When you have large systems, efficiency is key to productivity. Author Bret Updegraff shows you how to avoid doing the same tasks twice. You'll see a nifty sales forecast that uses embedded code to create reusable utility functions that you can call from multiple places your reports. As well, you'll find fundamentals like employing XSLT to create XML reports and advanced techniques such as accessing custom code in an external .NET assembly.

Reporting Services 2005 lets you give users greater control over their reporting needs. SQL Server 2005 Reporting Services in Action will help you provide safe, user-friendly reporting options to your users and free up your time for more important tasks. This book shows you how to set up ad hoc reporting through Report Builder so business users can get the information you need from the database without your help! You won't stop with the basics, though. You'll also learn how to apply advanced filters and security practices to protect your data from unwelcome or misguided queries.

Of course, this new edition is thoroughly updated to include coverage of all the new features introduced with SQL Server 2005. You'll see:

# Direct Client Printing: Send a report directly to a printer without having to export to printable format first
# End User Sort: Let the end user to re-sort data within the report
# Multi Valued Parameters: Use multiple values for parameters
# Custom Report Items: Build and embed custom server controls

You'll also work with the improved Report Designer, Report Builder, and Analysis Services Query Builder. You'll learn about SharePoint WebParts and the Report Viewer Controls for WinForms and ASP.NET, as well.

This book reveals the power of the SQL Server 2005 tools to database management system professionals, enabling you to maximize productivity. The authors of the book have been working on the SQL Server 2005 team since its inception, they share the philosophy behind the design of the tools, and they are familiar with insider tips and tricks.

The SQL Server 2005 family of products consists of Database Engine, Analysis Services, Reporting Services, Integration Services, Notification Services, and SQL Server Mobile Edition (SQL Server Everywhere Edition). This book describes the core functionality of all the SQL Server 2005 tools, and closely examines the Database Engine tools. The book provides solutions for installation, upgrade, configuration, schema design, management, authoring, development, optimization, deployment, operation, and troubleshooting. It covers the Installation Wizard, Upgrade Advisor, SQL Server Configuration Manager, SQL Server Management Studio, Database Tuning Advisor, SQLCMD, Database Mail, SQL Server Agent, and SQL Server Profiler. It also touches on technologies that these tools are built upon, such as SQL Server Management Objects (SMO), the Windows Management Instrumentation (WMI) Provider, and ADO.NET.

The book describes individual features and how they work together to create end-to-end scenarios. For the beginning user, we have screenshots and code samples. We provide examples with code snippets where applicable. When we introduce particular aspects of tool behavior or scenarios, we start first by describing them and relating them to other previously described tasks. Screen shots show how these things look inside the tools. For the more experienced users, we provide tips and insight. In addition, we provide code snippets to illustrate how particularly interesting functionalities can be implemented with underlying APIs.

In summary, the book will provide:

* Hundreds of time-saving solutions
* Tips, tricks, and workarounds
* Solutions for working smarter
* A vehicle through which you can expand your existing knowledge of SQL Server tools

The book is targeted at both new and experienced database professionals. New professionals who have never used the SQL Server tools will learn how to efficiently use each tool to perform specific tasks. More experienced database professionals can update their existing knowledge of the tools, learn about new features, and learn tips and tricks of the SQL Server 2005 toolset.

The purpose of this book is not to introduce you to the basic concepts of databases. We assume that you have been working with databases for at least one year. This book will show you how the tools can be used to maximize productivity while performing common SQL Server 2005 tasks. After reading this book you will be very comfortable using the tools for day-to-day tasks.

The book is organized by SQL Server tools and scenarios. Each chapter presents a tool or set of tools and also includes a number of relevant scenarios that illustrate the use of the tools. If you are interested in specific tools or scenarios, you can move straight to those chapters, or you can read through the book in a linear fashion for a more complete understanding of all the tools and features.

Your hands-on guide to learning Microsoft SQL Server Analysis Services, Microsofts customizable analysis solution for business data modeling and interpretation. Analysis Services is a powerful tool for business intelligence, so understanding the essentialshow to create a cube, as well as how to deploy, customize, and extend the basic calculationsis critical to harnessing the full benefits of SQL Server. This step-by-step tutorial shows you how to get started, how to build scalable analytical applications, and how to use and administer advanced features. Interactivity features (enhanced in SQL Server 2005), data translation, and security are also covered in detail. With Step by Step, you work at your own pace through hands-on, learn-by-doing exercises. Whether youre a beginning programmer or new to this version of the technology, youll understand the fundamental techniques for using Analysis Services.

In this book, two of Microsoft's leading consultants illustrate how to use SQL Server 2005 Business Intelligence (BI) technologies to solve real-world problems in markets ranging from retail and finance to healthcare. Drawing on extensive personal experience with Microsoft's strategic customers, John C. Hancock and Roger Toren offer unprecedented insight into BI systems design and step-by-step best practices for implementation, deployment, and management.
Hancock and Toren introduce practical BI concepts and terminology and provide a concise primer on the Microsoft BI platform. Next, they turn to the heart of the bookconstructing solutions. Each chapter-length case study begins with the customer's business goals, and then guides you through detailed data modeling. The case studies show how to avoid the pitfalls that derail many BI projects. You'll translate each model into a working system and learn how to deploy it into production, maintenance, and efficient operation.
Whether you're a decision-maker, architect, developer, or DBA, this book brings together all the knowledge you'll need to derive maximum business value from any BI project.
• Leverage SQL Server 2005 databases, Integration Services, Analysis Services, and Reporting Services
• Build data warehouses and extend them to support very large databases
• Design effective Analysis Services databases
• Ensure the superior data quality your BI system needs
• Construct advanced enterprise scorecard applications
• Use data mining to segment customers, cross-sell, and increase the value of each transaction
• Design real-time BI applications
• Get hands-on practice with SQL Server 2005's BI toolset

Your in-depth guide to using the new Microsoft(r) data mining standard to solve today's business problems

Concealed inside your data warehouse and data marts is a wealth of valuable information just waiting to be discovered. All you need are the right tools to extract that information and put it to use. Serving as your expert guide, this book shows you how to create and implement data mining applications that will find the hidden patterns from your historical datasets. The authors explore the core concepts of data mining as well as the latest trends. They then reveal the best practices in the field, utilizing the innovative features of SQL Server 2005 so that you can begin building your own successful data mining projects.
You'll learn:
* The principal concepts of data mining
* How to work with the data mining algorithms included in SQL Server data mining
* How to use DMX-the data mining query language
* The XML for Analysis API
* The architecture of the SQL Server 2005 data mining component
* How to extend the SQL Server 2005 data mining platform by plugging in your own algorithms
* How to implement a data mining project using SQL Server Integration Services
* How to mine an OLAP cube
* How to build an online retail site with cross-selling features
* How to access SQL Server 2005 data mining features programmatically

* Serving as both a tutorial and a reference guide to the MDX (Multidimensional Expressions) query language, this book shows data warehouse developers what they need to know to build effective multidimensional data warehouses
* After a brief overview of the MDX language and a look at how it is used to access data in sophisticated, multidimensional databases and data warehousing, the authors move directly to providing practical examples of MDX in use
* New material covers changes in the MDX language itself as well as major changes in its implementation with the latest software releases of Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase
* Also covers more advanced techniques, like aggregation, query templates, and MDX optimization, and shows users what they need to know to access and analyze data to make better business decisions

Эта книга - практическое руководство по разработке приложений на основе Microsoft SQL Server 2005. Здесь подробно рассматривается работа с сервером баз данных, включая проектирование базы данных, программирование представлений, хранимых процедур, триггеров и функций на языке T-SQL, вопросы обеспечения безопасности, а также интеграция SQL Server и .NET CLR; обсуждаются практические вопросы разработки приложений баз данных и возможности расширения функциональности при помощи таких технологий, как конечные точки HTTP, SQL Server Service Broker, SQL Server Notification Services, SQL Server Express Edition и SQL Server Everywhere Edition; описываются службы SQL Server Integration Services, Analysis Services и Reporting Services.
Книга адресована разработчикам .NET-приложений баз данных и всем, кто хочет освоить возможности программирования Microsoft SQL Server 2005.

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

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

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