Blog
Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.
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.
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.
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.
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.
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.
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.
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.
Delayed Durability in SQL Server
In this post we’ll touch on RDBMS, WAL and ACID. Then we may use SSMS and write some TSQL for an introduction to a new SQL 2014 feature, Delayed Durability.
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.