A SQL Prompt AI Experiment with Window Clauses

SQL Prompt has an EAP with some AI capabilities. I was asked to do some testing, and while I’ve done relatively little, I did find some time to play...

Friday Flyway Tips–Comparison Options

Recently a customer asked how they could get index changes to be captured in Flyway Desktop. In their case, they wanted a different fill factor, but I decided to...

Understanding I/O Freeze in SQL Server 2022's TSQL Snapshot Backups

SQL Server 2022 introduces a new feature to enable application-consistent snapshot backups. TSQL Snapshot Backups enable the SQL Server to control the database quiesce without external tools. Using TSQL...

Accounting for Virtualization Head Room

In this post, I discuss about not forgetting to allow for additional head room when planning out new hardware, especially for HA/DR needs.
The post Accounting for Virtualization Head Room...

Becoming Kristyna Ferris <3

Hey folks, fun personal post today. A few weeks ago, I got married! My amazing new husband is Kyle Ferris, and I will be changing my name to Kristyna...

“Surviving the Digital Heatwave: Lessons Learned from Singapore’s Datacenter Meltdown”

Today, we’re unpacking a real-world tech drama that unfolded in Singapore, offering a stark reminder about the vital role of Disaster Recovery (DR) planning and the often overlooked, yet...

Databricks Unity Catalog primary key and foreign key constraints are not enforced

I’ve been building lakehouses using Databricks Unity catalog for a couple of clients. Overall, I like the technology, but there are a few things to get used to. This...

TryHackMe Advent of Cyber

I posted that I was thinking about the AdventOfCode this year, but wasn’t sure I’d spend the time. Someone then posted a link to the TryHackMe advent calendar. I...

Removing a PowerShell Array Element–#SQLNewBlogger

I saw an article on this and realized I had no idea how to do this, so I decided to practice a bit. I don’t work with PoSh arrays...

Beginner's Introduction to PowerShell Remoting

Beginner's Introduction to PowerShell Remoting

...