Author Archives: sqlblog

Using Windows Azure Management Portal with SQL Database

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: … Continue reading

Posted in Administration, Cloud database, What is SQL Azure, Windows Azure Platform | Tagged , , | Comments Off

Windows Azure SQL Database – Tutorial video on Cloud database

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

Posted in How to Video, SQL Azure tutorials, Video Training, What is SQL Azure | Tagged , | Comments Off

Resources on Windows Azure SQL Database

There is quite a bit of resources on Windows Azure SQL Database. However these websites and resources are not listed in one single location. I figured we should have a short list of vital websites you need to know about … Continue reading

Posted in Uncategorized | Comments Off

SQL stored procedures in Windows Azure SQL database

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 the … Continue reading

Posted in Development, SQL Programming, TSQL | Tagged , | Comments Off

How to create Windows Azure SQL Database?

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 … Continue reading

Posted in Cloud database, SQL Azure tutorials, What is SQL Azure, Windows Azure Platform | Tagged , , , | Comments Off

How to create table in SQL Azure – Cloud Database

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 … Continue reading

Posted in Development, How to Video | Tagged , | Comments Off

Microsoft drops SQL Azure cloud database pricing

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 … Continue reading

Posted in Cloud database, Installation | Comments Off

Import data from SQL Server 2008 to SQL Azure

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 … Continue reading

Posted in How to Video, Migration, Video Training, What is SQL Azure | Tagged , , | Comments Off

How to create database objects in SQL Azure

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 … Continue reading

Posted in Development, SQL Programming, TSQL | Tagged , , | Comments Off

Windows Azure subscription: How to cancel SQL Azure subscription?

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 … Continue reading

Posted in Administration, Windows Azure Platform | Tagged , | Comments Off