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.
With all the focus on cloud and Azure, have you ever wondered if you can run your traditional BI workloads within Azure? You may ask, should we be putting our traditional BI workloads that we’ve been using like the SQL Stack, SSIS, SSAS and relational databases in Azure; can we even do that?
The answer – yes; there are components and capabilities with Azure, and you can utilize those to migrate what you’re doing on-premise to Azure. The first way you can do this is to run them via SQL VMs within the Azure cloud. You can spin up SQL Server and everything you need there. As far as SSIS, analysis services and SQL Server, you can solve it just like you did on-prem, but run it within the cloud. Then you can take advantage of everything you get within an IaaS implementation.
The good news is now you can run all these components as Platform as a Service (PaaS) as well. So as SQL Server we can use Azure SQL Database. For workloads with larger-sized volumes, distributed queries or distributed big data within a SQL environment, Azure SQL Data Warehouse is a great solution.
Previously, we couldn’t run SSIS packages within the cloud, but with capabilities within Azure Data Factory, we can now do this as a platform, without having to manage the server, cutting down on maintenance tasks and the daily chores of checking our server.
With SSAS, we have Azure Analysis Services, which works like a tabular instance of SSAS on-prem. We can employ tabular models there and run them in the cloud. So, we can orchestrate all these things together and take advantage of the PaaS capabilities that we get there. Once we're there, we gain the ability to orchestrate Data Lakes and put real time and advanced analytics on top of it.
If you’ve been waiting for good Platform as a Service offerings to go to the cloud, the time is now. And Azure is the answer. If you need help getting started or have more questions about running your traditional BI workloads in the cloud or about Azure in general, click the link below or contact us – we’d love to help. Our team of experts can help you move to the cloud and take your business from good to great.
Join other Azure, Power Platform and SQL Server pros by subscribing to our blog.