Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

Getting Started with SQL Queries

Jul 24, 2023 By Aiven In Aiven
Welcome to our tutorial on executing basic queries on pgAdmin, the intuitive GUI tool for managing PostgreSQL databases. In this video, we'll cover essential SQL commands such as SELECT, UPDATE, DELETE, and INSERT, and demonstrate how to utilize them effectively on pgAdmin. Whether you're a beginner or looking to refresh your SQL skills, this tutorial provides valuable insights and practical examples. Additionally, we'll share helpful resources like SQL cheatsheets and codecademy's SQL commands article to further enhance your understanding.
View Video
redgate

Managing the challenge of migrating to the cloud

Jul 21, 2023 By Matt Hilbert In Redgate
Migrating to the cloud has many advantages … until you’re the one tasked with making it happen. For many data professionals, this will be a first step from the traditional, predictable challenges of managing on-premises servers to the many and varied databases and platforms in the cloud. As many have discovered, it’s not simply a case of ‘lift and shift’.
Read Post
grafana

How Worldline uses Grafana Enterprise and Grafana Mimir to run its platform-as-a-service at a global scale

Jul 21, 2023 By Gina Lopez In Grafana

According to the World Bank, two-thirds of adults around the globe currently make or receive digital payments. Businesses have come to expect quick, reliable processing, and one company at the forefront of that is Worldline. The global payment service provider (PSP) is a leading payment processor and payment provider in Europe, with about 3.4 billion e-commerce transactions made in 2022.

Read Post
atatus

Relational Databases: Exploring Indexes and Transactions

Jul 21, 2023 By Aiswarya S In Atatus

Indexes serve as the key to unlocking the immense potential of relational databases, enabling swift and optimized data access. They act as a roadmap, allowing the database engine to locate specific data quickly, ultimately enhancing query performance. Understanding the nuances of indexes and employing the appropriate indexing techniques can significantly impact the efficiency of a database system.

Read Post
redgate

The promise - and the perils - of GitHub Copilot

Jul 20, 2023 By Matt Hilbert In Redgate
There’s been a lot of talk about GitHub Copilot recently, loudly touted as Your AI pair programmer. According to GitHub, Copilot for Business brings the power of generative AI to engineering teams, accelerating the speed of software development and innovation. At the back end is OpenAI Codex, a modified version of the GPT-3 Large Language Model (LLM) used in ChatGPT. At the front end it integrates with code editors like Visual Studio and JetBrains to automatically generate code.
Read Post

Creating Databases, Schemas, and Tables on pgAdmin

Jul 20, 2023 By Aiven In Aiven
In this tutorial, we'll walk you through the process of creating databases, schemas, and tables on pgAdmin, a powerful GUI tool for managing PostgreSQL databases. Whether you're new to pgAdmin or seeking to enhance your database administration skills, this video provides a comprehensive guide to efficiently create and organize your database structures. We'll also highlight the seamless integration of pgAdmin with Aiven's PostgreSQL service, enabling you to leverage Aiven's reliable and scalable infrastructure while utilizing pgAdmin's intuitive interface.
View Video
opsmatters

What is Database Administration?

Jul 19, 2023 By OpsMatters In OpsMatters
In today's digital age, data has become the lifeblood of businesses and organizations. With the exponential growth of data, the need for efficient and secure management has become paramount. This is where database administration comes into play. Database administration is a crucial role in ensuring the smooth operation and maintenance of databases. It involves a wide range of tasks, from designing and implementing databases to monitoring and optimizing their performance.
Read Post

Deploy Testing Environments with Production-Like Data using Bunnyshell and Neon Serverless Postgres

Jul 19, 2023 By Bunnyshell In Bunnyshell
In this webinar we explored the power of Bunnyshell and Neon in deploying production-like testing environments. Bunnyshell, an Environment as a Service platform, enables developers to instantly spin up ephemeral environments on Kubernetes. Neon provides a fully managed multi-cloud Postgres with a generous free tier, making it easy to launch serverless Postgres with a single command.
View Video

Copyright © 2024 OpsMatters™. All rights reserved.