wget – Use to download GitHub files

Background Let us issue wget to download github files. Artifacts EternallyBored.Org Windows binaries of GNU Wget Link SourceForge gnuwin32 wget Link Usage Outline Download file To download individual files, please use github's raw interface Download folder To download entire repository, please use the archive/zip toolset Tasks Download File Syntax Sample Sample - _gitGetFile.cmd Sample - … Continue reading wget – Use to download GitHub files

FileZilla :- Open for write: permission denied – File Transfer Failed

Background Trying to use FileZilla to copy a file I downloaded to my Windows Machine so that I can install same file on Linux. Backwards. But, Linux is just not my fluency. Error Error Image Error Text Troubleshooting List folder permissions Commands Command - ls Syntax Sample Image Explanation Our targeted folder ( /downloads ) … Continue reading FileZilla :- Open for write: permission denied – File Transfer Failed

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

NUMA – Get Current Configuration ( On Linux )

Background Reading through database documentation and understanding that some database platforms do not really support NUMA, as well as others. What is NUMA? Wikipedia Link Modern CPUs operate considerably faster than the main memory they use. CPUs increasingly have found themselves "starved for data" and having to stall while waiting for data to arrive from … Continue reading NUMA – Get Current Configuration ( On Linux )

AWS/EC2 – Instance – Metadata

Background Continuing with our study on AWS/EC2. Let us quickly cover how we go about querying the EC2 instance for rudimentary system information. Environment On the instance itself, please send a payload against Link-local address; specifically 169.254.169.254.  The full URL is http://169.254.169.254/latest/meta-data/ Tool We are on MS Windows and we have browsers loaded and we … Continue reading AWS/EC2 – Instance – Metadata

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