Yum – Warning – “Repository packages-microsoft-com-prod is listed more than once in the configuration”

Background There is a bit of an annoying error that I get whenever I issue yum commands against my Linux CentOS host. Error The error reads :- Image Textual Troubleshooting Yum Repository /etc/yum.repos.d Objective Let us look into our /etc/yum.repos.d folder and see which files reference packages-microsoft-com-prod Command Syntax Sample Output Output - Image Output … Continue reading Yum – Warning – “Repository packages-microsoft-com-prod is listed more than once in the configuration”

SQL Server – Upgrade – v2017 to v2019/CTP – Linux

Background Let us upgrade our Microsoft SQL Server v2017 running on Linux. We will be upgrading it to v2019/RC1. Outline Repositories Current Repository List Current Repository files Map Repository Files to Repositories Update Repository Add Repository File for MS SQL Server v2019 Upgrade SQL Server Upgrade SQL Server - Engine Restart SQL Server Service Validate … Continue reading SQL Server – Upgrade – v2017 to v2019/CTP – Linux

Samba :- Name Resolution – From Linux, Resolve Windows Host

Background Here is how to use Samba to perform name resolution from a Linux Host to MS Windows computers. Lineage Windows WINS Installing & Configuring WINS Link Linux Samba Samba – Host Name Resolution Link Steps Outline Package Installation samba-winbind Network Configuration Names Service Switch /etc/nsswitch.conf Samba etc/smb.conf Firewall Configuration Firewall - firewalld Allow tcp/137 … Continue reading Samba :- Name Resolution – From Linux, Resolve Windows Host

Linux :- ODBC / SQL Server – Configuration

Background On our Linux box, wanted to configure a Database Source to a SQL Server Instance. Lineage In a previous post, we installed SQL Server Command Line Tools and ODBC Development Tools. That post is :- SQL Server On Linux – Installing Command Line Tools Link ODBC Manager Here are some of the ODBC Managers … Continue reading Linux :- ODBC / SQL Server – Configuration

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