Day 7 - Windows Azure Platform - SQL Azure Reporting

by Kev Ritchie 7. December 2010 00:00

 

On the 7th day of Windows Azure Platform Christmas my true love gave to me SQL Azure Reporting.

Well, not quite yet Wink SQL Azure Reporting isn’t available commercially, but you can register to be invited to the CTP http://connect.microsoft.com/sqlazurectps. Enjoy!

But what is SQL Azure Reporting?

SQL Azure Reporting is the Cloud-based version of SQL Server Reporting Services (SSRS) and provides almost all the same features that you’re used to; with the exception of scheduled delivery, subscriptions and developer extensibility, but it does however, provide a central, highly available, fault tolerant reporting system to you and your customers.

So, what are the key benefits to you?

Well, first and foremost, less work and cost Smile.  The infrastructure for delivering your reports is all ready there, which allows you to just get on and create the reports you need.

For all you security bods out there, SQL Azure Reporting includes a rich authentication/authorisation model which gives you reliable and secure access to your reports and the underlying data of the reports.  So there’s no need to worry what’s happening when you let your reports fly into the ether.

That’s all great, but I missed one point.  Any reports you create and upload to SQL Azure Reporting can be directly accessed within your Windows Azure or on-site application, through your favourite browser (in my case IE9 beta) or through the SQL Azure portal.  Brilliant, hardly any work for you; well if you don’t include building the report and an application that accesses your reports Wink

So with a small investment in the building or even migrating of your reports to SQL Azure Reporting, you get an infrastructure that opens the way for you to deliver your reports robustly and securely to your customers or even the world!

Tomorrow installment: SQL Azure – Data Sync 

P.S. If you have any questions, corrections or suggestions to make please let me know.

Day 6 - Windows Azure Platform - SQL Azure Database

by Kev Ritchie 6. December 2010 00:05

 

On the 6th day of Windows Azure Platform Christmas my true love gave to me the SQL Azure Database.

What is the SQL Azure Database?

The SQL Azure Database is a Windows Azure platform relational database system based on SQL Server technology and because of this provides a very familiar development model.  So; as developers, you can still use familiar connection protocols like; ADO.NET, ODBC and the Entity Framework to name a few.

You can also use the standard SQL tools that you’re used to like Management Studio, Integration Services, Analysis Services and BCP.  So, if you want to manage or move an existing database in the Cloud, it should be very simple.

But that’s not the only benefit of using a Cloud-based relational database system, there are more.

Let’s imagine that your server suddenly comes under some heavy workload; not to worry.  SQL Azure replicates multiple redundant copies of your data to multiple physical servers to maintain data availability. But what if my server fails?  Simple; SQL Azure provides automatic failover.  All this without you having to manage a single thing Smile

You can also scale up and scale down the service as your data grows or reduces and with the use of a “pay-as-you-grow” pricing model, this makes sure that you only pay for what you store.

I’ve only touched on a few benefits here, but what I wanted to show was the familiarity and ease with which you can store, manage and access data in the Cloud.

Tomorrow installment: SQL Azure - Reporting

P.S. If you have any questions, corrections or suggestions to make please let me know.

Day 5 - Windows Azure Platform - Connect

by Kev Ritchie 5. December 2010 00:22

 

On the 5th day of Windows Azure Platform Christmas my true love gave to me Connect.

What is Windows Azure Connect?

Connect is a component of Windows Azure; that, well allows you to connect things. Doesn’t sound amazing, does it? Well, let’s have a closer look. If you’re a Network Administrator or a Dev, you’ll love this.

Windows Azure Connect allows you to connect (using IPSec protected connections) computers/servers in your network to roles in Windows Azure and the best bit; the roles take on IP addresses as if they were resources in your network.

NOTE: It doesn’t create a VPN connection

So, for example, you could have a web application running on Windows Azure that has a back-end database to store; for instance, customer information. But, what if you don’t want to store the database in Azure, well you don’t have to. With Connect, you can leave the database on your network; Connect will do the rest. Well, obviously after some human intervention Wink

Also after Connect is configured, you have the ability to use existing methods for domain authentication and name resolution. You can remotely debug Windows Azure role instances and you can also use existing management tools to work with roles in the Azure Platform e.g. PowerShell.

Connectivity between different networks and applications isn’t a new concept by any means, but what Connect provides, is a simple, secure, non-nonsense, no VPN way of bridging the gap between your network and The Cloud.

Tomorrow’s installment: SQL Azure - Database

P.S. If you have any questions, corrections or suggestions to make please let me know.

Day 4 - Windows Azure Platform - Content Delivery Network

by Kev Ritchie 4. December 2010 00:21

 

On the 4th day of Windows Azure Platform Christmas my true love gave to me the Content Delivery Network.

What is the Content Delivery Network?

The Windows Azure Content Delivery Network (CDN) caches Windows Azure Blobs (discussed on day two), at locations closer to where the content is being requested, this way bandwidth is maximised and content is delivered faster.

For example, say you have a website that delivers video content to millions of users around the world, that’s a lot of locations Wink It would be terribly inefficient to serve up content from just one location.  Allowing the video content to be cached in several locations, some being closer to the requesting source allows for the video to streamed/downloaded quicker.

There’s only one requirement to make a blob (your data) available to the CDN and it’s very simple, mark the container the blob resides in as public.  To do this, you need to enable CDN access to your Storage Account.

Enabling CDN access to a Storage Account is done through the Management Portal (briefly mentioned on day two).  When CDN access has been enabled the portal will provide you with a CDN domain name in the following URL format: http://<identifier>.vo.msecnd.net/.

NOTE:  It takes around 60 minutes for the registration of the domain name to propagate round the CDN.

With a CDN domain name and a public container with blobs in, you now have the ability to serve up Windows Azure hosted content; strategically, to the world Smile

Tomorrow’s installment:  Connect

P.S. If you have any questions, corrections or suggestions to make please let me know.

Day 3 - Windows Azure Platform - Fabric Controller

by Kev Ritchie 3. December 2010 00:01

 

WAP

On the third day of Windows Azure Platform Christmas my true love gave to me the Fabric Controller.

And I’m quite glad she did, as this is one the most fundamental aspects of Windows Azure.

I briefly mentioned on day one about the Fabric Controller and one of the main functions that it provides (Virtual Machine/Role scaling). Today I’ll expand a little on that.

What is the Fabric Controller?

The Fabric Controller is a new innovative technology that acts on-demand and is, in many ways the brain of Windows Azure. It controls, maintains, allocates resources…well to cut it short, it looks after your Azure application and environment for you. That’s not to say it will make a badly written application better Winking smile

So, expanding on Virtual Machine scaling, let’s say for instance, when you deploy your application to Windows Azure, you specify that you want a single Web Role, the Fabric Controller spins that Virtual Machine (VM) up for you, nice Smile Now the magic, imagine that you have a web application; let’s say an e-Commerce site, and it handles quite a large user base everyday. If the application or the server the application was on happened to fail or throw an unhandled error, it could be quite costly. Well, with the Fabric Controller, if it notices that your application (Web Role) has failed, it will spin up another VM to maintain the total number of instances required for your application; seamlessly. Nicer! Smile

One of the other features I really love about the Fabric Controller is its ability to maintain, upgrade and patch the environment (VM) in which your application runs. No more tedious administration tasks!

With just these little snippets I’ve given you, you can really see why Windows Azure is the perfect PaaS (Platform as a Service).

Tomorrow’s installment: CDN (Content Delivery Network)

P.S. If you have any questions, corrections or suggestions to make please let me know.

Powered by BlogEngine.NET 2.5.0.6
Theme by Mads Kristensen | Modified by Mooglegiant

About Author

C# Senior .NET Developer with a passion for clean, maintainable and re-usable code. Loves to code and say a few words!

profile for Kev Ritchie at Stack Overflow, Q&A for professional and enthusiast programmers

Month List