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?
Database is a collection of data that is organize in manner that makes it easy to be managed, accessed, and changed. An organization generally has different department based on their specialization, so does the data requirement change that lead to multiple database requirement in the organization.
Continue reading What is Database?
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?
Simple steps, where you can easily configure pods and deploy on server/kubernetes cluster.
Continue reading Configure kubernetes pods
This ELK stack is opensource stack, where E stands for Elastic serach, L– logstash and K stands for Kibana.
Continue reading Elastic-search, Logstash, and Kibana is know as ELK stack.
Grafana is open source analytic and visualization tool. Nowdays, organization use this for infrastructure and application analytics but it depends on domain to domain.
Continue reading Grafana for Analytic and Visualization
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?