Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports

A few weeks ago, Wrox Publishers released their book entitled Professional Microsoft SQL Server 2016 Reporting Services and Mobile Reports written by Paul Turley (B|T), an independent BI consultant and trainer, owner of Intelligent Business LLC and Mentor for SolidQ.

Paul asked me to be the technical editor for this book based on our previous collaboration for the 2012 version. I know that he took a lot of time and effort to ensure that this book delivered useful and relevant information for anyone looking to upgrade or leverage Reporting Services 2016 in their production environment.

Reviewing twenty-two (22) chapters while dealing with changes from SQL Server 2016 RC3 to RTM was definitely a challenge but it was also a great learning experience. I am greatly appreciative of this opportunity that Paul and Wrox has given me and I look forward to future collaborations with them.

Continue Reading →

New SQL Server 2012 Reporting Services Book

If you are interested in understanding SQL Server 2012 Reporting Services' architecture and BI fundamentals then the 'Professional SQL Server 2012 Reporting Services' book is the resource for you. This book covers the capabilities of the new reporting platform as well as the new BI capabilities introduced in SQL Server 2012 including semantic model design, enhancements to Report Builder, PowerPivot for Excel 2012 and SharePoint 2012, and Power View.

This book was written by esteemed authors: Paul Turley, Robert Bruckner, Grant Paisley, Thiago Silva and Ken Withee. It is also the first book that I worked on as a technical editor along with Joe Salvatore and Chris Albrektson. This as well as the SQL Server 2012 Upgrade Technical Guide is what kept me extremely busy for the last few months hence the lack of blog posts. Thanks to Paul Turley, my colleague at SolidQ, and Wrox Press for this great opportunity.

It is currently available from Wrox.com, Amazon & other resellers in paperback and electronic editions.

Continue Reading →

SQL Server 2012 Upgrade Technical Guide

Microsoft has recently released the SQL Server 2012 Upgrade Whitepaper. This technical guide takes you through the essentials for upgrading SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 instances to SQL Server 2012. Administrators, developers, business intelligence professionals and project managers planning to upgrade environments and solutions to SQL Server 2012 will find it very useful.

The very detailed and in-depth 454 page guide was written by SolidQ members and technically reviewed and published by Microsoft. I am extremely happy that I was able to contribute to this guide. This is the first time my writing was published and I would like to thank SolidQ and Microsoft for the opportunity.

Congratulations to the SolidQ Authors: Ron Talmage, Nigel Sammy, Allan Hirt, Herbert Albert, Antonio Soto, Danilo Dominici, Régis Baccaro, Milos Radivojevic, Jesús Gil, Dejan Sarka, Johan Åhlén, Simran Jindal, Paul Turley, Craig Utley, Larry Barnes, Pablo Ahumada.

List of Chapters:
Chapter 1: Upgrade Planning and Deployment
Chapter 2: Management Tools
Chapter 3: Relational Databases
Chapter 4: High Availability
Chapter 5: Database Security
Chapter 6: Full-Text Search
Chapter 7: Service Broker
Chapter 8: SQL Server Express
Chapter 9: SQL Server Data Tools
Chapter 10: Transact-SQL Queries
Chapter 11: Spatial Data
Chapter 12: XML and XQuery
Chapter 13: CLR
Chapter 14: SQL Server Management Objects
Chapter 15: Business Intelligence Tools
Chapter 16: Analysis Services
Chapter 17: Integration Services
Chapter 18: Reporting Services
Chapter 19: Data Mining
Chapter 20: Other Microsoft Applications and Platforms
Appendix 1: Version and Edition Upgrade Paths
Appendix 2: SQL Server 2012: Upgrade Planning Checklist

DownloadSQL Server 2012 Upgrade Technical Guide

Continue Reading →