DBeaver /v7 – Install on CentOS

Installing Need a quick install of DBeaver on my CentOS box. Outline Artifact Identify artifact Download artifact Dependencies List Dependencies Review Dependencies Install Dependencies Install actual package Review install Launch app   Tasks Artifact Identify Artifact URL Artifacts for DBeaver are available @ Link Image Explanation Our targeted OS is a 64-bit CentOS and so … Continue reading DBeaver /v7 – Install on CentOS

MySQL – Using “Load Data” Statement

Background Let us load data into our MySQL using it's native "Load Data" statement. Outline Data Source Identify Data Source Review Data Download Data Tools CURL Prepare Target Storage Create Tables Create Staging Table Create Actual Table Load Data Load data into staging table Move data from staging table into actual table Tasks Data Source … Continue reading MySQL – Using “Load Data” Statement

MySQL:- Select / INTO File

Background Wanting to extract data out of MySQL. Chose to use select along with "into outfile".   Outline Preparation Configuration Review Process SQL Review Data Tools cat Tasks Preparation Configuration Configuration - Review Let us review the pertinent MySQL Engine configuration. Outline System Configuration secure_file_priv Folders where File I/O can occur Tasks SQL SQL - … Continue reading MySQL:- Select / INTO File

Bash – Reading File

Background Now that we are able to run Bash on a Windows machine, it is even more reason to be aware of it.   Read a File Tradition Reading a file usually follows the following sequence:- Open File for reading Read line If EOF exit Process Read Line Read Next Return to EOF check   … Continue reading Bash – Reading File

GoLang – Availing on Linux

Background Let us avail the go runtime on our system.   Lineage OS Microsoft - MS Windows Link   Linux Though my primary OS is MS Windows, I play around a bit with Linux, as well. Options There are a couple of options for availing go on a Linux system. The options include:- rpm Repositories … Continue reading GoLang – Availing on Linux

SQL Server – Configuration – Default Directories

Background In the last few days knee-deep reviewing SQL Server Installs and Scripts. ServerProperty In the last hour or so found myself looking at what is exposed via ServerProperty. Folders Here are some of the File System folder entries exposed through the ServerProperty function. InstanceDefaultDataPath Name of the default path to the instance log files. … Continue reading SQL Server – Configuration – Default Directories

Linux – CentOS – Set Timezone

Background Playing around with Linux, queried the system for the current time, and noticed it is a bit off.   OS OS - Linux - CentOS Our OS is CentOS/Version 8. Command hostnamectl We can issue hostnamectl, to get the OS Name and Version. Output     timedatectl Outline timedatectl timedatectl status timedatectl list-timezones timedatectl … Continue reading Linux – CentOS – Set Timezone

Linux – File System – Listing File Systems

Background What is the File System on our disks? Outline Commands df ( Disk Free ) lsblk ( List Information on the block devices ) lshw ( List Hardware ) file ( File Command ) mount ( List Mount Points ) blkid ( List Information on Available Block Devices ) System Configuration File /etc/fstab Commands … Continue reading Linux – File System – Listing File Systems

Powershell – Linux – Invoke Using Command Argument

Background There are a couple of ways to invoke Powershell in Linux. Options Here are a couple of Options:- -File -Command Payload - File Syntax Sample Payload - Command Outline To get username Environment::UserName Syntax Sample Hello World Output Output - Image Output - Text Explanation We printed out our username Environment Variables and $PSVersionTable … Continue reading Powershell – Linux – Invoke Using Command Argument

Linux – CentOS /v8 – Avail Python/v2

Background Let us get Python version 2 to be the default Python version on our machine. Outline List installed Python Versions If not installed, Install Python version 2 Review Installed Locations Set Python Version 2 as the default version of Python Confirm Current Version of Python List Installed Python Versions Outline alternatives compgen alternatives Outline … Continue reading Linux – CentOS /v8 – Avail Python/v2