Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Using SQL Clone with Githooks & Branch Policies in Azure DevOps

Switching branches quickly and testing Pull Request code when working on database changes is no easy thing, but fear not! Join Chris Unwin in this video to find out how you can set up SQL Clone to allow developers to preserve changes when switching branches, and how teams can review code against a live DB, rather than relying on the raw code in version control.

How to Optimize Server Performance

Optimizing server performance is important in supporting end-user requirements. Using server optimization, actively monitor: Web server monitoring and optimization helps you to troubleshoot bottlenecks as they emerge and optimize server performance. In this post, we will discuss how to optimize performance and why it is important.

Key Challenges of Database Cloud Migration

As we shift enterprise computing to the cloud, the need for database migration increases—but with this comes the inherent challenges of migration and the need to plan. Moving to the cloud can come with more risks and obstacles than migrating a database within a data center or from one on-premises data center to another. If a business isn’t fully prepared to migrate, they’re almost certain to run into issues.

What is the difference between Database, Data Warehouse, and Data Lake?

Data is everywhere in the form of values, text, numbers, pictures and so on that can be stored and used anytime when required. The importance of data and data storage systems has gained recognition since businesses find the potential of big data and its use cases. The data was with us always, but the possibilities to use it effectively were an arduous task.

Why We Chose the M3DB Data Store for Logz.io Prometheus-as-a-Service

Logz.io is focused on creating the best observability service to manage the scale of monitoring, add value on top of AI/ML technologies, and enhance enterprise security. Metrics is one of the pillars of Logz.io, and our Prometheus-as-a-Service offering. It has been a crucial part of our platform goals, but if we turn the clocks back a year, our service only used the open-source Elasticsearch database (ES).

Creating Custom Event Views in SQL Sentry

If you’re using SQL Sentry regularly, there’s a great event management feature that provides a lot of value for our advanced users. I often find the SQL Sentry Event Calendar isn’t being used as often as it once was. The Event Calendar lets you view historical and future events, drill down into event failures, and reschedule jobs using drag and drop all from within the SQL Sentry desktop client. In addition, you can create custom views of events you need to reference frequently.

DevOps As a Bludgeon

When I first started trying to figure out how to automate database deployments, over 15 years ago, I will freely admit, I was both skeptical and reluctant. I had to be dragged up to the notion that automating getting the database code out the door wasn’t just an excuse by the developers to find a way to bypass the DBA team. As per the traditional, biased, story, our favorite word was “No!”.

Effective Technical Writing Is Essential for Your Organization's Success

"No one likes documentation", chirped the little blue birds. The bird quotes in the image above are all taken from real tweets and are listed below for accessibility: I can't argue with "liking to write documentation" being a rare skill, since so many people are vocal about disliking it. That tweet might prove to be true, in which case, technical writers should simply be more appreciated for the rare gems that they are. In this blog post, however, I’m going to explain.

Database Cloud Migration Done Right - SolarWinds Lab Episode #95

The global pandemic has accelerated corporate planning for cloud computing and digital transformation by 2-4 years on average. But database migration, the process of moving a database from one place to another, is no walk in the park. Obstacles abound. Setbacks are common.