Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

Database Monitoring and Performance

dbaddon.mp4 - Google Drive Sign in Most modern web applications are heavily reliant on persisting data with relational databases, and so it’s no surprise that a large part of application performance monitoring relates to keeping an eye on database performance to ensure that our SQL queries are as efficient as possible. With this in mind, Scout features a Database Add-on module, and in this video, we are going to take a closer look at what it has to offer.

NiCE MongoDB Management Pack for Microsoft SCOM

Cloud application requirements have pushed beyond the limitations of relational database management systems. This rising demand for managing unstructured data, along with the growing need for data analytics, has caused significant market growth in the NoSQL database sector. MongoDB, as one of the classical NoSQL databases, is a powerful tool helping companies align with new cloud-based business strategies. With great power comes great responsibility.

Introduction to Database Security: Security Basics You Need to Know

Database security is essential to keep your business’s data and files security from others that do not need access. Whether you are a small business owner or are a database administrator for a medium or large company, you need to have a solid understanding of data security basics.

Understanding Database Transactions in Rails

Few things are scarier than a database slowly losing integrity over weeks or years. For a while, nobody notices anything. Then users start reporting bugs, yet you can't find any code that's broken. By the time you realize the problem, it may be happening for so long that your backups are unusable. We can avoid problems like these with skillful use of transactions.

Django and the N+1 Queries Problem

The N+1 Queries Problem is a perennial database performance issue. It affects many ORM’s and custom SQL code, and Django’s ORM is not immune either. In this post, we’ll examine what the N+1 Queries Problem looks like in Django, some tools for fixing it, and most importantly some tools for detecting it. Naturally, Scout is one of those tools, with its built-in N+1 Insights tool.

What is PostgreSQL, and why do developers love it?

(Want your cloud apps managed? Reach out to Canonical now. You can also watch our webinar on why you should get your apps managed, and get your application reviewed by our app engineers.) PostgreSQL solves the problem of extensibility, in complex cloud environments. This statement is often thrown around, but why is it true? Should next-generation cloud-infrastructure still use it? Is it still relevant in an era of big data?

Secure Access to PostgreSQL with Pgweb

PostgreSQL is an open source database known for its reliability and performance. It’s used across many industries and applications, and is especially a favorite of web developers. All major web frameworks support PostgreSQL natively, from node.js and Django to Rails and Spring, so its adaptation is relatively broad across the internet for site backend systems. As with any database, developers need tools to work with them. Pgweb is an open source, web-based client for PostgreSQL.

Monitoring and Securing Cloud-Based Databases Is the Developer's Responsibility

Modern application development requires more work to ensure the development path and the data it produces are fully in sync, secure, optimized, and error-free. This responsibility has increasingly fallen upon application developers. They’re being asked to double as database administrators to maintain fluidity in the process and support an agency’s rapid release cycle.

What Is a Serverless Database? (Overview of Providers, Pros & Cons)

To put it simply, serverless computing is a cloud computing execution model meaning that the cloud provider is dynamically managing the distribution of computer’s resources. What’s taking up valuable computing resources is the function execution. Both AWS and Azure charge more if you have a combination of allocated memory and the function execution elapse time which is rounded up to 100ms.