SQL Server Patching

Why should you patch your SQL Server instances? Compliance, stability, security, reliability, functionality, and more. Microsoft regularly releases updates to SQL Server known as Cumulative Updates (CUs). Cumulative updates...

How to check if powershell is running as administrator with elevated privileges

How to check if powershell is running as administrator with elevated privileges

In case it's not clear from the title, I am referring to...

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

Decrypting Stored Procedures The Cumbersome Way

I had a client that was struggling with some encrypted stored procedures. They needed to decrypt them, which I know is a pain in the #@$%@#$@#$#@. I had to...

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