18 February

AWS-Athena

Getting Started with AWS-Athena Introduction to AWS Athena Amazon Athena is an interactive query service that makes it easy to analyze data directly in Amazon Simple Storage Service (Amazon S3) using standard SQL. Features: Athena is serverless. So there is no infrastructure to set up or manage, and you pay only for the queries you run. It […]

Read More
18 February

CDC USING DEBEZIUM SERVER, MYSQL, KINESIS

What is CDC/ Change Data Capture According to wiki, Change data capture is a set of software design patterns used in databases to identify and track changed data so that action may be made based on it. So normally let’s take an example of Microservices, One of the key ideas of Microservices is to create […]

Read More
24 January

ELASTIC SEARCH MAPPING AND INDEX CREATION

Auto Index Creation Setting We will see how to create a schema for an index : There is a property defined in elasticsearch and if it is turned on, we can automatically create indices without predefining any schema for that index(Mapping). By default, it is set to true and if you want to turn it […]

Read More
24 January

TERRAFORM INSTALLATION, BASICS, STATEFILE

Infrastructure As A Code Redhat’s definition Infrastructure as Code (IaC) is the managing and provisioning of infrastructure through code instead of through manual processes. With IaC, configuration files are created that contain your infrastructure specifications, which makes it easier to edit and distribute configurations. So Terraform is one of the tools which helps us in automating Infrastructure […]

Read More
24 January

AUDITING IN SQL SERVER

AUDITING IN SQL SERVER USING CDC APPROACH Hi, In this post I would like to explain how we can audit tables in SQL server using Change data capture ( CDC) approach. Requirement: In the world of transactional databases, It is always required to audit our changes to track changes like what was changed and when […]

Read More