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

T-SQL Tuesday #168–Roundup

Last week was the 168th T-SQL Tuesday, which I hosted. The invitation is here. I didn’t get much of a chance to check out the posts as I was...

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

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

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

Beginner's Introduction to PowerShell Remoting

Beginner's Introduction to PowerShell Remoting

...

Microsoft Fabric is now GA!

After more than two years in development and six months in public preview, Microsoft Fabric is now generally available (GA). Here is the announcement made during Microsoft Ignite last...

Changing the Data Type of a Primary Key–#SQLNewBlogger

A client asked this question recently: How do I change my numeric PK to a character type? I decided to write a short blog on how to do this....

Building Upon Your Productivity Momentum: Staying Productive For Life

Note: I found this sitting in my Medium draft. This was a cross-post from my old productivity blog that got lost in oblivion. Productivity is never an accident. It...

Is that the right question to ask?

This is not a “clickbait” title, but an important consideration when it comes to developing technical solutions. Let me give you an example between two questions for SQL Server...