SQL Server 2017 Now on Linux

SQL Server 2017 is now in General Availability (GA) on Linux.  To support an operating system and database system that runs on it requires a deep level of knowledge.  Troubleshooting issues, knowing the tools for diagnostics, and becoming familiar with the interactions and compatibilities among components is like the study of religion.  It requires a great deal of dedication and patience.  I started with Sybase (which birthed SQL Server) on Solaris (a Unix variant) many years ago and I transitioned to SQL Server on Windows.  I missed the Unix tools so much that I insisted on installing MKS Toolkit (Unix tools on Windows) wherever I went as a freelance web programmer.  I succeeded in building many data warehouses using these tools and welcome the addition of SQL Server to the Linux world.

Had Powershell emerged with “here” document capabilities back in 1995, things would be different.  Since Oracle now controls MySQL, and MariaDB is gaining momentum, I expect that the stability of the SQL Server database engine will gain some converts among the Linux community wishing for an economical vendor-supported product.  Despite popular belief, you don’t need .NET to run the SQL Server database engine, and you don’t need SSRS or SSIS to deliver reporting solutions and high speed streamed data integrations. The only tools MS needs to port with the database engine are the command line versions of BCP.exe and SQLCMD.exe, which they have done.

The database development software is supported on four varieties of Linux here.

RFID for Event Attendance Demographics

An event organizer has teamed with Konduit to provide a system that tracks the activities of event attendance.  Demographics are captured during attendee registration by offering a questionnaire.  Attendee event badges are affixed with an RFID tag associated with the attendee’s registration.  Exhibitors log into a Transaction Editor Web Portal to view real time statistics on event attendance and product trial areas.  RFID guarantees usage and at a lower cost than popular Bluetooth LE solutions using attendee cell phones.

The Exhibitor Portal also allows the Exhibitors to manage a list of product demos they plan to bring to each event.  Back office users then use Transaction Editor to associate an RFID tag with each product that will be used to pair attendee’s RFIDs with product trials.  This adds significant value to the attendee registration data for follow up after the show.  The system utilizes 7 Tables, 76 Columns, 2 Triggers, 14 Job Steps, and 10 Sproc Reports.