If you are like me and love to keep up with the latest news in the Database, SQL and Cloud world, this is your place. Here is a short list of the blogs posts that got my attention during the past week. I hope you like them!

Five facts about the SQL Server TempDB Database: “The tempdb database is one of the SQL Server system databases. While many database specialists often have a chance to work with the tempdb database, I have noticed that there are many myths, misconceptions, and misleading opinions around this database even among DBAs and database developers. In order to disprove some common myths and provide information about some useful features of tempdb, we will cover five facts about this database in this article.”

Syncing your SQL Server database backups to an AWS S3 bucket: “”Sometimes” just having all the database backups in one place is not enough. In fact, most of the time, putting all the eggs in one basket is a bad idea. You want to have some piece of mind that during the time of crisis, all your database backups are restorable. This is probably why many companies offered offsite backup services before the public cloud became so popular. While the public cloud changed a lot of things, the need for offsite storage is still there. This article is going to discuss how to send a copy of your SQL Server database backup files from AWS EC2 to an AWS S3 bucket.”

Invisible MySQL: ” Is MySQL going invisible?  Invisible Indexes were included in MySQL 8.0 and now with version 8.0.23 we have Invisible Columns.”

The Answer is Postgres; The Question is How?: “You have a number of good options for how to run Postgres: run it in VMs, as a managed service or bare metal. Benjamin Good, a Google Cloud Solutions Architect, wrote a helpful blog post of when to run databases on Kubernetes; a common question and increasingly popular and successful option. So which deployment model is appropriate for you? As usual, it depends.”

Why is there database named ‘Postgres’: “Every so often, on irc, someone asks if they can remove postgres database, and why is it even there. Figured I can write one blogpost to answer it once and for all, and use it as ready answer whenever the question resurfaces.”

And this is it. I hope you enjoyed reading them as much as I did. Have a nice weekend and keep yourself healthy!