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: 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: 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: Implementing Geographic Redundancy

    Geographic redundancy is a fancy word for distributing your data across multiple data centers globally. One way to accomplish this is to spread your data across many SQL Azure data centers using Data Sync Service for SQL Azure to synchronize a hub database to many global member databases. SQL Azure has...
  • Blog Post: PowerPivot for the DBA: Part 1

    In this article I am going to tie some simple terminology and methodology in business intelligence and PowerPivot with Transact-SQL – bring it down to earth for the DBA. You don’t need to know Transact-SQL to build awesome reports with PowerPivot, however if you already do these articles will attempt...
  • Blog Post: WinForm Application Streaming from SQL Azure

    In this blog post, we are proving code for a sample WinForm application that streams images from SQL Azure to a PictureBox control. Our goal is to show how you can stream large BLOB data from a varbinary(max) column in SQL Azure to the WinForm application, in this case, an image. One of the nice things...
  • Blog Post: Copying Files to SQL Azure BLOBS

    I have written a simple console application (run from the command line) to upload multiple BLOBs from files into SQL Azure. This article discusses how it works, provides a complete Visual Studio solution of the console application and the source code in case you want to modify the code to meet your needs...
  • 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: Writing BLOBs from SQL Azure to Windows Azure Storage

    One of the more interesting things that we can do with the SqlStream class introduced in this blog post is to write to Windows Azure Storage from SQL Azure. Windows Azure storage provides persistent, durable storage in the cloud. To access the storage services, you must have a storage account, created...
  • Blog Post: Streaming Blobs To and From SQL Azure

    Because of the remoteness of SQL Azure it is beneficial to have some tricks in your coding toolbox for dealing with large binary objects, the varbinary(max) data type in SQL Azure. One of these is to be able to stream large binary objects (BLOB) -- reading or writing a piece of the data at a time. ...
  • 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: 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: Vertical Partitioning in SQL Azure: Part 1

    SQL Azure currently supports 1 GB and 10 GB databases. If you want to store larger amounts of data in SQL Azure you can divide your tables across multiple SQL Azure databases. This article will discuss how to use a middle layer to join two tables on different SQL Azure databases using LINQ. This technique...
  • Blog Post: Connections and SQL Azure

    When using a web enabled database like SQL Azure, it requires connections over the internet or other complex networks and because of this, you should be prepared to handle unexpected dropping of connections.  Established connections consist of: connections that are returning data, open connections...
Page 1 of 1 (21 items)