Subscribe

CDC Using Debezium Server, MySql, Kinesis - Using Single Kinesis Stream for Multiple tables In my previous post, we saw how we can stream Mysql table changes to Kinesis using Debezium. But the problem there is, that we need to configure 1 kinesis stream for 1 table. So the number...

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...

Hi Everyone, Here is the video recording of my session (Part 1) of the series SQL Server. Hope you liked my session and please do comment at the bottom about the way you felt about this session. Your response helps me to improve in further sessions. Recording: https://www.youtube.com/watch?v=wBkxhIfnRNA PPT :...

What is CDC/ Change Data Capture As per Wikipedia In databases, change data capture is a set of software design patterns used to determine and track the data that has changed so that action can be taken using the changed data So usually let’s take an example of Microservices, One...

Hi, Did you ever think like it would be nice to learn and execute SQL queries on 381GB+ data? https://data.stackexchange.com/ is the place where you can execute an unlimited number of queries and find out interesting stats on Stackoverflow dataset? I did write a few queries to find out interesting...

Hi, In my previous posts, we saw how we can leverage the Docker playground to install Elastic Search and then creating clusters and also indexing data into Elastic cluster. You can find these links here Starting Elastic Search cluster using Docker and Docker Play ground Cluster, Nodes and Shards in...

Hi, In my previous posts, we saw how we can create an Elastic search cluster using Docker. Please refer to that post https://xyzcoder.github.io/2020/07/23/elastic-search-cheetsheet.html. I also have a video recorded for that and you can visit it at https://www.youtube.com/watch?v=v1s3bUcN3E4 Now in this post, we will see how we can add data...

In this post, I am actually writing all queries that we use day to day as a cheat sheet. Are you thinking of trying Elastic Search for a long time and didn’t get a chance or proper infrastructure. Then you can try creating Elastic search in Docker Playground and play...

Hi, In this post I’ll discuss on how to deploy Elastic Search docker images as a cluster on multiple hosts ( Note: This is not about single host machine running multiple elastic search containers). This is all about having multiple Linux/Windows machines in a network and on each machine we...

Running Jekyll Anywhere Using Docker My Custom Image: Before actually going through this post, I hope you got a chance to go through my previous 2 blog posts on how I am making using Jekyll (Static Site Generator and Github Pages) for hosting my blog. Part 1: How I successfully...

Hello Everyone, As a developer, I use Stackoverflow and Github everyday. So I know these sites play a vital role in almost every software developers day to day life. So In this post, I would like to find some interesting stats like how many .cs(C# files) have stackoverflow question as...

Hello Everyone, In this post, I would like to continue how I built my blog using GitHub pages and Jekyll at free of cost and maintenance. Here is the link to my previous article In my previous post we saw what Static file generators are and how they help us,...

Hello Everyone, In this post, I would like to discuss on how I successfully built (xyzcoder.github.io) my blog at free of cost and maintenance. Technologies I am making use of for building and maintaining my blog (xyzcoder.github.io) Jekyll Github Pages Javascript HTML Ruby(But we don’t need any prior knowledge of...

List Of all Tables and their columns along with datatypes SELECT o.Name as TableName,c.Name as ColumnName,t.name as DataType,t.length as [DataLength] FROM sysobjects o JOIN syscolumns c ON o.id = c.id JOIN systypes t ON c.xtype = t.xtype WHERE o.xtype = 'u' ORDER By o.name Search for a string accross all...

Hi, In this post, I would like to explain how we can handle the following error that we usually get when hosting Asp.Net core application using IIS. ** An error occurred while starting the application. .NET Core | Microsoft.AspNetCore.Hosting version | Microsoft Windows ** An error occurred while starting the...

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 it was...

Error: Docker: A firewall is blocking file Sharing between Windows and the containers. See documentation for more info Shared drives require port 445 to be open between the host machine and the virtual machine that runs Linux containers. Docker detects if port 445 is closed and shows the following message...

Hello Everyone, In this post I would like to discuss on how we can make use of SQL Rest API In Elastic Search to learn and write better queries and understand different aspects of a native elastic search query. Coming from SQL background , I always felt like writing queries...

Hi, Recently I installed Elastic search 7.0 on one of my machines and I am using NEST C#(6.6.0) Client for interacting with it. I started getting an exception when trying to create an index from C#. Failed to parse mapping [_doc]: Root mapping definition has unsupported parameters: [employee : {properties={office_hours={type=text},...

Hi, In this post I would like to share details on how to generate Stored Procedures for performing CRUD operations. I’ll be using visual studio for this accomplishing this task. Step1: Right click on the project name in Visual studio. Add a new item. Now under visual c# —> Data...

Recently I am getting a weird issue in my Visual Studio. Backspace is not working and it is so irritating. Solution Go to “Tools” – “Options” In Options windows, under the menu “Environment”… Click on “Keyboard”. Now Search For “Edit.DeleteBackwards” and select it. Now for the option “Use New Shortcut...

Sometime we write code using Jquery Custom selector to great extent. It works fine with pages that has less amount of data but when the page size is growing I am getting an error in ie (Unresponsive script error). These are the few things that I did to overcome these...

Hi, Came across an interesting thing today. eval(‘25;(100/10);40;30+40’) What will be the output of this javascript statement. The output of above statement is 70. So point here is if we pass semi-colon separated mathematical expressions to eval function in javascript then it would return the value of the last evaluated...

Hi, In this post I’ll explain how I am making use of firebase real time database / firebase database for storing my subscribers list of my blog. I am hosting my blog as static html pages in github pages and I dont have a feasibility to interact with traditional databases....

Hi, In this post I would like to share a small js code snippet which I use from Console of a browser to list all the files that were changed with the pull request. My usecase is usually I review pull request created my team mates and sometimes we will...

Hi, In this post we will see how to get started with CKEditor in Angular6 ng2-ckeditor: I decided to make use of ng2-ckeditor because of the community support and number of download in nuget packages We can download it from ng2-ckeditor. Steps: Add ng2-ckeditor to package.json file “ng2-ckeditor”: “^1.2.2”, under...

Hi, In this post we will see how to get started with Apache Kafka C#. In this article I’ll be using Kafka as Message Broker. So basically I’ll have 2 different systems. One is Producer and the Other is Consumer. Basically a producer pushes message to Kafka Queue as a...

**Happy New Year **: First of all, Thank you for following my blog and showing interest in reading my articles. In this blog post, I would like to discuss my plans for the year 2019. I’ll work hard to accomplish all my goals mentioned here and share my learnings. Here...

DnSpy is a c# reverse engineering tool which helped me to decompile a c# assembly and debug it Problem I am trying to solve: I Was having an issue with a .Net Windows Application exe throughing error message when trying to open it. I have an exe, and all dll’s...

Problem I am trying to solve: Actually I am planning to create a cluster for a spark environment using my AWS free tier account. So I created an account with AWS and was impressed by their free offerings :) 750hrs for an instance … I decided to spin up few...

Hi, In this post, we will see how to install docker on windows and other basic details. System Requirements: 1. For docker to run, we need to enable virtualization in windows. Windows by default support virtualization using HyperV. Restart your machine and go to boot menu and try to enable...

Hi, I Just want to share details about a very useful tool, I really liked it and may be you’ll also like it. Lets say i have a Restful service(example webapi code) in my PC , i am running it on port 4000. So something like http://localhost:4000/getEmployeeDetails will display my...

Generally we will be having all the static content files like Java scripts, images, css files at different locations on our machine and we will be importing them in our aspx or html pages by mentioning the path where they exist. For example let us assume that i am having...