Introduction to IaC: Deploying Data infrastructure to Azure using Terraform (Part 1 - Intro and prerequisites)

IntroductionOne integral part of modern Continuous Integration and Continuous Development (CI/CD) pipelines is the ability to create the underlying infrastructure as part of the pipeline in a consistent and...

Simplify Your Work with PowerShell Scripts: Running from the Command Line

Introduction
You know that feeling when you have your PowerShell script written, saved and now you need to execute it? But every time you want to use the script, you...

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