A Quick PartitionBy Switch for Delta Files

Sometimes you need to make a change to how things are partitioned. And that's okay! You should have the flexibility to change what your delta is partitioned by just like you can change how a table is indexed. So, here's the code you need! A couple of notes on why we are overwriting to the … Continue reading A Quick PartitionBy Switch for Delta Files

Add Your AAD Group to Dedicated or Serverless SQL Pool

It can be confusing that we can create Synapse, see that it comes with Serverless SQL Pool, setup a Dedicated SQL Pool, and then not be able to access it. SQL Server Databases - even serverless ones - still need logins, users, and roles to be able to work. Here is a quick rundown to … Continue reading Add Your AAD Group to Dedicated or Serverless SQL Pool

Synapse Permissions from a Different Perspective

Ever want to compare the different permissions between the Synapse roles side by side or determine quickly which permissions are shared by what roles? Looking at these in the table format below will help. All of the roles listed below are the built in RBAC roles that currently exist in the Synapse Access Control found … Continue reading Synapse Permissions from a Different Perspective