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 […]

Container Development Work

by Steve Jones

SQLServerCentral

Virtualization, containers, and k8s

Steve talks about using containers for development work today.

SQL ROUND Function vs. Bankers Rounding with T-SQL

by Additional Articles

MSSQLTips.com

T-SQL

Learn about rounding values using T-SQL and how the ROUND function works compared to creating a user-defined function for bankers rounding.

Fifty Percent

by Steve Jones

SQLServerCentral

Career Growth

What percentage of a job's requirements should you have? Steve says fifty percent.

Stairway to Columnstore Indexes Level 6: Updating and Deleting Data in a Columnstore Index

by Hugo Kornelis

SQLServerCentral.com

This level looks in detail at what happens when we update or delete data from a clustered columnstore index, the impact it has on concurrent data access, and how without careful maintenance the efficiency of columnstore indexes can degrade over time.

I Must Be an Idiot: Automatic Tuning Never Works for Me.

by Additional Articles

Brent Ozar Blog

Automatic tuning

I don’t get it. I’ve given this feature one chance after another, and every time, it takes a smoke break rather than showing up for work.

How to Recover a Corrupted Azure Data Factory Integration Runtime

by diponkar.paul

SQLServerCentral

I would like to share my recent experience with Azure Data Factory (ADF) where AutoResolveIntegrationRuntime become corrupted and how did I recover it. I still don't know how the Integration Runtime (IR) was corrupted. However, if it happens, then this article will help you to solve the issue. Problem In general, the ADF AutoResolveIntegrationRuntime should […]