{"id":24414,"date":"2018-05-29T08:00:33","date_gmt":"2018-05-29T15:00:33","guid":{"rendered":""},"modified":"2024-12-23T10:26:29","modified_gmt":"2024-12-23T18:26:29","slug":"sql-server-at-the-red-hat-summit-2018","status":"publish","type":"post","link":"https:\/\/www.microsoft.com\/en-us\/sql-server\/blog\/2018\/05\/29\/sql-server-at-the-red-hat-summit-2018\/","title":{"rendered":"SQL Server at the Red Hat Summit 2018"},"content":{"rendered":"\n

This blog post is also authored by Travis Wright, Principal Program Manager, Microsoft; and Jamie Reding, Senior Program Manager, Microsoft.<\/em><\/p>\n\n\n\n

A few weeks ago, developers from around the world gathered for the Microsoft Build Conference. It was an amazing display of Microsoft\u2019s products and cloud services to meet the needs of all types of applications. I missed the \/\/build event this year because I found myself in San Francisco at the Red Hat Summit 2018. I can\u2019t even imagine five years ago someone telling me I would represent Microsoft and SQL Server at an open-source based event.<\/p>\n\n\n\n

Travis Wright, Jamie Reding, and I travelled to the event to speak and show amazing demos of SQL Server running on Red Hat Enterprise Linux (RHEL) and OpenShift. We were part of the Microsoft team attending the event to continue to show the great partnership we have and are building with Red Hat. Get an overview of the Microsoft presence at the summit from Robin Ginn\u2019s blog post.<\/a><\/p>\n\n\n\n

This was not the first time for Travis or Jamie attending this event. Microsoft demonstrated SQL Server on Linux at the Red Hat Summit 2016. Travis and Jamie both presented at the 2017 Summit for SQL Server on RHEL and Open Shift. I thought it would be interesting to write about our experiences and what we learned at this year\u2019s Summit.<\/p>\n\n\n\n

The presentation Travis and I gave on SQL Server was rich with demos. We worked hard on these demos, so we thought why not show everyone, not just the people at the Summit. We have packaged them all on the brand-new SQL Server YouTube channel<\/a>. I\u2019ve included links to these videos throughout the rest of this blog post.<\/p>\n\n\n\n

It\u2019s no longer \u201cWhy are you here?\u201d<\/h2>\n\n\n\n

As the event ended, I asked Jamie and Travis what was one of the key differences between previous Summit events and this year. Travis summarized it as \u201cCustomers at the booth have switched from asking us Why are you here? and What is SQL Server? two years ago to specific questions about running SQL Server on RHEL\/OpenShift.”<\/em><\/p>\n\n\n\n

The most common question we received was \u201cHow do you install it?\u201d I think I must have demonstrated at our booth 20 or more times the SQL Server deployment experience, along with the great set of tools we have available for SQL Server on Linux including SQL Server Operations Studio and mssql-cli. Check out this video that shows the complete deployment experience on RHEL as well as a survey of our tools. Cross-platform and open-source tools is how we roll these days!<\/p>\n\n\n\n

Watch the video here<\/a>.<\/p>\n\n\n\n

Is it the same as SQL Server on Windows?<\/h2>\n\n\n\n

Part of the above video shows how to restore a database and connect with SQL Server tools. Linux admins and architects want to be more comfortable with how we integrate with Linux, and I met many folks at the Summit who didn\u2019t know much SQL Server but knew Linux. Many of their colleagues who manage SQL Server in their environment couldn\u2019t attend so they wanted to know if SQL Server is the same as on Windows?<\/p>\n\n\n\n

My first answer to this question was \u201cTell your SQL friends to install SQL Server on Linux, backup their database on Windows, and just restore it on Linux\u201d. Then fire up SQL Server Management Studio (SSMS), connect, and start running queries. When I showed this simple experience, it made the Linux folks incredibly happy. They saw our deployment experience aligned with package managers like yum. But they also could tell their SQL Server colleagues \u201cHey, it\u2019s pretty much just SQL Server\u201d. Since many of them didn\u2019t use Windows, I then showed them SQL Operations Studio and mssql-cli which runs native on Linux and macOS as well as Windows. I heard comments like \u201cNow that is impressive\u201d.<\/p>\n\n\n\n

We used these opportunities to talk beyond just the basics. We showed customers how fast SQL Server can be with technologies like Columnstore Indexes. Check out this demo with PowerBi and Columnstore.<\/p>\n\n\n\n

Watch the video here<\/a>. <\/p>\n\n\n\n

We showed new SQL Server 2017 capabilities of intelligence performance like Automatic Tuning<\/a> powered by Query Store<\/a>. Check out this demo which includes built in performance telemetry through SQL Server Dynamic Management Views<\/a> and charting capabilities in SQL Operations Studio.<\/p>\n\n\n\n

Watch the video here<\/a>. <\/p>\n\n\n\n

We also talked about security and authentication. SQL Server supports both SQL Server authentication and integration with Active Directory<\/a>. Watch this demo of SQL Server connecting with Active Directory Authentication.<\/p>\n\n\n\n

Watch the video here<\/a>. <\/p>\n\n\n\n

What about new capabilities?<\/h2>\n\n\n\n

One of the most compelling new features of SQL Server 2016 and 2017 is in database Machine Learning Services<\/a>. Keeping data associated with data science models and projects together with SQL Server provides security, data freshness, and scalability.
While SQL Server 2017 on Linux supports Native Scoring, support for R and Python did not make it into the release. But we are committed to bringing this type of feature for SQL Server on Linux. Check out this demo to see SQL Server on Linux with Python and Native Scoring with a real-world prediction example.<\/p>\n\n\n\n

Watch the video here<\/a>. <\/p>\n\n\n\n

Does it perform?<\/h2>\n\n\n\n

As we described the architecture of SQL Server on Linux, the first question most people asked us was \u201cDoes it perform?\u201d. Sometimes it is always best to answer questions like these with data.<\/p>\n\n\n\n

The current top two 1TB TPC-H benchmarks are SQL Server 2017 on Linux 1 2. We talked to customers about how SQL Server can scale from your laptop to the biggest servers in the market. And we especially love showing how fast it can run and scale on enterprise-class machines. Check out this demo where Travis Wright shows how SQL Server in Linux can scan billions of rows and run aggregation functions in seconds on an HPE Superdome computer with 12TB of RAM and 480 CPUs.<\/p>\n\n\n\n

Watch the video here<\/a>. <\/p>\n\n\n\n

How does SQL Server support Containers?<\/h2>\n\n\n\n

I have come to realize over the last few months how popular containers are spreading. It is fast becoming not just an interest, but part of production implementation plans. SQL Server is ready to be a part of this wave. Deploying in a container<\/a> itself can be an amazingly easy way to get up to speed fast on SQL Server on Linux. In fact, I brought along my MacBook Pro with me and demonstrated to attendees the SQL Server on Mac challenge<\/a>. For those who know me in the SQL Server community I\u2019m sure you fell off your chair over this.<\/p>\n\n\n\n

Running a single container is interesting, but to run containers in a production environment, you need something bigger. This is where Kubernetes comes in. And this is also where Red Hat\u2019s Kubernetes-based system called OpenShift can make a difference. At the Summit, Microsoft announced a new managed OpenShift service in Azure<\/a> and SQL Server fits right into this offering. Kubernetes and OpenShift have built-in high availability capabilities with shared persistent storage. SQL Server works well within this model. Try it yourself with this tutorial<\/a>.<\/p>\n\n\n\n

Always on Availability Groups (AG) is the flagship feature for SQL Server High Availability. So, we are working on new capabilities for SQL Server to integrate AGs with environments like OpenShift. Watch this demo<\/a> to see this in action.<\/p>\n\n\n\n

Licensing<\/h2>\n\n\n\n

One last interesting topic from attendees was around licensing and offers. Attendees wanted to know if SQL Server on Linux licensing were the same as with Windows. First, it is important to know the Editions of SQL Server are the same, I found many attendees did not know this:<\/p>\n\n\n\n