Posts Tagged ‘SQL Database’

Create a new Azure SQL Database (on PaaS) step by step

February 15, 2018 Leave a comment

Azure SQL Database is a Microsoft’s cloud based service on Microsoft on premise version of SQL Server relational database. It is a fully-managed relational cloud database service built for developers.

–> Today we will see how you can create a new SQL Database on Microsoft Azure:

1. Please make sure you have a Azure Account and Subscription.

2. Go to Microsoft Azure portal:

– In the menu, click New

– Select the Databases in the Azure Marketplace blade

– Click SQL Database

3. In the SQL Database blade enter the following settings:

– Name: MyFirstAzureSQLDB

– Subscription: Select your Azure Subscription

– Resource Group: Select the Resource Group, or create new

– Select source: We will choose here “Sample (AdventureWorksLT)”

– Server: Create a new logical server with following settings:
   – Server name: Provide a globally unique name
   – Server admin login: Provide a valid user name of your choice
   – Password: Provide a valid password
   – Location: Select a valid location
   – Allow azure services to access server: Select the check box

– Want to use SQL elastic pool? Select “Not now”

– Pricing tier: As you click on this option you will be taken to the Configure Performance blade, select Basic for now, but you can choose higher tiers as per your workloads and needs.

– Collation: Leave it as default, SQL_Latin1_General_CP1_CI_AS

– Pin to dashboard: Select the check box

4. Finally click the Create button on the main blade. Provisioning a new SQL Database takes few minutes and you can see the deployment progress at the Top-Right corner of your portal. And once the deployment is done you will see following message at the same place:

5. Now as you had selected to pin the new Database, so you should be able to see it in your dashboard like this:

6. Click on the shortcut and you will be taken to its Settings and Properties, where you can check resources, various options, tweak settings and do some admin related stuff.

7. The portal also provides a basic Query Editor to execute SQL Queries, check data in tables, and explore the database, check some DB objects, etc. After selecting the Query Editor you can click on Login button at the top. Provide the User Name and Password you applied while creating the Database.

8. Try explore the Sample Database, it gives limited feature to check Tables, Views and SPs. You can try writing a SQL Query and Run against the tables/views, or execute the SPs. The results will be shown in pane below.

9. You can also connect to this Azure SQL Database from SSMS installed in you PC or a remote server, which I’ll show in my next [blog post].

–> Terms used above:

1. Resource Group: is a collection of resources that share the same life cycle, permissions, and policies.

2. Server: or Logical Server acts as a central administrative point for multiple databases, including elastic pools logins, firewall rules, auditing rules, threat detection policies, and failover groups.

3. DTU (or Database Transaction Units): Microsoft guarantees a certain level of resources for that database (independent of any other database in the Azure cloud) and providing a predictable level of performance. This amount of resources is calculated as a number of Database Transaction Units or DTUs, and is a blended measure of CPU, memory, I/O (data and transaction log I/O).

4. Elastic Pools: provide a simple and cost effective solution for managing the performance of multiple databases within a fixed budget. An elastic pool provides compute (eDTUs) and storage resources that are shared between all the databases it contains. Databases within a pool only use the resources they need, when they need them, within configurable limits. The price of a pool is based only on the amount of resources configured and is independent of the number of databases it contains.


New Microsoft Azure Portal | Mind = Blown

August 27, 2014 Leave a comment

Microsoft recently announced a first-of-its-kind Cloud experience that brings together cross-platform technologies, services and tools, enabling developers and businesses to innovate at startup speed via a new Microsoft Azure Preview Portal.

“Developing for a mobile-first, cloud-first world is complicated, and Microsoft is working to simplify this world without sacrificing speed, choice, cost or quality,” said Scott Guthrie, executive vice president at Microsoft. “Imagine a world where infrastructure and platform services blend together in one seamless experience, so developers and IT professionals no longer have to work in disparate environments in the cloud. Microsoft has been rapidly innovating to solve this problem, and we have taken a big step toward that vision today.”

Windows AZURE is now Microsoft Azure!

New Portal:


–> Check in this Video the new “AZURE Portal” & how DevOps just got a whole lot more awesome:


The new “Microsoft Azure” Portal provides a fully integrated experience that will enable customers to develop and manage an application in one place, using the platform and tools of their choice. The new portal combines all the components of a cloud application into a single development and management experience.

–> New components include the following:
1. Simplified Resource Management
2. Integrated billing
3. Gallery
4. Visual Studio Online
… for more info visit Microsoft Press, [link].


–> Easily Spin-Up a new “SharePoint Farm” in minutes:

You can see here on AZURE cloud how easily and in no time you can Spin-Up a new SharePoint Farm in minutes and few Clicks:

Azure also provides you various options to select SQL Server Plans based upon your preference and budget:

Otherwise in an on-Premise environment or with any other vendor solution this would take days to setup a new Server (Hardware) with Windows Server OS, SharePoint, SQL Server, etc. installed and get things configured.


–> Spin-Up a new “SQL Database” in seconds:

Creating a new SQL Server instance is also very easy where you provide all necessary information in simple steps, like SQL Instance Name:
The new instance will be created in seconds and you can access the Instance Create Databases, Tables, Views, other DB Objects and easily Query them via SSMS.


–> Microsoft Azure Offerings:
Apart from these 2 offerings that we saw above, Microsoft Azure provides lot more that you can browse in Azure Gallery:

I’ll be exploring the new Portal as per my needs and post my experiences in coming posts, so stay tuned!