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.
- -One was for databases that are smaller in size between range of 50 – 100 MB in size.
- -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:
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
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
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
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
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
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
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
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
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:
Read More
|
Comments
