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.

Expanded Support for Non-Windows SQL Server

• by Steve Jones

• SQLServerCentral

• humor

Steve is excited that SQL Server is moving to a new platform.

Power BI Reports in SSMS

• by Steve Jones

• SQLServerCentral

• humor

Get more interactive reports in SSMS.

Considerations for Running SQL Server on Kubernetes

• by Additional Articles

• MSSQLTips.com

• Containers

In this article we discuss deploying SQL Server containers / images using Azure Kubernetes Cluster.

Using Flyway Output in PowerShell

• by Additional Articles

• Redgate

• Vendors/3rd-party Products

How to send Flyway logging and error output to JSON and consume it in PowerShell to produce ad-hoc database migrations reports, including any errors that occurred, the version of the database, runtimes for each migration script and more.

Constant Integration

• by Steve Jones

• SQLServerCentral

• Auditing

Apple buys a company every few weeks. The data integration for this must be a large effort.

Datatypes and the Default Mask with Dynamic Data Masking - Step 2 of the Stairway to Dynamic Data Masking

• by Steve Jones

• SQLServerCentral.com

This article digs deeper into the ways that Dynamic Data Masking works with different data types.

What is interpolation?

• by Additional Articles

• SimpleTalk

• T-SQL

In this article, Joe Celko explains interpolation and covers a bit about the history and what we all did before computers.