SQL Azure Tutorials - Helping you with Cloud Databases
Welcome to our site on SQL Azure 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 SQL Azure and SQL Server.
Feel free to contact us at
kash@sqlazuretutorials.com
if you have any comments or suggestions.
How to create Windows Azure SQL Database?
May 2, 2013
Posted by
Kash
For this post, we are assuming you do not have a 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 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 database from Microsoft. We use CREATE TABLE sql command to create two tables.
Next we go over the Alter table command which can be used to add (ADD), modify (ALTER COLUMN) and delete columns
(DROP COLUMN) in an Azure SQL table...
Read More
|
Comments
Microsoft drops Windows Azure SQL Database pricing
January 18, 2013
Posted by
Kash
In terms of low cost structure for cloud database 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 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
- Stored procedure
If you want more information about our TSQL scripts on SQL Azure, plz visit this blog post...
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
Import and export data
Write and execute SQL statement
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)
Role: A role in SQL Azure is analogous to a group in Windows. So if the Accounting dept
has database users with the same level of permissions, it is better to create a role and
assign perms to it...
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
retrieving data from SQL. You can either have a clustered or a non-clustered index
in SQL azure...
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.
Unlike your local (On-premise) SQL server, SQL Azure is accessible via the Internet...
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
database, you will also be deploying the actual Azure report up to the cloud environment...
Read More
|
Comments
Transact SQL scripts - SQL Azure Video Tutorials
Nov 4, 2011Posted
by
Kash
As part of the
SQL Azure Video Tutorials
- Unlimited Package
, we have added some Transact SQL scripts.
These will help you in understanding SQL Azure 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. Other SQL statements include the DML commands like: INSERT, SELECT, UPDATE AND DELETE....
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.
In addition Database.com is highly available so you do not have to worry about a database server going down
as your databases are replicated throughout the server farm at Salesforce.com...
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 SQL Azure
When working with SQL Azure, 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"
that will give you somewhat of a basic user interface for working with SQL Azure. As such you need to
have a good grasp on Transact SQL...
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
between an on-premise SQL server and another one in the SQL Azure cloud environment, you can also synchronize
two or more SQL Azure databases between different cloud servers.
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
in house. You can also use the "Pay what you Consume" model which can be beneficial in database computing costs.
Finally you do not have to worry about high availability and redundancy as this feature is built into the cloud
databases from Microsoft SQL Azure....
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
having control over physical files and filegroups has been challenging but so
far so good. When I first tried to Install Windows Azure Platform, I was taken
to this following screen....
Read More
|
Comments
October 22, 2010Posted by
Kash
How do I setup SQL Azure Server and Database?
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
