Welcome to Datavail’s Blog, where you can read the latest insights, tips and opinions of our experts on all things data and technology.
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.
Upgrade your database from SQL2000 to SQL2014 with a 2-hop migration plan, steps outlined here to reduce outages.
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.
Thinking about using Microsoft Azure as an alternative to a data center? Learn about the features and benefits of Azure cloud services.
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.
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.
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.
Datavail SQL Server DBA, Andy McDermid, lays out helpful tips for upgrading from SQL 2008 and beyond. Click to learn more.
Microsoft has very nice documentation covering which features are available for each version and edition of SQL Server.
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.