SQL

I’m Speaking at SQLSaturday Cambridge!

Speaking at SQLSaturday Cambridge!

  I’m proud to announce that I will be speaking at <a href="http://www.sqlsaturday.com/748/EventHome.aspx">SQL Saturday Cambridge</a> on September 8th 2018! And wow, 748 SQL Saturdays! This one won’t let you down. <a href="http://www.sqlsaturday.com/748/Sessions/Schedule.aspx">Check out the amazing schedule</a> of International Experts and Microsoft MVPs!

  If you don’t know what SQLSaturday is, it’s a whole day of free SQL Server training available to you at no cost!

  If you haven’t been to a SQLSaturday, what are you waiting for! <a href="https://www.sqlsaturday.com/748/registernow.aspx">Sign up now</a>!

  <a href="http://www.sqlsaturday.com/748/EventHome.aspx"><img style="display: block; margin-left: auto; margin-right: auto;" src="http://www.sqlsaturday.com/images/sqlsat748_header.png" alt="SQLSaturday #748 - Cambridge 2018" /></a>

  **This year I have TWO sessions!**

  **1. **<a href="http://www.sqlsaturday.com/748/Sessions/Details.aspx?sid=78607">**Monitoring Linux Performance for the SQL Server Admin**</a>

<blockquote>

    So you’re a SQL Server administrator and you just installed SQL Server on Linux. It’s a whole new world. Don’t fear, it’s just an operating system. It has all the same components Windows has and in this session we’ll show you that. We will look at the Linux operating system architecture and show you where to look for the performance data you’re used to! Further we'll dive into SQLPAL and how it architecture and internals enables high performance for your SQL Server. By the end of this session you’ll be ready to go back to the office and have a solid understanding of performance monitoring Linux systems and SQL on Linux. We’ll look at the core system components of CPU, Disk, and Memory and monitoring techniques for each.

</blockquote>

  **2. **<a href="http://www.sqlsaturday.com/757/Sessions/Details.aspx?sid=78317">**Containers – You Better Get on Board**</a>

<blockquote>

    Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get your started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes. In this session we’ll look at Container Fundamentals with Docker Common Container Scenarios Automation with Kubernetes.

</blockquote>

Questions from PASS Marathon Containers

Thanks to everyone who attended the PASS Marathon Containers edition and to PASS for the opportunity to present. I received the Questions from the session and wanted to provide answers to the attendees and the community.

If you want to see the session again, check it out on YouTube. The decks are available online at http://www.centinosystems.com/blog/talks/

Here’s the list of questions from the session and my answers.

  • What do you mean it is not for production environment in Windows?

Speaking at SQLSaturday Sacramento – 757!

Speaking at SQLSaturday Sacramento!

  I’m proud to announce that I will be speaking at <a href="http://www.sqlsaturday.com/757/eventhome.aspx">SQL Saturday Sacramento</a> on July 28th 2018! And wow, 757 SQL Saturdays! This one won’t let you down. <a href="http://www.sqlsaturday.com/757/Sessions/Schedule.aspx">Check out the amazing schedule</a>!

  If you don’t know what SQLSaturday is, it’s a whole day of free SQL Server training available to you at no cost!

  If you haven’t been to a SQLSaturday, what are you waiting for! <a href="https://www.sqlsaturday.com/757/registernow.aspx">Sign up now</a>!

  <a href="https://www.sqlsaturday.com/757/registernow.aspx"><img style="display: block; margin-left: auto; margin-right: auto;" src="http://www.sqlsaturday.com/images/sqlsat757_header.png" alt="SQLSaturday #757 - Sacramento 2018" /></a>

  **This year I have TWO sessions!**

  **1. **<a href="http://www.sqlsaturday.com/757/Sessions/Details.aspx?sid=78312">**Monitoring Linux Performance for the SQL Server Admin**</a>

<blockquote>

    So you’re a SQL Server administrator and you just installed SQL Server on Linux. It’s a whole new world. Don’t fear, it’s just an operating system. It has all the same components Windows has and in this session we’ll show you that. We will look at the Linux operating system architecture and show you where to look for the performance data you’re used to! Further we'll dive into SQLPAL and how it architecture and internals enables high performance for your SQL Server. By the end of this session you’ll be ready to go back to the office and have a solid understanding of performance monitoring Linux systems and SQL on Linux. We’ll look at the core system components of CPU, Disk, Memory and Networking monitoring techniques for each and look some of the new tools available.

</blockquote>

  **2. **<a href="http://www.sqlsaturday.com/757/Sessions/Details.aspx?sid=78317">**Containers – You Better Get on Board**</a>

<blockquote>

    Containers are taking over, changing the way systems are developed and deployed…and that’s NOT hyperbole. Just imagine if you could deploy SQL Server or even your whole application stack in just minutes. You can do that, leveraging containers! In this session, we’ll get your started on your container journey learning container fundamentals in Docker, then look at some common container scenarios and introduce deployment automation with Kubernetes. In this session we’ll look at Container Fundamentals with Docker Common, Container Scenarios and Orchestration with Kubernetes

</blockquote>

Speaking at SQLSaturday Atlanta – 733

Speaking at SQLSaturday Atlanta!

  I’m proud to announce that I will be speaking at <a href="https://www.sqlsaturday.com/733">SQL Saturday Atlanta</a> on May 17th 2018! This one won’t let you down! <a href="https://www.sqlsaturday.com/733/Sessions/Schedule.aspx">Check out the amazing schedule</a>!

  If you don’t know what SQLSaturday is, it’s a whole day of free SQL Server training available to you at no cost!

  If you haven’t been to a SQLSaturday, what are you waiting for! <a href="https://www.sqlsaturday.com/733/registernow.aspx">Sign up now</a>!

  My presentation is **“<a href="http://www.sqlsaturday.com/733/Sessions/Details.aspx?sid=71960">Monitoring Linux Performance for the SQL Server Admin</a>” **

  <img style="display: block; margin-left: auto; margin-right: auto;" src="http://www.sqlsaturday.com/images/sqlsat733_header.png" alt="SQLSaturday #733 - Atlanta 2018" />

  Here’s the abstract for the talk

<blockquote>

    So you’re a SQL Server administrator and you just installed SQL Server on Linux. It’s a whole new world. Don’t fear, it’s just an operating system. It has all the same components Windows has and in this session we’ll show you that. We will look at the Linux operating system architecture and show you where to look for the performance data you’re used to! Further we'll dive into SQLPAL and how it architecture and internals enables high performance for your SQL Server. By the end of this session you’ll be ready to go back to the office and have a solid understanding of performance monitoring Linux systems and SQL on Linux. We’ll look at the core system components of CPU, Disk, Memory and Networking monitoring techniques for each and look some of the new tools available including new DMVs and DBFS.Prerequisites: Operating system fundamentals, process, memory and disk concepts.

</blockquote>

Attempting to Run SQL on Linux Inside Windows Subsystem for Linux

Update - head on over to Andrew Pruski’s blog to find out how to get this to work!

Shawn Melton MVP and dbatools contributor last week had an issue running SQL Server on Linux inside of Windows Subsystem for Linux.

I didn’t want to leave a brother hanging so I spent this morning digging into this a little bit.

A Novel Idea for High Availability in SQL Server on Linux

Over the past year we’ve learned about how SQL Server on Linux is implemented, leveraging SQLPAL and the team is pretty confident in their architectural decisions as indicated in this post here.

Now that there is this wrapper around SQL Server, this really opens up some interesting opportunities…perhaps we can leverage SQLPAL to facilitate some new high availability techniques.

When I was in graduate school, I worked on a research project, that became my master’s thesis. In this work, I developed a technique that synchronized the process address space of a virtual machine on two separate physical hypervisors.The technique involved an initial copy of all pages between the two systems and then selectively copying the virtual machine’s pages as they became dirty. Using this technique, the process address space of the virtual machine is synchronized between the two hypervisors. This allows for a significant reduction in the amount of information that had to be replicated between the hypervisors but more importantly…the virtual machines memory in sync which meant if hypervisor hosting the virtual machine crashed we could theoretically start the virtual machine on the second hypervisor.

I’m Presenting Two Linux Sessions on One Day!

On 12/13 I’m presenting two, back to back, sessions on SQL Server on Linux online. So you can attend from anywhere!

Let’s go through both!

First, on 12/13 at 1PM Central, I’m presenting for the PASS Database Administration Virtual Group here’s my session details:

Topic: Linux OS Fundamentals for the SQL Admin

Registration: You must register if you want to attend. You can register at http://dba.pass.org/. When you register, you will receive a link to the meeting. All attendees will be entered into a raffle for a $25 gift card.

Top 5 Reasons Why I think SQL Server on Linux is Legit

Here are my top 5 reasons why I thing SQL Server on Linux is Legit!

  1. **SQL Server on Linux is Fast** – Earlier this year SQL Server on Linux posted the fasted 1TB TPC-H benchmark in the world and at the end of October posted the a 10TB result! Check out the results here and some info on how they did it here and here.
  2. It’s tunable – From and OS standpoint, I think the “tunability" of the operating system is more well documented and well known on Linux. Check out Microsoft’s recommendations <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-performance-best-practices">here</a> and also Redhat’s <a href="https://access.redhat.com/documentation/en-US/Red_Hat_Enterprise_Linux/7/html/Performance_Tuning_Guide/">here</a>.
  3. Features – If you’re a developer in the Linux ecosphere, this is the reason why you’re evaluating using SQL Server on Linux…there’s likely a feature you want…that you can now have. Check them out <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-editions-and-components-2017">here</a>!
  4. Enterprise Support – I like cruising around in forums just like anybody else, but sometimes you have to <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-overview">call</a> support to bring in the people that actually wrote the software.
  5. Availability Solutions – SQL Server has a proven track record for availability, those same concepts and techniques apply to SQL Server on Linux. Backups, Availability Groups, and Failover Clusters <a href="https://docs.microsoft.com/en-us/sql/linux/sql-server-linux-business-continuity-dr">check it out</a>.