Blog Post

T-SQL Tuesday #116 Roundup – SQL on Linux

,

This month’s topic is wide open to anything you could think of that had to do with SQL on Linux from something technical on how to implement it or something you needed to know to run it on Linux to why you may not have adopted it yet.  We extended the deadline thinking maybe the July holiday got in the way and got a few more submissions.  In alphabetical order here are the submissions.

  • Taiob Ali explains why he hasn’t learned beyond the basics with Linux yet leaving the door open to learning in the future if his job calls for it.
  • Tracy Boggiano (me) talks about how easy it to install SQL on Linux, upgrade it, and even downgrade it all in a single line of code.
  • Jason Brimhall talks Extended Events specifically how to configure the directories for the event_file target so that you can have the same script for Windows and Linux.
  • Kevin Chant gives us a rundown of what is needed for adoption based on what size company you are in. Then he recommends getting the Linux Essentials certification for supporting and having SQL on Linux installed via containers.  Finally, getting your Linux administrators on board and finding out what tools they use.
  • Rob Farley won’t be formatting his personal laptop to a distro of Linux something I’ll have to talk to him about.  He talks about the operating system being less important to companies as they move to PaaS but comes into the picture for on-prem customers that could be wanting to save on the licensing costs.  He ends by telling us the future includes SQL on Linux so you should give it a try.
  • Jay Falck states he has been giving a presentation on Linux since at SQLSaturdays with low attendance.  He gives four reasons to people on why they should learn Linux: to have support staff, how easy it is to install SQL on Linux, patching is easier, and tools work on both Windows and Linux.
  • Steve Jones talks about how he sees containers being used more in his work.  He is using Docker.  Linux being used more when it comes to Kubernetes and Big Data Clusters.
  • Chrissy LeMaire talks about her fondness for Linux is why dbatools is spelled in lowercase (nice trivia fact for PASS Summit).  That currently 75% of the dbatools commands work on Linux currently.  Then she walks us through connecting to linux from mac os with dbatools and to linux using registered servers and finally to Windows from mac os.
  • Eugene Meidinger talks about why he didn’t see the point of SQL on Linux at first but now that he has to constantly update his Virtual Machines to the newest version of 2019 for presentations he loves he can spin up a container in five lines of code.  For demos at least he will be using SQL on Linux.
  • Wayne Sheffield was in party mode all week trying to figure out his topic.  He gives a brief history of SQL Server.  Then explains why he too uses SQL on Linux for this presentations and knowing that his scripts will work the same no matter what OS SQL Server is running on.  But until his clients start using it, he won’t worry about using it in production.
  • Sander Stad talks about how easy to install, integrates with Active Directory, and runs in Docker. He points us to a session by Bob Ward to which is an excellent resource and gives a link to some articles where you can read more about SQL on Linux.

I noticed a common theme in how easy it is to install SQL on Linux that tells me if you didn’t think you had time to install SQL on Linux then you probably do and should give a try in the near future.

Thanks for all that participated!

Watch tsqltuesday.com for next month’s topic and consider signing up to host.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating