Author Archives: sqlblog

Differences between Microsoft SQL Server and 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 server, SQL Azure is … Continue reading

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

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

SQL Azure Reporting Server – Windows Azure platform

Using SQL Azure Reporting, you can deploy a reporting solution to the Windows Azure platform environment. This solution will not only use data from the cloud SQL Azure database, you will also be deploying the actual Azure report up to … Continue reading

Posted in Reporting, SQL Azure tutorials, Windows Azure Platform | 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

ATTENTION Guest Bloggers:

ATTENTION Guest Bloggers: Please contact us at blog@sqlazuretutorials.com if you: -Would like to post SQL Azure or Cloud database related topics to our blog. This would be free advertising for you via a backlink to your site or blog! We … Continue reading

Posted in Cloud database | 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

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