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.
Knowing What You Don't Know
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 […]
Blogs
A New Word: los vidados
By Steve Jones
los vidados – n. the half-remembered acquaintances you knew years ago, who you might...
In-Person CISA Training – April 13-16, 2026
By Brian Kelley
I will be leading an in-person Certified Information Systems Auditor (CISA) exam prep class...
EightKB 2026
EightKB is back again for 2026! The biggest online SQL Server internals conference is...
Forums
query to track time spent on individual tasks in SSIS
Hi everyone I am looking at building a query to determine how much time...
SQL Server Transactional Replication from Always On Availability Groups to Azure SQL Database
Comments posted to this topic are about the item SQL Server Transactional Replication from...
Hidden Heroes
Comments posted to this topic are about the item Hidden Heroes
Question of the Day
Identities and Sequences I
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which are explicitly linked to increment a number in a table when a new row is added?
See possible answers