May 25, 2025 · 18 min read · Everyone talks about normalization. But barely anyone talks about denormalization—let alone selective denormalization. Back in college, while studying DBMS concepts, professors would emphasize how important—crucial, even—normalization is. And to be h...
Join discussion
Nov 18, 2024 · 6 min read · What is Redshift ? Redshift is a fast and powerful, fully managed, petabyte-scale data warehouse service in the cloud. AWS Redshift is big data analytics service. It can gather information from many sources. It assists you with getting connection...
Join discussion
Sep 12, 2024 · 6 min read · Migrating from Amazon Redshift to Snowflake: A Comprehensive Guide As organizations continue to scale and deal with increasing amounts of data, the need for more powerful, flexible, and cost-efficient
Join discussion
Aug 13, 2024 · 2 min read · One way of managing, retrieving and rotating passwords, credentials and other secrets is via the use of AWS Secrets Manager along with the use of AWS Key Management Service (KMS) for encryption. Secrets Manager avoids the hardcoding of credentials in...
Join discussionMay 21, 2024 · 5 min read · In the ever-evolving landscape of cloud computing, enterprises are increasingly turning to streamlined and secure identity management solutions to enhance access control and user experience. One such powerful alliance is the integration of Single Sig...
Join discussionApr 20, 2024 · 3 min read · In the vast realm of cloud computing, Amazon Web Services (AWS) stands out as a powerhouse, offering a plethora of services to cater to diverse business needs. Among these, Amazon Redshift shines as a powerful data warehousing solution, enabling orga...
Join discussion
Mar 24, 2024 · 6 min read · Link to exam: https://aws.amazon.com/certification/certified-cloud-practitioner/ Introduction Databases Overview Databases provide structured storage with indexing and relationships. Relational Databases: OLTP: RDS & Aurora (SQL) NoSQL Databases:...
Join discussion
Mar 6, 2024 · 3 min read · Recently, I found myself navigating the complex landscape of data analytics, specifically, the journey of transferring data from PowerBI to Amazon Redshift. The more I delved into the subject, the more I realized the choice between direct and indirec...
Join discussion
Dec 6, 2023 · 3 min read · Introduction: In the fast-paced world of data analytics, businesses are constantly seeking efficient and cost-effective solutions to handle their data workloads. Amazon Redshift Serverless emerges as a game-changer, offering a scalable and flexible ...
Join discussionNov 16, 2023 · 5 min read · Introduction I'll be going through a hypothetical scenario at an event ticketing company and describe the data modeling and transformation process in the STAR format. The github repository of the project is linked below.(https://github.com/Aditya-Tiw...
Join discussion