SQL Azure Reporting.

Who is online?  107 guests and 0 members
home  »  blogs  »  suhas kudekar  »  SQL Azure Reporting.

SQL Azure Reporting.

change text size: A A A

posted  6/27/2012 4:37:57 AM  by suhas kudekar -  Views: [1136] 

SQL Azure Reporting
SQL Azure Reporting enables developers to enhance their applications by embedding cloud based reports on information stored in a SQL Azure database.  Developers can author reports using familiar SQL Server Reporting Services tools and then use these reports in their applications which may be on-premises or in the cloud.
1
First we need to understand what is SQL Azure & SQL Azure Database?
Microsoft SQL Azure
Microsoft SQL Azure delivers on Microsoft’s SQL Server Data platform vision of extending the Data platform capabilities to the cloud. SQL Azure provides data services, including a relational database, reporting; and data synchronization with mobile users, remote offices and business partners.
Sign Up for a free account to Access SQL Azure
Two ways you can try SQL Azure FREE of charge:
  • Sign up for this limited-time promotion, and you’ll get TWO 1GB Web Edition databases for one month.
  • Get a 1GB Web Edition database for no charge for 3 months.

 

Microsoft SQL Azure Database
Microsoft SQL Azure Database is part of Microsoft SQL Azure. It is a cloud-based relational database service built on SQL Server technologies. It provides a highly available, scalable, multi-tenant database service hosted by Microsoft in the cloud. SQL Azure Database enables easy provisioning and deployment of multiple databases.
2

Benefits of the Azure platform for Azure Reporting Services are:
Advantages-
  • Highly available, the cloud services platform has built-in high availability.
  • Cloud services platform automatically scales up and down.
  • Reports and SQL Azure databases are on a safe place in the cloud.
  • Don’t have to set up servers and you don’t have to invest in managing servers.
  • Use the same tools you use today to develop your solutions. Just develop your reports in BIDS or Report Builder and deploy to Azure.
Disadvantages-
  • No subscriptions or scheduled delivery available.
  • No developer extensibility in the first version, so no custom data sources, assemblies, report  items or authentication
  • SQL Azure databases are the only supported data sources in the first version, more data sources are expected to come.
  • No Windows Authentication, only SQL Azure username/password is supported in the first version, similar to SQL Azure database. When SQL Azure database gets Windows Authentication

Difference between SQL Server Reporting Services (SSRS) & SQL AZURE Reporting

Developer Tool:
  • SSRS-Business Intelligence Design Studio (BIDS)Report Builder
  • SQL Azure Reporting-Business Intelligence Design Studio (BIDS)

Report Builder (Authoring only – deployment to SQL Azure Reporting through BIDS)

Supported Data Sources:
  • SSRS-Diverse data sources
  • SQL Azure Reporting-SQL Azure databases
Report:
  • SSRS-Embed reports into your apps
  • SQL Azure Reporting-Embed hosted reports into your apps
Management & Delivery:
  • SSRS-Report Manager or SharePoint Portal display reports rendering to multiple formats subscriptions scheduled delivery
  • SQL Azure Reporting-SQL Azure Development Portal display reports rendering to multiple formats
Developer Extensibility:
  • SSRS-Extensible for custom data sources, assemblies, report items, authentication, etc.
  • SQL Azure Reporting-Extensibility is not yet enabled
Security Model:
  • SSRS-Windows Authentication
  • SQL Azure Reporting-SQL Azure Username/password

Suhas Kudekar

tags : SQL Azure Reporting, SSRS
  Rate This Blog Entry:  register  or  login

Author

suhas suhas kudekar (Member since: 4/16/2012 1:53:42 PM)
Recived microsoft community contributor award 2012. https://www.microsoftcommunitycontributor.com/logon.aspx

View suhas kudekar 's profile

Comments (no comments yet)

Leave a comment


 
Type the characters:
 *
 
   

Training on Microsoft Products & Technologies

Email Subscriptions

   Get the Most Recent Blogs in your inbox
Blogs RSS Feed

suhas kudekar's latest blog posts

  • Power Pivot and Power View now available in Excel 2013.
    8/1/2012 1:00:03 PM by suhas kudekar  - Views: 1955  - Comments: 0
    In Excel 2013, much of that functionality, including the infrastructure that supports it, is built directly into the Data Model in Excel. Without installing a separate add-in, PowerPivot and ower View...
  • SQL Azure Reporting.
    6/27/2012 4:37:57 AM by suhas kudekar  - Views: 1137  - Comments: 0
    SQL Azure Reporting SQL Azure Reporting enables developers to enhance their applications by embedding cloud based reports on information stored in a SQL Azure database. Developers can author reports u...
  • SQL Server - Get a comma separated list in SQL & MDX.
    6/8/2012 4:44:37 AM by suhas kudekar  - Views: 2254  - Comments: 1
    To get a comma separated list in SQL as well as in MDX use below queries. 1 – SQL Select Name from Sales.SalesReason GO Select Name from Sales.SalesReason SELECT SUBSTRING ( ( SELECT ‘,&rs...
  • SQL Server - Change the Look & Feel of the Report Manager.
    6/6/2012 11:00:11 AM by suhas kudekar  - Views: 2691  - Comments: 0
    Why we need to change the Look & Feel of the Report Manager? Ans- If we have different environments to deploy the reports like QA, DEV, PROD. that time User/Developer can get the more idea once op...
  • SQL+MDX in one Apartment (Hybrid Query).
    5/25/2012 9:21:04 AM by suhas kudekar  - Views: 2294  - Comments: 4
    While replying on the MSDN Forums Most of the time people ask on how to write SQL+MDX both in single place means. 1- Certain data like aggregated data from MDX Query. 2- Select that data from SQL Quer...
  • SQL Server - BIDS No More Exist in SQL Server 2012.
    5/24/2012 2:51:58 PM by suhas kudekar  - Views: 5845  - Comments: 0
    Once you will installed SQL Server 2012 you could not find the BIDS to develop SSAS/SSIS/SSRS application. BIDS will replace with SSDT i.e. SQL Server Data Tools. Comparison of SQL Server 2012 Vs SQL ...
  • SQL Server - VertiPaq Engine Renamed as xVelocity in SQL Server 2012.
    5/24/2012 3:59:06 AM by suhas kudekar  - Views: 1705  - Comments: 0
    VertiPaq engine is currently only available to PowerPivot for Excel in SQL Server 2008 R2. After the amazing success of PowerPivot for Excel in the previous release of SQL Server 2008 R2 this engine m...
Blogs RSS Feed

Latest community blog posts

  • Parse DBCC MemoryStatus using Powershell
    5/19/2013 10:58:46 AM by Ahmad Osama  - Views: 195  - Comments: 0
    A few days back I was resolving a memory issue which caused sql server to stop responding. I was able to figure out the issue by looking into DBCC MemoryStatus output. It was the full text search whic...
  • DB-Migrate v2: Powershell Module to Migrate Databases
    5/14/2013 8:11:24 PM by Ahmad Osama  - Views: 275  - Comments: 0
    This is an update to the DB-Migrate ( http://www.sqlservergeeks.com/blogs/AhmadOsama/personal/797/db-migrate-a-powershell-module-to-migrate-databases ) powershell module to migrate database between sq...
  • The TSQL Classes Stored Procedures: Transaction Handling
    5/12/2013 4:14:12 PM by Ahmad Osama  - Views: 280  - Comments: 0
    This blog is part of the series The TSQL Classes: Stored Procedure The links to previous post are given below. http://sqlservergeeks.com/blogs/AhmadOsama/personal/762/the-tsql-classes-stored-procedure...
  • Reporting With SSRS Part 1 -With Sample Report.
    5/9/2013 4:33:03 AM by Syed Asrar Ali  - Views: 166  - Comments: 0
    Reporting With SSRS Part 1 : In this serires of blogs, i will try to introduce you with some of the key features of the tool which will help you get on board to become a proficient report developer.If...
  • SQL Server – What is IDENTITY_INSERT?
    5/8/2013 2:31:43 PM by Piyush Bajaj  - Views: 1179  - Comments: 3
    Hi Folks, I am sure that all of you would be aware about the role of Identity column in a table, i.e., it is column which keeps on incrementing without supplying the value explicitly during insertion....
  • DB-Migrate: A PowerShell Module to Migrate Databases.
    5/5/2013 8:48:46 PM by Ahmad Osama  - Views: 821  - Comments: 0
    Recently I wrote powershell scripts to move databases, logins and SQL Agent Jobs between instances. Another one I wrote was to fix orphan users. I have now combined all of these different functions in...
  • SQL Server blogs from Ahmad Osama for the month of April
    5/3/2013 10:22:05 AM by Admin Admin  - Views: 351  - Comments: 0
    Hi SQL Geeks, Here are the blog posts by Ahmad Osama for the month of April. We would expect more of his informative blogs this month. Happy Learning! If you like our blogs do like us on Facebook at h...
  • The TSQL Classes Stored Procedures: Error Handling
    5/1/2013 9:05:11 PM by Ahmad Osama  - Views: 1180  - Comments: 0
    This blog is part of the series The TSQL Classes: Stored Procedure The link to previous post are given below. http://sqlservergeeks.com/blogs/AhmadOsama/personal/762/the-tsql-classes-stored-procedures...
  • Get free space in all files in an Instance
    4/8/2013 9:01:44 AM by Manohar Punna  - Views: 1671  - Comments: 1
    As DBAs we are always challenged of unexpected size growth of log or data files and need to shrink files based on available free space in each file. Most of the times we are stuck and do a lot of scri...
  • SQL Server: Using Powershell to Fix Orphan Users
    4/2/2013 7:05:50 PM by Ahmad Osama  - Views: 1739  - Comments: 0
    One of the major migration activities is to fix orphan users. Though, it can be easily fixed by sp_change_users_login procedure, however what if you need to do this for multiple servers. A powershell ...
  • The TSQL Classes Stored Procedures: Parameter sniffing
    4/1/2013 10:55:43 PM by Ahmad Osama  - Views: 2446  - Comments: 3
    This blog is part of the series The TSQL Classes: Stored Procedure. http://www.sqlservergeeks.com/blogs/AhmadOsama/personal/764/the-tsql-classes-stored-procedures-nested-proc-recursion-and-plan-cachin...