BACKGROUND IMAGE: iSTOCK/GETTY IMAGES
Many large companies have been hesitant about moving data and systems to the cloud, citing concerns about security, availability and expediency. Windows Azure SQL Database, the renamed version of SQL Azure, is Microsoft's cloud database service, and it has become an essential component of Windows Azure. According to experts, if database administrators (DBAs) continue to follow standard security practices, businesses can still maintain control of data, even in the SQL Azure cloud. In fact, the Azure cloud computing platform includes built-in security measures, including a strong firewall.
Developments in SQL Azure Federations enable companies to scale out, improving storage and accessibility for larger and larger quantities of data. With Windows Azure SQL Database, Microsoft is aspiring to provide an infrastructure for petabyte-sized big data, expanding beyond the basic cloud database service. And while it offers support for high availability, fault tolerance and data synchronization, SQL Azure falls short in some areas as well. For example, it does not include the whole set of T-SQL extensions. Also, reporting, outbound data and other services incur additional charges.
This guide offers a comprehensive look at Windows Azure SQL Database, exploring its beginnings and the evolution of its features. The stories below examine the benefits and drawbacks of SQL Azure, offer insider tips for managing this technology and discuss early best practice recommendations.
Becoming Windows Azure SQL Database
While Microsoft's database in the cloud, formerly known as SQL Azure, is not new, it continues to change and add new features. Now known as Windows Azure SQL Database, this evolving technology offers a scaling service called SQL Azure Federations. The articles in this section discuss the pros and cons of Windows Azure SQL Database and offer tips on how to get the most out of the services it offers.
This article offers a discussion of the most crucial advantages of using SQL Azure. Continue Reading
Azure SQL Database may not be the best choice for everyone. This article examines the cons. Continue Reading
Learn how to scale out your database with Microsoft's SQL Database Federations service. Continue Reading
In part two, the author explains splitting the federation root member table, the last step in the T-SQL management of SQL Azure Federations. Continue Reading
2Migration and management-
Tips for migrating to and managing SQL Azure
Migrating to SQL Azure and maintaining security are relatively easy. Most IT departments can manage its many functions while enhancing business intelligence by taking advantage of tips and tools available. These stories offer advice for better migration and management, as well as workarounds that address limitations in earlier incarnations of SQL Azure.
Learn what it takes to manage the SQL Azure Database platform. Continue Reading
Learn about the report-hosting and rendering service built on the Windows Azure platform, SQL Azure Reporting. Continue Reading
Enterprise customers are more hesitant than independent software vendors when it comes to SQL Azure cloud computing. This article explains why. Continue Reading
3Azure SQL early on-
Exploring SQL Azure capabilities and development
Windows Azure SQL Database began as a basic cloud database technology, and many developers found that several familiar aspects of SQL Server development did not work with Azure in its first version. The articles in this section look at SQL Azure features such as Data Sync and SQL Azure Migration Wizard, offering perspectives from early users of this technology.
Learn how to execute a scheduled task in SQL Azure the simple way: Use a local SQL Agent to execute a SQL Server Integration Services (SSIS) package on the SQL Azure server. Continue Reading
Glossary of SQL Azure terms
Review these definitions to enhance your understanding of SQL Azure.
SQL Azure Quiz
How well do you know Windows Azure SQL Database? Take this brief quiz and test your knowledge.Take the quiz!