T-SQL Tuesday #147 – SQL Server Upgrade Strategies

T-SQL Tuesday #147 – SQL Server Upgrade Strategies

Thanks to Steve Jones for hosting February month of T-SQL Tuesday! This month T-SQL Tuesday is all about SQL Server upgrades. Thank you, Kevin and Deepthi for the reminder. I had forgotten about T-SQL Tuesday this time but hopefully, the below, although...
Should we run SQL Server on the default port 1433

Should we run SQL Server on the default port 1433

There are two types of DBAs. Those that run SQL Server on the default port 1433 and those that don’t. Those that do not run on the default port 1433 say it’s more secure, and those who do say it’s “security by obscurity” do not make it...
To log backup or not to log backup

To log backup or not to log backup

SQL Server has been around for decades, but I still come across companies that do not have dedicated DBAs and do not understand the concept of Log Backups, which often means they put their data at risk. Recovery Objectives Let’s start with the basics. The best...
How I built the Data Community Events Aggregator

How I built the Data Community Events Aggregator

Not a strictly SQL Server related topic, but I know many of you want to know this. Let’s talk about how I built the Data Community Events Aggregator. When the Great Lockdowns of 2020 started, most user groups and community conferences went online. This has...