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

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.

Python Automated NSLOOKUP with socket.gethostbyname()

Sometimes you need to look up a list of hosts to get their IP addresses. Maybe you need to create a quick list for a hosts file, as was my case. This example also includes examples for using a list in python, creating a for loop in python, and a print statement using a custom … Continue reading Python Automated NSLOOKUP with socket.gethostbyname()

FIND-AND-REPLACE SHORTCUTS AND REGULAR EXPRESSIONS

If you are going to work efficiently as a programmer, then your search skills have got to be on point. You need to be able to Ctrl+F and Ctrl+H yourself out of trouble, and quick! When find-and-replace work gets tricky, that’s when you pull out Regular Expressions, the power tool of searching. You can use … Continue reading FIND-AND-REPLACE SHORTCUTS AND REGULAR EXPRESSIONS

SQL Server Set Operators: UNION, INTERSECT, and EXCEPT

Did you know you can do set-based math with SQL Server? With the UNION, INTERSECT, and EXCEPT set operators, you can compare one result set to another and add or subtract results, called a compound query. This can be a handy tool for your toolbox. This is very similar to Oracle Set Operators: UNION, INTERSECT and MINUS … Continue reading SQL Server Set Operators: UNION, INTERSECT, and EXCEPT

SQL Server: Fake a Dynamic IN with STRING_SPLIT

use string_split to actually join your multiple choices to a table! #SQLServer2016 #SQL #TSQL