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.
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
