today's howtos

posted by Roy Schestowitz on Feb 08, 2023

• Mysql Loading sample data

  Introduction MySQL is one of the most popular open-source relational database management systems used for managing and organizing data. To test and practice the features and functionality of the database, sample data can be loaded into the MySQL database. In this article, we will discuss how to load sample data into a MySQL database.

• Mysql Inserting, Updating, and Deleting Rows

  MySQL is one of the most widely used relational database management systems in the world. It is an open-source database management system, which means that it is free to use and modify. It is widely used by website developers, data analysts, and other professionals who need to manage and analyze large amounts of data.

• Day 96: the margin-trim property

  The margin-trim property allows a container element to trim the margins of its children where they adjoin the container’s edges.

• 4 Useful Commands to Clear Linux Terminal Screen

  Just like any other operating system, Linux also supports a rich Graphical User interface (GUI). In fact, it supports multiple graphical desktop environments such as – GNOME, KDE, Cinnamon, and the list goes on.

  However, most Linux administrators and power users prefer to use the command line interface, because it allows us to automate repetitive tasks using the scripts.

• 🔒 SSL is Everywhere

  This has all changed with the availability of free SSL certificates from Let’s Encrypt. There is now a much wider adoption of SSL encryption across the Internet. It is becoming less and less common to find web sites which don’t offer https. Wider adoption of SSL is a very good thing, but with this added layer of security there comes an added layer of complexity. Just like domain name registrations, SSL certificates need to be renewed regularly, otherwise they expire. This means you now have one more thing to monitor. 1

  In this post we’ll look at a three different ways to automate getting SSL certificate expiration dates. 2 Before we get to that, is an easier way?

• Regular Expressions make me feel like a powerful wizard - and that's not a good thing

  As a result, once the RegEx becomes more than trivially complex they're hard for most humans to understand. That makes them difficult to debug. It also makes it difficult to add or remove functionality.

• How to Setup Local YUM/DNF Repository on RHEL 9

  In this post, we will show you how to setup local yum/dnf repository using ISO file on RHEL 9.

• Peter Czanik: Syslog-ng 101, part 6: Destinations and log path

  This is the sixth part of my syslog-ng tutorial. Last time, we learned about syslog-ng source definitions and how to check the syslog-ng version. Today, we learn about syslog-ng destinations and the log path. At the end of the session, we will also perform a quick syntax check.