The Latest Stories
 |
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. |
|
 |
That’s a Great Idea! Let Me Get Back to You… Being responsive to customer needs and desires is not a bad thing—the decision to accept, reject, or defer a change is something that should be considered in light of the consequences of the delay. |
|
 |
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. |
|
 |
The Cost of Running Late Projects exceed their predicted schedules for many reasons. The cost consequences of some delays are obvious, but some are subtle. Knowing the expected costs of delays is vital to supporting informed decision-making. |
|
 |
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. |
|
 |
Control the Narrative We often talk about the importance of effective communication on a project, but we often omit timing and context. Messages need to be timely if a project manager is going to guide the narrative. |
|
 |
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. |
