Databases

Welcome to our Databases category. This section is your go-to resource for comprehensive guides, expert tutorials, and best practices on database management. Whether you’re a database administrator, data architect, or developer, our content covers essential topics such as database design, SQL queries, performance tuning, and security. Stay updated with the latest trends and technologies in database management and learn how to effectively manage and optimize your database systems to support your organization’s data needs.

How to Connect to Oracle Database from an AWS Lambda using Thin mode

By Deiby Gómez After exploring How to Connect to Oracle Database using AWS Lambda in Thick Mode, we now move on to Thin Mode. With so many companies using AWS as their Cloud Provider, AWS Lambda is a popular solution to process Serverless Code. This guide was written to help people that need to work […]

How to Connect to Oracle Database from an AWS Lambda using Thin mode Read More »

AWS, Cloud Computing, Data Integration, Databases, Oracle, Technical Tutorials
Abstract image of floating numbers symbolizing data connectivity between AWS Lambda and Oracle Database

How to Connect to Oracle Database from an AWS Lambda Using Thick Mode

By Deiby Gómez Many companies use AWS as their Cloud Provider to implement solutions, and AWS Lambda is a popular choice for processing Serverless Code. In a world where data is king, it’s common to need to pull or push from Oracle Databases. For that reason, I wrote this guide to help anyone that needs

How to Connect to Oracle Database from an AWS Lambda Using Thick Mode Read More »

Cloud Solutions, Data Integration, Databases, Oracle, Oracle Technology Network, Technical Tutorials
Turquoise 3D Snowflake icon on a black background, illustrating how to identify Snowflake ACCOUNTADMIN privileges using Prismafy.

How to Quickly Identify Users and Roles with ACCOUNTADMIN Privileges in Snowflake

By Deiby Gómez  Wondering how to quickly identify Snowflake ACCOUNTADMIN privileges and the users or roles that hold them? This article will show you how to easily identify them using Prismafy, a free tool that generates detailed reports in just a few minutes. Prismafy supports external authentication, usernames and passwords, and MFA, making it secure

How to Quickly Identify Users and Roles with ACCOUNTADMIN Privileges in Snowflake Read More »

Databases, Security, Snowflake
Abstract geometric pattern symbolizing query profile changes in Snowflake. Detect query profile changes easily with Prismafy for better SQL query optimization.

How to Detect Query Profile Changes in Snowflake: Quick & Easy Method

By Deiby Gómez  In this article, we’ll explore how to quickly detect when Snowflake changes the way it executes your SQL statements. We’ll use the Prismafy tool for Snowflake, which generates detailed reports, allowing you to identify within minutes when a query profile changes. Prismafy is a free, open-source tool that supports external authentication, including

How to Detect Query Profile Changes in Snowflake: Quick & Easy Method Read More »

Databases, Snowflake, SQL
Scroll to Top