Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

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.

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.

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.

How to Install SQLite3 ODBC Driver?

Need a reliable bridge between SQLite and any ODBC-compliant software, such as Excel, Power BI, or programming languages like Python and.NET, to execute SQL queries, retrieve data, and interact with SQLite databases? Devart ODBC driver for SQLite is a software interface that enables applications to interlink with SQLite databases using the universal ODBC standard.

How to Run SSIS Package With Multiple Parameters From a Batch File

Running an SSIS package with multiple parameters from a batch file might sound like a niche skill, but it’s a game-changer for anyone looking to streamline their workflows and enhance efficiency. This approach offers a simple yet powerful way to automate and control complex data integration processes without manually adjusting configurations every time.

Inside Perspectives: What does AI mean for Redgate?

Jeff Foster, Director of Technology & Innovation at Redgate, explains how Redgate is approaching the AI revolution. As we celebrate Redgate’s 25th anniversary, it’s a great time to reflect on how far we’ve come and where we’re headed. Our longstanding mantra has been “ingeniously simple” software – tools that empower users to accomplish tasks they might not have thought possible.