Category Archives: Administration

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

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