Click here to close now.



Welcome!

Agile Computing Authors: Sanjay Zalavadia, Elizabeth White, Dana Gardner, Kevin Benedict, Xenia von Wedel

Related Topics: Microsoft Cloud, IoT User Interface, Silverlight, Agile Computing

Microsoft Cloud: Book Review

Book Review: Microsoft SQL Server 2012 Reporting Services

The Report Builder's Bible

Over the years I have been on quite a few projects and there have been very few if any that did not require some type of reporting. For a while that meant Crystal Reports, but when SQL Server Reporting Services (SSRS) hit the scene, Crystal Reports began to fade on Microsoft projects. That was especially true if I had my way. I was the first person to champion SSRS in state projects in Pennsylvania. That was quite a battle but well worth it!

SSRS is one of the best solutions to come out of Microsoft. I don't say that lightly. I have plenty of complaints about different Microsoft products, but none about SSRS. The extensibility model built into the architecture makes the product completely customizable through extension.

This book introduces the SSRS architecture, the report manager, the basics of databases and database queries, but every topic introduced supports the report builder role. This book is all about the report builder. The chapters are listed below.

Part I: Getting Started
Chapter 1. Let's Start at the Very Beginning
Chapter 2. Putting the Pieces in Place: Installing Reporting Services

Part II: Report Authoring
Chapter 3. DB 101: Database Basics
Chapter 4. A Visit to Emerald City: The Report Wizard
Chapter 5. Removing the Training Wheels: Building Basic Reports
Chapter 6. Graphic Expression: Using Charts, Images, and Gauges
Chapter 7. Geography Lesson: Using Maps and Spatial Data Types
Chapter 8. Kicking It Up a Notch: Intermediate Reporting
Chapter 9. Beyond Wow: Advanced Reporting

Part III: Reporting Serving
Chapter 10. How Did We Ever Manage Without You--The Report Manager
Chapter 11. Delivering the Goods: Report Delivery
Chapter 12. Teamwork: Integrating Reporting Services
Chapter 13. Well Begun: Best Practices

One thing that struck me as a little weird was there was no "What's new in SSRS 2012" section. That is no big deal as I usually skip those sections anyway, but some readers may be looking for it. One big change that was worth mentioning was no more Report Models. I didn't see that mentioned anywhere in the book.

Reports can be built using Visual Studio 2010, Visual Studio 2010 with the SQL Server Data Tools add-in, and Report Builder. The author does a great job showing how to use the different tools with each example when usage is different. This really helps you get familiar with the tools and in the end will help you choose which tool you would like to use.

There is no coverage of custom extensions. My review started by touting that that is my favorite part of the product, so I was disappointed to see nothing about it. Although I do believe the content of this book will take you to the maximum possible potential of creating and delivering reports with the out of the box functionality, I have had to write custom extensions on many projects in order to meet the client's requirements. It is a topic that I would like to see covered and have seen covered in other reporting services books. However, I am not going to ding the book for this because I know that 99.9% of the reporting services authors will never have to write a custom extension or even have to know they exist.

My favorite part of the book was the hands on approach the author takes to teach us the ins and outs of SSRS. The best way to read this book is with Visual Studio or Report Builder open. The author goes through tons of step by step tasks.

Another thing I really liked was the coverage of data visualization. One of the biggest business user requests I hear is for data visualization in the form of charts, images, and gauges. This book will teach you how to use all three. It also includes great coverage of maps and spatial data types.

One last thing I really like about this book is that the author does a great job of teaching the reader how to retrieve data. In the beginning of the book he does an excellent job explaining joins. Then throughout the book he advances the reader to some fairly complex queries using joins. After running through all the examples you'll know how to get to the data you want.

Like I said above this is a Report Builder's book. If you want to learn everything there is about building reports, this is the book to teach you. The best part though is that you do not have to have any experience. This book takes the beginner from databases 101 to beginning reports, through intermediate reports, to building advanced reports.

The downloadable code is well organized and very usable. The author includes a database and an OLAP database. Both come with instructions for installing and configuring. All the code works well and adds a lot of value to the book.

All in all if you are building SQL Server 2102 Reporting Services Reports, or if you are interested in learning how to, you owe it to yourself to get this book.

Microsoft SQL Server 2012 Reporting Services 4/E

More Stories By Tad Anderson

Tad Anderson has been doing Software Architecture for 18 years and Enterprise Architecture for the past few.

@ThingsExpo Stories
It is one thing to build single industrial IoT applications, but what will it take to build the Smart Cities and truly society changing applications of the future? The technology won’t be the problem, it will be the number of parties that need to work together and be aligned in their motivation to succeed. In his Day 2 Keynote at @ThingsExpo, Henrik Kenani Dahlgren, Portfolio Marketing Manager at Ericsson, discussed how to plan to cooperate, partner, and form lasting all-star teams to change t...
The cloud market growth today is largely in public clouds. While there is a lot of spend in IT departments in virtualization, these aren’t yet translating into a true “cloud” experience within the enterprise. What is stopping the growth of the “private cloud” market? In his general session at 18th Cloud Expo, Nara Rajagopalan, CEO of Accelerite, explored the challenges in deploying, managing, and getting adoption for a private cloud within an enterprise. What are the key differences between wh...
The 19th International Cloud Expo has announced that its Call for Papers is open. Cloud Expo, to be held November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, brings together Cloud Computing, Big Data, Internet of Things, DevOps, Digital Transformation, Microservices and WebRTC to one location. With cloud computing driving a higher percentage of enterprise IT budgets every year, it becomes increasingly important to plant your flag in this fast-expanding business opportuni...
Internet of @ThingsExpo, taking place November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with the 19th International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world and ThingsExpo Silicon Valley Call for Papers is now open.
There is little doubt that Big Data solutions will have an increasing role in the Enterprise IT mainstream over time. Big Data at Cloud Expo - to be held November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA - has announced its Call for Papers is open. Cloud computing is being adopted in one form or another by 94% of enterprises today. Tens of billions of new devices are being connected to The Internet of Things. And Big Data is driving this bus. An exponential increase is...
In his general session at 18th Cloud Expo, Lee Atchison, Principal Cloud Architect and Advocate at New Relic, discussed cloud as a ‘better data center’ and how it adds new capacity (faster) and improves application availability (redundancy). The cloud is a ‘Dynamic Tool for Dynamic Apps’ and resource allocation is an integral part of your application architecture, so use only the resources you need and allocate /de-allocate resources on the fly.
In his keynote at 18th Cloud Expo, Andrew Keys, Co-Founder of ConsenSys Enterprise, provided an overview of the evolution of the Internet and the Database and the future of their combination – the Blockchain. Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life sett...
Machine Learning helps make complex systems more efficient. By applying advanced Machine Learning techniques such as Cognitive Fingerprinting, wind project operators can utilize these tools to learn from collected data, detect regular patterns, and optimize their own operations. In his session at 18th Cloud Expo, Stuart Gillen, Director of Business Development at SparkCognition, discussed how research has demonstrated the value of Machine Learning in delivering next generation analytics to imp...
There are several IoTs: the Industrial Internet, Consumer Wearables, Wearables and Healthcare, Supply Chains, and the movement toward Smart Grids, Cities, Regions, and Nations. There are competing communications standards every step of the way, a bewildering array of sensors and devices, and an entire world of competing data analytics platforms. To some this appears to be chaos. In this power panel at @ThingsExpo, moderated by Conference Chair Roger Strukhoff, Bradley Holt, Developer Advocate a...
Cognitive Computing is becoming the foundation for a new generation of solutions that have the potential to transform business. Unlike traditional approaches to building solutions, a cognitive computing approach allows the data to help determine the way applications are designed. This contrasts with conventional software development that begins with defining logic based on the current way a business operates. In her session at 18th Cloud Expo, Judith S. Hurwitz, President and CEO of Hurwitz & ...
A strange thing is happening along the way to the Internet of Things, namely far too many devices to work with and manage. It has become clear that we'll need much higher efficiency user experiences that can allow us to more easily and scalably work with the thousands of devices that will soon be in each of our lives. Enter the conversational interface revolution, combining bots we can literally talk with, gesture to, and even direct with our thoughts, with embedded artificial intelligence, wh...
19th Cloud Expo, taking place November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, will feature technical sessions from a rock star conference faculty and the leading industry players in the world. Cloud computing is now being embraced by a majority of enterprises of all sizes. Yesterday's debate about public vs. private has transformed into the reality of hybrid cloud: a recent survey shows that 74% of enterprises have a hybrid cloud strategy. Meanwhile, 94% of enterpri...
SYS-CON Events announced today that Bsquare has been named “Silver Sponsor” of SYS-CON's @ThingsExpo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. For more than two decades, Bsquare has helped its customers extract business value from a broad array of physical assets by making them intelligent, connecting them, and using the data they generate to optimize business processes.
Internet of @ThingsExpo, taking place November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 19th Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The Internet of Things (IoT) is the most profound change in personal and enterprise IT since the creation of the Worldwide Web more than 20 years ago. All major researchers estimate there will be tens of billions devices - comp...
Cloud computing is being adopted in one form or another by 94% of enterprises today. Tens of billions of new devices are being connected to The Internet of Things. And Big Data is driving this bus. An exponential increase is expected in the amount of information being processed, managed, analyzed, and acted upon by enterprise IT. This amazing is not part of some distant future - it is happening today. One report shows a 650% increase in enterprise data by 2020. Other estimates are even higher....
Connected devices and the industrial internet are growing exponentially every year with Cisco expecting 50 billion devices to be in operation by 2020. In this period of growth, location-based insights are becoming invaluable to many businesses as they adopt new connected technologies. Knowing when and where these devices connect from is critical for a number of scenarios in supply chain management, disaster management, emergency response, M2M, location marketing and more. In his session at @Th...
SYS-CON Events announced today that ReadyTalk, a leading provider of online conferencing and webinar services, has been named Vendor Presentation Sponsor at the 19th International Cloud Expo, which will take place on November 1–3, 2016, at the Santa Clara Convention Center in Santa Clara, CA. ReadyTalk delivers audio and web conferencing services that inspire collaboration and enable the Future of Work for today’s increasingly digital and mobile workforce. By combining intuitive, innovative tec...
Amazon has gradually rolled out parts of its IoT offerings, but these are just the tip of the iceberg. In addition to optimizing their backend AWS offerings, Amazon is laying the ground work to be a major force in IoT - especially in the connected home and office. In his session at @ThingsExpo, Chris Kocher, founder and managing director of Grey Heron, explained how Amazon is extending its reach to become a major force in IoT by building on its dominant cloud IoT platform, its Dash Button strat...
industrial company for a multi-year contract initially valued at over $4.0 million. In addition to DataV software, Bsquare will also provide comprehensive systems integration, support and maintenance services. DataV leverages advanced data analytics, predictive reasoning, data-driven diagnostics, and automated orchestration of remediation actions in order to improve asset uptime while reducing service and warranty costs.
Vidyo, Inc., has joined the Alliance for Open Media. The Alliance for Open Media is a non-profit organization working to define and develop media technologies that address the need for an open standard for video compression and delivery over the web. As a member of the Alliance, Vidyo will collaborate with industry leaders in pursuit of an open and royalty-free AOMedia Video codec, AV1. Vidyo’s contributions to the organization will bring to bear its long history of expertise in codec technolo...