Azure SQL Database, a great alternative to SQL Server Express or Standard

Description

Do you currently use SQL Server Express or Standard Edition to support third-party applications? Discover how moving to Azure SQL Database can reduce costs and administrative overhead. This session will cover the pros and cons. We’ll walk through real demos of ongoing management, and engage in an interactive discussion to help you decide if Azure SQL DB is right for your environment.

Key Takeaways

• Freelance Consultant | MVP
• SQL Masters Consulting |
• Influence our SQL roadmap and ensure
• Platform Overview – What Azure SQL DB is and why it solves Express/Standard Edition
• Capabilities – Feature comparison, HA, security, patching, performance
• Operations – Provisioning, configuration, daily management tasks

My Notes

Action Items

• [ ]

Resources & Links

Slides

📥 Download Slides

Azure SQL Database, a great alternative to SQL
Server Express or Standard
Moving beyond the limits of on-premises SQL Server editions
Kelly Broekstra
Warwick Rudd
• Freelance Consultant | MVP
• SQL Masters Consulting |
MVP, MCM
• Principal Consultant
Sound off.
The mic is all yours.
Influence the product roadmap.
Join the Fabric User Panel
Join the SQL User Panel
Share your feedback directly with our
Fabric product group and researchers.
Influence our SQL roadmap and ensure
it meets your real-life needs
https://aka.ms/JoinFabricUserPanel
https://aka.ms/JoinSQLUserPanel
Abstract
Do you currently use SQL Server Express or Standard Edition to support thirdparty applications? Discover how moving to Azure SQL Database can reduce
costs and administrative overhead.
This session will cover the pros and cons. We’ll walk through real demos of
ongoing management, and engage in an interactive discussion to help you
decide if Azure SQL DB is right for your environment.
This is a practical, no-hype session designed to help DBAs, architects, and
decision-makers make informed platform choices.
What You’ll Learn
• Platform Overview – What Azure SQL DB is and why it solves Express/Standard Edition
limitations
• Capabilities – Feature comparison, HA, security, patching, performance
• Operations – Provisioning, configuration, daily management tasks
• Costs – Licensing, infrastructure, and built-in efficiencies
• Getting Started – Migration tools, paths, free tier, decision points
Why Are We Even Having This Conversation?
Express Edition Limits
Standard Edition Challenges
• 10 GB max database
size
• No SQL Agent — no
scheduled jobs
• Capped at 1 CPU
socket, 4 cores, 1 GB
RAM
• No HA, no mirroring, no
enterprise features
• Heavy licensing: Server +
CALs or core-based
• You own everything:
patching, backups, HA
• Scaling means hardware
procurement cycles
• Disaster recovery
requires significant extra
investment
"We've outgrown
Express, but Standard
feels like overkill." —
Sound familiar?
“Patching windows,
backup management,
capacity planning; it
feels like to much work”
Why Are We Even Having This Conversation?
Express Edition Limits
Standard Edition Challenges
• 50 GB max database
size (SQL Server 2025)
• No SQL Agent — no
scheduled jobs
• Capped at 1 CPU
socket, 4 cores, 1 GB
RAM
• No HA, no mirroring, no
enterprise features
• Heavy licensing: Server +
CALs or core-based
• You own everything:
patching, backups, HA
• Scaling means hardware
procurement cycles
• Disaster recovery
requires significant extra
investment
"We've outgrown
Express, but Standard
feels like overkill." —
Sound familiar?
“Patching windows,
backup management,
capacity planning; it
feels like to much work”
Azure SQL Database
Fully managed relational DBaaS built on the latest stable SQL Server engine. Microsoft
handles the infrastructure — you focus on your data.
Single Database
Dedicated, fully isolated
resources. The most
common starting point for
Express/Standard
migrations.
Elastic Pool
Shared resources across
multiple databases. A
cost-saving gem for SaaS
and multi-tenant
applications.
Managed Instance
Near 100% SQL Server
compatibility. Ideal for liftand-shift when full feature
parity matters.
Microsoft manages: patching, backups, HA, and infrastructure.
You manage: schema, queries, security policies, and data.
How Do They Stack Up?
Demo 1: Provisioning & Configuration
• Deploying an Azure SQL Database
• Selecting service tiers and performance models
• Review security defaults
• Connect with SSMS or Azure Data Studio
What You Get That You Don't Have to Build
Azure SQL Database is like having a DBA working 24/7 on your database — without the overhead.
High Availability
Automated Backups
Security by Default
Automatic Patching
Intelligent Performance
Global Scale
Demo 2: Day-to-Day Management
• Automated backups and point-in-time restore
• Scaling performance up and down
• Monitoring and performance insights
• Patching and maintenance (or lack thereof!)
Understanding the Cost Model
Two Purchasing Models
Service Tiers
Cost Highlights
Serverless
• General Purpose — the right fit for most workloads
• Business Critical — in-memory OLTP, low latency,
readable secondary
• Hyperscale — up to 100 TB with rapid scaling
Auto-scales compute,
auto-pauses when idle.
Pay only for what you
use — perfect for
dev/test.
Azure Hybrid Benefit
Bring existing SQL Server
licenses. Organizations with
EA agreements can save up
to 40%.
Free Tier
32 GB General Purpose database — always free. One DB per
subscription, no commitment needed.
Tip: Use the Azure Pricing Calculator to model your
specific workload before committing.
DTU Model
vCore Model
Bundled compute + I/O + memory. Simple and
predictable — ideal for steady workloads.
Choose CPU cores and memory independently. Supports
Azure Hybrid Benefit — bring your existing licenses.
Demo 3: Cost & Operational Comparison
• Azure Pricing Calculator
• Cost Management in the Azure Portal
• Operational overhead comparison
How Do You Get There?
Assessment Tools
Getting Started Today
• Database Migration Assistant (DMA) —
compatibility check and feature parity report
before you move
• Azure Migrate — broader workload
discovery across your environment
•
Migration Options
• BACPAC export/import — simple, great for
smaller Express databases
• Azure Database Migration Service — online
migration with minimal downtime
• Transactional replication — near-zero
downtime for large Standard databases
Free tier: 32 GB General
Purpose DB — always free, no
credit card required
•
Microsoft Learn: Azure
SQL Fundamentals Learning
Path
•
Azure SQL Docs:
docs.microsoft.com/azure/az
ure-sql
"The hardest part of migrating
is deciding to start."
Let's Be Honest About the Tradeoffs
Azure SQL Database is not the right tool for every situation. Know your workload — then choose the right fit.
•
Air-Gapped / Offline Environments
•
Complex Linked Server Dependencies
•
CLR, Service Broker, or Agent Jobs
•
Strict Data Residency Requirements
•
Very Small, Cost-Sensitive Workloads
•
Legacy 2008/2012 Dependencies
Interactive Discussion
• What database platform are using now?
• Would you consider changing?
• What’s stopping you?
How was
the session?
Complete Session Surveys in
for your chance to WIN
PRIZES!
Questions
Thank you for Joining us today!
Kelly Broekstra
Warwick Rudd
Sound off.
The mic is all yours.
Influence the product roadmap.
Join the Fabric User Panel
Join the SQL User Panel
Share your feedback directly with our
Fabric product group and researchers.
Influence our SQL roadmap and ensure
it meets your real-life needs
https://aka.ms/JoinFabricUserPanel
https://aka.ms/JoinSQLUserPanel