Tuesday, August 13, 2013

Book Review - Learning SQL Server Reporting Services 2012

To give an opening line about the book - All about Reports and Reporting life cycle from creation to deployment on On-Premises, With SharePoint and on Cloud. Really Comprehensive content on the installation. When I was explaining about the Azure SQL Databases (then SQL Azure) to my friend, his comment was this is far better than on-premises SQL Server; when I asked for the reason, he replied back saying we don’t need to traverse the 50 odd installation steps and configurations. This book steps in and solves the mystery of the SQL Server & Reporting Components about the installation and the background for the installation steps.

The things which I liked in the book are the depth in the illustration of the component and necessity in the installation steps; overview of the features around the reporting tools. The aim of the author to make this book ready for Reporting Developers to start from ZERO and take off to a real-time production environment, the several ways to create / develop reports - the pros and cons of taking either of the approaches, the emphasis of the role management with AD and the ways to architect a role / custom role to restrict the access at the report level.
The good things is the involvement of the SharePoint into the reporting scenario. There are several new things around Data BI which picked up lot of attention like Power View, Report Manager / Builder, Alerts, Extending / Programming the reports, PowerShell for automation & Management, you get to read about all the above stated in this books.

With Cloud, Data gearing up a great way, Microsoft's Azure SQL Reporting Services is something really cool, powerful, and self-service. With Azure SQL Databases and Azure SQL Reporting it changes the game of Data & Reporting for an Organization. Thanks to the author, Azure SQL Reporting was brought under the scope and I can say, the chapter sufficient to handle the Azure SQL Reporting, right from provisioning, deployment, users / role creation, logs, Access Management at enterprise level.

Although all of the example are explained on Windows 7 environment which is a client Operating System, the real-time production loads pretty much happen over the Server Operating System like Windows Server 2008 R2 or Windows Server 2012. The thing to note is that, the background, configuration about the Reporting tools are transferable. One doesn’t need to worry a great deal about examples and exercises which are illustrated over the Windows 7.