A Simple Solution
Today Steve wonders if you have simple solutions you like or complex ones you don't.
The Mastering Azure Data Studio Series
A list of articles in my series on Azure Data Studio along with a few other links.
Introducing the New Stars of Data speakers for PASS Summit 2024
Three new speakers will be taking to the stage at this year's PASS Data Community Summit for the New Stars of Data Track. Sessions will be delivered by Haripriya Naidu, Vitalija Bartusevičiūtė, and Jarid McKenzie!
LIKE Constraints
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
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
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
This article looks at how you can use event sourcing to maintain persistent and asynchronous communication between microservices.
The Invisible Disk
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
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.
Blogs
Local LLM Models at SQL Saturday Boston 2025
By Steve Jones
I’m starting a long trip at Boston this weekend. I’ll be there Saturday speaking,...
3 things you must do to start data quality management right
As a data & AI strategist who’s seen countless projects succeed and fail, I...
Set Theory vs. Batch Mode in SQL Server
By SQLPals
Set Theory vs. Batch Mode in SQL Server Not long ago,...
Forums
SSC Website Deployment 24 Sept 2025
We are planning on a fairly big code deployment to set the stage for...
Timeout when expanding the table
Experts, I am hoping to get some help and feedback. I have a server...
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers