I want to start out a series on what SQL Azure is, benefits and pitfalls, On premises vs Cloud data and so on. There are a bunch of cool benefits with putting the data in the cloud if your application resides there, SQL Azure delivers a high scalable, high performance and highly secure method of working with data for cloud services. Of course we still need our on premises, sql boxes, bare metal or virtual. But for online services the cloud delivers the technologies for us. And now also a highly competent SQL service.
SQL Azure got commercially available on the 17th of november well aligned with the Pre-Developer Conference in Los Angeles. Unfortunally I wasn't there drue to TechEd in Berlin and business. But I had alot of friends attending and speaking there, as with online content, so I guess in time I'll get all the goods from the event. Maybe next year...
SQL Azure is available in two editions, Web (1GB) and Business(10GB). To get you started you need to know how to create the database.
So here it is: (Snip out from books online)
CREATE DATABASE (SQL Azure Database)
Syntax
CREATE DATABASE database_name [(MAXSIZE = [1 | 10] GB )][;]
Arguments
- database_name
-
The name of the new database.
- MAXSIZE
-
Specifies the maximum size of the database. In this release, SQL Azure provides two database sizes for users: 1 GB or 10 GB. If the MAXSIZE is not set, a default value of 1 GB is used.
This syntax diagram demonstrates the supported arguments in Microsoft SQL Azure Database.
SQL Azure does not support the following arguments and options when using the CREATE DATABASE statement:
- Parameters related to the physical placement of file, such as <filespec> and <filegroup>
- COLLATE on a user database
- External access options, such as DB_CHAINING and TRUSTWORTHY
- Attaching a database
- Service broker options, such as ENABLE_BROKER, NEW_BROKER, and ERROR_BROKER_CONVERSATIONS
- Database snapshot
Remarks
Databases in SQL Azure have several default settings that are set when the database is created.
CREATE DATABASE statement must be the only statement in a SQL batch.
Read more on SQL Azure, http://msdn.microsoft.com/en-us/library/ee336279.aspx.
Subscribe