Category Archives: SQL Programming

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

How to rebuild an Index in SQL Azure using ALTER INDEX

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

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

Transact SQL scripts – SQL Azure Video Tutorials

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

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

Database.com – Another database in the cloud

Database.com – Another database in the cloud 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 … Continue reading

Posted in Cloud database, Database.com, SQL Programming | Tagged , , | Comments Off

SQL statements not supported for SQL Azure

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

Posted in SQL Programming | Tagged , , | 3 Comments