7 Things You Need To Know about SQL Azure Reporting

Solution  · 

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.

Enjoy!

19 responses

  1. informatica vicenza – 2011-08-29 at 08:41

    Complimenti per questo fantastico blog!

  2. opsirap – 2011-08-29 at 13:42

    Very Good Informations Thank You

  3. joculete – 2011-08-29 at 15:50

    I collected a lot of interesting things in your blog especially its discussion. Nice work!

  4. Marco Ginoza – 2011-09-02 at 06:11

    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.

  5. Red Eyeshadow – 2011-09-04 at 00:06

    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.

  6. Economia Mundial – 2011-09-14 at 15:03

    Great article, very usefull, thx i shared in fb with my friends, thx

  7. Soil Conditioner – 2011-09-15 at 21:16

    You seem to be well informed in your field.I must say you have a nice site you have here. Keep up the good work!!!

  8. Aman – 2011-09-29 at 11:20

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

  9. compras online – 2011-10-03 at 02:43

    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.

  10. Alyssa – 2011-11-03 at 08:57

    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?

  11. brianlara2011 – 2012-03-07 at 02:02

    Your blog explains the nitty-gritty of it very well. Thank you for posting it and educating us all. Keep the good work up.

  12. Audio Tech – 2012-04-13 at 17:18

    One of the useful post I’ve been reading lately … Keep up the good job. Congrats.

  13. Travel Guide – 2012-04-18 at 16:08

    Wow, love your site. Really enjoy your posts.

  14. Reodedags – 2012-04-18 at 19:18

    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. gervads

  15. prepagos medellin – 2012-04-23 at 05:48

    Hola!! Gracias por tus comentarios muy interesantes, te mando un saludo desde Colombia!! Espero que me lean!

  16. Premium Adobe After effects Template – 2012-05-23 at 04:26

    I do not even understand how I ended up here, but I thought this post was great. I don’t recognize who you might be however definitely you are going to a famous blogger when you are not already. Cheers!

  17. cindylopez@ymail.com – 2012-05-24 at 04:44

    Hey, your own write-up had been awesome a lot regarding tips in addition to seriously given a hand to all of us out there.

    Thank you and good luck.

  18. Therese – 2013-06-22 at 13:28

    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!

  19. Vincent-Philippe Lauzon – 2013-07-05 at 08:45

    Sure.

Leave a comment