Decrypting Stored Procedures with SQL Compare

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

Reflections on the Software Industry

Every now and then we like to have someone do a guest post, with a topic of their own choosing. This time, we picked Kevin Miller (LI). Kevin is...

A New Word: Rückkehrunruhe

rückkehrunruhe – n. the feeling of returning from an immersive trip only to notice if fading rapidly from your awareness, as if your brain had automatically assumed it was...

Data Types - Does size really matter? - nvarchar vs. varchar

How many of us have created a new table and used the default and first data type nvarchar for all of the text/alphanumeric fields, or had...

Getting a Summary of Changes in SQL Compare 15

A client asked for a summary of changes, so I wrote this quick post to show where to find this in SQL Compare 15. If you use SQL Compare,...

The DevOps Roadshow(s) from Redgate

I’m back from an office trip this week to Pasadena. I had the chance to go to the office, do some internal training for people, and spend time with...

Updated training list for a new DBA

Met an eager young volunteer at SQLSatBR over the weekend who inspired me to update a blog post that hadn't been refreshed in a few years. See the [UPDATED] Training...

Adding Copilot to Azure Data Studio and a Few Experiments

As a part of a recent Data Exposed that I was on, there was an ADS update which mentioned Copilot being added. Since I’ve been experimented, I decided to...

Appalachian State Cyber Summit – September 8, 2023

Looking to attend a security summit in cooler weather that will benefit students? Applachian State holds an annual cybersecurity summit and this year it is scheduled for September 8,...

A Basic SQL Script to Monitor Long Running SQL Server Agent Jobs

A Basic SQL Script to Monitor Long Running SQL Server Agent Jobs

 As a SQL Server DBA, especially Production/Operations DBA in a relatively large environment,...