SQL Server on Linux – 11th December 2018

Tech-Spark’s end of year event at MIC Malta by Ralph Attard an MCT and MCSE in Data Management and Analytics.

A technical presentation about running MS SQL Server 2017 on Linux. We started off by using containers and proceed in looking at High Availability and Data Protection using Fail over clusters, Availability Groups, Pacemaker, read-scale, and cross-platform options.

Being the Christmas event, attendees were treated to some mulled wine and mince pies!

Agenda

  • Supported features & Linux differences
  • Installing SQL Server on a Linux Container
  • Accessing SMB 3.0 shared storage using Samba
  • Setting up a Fail over Cluster using Pacemaker
  • Setting up AlwaysOn Availability Groups using Pacemaker
  • Authenticating to SQL Server using AD Authentication
  • Setting up Read-Scale Cross-Platform Availability Groups

Presentation

Event sponsored by Microsoft and Hotel Santana.

Leave a Reply