25 September 2023
25 September 2023

MySQL joins

0
1
Tables in a MySQL database are commonly related to one another, often in multiple ways, and it is only by linking the tables together that you can derive meaningful information from the data. To connect these tables together, you can use the JOIN clause, which you include in your SELECT, DELETE, or UPDATE statements. The … Read more
0
1
22 September 2023
22 September 2023

Analyze and Tune SQL Server Statistics

Over the years, SQL Server Statistics have been discussed in countless blog posts, articles, and presentations, and I believe that they will remain a core topic for a while when speaking about performance. Why is that? Well, if we were to consider the equivalent of Maslow’s hierarchy of needs for database performances, statistics would be … Read more
18 September 2023
18 September 2023

Alternatives To SQL Server 2022 Built-in function GREATEST

If you haven’t already heard, SQL Server 2022  introduced a new built-in system function called GREATEST. Simply put, it is to a set of columns, variables, expressions etc. what the MAX function is to a set of values (i.e., rows) of a single column or expression. The opposite of GREATEST function is LEAST function which … Read more
15 September 2023
15 September 2023

How to Set up Jenkins CI/CD on Kubernetes Cluster using Helm

0
0
Jenkins is an open-source multi-platform software for continuous integration/continuous delivery and deployment (CI/CD) in DevOps. It is one of the most common CI/CD tools. Jenkins uses CI/CD pipelines to automate the software development and deployment workflows. Jenkins uses plugins to integrate with DevOps tools such as Docker and Kubernetes. Jenkins plugins can also be used … Read more
0
0
07 September 2023
07 September 2023

Working with MySQL constraints

0
1
MySQL provides a set of constraints that you can include in your table definitions to help ensure the integrity of the data. The constraints let you better control the types of data that can be added to the database. For example, you can use constraints to set a column’s uniqueness or nullability, specify a default … Read more
0
1
05 September 2023
05 September 2023

Orchestrating a MySQL Container on Kubernetes

If you’ve been using MySQL for a while and want to learn how to orchestrate MySQL containers, you’ve come to the right place. And while using Docker on its own to manage a single MySQL instance or multiple instances has certain drawbacks, such as lacking the ability to orchestrate multiple instances, scale, and provide services … Read more
01 September 2023
01 September 2023

Decoding Efficiency in Deep Learning, A Guide to Neural Network Pruning in Big Data Mining

0
0
In recent years, deep learning has emerged as a powerful tool for deriving valuable insights from large volumes of data, more commonly referred to as big data. Harnessing the computational capabilities of artificial neural networks, deep learning algorithms have the ability to model complex patterns and make accurate predictions based on these patterns. This makes … Read more
0
0
17 August 2023
17 August 2023

AWS Step Functions in C#

0
1
Step functions allow complex solutions to process data in the background. This frees users from having to wait on the results while it is running. Imagine a use case where someone uploads a resume because sifting through resumes takes time, a background process can curate the data and have it ready for a recruiter. In … Read more
0
1
06 August 2023
06 August 2023

Bots Usage in Artificial Intelligence

The usage of bots in artificial intelligence (AI) has gained significant attention and importance in recent years. Bots, also known as chatbots or intelligent agents, are software applications designed to perform automated tasks or engage in conversations with humans; they are an integral part of AI systems, enabling interactions and delivering various functionalities across various … Read more
04 August 2023
04 August 2023

Building REST APIs in Go with Mux and GORM

In modern software development, Application Programming Interfaces (APIs) are essential for building scalable and flexible systems. APIs enable applications to communicate and exchange data, amongst other actions. Representational State Transfer (REST) is an API specification for building simple, scalable, client-server APIs based on HTTP, stateless, cacheable, and layered. RESTful APIs provide a medium for interaction … Read more