Azure Synapse

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

Azure Synapse Shorts – 3 Value Considerations

In this video, Chris Seferlis covers the three most valuable aspects of Azure synapse. The only complete analytics solution, the ability to use serverless and provisioned compute clusters, and the most secure data management tool available. Make sure to like, comment, and subscribe.

Read More
Azure Synapse CosmosDB

Deep dive into Azure Cosmos DB API for MongoDB + Azure Synapse Link

This week Chris Joakim joins Mark to deep dive on building HTAP analytics on MongoDB data using the Azure Cosmos DB API for MongoDB and Azure Synapse Link. In this episode, Chris will show how to build a PySpark Notebook to aggregate data out of MongoDB data in Azure Synapse Link. All in near real-time.

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

Azure Synapse Shorts – Maximizing Calculations in Power BI

Traditional Data Warehousing expertise tells us that calculations should be performed during our ETL/ELT, as close to our data sources as possible to relieve pressure on our sematic layer and visualization tools. In this video, Chris Seferlis is going to explore where Power BI might challenge some of that thinking. In our 3rd video, my […]

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 Full Course

Azure Synapse Analytics (ASA) is changing the way we work with data services in Azure. The ASA workspace combines the core technologies required for data warehousing, Big Data Analytics and Data Science. In this Learn with the Nerds event, Mitchell Pearson will teach you how you can use Synapse Analytics to solve the paradox of […]

Read More