Limits in Containers

Docker gives you the ability to control a container’s access to CPU, Memory, and network and disk IO using resource constraints, sometimes called Limits. You define limits as parameters when creating containers. In its default configuration, a container will have no resource constraints for accessing resources of the host operating system. This post will look at how to configure resource constraints in Docker and look at how SQL Server sees the resources when CPU and Memory resource constraints are in place.

I want to start by saying thank you to all who submitted, and an amazing collection of people submitted some fantastic content. Also, thanks to Steve for asking me to host and being patient with me for mixing up the dates and the hashtag. It’s #tsql2sday and it’s on Tuesday not Wednesday :P

Now, onto the posts in submission order.

Rob Farley – On containers

In recent years containers have come into the data platform world, exposing new technologies to data professionals. Microsoft put SQL Server in Linux, and shortly after that, SQL Server made its way into containers. SQL Server in Containers has become the foundation for things like Big Data Clusters and Azure Arc-enabled Data Services

My invitation to you for this month’s #tsql2sday is…

I want to invite you to share your experiences using containers and not just SQL Server in containers…

Where I’ve Been

Since January 1, 2012 I’ve been the principal consultant at Centino Systems. Jokingly, I refer to myself as The Centino of Systems. I learned a lot of lessons running my own business. Such as how to be a consultant and also how to scale the business even as the only employee/consultant. There’s been ups and downs, successes and failures and I couldn’t be more happy with how things went. The first phase of Centino Systems I learned how to build a consulting practice. Then in the second phase I learned how to scale Centino Systems by focusing on training. I blogged a bunch, produced 21 courses at Pluralsight, co-authored three books (with one more on the way), and numerous corporate and conference sessions and workshops focusing on Linux, SQL Server and of course Kubernetes.

Ever need to set your web server a specific protocol version of TLS for web servers and need a quick way to test that out to confirm? Let’s check out how to use curl to go just that.

This code here uses curl with the parameters --tlsv1.1 --tls-max 1.1, which will force the max TLS protocol version to 1.1. Using the --verbose parameter gives you the ability to see the TLS handshake and get the output sent to standard out.

My updated course “Managing the Kubernetes API Server and Pods” is now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right in check it out here! 

This course targets IT professionals that design and maintain Kubernetes and container based solutions. The course can be used by both the IT pro learning new skills and the system administrator or developer preparing for using Kubernetes both on premises and in the Cloud.

My updated course “Kubernetes Installation and Configuration Fundamentals” is now available on Pluralsight here! If you want to learn about the course, check out the trailer here or if you want to dive right in check it out here! 

This course targets IT professionals that design and maintain Kubernetes and container based solutions. The course can be used by both the IT pro learning new skills and the system administrator or developer preparing for using Kubernetes both on premises and in the Cloud.

I’m super proud to announce that Ben E. Weissman and I have published Azure Arc-Enabled Data Services Revealed available now at Apress and your favorite online booksellers! Buy the book now; or keep reading below if you need to be more convinced :)

A couple of notes about the book first, I enjoyed working with this bleeding-edge tech and collaborating with the SQL Server Engineering Team at Microsoft on this. I want to call out the support from our tech reviewer, and Program Managed for Azure Arc Enabled Data Services, Travis Wright. Thanks for your help and support. Be sure to read the forward from Travis; it tells the story of why and how. From getting SQL Server on Linux, into containers, into Kubernetes, Big Data Clusters, and now Arc Enabled Data Services. Awesome stuff. I also want to call out my co-author and friend, Ben. You are an excellent writer. Thank you for including me in this adventure!

Recently I needed to take a look at all of the SQL Server Agent Jobs and their Jobs Steps for a customer. Specifically, I needed to review all of the Jobs and Job Steps for Ola Hallengren’s Maintenance Solution and look at the Backup, Index Maintenance and Integrity Jobs to ensure they’re configured properly and also account for any customizations and one-offs in the Job definitions. This customer has dozens of SQL Server instances and well, I wasn’t about to click through everything in SSMS…and writing this in TSQL would have been a good candidate for a Ph.D. dissertation. So let’s check out how I solved this problem using dbatools.

Pre-conference Workshop at Data Platform Virtual Summit 2020

I’m proud to announce that I will be be presenting pre-conference workshop at Data Platform Virtual Summit 2020 split into Two four hour sessions on 30 November and 1 December! This one won’t let you down!

Here is the start and stop times in various time zones:

Time Zone	Start	Stop
EST	5.00 PM	9 PM
CET	11.00 PM	3.00 AM (+1)
IST	3.30 AM (+1)	7.30 AM (+1)
AEDT	9.00 AM (+1)	1.00 PM (+1)

The workshop is “Kubernetes Zero to Hero – Installation, Configuration, and Application Deployment”