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…
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,…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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…
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,…
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,…
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…
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…
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…
