Installing OpenSSH Server on Windows 10

So in yesterday’s post we learned that the OpenSSH client is included with the Windows 10, Update 1803! Guess, what else is included in this server, an OpenSSH Server! Yes, that’s right…you can now run an OpenSSH server on your Windows 10 system and get a remote terminal! So in this post, let’s check out what we need to do to get OpenSSH Server up and running. First, we’ll need to ensure we update the system to Windows 10, Update 1803.

OpenSSH is now Part of Windows!

Today is a big day! The OpenSSH client version 7.6p1 is now part of the Windows 10 operating system! Microsoft released Windows 10 Update 1803 and included in that release is the OpenSSH client, which is installed as part of the update. That’s right an SSH client as part of the Windows operating system by default! Also included with this update is the OpenSSH Server which is included as an Windows Feature on Demand.

Speaking at SQLSaturday Atlanta – 733

Speaking at SQLSaturday Atlanta! I’m proud to announce that I will be speaking at SQL Saturday Atlanta on May 17th 2018! This one won’t let you down! Check out the amazing schedule! <p> If you don’t know what SQLSaturday is, it’s a whole day of free SQL Server training available to you at no cost! </p> <p> If you haven’t been to a SQLSaturday, what are you waiting for! <a href="https://www.

Distributing SSH User Keys via PowerShell

Folks in the Linux world are used to moving SSH keys to and from systems enabling password-less authentication. Let’s take a minute to look at what it takes to use PowerShell to distribute SSH user keys to remote systems. In the OpenSSH package there’s a command ssh-copy-id which is a bash script that copies a user’s public key to a remote system. There’s a little intelligence in the script to set things up properly on the remote system for password-less key based authentication.

New Pluralsight Course – LFCE: Linux Service Management – Advanced HTTP Services

My new course “LFCE: Linux Service Management – Advanced HTTP Services” in now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right in check it out here! This course offers practical tips from my experiences building high performance web infrastructure for Centino Systems clients. This course targets IT professionals that design and maintain RHEL/CentOS based enterprises.

Speaking at PowerShell Summit 2018!

I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2018 on the conference runs from April 9th 2018 through April 12th 2018. This is an incredible event packed with fantastic content and speakers. Check out the amazing schedule! All the data you need on going is in this excellent brochure right here! This year I have two sessions! On Tuesday, April 10th at 2:00PM – I’m presenting “OpenSSH Internals for PowerShell Pros”

Attempting to Run SQL on Linux Inside Windows Subsystem for Linux

Update - head on over to Andrew Pruski’s blog to find out how to get this to work! Shawn Melton MVP and dbatools contributor last week had an issue running SQL Server on Linux inside of Windows Subsystem for Linux. Error trying to configure #sqlLinux on the openSUSE app for Windows 10 pic.twitter.com/0Eg5TtV0o5 — Shawn Melton (@wsmelton) December 4, 2017 I didn’t want to leave a brother hanging so I spent this morning digging into this a little bit.

A Novel Idea for High Availability in SQL Server on Linux

Over the past year we’ve learned about how SQL Server on Linux is implemented, leveraging SQLPAL and the team is pretty confident in their architectural decisions as indicated in this post here. Now that there is this wrapper around SQL Server, this really opens up some interesting opportunities…perhaps we can leverage SQLPAL to facilitate some new high availability techniques. When I was in graduate school, I worked on a research project, that became my master’s thesis.

I’m Presenting Two Linux Sessions on One Day!

On 12/13 I’m presenting two, back to back, sessions on SQL Server on Linux online. So you can attend from anywhere! Let’s go through both! First, on 12/13 at 1PM Central, I’m presenting for the PASS Database Administration Virtual Group here’s my session details: Topic: Linux OS Fundamentals for the SQL Admin Registration: You must register if you want to attend. You can register at http://dba.pass.org/. When you register, you will receive a link to the meeting.

Top 5 Reasons Why I think SQL Server on Linux is Legit

Here are my top 5 reasons why I thing SQL Server on Linux is Legit! SQL Server on Linux is Fast – Earlier this year SQL Server on Linux posted the fasted 1TB TPC-H benchmark in the world and at the end of October posted the a 10TB result! Check out the results here and some info on how they did it here and here. It’s tunable – From and OS standpoint, I think the “tunability” of the operating system is more well documented and well known on Linux.