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:
- get list of connected users and its sessions
- get list of long running cursor
- get list of idle session that has open transaction(s)
- get information about own query and connection info
- Get information about blocked request
Continue reading SQL-Server admin sqlQuery to view the running stats on the server
Installation of MongoDB 4.4 on Linux Ubuntu 18 is very easy. Here is step-by-step command and you are done. I have done installation on my desktop of Linux Ubuntu 18.
Continue reading How to install MongoDB 4.4 on Ubuntu 18?
We are living in the high tech 21st-century world, where we use to say: “change is the only constant“, it’s not only applicable in software, it’s applicable in general life too. In software, we call it evolution. Whatever we call it, but this is the fact that “change is the only constant“.
Continue reading Change is the only constant in software
JSON is programming language and platform independent data structure data format to exchange the data between heterogeneous system. JSON is widely used nowadays by almost all the language by all the developers whether its web application or enterprise application or database.
Continue reading JSON overview
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?
We are living in the world, where protection of security is very important, and security does not comes free This is basic building block of any security.
Continue reading what are the security objectives?
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
This post is about the frequently asked questions about mongoDB Security, which is ACL (Access Control Layer). What are the different Authorization and Authentication are available in mongoDB.
Continue reading MongoDB Security Access Control FAQ
SSH is a secure protocol for secure remote login. It is widely used remote login protocol to login from one linux/unix system to another linux/unix system login.
Continue reading SSH (Secure Shell) Protocol for Secure Remote Login