The Upgrade Storm

Steve discusses upgrading your SQL Server and why it might make sense.

Localized Upgrades

Setting up R in SQL 2016 – Avoiding Pitfalls

Setting up R in SQL 2016 proved to be trickier than expected, but here is how to avoid the frustrations.

SQL Migrator (Part 2)

Automated Upgrade\Migration Tool for SQL Server

SQL Migrator (Part 1)

Read about a free automated Upgrade\Migration Tool for SQL Server.

Query Performance comparison between instances

Execute at source, and will generate an output with TSQL commands to create temp tables filled with top 50 long lasting queries from all databases.
Then execute output at destination and will do the same and show comparison of matching queries!!

The Bleeding Edge Versus N Minus One

Risk-averse managers are reticent to upgrade to the latest and greatest. Why is this the case and how can the savvy DBA make the case for and get ready for a newer version of SQL Server?

The Push to Upgrade from SQL Server 2005

There's a push to upgrade those SQL Server 2005 instances with support ending this April.

How to Upgrade SQL Server

What steps should you take in upgrading SQL Server to SQL 2014

Complete Definitions

When we write scripts, we often assume many settings will be at some default value. When we generate scripts, that's not the case. Perhaps we should be sure that we always include the settings we expect.