SQL Server On Linux – Installing Command Line Tools

Background It is time to start playing around with command line client tools for SQL Server On Linux. os Each os has its own installation platform. Our os is CentOS and so that is the os we singularly target. Components Here are the actual components that are part of SQL Server Client Tools :- sqlcmd … Continue reading SQL Server On Linux – Installing Command Line Tools

SQL Server – Installation on Linux/CentOS

Background Let us install SQL Server v2017 on our CentOS System. Installation Outline Repositories Review registered Repositories Add missing Repositories MS SQL Server Engine Install Configure Services Service Review Adjust Network Firewall Rules Validate Repositories Review Registered Repositories yum repolist Syntax Output Explanation We do not see the repositories that we need :- Repositories packages-microsoft-com-mssql-server-2017 … Continue reading SQL Server – Installation on Linux/CentOS

PowerShell – Get Computer name

Background Wanted to highlight a couple of APIs for retrieving the computer name in Powershell. Platform Linux/Cent OS.   Outline Environment Variable Get-ChildItem Env:HOSTNAME system.environment machineName system.net.Dns GetHostName Get-WmiObject ( only works on MS Windows ) Win32_ComputerSystem Name   Environment Variables Get-ChildItem Env: Syntax Output   Get-ChildItem Env:HOSTNAME Syntax Output system.environment machineName Syntax Output system.net.Dns … Continue reading PowerShell – Get Computer name

PowerShell Install On Linux / CentOS

Background Still preparing our CentOS computer. Our current step is to Install Microsoft's PowerShell. Guide Our guide is :- Installing PowerShell Core on Linux Link Outline Install yum Install Install Powershell Registered Repositories - Review yum repolist ls /etc/yum.repos.d Registered Repositories - Update Curl/tee Install Install Powershell Run Sample Powershell Scripts Install Install Powershell yum … Continue reading PowerShell Install On Linux / CentOS

Keep your laptop running when LID is Closed

Background There is really not much need to keep a laptop's lid opened when connected to an external monitor. OS Linux Outline Launch terminal sudo to root edit /etc/systemd/logind.conf Change folder to /etc/systemd Backup current logind.conf Launch editor ( vi) and pass along file name ( logind.conf ) Keep current HandleLidSwitch=suspend commented out Add HandleLidSwitch=lock Save … Continue reading Keep your laptop running when LID is Closed