Do you want to learn how to bring together enterprise data warehousing and big data analytics? In a recent webinar, 3Cloud consultant Mike Donnelly, explores the components included with an Azure Synapse Workspace. This presentation goes through all the various pieces of Synapse, what it is and what it can do, as well as why people will be using this more and more as people build modern data warehouse.
When you search Azure Synapse Analytics, you’ll see there is Azure Synapse Analytics (formerly known as Azure SQL DW) which has been around for a bit as a data warehouse solution. But you will also find Azure Synapse Analytics Workspaces Preview. This preview resource is the focus today and many of the pieces it includes will be covered (and demoed), including:
• SQL Pools (formerly known as SQL Data Warehouse)
• Built-in SQL Pool (aka SQL On-Demand/Serverless)
• Azure Data Lake Storage (Gen2)
• Spark Compute Pools (not Azure Databricks)
• Integrate (Azure Data Factory)
If you’re interested in learning more about Azure Synapse Analytics and why it will become the tool of choice for building modern data warehouse, this webinar is for you. Watch the complete webinar below.
Azure SQL Data Warehouse (DW) has been improving its capabilities day-by-day. This relational database platform used by Microsoft is known to be faster and cheaper than other major cloud data warehouse solutions.
There are many options for data storage, how do you know which is right for your data? Today I’d like to discuss storage in relation to the architecture of the modern data warehouse and to shed some light on your options.
What do you know about the database tool from Microsoft called Azure Data Studio? Azure Data Studio is a free Microsoft desktop tool (initially called SQL Operations Studio) that can be used to manage SQL Server databases and cloud-based Azure SQL Databases and Azure SQL Data Warehouse systems.
I’d like to share a great resource that I found when setting up a demonstration of Azure SQL Data Warehouse. It’s a tutorial from Microsoft that allows us to very easily load a large sample data set into Azure SQL Data Warehouse for free.
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.
In this post, I’d like to discuss some of the common Azure SQL Data Warehouse performance issues I come across personally or with clients. Sharing these issues is a way for all of us to gain the knowledge needed when you come across issues when utilizing Azure SQL Data Warehouse.