Related Articles
Newsletter
Join our blog
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.
Start with the FREE community plan and get your lifetime access to 20+ courses. Get Instant Access Now!
Need help? Talk to an expert: (904) 638-5743
Private Training
Customized training to master new skills and grow your business.
On-Demand Learning
Beginner to advanced classes taught by Microsoft MVPs and Authors.
Bootcamps
In-depth boot camps take you from a novice to mastery in less than a week.
Season Learning Pass
Get access to our very best training offerings for successful up-skilling.
Stream Pro Plus
Combine On-Demand Learning platform with face-to-face Virtual Mentoring.
Certification Training
Prepare and ace your next certification with CertXP.
Private Training
Cheat Sheets
Quick references for when you need a little guidance.
Nerd Guides
Summaries developed in conjunction with our Learn with the Nerds sessions.
Downloads
Digital goodies - code samples, student files, and other must have files.
Blog
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Community Discord Server
Start here for technology questions to get answers from the community.
Career Guides
Breaking into the field? Let these guides help get you started with a plan.
Affiliate Program
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
Reseller Partner
It's time to address your client's training needs.
Foundation
Learn how to get into IT with free training and mentorship.
Management Team
Discover the faces behind our success: Meet our dedicated team
Contact Us
How can we help? Connect with Our Team Today!
FAQs
Find all the information you’re looking for. We’re happy to help.
It can be hard to know which Azure SQL Platform to use for your data. If you’re one of those people and would like to learn more about the options Azure provides to architect robust solutions, we’re here to help. In a recent webinar, I spent some time comparing common functionality and options (including demos) for different Azure SQL services to help you decide if you’re looking to migrate or start new projects within Azure.
There are basically four options to run SQL within Azure. The most used option currently is IaaS – Azure VM running SQL Server. You also have a few PaaS options. There is PaaS SQL Instance with Azure SQL Managed Instance, which was just released recently in public preview. The final two are PaaS SQL Databases – Azure SQL DB and Azure SQL DW.
So, which one is right for you? For me it boils down to two factors (although with many nuances):
Here’s a look at some pros/cons of Iaas vs PaaS:
IaaS
PaaS (Serverless)
My recommendations? I have a few:
1. Choose PaaS over IaaS when possible. This is the current trend in the industry. Using PaaS will reduce your maintenance chores, it will increase your development agility and you will have the advantage of new features.
2. Choose Azure SQL DW IF it fits your data. Azure SQL DW is great for large, well modelled workloads and large queries but is not the correct platform for all data warehouses, such as small queries or OLTP workloads. It does require new development patterns to take advantage of the MPP (Massively Parallel Processing). Be sure to pay attention to feature differences with Azure SQL DB.
3. Use Azure SQL DB if you can and when Azure SQL DW doesn’t make sense. Azure SQL DB is great for new applications and application development. It has multi-tenant capabilities, easy replication and built in backups and index tuning advisor. It enables you to manage data less and “use” it more.
The bottom line is that most environments will use a different mix of options, so I recommend looking into all the options and combining them for the best fit in your environment. I’ll also say, if you’re in IT and have not looked into Azure, you should start now. Azure is here, and we should all be looking into how we can take advantage of it.
Again, watch the full webinar below for more details of the comparisons, as well as demos.
If you have other questions about what platform is right for your organization or you’d like help in getting started with Azure, we’re the people to talk to. Visit our website or contact us to start a conversation today.
Free Trial
private training
Newsletter
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.
Leave a comment