Learn about more of the T-SQL language changes in SQL Server 2022. This article is the third in a series and will cover the changes to the JSON functions.
The post T-SQL Language Changes in SQL Server 2022 Part 3 appeared first on SQLServerCentral.

In this article, we walk through the steps and examples of how to use Secure File Transfer Protocol (SFTP) when working in Azure.
The post Secure File Transfer Protocol (SFTP) support for Azure Blob Storage appeared first on SQLServerCentral.

Where does data fit into the digital transformation story? Discover how and why it deserves a place in this fascinating piece from Pramod Sadalage, principal consultant at Thought Works
The post Enabling digital transformation – and data modernization – with DevOp appeared first on SQLServerCentral.

This article dives into all the math required to convert historical times between time zones.
The post Converting Data Across Time Zones: An In-Depth Primer appeared first on SQLServerCentral.

This article demonstrates how we can use a Flyway placeholder as a simple on/off switch for each task, during Flyway migrations.
The post Executing Optional Code in Flyway Callbacks appeared first on SQLServerCentral.

The examples so far in this series have all used repeatable read isolation to acquire shared locks on qualifying rows and hold them to the end of the transaction. This was convenient for the demos but repeatable read isolation isn’t common in everyday use.
The post The Lock Escalation Threshold – Part 3 appeared first on SQLServerCentral.

This article looks at how to calculate MACD indicators using a set of T-SQL code and data stored in a SQL Server database.
The post Building a SQL Computational Framework for MACD Indicators appeared first on SQLServerCentral.

For those new to Flyway Desktop, this article takes a strategic overview of the components of a Flyway Desktop project, how to set up a project for team-based development work, and how we can use the tool in conjunction with a version control system and CI servers to manage a database development and release process.
The post Flyway Desktop in Database Development Work: An Overview appeared first on SQLServerCentral.