Describing the two main use cases for occasional "cherry picking" of Flyway database migration scripts: back-filling emergency production hotfixes to version control and managing parallel development streams.

Query Audit data in Azure SQL Database using Kusto Query Language (KQL)

by Additional Articles

MSSQLTips.com

Azure

In this article we look at how you can user the Kusto Query Language (KQL) for querying Azure SQL Database audit data.

Malleable Source Control

by Phil Factor

SQLServerCentral

Git has proved to be a better fit to the needs and workflow of a database development team than anything that came before. Git is valuable because it encourages branching and merging, giving more choice in the way that your team can work. Due to the ease with which you can adapt Git, there is […]

I Hate To Send This Email

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones wonders how many of us have had to send, or will have to send this email.

Solving FIFO Queues Using Windowed Functions

by J. Drew Allen

SQLServerCentral.com

FIFO Queues

One common request often seen in T-SQL is working with queues of information. In this piece, J. Drew Allen will show to use windowing functions and the OVER clause to process a FIFO queue.

Automating Migrations for Multiple Databases using Flyway

by Additional Articles

Redgate

Vendors/3rd-party Products

During development you need a fast, automated way to build multiple copies of a database on any development or test server, with each database at the right version. This article provides a PowerShell automation script for Flyway that will do the job.

Exploring Four Simple Time Series Forecasting Methods with R Examples

by Additional Articles

MSSQLTips.com

R Language

In this article we explore four simple time series forecasting methods using R: the Mean Method, the Naive Method, the Seasonal Naive method and the Simple Moving Average Method.