Check out the free trial of Microsoft® SQL Azure Database Community Technology Preview (CTP). SQL Azure Database, a part of the Windows Azure platform, is a cloud-based database service built on Microsoft SQL Server technology. With SQL Azure organizations will benefit from a pay-as-you grow model with enterprise-class availability, data protection, scalability, and security.
Also available as a CTP is the SQL Server Driver for PHP 1.1, which provides new capabilities for building PHP applications and support for SQL Azure, enabling developers to build PHP apps with relational database capabilities using SQL Server or SQL Azure Database. The CTP for the SQL Server Driver for PHP is available for download today.
With the explosion of data-driven Web 2.0 applications, along with the need to extend existing applications and build innovative data solutions in the cloud – these are exciting milestones. With SQL Azure, developers building Web 2.0, ASP.NET and PHP applications can use familiar tools and data models to develop on a pay-as-you-grow, secure, scalable and highly available database service at minimal infrastructure cost. In fact, there are really no comparable solutions available today --- we are leading the industry by offering a relational database service. When hosting your application in Windows Azure and with SQL Azure as your cloud database, building credible, reliable cloud-based applications becomes very easy.
The SQL Azure Database CTP includes:
· Relational data model supporting Transact-SQL (T-SQL), including T-SQL stored procedures. Access SQL Azure with familiar data access APIs such as ODBC, ADO.Net, PHP, etc. The high degree of compatibility with SQL Server enables easy migration of existing Line of Business (LOB) or Web applications to the cloud.
· Self-provisioning, auto-healing and disaster recovery, with high availability and no physical database administration. Self service provisioning means you can provision any number of databases and not have to worry about machines, disks, or server configuration.
SQL Server Driver for PHP CTP will include:
SQL Azure Database will be available as a free trial until the service goes live in November. SQL Azure Database will be available in two editions: Web Edition, which will include up to 1 GB of relational data, priced at $9.99 per month, and Business Edition, which will include up to 10 GB of data, priced at $99.99 per month.
Need to confirm you'll be sending email to prior SSDS/SDS users with a token. Any closer estimate on the backlog than in your reply to Jamie Thomson in the forum?
See my post at http://bit.ly/2yLesd.
I believe this makes Azure a far more complete platform and hope it now encourages the on-boarding of existing apps that rely on SQL
We have been waiting for this release for a very long time. Congratulations to everyone who has worked to deliver it.
I look forward to seeing what our developers make of it in the weeks ahead.
(once we get the codes that is :-)
Thank you for all of your efforts - this is amazing for anyone who has tried to deploy scalable systems.
I'm still having problems "joining the mailing list" or "registering for the CTP" - but I know that's just a Microsoft Connect issue - thank you again.
will sql azure support nhibernate? i have an existing app on nhibernate that i want to port onto azure, but the db side has been a sticking point.
Will SQL Server 2008 fulltext features be available in the future?
Congrats for SQL Azure! I believe it's the first in a new class of indispensable products for the future architectures. Hope MS will just deliver to the promises ... or at least won't promise too much :)
Few questions about the performance or internal architecture of the next features: auto-healing, disaster recovery and high availability. I haven't found much about how these important features of the Azure database are achieved. If this is already explained somewhere else, it would be great if you could post the link. The SQL Azure white paper doesn't really go into details. Also a blog post here would be so welcomed!
1. The list of features suggest that the database is replicated in a master-master model. Is this true? If Yes, then probably a Two-Phase commit (2PC) strategy is used, which is know to hurt the performance of transactions a bit.
2. Is it possible to disable the replication to improve performance of transactions?
3. What is the effort involved in having the production architecture start using the second database in the event of a failure? Is the failover performed automatically?
4. Can I disable the internet connectivity to the database and maintain only connectivity from Windows Azure?
5. Is there any performance optimization when I'm accessing the database only from web services hosted with Windows Azure? Could we expect decent network trafic optimization, comparable to a LAN?
Today I simply tried to script an existing table under SQL Server 2008 and then run the generated script in a query in SSMS and received many errors.
It would be nice to have a stored proc to script database objects in a SQL Azure compatible T-SQL so we can simply migrate many tables from on premises SQL Server 2008 to SQL Azure.
Loading data was relatively easy.
To help move database objects to SQL Azure databases would it be a good idea to use the “Publish to provider…” from Visual Studio 10 or SSMS.
Awesome post. Here’s a tool that lets you build your cloud database apps without coding http://www.caspio.com/