Developers need to consider not only system performance when writing code, but also how readability impacts code maintenance.

Different Ways to Import JSON Files into SQL Server

by Additional Articles

MSSQLTips.com

JSON

Nat Sundar explains the different ways to load JSON data into SQL Server, along the way also covering the use OpenRowset and OpenJSON functions to manage JSON data effectively.

A New SQL Server Edition

by Steve Jones

SQLServerCentral.com

Editorial

A new edition of SQL Server came out this week from Microsoft.

If only the US would follow ...

by Steve Jones

SQLServerCentral.com

Editorial

Governments are requiring better security, and Steve wishes the US would follow.

Set-Based String Splitting table function

by bevan ward

SQLServerCentral.com

T-SQL

Describe and provide a set-based method that takes a multiple character split term and returns as a table

What is the State of My Transparent Data Encrypted Database?

by Additional Articles

SQLServerCentral

Transparent Data Encryption (TDE)

When using Transparent Data Encryption, you might wonder “What is the state of my transparent data encrypted database?” Read on to learn the many different states that a transparent data encrypted database might go through.

TEMPDB Enhancements in SQL Server 2016

by Dharmendra Keshari

SQLServerCentral.com

tempdb

TEMPDB Enhancements in SQL Server 2016 - By default enforced to follow best practices.

Data Encryption Using Always Encrypted in SQL Server

by Additional Articles

SQLServerCentral

Encryption

The key challenge for application developers is to build a foolproof system to ensure data security. This is not only more intense, but more complex these days, as many organizations are planning to move their applications to the cloud. Read on to learn more.