Category Archives: TSQL

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

Security considerations in SQL Azure

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

Posted in How to Video, Security, SQL Azure tutorials, 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

What is SQL Azure? From SQL Azure Tutorials.com

What is SQL Azure? 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 … Continue reading

Posted in Cloud database, SQL Azure tutorials, TSQL, What is SQL Azure | 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