October 28, 2024 at 12:00 am
Comments posted to this topic are about the item Databases for Executives
October 28, 2024 at 9:45 am
Even between RDBMS there are differences that can have a profound impact on the availability, performance, security and data quality.
There are certain fundamental principles that apply to managing databases, RDBMS or NOSQL. This gives you a checklist and a roadmap of the capabilities you need to have. However, knowing the principles behind say a full restore, and physically enacting it in a production environment are two different things.
Then there is tooling that is available for the DB. At my previous place we used to rely on the Redgate toolbelt. There was a top down decision to move from SQL Server to MongoDB and Vertica as a data warehouse platform. Losing Redgate tools was like losing at least one limb. I'm damn sure that tooling wasn't considered in the choice to migrate. This meant that we had to solve problems for ourselves that were products or out-of-the-box facilities. This includes CICD. There are plugins for various CICD tools but at the time there weren't for those two platforms.
A DB platform is not a thing on its own. There's a ecosystem of things that support and manage it and I feel that ecosystem is what is overlooked.
November 1, 2024 at 9:37 am
November 1, 2024 at 9:41 am
Even between RDBMS there are differences that can have a profound impact on the availability, performance, security and data quality.
There are certain fundamental principles that apply to managing databases, RDBMS or NOSQL. This gives you a checklist and a roadmap of the capabilities you need to have. However, knowing the principles behind say a full restore, and physically enacting it in a production environment are two different things.
Then there is tooling that is available for the DB. At my previous place we used to rely on the Redgate toolbelt. There was a top down decision to move from SQL Server to MongoDB and Vertica as a data warehouse platform. Losing Redgate tools was like losing at least one limb. I'm damn sure that tooling wasn't considered in the choice to migrate. This meant that we had to solve problems for ourselves that were products or out-of-the-box facilities. This includes CICD. There are plugins for various CICD tools but at the time there weren't for those two platforms.
A DB platform is not a thing on its own. There's a ecosystem of things that support and manage it and I feel that ecosystem is what is overlooked.
We're migrating from SQL Server to Snowflake and I really miss SQL Prompt.
November 2, 2024 at 9:42 am
Chris, Aquafold DataStudio is a DB IDE that has a poor man's equivalent of SQL Prompt where the snippets are stored as "abbreviations".
I don't know what is available in other DB IDEs. I'm a big fan of the JetBrains IDEs though my current company prefers open-source offerings so DataGrip may have a SQL Prompt approximation too
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply