Rodney Landrum

Take full advantage of everything SQL Server 2008 Reporting Services has to offer and deliver customizable, web?enabled reports across your business at a reasonable cost. Learn best?practices from professionals who use SQL Server Reporting Services daily to deliver solutions to paying clients and gain the competitive edge on using Microsoft?s enterprise?level reporting platform. Provides best?practices for using Reporting Services Written by practicing professionals with paying clients Your key to delivering business intelligence across the enterprise

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. Ur innehållet: Chapter 1: Report Server Architecture and Overview -- RL Chapter 2: Report Authoring – Best Practices-- RL Chapter 3: The Reporting Environment-- RL Chapter 4: Building Report Examples-- RL Chapter 5: Custom .Net Applications with Reporting Services-- JV Chapter 6: Rendering Reports-- JV Chapter 7: Deploying Reports-- JV Chapter 8: Managing Reports-- RL Chapter 9: Report Security-- RL Chapter 10: Report Auditing and Execution-- RL Chapter 11: Reporting with Yukon Analysis Services—RL Chapter 12: Future SSRS-- RL

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

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

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.

SQL Server Reporting Services 2005 is the latest version of the reporting technology from Microsoft, providing the means to design, author, render, and deploy business reports to users, customers, and employees via the Web or the company intranet. The reporting engine is built into the SQL Server 2005 database (and provided as a free add-on with SQL Server 2000), and the report manager is integrated with Visual Studio 2003, offering an effective and familiar environment for SQL Server and .NET developers. The book is steeped in the day-to-day challenges, discoveries, and successes involved in delivering a successful reporting solution with this technology. Consequently, you will encounter step-by-step guides, best practices, and real code examples that cover all common Reporting Services tasks.