Install SQL Server 2019 - Part 10

Synapse and federated queries

As I was finishing up a demo script for my presentation at the SQL PASS Virtual Summit on 11/13 (details on my session here), I wanted to blog about...

Daily Coping 15 Oct 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...

Permissions script for Azure Synapse

I was recently asked to add on to my permissions stored procedures (sp_SrvPermissions, sp_DBPermissions and sp_AzSQLDBPermissions) and create one for ... Continue reading

Using Durable Functions in Azure Data Factory - Support for long running processes in Azure Functions

(2020-Oct-14) Ok, here is my problem: I have an Azure Data Factory (ADF) workflow that includes an Azure Function call to perform external operations and returns output result, which in...

Spoooky SQL at the Baton Rouge SQL/.NET Campfire Stories!

Enjoyed the heck out of tonight's October special edition of the virtual Baton Rouge .NET and SQL User Groups meeting, where we had a lot of active chat, three...

Writing Output from Powershell

One of the things we often want to do when building a PoSh script is to get some output. I first learned about Write-Host, but I learned over time...

A more considered approach to email signatures

This — like last week’s post — is not about SQL Server or Azure SQL Database. In a way, it hearkens back to a post I wrote a few years...

Azure Databricks – The Notebook

Data engineers, pipe line developers, general data enthusiasts will be spending most of their time within a notebook. Here you develop your code, nice visualisations and commentary boxes are...

Daily Coping 14 Oct 2020

I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...