pandora fms

Fourteen Free SQL Software Tools

Our databases are the ones that keep the Internet alive. There has even been talk for some years about the development of operating systems with which users do not have direct contact with the files, but their personal files are stored in a local DB. In fact, we already see how there are online services that do this for us, such as Google Drive or Nextcloud, the latter written under free license Affero.


SQL Performance tuning: 6 Tips for tuning SQL server

SQL performance tuning can be a tricky thing. We spend so much time focusing on our business logic, it’s easy to leave the database behind in the dust. But it’s important to keep the DB in mind to maintain quality performance. We need tools in our toolbox to tune our SQL performance. In this post, we map out six tips to help you tune SQL Server. Learn more and try Raygun free for 14 days.


Spring Cleaning at OverOps: How (and Why) We Changed Our DB Cleaning Strategy

There comes a time in the life of any application that small things we let slide become unignorable issues. For us, it happened when, after years of writing and executing code, our DB’s free disk space started to run out. Each passing day brought us closer to our eventual doom, and we finally had to allocate the time to fix the problem.

Cassandra vs. MongoDB vs. Hbase: A Comparison of NoSQL Databases

Unlike traditional SQL databases, NoSQL databases, or “non-SQL” databases, do not store their data in tabular relations. Originally designed for modern web-scale databases, they have found widespread use in present-day big data and real-time web applications. Some of the most commonly used data structures include key-value, wide column, graph, and document stores.


Automation of SQL Server Environments for SQL Developers

At any given time, a DevOps or DataOps team can be responsible for managing dozens of databases. With so much to monitor, automation is key for ensuring performance issues are recognized and addressed efficiently and quickly. To be sure, it can be daunting to hand off critical business operations to non-human operators (which is what happens when you automate database administration), but delivering repeatability and accuracy sometimes trumps gut feelings.

When to Scale Up in RDS: Freeable Memory

Monitoring freeable memory will help you know when it is time to scale your Amazon RDS cluster. Freeable memory is not reported by the database, but rather by the OS. Freeable memory is the combination of unused and temporarily used memory. It is the memory that the system can grant without adverse effects. When an Amazon RDS instance runs out of freeable memory the OS may do up to three things.

What is Database Security?

Database security refers to the various measures organizations take to ensure their databases are protected from internal and external threats. Database security includes protecting the database itself, the data it contains, its database management system, and the various applications that access it. Organizations must secure databases from deliberate attacks such as cyber security threats, as well as the misuse of data and databases from those who can access them.

When to Scale Up in RDS: 7 Critical Metrics

RDS is Amazon's managed relational database service. While RDS manages your databases maintenance, uptime and upgrade it is your responsibility to determine the cluster's scale and capacity. So the big question is when do you need to scale up? To answer this question you should understand and monitor seven metrics for each server in your cluster. They are: Database connections, Freeable memory, CPU credit balance, Free local storage, Replica lag, Commit latency, Select latency