Blog

AlwaysOn Availability Groups: Non-container Objects Synchronization Scripts

The AlwaysOn Availability Groups feature keeps databases in sync for HA, but the non-container objects need to be copied over manually, here’s a script to help.

SQL on Linux: Exploring the System Utilities on Linux

SQL Server expert JP Chen takes on the three popular tools to help explore the systems utilities on Linux: htop, glances and iostat.

SQL on Linux: Configuring SQL on Linux with the mssql-conf tool

SQL Server expert JP Chen walks users through the configuration of SQL on Linux with the mssql-conf tool.

SQL on Linux: Creating, Backing up & Restoring a Database

Essential steps outlined to create, back up and restore a database for SQL on Linux.

SQL on Linux: Connecting to and Querying SQL on Linux

SQL Server expert JP Chen maps out the steps to cover connecting and querying SSMS and Azure Data Studio.

SQL Server 2019 New Features: Batch Mode on rowstore

SQL Server 2019 public review CTP 2.0 brings us some exciting query performance improvements like the Batch mode on rowstore.

On-Demand Training: Improve SQL Performance with Query Tuning Techniques

If you’re responsible for keeping your SQL databases in peak condition, you know what a challenge it can be.

Top SQL Server 2016 Features: Query Store

Microsoft SQL Server 2016 includes a new Query Store feature, which provides DBAs with insight into query plan choice and performance.

Top SQL Server 2016 Features: The Stretch Database

The Stretch Database is one of the more important new features of SQL Server 2016 that blend on-premise and cloud environments into a single entity.