In this article, I will cover a bit about the LIKE operator, including how it works, and a bit of history about why it is like it is. After establishing this, I will discuss a bit about how you can (and should) use the LIKE operator in your CHECK constraints to strengthen your data integrity.

Casino Night is Back

by Steve Jones

SQLServerCentral

Casino Night from SQL Server Central is coming back to the PASS Data Community Summit.

Delta Table Performance Is Governed By Transaction Size: Data Engineering with Fabric

by John Miner

SQLServerCentral

Microsoft Fabric (Azure Synapse, Data Engineering, etc.)

This next article examines the impact of transaction sizes on the performance of our Delta Parquet tables.

Event Streams for Persistent and Asynchronous Microservice Communication

by Additional Articles

MSSQLTips.com

software development

This article looks at how you can use event sourcing to maintain persistent and asynchronous communication between microservices.

GitHub Desktop Tutorial

by Daniel Calbimonte

SQLServerCentral

Git
GitHub

Learn the basics of using Git and Github with the desktop application.

The Invisible Disk

by Steve Jones

SQLServerCentral

Hardware

Steve sees disk drives as shrinking to the point of being invisible to most of us.

Effective Strategies for Storing and Parsing JSON in SQL Server

by Additional Articles

SimpleTalk

JSON
T-SQL

Like XML, JSON is an open standard storage format for data, metadata, parameters, or other unstructured or semi-structured data. Because of its heavy usage in applications today, it inevitably will make its way into databases where it will need to be stored, compressed, modified, searched, and retrieved.

Knowing What You Don't Know

by drsql@hotmail.com

SQLServerCentral

Database Weekly

I used to think I knew everything. I felt like I had the world all figured out. But then, when I went to kindergarten, I realized that I didn't know much at all. As I grew older and finished college, I regained confidence in my knowledge and again felt like I knew everything about the […]