Author: Andy McDermid

Andy is a MCITP certified MS SQL DBA who delivers and manages delivery of DBA services to many diverse clients. He enjoys helping his clients by finding and deploying pragmatic and practical solutions for their database issues. Andy is always working to improve and expand his DBA skills and he likes to share the experience via writing.

Principal SQL Server DBA

Andy McDermid

Andy is a MCITP certified MS SQL DBA who delivers and manages delivery of DBA services to many diverse clients. He enjoys helping his clients by finding and deploying pragmatic and practical solutions for their database issues. Andy is always working to improve and expand his DBA skills and he likes to share the experience via writing.

Articles Written by Andy McDermid

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.

Read More

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

Read More

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.

Read More

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

Read More

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

Read More

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

Read More

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.

Read More

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.

Read More

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.

Read More

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.

Read More