Tuesday, December 22, 2009

Getting Started with SQL Azure, create your first SQL database in the cloud.



Microsoft® SQL Azure™ Database is a cloud-based relational database service built on SQL Server® technologies. As said by Microsoft SQL Azure should:
  1. Provide a highly available, scalable, multi-tenant database service hosted by Microsoft in the cloud. SQL Azure Database helps to ease provisioning and deployment of multiple databases.
  2. Developers do not have to install, setup, patch or manage any software.
  3. High availability and fault tolerance is built-in and no physical administration is required.
  4. SQL Azure Database supports Transact-SQL (T-SQL). Customers can use existing knowledge in T-SQL development and a familiar relational data model for symmetry with existing on-premises databases.
  5. SQL Azure Database can help reduce costs by integrating with existing toolsets and providing symmetry with on-premises and cloud databases.
These statements sounds very promising. Therefor I started creating a SQL Azure database in the cloud to see the current status of the cloud-based relational database service.

First of all you need a SQL Azure account. Request an invitation code for yourself.  Within one day you will receive the invation code which enables you to create your own SQL Azure Server. To create a server you need to specify and Administrator Username and an Administrator Password.

Now your server is created with one database: Master.
To access this server you need to configure the firewall settings. Press on the Firewall Settings tab and click on checkbox "Allow Microsoft Services acccess to this server". Select the Rule MicrosoftServices and press the Edit Rule button. Now you can specify the range of IP adresses which are allowed to connect to your Azure Server. In my example I have configured all IP addresses.





Now we will create the first database. Select the Databases tab. Press Create Database, Specify a database name and the size of the database. You can choose between 1 Gb and 10 Gb.



Press the Test Connectivity button to test the connection. You MUST have the MicrosoftServices Firewall rule enabled in order to use this feature. Your database is created and you are ready to connect with the SQL Server Management Studio (SSMS). For the Object Explorer you have enter the Server name and Login credentials.



To open a new query you need to specify the database you want to connect. This canbe done in the connection propertie tab. The USE command is not supported for switching between databases. Establish a connection directly to the target database.




Now you are connected.





Enjoy using SQL Azure.

11 comments:

joellreyy87 said...

Regardless sort of the college schoolwork task you need to submit, fail to remember every one of the concerns and let our particular college do my assignment for me online task aces help you for better grades. We can furnish you with college schoolwork composing administrations for all areas, subjects and in different types and styles!

Ariel Wilson said...

I'm currently working on a research data collection services assignment given by my University and your provided guide about a SQL database helped me a lot in keeping my data collection as simple as possible.

thisisemliyblunt said...

Quick reply to any of my questions and very lovely people ready to help you ASOS Discount Code. I can’t recommend enough.

Unknown said...

Wow! This is very helpful post for the needy ones. Therefore, I think it should be shared to more and more people so it can be reached to the needy people. believe me, I even wish to share it at this moment, but first I will have to look for dissertation proofreading services for my dissertation writing task. I promise, I will get free soon and will share it.Yellowstone Season 4 Moses Brings Plenty Jacket

Douglas Davis said...

I remember having nothing to do when Covid put our country on lockdown. I started researching several field to offer services like dissertation discussion writing help UK. I ultimately began looking for occupations and discovered SQL as being my kind. I now work as a SQL professional.

Anna Stanley said...

Great artile, here's one of them Top 10 Best Assignment Writing Websites

Phil Smith said...

I will start learning SQL after coming back from Dubai city tour. I think this field will grow even more in future.

Unknown said...

Leave our college without thinking about all your concerns, regardless of what kind of college assignment you need to submit.Reliable nursing assignment writing task aces help you for better grades. We can furnish you with college schoolwork composing administrations for all areas, subjects and in different types and styles!



Henryjones said...

Got here after completing my dissertations with the experts who have assisted me with expert dissertation writing services. event management topics has assisted me fully and is helping thousands of students do their dissertations on time.

Thomas Max said...

Microsoft® SQL Azure™ Database, a cloud-based relational database service rooted in SQL Server® technologies, offers unparalleled scalability and flexibility. As asserted by Microsoft, SQL Azure ensures seamless data management, high availability, and robust security. This innovative solution aligns seamlessly with the evolving landscape of dissertation writing service, providing a reliable and efficient platform for managing complex databases essential to academic research and content creation.

Thomas Max said...
This comment has been removed by the author.