What is Microsoft Azure SQL Data Warehouse and use cases of Microsoft Azure SQL Data Warehouse?

What is Microsoft Azure SQL Data Warehouse? Microsoft Azure SQL Data Warehouse is a cloud-based, fully managed data warehousing solution provided by Microsoft Azure. It is designed…

Read More

What are Intelligent Virtual Assistants and use cases of Intelligent Virtual Assistants?

What are Intelligent Virtual Assistants? Intelligent Virtual Assistants (IVAs) are AI-powered software agents that can interact with users in a natural language conversation. IVAs use artificial intelligence,…

Read More

Kapitan Commands line Reference

Merges inventory and inputs and produces generated files in the output folder (/compiled by default) Compiles one or more targets selected by name using –targets or -t…

Read More

What is Microsoft SQL Server Integration Services and use cases of Microsoft SQL Server Integration Services?

What are Microsoft SQL Server Integration Services? Microsoft SQL Server Integration Services (SSIS) is a platform for building high-performance data integration solutions, including extraction, transformation, and loading…

Read More

Gerrit Setup using Tomcat and Mysql

MySQL database CREATE USER ‘gerrit’@’localhost’ IDENTIFIED BY ‘gerrit’; CREATE DATABASE gerritdb; ALTER DATABASE gerritdb charset=latin1; GRANT ALL ON gerritdb.* TO ‘gerrit’@’localhost’; FLUSH PRIVILEGES; exit; Apache Configuration sudo…

Read More

SQL SERVER queries to gather information about the workload

To get the top queries that are taking the longest time to execute: To get the top resource-intensive queries: To get the top wait types: Jami RajMotoShare.in…

Read More

Difference between INFORMATION_SCHEMA and SYS schema in SQL SERVER

In SQL Server, both INFORMATION_SCHEMA and sys are schema-based views that provide metadata about database objects. However, there are some differences between the two: In summary, the…

Read More

Query to check Tables row count and space details in SQL Server

The sp_spaceused stored procedure to retrieve the table size information: Replace ‘YourTableName’ with the name of the table you want to check. This will return a result…

Read More

How to restore deleted ‘root’ user and password for MySQL

Rajesh KumarI’m Rajesh Kumar, a DevOps, SRE, DevSecOps, Cloud, and Platform Engineering expert passionate about sharing practical knowledge, real-world experiences, and industry best practices. I have worked…

Read More

Encryption using Public key and Private key in PHP using mySql database

Write a php code for generating public key and private key on page one and on page two encrypt user entered data using public key and store…

Read More

MySQL Commands & Query Cheatsheet Example

List All Users in a MySQL Database Server Are you looking for the MySQL SHOW USERS command? Unfortunately, MySQL does not have the SHOW USERS command like…

Read More

Datadog Tutorials: Datadog Agent integration with mysql databases?

How to setup Datadog Agent integration with mysql to collect many metrics from MySQL databases? The Datadog Agent can collect many metrics from MySQL databases, including (but…

Read More

Python Tutorials: Database operations using python – mysql

Step 1 – Install MYSQL Server https://www.devopsschool.com/blog/how-to-download-and-install-mysql-in-macos-10/ https://www.devopsschool.com/tutorial/mysql/how-to-install-mysql-on-centos-7.html Step 2 – Install python mysql connector using PIP3 $ sudo pip3 install mysql-connector-python Step 3 – Using Python…

Read More

How to install MSSQL in CENTOS 7?

Step 1 – Install SQL Server Step 2 – Install the SQL Server command-line tools Rajesh KumarI’m Rajesh Kumar, a DevOps, SRE, DevSecOps, Cloud, and Platform Engineering…

Read More

Rundeck Database Migration From H2 to MySql and postgresql

Rundeck Database Migration From H2 to MySql Step 1 – Install mySql Server Step 2 – Create rundeck db and rundeckuser and set their permissing Step 3…

Read More

MySql Backup and Restore – A Complete Guide

Generate the backup of a single database Generate the backup of multiple databases or all the databases Generate the backup of database structure Generate the backup of…

Read More

How to Reset or Recover Forgotten mySql root Password

Recover Forgotten mySql root Password in Linux OLD method Resetting MySQL Root Password with XAMPP on Localhost How to change a mysql user password? Rajesh KumarI’m Rajesh…

Read More

Import all MySQL databases at one time in seperate file for Backup

Script Commands Rajesh KumarI’m Rajesh Kumar, a DevOps, SRE, DevSecOps, Cloud, and Platform Engineering expert passionate about sharing practical knowledge, real-world experiences, and industry best practices. I…

Read More

What is Azure SQL?

Azure SQL is Microsoft’s cloud database service. Based on SQL Server database technology and built on Microsoft’s Windows Azure cloud computing platform, SQL Azure enables organizations to…

Read More

What is Apache Kudu?

Apache Kudu is a free and open source columnar storage system developed for the Apache Hadoop. It is an engine intended for structured data that supports low-latency…

Read More

How to install MySql and MaridaDb in Centos/RHEL?

Rajesh KumarI’m Rajesh Kumar, a DevOps, SRE, DevSecOps, Cloud, and Platform Engineering expert passionate about sharing practical knowledge, real-world experiences, and industry best practices. I have worked…

Read More

How To Install MySQL server and client on Ubuntu?

Step 1 — Installing MySQL Step 2 — Configuring MySQL – NOT WORKING WITH LATEST Step 3 — Creating a Dedicated MySQL User and Granting Privileges Rajesh…

Read More

How to connect Teradata SQL Assistant to Teradata

In this Tutorial we will learn how to connect Teradata SQL Assistant to Teradata database using Teradata ODBC drive. If you want to install Teradata Database in…

Read More

Top 50 Interview question and answers of MySQL

Introduction to MySQL MySQL is a leading open-source database management system. It is a multi-user, multithreaded database management system. MySQL is especially popular on the web. It…

Read More

NewRelic Interview Questions and Answer Part – 1

Which are not the components of NewRelic? APM Infrastrcuture Mobile Datalog Answer- Datalog Is it a right defintion of NewRelic One?New Relic One lets you find, visualize,…

Read More

Install and Configure Prometheus MySQL Exporter

Step 1 – Add Prometheus system user and group: Step 2 – Download and install Prometheus MySQL Exporter This should be done on MySQL / MariaDB servers,…

Read More

How to migrate artiafactory derby database to mysql database?

Step 1 – Check mysql version supported by artiafactory 7.x Artifactory supports MySQL v5.5, 5.6, 5.7 and 8.x with InnoDB engine which is the default provided. Step…

Read More

How to monitor mysql using NewRelic with integration in Linux?

What MySQL integration collects and sends? NewRelic MySQL integration collects and sends inventory and metrics from your MySQL database to our platform, where you can see the…

Read More

Basic SQL Command in a database

The SQL ORDER BY Keyword The ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword sorts the records…

Read More