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.

21 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.
daynaswitzer said...

Great guide on getting started with SQL Azure! Ensuring data integrity and security is crucial when working with cloud databases. For those looking for robust solutions, I recommend secure hosting with ECC Memory from Mikro Cyber. ECC Memory helps prevent data corruption and improves reliability, which is essential for maintaining your SQL Azure databases. Mikro Cyber’s hosting services offer the perfect blend of security and performance for all your database needs.



Marisa Eckert said...

Great guide on getting started with SQL Azure! In a similar vein, just as SQL Azure helps streamline database management, Palco Specialties' theater set design cubes simplify the process of creating dynamic stage setups. These cubes are versatile tools for school productions, enabling easy and flexible stage designs. Leveraging such innovative solutions can significantly enhance efficiency and creativity in both tech and theater environments.

anthonygranger said...

Vicarious liability involves holding one party accountable for another's actions, similar to how Al Karim Fabric ensures the quality of Cross Stitch Ready To Wear collections. Just as companies must maintain standards and accountability, understanding SQL Azure helps in managing data efficiently. Both concepts emphasize the importance of oversight and control, ensuring the final product or service meets high standards.


Franklinroberts said...

SQL Azure is a powerful tool for creating your first cloud-based SQL database. As more businesses move to the cloud, having a robust online presence is essential. At Branex, a leading web design company Dubai, we understand the importance of creating websites that integrate seamlessly with modern technologies like SQL Azure. We help businesses build responsive, secure, and scalable websites that enhance their digital footprint while utilizing cloud solutions efficiently.







Franklinroberts said...

When starting with SQL Azure, it's essential to work with reliable tech partners to ensure smooth deployment and management. If you're looking for an app development company, Branex in the UAE offers top-tier services to help you create custom mobile applications integrated with powerful back-end databases like SQL Azure. Their expertise makes the app development process efficient, just like how SQL Azure simplifies database management in the cloud.




Johntaylor said...

Creating your first SQL database in SQL Azure is a great way to get started with cloud computing. With just a few clicks, you can set up a scalable, secure database for your applications. However, mastering cloud databases can be overwhelming for students. If you're preparing for an exam and need assistance, Take My Online Exam offers services where you can request to "take my online exam for me" and get expert help.






richardgoss said...

Setting up your first SQL database in SQL Azure can be a great experience, but it also requires a deep understanding of cloud technologies and database management. For students who find this challenging, UK Assignment writers at UK assignment help can provide valuable assistance. They offer expert guidance to help you understand SQL Azure concepts while delivering top-notch assignments that meet UK academic standards. Whether it's database creation or complex queries, they've got you covered!






Calvin said...

Great introduction to getting started with SQL Azure! Just like cloud databases offer seamless scalability and flexibility, canvas UV printing at Vibrant Colour in Pakistan provides customizable, high-quality printing solutions for artwork and advertising. With UV printing technology, we deliver vibrant, long-lasting results on canvas, making it perfect for businesses looking to stand out with striking visuals, much like the efficiency of cloud-based databases in scaling your operations.






jameshyman said...

Getting started with SQL Azure is simple! You can create your first SQL database in the cloud by setting up an Azure account, selecting SQL Database, and configuring your server and database settings. Just like how Snus Dubai offers innovative products like energy pouches, Azure provides cutting-edge cloud solutions that are scalable and efficient. Whether managing nicotine products or databases, having the right tools is essential for success.






Joseph said...

Great advice on keeping things efficient and effective! Simplicity and speed are also key in modern dental treatments, like laser fillings for cavities. For anyone in Karachi, The Dental Clinic offers advanced options, including laser filling of teeth cost in karachi at competitive prices. This technology ensures precision and minimal discomfort. If you’re interested in a quick and comfortable way to treat cavities, it’s definitely worth checking out their services!