Cloud Database ado.net tutorials

Tags: VB.NET, VB 2008, VB 2010, VB 2012, VB 2013

This lesson explains what is a Cloud Database

Cloud computing is very popular these days as companies and consumers are storing data in the cloud. As you guess the cloud is not a white fluffy cloud with desktop computers inside.

I'm not even sure where this image originated because Microsoft's datacenters worldwide are situated firmly on the ground consisting of thousands of commodity servers in racks that look nothing like desktop computers.

Meaning, cloud computing actually means that a vendor such as Microsoft supplies computing services via the Internet.

Microsoft's cloud services are branded Microsoft Azure, and there are two ways Microsoft can host your database in the cloud.

Azure SQL Database

The first way is by installing SQL Server instance on an Azure virtual machine, which means that you will work with the SQL Server in the same ways that you do when it's installed on your own server.

The second way is by creating a Microsoft Azure SQL Database, and in this case, you don't manage the SQL Server instance at all. Rather you manage only the database(s) without spinning up a Virtual Machine.

It has a built-in high availability and disaster recovery, and most importantly, the T-SQL language is mostly the same. For more info please visit the Azure SQL Database Transact-SQL Reference.

One of the things that i love about Azure SQL Database is that Microsoft can push out updates and new features on a frequent basis, much more frequently than the traditional SQL Server. You can just provision a database in seconds and never have to worry about reboots, upgrades, or backups, because Microsoft automatically performs most of the maintenance for you.

Most of the companies are taking advantage of cloud services, like Microsoft Azure, to save money and be more flexible. They are moving their web-based applications entirely to the cloud saving a lots of money, because you just pay for what you use. For example, they could scale out during the busy months and scale back during the slow months, paying more during the busy months and saving a lot of money during the slow months.

To get started with Azure SQl Database, you'll need like 20 seconds. Once you are logged in, select SQL Databases and after that click the +New link in the bottom. Then select Data Services -> SQL Database -> Quick Create and fill in a name for the database. Select a region that is closest to you and finally create a login and password. Once you click the Create SQL Database check mark you will be all set. Voila!

The cloud is certainly the future of enterprise computing, and there is no turning back anymore!


Share This

Home | About | Contact | Privacy Policy

Copyright visual-basic-tutorials.com 2017 - All Rights Reserved.