MSSQL | Configure SQL Server for Remote TCP/IP Connections

These instructions work for Windows Server 2016 and SQL Server 2016 and SQL Server Express. You can connect remotely through port 1433 from Windows and/or Linux instances. Configure SQL Server for Remote TCP/IP Connections Connecting remotely to SQL Server requires that you switch on SQL Server authentication, enable the TCP/IP protocol, and restart SQL Server so that the changes take

Read more

Install SQLCMD on Windows using Chocolatey

You can install SQLCMD on Windows (for accessing Microsoft SQL Server databases, both locally and remotely). choco install sqlserver-cmdlineutils SQLCMD Install Log If all is well you can expect Chocolatey to produce the below SQLCMD install log. choco install sqlserver-cmdlineutils Chocolatey v0.10.5 Installing the following packages: sqlserver-cmdlineutils By installing you accept licenses for the packages. Progress: Downloading sqlserver-odbcdriver 13.1.4413.46… 100%

Read more

AWS User Data Script | Auto Provision a Windows EC2 Instance

How to Script (Auto Provision) an AWS Windows EC2 Instance To auto provision an AWS Windows instance with a script that runs when the instance comes up – is a common (but poorly documented requirement). Scroll down for links to other net resources on this subject. Intro | AWS User Data Script that Auto Provisions a Windows Server We are

Read more

Ruby’s Native String Handlers

String Handling in Ruby If nothing else, Ruby is the bees knees at manipulating strings. Try and avoid regular expressions as they are hard to read – often you can avoid them and use one of Ruby’s many in-built string tools instead. UpperCase | LowerCase | Ruby’s Case Managers str.capitalize Return a copy of str capitalized # “string” => “String”

Read more

Swap Space | How to Provision Swap

When and Why to Add Swap Space Without swap space – the below middleware will either fail to install or will behave badly once installed. These include GitLab (for businesses who must host their own Git repositories) Jira (a Java web application for collaborating on projects) Jenkins (a job runner used to continuously integrate java software). Swap space does not

Read more
1 2 3 4 27