Windows Azure SQL Database Tutorials - We help with Cloud Databases




Welcome to our site on Azure SQL Database Tutorials. We have put together quite a bit information together to help you in the learning process. The training material includes PowerPoint presentations, tutorial videos, TSQL commands, Blog posts and vital resource links. 

In addition to training we provide Database Consulting on Azure SQL Database and SQL Server. Feel free to contact us at kash@sqlazuretutorials.com if you have any comments or suggestions.  

Using Windows Azure Management Portal with SQL Database


December 31, 2013 Posted by Kash

 
Windows Azure Management Portal gives you an idea of how your subscribed services are performing in the cloud environment. The Windows Azure Portal is supported in multiple languages so it gives you additional functionality. The portal supports the following services:
  • Web Sites
  • Virtual Machines
  • Mobile Services
  • Cloud Services


Read More     |     Comments

Windows Azure SQL Database – Tutorial video on Cloud computing database


October 31, 2013 Posted by Kash

 
In this tutorial video on Windows Azure SQL Databases , we cover Microsoft Windows Azure signup process. Windows Azure SQL Databases is a cloud computing relational database built on SQL server technologies. It is a scalable, self managing and highly...

Read More     |     Comments

Resources on Microsoft Windows Azure SQL Database


September 25, 2013 Posted by Kash

 
There is quite a bit of resources on Microsoft Windows Azure SQL Database. However these websites and resources are not listed in one single location. I figured we should have a short list...

Read More     |     Comments

SQL stored procedures in Windows Azure SQL database


August 31, 2013 Posted by Kash

 
Using stored procedures in Windows Azure SQL database is a conventional wisdom. Store procedures typically run faster than Adhoc SQL statements. The reason for this is that they are pre-compiled and SQL Server has generally a good idea about...

Read More     |     Comments

How to create Windows Azure SQL Database?


May 2, 2013 Posted by Kash

 
For this post, we are assuming you do not have a Microsoft Windows Azure account. We will create a brand new Windows Azure Cloud SQL Database. You will also need to have a FREE Live.com. So lets start with the basics. Please browse to this location. http://www.windowsazure.com/en-us/

Click on Free Trial. At this point they will have you log into Live.com account. If you have not signed up for an account, you can do that at this web address.

https://login.live.com

Read More     |     Comments

How to create table in Windows Azure SQL Database – Cloud computing Database


March 31, 2013 Posted by Kash

 
In this SQL Tutorial video, we show you how to create a table in SQL azure database. This is the cloud computing database from Microsoft. We use CREATE TABLE sql command to create two tables...

Read More     |     Comments

Microsoft drops Windows Azure SQL Database pricing


January 18, 2013 Posted by Kash

 
In terms of low cost structure for cloud computing service , Microsoft SQL Azure is already a viable option. However there seem to be two issues with their cost structure.
  1. -One was for databases that are smaller in size between range of 50 – 100 MB in size.
  2. -The other issue was with VLDB that are greater than 150 GB in size...


Read More     |     Comments

Import data from SQL Server 2008 to SQL Azure


Dec 2, 2012 Posted by Kash

 
In this training demo on SQL Azure, we will demonstrate how to move data from local on premise SQL Server 2008 to SQL Azure in the cloud computing environment. Before you get started, you do need to have the destination table in Azure SQL database first...

Read More     |     Comments

How to create database objects in SQL Azure?


Oct 26, 2012 Posted by Kash

 
In this blog post, we are going to show you how to create the following important database objects in SQL Azure cloud database:
  • Database
  • Table
  • ...


Read More     |     Comments

Windows Azure subscription: How to cancel SQL Azure subscription?


Sep 3, 2012 Posted by Kash

 
SQL Azure is Microsoft’s version of Cloud Database. SQL Data Services are now known as Microsoft SQL Azure and SQL Azure Database. There are a few changes, but fundamentally Microsoft’s plans to extend SQL server capabilities in cloud as web-based...

Read More     |     Comments

Differences between Microsoft SQL Server and SQL Azure


Aug 30, 2012 Posted by Kash

 
SQL Azure is a Relational Database Management System (RDBMS) in the Cloud. It is built on the SQL Server platform and has full support for using Transact SQL (TSQL) programming language. Unlike your local (On-premise) SQL server, SQL Azure is accessible via the Internet...

Read More     |     Comments

Manage a SQL Azure database via the portal


July 1, 2012 Posted by Kash

 
One way to manage SQL Azure database is through SQL Server Management Studio. Using the Azure web portal, you can also management the following database operations: Create and modify tables Program Stored Procedures and functions...

Read More     |     Comments

Security considerations in SQL Azure


Apr 27, 2012 Posted by Kash

 
Before we dig deeper into SQL Azure Security, here are some basic concepts: Principal: This is an entity that can request SQL Azure resources. Principals can include sql logins (access to SQL Azure server) and database users (access to SQL Azure database) ...

Read More     |     Comments

How to rebuild an Index in SQL Azure using ALTER INDEX


Feb 11, 2012Posted by Kash

 
Indexes help with database performance. If you do not have an index on a table, SQL Azure has no choice but to use a Table Scan. If you do not know, Table Scan is slowest method of ...

Read More     |     Comments

What is SQL Azure? SQLAzureTutorials.com


Jan 25, 2012Posted by Kash

 
SQL Azure is a Relational Database Management System (RDBMS) in the Cloud. It is built on the SQL Server platform and has full support for using Transact SQL (TSQL) programming language ...

Read More     |     Comments

SQL Azure Reporting Server - Windows Azure platform


Nov 26, 2011Posted by Kash

 
Using SQL Azure Reporting, you can deploy a reporting solution to the Windows Azure platform environment. This solution will not only use data from the cloud SQL Azure ...

Read More     |     Comments

Transact SQL scripts - Azure SQL Database Video Tutorials


Nov 4, 2011Posted by Kash

 
As part of the Azure SQL Database Video Tutorials - Unlimited Package , we have added some Transact SQL scripts. These will help you in understanding Azure SQL Database and how to work with objects in the cloud database environment. Some of the SQL scripts are used to create objects like database, table, indexes, primary keys and foreign key constraints...

Read More     |     Comments

Database.com - Another database in the cloud


Sept 30, 2011Posted by Kash

 
Database.com is an enterprise level cloud database service offered by Salesforce.com. The platform is highly scalable so as your database needs grow with time, this cloud database system will scale up nicely...

Read More     |     Comments

How to build a SQL Server Reporting Services report with SQL Azure?


July 22, 2011Posted by Kash

 
SQL Server Reporting Services report with SQL Azure Today we are going to look at how to create a report with SQL Server Reporting Services (SSRS) and Microsoft SQL Azure. In this manner we are using the database...

Read More     |     Comments

SQL Azure Migration Wizard - How to Video


May 18, 2011Posted by Kash

 
9 Easy steps to Migrate SQL Server 2008 R2 to SQL Azure:

1. Download the migration and wizard utility from this location,

http://sqlazuremw.codeplex.com/

2. Installed the application on your database server and start the Migration wizard...

Read More     |     Comments

SQL statements not supported for Windows Azure SQL Database


Apr 21, 2011Posted by Kash

 
SQL statements not supported for Windows Azure SQL Database

When working with Azure SQL Database, you primarily have to work with Transact SQL (TSQL) instead of a graphic user interface. There is limited functionality that is available with "Project Houston"...

Read More     |     Comments

Using SQL Azure Data Sync - Data Synchronization in Cloud


Mar 11, 2011Posted by Kash

 
Using SQL Azure Data Sync - Data Synchronization in Cloud

Today we are going to look at another SQL Azure technology, SQL Azure Data Sync. This is a service built on Microsoft Sync framework technology. When you use SQL Azure data sync, you can not only synchronize databases...

Read More     |     Comments

Migrate to SQL Azure from SQL Server 2008


Feb 6, 2011Posted by Kash

 
Migrate SQL Server 2008 R2 to Microsoft cloud database SQL Azure:

If you're a small company, migrating your SQL server databases from an on-premise SQL Server 2008 to cloud SQL Azure service makes perfect sense. In such a manner you are able to cut some of the overhead you incur by having SQL Server...

Read More     |     Comments

Azure Tutorials - Coming Soon!!


Jan 11, 2011Posted by Kash

 
Azure Tutorials

We have training videos on SQL Azure and other Cloud Database topics. Please visit the page on SQL Azure Training. p.s. Training videos will be available after January 17, 2011...

Read More     |     Comments

Installing Windows SQL Azure Platform - Setup


October 14, 2010Posted by Kash

 
Installing Windows SQL Azure Platform - Setup

So I have been playing with SQL Azure for a few weeks, overall things are going well I would say. Not ...

Read More     |     Comments

How do I setup Azure SQL Database Server?


October 22, 2010Posted by Kash

 
How do I setup Azure SQL Database Server?

The first thing you need to do is setup a Windows Live account and then sign up for Windows Azure Online Services. We discuss this in this post so go ahead and check it out. Windows Azure Portal Once your account is setup you will need to log into the Windows Azure Portal. Here is the web address: http://www.microsoft.com/windowsazure/account/ We have included a screen capture of this down below: