Category Archives: Development

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

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

Manage a SQL Azure database via the portal

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

Posted in Administration, Development, What is SQL Azure | 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

How to build a SQL Server Reporting Services report with SQL Azure?

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

Posted in Development, Reporting | Tagged , , , | 1 Comment