DEV Community

Cover image for Mastering Azure SQL Database: A Practical Guide to SSMS Integration
Oluwatobiloba Akinbobola
Oluwatobiloba Akinbobola

Posted on

1

Mastering Azure SQL Database: A Practical Guide to SSMS Integration

INTRODUCTION

A completely managed relational database service, Azure SQL Database enables smooth interaction with SQL Server Management Studio (SSMS). This tutorial explains setting up security settings, creating an Azure SQL database, and running SQL queries.

PROCEDURE

Part 1: Creating an Azure SQL Database

  1. Sign in to Azure Portal
  2. Create a New SQL Database New SQL Database
    • Click Create a resource > Search for SQL Database > Select Create.
  3. Configure Database Settings
    • Choose a subscription and resource group. create01
    • Provide a Database Name
    • Click Create new server, set authentication to SQL auth only, define an admin login and password, and select a region. Create2
    • Choose Basic pricing for this lab.
    • Click Review + create > Create. Review + create
  4. Configure Firewall Rules
    • Navigate to SQL Server > Networking. SQL Server
    • Click Add Client IP > Save. Add Client IP

Part 2: Connecting to Azure SQL Database with SSMS

  1. Launch SSMS on your computer.
  2. Connect to the Server
    • Server type: Database Engine.
    • Server name: Copy from Azure Portal.
    • Authentication: SQL Server Authentication.
    • Login: Use the admin username and password.
    • Click Connect. ssms Connect
  3. Expand Databases in Object Explorer to view. Object Explorer

Part 3: Running SQL Queries in SSMS
1.Create a Table

CREATE TABLE Employees (
    EmployeeID INT PRIMARY KEY,
    FirstName NVARCHAR(50),
    LastName NVARCHAR(50),
    Email NVARCHAR(100)
);
Enter fullscreen mode Exit fullscreen mode

Click Execute.
CREATE TABLE
2.Insert Data

INSERT INTO Employees (EmployeeID, FirstName, LastName, Email)
VALUES (1, 'John', 'Doe', 'john.doe@example.com'),
       (2, 'Jane', 'Smith', 'jane.smith@example.com');
Enter fullscreen mode Exit fullscreen mode

Click Execute.
Insert Data
3.Query the Data

SELECT * FROM Employees;
Enter fullscreen mode Exit fullscreen mode

Click Execute.
SELECT ALL
4.Update and Delete Data

UPDATE Employees SET Email = 'johndoe@newmail.com' WHERE EmployeeID = 1;
DELETE FROM Employees WHERE EmployeeID = 2;
Enter fullscreen mode Exit fullscreen mode

Click Execute.
UPDATE

Part 4: Additional Features

  1. Query Performance Insight
    • Navigate to your database in the Azure Portal. SQL database
    • Under Intelligent Performance, open Query Performance Insight to monitor slow queries. Query Performance Insight
  2. Enable Automatic Tuning
    • Go to Automatic tuning > Enable options like Force Last Good Plan.
  3. Backup and Restore
    • Azure SQL Database provides automatic backups.
    • To restore, go to Backups > Point-in-time restore.

Writing SQL Queries in Azure Portal
1.Open Query Editor in Azure Portal under SQL Database > Query Editor (preview).
2.Log in using SQL Authentication.
3.Run Queries Directly in the Portal

CREATE TABLE Customers (
    CustomerID INT PRIMARY KEY,
    FirstName NVARCHAR(50),
    LastName NVARCHAR(50),
    PhoneNumber NVARCHAR(15)
);
Enter fullscreen mode Exit fullscreen mode

Run
Click Run.
Run Table

CONCLUSION

This guide covered creating and configuring an Azure SQL Database, connecting to SSMS, executing SQL queries, and exploring advanced features like performance insights and backups. These foundational skills are essential for managing databases in a cloud environment.

API Trace View

How I Cut 22.3 Seconds Off an API Call with Sentry

Struggling with slow API calls? Dan Mindru walks through how he used Sentry's new Trace View feature to shave off 22.3 seconds from an API call.

Get a practical walkthrough of how to identify bottlenecks, split tasks into multiple parallel tasks, identify slow AI model calls, and more.

Read more →

Top comments (0)

AWS Security LIVE!

Tune in for AWS Security LIVE!

Join AWS Security LIVE! for expert insights and actionable tips to protect your organization and keep security teams prepared.

Learn More

👋 Kindness is contagious

Immerse yourself in a wealth of knowledge with this piece, supported by the inclusive DEV Community—every developer, no matter where they are in their journey, is invited to contribute to our collective wisdom.

A simple “thank you” goes a long way—express your gratitude below in the comments!

Gathering insights enriches our journey on DEV and fortifies our community ties. Did you find this article valuable? Taking a moment to thank the author can have a significant impact.

Okay