Benjamin Nevarez Rotating Header Image

Uncategorized

SQL Server on Linux Foreword by Kalen Delaney

I started working with SQL Server more than 30 years ago, when it was a Sybase product that ran on Unix (as well as on more than half a dozen other operating systems), and we did all our work on Unix machines. SQL Server didn’t run on Windows at that time, because there was no Windows operating system. But several years later, when Sybase partnered with Microsoft to port its database product onto PC-based operating systems, few people could foresee just how powerful and ubiquitous these PCs would become. PC is hardly about only personal computers these days.

I’ve seen a lot of changes with SQL Server over these three decades, and some of the most interesting ones for me are when the product seems to circle back and add features or internal behaviors that were originally part of the product but had once been discarded. Some of the original ideas were not that far off base after all. Having SQL Server return to its roots and become available on Linux (a Unix-based OS) in SQL Server 2017 almost seems like coming home.

Benjamin Nevarez has been working with Unix-based operating systems almost as long as I’ve been working with SQL Server. He was also excited to see SQL Server make an appearance on Linux. It didn’t take him long to decide to get his hands dirty and figure out how SQL Server professionals could get the maximum value out of the new OS. He wrote this book to make available to others all that he had learned.

I have known Ben for more than a dozen years, since he first started finding typos and other errors in my SQL Server 2005 books. We started a dialog, and I then asked him if he was interested in being a technical editor for some of my work. Through this technical collaboration, I have learned that when Ben sets out to learn something, he does it thoroughly. His attention to detail and passion for complete answers never cease to amaze me.

In this book, Ben tells you how to get started using SQL Server on Linux and how the database system actually works on the new platform. Chapters 1, 2, and 3 are particularly useful if you’re new to Linux but experienced with SQL Server. Although most SQL Server books wouldn’t go into operating system administration details, Chapter 3 does just that, to make the transition easier for people who have many years, if not decades, of experience with Windows. Of course, if you’re already proficient with Linux, but new to SQL Server, you can focus on the following chapters when Ben’s expertise with SQL Server shines through.

In Chapter 4, he tells you how SQL Server can be configured and blends SQL Server details with the Linux tools you need to access and control your SQL Server. Chapters 5 and 6 are very SQL Server focused. Chapter 5 provides some very detailed information about working with SQL Server queries, including how queries are optimized and processed, and how you can tune slow-running queries. Chapter 6 tells you all about some of the latest and greatest in SQL Server’s optimization techniques in the most recent versions of SQL Server. Finally, in Chapters 7 and 8, he provides coverage of two critical focus areas for a database administrator: managing availability and recoverability, and setting up security. These are critical topics for any DBA, and because they involve the relationship between the database engine and the operating system, it’s best to learn about them from someone who is an expert in both areas.

Although both Linux and SQL Server are huge topics and there is no way one book can provide everything you need to know about both technologies, Ben has done an awesome job of giving you exactly what you need to know, not only to get SQL Server running on the Linux operating system, but to have it performing well, while keeping your data safe and secure.

—Kalen Delaney

www.SQLServerInternals.com

Poulsbo, Washington, March 2018

PASS Summit and Other Speaking Engagements

It is almost that time of the year again when we are all headed to attend the largest SQL Server conference in the world, the PASS Summit, hosted again in Seattle. In my particular case I will also be attending some other SQL Server events where I will be given probably more than a dozen presentations. But like a rock band getting ready for a world tour 🙂 I’ll start warming up with a local gig at our SQL Server user group. I’ll be presenting Query Processing in In-Memory OLTP (Hekaton) this Thursday, September 18th at the Los Angeles SQL Server Professionals Group. Their meetings are hosted at the UCLA campus and you can visit their page for more details.

Two days later I’ll be attending our SQLSaturday in San Diego where I am schedule to present three sessions: the Hekaton session previously mentioned, Understanding Parameter Sniffing and Dive into the Query Optimizer – Undocumented Insight. As usual this event includes great speakers from all over the country and this time we will have Itzik Ben-Gan, Grant Fritchey, Randy Knight, TJay Belt, Mickey Stuewe, Brandon Leach, and Andrew Karcher among others. You can see the schedule and register at the SQLSaturday website.

So far I only have one event scheduled for October which is a local user group meeting at the San Dimas Software & Database Professionals group where again I will be presenting my Hekaton session. The session is scheduled for October 8th and you can find the meetup page here.

Then the first week of November I’ll be attending both the MVP Summit and the PASS Summit in Seattle, WA. But my flight will make a short stop first in Portland, OR to attend the Oregon SQLSaturday which is scheduled for November 1st. My only session for the event, Query Processing in In-Memory OLTP (Hekaton), is scheduled at 4:30pm. After the Oregon SQLSaturday I will be attending my first MVP Summit from November 2nd to November 6th. I am excited to be attending this event for the first time. The PASS Summit starts on November 4th and I’ll be presenting Query Processing in In-Memory OLTP on Friday, November 7th at 8:00am, rooms 611-612. This would be my 12th PASS Summit and my 7th year as presenter.

Before closing 2014, I’ve been invited to Istanbul, Turkey to participate on their SQLSaturday which is scheduled for the first weekend of December. I am planning to deliver a pre-con on Friday 5th covering “SQL Server Query Tuning & Optimization” topics and will be presenting my Hekaton session at the SQLSaturday the following day. I’ll provide or tweet more details as they become available.

I look forward to seeing lots of SQL Server professionals and meeting new friends at these SQL Server events.

Finally, after writing a new book this year it looks like I took a good break from writing. I just started working on some articles again and will be posting them soon both on this blog and on SQLPerformance.com.