Synapse Update – September 2022
This month, you will find information about MERGE for dedicated SQL pools, Auto-statistics for CSV datasets in serverless SQL and the new Livy errors codes for Apache Spark in Azure Synapse Analytics. Additional general updates and new features in Synapse Data Explorer and Data Integration are also mentioned in this edition.
Read More
Synapse Espresso: How to Optimize Listing Files?
This 7th video of the Synapse Espresso series, Stijn and Filip discuss different ways that we can optimize listing files to improve the performance of serverless SQL pool.
Read More
Real-world Demo of Microsoft Intelligent Data Platform
-
Frank
- August 18, 2022
- Analytics
- Azure
- azure active directory
- azure purview and power bi
- azure purview data governance
- azure sql database
- Azure Synapse
- Azure Synapse Link
- built in AI
- Cloud Defender
- cosmos db
- database
- Governance
- intelligent data governance
- intelligent data platform
- intelligent data services
- Machine Learning
- Microsoft Sentinel
- Power BI
- power bi data modeling
- power virtual agent
- predictive AI
- SQL
- SQL Server
- Synapse
- Synapse Analytics
Sharieff Mansour, a leader on the Data and AI team at Microsoft, joins Jeremy Chapman for a closer look at how databases, analytics, machine learning, and governance come together in the Intelligent Data Platform. See how you can use these integrated services to build powerful new apps or modernize your current ones.
Read More
Are you following best practices with Azure Synapse Analytics?
How do you know if you are following best practices for Azure Synapse Analytics? One way is to check out this report that Patrick walks through. It’s a great way to get an understanding where your database is at.
Read More
How to Export your SQL Server data and Upload to Azure Storage
Learn how to use the bulk copy program utility (BCP) to export your SQL Server data and upload to Azure Storage.
Read More
Deep dive into CosmosDB Synapse Link
Synapse Link provides HTAP or hybrid transactional/analytics processing capabilities to Cosmos DB. In this episode, Mark is joined by Rodrigo Souza who leads our integration with Azure Synapse via Synapse Link. Rodrigo will dive into these capabilities and show you how you can build analytical workloads on top of Cosmos DB.
Read More
Real-time Advanced Analytics with Azure Synapse Analytics & Cosmos DB
In this workshop, learn to design a data pipeline solution that leverages Cosmos DB for both the scalable ingest of streaming data, and the globally distributed serving of both pre-scored data and machine learning models. At the end of this workshop, you will be better able to design and implement solutions that leverage the strengths […]
Read More
Azure Synapse Analytics: Intro Design a multidimensional schema
In this module, you will learn how to design and implement data stores in a modern data warehouse to optimize analytical workloads. You will design a multidimensional schema to store fact and dimension data. Next, you will learn how to create, populate, and query the data model in an Azure Synapse Analytics dedicated SQL pool.
Read More
Azure Synapse: Synapse Link for Dataverse
Learn how to do analytics on your business application data with Synapse Link for Dataverse No tags,
Read More
Optimizing Power BI and Synapse
Azure Synapse and Power BI go together like peanut butter and jelly, but are you making the most of your deployments in the way of performance and optimized architectures? Watch this video with Chris Chalmers and Chris Seferlis where they discuss what you should consider for your deployments to ensure you meet your business requirements. […]
Read More