Blog About Me Posts By Tags Subscribe Elastic Search My Sessions

Pavan Kumar Aryasomayajulu


  • March 7, 2021

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

  • February 19, 2021

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

  • August 21, 2020

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

  • August 3, 2020

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

  • July 29, 2020

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

  • July 23, 2020

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

  • August 7, 2019

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

  • July 17, 2019
  • Audit_SqlServer
  • CDC
  • Tracking_Changes_In_SqlServer

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

  • July 8, 2019
  • Docker
  • DockerWindows

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

  • March 28, 2019
  • VisualStudio

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

  • March 23, 2019
  • Jquery

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

  • March 23, 2019
  • javascript

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

  • March 17, 2019
  • Firebase

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

  • March 8, 2019
  • ckeditor_angular6
  • ckeditor

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

  • February 26, 2019
  • Kafka
  • Kafka_Csharp
  • Confluent_Kafka
  • Kafka_on_windows

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

  • January 1, 2019

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

  • June 7, 2018
  • Dll_Decompiling
  • Decompiled_Dll_Debugging
  • dnSpy

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

  • May 15, 2018
  • AWS
  • VPC
  • VPC-Peering

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

  • May 9, 2018
  • Docker

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

  • November 1, 2011
  • WebResource.axd

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