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.
We all have personal capacities and limits that allow us to do something that we want to do every day and most times we know what our limits are. So, you’re thinking, what does that have to do with or how does it apply to Azure? Azure has the same principal behind it, as Azure has limits and capacities just as we do.
On a recent engagement, we ran into an interesting obstacle we needed to overcome. We were migrating from an on-premises ADS environment and wanted to take the SQL Data Warehouses and move them to Azure SQL Data Warehouse.
When we started to ‘peel back that onion’ we found there were certain things we needed to do. First, we needed to understand that there were no cross-database queries with Azure SQL Data Warehouse. This is not about the technology, per se, but about knowing our capacities and resources.
Secondly, we ran into a scenario in which we hit the capacity of 10,000 tables. This client had 10,000 tables with their on premise SQL Data Warehouse, as they had used the appliance to its fullest capacity.
So, here’s why I wanted to share this story. Understanding the capacities of Azure and the Azure resources available to us is important. Are we going to memorize the capacities of all these resources? Of course not, unless you have that photographic memory capacity.
For those like me without that capacity, understanding where to find that info and when we need to look it up is important. If you use your search engine of choice to search ‘Azure capacity limits’, you’ll find a Microsoft doc called Azure Subscription Limits and Quotas.
Something I appreciate about Microsoft is the amount of documentation they’ve put together. Here you’ll find a list of service-specific limits for all services Azure provides and some of the resource limits within them.
When I click on SQL Data Warehouse limits, for example, it takes me to another link and I can click further to find SQL Data Warehouse capacity limits. So, with a few clicks you can drill in and easily determine what limits and capacities your Azure resources can provide.
At times we may not know our own personal limits, but now you know there’s an easy way to find our capacities and limits within our Azure subscriptions. If you’d like to learn more about any Azure product, service or resource, you’re in the right place. Click the link below or contact us—we’re here to help.
Free Trial
private training
Newsletter
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.
Leave a comment