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

SQL Agent job history on a Managed Instance

The defaults for saving SQL Agent Job history are ok (at best), so you should probably check and update them ... Continue reading

AWS RDS SQL Server Announcements - 2022 & 2023

RDS Custom for SQL Server now supports Local Time ZonesAmazon RDS for SQL Server supports minor version 2019 CU21Amazon RDS for SQL Server now supports self-managed Active DirectoryAmazon RDS...