Finding Analogies with AI

I saw this article on using AI to help that included a few prompts. I decided to try one. This is part of a series of experiments with the...

Finding a History of Database Snapshots, Taken and Restored

This is a question that’s come up twice this morning, firstly where can we find a history of database snapshots and secondly where can we find a history of...

Restore with Standby–#SQLNewBlogger

A customer had a question about restoring with standby, so I wrote a quick post to explain how this works. Another post for me that is simple and hopefully...

Yet another newsletter

I’ve been thinking about starting a newsletter for a while now. I want to focus on summaries and what stood out for me from among the many cool talks...

Chicago Database DevOps in a Day Workshop

I’m heading to Chicago today for the Redgate Database DevOps in a Day workshops. This is the first of many on the US tour. I’ll be at 5 of...

Remotely Check Disks Space, Find Large Files and Remove Old Files - PowerShell

Remotely Check Disks Space, Find Large Files and Remove Old Files - PowerShell

 For a very important client, I currently manage over 200 SQL...

How to Create a Time Table in Power BI Using DAX

Lately, I’ve been having to create items in Power BI, that I haven’t had to do for a while, this week it was a Time table. Of course, I...

Serving layers with a data lake

Data lakes typically have three layers: raw, cleaned, and presentation (also called bronze, silver, and gold if using the medallion architecture popularized by Databricks). I talk about this is...

A New Word: mahpiohanzia

mahpiohanzia – n. the frustration of being unable to fly, unable to stretch out your arms and vault into the air, having finally shrugged off the burden of your...

Finding Identity Columns–#SQLNewBlogger

I had to find a set of identity columns recently and through this would make a good blog post. Another post for me that is simple and hopefully serves...