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...
2023-12-08
28 reads
Blog Posts
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...
2023-12-08 (first published: 2023-11-21)
588 reads
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...
2023-12-07
19 reads
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...
2023-12-07
41 reads
“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...
2023-12-06 (first published: 2023-11-21)
425 reads
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...
2023-12-06 (first published: 2023-11-22)
266 reads
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...
2023-12-06
15 reads
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...
2023-12-05 (first published: 2023-12-04)
167 reads
2023-12-04 (first published: 2023-11-20)
917 reads
Importing Flat Files into Azure SQL DB
Initially, I thought I would have to use sqlcmd because I’m on a Mac and don’t have SSMS. It turns out Azure Data Studio has a nifty way to...
2023-12-04 (first published: 2023-11-20)
582 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers