Which Schema is Queried First?–#SQLNewBlogger

I had to test something for a customer, and as a part of this there as a need to have a different default schema for a user. I wrote...

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

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

Exploring limitations of Fabric Warehouse: 3 key observations

Introduction
Fabric Warehouse is a new interesting tool used for data management and analysis. While it offers a wide range of features and functionalities, it is essential to be aware...

Presenting at PASS Summit 2023 – Atomic Habits

I’m excited to be presenting at PASS Summit 2023, not only because it is PASS Summit but because of the topic.  I do a lot
The post Presenting at PASS...

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

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

Options for Data Source Credentials When A Service Principle Owns A Power BI Dataset

In today’s world of wanting to automate everything, specifically, automating your CI/CD process for your Power BI datasets and dataset refreshes, you need to understand your options when it...