Tag: SQL

Published on 11 May

The Most Effective SQL Server Activity Monitor Strategy

By Alexander FO , In DevOps, Software Architecture

Databases power all modern applications, from banking and ATM software to space shuttle systems and your Angry Birds game. Wherever you go, you will find databases. The most common databases used today are relational or SQL databases, where data is stored in interconnected tables. In turn, you can query those tables using a query language that resembles plain English, Standard Query Language (SQL). To get the most value of the SQL databases you use as a developer, system administrator, or database administrator, it’s vital that you have visibility into what’s going on. …

# , ,
Read More

Published on 19 January

Spring SQL Injection Guide: Examples and Prevention

By Alexander FO , In Backend

Introduction As hackers find increasingly creative ways to attack applications, organizations must try to stay one step ahead in protecting themselves, even from the most common types of attacks and across a variety of frameworks. Let’s start this post with a few definitions. SQL Injection SQL injection is a common way that hackers and users with malicious intentions attempt to hack applications. In an SQL injection, they “inject” values into a database query in order to gain visibility into the database’s structure and eventually gain access to personal data stored in the …

# , ,
Read More

Published on 12 July

SQL vs NoSQL Performance: Where One Outperforms the Other

By Alexander FO , In Backend, DevOps

NoSQL databases have taken the world by storm in recent years. What started as a niche phenomenon grew to rival the popularity of the “old” SQL relational databases. However, relational databases still have their use cases and are not going to disappear anytime soon. In this post, I’ll discuss the differences between SQL and NoSQL databases and do an analysis of their respective performance. Lastly, I’ll give a list of use cases for which one is better than the other and vice versa. What Are SQL Databases? SQL databases, or relational databases, …

# , ,
Read More