Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Locking Down PostgreSQL with SSL: Secure Remote Connections Like a Pro

PostgreSQL is a beast when it comes to handling data, but if you're running an instance that needs to be accessed remotely, securing it with SSL is non-negotiable. Without SSL, your database connection is essentially an open book for anyone snooping on the network. Let’s lock it down with properly signed certificates!

How To Configure a PostgreSQL Datasource in Grafana

So, you’ve got a PostgreSQL database packed with juicy data, and you want to turn those raw numbers into slick, interactive Grafana dashboards? Good call! Grafana’s PostgreSQL datasource is like the secret handshake that lets you visualize your data in style—no extra ETL magic required. In this guide, we’ll walk through getting PostgreSQL and Grafana to play nice, covering everything from connection settings to query tuning.

Monitor dbt Cloud with Datadog

Data build tool (dbt) is an open source service that cleans, aggregates, and models raw data into organized, analytics-ready formats within a data warehouse. dbt Cloud, a fully managed platform by dbt Labs, extends dbt’s capabilities with advanced features such as scheduling, testing, and monitoring, accessible directly from your browser.

Monitoring database exposure on Kubernetes and VMs

This week, security researchers at Wiz published a report about an internal database at DeepSeek being exposed to the internet. This kind of security risk is surprisingly common and can affect any company. The only way to prevent it is through continuous monitoring. But in modern infrastructures, services can be exposed in many different ways, making detection tricky. At Coroot, we realized that the telemetry data we already collect can help identify these risks — without requiring any extra setup.

How to Configure a SQL Server Linked Server to Connect to MySQL

Looking for simple ways to connect an SQL Server Linked Server to different data sources, such as an external database, its table, or a particular object in MySQL Server? The Linked Server configuration allows you to query data and use DML functions to access these external sources directly within SQL Server Management Studio (SSMS). With such a configuration, you are no longer required to move or duplicate data between different database systems to overcome OS barriers and complexities.

How to Connect MongoDB Using Python Connector From Devart to Perform DML Operations

Many Python developers choose MongoDB for its speed, flexibility, and scalability. This NoSQL database adapts to different types of data, letting you build features regardless of data structure complexity. It’s a natural choice for applications that have to store lots of different information, handle constant changes, or manage large volumes of data. From this tutorial, you’ll learn how to connect MongoDB using Python Connector from Devart to create, read, update, and delete data.

How to Use Data Conversion Tasks in SSIS for Accurate Data Handling

SQL Server integration services is a powerful data integration and workflow platform provided by Microsoft. It can be used to automate data extraction, transformation, and other ETL processes. You can use SSIS to export data from various data sources like flat files, database servers, spreadsheets, etc. Due to these capabilities, SQL Server integration services are widely used in building data warehousing, business intelligence, and database migration tasks.

How to Migrate From SQL Server to Oracle

Database migration involves transferring data, schemas, and other database objects from one database system to another. How can you migrate data from SQL Server to Oracle with minimal disruption and maximum efficiency? In this article, we will explore the key reasons why companies might choose to migrate from SQL Server to Oracle and how to tackle migration challenges. Also, we’ll provide step-by-step guides on how to execute this migration using the following tools.

Inside Perspectives: Database technology - 25 years and beyond

The relational database industry has changed a lot in 25 years. Find out how these changes have impacted the role of a DBA, and the industry as a whole, with Redgate Advocate Kellyn Gorman. Over the past 25 years, the relational database industry has experienced a dramatic transformation. With Oracle, SQL Server, MySQL, and PostgreSQL as foundational technologies, these databases have evolved in response to the emergence of big data, NoSQL, cloud computing, and, most recently, AI.