Sign-up now and get instant access
Leave a comment
Customized training to master new skills and grow your business.
Beginner to advanced classes taught by Microsoft MVPs and Authors.
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.
Quick references for when you need a little guidance.
Summaries developed in conjunction with our Learn with the Nerds sessions.
Digital goodies - code samples, student files, and other must have files.
Stay up-to-date on all things Power BI, Power Apps, Microsoft 365 and Azure.
Earn money by driving sales through the Pragmatic Works' Training Affiliate Program.
It's time to address your client's training needs.
Learn how to get into IT with free training and mentorship.
Discover the faces behind our success: Meet our dedicated team
How can we help? Connect with Our Team Today!
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.
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.