Naming Azure SQL Servers

As technology advances and organizations grow, cloud computing and hosting are becoming  a part of our organizations more and more.  One of the new offerings by Microsoft is their Azure platform with one of the services being the Azure SQL database.  While working with the Microsoft Azure platform during a recent project, I discovered the ability to name your own Azure SQL server in the Azure Preview Portal, a feature that isn’t available in the Azure Management Portal. I’d like to share this feature with you. 

If you have ever worked within the Azure Management Portal, you’ll know this is where you can maintain your entire cloud organization, such as web apps, cloud services, virtual machines, and, of course, SQL databases.  Creating a SQL database server in the Azure Management Portal is very easy;  you simply navigate to the SQL Databases tab, select the Servers tab, click ADD, and then provide the administrative login/password and desired region.  You might think, “That was easy, but what about the name?”  Unfortunately, in the Azure Management Portal, the name is generated for you, and you end up with a database server name of random characters.

Corey_BlogPost4_Pic1.png 

Corey_BlogPost4_AddDelete.png

 

 

 

Corey_BlogPost4_Pic2.png

Corey_BlogPost4_Pic3.png

Corey_BlogPost4_AddDelete.png

As shown above, I ended up with ‘faf6ul2205’ as my database server.  The days of naming your servers to decipher between production, test, and development are over… or are they?  Let us jump over to the Azure Preview Portal and take a look there.

If you have ever worked within the Azure Preview Portal, you’ll find that it is built with a layout that is user friendly for tablets and phones.  What isn’t as obvious initially is that you still have the same ability to maintain your entire cloud organization here.  Creating a SQL database server here is just as easy, but at first glance when you navigate to the SQL servers tab, it just has a list of existing servers and no option to add a new one. However, if you go to the SQL databases tab, you see an option to add a database. 

Corey_BlogPost4_Pic4.png

You might ask how you can add a database without a database server. It’s  simple. During the steps to create your new SQL database, you have the chance to either create a new server or use an existing server.

Corey_BlogPost4_Pic5.png

Corey_BlogPost4_Pic6.png

Corey_BlogPost4_Pic7.png

Once you select the option to create a new server, you see similar options to those you saw in the Azure Management Portal. However, this time you see a server name.

Corey_BlogPost4_Pic8.png

Corey_BlogPost4_Pic9.png

Corey_BlogPost4_Pic10.png

Alas, you can again name your own database servers!  As you can see above in the Azure Preview Portal, the server has been created with the provided name. Then if we switch over to the Azure Management Portal, we will see the same.

 

Corey_BlogPost4_Pic11.png

Corey_BlogPost4_AddDelete.png

I hope this helps you set up your Azure SQL Database environments the way you want them! Thanks for reading. 

 

Leave a Reply

Your email address will not be published. Required fields are marked *