Select Page


Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.


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.

Anup Gopinathan | April 7, 2020

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.

Anup Gopinathan | August 29, 2019

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

Anup Gopinathan | January 30, 2019