Blog

RegEx in SSMS: A gift for quick code

I had yet another example of how beautiful Regular Expressions can be in SQL coding today, and so I thought I’d share. What I HAD was a set of DELETE statements that might or might not have been executed recently: What I needed was to be able to check each...

Read More

How to use Minion Enterprise for the first time, part 3

This is the first article in a multi-part series to guide you through your first weeks in Minion Enterprise.

Read More

How to use Minion Enterprise for the first time, part 2

This is the first article in a multi-part series to guide you through your first weeks in Minion Enterprise.

Read More

How to use Minion Enterprise for the first time

This is the first article in a multi-part series to guide you through your first weeks in Minion Enterprise.

Read More

PowerShell for fun (and profit?)

Let's have a liltle fun with PowerShell. Along with, I suppose, a couple of useful things and links.

Read More

In Beta: Health Check for Minion Enterprise!

At the PASS Summit we were thrilled to announce a new feature: Health Check for Minion Enterprise! Minion Enterprise already gathers a ton of information about your servers and SQL Server instances into a central repository, which is perfect for alerting, reporting and configuration. Now, we’re adding standard audits...

Read More

New book: Voices from the Data Platform (Kindle)

Before I even tell you about this book, go get the Kindle version for $10! for free, before the sale ends! (The sale has eneded.) Let Her Finish: Voices from the Data Platform The writing of this book was a collaborative effort taken up by 7 very talented IT professionals. ...

Read More

Which is the performance killer: SELECT INTO or INSERT INTO?

There are many ways to kill performance in a script or stored procedure.  However, not many think about the possibility that adding columns to a temporary table can kill performance.  Here, I’m going to show you how a simple design decision – using INSERT vs ALTER TABLE – can have...

Read More
Photo by Henry Hustava on Unsplash

Protect yourself from Ransomware with Minion Enterprise

Ransomware is becoming a huge problem in the corporate world as more and more companies fall prey to this heinous act of terrorism. One of the biggest disasters that could befall you as a company – or even specifically as a DBA – is to come in one day...

Read More

I’m the new DBA, and I’m locking down development servers

As the new DBA, I'm here to fix things for you. I'm going to take care of the things that keep causing fires and outages and slowdowns....and I'm locking down your dev environment. Here's why.

Read More

Posts Navigation

Categories

Archives