Browse by Tags - SQL Azure Team Blog - Site Home - MSDN Blogs

Browse by Tags

Tagged Content List
  • Blog Post: Create a Numbers Table in SQL Azure

    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...
  • Blog Post: Compression for Speed and Cost Savings

    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 discuss how to do...
  • Blog Post: The Cost of a Row

    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 cost of a row in a table. Imagine that you are running...
  • Blog Post: Transferring a SQL Azure Database

    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 Portal administrator name and password...
  • Blog Post: Creating a Bing Map Tile Server from Windows Azure

    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; these tiles can be generated dynamically from a Windows...
  • Blog Post: How to Tell If You Are Out of Room

    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 is not done automatically. This article will...
  • Blog Post: Using SQL Azure for Session State

    Since I wrote this post in 2010, Microsoft has come out with an offically supported version of ASP.NET sessions that run on SQL Azure. The ASP.NET Universal Providers extend Session, Membership, Roles and Profile support to SQL Compact Edition and SQL Azure. This is the recommend approach. Hypertext...
  • Blog Post: I Miss You SQL Server Agent: Part 3

    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 compare to SQL Server Agent, and got started...
  • Blog Post: I Miss You SQL Server Agent: Part 2

    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 compare to SQL Server Agent, and got started...
  • Blog Post: I Miss You SQL Server Agent: Part 1

    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 agent man, secret agent man They've given you...
  • Blog Post: Programmatically Changing the Firewall Settings

    SQL Azure has two types of access control: SQL Authentication logins and passwords and a server side firewall that restricts access by IP address. This blog post will discuss how to programmatically modify the firewall settings. For information about programmatically creating logins, see this blog post...
  • Blog Post: Improving Your I/O Performance

    As a DBA I have done a lot of work improving I/O performance for on-premise SQL Server installations. Usually it involves tweaking the storage system, balancing databases across RAID arrays, or expanding the count of files that the tempdb is using; these are all common techniques of SQL Server DBA. However...
  • Blog Post: Adding Users to Your SQL Azure Database

    When you generate a SQL Azure server via the SQL Azure portal , you generate a user name and password at the same time. This is your administrative account it has access to all databases on that server. However, you might want to give other people access to some or all of your databases on that server...
  • Blog Post: Creating a SQL Azure Database with SQLCMD

    Once you have your server allocated via the SQL Azure Portal you can create and drop databases from your desktop’s command line using sqlcmd.exe. This can be handy for clean slate testing where you want to create a database from scratch, unload a schema and then do some testing in a repeatable way. One...
  • Blog Post: Finding Your Clustered Indexes

    Before migrating your SQL Server schema to SQL Azure, you need to create a clustered index on every table. You can read about why in this blog post . In this post, we will show how to find all the tables that don’t have a clustered index. One of the techniques for migration is to update your SQL Server...
  • Blog Post: Unicode Works Better With SSIS

    Now that you have decided to move your SQL Server data to SQL Azure, it is a good time to change your varchar(max) and text data types to nvarchar(max) . Changing your data types to Unicode will make your migration from SQL Server to SQL Azure easier when using SQL Server Integration Services (SSIS)...
  • Blog Post: SQL Azure and Session Tracing ID

    If you have been paying close attention, you will have noted that SQL Server Management Studio 2008 R2 has added a new property for connections to SQL Azure -- the Session Tracing ID. A session tracing identifier is a unique GUID that is generated for every connection to SQL Azure. On the server side...
  • Blog Post: SQL Azure Database Now Generally Available – SLAs in effect

    Starting today, customers and partners in countries across the globe will be able to launch their SQL Azure Database production applications and services with the support of the full Service Level Agreements (SLAs). Customers who have yet to upgrade their CTP accounts to paid commercial subscriptions...
  • Blog Post: Updated CTP for SQL Azure Database includes complete feature set for PDC 2009!

    A few short weeks ago we announced the SQL Azure Database August CTP. Since the announcement, tens of thousands in the community have signed up for the service and have provided us with a tremendous amount of positive feedback. Today, the SQL Azure Database October CTP (CTP 2) update is another major...
  • Blog Post: Try SQL Azure Database CTP Today

    Check out the free trial of Microsoft® SQL Azure Database Community Technology Preview (CTP). SQL Azure Database, a part of the Windows Azure platform, is a cloud-based database service built on Microsoft SQL Server technology. With SQL Azure organizations will benefit from a pay-as-you grow model...
  • Blog Post: The no spin details on the new SDS features

    Today we announced the details of our plans to accelerate the delivery of core relational database features as part of SDS. There has been quite a bit of buzz about SDS over the past couple weeks and it is great to be able to share the details more broadly. If we flash back about a year ago to Mix...
Page 1 of 1 (21 items)