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

Remotely Copy Files To Multiple Destinations Using PowerShell

Remotely Copy Files To Multiple Destinations Using PowerShell

Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...

Remotely Copy Files To Multiple Destinations Using PowerShell

Remotely Copy Files To Multiple Destinations Using PowerShell

Basic Copy-Item cmdletIf you have used some PowerShell, you are probably familiar with Copy-Item...

Friday Flyway Tips: Searching Migrations

When a Flyway Desktop (FWD) project (or Flyway project) has been around for a long time, there can be a lot of migration scripts. That can be a pain...

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

A New Word: Aubadoir

aubadoir – n. the outworldly atmosphere just before 5 am, when the bleary melodrama of an extremely late night becomes awkwardly conflated with the industrious flourescence of a very...

Webinar: Unlock the Full Potential of Flyway to Achieve Automated Database Releases

On Aug 22, 2023, I’m co-hosting a webinar with Anderson Rangel, Redgate Solution Engineer in Brisbane. You can register here for the 11am AEST webinar. No, I’m not going...

The 2023 Redgate UK DevOps Roadshow

Years ago Redgate did some traveling events under the SQL in the City brand. These were a lot of fun and kind of amazing. One of the longer tours...

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

Finding Encrypted Stored Procedures–#SQLNewBlogger

I had a client ask about how to deal with encrypted stored procedures in their database. This post looks at how to find them and I’ll have future posts...