Category: AWS
-
Babelfish for PostgreSQL, what the heck is that?
A short answer is: Babelfish is an extension for PostgreSQL, that allows your SQL Server applications to speak to PostgreSQL in their native language. The next question you probably have is: “Why would I ever want my applications to do that?” And it’s a valid question, to which the answer would be, to modernize your…
-
Open-source vs. commercial database systems
While SQL Server has been one of the cornerstones of my 25+ years career in IT, I’ve occasionally wandered out of my commercial databases comfort zone to the open-source database space (PostgreSQL and less frequently MySQL). These forays to the open-source database systems have definitely become more common as I started working with the public…
-
Well-Architected Framework (for Databases)
If you work mainly with on-premises and focus on databases, there’s a good chance that you are not familiar with the concept of a Well-Architected Framework (WAF). However, while you might not be familiar with the term, you probably are already doing things related to it. How do I know that, you ask? Because, ultimately,…
-
Seeing database cloud migrations as opportunities, rather than risks.
Database migrations are typically one of the biggest challenges when we’re moving applications to the cloud. The reason for it is obvious, databases, or rather their contents, are the lifeblood of many businesses. This makes people rather cautious, when dealing with database migrations. I like that, caution is good. Applications and their servers, on the…
-
Why I know DBA role survives the public cloud.
For the past 10 years or so, I’ve seen it occasionally come up in the discussions that DBA won’t be needed in the future. Originally, it started with the vendors claiming that their database systems are becoming self-tuning. Then the final nail in the coffin was to be the public cloud, which was also to…
-
Database Migration, Modernization, and R-strategies.
Public cloud is a really great place to put your application and database workloads. However, it’s not always clear how, exactly, that should happen. Some people talk about migrating, others about modernizing, a few mix everything together, and then there is a bunch of words that all start with the letter R. In this post,…
-
AWS Purpose-Built Databases, Part 3 of 3.
All good things must come to an end, including this 3 part blog post series. In this post, we’ll dive into one of the database systems I am not hugely familiar with, Apache Cassandra, and it’s AWS counterpart, Keyspaces. What is Cassandra, then? It’s an open-source distributed, wide column data store that is capable of…