Access your Pro+ Content below.
Are we there yet? The slow road to SQL Azure
This article is part of the August 2010, Vol. 3 issue of SQL Server Insider
If an application doesn’t run on a smartphone or in the cloud, it seems that no one pays much attention to it. So it's only natural that Microsoft would push to put SQL Server Database Services in the cloud. Enter SQL Azure, Microsoft’s cloud-based SQL Server platform. SQL Azure gives enterprises relational database management system (RDBMS) features at a fraction of the cost of buying hardware and licenses for their own in-house SQL Server instances. But is SQL Azure ready to replace a full-blown SQL Server installation? Recent Microsoft announcements hint about the second major release of SQL Azure, it’s still uncertain how much further product development needs to advance before the cloud technology can replace in-house SQL Server instances. What’s to gain with SQL Azure? SQL Azure offers true SQL Server functionality; you can create tables, views, indexes, stored procedures, triggers and functions. Security exists through logins as well as user and database roles. And you can execute complex queries that use standard ...
Features in this issue
PowerPivot, SQL Azure and ‘Dallas’ combine to create BI applications in the cloud. Is that integration seamless and is it even for you?
Data-tier applications are among SQL Server 2008 R2’s most talked-about new features, though version-one limitations could minimize their impact in the short term.
SQL Azure offers full-blown SQL Server functionality in the cloud and could ease management and development. But whether it’s ready to fully replace SQL Server remains to be seen.