Select Page

SentryOne/Viscosity Webinar Series

 

Linux Primer for SQL Server DBAs, Wednesday, March 21st 11:00am – 12:00pm EST

 

Since Microsoft SQL Server became generally available on Linux, more and more companies have begun to use Linux as the operating system (OS) of choice for SQL Server. Linux may not be embraced as the mainstream OS for mission critical databases yet, but many have rolled out development and test environments on Linux. To be an effective database administrator in today’s market, DBAs and Architects must possess extensive operating experience and database expertise; this includes SQL Server on Linux.  

Come learn how to navigate in the world of Linux and learn the essential Linux commands covering commonly used distributions, such as Red Hat Enterprise Linux and SUSE Enterprise Server (SLES v12) to perform the day-to-day management of the Linux environment such as how to stop, start, enable and disable SQL Server Services on Linux.

 

You will also learn the essentials of:

  • Shell scripting
  • File system and directory maintenance
  • Cron job scheduling
  • Finding large files and directories
  • Regular expressions
  • Manipulating files with vi
  • Performance monitoring
  • Reviewing top CPU and memory consumers
  • Identifying top consuming processes
  • Log management
  • Firewall management
  • Setting up ssh equivalence between Linux servers
  • Setting up a vncserver

Join us for our other presentations in this series.

Other topics include:

Linux Fundamentals for SQL Server DBAs

Most of the Fortune 1000 companies leverage Linux for their 7/24 mission-critical enterprise server platform and Enterprise Linux has become the standard de facto for reliability and scalability. Today, more and more companies are considering Linux as their new operating system (OS) for SQL Server; and in today’s economy to be an effective database administrator, DBAs and Architects must possess extensive OS and database expertise. In this session, learn how to install and configure SQL Server on Red Hat 7 Enterprise Linux and SUSE Enterprise Server (SLES v12) on bare metal servers and in virtualized infrastructures.

 

We will discuss the top 10 Linux commands that every SQL Server DBA needs to know as you transition from Microsoft to the world of Red Hat and SUSE; with a closer look at the different file system types that are available and which one you should choose.

 

Leveraging real-life experiences and techniques as a certified Linux veteran for over 16 years, I will also share my top tips that you need to know to configure a Linux environment worthy to run SQL Server:

  1. Install required RPMs to install SQL Server
    * Manage and interrogate RPMs
    * Review RPM dependencies
    * Setup a local YUM repository
  2. Set appropriate kernel and network parameters, shell limits, and file limits for SQL Server
  3. Configure transparent hugepages
  4. Determine and implement the right I/O Scheduler
  5. Configure NTP for the server
  6. Bond network interface
    * Enable jumbo frames
  7. Configuring NFS
  8. Setup correct partition alignment
  9. Centralize System Logging
  10. Simplify DNS
  11. Setup up ssh equivalence between Linux servers
  12. Configure swap settings

Linux Best Practices for SQL Server DBAs

Have confidence in knowing that your Linux environment will be tuned to run a business critical SQL Server database. In this session you will learn the industry best practices to successfully deploy a high performant SQL Server database on bare metal servers and in a virtualized environment running Red Hat 7 Enterprise Linux and SUSE Enterprise Server (SLES v12). You will also quickly master the fine art of automating the build processes by setting the right infrastructure with RPMs and a local YUM repository.

You will also learn the best practices to effectively:

  1. Set kernel and network parameters, shell limits, and file limits for SQL Server
  2. Configure transparent hugepages
  3. Determine and implement the right I/O Scheduler
  4. Configure NTP for the server
  5. Bond network interface
    * Enable jumbo frames
  6. Configuring NFS
  7. Setup correct partition alignment
  8. Centralize System Logging
  9. Simplify DNS
  10. Setup up ssh equivalence between Linux servers
  11. Configure swap settings

Linux Best Practices for SQL Server DBAs

Have confidence in knowing that your Linux environment will be tuned to run a business critical SQL Server database. In this session you will learn the industry best practices to successfully deploy a high performant SQL Server database on bare metal servers and in a virtualized environment running Red Hat 7 Enterprise Linux and SUSE Enterprise Server (SLES v12). You will also quickly master the fine art of automating the build processes by setting the right infrastructure with RPMs and a local YUM repository.

You will also learn the best practices to effectively:

  1. Set kernel and network parameters, shell limits, and file limits for SQL Server
  2. Configure transparent hugepages
  3. Determine and implement the right I/O Scheduler
  4. Configure NTP for the server
  5. Bond network interface
    * Enable jumbo frames
  6. Configuring NFS
  7. Setup correct partition alignment
  8. Centralize System Logging
  9. Simplify DNS
  10. Setup up ssh equivalence between Linux servers
  11. Configure swap settings

Containerization Essentials for SQL Server DBAs
Stay tuned in the upcoming months, as we go through a step-by-step process of setting up and running SQL Server in a docker container, as well as demonstrate how to manage a docker environment.

Meet Our Speakers

Charles Kim is an Oracle ACE Director, a VMware vExpert, an Oracle Certified DBA, a Certified Exadata Implementation Specialist, and a Certified RAC Expert. Charles specializes in RAC, Exadata, Cloud, complex data replication, and virtualization and is the co-author of nine books on Oracle Database. Charles holds certifications in Oracle, VMware, Red Hat Linux, and Microsoft, and has over 26 years of Oracle experience on mission- and business- critical databases. Charles presents regularly at local, regional, national, and international Oracle conferences, including COLLABORATE, VMware World, and Oracle OpenWorld, on topics of RAC, ASM, Cloud, Linux best practices, Data Guard best practices, VMware best practices, Oracle on VMware virtualization, and 7×24 high-availability considerations. Charles is the founder and president of Viscosity North America, a niche Oracle consulting company specializing in Exadata, RAC, virtualization, and Oracle Cloud. Charles is also the president of the Cloud SIG for the Independent Oracle User Group.

 

 


Kevin Kline, Principal Program Manager. Kevin (@kekline) is responsible for expanding SentryOne’s technical sales and marketing initiatives and is also heavily involved in product design activities. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, Google Author, and long-time blogger at sqlblog.com and at kevinekline.com.

Get In Touch






    [recaptcha]

    Share This