Synapse

Azure Synapse

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
Azure Synapse

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
Data Microsoft

Real-world Demo of Microsoft Intelligent Data Platform

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
Azure Synapse

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
Azure Synapse SQL Server

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
Azure Synapse CosmosDB

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
Azure Synapse CosmosDB

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

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

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
Azure Synapse

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