A New Word: Gobo

gobo – n.  the delerium of having spent all day in an aesthetic frame of mind, taking photos across the city, getting lost in an art museum – which...

How to Downgrade Or Recover a SQL Server Database To A Previous Version Using SqlPackage.exe?

How to Downgrade a SQL Server Database To A Previous Version?

Upgrading a SQL Server database to a newer version is one of the core duties...

SQL Prompt Quick Access to Helper Code

We’ve been doing some events as part of the Redgate Roadshow, and at one of the events, we had a customer ask about something that we demo’d. This post...

The Year in Travel

Here’s my year, which is pre-populated with a couple more trips coming up in November. Those should be all, as I’ve declined to go back to the UK in...

Common Mistakes in SQL Server – Part 3

Last week we discussed advantages of recompilation in Common Mistakes in SQL Server – Part 2. This week in this article Common Mistakes in SQL Server - Part 3 I...

Eleven chapters of my data architecture book are available

As I have mentioned in prior blog posts, I have been writing a data architecture book, which I started last November. The title of the book is “Deciphering Data...

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...