If you're thinking about moving into cloud infrastructure or IT support, Azure SQL databases are becoming increasingly important skills. The cloud database market is booming, and UK companies are investing heavily in Azure ecosystems. According to recent industry data, IT professionals with Azure certification earn between £35,000 and £55,000 starting salaries, with senior roles reaching £70,000+.
Azure SQL Database isn't as intimidating as it sounds. Think of it as Microsoft's managed version of SQL Server, but running in the cloud. You don't need to worry about physical servers, patches, or complex infrastructure. Microsoft handles all that backend stuff for you.
In this guide, I'll walk you through setting up your first Azure SQL database, explain what each step actually means, and share some practical tips I've picked up working with clients.
Before we dive into the setup, let's clarify what we're actually working with.
Azure SQL Database is a fully managed relational database service. That means:
It's perfect for businesses moving away from on-premises SQL Server installations. The learning curve is gentle because if you know SQL, you already know the language you'll be using.
Before starting, make sure you've got:
That's genuinely it. No complicated software to install locally.
When you're setting up anything in Azure, you start with a resource group. This is basically a folder that holds all your related stuff together.
Here's how:
1. Log into the Azure Portal (portal.azure.com)
2. Click "Resource groups" in the left menu
3. Click "Create"
4. Choose your subscription and give your group a logical name (something like "MyFirstDatabase")
5. Pick the region closest to your location (London or Ireland for UK users)
6. Click "Review and create", then "Create"
That's it. Your resource group is now ready. In practical terms, this keeps your billing organised and makes managing resources much simpler when you've got multiple projects running.
Here's where people sometimes get confused. Azure SQL Database actually needs an Azure SQL Server to live on. They're separate things, and that takes five minutes to understand.
To create your server:
1. In the Azure Portal, search for "SQL servers" at the top
2. Click "Create"
3. Select your resource group from the dropdown
4. Give your server a name (must be globally unique, so something like "mycompanydb2026")
5. Choose your region (keep it the same as your resource group)
6. Set up an admin login (username and password)
7. Review and create
Important point: Store your admin password somewhere secure. You'll need it later. I recommend using a password manager.
Now we're creating the database that will live on your server.
1. Once your server is deployed, click "Go to resource"
2. Click "Create database"
3. Name your database (something descriptive like "SalesDB" or "CustomerData")
4. For compute and storage, select "Configure database"
5. Choose "DTU-based purchasing model" for learning (it's simpler and cheaper)
6. Select "Basic" tier to start (perfect for beginners and costs very little)
7. Set storage to 2GB to begin with
8. Review and create
After a few seconds, your database exists. That's genuinely remarkable when you think about it. You've just created an enterprise-grade database without installing anything.
This is crucial and a bit fiddly, so pay attention.
Your database is now live, but you can't connect to it yet because Azure's firewall is blocking traffic. You need to tell Azure which IP addresses can access your database.
1. Go to your SQL Server resource
2. Click "Firewalls and virtual networks"
3. Click "Add your client IP"
4. This automatically adds your current IP address
5. Click "Save"
In production environments, this gets more sophisticated, but for learning purposes, this is fine.
Now let's actually connect to your new database. You have several options:
Option A: Using Azure Portal (Easiest)
1. Go to your database resource
2. Click "Query editor" in the left menu
3. Log in with your admin credentials
4. Run a simple query: SELECT 1
If you see "1" returned, your database is working perfectly.
Option B: Using SQL Server Management Studio (More Professional)
This is what database professionals actually use.
1. Download and install SQL Server Management Studio (free from Microsoft)
2. Open SSMS
3. Connect to server: your-server-name.database.windows.net
4. Use your admin credentials
5. You're connected
From here, you can create tables, add data, and manage your database exactly like you would with an on-premises SQL Server.
After setting up several databases, these practices make life easier:
Don't do what I did when I first started:
Once your database is running, you'll want to:
Getting a single database running is one thing. Understanding Azure as a comprehensive platform is another entirely. If you're thinking about building a proper career in cloud infrastructure, now's the perfect time to invest in structured learning.
At SmoothOps 365, our Azure Cloud course (available at both Basic and Advanced levels) takes you from absolute beginner to job-ready. The Basic tier is £1,250, with Advanced at £1,750, and you're joining the July 2026 cohort at founding prices. You'll cover Azure SQL alongside the broader Azure ecosystem, security, virtual machines, and networking.
Want to explore whether Azure is right for your career path? Join one of our free 30-minute live info sessions where you can ask questions directly to our instructors and get personalised guidance. No sales pitch, just honest conversation about your options.
Book your free webinar at smoothops365.com/webinar
Azure SQL databases are just the beginning of a genuinely rewarding career in cloud technology.
SmoothOps 365 runs live instructor-led training every Saturday and Sunday. 3 months. 52 contact hours. Keep your job while you train.