Blog

How To Fix Log Shipping Failure Errors In SQL Server

Learn how to fix common Log Shipping Failure errors in SQL Server. Follow Datavail’s step-by-step instructions, screenshots, and software script here!

Striped SQL Server Backups with Azure Blob Storage

Microsoft has been investing in their cloud platform, Azure; the best part of this is the added capabilities in the next version of SQL Server 2016.

TempDB Database Enhancements with SQL Server 2016

TempDB is a critical system database that has been available with SQL Server for ages. Here are some enhancements in conjunctions with SQL Server 2016.

Merging the Hybrid World of Blobs and SQL Server 2016 with Polybase

There are a number of new capabilities introduced in SQL Server 2016. One of the features that is not often discussed is a tool called Polybase.

Top 3 SQL Server Management Studio Enhancements with SQL Server 2016

This blog is dedicated to the SQL Server 2016 feature that caught my eye first: the new SQL Server Management Studio look and feel.

Microsoft SQL Server Developer Edition Is Now Free

Microsoft recently announced that SQL Server 2014 Developer Edition is now free to download for Visual Studio Dev Essentials members.

Top 2 LOBs Enhancements with Memory Optimized and Native Compilations

There are many limitations which are being lifted by SQL Server 2016. This blog will demonstrate two of the most wanted features.

Parameter Sniffing with Database Scoped Configurations in SQL Server 2016

Parameter sniffing is a phenomenon in SQL Server where SQL optimizer would “sniff” the value of parameter during compile time. Read more.

StretchDB Got Easier With SQL Server 2016

The next version of SQL Server is loaded with features where the cloud technologies are playing a very important and vital role. Learn more about them here.

ColumnStore Index on Steroids with SQL Server 2016

ColumnStore index is a non-conventional index where only one column is stored in page. This feature was introduced in SQL Server 2012 but is still largely unknown.

Backup Enhancements Inside SQL Server 2016 Just Got Better

Read about some of the xtensive improvements introduced inside SQL Server 2016 like extension to managed backups and backup to block blobs.

Performance Improvements with Live Query with SQL Server 2016

New capabilities get added with every single version that get introduced in every software. SQL Server 2016 is no brainer in this challenge.