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

Managed Resource Groups – Your Resource’s Toy Box

You need a resource, so you create it. Your resource needs resources, so it creates a managed resource group where it can put its resources.

Delta Table Time Travel – How Far Back Does it Go?

When it comes to Time Travel, let's face it. We all have a lot of questions. If I go back in time and kill my father, do I kill myself, too? Or does it spawn a new timeline? Can I meet dinosaurs and if I step on a bug, will it end life as we … Continue reading Delta Table Time Travel – How Far Back Does it Go?

Python Style and Best Practices for Notebooks

Python is used often these days in notebooks. As is true in any development environment, there are best practices and good conventions for using Python in notebooks. The following is what I use in my own designs and with my teams.