How to Save Money on SQL Server Licensing by Upgrading
November 21, 2022
If you have SQL Server instances that are out of support, which is any version prior to SQL Server 2014, then I’m sure you have your reasons for not upgrading to a newer version. Let’s take a quick look at those reasons and then examine one reason you might not have considered. My hope is
SQL Server Migration Considerations from a Jr. DBA
November 16, 2022
SQL Server migrations are a necessary and expected part of keeping a modern SQL Server deployment. We have worked with many clients on migration projects, and I have organized some considerations for you and your team before, during, and after your SQL Server migration. We recommend working with a SQL server DBA on these kinds
SQL Server In Place Upgrades: Too Expensive?
April 10, 2020
About eight years ago, I wrote a (kind of long) answer to a DBA. Stackexchange question, “Are SQL Server In-Place upgrades as ill-advised as they used to be?” My summary answer on the top of my tome was: Short Answer – In Place is okay. You can review your configuration afterward and implement the best practices
SQL Server Upgrade Checklist
March 7, 2019
Last week, I wrapped up the delivery of a 4-part webinar series giving tips about SQL Server upgrades. I talked about how critical a SQL Server Upgrade Checklist is to the success of your SQL Server upgrade projects and promised a checklist. Here it is! This is a free download, no e-mail address required. Check
After Your SQL Server Upgrade – Upgrading SQL Server Webinar Episode 4
March 7, 2019
This article is part of our SQL Server Upgrades Made Easy series: Why Upgrade? Before You Upgrade During Your Upgrade After Your Upgrade Recap Chat Upgrading SQL Server – Week 4 “After You Upgrade SQL Server” You can watch the previous 3 weeks on youtube. This is the last video from the webinar portion of the
During Your SQL Server Upgrade – Upgrading SQL Server Webinar Episode 3
February 28, 2019
This article is part of our SQL Server Upgrades Made Easy series: Why Upgrade? Before You Upgrade During Your Upgrade After Your Upgrade Recap Chat Upgrading SQL Server – Week 3 “During Your Upgrade SQL Server” You can watch week one here on the blog or directly on youtube. You can also check out week
Before you Upgrade Your SQL Server – SQL Server Upgrade Webinar Episode 2
February 20, 2019
This article is part of our SQL Server Upgrades Made Easy series: Why Upgrade? Before You Upgrade During Your Upgrade After Your Upgrade Recap Chat Upgrading SQL Server – Week 2 “Before you Upgrade SQL Server” You can watch week one here on the blog or directly on youtube. Please consider subscribing to the channel
“Basic” Availability Groups – Some Rumors Persist
February 19, 2019
I was having a twitter interaction the other day. Since High Availability and Disaster Recovery topics are on my mind as I just wrapped up delivering an online class on SQL Server HA/DR last week and am preparing for my next free webinar series talking about HA/DR, that twitter thread piqued my interest. The short
Why Upgrade SQL Server? SQL Server Upgrade Webinar Episode 1
February 16, 2019
This article is part of our SQL Server Upgrades Made Easy series: Why Upgrade? Before You Upgrade During Your Upgrade After Your Upgrade Recap Chat Upgrading SQL Server – Week 1 “Why, Why, Why!” This is the first video from the series from two weeks ago. This is an introduction to the SQL Server upgrade
Tara’s favorite SQL Server 2012+ Feature
February 16, 2019
If you’re still on SQL Server 2008/2008 R2, you’re missing out on some great features. It’s no secret that Availability Groups are my favorite feature since SQL Server 2012. Back in the day, I was supporting complex environments with aggressive SLAs. On one particular system, I had Failover Clustering for HA, Asynchronous Database Mirroring for