피드 구독

It’s been five years since Microsoft first brought SQL Server to Linux. In that time, Linux and containers have moved from being "new stuff," to becoming standard operating environments for modern SQL Server workloads. Nowhere was this more visible than at the recent Data Platform Summit (DPS) 2022, a free conference covering SQL Server and Azure Data topics, where Red Hat was the Platinum sponsor.

DPS is a global virtual event with specific days aligned with India, Australia/New Zealand, Asia Pacific and Americas and Europe/Middle East/Africa time zones. This event started in-person in India in 2015 and has gone on to become one of the world's largest conferences relating to SQL Server.

I had the good fortune to be asked to record Red Hat’s session for this event. My talk, Automating Deployment of Red Hat Enterprise Linux with Microsoft SQL Server, provided an overview of the overlap between products from Red Hat and Microsoft.

I also discussed the technical advantages of running SQL Server on Red Hat Enterprise Linux (RHEL), introduced the Red Hat Ansible Automation Platform and offered up demos (from Red Hat Solution Architect Johan Odell and myself) that showed how to automate SQL Server deployment as well as the deployment of Always On availability groups managed with the Red Hat High Availability Add-on. In the end, I got to speak with many of the Database Administrators (DBAs) who attended the conference and I took four things away from my conversations:

First, many of the DBAs I spoke to are already using SQL Server on Linux containers to test database modifications and optimizations.

Second, several DBAs were not aware of functionality that was introduced with SQL Server 2019 for Linux, let alone all the exciting bits that are coming with SQL Server 2022 (now in preview for RHEL 8). Upon hearing about these features, they indicated that they would be looking to move from using SQL Server for development and testing to moving it into production workloads.

Third, DBAs I spoke to are indeed moving legacy SQL Server production workloads to Linux, but some also indicated they were able to move other databases they were using on Linux or UNIX to SQL Server on RHEL (those with less attractive licensing, or in some cases, legacy databases that lacked key innovations).

Fourth, Red Hat continues to be a leader for SQL Server on Linux deployments in production environments. About two thirds of the DBAs I spoke with who were running SQL Server on Linux were running it on RHEL.

Now that the conference has ended, many of the session recordings will be made available to the general public. You can find last year’s recordings, including my own session, Monitoring SQL Server on Linux performance with Performance Co-Pilot and Grafana, here.

For more information on Red Hat Enterprise Linux with Microsoft SQL Server use case visit: Red Hat Enterprise Linux for Microsoft SQL Server.

 

저자 소개

Louis Imershein is a Product Manager at Red Hat focussed on Microsoft SQL Server and database workloads. He is responsible for working with Microsoft and Red Hat engineering to ensure that SQL Server performance, management, and security is optimized for Red Hat platforms. For more than 30 years, Louis has worked in technical support, engineering, software architecture, and product management on a wide range of OS, management, security, and storage software projects. Louis joined Red Hat as part of the acquisition of Permabit Technology Corporation, where he was VP of Product.

Read full bio
UI_Icon-Red_Hat-Close-A-Black-RGB

채널별 검색

automation icon

오토메이션

기술, 팀, 인프라를 위한 IT 자동화 최신 동향

AI icon

인공지능

고객이 어디서나 AI 워크로드를 실행할 수 있도록 지원하는 플랫폼 업데이트

open hybrid cloud icon

오픈 하이브리드 클라우드

하이브리드 클라우드로 더욱 유연한 미래를 구축하는 방법을 알아보세요

security icon

보안

환경과 기술 전반에 걸쳐 리스크를 감소하는 방법에 대한 최신 정보

edge icon

엣지 컴퓨팅

엣지에서의 운영을 단순화하는 플랫폼 업데이트

Infrastructure icon

인프라

세계적으로 인정받은 기업용 Linux 플랫폼에 대한 최신 정보

application development icon

애플리케이션

복잡한 애플리케이션에 대한 솔루션 더 보기

Original series icon

오리지널 쇼

엔터프라이즈 기술 분야의 제작자와 리더가 전하는 흥미로운 스토리