Latest Posts

With the announcement of Microsoft Fabric at the Build conference in May. Be on the lookout for new blog posts about Fabric. While I will still continue to post on Synapse and other data related topics. Fabric is the new buzz word that deserves some attention.

Fabric – Easy Hub and Spoke Architecture

July 31, 2023
If you have an existing hub and spoke architecture, moving your architecture to Fabric may not be as difficult as you might initially think. One of the coolest features in…
Read More

Synapse Fundamentals – Table Creation Made Easy

September 27, 2022
One of the most common issues encountered with Azure Synapse Dedicated SQL Pools is the confusion of table creation.  The confusion stems from separating how a table is stored from…
Read More

Synapse Dedicated SQL Pool Execution Plans

August 4, 2022
Synapse execution plans are specifically for distributed SQL (DSQL) and are not the same as SQL Server execution plans.  SQL Server execution plans show the types of join patterns (hash,…
Read More



Azure Synapse Analytics Dedicated SQL Pools

Top 10 Performance Considerations

I have presented on this topic in different forums before but will be presenting it here in a series of blog posts over the next few months. Check back periodically – I will be adding to the list and go into details about how to get the most performance out of your Synapse environment.

Have more questions? Check out my resources page where I have listed many popular Synapse related sites, video channels, etc… or contact me directly and start a dialog.