Create a Numbers Table in SQL Azure

[This article was contributed by the SQL Azure team.] Often you may require number table for various purposes like parsing a CSV file into a table, string manipulation, or finding missing identities (see example below), etc. Numbers tables are used to increase performance (by avoiding cursors) and simplify queries. Because SQL Azure requires all tables…

0

Compression for Speed and Cost Savings

[This article was contributed by the SQL Azure team.] SQL Azure doesn’t currently support page level or row level compression like the enterprise edition of SQL Server 2008. However, you can implement your own column level compression in your data access layer to take advantage of the performance and cost savings of compression. I will…

0

The Cost of a Row

[This article was contributed by the SQL Azure team.] In a previous blog post I covered how to calculate the cost of a covered index, allowing you to evaluate if the performance of the covered index was worth its monthly cost. In this blog post I am going to use Transact-SQL to calculate the average…

0

Transferring a SQL Azure Database

[This article was contributed by the SQL Azure team.] The original blog post doesn’t work as written, since the destination user executing the CREATE DATABASE must have exactly the same name as SQL Azure Portal Administrator name on the source database; i.e. you can only copy from a database where you know the SQL Azure…

0

Creating a Bing Map Tile Server from Windows Azure

[This article was contributed by the SQL Azure team.] In this example application, I am going to build a Bing Maps tile server using Windows Azure that draws push pins on the tiles based on coordinates stored as spatial data in SQL Azure. Bing Maps allows you to draw over their maps with custom tiles;…

0

How to Tell If You Are Out of Room

[This article was contributed by the SQL Azure team.] SQL Azure databases are capped in size; one reason for this is that we don’t want to send you a surprise bill if your data grows beyond your expectations. You can always increase or decrease the cap of your database (up to 50 Gigabytes); however this…

0

Using SQL Azure for Session State

[This article was contributed by the SQL Azure team.] Hypertext Transfer Protocol (HTTP) is a stateless protocol; the advantage of a stateless protocol is that web servers do not need to retain information about users between requests. However, in some scenarios web site developers want to maintain state between page requests to provide consistency to…

0

I Miss You SQL Server Agent: Part 3

[This article was contributed by the SQL Azure team.] Currently, SQL Azure doesn’t have the concept of a SQL Server Agent. In this blog series we are attempting to create a light-weight substitute using a Windows Azure worker role. In the first blog post of the series, I covered how the Windows Azure worker roles…

0

I Miss You SQL Server Agent: Part 2

[This article was contributed by the SQL Azure team.] Currently, SQL Azure doesn’t have the concept of a SQL Server Agent. In this blog series we are attempting to create a light-weight substitute using a Windows Azure Worker role. In the first blog post of the series, I covered how the Windows Azure worker roles…

0

I Miss You SQL Server Agent: Part 1

[This article was contributed by the SQL Azure team.] Currently, SQL Azure doesn’t support running SQL Server Agent in the cloud. If you need SQL Server Agent type functionality for SQL Azure, you can use a Windows Azure worker role and some custom code, I will show you how in this blog post series. “Secret…

0