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 Outline timedatectl timedatectl status timedatectl list-timezones timedatectl set-timezone timedatectl show … 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

Linux – OS – Bitness

Background Let us figure out the bitness of our Linux OS. Outline Commands lscpu Commands lscpu Syntax Sample Output Output - Image Output - Textual Explanation Architecture Meaning:- Processor ( Hardware ) Common Values x86_64 64-bit CPU CPU op-mode(s) Meaning:- Based on OS Installed, CPU Operating Mode ( Software ) Common Values 32-bit, 64-bit Supports both … Continue reading Linux – OS – Bitness

Install Powershell on Linux/CentOS

Background Back playing around with a Linux box and wanted to see if it is any easier for me to understand the steps for installing Powershell. Outline Configure Source Repositories Review available Microsoft Repository for your OS/Version ( https://packages.microsoft.com/config/rhel/ ) Redhat Repository - Local Review "Local" Redhat Repository Is Microsoft repository registered? If Microsoft Repository … Continue reading Install Powershell on Linux/CentOS

Linux – cent-OS – Application – Installed Location & Application Name – “Azure Data Studio”

Background Yesterday evening I installed Microsoft's Azure Data Studio on a Linux Cent-OS box. Use It Naturally, I wanted to start using it. But, I couldn't find it. OS MS Windows In MS Windows, I will simply access the Start button and trek the start menu. Linux - Cent-OS My Cent-OS does not have a start … Continue reading Linux – cent-OS – Application – Installed Location & Application Name – “Azure Data Studio”

Linux:- id command

Background In Linux, the id command displays a user's group names.   Output Here is information offered Attribute Meaning Sample uid User ID uid=1002(daniel) gid Group ID gid=1002(daniel) groups Groups groups=1002(daniel),10(wheel) Syntax Sample Sample-01 Command Output Image Textual Explanation User Id Sample uid => 1002 daniel Group ID  Sample gid => 1002 daniel Groups Sample … Continue reading Linux:- id command

PowerShell – Network Command – “Test-NetConnection”

Background Continuing with preparing for our planned Network work. Lineage PowerShell – Network Command – "Get-NetAdapter" Link Test-NetConnection Outline The Test-NetCommand provides basic network connection testing over the TCP Protocol. Exercises Exercise - Basic Outline Basic network connectivity test TCP Network Port Test Network Port Number specified as numeric "Common TCP" Port Port Test Diagnostic … Continue reading PowerShell – Network Command – “Test-NetConnection”