Software Development
 |
Resource Groups in MySQL 8 Resource Groups, a new feature in MySQL 8 for resource management, are used to define a group for a certain type of threads, and to allocate the resources that threads in a particular group may consume. This results in prioritizing the different groups of threads. |
|
 |
Window Functions in MySQL 8 Window functions are a new feature in MySQL 8. While most functions operate only on the data pertaining to a single row of data, Window functions operate over a “window” of data when performing a SQL query, and also for each query row. |
|
 |
Creating a New User in MySQL 8 In MySql 8, you may create a user that requires multiple authentication methods, uses a random password, with comments and attributes annotated with the user, and configured failed logins. |
|
 |
Common Table Expressions in MySQL 8 Common Table Expressions (CTEs) are a new feature in MySQL 8.0 to simplify SQL code related to result sets generated by subqueries, offering a better alternative to derived tables. |
|
 |
4 DevOps Security Challenges and Solutions Various cultural and technical challenges can impact DevOps security, but the main security issues generally derive from the gap between the security and development teams. |
|
 |
The New Data Dictionary in MySQL 8.0 The data dictionary tables do incur some operational and upgrade differences, but the benefits outweigh the overhead. |
|
 |
4 Questions to Audit API Security In the first half of 2021, API attacks had increased by 348%. With the proliferation of APIs, we have every reason to plan for an increase in the number and complexity of attacks. This questioning to API security provides lines of inquiry that lead to a better understanding of how APIs fit into security and business. |
|
 |
The 5 Biggest Challenges Facing the IoT Today The Internet of Thing's rapid growth and prevalence has brought with it a host of unique challenges that have to be addressed as we continue to integrate it into our personal and professional lives. So, let’s look at why they exist, and possible solutions to them. |
