Resumable Online Index Create and Rebuild Operations

Index maintenance can be a real headache for database administrators as tables grow larger and maintenance windows shrink. In this article, Greg Larsen demonstrates resumable index operations available with SQL Server 2017 and 2019. This feature helps DBAs work around those small maintenance windows by allowing certain index operations to be paused and restarted again later.

SQL Server 2017 Build List

A list of builds for SQL Server 2017.

How Big is Your Transaction Log?

If you are not managing the transaction log space used by a database, the transaction log might grow uncontrollably. With SQL Server 2017 there is a new dynamic management function (DMF) that exposes statistical information about a database transaction log. One of the things you can do with the information returned from this DMF is to determine how full a database transaction log file is.

Import flat files to SQL Server on Linux using Azure Data Studio

Have you ever wonder how to import flat files to SQL Server on Linux? In this article, I will share my experience loading data to a Linux SQL Server instance using the new Azure Data Studio data import extension from macOS.

SQL Server 2008 Migration to SQL Server 2017 Linux Containers using Database Cloning

Learn how you can get a SQL Server 2017 container working with Docker and Windocks.

Logshipping to SQL Server on Linux

An example of a database migration from SQL Server 2016 on Windows to MS SQL Server 2017 on Linux.

SQL Server Graph Databases – Part 4: Working with Hierarchical Data in a Graph Database

The Graph Database feature, new with SQL Server 2017, can be used to represent hierarchies. In this article of the series, Robert Sheldon demonstrates how to represent hierarchies in data with complex relationships.

Automated Indexes

Provisioning SQL Server Instances with Docker

With SQL Server 2017, Microsoft announced the exciting news that SQL Server would now run in Docker containers. Laerte Junior provides a guide to get started creating SQL Server instances in Docker.

TRIM() in T-SQL

The T-SQL language expanded in SQL Server 2017 with the TRIM() function.