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

Restoring SSAS Cubes to a SQL 2022 Server with CU5

I have a client who was upgrading some servers from pre-2022 versions of SQL Server to SQL Server 2022 CU7. They had some multidimensional SSAS cubes that were to...

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

Friday Flyway Tips: Copying the Migration Number

It’s a small thing, but copying the migration number can be a pain. However, we’ve made this easier in Flyway 6.5.4. I’ve been working with Flyway Desktop for work...

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

Another option is coming to gain extended support for SQL 2012

Another option is coming to gain extended support for SQL 2012

If you still have SQL 2012 servers, you are probably aware that support...

Quick Tip About Fonts in Deneb Visuals in Power BI

This week, I was working with a client who requested I use the Segoe UI font in their Power BI report. The report contained a mix of core visuals...

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

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