Articles

Connect, share and learn with the global data community in Seattle this November. Whether you're a DBA, Developer, Architect, Engineer or you're just getting started in your data career, there's a huge range of content for you to choose from (over 150 sessions and counting across 5 different tracks). Speakers this year include Steve Jones, Grant Fritchey, Ryan Booz, Bob Ward, Deepthi Goguri and Jennifer Stirrup. Check out the full program and register before September 18 to secure your ticket at the standard price.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2024-09-16 (first published: 2024-08-19)

The Mastering Azure Data Studio Series

by Steve Jones

SQLServerCentral

A list of articles in my series on Azure Data Studio along with a few other links.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2024-09-13 (first published: 2024-01-10)

3,204 reads

Discuss

Introducing the New Stars of Data speakers for PASS Summit 2024

by Additional Articles

SQLServerCentral

PASS Summit

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!

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2024-09-13

LIKE Constraints

by Additional Articles

SimpleTalk

Uncategorized

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.

2024-09-13

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2024-09-11

2,316 reads

Discuss

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.

2024-09-11

GitHub Desktop Tutorial

by Daniel Calbimonte

SQLServerCentral

Git
GitHub

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

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(1)

You rated this post out of 5. Change rating

2024-09-09

4,514 reads

Discuss

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.

2024-09-09