{"id":25,"date":"2011-06-30T06:37:35","date_gmt":"2011-06-30T06:37:35","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2011\/06\/30\/benefits-and-features-of-sql-azure\/"},"modified":"2011-06-30T06:37:35","modified_gmt":"2011-06-30T06:37:35","slug":"benefits-and-features-of-sql-azure","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2011\/06\/30\/benefits-and-features-of-sql-azure\/","title":{"rendered":"Benefits and Features of SQL Azure"},"content":{"rendered":"<p><strong>Benefits of SQL Azure:<\/strong><\/p>\n<ul>\n<li>High availability<\/li>\n<li>\nHigh Fault tolerance<\/li>\n<li>\nability to create and deply of multiple number of databases<\/li>\n<li>\nSimilar to TSQL Used for SQL SERVER, hence makes its use easy<\/li>\n<li>\nPAY AS YOU GO Option for pricing helps users pay for what they use<\/li>\n<li>\nIntegration to SQL Server and Visual Studio<\/li>\n<li>\nScale up and down the databases as per requirement<\/li>\n<li>\nNo need to take care of Physical administration of the server<\/li>\n<\/ul>\n<p><strong>Features of SQL Azure:<\/strong><\/p>\n<ul>\n<li>Cloud based model<\/li>\n<li>\nSimilar to SQL Server<\/li>\n<li>\nSimilar TSQL Usage<\/li>\n<li>\nAbility to use tables, indexes, views,triggers, stored procedures, functions, roles etc<\/li>\n<li>\nExecution of Joins on multiple tables <\/li>\n<li>\nTransactions are allowed<\/li>\n<li>\nCreation of Temporary tables is allowed<\/li>\n<li>\nSystem functions like string,datetime are allowed<\/li>\n<li>\nSQL Azure Data Sync<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Benefits of SQL Azure: High availability High Fault tolerance ability to create and deply of multiple number of databases Similar to TSQL Used for SQL SERVER, hence makes its use easy PAY AS YOU GO Option for pricing helps users pay for what they use Integration to SQL Server and Visual Studio Scale up and&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[87],"tags":[],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/25"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=25"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/25\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=25"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=25"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}