Access "Are we there yet? The slow road to SQL Azure "
This article is part of the August 2010, Vol. 3 issue of Exploring SQL Azure features and opportunities
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 such as transactions or temp... Access >>>
Access TechTarget
Premium Content for Free.
What's Inside
Features
-
-
Where to look next for BI applications? Try the cloud
by Roman Rehak, Contributor
PowerPivot, SQL Azure and ‘Dallas’ combine to create BI applications in the cloud. Is that integration seamless and is it even for you?
-
Are we there yet? The slow road to SQL Azure
by Eric Johnson, SQL Server MVP
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.
-
Where to look next for BI applications? Try the cloud
by Roman Rehak, Contributor
-
-
Pros and cons of the DACPAC with SQL Server 2008 R2
by Denny Cherry, Contributor
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.
-
Pros and cons of the DACPAC with SQL Server 2008 R2
by Denny Cherry, Contributor
More Premium Content Accessible For Free
Understanding Microsoft SQL Server business intelligence options
E-Handbook
Microsoft has made a great effort to turn SQL Server into a viable enterprise database platform, and part of that has been boosting its business ...
SQL Server and big data strategies
E-Book
Microsoft has worked to address the big issue of "big data," as companies are dealing with a constant influx of digital information. SQL Server is no...
Should you upgrade to SQL Server 2012?
E-Zine
Are you going to upgrade to SQL Server 2012? This edition of SQL Server Insider sets out to help you decide whether the investment is worth it or not...