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.


Tips for Upgrading From SQL 2008 to 2012 or 2014

Datavail SQL Server DBA, Andy McDermid, lays out helpful tips for upgrading from SQL 2008 and beyond. Click to learn more.

Andy McDermid | April 8, 2015

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

Microsoft has very nice documentation covering which features are available for each version and edition of SQL Server.

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.

Andy McDermid | March 9, 2015

TempDB and Instance Standards

One of the ‘best practice’ practices I like to consider putting in place on a SQL instance is multiple tempdb files to eliminate any chance of tempdb allocation contention.

Andy McDermid | March 6, 2015

Three Ideas for Returning Microsoft SQL Queries Faster

Would you like to make your users happy? Give them the information they need through optimization that allows SQL queries to be returned faster.

Andy McDermid | January 13, 2015

Where Can You Run SQL Server?

If you want to run SQL Server, you’re no longer limited to having it operate from a box in a closet. You have a lot of choices, some of which we cover below.

Andy McDermid | December 26, 2014

Microsoft Releases Final SQL Server 2008 Service Pack

Microsoft announced it was releasing a final update for the SQL Server 2008 Service Pack recently.

Andy McDermid | November 11, 2014

Solving SQL Server Issues: The Long Road

You can easily resolve some issues related to SQL Server performance, but there are others that require more time and resources.

Andy McDermid | October 7, 2014

Solving SQL Server Issues: The Best Bang for the Buck

There are many issues that can affect the health and stability of your SQL Server performance.

Andy McDermid | October 6, 2014