Redgate SQL Data Masker Refreshing Schema

This is a quick blog to help me remember what is going on with the Data Masker product. This is for the SQL Server version, but I believe the...

T-SQL Tuesday Retrospective #003: Relationships

In my quest to respond to every T-SQL Tuesday since the dawn of the end of 2009, it was only a matter of time before Rob Farley’s name came...

Daily Coping 4 Nov 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...

PASS Virtual Summit 2020: I'm (Virtually) Presenting

I'll be presenting at 7AM Central Time in the first timeslot of the main three-day PASS Virtual Summit 2020 conference. It's long been a goal of mine to present...

Consider the Benefits of Powershell for Developer Workflows

Who Am I Talking To

You use bash or python.
PowerShell seems wordy, extra verbose, and annoying.
It’s a windows thing, you say… why would I even look at it.
Pry bash out...

Pro Microsoft Power Platform: Solution Building for the Citizen Developer

Over the last several months a team of excellent authors, including myself, have been writing a very exciting new book about Microsoft’s Power Platform. We

Restoring Database Users After Copying the Database

A former colleague emailed me with a question about retaining/fixing database users and permissions after restoring a database. They were copying a database from one instance to another, with...

Improving Local Development Workflow With Go Task

Workflow Tooling
Development workflow, especially outside of a full-fledged IDE, is often a disjointed affair.
DevOps oriented workflows that often combine cli tools such as terraform, PowerShell, bash, and more all...

External tables vs T-SQL views on files in a data lake

A question that I have been hearing recently from customers using Azure Synapse Analytics (the public preview version) is what is the difference between using an external table versus...

Fundamental Information for Azure Open Source Databases

As all of us know that Microsoft Azure Supporting many different database types such as Azure SQL, Azure Cosmos DB, and Azure support also MariaDB, MySQL, and PostgreSQL so...