Windows Azure and SQL Azure Use Cases

Those of you who know me know that I am very interested in helping you take advantage of applications and design patterns that fit the cloud (See this blog post.) Buck Woody has recently published an on-going series of Windows Azure and SQL Azure Use Cases that you may find helpful. Here are some of…


SQL Server Data-tier Application Framework Eases Database Management

The Data-tier Application Framework (DAC Fx)  is a set of tools, API’s and services designed to dramatically simplify the development, deployment and management of SQL Server and SQL Azure database schemas. DAC Fx was introduced in SQL Server 2008 R2 as part of an improvement category known as “Application and Multi-Server Management” (AMM). It’s a…


Windows Phone 7 / Windows Azure – How-to Video

Last month we posted about Wade Wegner’s Windows Phone 7 / Windows Azure Toolkit in our blog post: Windows Phone 7 and Windows Azure – Perfect Together.  This toolkit adds templates into visual studio that allow you to generate a Windows Phone 7 app with a SQL Azure cloud based database.  The significance of this…


Microsoft SQL Azure Federations Product Evaluation Program

What are SQL Azure Federations? Federations are objects that allow scaling-out of data for building data tier applications with unlimited scalability and best price-performance.  For more details on Federations in SQL Azure, please check this TechNet article.     Sharding provides: Unlimited Scalability:  Federations enable horizontal partitioning or ‘sharding’ of data across many nodes to…


Database Import and Export for SQL Azure

SQL Azure database users have a simpler way to archive SQL Azure and SQL Server databases, or to migrate on-premises SQL Server databases to SQL Azure. Import and export services through the Data-tier Application (DAC) framework make archival and migration much easier. The import and export features provide the ability to retrieve and restore an…


Feeling constrained by the 50GB SQL Azure Limit? Try Sharding

Database Sharding is a way to partition multiple SQL Azure databases to get around the 50GB maximum database size limit.  Using this technique you can implement a scale-out network of SQL Server databases that can handle massive capacity requirements. Michael Heydt from Sungard has produced an outstanding tutorial on the subject.    In the tutorial…


Choosing between SQL Server, SQL Azure, SharePoint and Access

               Microsoft provides a rich set of database technologies that can be use to implement on-premise and cloud based products and services.  The question of which tool to use for a given scenario often comes up. This well thought-out white paper lists the pros and cons of each one and the reasons…


Cloud Power on Ignition Showcase

For those ISVs that want to come up to speed quickly on Microsoft’s Cloud initiatives, here is a summary of the Cloud related posts that have appeared in the Ignition Showcase blog recently.  The posts are categorized by: General Cloud Public Cloud Private Cloud 1. General Cloud An ISV in the Age of the Cloud …


Applied Architecture Patterns on the Microsoft Platform Reviewed

I just finished reading an excellent book:  Applied Architecture Patterns on the Microsoft Platform by Seroter, Fairweather, Thomas, Sexton and Ramani. (PACKT Publishing 2010.)  IMHO this is a book that all ISVs and other developers basing their solutions on Microsoft technology should read. Although not physically divided into parts, logically the first “part” of the…


SQL Azure Raises the Cloud Database Bar

In my last post I talked data storage options for cloud applications including SQL Azure.    SQL Azure takes the power of SQL Server to the cloud allowing you to leverage relational data as you do today. See what is being said about SQL Azure and how it fits into the cloud in this Forrester report.  …