Maximize the Business Intelligence Tools in Microsoft SQL Server 2008

Manage, analyze, and distribute enterprise data with help from this expert resource. Delivering Business Intelligence with Microsoft SQL Server 2008 covers the entire BI lifecycle and explains how to build robust data integration, reporting, and analysis solutions. Real-world examples illustrate all of the powerful BI capabilities of SQL Server 2008. This is your one-stop guide for transforming disparate data into actionable insight for users throughout your organization.

• Understand the goals and benefits of business intelligence
• Design and create relational data marts and OLAP cubes
• Manage Analysis Services databases using BI Development Studio
• Cleanse data and populate data marts with SQL Server Integration Services
• Take advantage of the flexibility of the Unified Dimensional Model
• Manipulate and analyze data using MDX scripts and queries
• Use data mining to identify data patterns, correlations, and clustering
• Develop and distribute interactive reports with SQL Server 2008 Reporting Services
• Integrate business intelligence into enterprise applications using ADOMD.NET and the Report Viewer Control

• The new edition of the successful previous version is 25 percent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS)
• Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than ever
• Case studies and tutorial examples acquired over the three years since the previous edition will contribute to helping illustrate advanced concepts and techniques
• New chapters include coverage of data warehousing using SSIS, new methods for managing the SSIS platform, and improved techniques for ETL operations

Unless you are working at a very advanced level, this is the only SQL book you will ever need. The authors have taken the mystery out of complex queries and explained principles and techniques with such clarity that a “Mere Mortal” will indeed be empowered to perform the superhuman. Do not walk past this book!
–Graham Mandeno, Database Consultant

SQL Queries for Mere Mortals provides a step-by-step, easy-to-read introduction to writing SQL queries. It includes hundreds of examples with detailed explanations. This book provides the tools you need to understand, modify, and create SQL queries
–Keith W. Hare, Convenor, ISO/IEC JTC1 SC32 WG3–the International SQL Standards Committee

I learned SQL primarily from the first edition of this book, and I am pleased to see a second edition of this book so that others can continue to benefit from its organized presentation of the language. Starting from how to design your tables so that SQL can be effective (a common problem for database beginners), and then continuing through the various aspects of SQL construction and capabilities, the reader can become a moderate expert upon completing the book and its samples. Learning how to convert a question in English into a meaningful SQL statement will greatly facilitate your mastery of the language. Numerous examples from real life will help you visualize how to use SQL to answer the questions about the data in your database. Just one of the “watch out for this trap” items will save you more than the cost of the book when you avoid that problem when writing your queries. I highly recommend this book if you want to tap the full potential of your database.
–Kenneth D. Snell, Ph.D., Database Designer/Programmer

I don’t think they do this in public schools any more, and it is a shame, but do you remember in the seventh and eighth grades when you learned to diagram a sentence? Those of you who do may no longer remember how you did it, but all of you do write better sentences because of it. John Viescas and Mike Hernandez must have remembered because they take everyday English queries and literally translate them into SQL. This is an important book for all database designers. It takes the complexity of mathematical Set Theory and of First Order Predicate Logic, as outlined in E. F. Codd’s original treatise on relational database design, and makes it easy for anyone to understand. If you want an elementary- through intermediate-level course on SQL, this is the one book that is a requirement, no matter how many others you buy.
–Arvin Meyer, MCP, MVP

Even in this day of wizards and code generators, successful database developers still require a sound knowledge of Structured Query Language (SQL, the standard language for communicating with most database systems). In this book, John and Mike do a marvelous job of making what’s usually a dry and difficult subject come alive, presenting the material with humor in a logical manner, with plenty of relevant examples. I would say that this book should feature prominently in the collection on the bookshelf of all serious developers, except that I’m sure it’ll get so much use that it won’t spend much time on the shelf!
– Doug Steele, Microsoft Access Developer and author

Over the last several decades, SQL has evolved from a language known only to computer specialists to a widely used international standard of the computer industry. The number of new applications deployed each year using SQL now totals in the millions. If you are accessing corporate information from the Internet or from an internal network, you are probably using SQL. This new edition of SQL Queries for Mere Mortals helps new users learn the foundations of SQL queries, and is an essential reference guide for intermediate and advanced users.

The accompanying CD contains five sample databases used for the example queries throughout the book in four different formats: Microsoft SQL Server 2000 and later, Microsoft Access 2000 and later, MySQL version 5.0 and later, and SQL scripts that can be used with most other implementations of the language.

Create and deliver data-rich reports across the enterprise using this complete server-based reporting solution. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. The book explains how to maximize all of the powerful features, including the new Tablix data format, as well as enhanced performance, scalability, and visualization capabilities.

• Install, configure, and customize SQL Server 2008 Reporting Services
• Create SELECT queries to extract data
• Generate reports from the Report Wizard and from scratch
• Add charts, images, and gauges
• Build reusable report templates
• Use the new Tablix data format to create reports with any structure
• Export reports to Word, Excel, PDF, HTML, XML, and other formats
• Enable end-user access to reports via the Report Server and its Report Manager web interface

If you need to deploy, manage, or secure Microsoft SQL Server 2008, this is the complete, fast-paced, task-based reference you’ve been searching for. Authored by a world-class expert on SQL Server in the enterprise, this book goes far beyond the basics, taking on the complex tasks that DBAs need to make the most of Microsoft’s flagship database platform. SQL Server MVP, Ross Mistry presents proven techniques for SQL Server 2008 installation, upgrades, backup/restore, data transfer, indexing, high availability, security, and much more. He draws on extensive testing in high-profile production environments to offer step-by-step solutions and powerful tips you won’t find anywhere else. Every chapter begins with a section identifying SQL Server 2008’s most significant new improvements, and concludes with a convenient summary of best practices. Each chapter also outlines the benefits of leveraging Windows Server 2008.

Understand how to:

•          Master DBA tips, tricks, and best practices proven in actual enterprise environments
•          Install, upgrade or transition to SQL Server 2008.
•          Harden and Secure an implementation.
•          Encrypt SQL Server from an end-to-end perspective.
•          Implement high availability–and leverage SQL Server 2008’s major improvements to failover clustering and database mirroring
•          Save time with SQL Server 2008’s new policy-based management tools
•          Performance tune and troubleshoot a SQL Server 2008 environment.
•          Optimize application performance and manage workloads with the powerful new Resource Governor
•          Implement Performance Studio, maintenance plans, Transparent Data Encryption and much more…

Bonus Content:

•          The book is based on Windows Server 2008
•          Step by step instructions of how to implement a failover cluster on Windows Server 2008
•          SQL Server PoweShell Administration Tasks
•          Consolidate and virtualize SQL Server with Hyper-V
•          Step by step instructions on how to install Hyper-V
•          Proactively Monitor SQL Server with Operations Manager
•          Install Windows Server 2008 certificates to encrypt SQL Server data

Contributing Writers include:

Hilary Cotter — SQL Server MVP

John Welch — SQL Server MVP

Marco Shaw — PowerShell MVP

Maciej Pilecki — SQL Server MVP

Shirmattie Seenarine — Technical Writer

Let’s face it, SQL is a deceptively simple language to learn, and many database developers never go far beyond the simple statement: SELECT FROM WHERE . But there is “so” much more you can do with the language. In the “SQL Cookbook,” experienced SQL developer Anthony Molinaro shares his favorite SQL techniques and features. You’ll learn about:

Window functions, arguably the most significant enhancement to SQL in the past decade. If you’re not using these, you’re missing out

Powerful, database-specific features such as SQL Server’s PIVOT and UNPIVOT operators, Oracle’s MODEL clause, and PostgreSQL’s very useful GENERATE_SERIES function

Pivoting rows into columns, reverse-pivoting columns into rows, using pivoting to facilitate inter-row calculations, and double-pivoting a result set

“Bucketization,” and why you should never use that term in Brooklyn.

How to create histograms, summarize data into buckets, perform aggregations over a moving range of values, generate running-totals and subtotals, and other advanced, data warehousing techniques

The technique of “walking a string,” which allows you to use SQL to parse through the characters, words, or delimited elements of a string

Written in O’Reilly’s popular Problem/Solution/Discussion style, the “SQL Cookbook” is sure to please. Anthony’s credo is: “When it comes down to it, we all go to work, weall have bills to pay, and we all want to go home at a reasonable time and enjoy what’s still available of our days.” The “SQL Cookbook” moves quickly from problem to solution, saving you time each step of the way.