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.

Author: Andy McDermid
Browse Blog Categories

Automating Replication Tear-downs and Rebuilds

SQL Server replication will not stand up to some kinds of DDL. This blog post will take you through the process to automate replication tear-downs and rebuilds.

Andy McDermid | April 6, 2017

Reducing SQL Server 2000 to SQL Server 2014 DB Migration Outages

Upgrade your database from SQL2000 to SQL2014 with a 2-hop migration plan, steps outlined here to reduce outages.

Andy McDermid | February 1, 2017

Provisioning SQL Server on Azure VMs

This blog post gives you all the details in order to determine the just-right size to help stand up an Azure Virtual Machine to host your SQL server.

Andy McDermid | January 9, 2017
Native SQL Backups

Making the Case for Native SQL Backups

There are many different types of backups to use in SQL Server. Why use native SQL backups? Find out here.

Andy McDermid | December 13, 2016
Azure Alternative

Microsoft Azure As an Alternative to a Data Center

Thinking about using Microsoft Azure as an alternative to a data center? Learn about the features and benefits of Azure cloud services.

Andy McDermid | November 9, 2016

Retrofit Vintage SQL 2005 Databases

Read about a couple of very handy backup features included in more recent versions of SQL that you don’t get with vintage databases.

Andy McDermid | May 31, 2016
Cardinality Estimation

Cardinality Estimation in SQL Server 2014

The SQL Cardinality Estimator (CE) is the critical piece of SQL query processing that calculates the metrics which determine a query plan’s memory allocation, its shape, and its operators.

Andy McDermid | February 25, 2016

Delayed Durability in SQL Server

All in the service of an introduction to a new SQL 2014 feature, Delayed Durability (yes, it’s all spelled out, you’ve got to draw the line somewhere.) RDBMS stands for Relational Database Management System.

Andy McDermid | November 12, 2015

Tips for Upgrading From SQL 2008 to 2012 or 2014 Part 2

Previously, I mentioned in part 1 that a line has been drawn bisecting the upgrade path leading from SQL 2008 versions to SQL 2012+. As of SQL 2012, Microsoft has implemented a new licensing scheme and SQL instances are now licensed by core rather that by CPU.

Andy McDermid | July 8, 2015

Tips for Upgrading From SQL 2008 to 2012 or 2014

It’s 2015 and you can now establish totally respectable MS SQL DBA credibility just by mentioning you have been in the game since SQL Server version 9. You may even get the same gasps of shock from some colleagues that used to be reserved for the version 6 veterans.

Andy McDermid | April 8, 2015

SQL Server Enterprise Edition Features You Didn’t Know You Could Use

Features Supported by the Editions of SQL Server Microsoft has very nice documentation covering which features are available for each version and edition of SQL Server. I refer to these pages fairly often, usually on Mondays when I can’t remember if some particular feature is available in Standard Edition (SE) or if it is Enterprise […]

Andy McDermid | March 18, 2015

Right-sizing Multiple tempdb Files

To follow up on my last post, “TempDB and Instance Standards,”  here is a look at how to get the file sizing correct if or when it is determined that multiple tempdb files are a necessity. See that post for a discussion as to why multiple tempdb files might be needed. This post just concerns methods to […]

Andy McDermid | March 9, 2015

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.


Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.