Posts

Speaking at SQLSaturday Sacramento!

  I’m proud to announce that I will be speaking at <a href="http://www.sqlsaturday.com/757/eventhome.aspx">SQL Saturday Sacramento</a> on July 28th 2018! And wow, 757 SQL Saturdays! This one won’t let you down. <a href="http://www.sqlsaturday.com/757/Sessions/Schedule.aspx">Check out the amazing schedule</a>!

  If you don’t know what SQLSaturday is, it’s a whole day of free SQL Server training available to you at no cost!

  If you haven’t been to a SQLSaturday, what are you waiting for! <a href="https://www.sqlsaturday.com/757/registernow.aspx">Sign up now</a>!

  <a href="https://www.sqlsaturday.com/757/registernow.aspx"><img style="display: block; margin-left: auto; margin-right: auto;" src="http://www.sqlsaturday.com/images/sqlsat757_header.png" alt="SQLSaturday #757 - Sacramento 2018" /></a>

  **This year I have TWO sessions!**

  **1. **<a href="http://www.sqlsaturday.com/757/Sessions/Details.aspx?sid=78312">**Monitoring Linux Performance for the SQL Server Admin**</a>

<blockquote>

    So you’re a SQL Server administrator and you just installed SQL Server on Linux. It’s a whole new world. Don’t fear, it’s just an operating system. It has all the same components Windows has and in this session we’ll show you that. We will look at the Linux operating system architecture and show you where to look for the performance data you’re used to! Further we'll dive into SQLPAL and how it architecture and internals enables high performance for your SQL Server. By the end of this session you’ll be ready to go back to the office and have a solid understanding of performance monitoring Linux systems and SQL on Linux. We’ll look at the core system components of CPU, Disk, Memory and Networking monitoring techniques for each and look some of the new tools available.

</blockquote>

  **2. **<a href="http://www.sqlsaturday.com/757/Sessions/Details.aspx?sid=78317">**Containers – You Better Get on Board**</a>

<blockquote>

    Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get your started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes. In this session we’ll look at Container Fundamentals with Docker Common, Container Scenarios and Orchestration with Kubernetes

</blockquote>

Today, I’m proud to announce that I have been renewed as an Microsoft MVP – Data Platform for the 2018-2019 award year, my second MVP award. This is an truly an honor and I’m humbled to be included in this group of exceptional data professionals. I really look forward to continuing to work with everyone in the MVP community and continuing to contribute to our unmatched SQL Community!

****

I’m proud to announce the completion of my first Pluralsight Learning Path. This learning path is built to advance your Linux knowledge to the system administrator or system engineer level. In this series of courses you’ll learn the theory behind how things work and also practice demonstrations and tips to really nail home the things you need to know to run production Linux systems.

The learning objectives of this series align with the Linux Foundation Certified Engineer (LFCE) certification “Domains and Competencies” however these courses will be very valuable to your development as a Linux professional even if you’re not interested in certification.

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. Do that using your normal update mechanisms.

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!

  I’m proud to announce that I will be speaking at <a href="https://www.sqlsaturday.com/733">SQL Saturday Atlanta</a> on May 17th 2018! This one won’t let you down! <a href="https://www.sqlsaturday.com/733/Sessions/Schedule.aspx">Check out the amazing schedule</a>!

  If you don’t know what SQLSaturday is, it’s a whole day of free SQL Server training available to you at no cost!

  If you haven’t been to a SQLSaturday, what are you waiting for! <a href="https://www.sqlsaturday.com/733/registernow.aspx">Sign up now</a>!

  My presentation is **“<a href="http://www.sqlsaturday.com/733/Sessions/Details.aspx?sid=71960">Monitoring Linux Performance for the SQL Server Admin</a>” **

  <img style="display: block; margin-left: auto; margin-right: auto;" src="http://www.sqlsaturday.com/images/sqlsat733_header.png" alt="SQLSaturday #733 - Atlanta 2018" />

  Here’s the abstract for the talk

<blockquote>

    So you’re a SQL Server administrator and you just installed SQL Server on Linux. It’s a whole new world. Don’t fear, it’s just an operating system. It has all the same components Windows has and in this session we’ll show you that. We will look at the Linux operating system architecture and show you where to look for the performance data you’re used to! Further we'll dive into SQLPAL and how it architecture and internals enables high performance for your SQL Server. By the end of this session you’ll be ready to go back to the office and have a solid understanding of performance monitoring Linux systems and SQL on Linux. We’ll look at the core system components of CPU, Disk, Memory and Networking monitoring techniques for each and look some of the new tools available including new DMVs and DBFS.Prerequisites: Operating system fundamentals, process, memory and disk concepts.

</blockquote>

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. If the appropriate directory and key file aren’t set up, ssh-copy-id will create the directory and key file with the correct permissions on remote system. As far as I can tell, ssh-copy-id has not been implemented in the Win32-OpenSSH port. So that leaves us with implementing this functionality ourselves, in PowerShell.

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. It aligns with the Linux Foundation Certified System Administrator (LFCS) and Linux Foundation Certified Engineer (LFCE) and also Redhat’s RHCSA and RHCE certifications. The course can be used by both the IT pro learning new skills and the senior system administrator preparing for the certification exam

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”

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 <a href="https://twitter.com/hashtag/sqlLinux?src=hash&ref_src=twsrc%5Etfw">#sqlLinux</a> on the openSUSE app for Windows 10 <a href="https://t.co/0Eg5TtV0o5">pic.twitter.com/0Eg5TtV0o5</a>

— Shawn Melton (@wsmelton)

<a href="https://twitter.com/wsmelton/status/937565476632358914?ref_src=twsrc%5Etfw">December 4, 2017</a>

I didn’t want to leave a brother hanging so I spent this morning digging into this a little bit.