7 Things You Need To Know about SQL Azure Reporting

image The SQL Azure Team had a quite interesting blog back in mid-November around the newly released SQL Azure Reporting.  Here’s a summary of their nuggets about the new technology.

  1. It’s Based on SQL Server Reporting Services (SSRS)
    SQL Azure Reporting provides a subset of the features of SSRS, therefore, the same tooling & artefacts apply:  Business Intelligence Studio, tables, widgets (e.g. gauge, charts, maps) and the result is an RDL file.
  2. Report Execution Happens in the Cloud
    The cloud is going to absorb the execution of report.
  3. SQL Azure Reporting is Part of the Windows Azure Platform
    Which means the same advantages as the rest of the platform:  scalability, quick provisioning & integration with the Azure Portal.
  4. The Data Source is SQL Azure
    This is more of a limitation than anything at the moment.  Basically the paradigm is that you run reports in the cloud against a DB in the cloud.
  5. Reports Are Exactly the Same Format
    Nothing special needs to be put in the .rdl.  It is an output of Business Intelligence Studio like any other report.
  6. There is Nothing New to Download and Install
    Again, the same toolset
  7. You Can Access SQL Azure Reporting With a Browser
    You do not need to deploy a web site and embed your reports into it (although you can):  you can view the reports directly from SQL Azure Reporting.  The reports are secured with Live ID by default.

A nice introduction to Azure SQL Reporting is the PDC 2010 Video by Nino Bice.



20 thoughts on “7 Things You Need To Know about SQL Azure Reporting

  1. I wish to point out my respect for your kind-heartedness supporting individuals who actually need help with this important theme. Your personal commitment to getting the message along appears to be really helpful and has surely helped individuals just like me to get to their pursuits. Your entire important information signifies much to me and still more to my mates. Thanks a ton; from all of us.

  2. The next time I read a weblog, I hope that it doesnt disappoint me as much as this one. I mean, I do know it was my option to learn, but I really thought youd have something attention-grabbing to say. All I hear is a bunch of whining about something that you possibly can fix if you happen to werent too busy looking for attention.

  3. I suppose this webpost has a very vital information for all those who’s skills are in SQL
    so i find it awesome.

  4. Hi, I’m so glad I found this information. Today’s gossip bloggerspublish only the internet and stuff and this is really annoying. A good website with interesting content, this is what necesito.Gracias for making this website, and I visit again. What do newsletters? Can not find what you want.

  5. I have this error

    Tables without a clustered index are not supported in this version of SQL Server. Create a clustered index and try again.

    Can anyone solve this?

  6. Normally I do not read article on blogs, but I wish to say that this write-up very pressured me to try and do so! Your writing taste has been surprised me. Thanks, quite nice post.

  7. Do you mind if I quote a couple of your posts as long as I
    provide credit and sources back to your website?
    My website is in the exact same niche as yours and my visitors would
    really benefit from a lot of the information you present here.
    Please let me know if this ok with you. Many thanks!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s