Pro SQL Server 2012 Reporting Services opens the door to delivering customizable, web-enabled reports across your business at reasonable cost. Reporting Services is Microsoft's enterprise-level reporting platform. It is included with many editions of SQL Server, and is something you'll want to take advantage of if you're running SQL Server as your database engine. Reporting Services provides a full set of tools with which to create and deploy reports. Create interactive reports for business users. Define reporting models from which business users can generate their own ad hoc reports. Pull data from relational databases, from XML, and from other sources. Present that data to users in tabular and graphical forms, and more. Reporting Services experts Brian McDonald, Rodney Landrum, and Shawn McGehee show how to do all this and much more in this third edition of their longstanding book on the topic.* Provides best practices for using Reporting Services * Covers the very latest in new features for SQL Server 2012 * Your key to delivering business intelligence across the enterprise What you'll learn * Write efficient queries on which to base a report * Build and lay out a report using Report Designer * Enable end users to create ad hoc reports on demand * Combine Reporting Services with Analysis Services, SharePoint Server, and other technologies to deliver business intelligence across the enterprise * Secure and audit your reports as part of your regulatory compliance efforts * Customize your reports using C# assemblies and embedded Visual Basic .NET code Who this book is for Pro SQL Server 2012 Reporting Services is aimed at data analysts, developers, database administrators, and others who develop and deploy reports using Microsoft SQL Server Reporting Services. Table of Contents1. Introducing the Reporting Services Architecture 2. Report Authoring: Designing Efficienc Queries 3. Introduction to Reporting Services Design with SQL Server Data Tools 4. Laying Out A Report 5. Implementing Dashboard-Style Report Objects 6. Building Reports 7. Using Custom .NET Code with Reports 8. Deploying Reports 9. Rendering Reports from .NET Applications 10. Managing Reports 11. Securing Reports 12. Delivering Business Intelligence using SSRS 13. Creating Reports using Report Builder 1.0, 2.0, and 3.0

Every day, organizations large and small fall victim to attacks on their data. Encryption provides a shield to help defend against intruders. Because of increasing pressure from government regulators, consumers, and the business community at large, the job descriptions of SQL DBAs and developers are expanding to include encryption. Expert SQL Server 2008 Encryption will show you how to efficiently implement SQL Server 2008 encryption functionality and features to secure your organizational data.Introduces encryption, guiding readers through its implementation in SQL Server Demonstrates advanced techniques such as the use of hardware security modules Covers all that a SQL Server database administrator needs to know about encryption What you'll learn Take advantage of hardware security modules via extensible key management Implement targeted encryption of individual columns Secure an entire database at once with Transparent Data Encryption Encrypt disk volumes using BitLocker encryption Effectively design and manage encryption as part of your total security solution Digitally sign documents stored in your database Who this book is for

The audience for this book includes SQL Server DBAs, SQL developers, and .NET developers who want to take advantage of the powerful encryption functionality available in SQL Server 2008. The features of SQL Server 2008 provide a powerful set of tools to secure your most sensitive data, helping protect it from theft. Table of Contents Introduction to Encryption Encryption Key Management Symmetric Encryption Asymmetric Encryption Extensible Key Management Transparent Data Encryption Hashing SQL CLR Cryptography Indexing Encrypted Data Encrypting Connections to SQL Server 2008 Regulatory Requirements

Take full advantage of everything SQL Server 2008 Reporting Services has to offer and deliver customizable, webenabled reports across your business at a reasonable cost. Learn bestpractices from professionals who use SQL Server Reporting Services daily to deliver solutions to paying clients and gain the competitive edge on using Microsoft's enterpriselevel reporting platform.Provides bestpractices for using Reporting Services Written by practicing professionals with paying clients Your key to delivering business intelligence across the enterprise What you'll learn Write efficient queries on which to base a report Build and lay out a report using Report Designer Enable end users to create ad hoc reports on demand Combine Reporting Services with Analysis Services, SharePoint Portal Server, and other technologies to deliver business intelligence across the enterprise Secure and audit your reports as part of your regulatory compliance efforts Customize your reports using C# assemblies and embedded Visual Basic .NET code Who this book is for

Data analysts, developers, database administrators, and others who develop and deploy reports using Microsoft SQL Server Reporting Services.

Purchase this book and you'll get the free, fully searchable eBooka $20 value! (Details are printed inside the book.)

It does a good job of covering the fundamentals and simple reporting needs. For the SSRS newcomer, it is a great place to start. -- Will Wagers, C# Online.NET

SQL Server Reporting Services (SSRS) 2005 is the latest version of the reporting technology from Microsoft. This book examines all of the technology that SSRS provides to design, author, render and deploy professional business reports to the Web or to the company intranet (in a variety of formats, from HTML to XML, PDF, or TIFF), with detailed examples at every step.

It covers all of the new functionality present in the 2005 version, including the new management and BI development studios as well as the new report viewer controls and end-user reporting tools. It also contains significantly expanded chapters on Business Intelligence along with a wealth of tips and workarounds for effective development with SSRS.

The authors are both highly experienced with SQL Server and with business reporting in the medical industry, which is subject to rigorous HIPAA regulations and strict security. It is not their intention to evangelize the product or present "idealized" examples based on the simple built-in schemas. Instead, they take a hard, critical look at the technology and provide exactly what the reader needs to know to deliver effective reports. Their code examples are based on real, complex schemas and the need to deliver versatile, dynamic reports, as well as on strict security and performance requirements.

In summary, this book will provide you with step-by-step guides, best practices, and realcode examples covering all of the common Reporting Services tasks, including: A detailed overview of the reporting architecture and tools The new Report Definition Language Standard, which is XML-based and allows you to define reports in VS.NET Building effective queries for high-performance reporting Building custom .NET applications with SSRS Rendering reports to HTML, XML, PDF and Excel Deploying secure reports, using Windows authentication through Active directory Business Intelligence reporting using SQL Server Analysis Services

SQL Server Reporting Services is the long-awaited reporting technology for Microsoft, and provides the means to design, author, and deploy business reports via web or company intranet. This book takes a thorough look at each step necessary to create secure and professional reports, and the authors have extensive experience producing reports in the highly-regulated medical industry. As a result, this book bestows the reader with a skill-set to build versatile and secure reports.

For the day-to-day DBA, there are dangers around every corner; monsters waiting to strike down the unsuspecting database with a resource-hungry query, an inefficient data load, or even outright data corruption. When the worst happens, and SQL Server is down, or performance is suffering, customers are quick to complain. During such difficult periods, you, the DBA, are the centre of attention. Suddenly, three or four people crowd your desk, laser beam focused on your every action, fully expecting you to solve the problem quickly. The success of your career as a DBA depends largely on how well-prepared you are to deal with such situations. Without verified backups, sound server documentation, and a ready supply of tried-and tested troubleshooting tools, there is no safe place to hide when the monster rears up. All you can do is buy some time, patch things up as best you can and then duck away into your cubicle, which, if you lost any data in the process, may soon be empty. However, with the tools and techniques provided in the SQL Server Tacklebox, you will be fully-equipped to fight back. Inside, you'll find scripts that will allow you to automate and standardize SQL Server installation, document and report on your servers, migrate data and manage data growth, troubleshoot performance issues, receive notifications of impending danger, secure access to your servers and fight off data corruption. In short, you'll be able to respond quickly and professionally to the many issues that blight the waking, and often sleeping, hours of the DBA. Then, one day, who knows? That cubicle may turn into an executive office with wall-to-wall tinted windows revealing a flowing brook outside, where no monsters live.