What is Azure Databricks?

Azure Databricks (documentation and user guide) was announced at Microsoft Connect, and with this post I’ll try to explain its use...

Comparing Agent Jobs across Availability Group Replicas with PowerShell

On the plane home from PAS Summit I was sat next to someone who had also attended and when he...

Create users in Azure AD

In this post I'll show you how to create new users in your Azure Active Directory so you can use...

Create users in Azure AD

In this post I'll show you how to create new users in your Azure Active Directory so you can use them as service accounts or to grant other users...

Installing Pester

One of the things that I believe strongly in is that we need better testing of software. Actually, what we...

Spaced-Out Strings

I came across this in a code review not long ago:

Three things pop into my head when I see this...

Using PowerShell To Deploy Scripts From GitHub to Multiple SQL Servers

Now I’m all for making my life easier and one thing that makes life easier for me is having a...

Vigilant SQL DBA Vulnerability Management & 1st Look at Azure Vulnerability Assessments (Baltimore SSUG Session last week)

Just a quick note to share last Wednesday night's presentation on how to manage SQL Server vulnerabilities, plus a first...

Flexible connections and an old friend

TweetG’day,
Just lately I’ve found myself involved with an app that needed to run on a server and nearly always (although...

SQL SERVER ON LINUX INSTALLATION – PART4 – INSTALL SQL SERVER AGENT ON RHEL

In my previous tips, I explained about install RHEL Server on the virtual machine, install SQL Server 2017 on Red Hat Enterprise...