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 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.

How to Create Temporal Tables in SQL Server 2016

Analyze data faster with Temporal Tables in SQL Server 2016. Get the details (sample code included).