All posts by Ranjeet Jha

About Ranjeet Jha

Ranjeet Jha is a hands-on experienced software professional in Java JEE and Big Data space. In spare time, either in weekend or holiday, he enjoy by sharing his experience over here. LinkedIn Profile

SQL-Server admin sqlQuery to view the running stats on the server

SQLServer SQL-Server: admin SQL Queries to view the running stats. I have used this frequently on SQL-Server 2016 for day to day activities and useful for me most of the time. You can also try this if you are a admin or developer or user of sql server.
In this article, tried to share few tsql/sql server admin queries as:

  1. get list of connected users and its sessions
  2. get list of long running cursor
  3. get list of idle session that has open transaction(s)
  4. get information about own query and connection info
  5. Get information about blocked request

Continue reading SQL-Server admin sqlQuery to view the running stats on the server

why health-check service is required for Load Balancer?

Let us understand, why health-check service API is required for any LB (Load Balancer)? Checking of health, whether underlying node/application/webServer is up and running or not. Health-Check is most important and  basic things, when you add your application server or web server under LB( Load Balancer) (LB can be either SLB- Software Load Balancer or HLB – Hardware Load Balancer).

Continue reading why health-check service is required for Load Balancer?

PCI DSS (Payment Card Industry – Data Security Standard) overview

PCI-DSS : Payment Card Industry Data Security Standard The full form of PCI-DSS is ‘Payment Card Industry Data Security Standard‘. PCI which is widely accepted set of policies and procedures intended to optimize the security of Card ( i.e. credit card, debit card, cash card etc) transactions and protect cardholders data against misuse of their personal information. PCI-DSS is governed by PCI council and PCI DSS was created in 2004 jointly by five major credit-card companies: Visa, MasterCard, Discover, JCB and American Express.
Continue reading PCI DSS (Payment Card Industry – Data Security Standard) overview