Common Mistakes in SQL Server – Part 5

Last week, in the post Common Mistakes in SQL Server - Part 4 I explained about the Auto Growth configuration in SQL Server and how it can adversely impact....

SQL Saturday Boston 2023 Recap

First Things First Thank you to everyone who attended my session “Answering the Automator’s Call with Automation.” My slide deck and demo code are now available on my Github.....

The 5 Best SQL Course for Beginners – Reviews and Guide

In the technologically driven world of 2024, more individuals are finding themselves drawn towards the intricacies of database management. Central to this booming sector is SQL, a programming language exclusively...

Using the Pure Storage PowerShellSDK2 - Part 1 - Connecting to FlashArray

Welcome to our blog series on using the Pure Storage PowerShell SDK2. In this series, we will provide you with practical insights and examples on how to harness the...

SQL Saturday Boston 2023 Slide Decks

Thanks to everyone who came to my sessions at SQL Saturday Boston 2023. I’ve added the decks to the schedule, so you can click my session and will see...

A New Word: Harmonoia

harmonoia – n. an itchy sense of dread when life feels just a hint too peaceful – when everyone seems to get along suspiciously well, with an eerie stillness...

Creating an Empty Repo in GitHub–#SQLNewBlogger

I saw someone struggling with getting started with a Visual Studio project and Azure DevOps. They got a conflict, which I’ll show and then get you started with an...

Parameterize your Databricks notebooks with widgets

Widgets provide a way to parameterize notebooks in Databricks. If you need to call the same process for different values, you can create widgets to allow you to pass...

dataMinds Connect 2023 – Raiders of the Lost ADX slides

You can find the slides for the session that I gave with Johan at dataMinds Connect 2023 at GitHub. As usual, the event was amazing. A lot of great...

A NEW’er Solution For An Old Problem: How To Gain Access To SQL Server When No DBA Around

How To Gain Access To SQL Server When No DBA

When I showed a draft of this article to a friend of mine, to...