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

SQL Server: Fake a Dynamic IN with STRING_SPLIT

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

SQL Server: Duplicate Rows with Your Own Values Using STRING_SPLIT and CROSS JOIN

SQL Server 2016 came out with the STRING_SPLIT function that will return what amounts to a table from character-separated string. Using a CROSS JOIN with this function, you can return one row multiple times with whatever values you want!