Operations | Monitoring | ITSM | DevOps | Cloud

July 2021

Featured Post

How You Can Make Your Database More Efficient

Data is the lifeblood of your business, critical to its survival and success. It delivers insights into customers' specific needs, helping you better understand them and deliver a more tailored user experience. With data playing such a key role in whether modern businesses sink or swim, it's vitally important to optimize your database to ensure data is insightful, relevant, and actionable, providing the end user with the best possible experience.

Introducing Redgate's flexible-hybrid working model

The world of work has changed dramatically over the last year and, at Redgate, we’ve been reflecting on what this might mean for our business, and the ways that we work together in the future. From 2022 onwards, we’re aiming to offer Redgate staff a flexible-hybrid working model across our global organization.

SQL Made Simple for vSphere-powered Data Centers

Today we’re announcing a new feature of VMware Tanzu SQL called Data Management for VMware Tanzu. It offers a convenient user interface that simplifies the operation, automation, and scalability of Tanzu SQL databases (Postgres and MySQL); this same convenience is also available from a comprehensive set of APIs.

How Redox quickly identify and resolve database performance issues

In the IT team at Redox, I wear two hats: Software Development Manager and DBA. I’m the only DBA in the team, so if anything goes wrong it’s my job to identify and fix it. As you might imagine, this can be challenging when being a DBA isn’t your full-time role. Based in Sydney, Redox is one of the leading chemical and ingredients distributors in the world, with over 350 employees across our locations in Australia, New Zealand, Malaysia, and the US.

How to monitor Cassandra database clusters

Apache Cassandra is an open-source distributed NoSQL database management system that was released by Facebook almost 12 years ago. It’s designed to handle vast amounts of data, with high availability and no single point of failure. It is a wide-column store, meaning that it organizes related facts into columns. Columns are grouped into “column families.” The benefit is that you can manage data that just won’t fit on one computer.

How Converting to YAML Build Pipelines Can Help Engineering Teams Be More Efficient

Engineering teams can only be as efficient as the processes they employ during development. The need for increased efficiency is why software development has shifted from the “waterfall” approach to a more responsive, agile methodology. In an agile development environment, quality software can be delivered consistently to suit the ever-changing needs of stakeholders and end users.

Gaining a real competitive edge in managed services

These are interesting – and challenging – times to be a Managed Service Provider. When it first published its Managed Services Market Size Forecast, Mordor Intelligence valued the market at US$152 billion in 2020, and predicted it to reach US$274 billion by 2026, a compound annual growth rate of 11.2%. Over a year later, following a pandemic which has changed the way most of us work and which will probably see permanent changes going forward, Mordor is sticking by its prediction.

How to encourage DBAs to embrace DevOps, rather than fear change

How do we help Database Administrators (DBAs) embrace DevOps in a way that can be really productive and part of a rich DevOps team that delivers value to customers quickly and continuously? That’s an important question to ask right now because there’s a common view among DBAs that DevOps isn’t for them. They’re responsible for documentation and maintenance and deployments, they have internal customers, and they serve internal requests.

After analyzing 600,000 SQL queries, these are the top mistakes developers make - Oded Valin

Yalla! DevOps 2021 -- The first, in-person DevOps conference of the year! Driven by the DevOps community. All about the DevOps community. Users want to see their data fast, immediately, now. Whether you’re working with an ORM or writing native SQL, you probably had a “scratching-my-head-trying-to-figure-out-why-this-database-is-so-slow” moment. The team at EverSQL analyzed more than 600,000 SQL queries from thousands of different companies, to lay down the most common mistakes developers do when writing SQL queries. This talk focuses on writing SQL the right way, the fast way.

Cloud 66 Feature Highlight: Multi Database Support

Many applications use multiple types of datastores simultaneously - mixing SQL and NoSQL databases, for example. Or your application might need two separate clusters of the same database engine to handle an upgrade, or to support separate services. This is where Multi Database Support comes handy. What is Multi Database Support? Multi Database Support makes it possible to attach more than one database group to your application.

Why Would You Pay for Flyway?

Flyway is an open-source database deployment tool that also includes a paid tier called Teams. Since it’s open-source, you can just download Flyway and run it for free. You’ll get a robust DevOps tool to assist you in deploying your databases just like you deploy your code. It just works. So, why would you even bother to pay for Teams? Actually, there are a number of reasons why people pay for advanced tiers of open-source software in general.

Data cataloging: A giraffe's eye view

In the latest DBAle podcast episode our hosts, Chris and Chris, tackled what they really mean by cataloging a database and how taking a ‘giraffe’s eye view’ approach to compliance is not enough. That’s because the most common data concerns for managers and execs center around where your sensitive data is, the risk it poses and, if you’re migrating to the cloud, how much sensitive data is being stored on that database or that instance.

Overcoming SQL Server Blocking and Locking Challenges

One of the most common performance problems with SQL Server databases in production is the blocking of queries, which happens because database resources are locked. Understanding why locking happens is just half the battle. Being able to resolve locking, which will resolve blocking issues as well, is the second half.

Enabling Single Sign-On with SQL Monitor

It’s never been more critical to protect your data infrastructure against malicious actors, with organizations dealing with an ever-expanding number of increasingly sophisticated attacks. Monitoring solutions represent part of your infrastructure’s attack surface area – they enjoy highly privileged access to the systems they help manage, and store sensitive information about the workloads running on them.

Self-hosting vs Managed Services: Deciding how to host your database

Like all good things in infrastructure, picking whether or not to self-host your database is full of trade-offs. On the one hand, you have the absolute freedom to do whatever it is you want with your database - whether it's adding a useful Postgres extension, or experimenting with new technologies. On the other hand, you now have to dedicate resources to keeping your database reliably online.

PostgreSQL Monitoring: The Best Tools and Key Metrics to Help Improve Database Performance

PostgreSQL is a popular open-source, object-relational database. As with any other data storage solution, capturing metrics is crucial for making sure your database is reliable, available, and performing optimally. This will help you dig deeper into database performance problems, do performance tuning, optimize queries and indexes, and make partitioning decisions. But that’s not all. You’ll also be able to set up alerts and plan for failures or upgrades.

5 Reasons To Use DynamoDB In Serverless Applications

In this webinar, AWS Data Hero Alex Debrie and Uri Parush System Architect at Lumigo will introduce DynamoDB by understanding its unique properties and why it's so popular in serverless applications. They will walk through some tips for using DynamoDB correctly, including identifying and fixing common issues using Lumigo.

3 ways Managed Services Providers can offer more value

For many businesses, using a Managed Services Provider (MSP) makes sense, particularly when it comes to database management, monitoring and security. They can control costs while still having access to expert resources, and dial up or down the service as required. It’s perhaps no surprise then that 47% of people surveyed in the Channel Futures 2020 MSP 501 Report identified professional services as a growth area, 51% identified enhanced network monitoring, and 85% identified security services.

Migrating Between Monitoring Systems

This question comes up all the time: How do you migrate between monitoring systems? The answer is both simple and complicated. In order to understand this better, rather than just rely on my own knowledge, I reached out to a number of people to see how they accomplished this. I’m going to summarize their process for you here in order to help others who may find themselves in need of this information.