Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

Elasticsearch vs MongoDB - Battle of Search and Store

Elasticsearch is primarily a search engine optimized for fast, complex search queries, especially text searches, and is often used for log and event data analysis. MongoDB, on the other hand, is a general-purpose, document-oriented database that excels in storing and retrieving structured and semi-structured data. It is commonly used for mobile, social, and IoT applications. While Elasticsearch provides superior search capabilities, MongoDB offers more robust data processing and storage features.

Visualize CockroachDB in Grafana: Introducing the CockroachDB Enterprise data source

We’re excited to announce the addition of CockroachDB as an Enterprise data source for Grafana. The data source, available now in private preview, enables secure and seamless access to the CockroachDB distributed SQL database, while leveraging Grafana’s powerful visualization capabilities.

Fetch Zoho Books Data in a .NET Application

Zoho Books is an online accounting software that helps you manage finance, automate business workflows, and streamline collaboration across departments. Integration of Zoho Books data into a.NET application can be extremely beneficial when handling large amounts of data. This approach provides a simplified reporting method, saving your team’s time Fetching data from Zoho Books to an external application can enhance data analysis, reporting, and integration with other business processes.

Connecting to Shopify With Devart ODBC: A Guide to Data Analysis Using Power BI

Choosing the Devart ODBC Driver for Shopify enhances your ability to conduct in-depth data analysis and improves the integration process, offering a dependable and efficient connection to your Shopify data. In this article, we’ll demonstrate how to use the Devart ODBC Driver to connect to your Shopify database, followed by utilizing Power BI for data analysis.

How to Connect to a Remote Oracle Database With the Devart ODBC Driver Using HTTP/HTTPS Tunnel

When there is no Oracle DBA on the development team, connecting to a new remotely hosted Oracle database can present several challenges. These include dependency on the Oracle database version, limitations specific to Oracle databases, and certain customization restrictions. However, despite these obstacles, it is still possible to manage the task without any prior experience by using the ODBC Driver for Oracle from Devart.

Understanding SQL Server Triggers

In SQL, triggers allow developers to automate actions based on events within the database, such as INSERT, UPDATE, or DELETE operations. They can also be useful for maintaining database integrity and maintaining code accuracy. Still, you should be careful when using them since they may impact database performance. In this article, we’ll make a brief overview of SQL triggers and events that can initiate them.

Unlock Sybase ASE performance: Transform monitoring metrics into actionable insights

Sybase Adaptive Server Enterprise (ASE) is a robust solution for handling critical business operations. To keep it running at peak performance, it's essential to monitor it continuously and collect a range of performance metrics. These metrics provide detailed insights into various aspects of the server’s health, including connection times, memory usage, cache efficiency, transaction management, and database health.

Haley Wang - VictoriaMetrics At KubeCon China 2024

Haley Wang, a software engineer at VictoriaMetrics, presented at KubeCon China 2024 on August 22nd, 2024! In her talk, "Building a High-Performance Time Series #Database from Scratch: Optimization Strategies," Haley shared valuable insights and strategies for optimizing time series databases.

Enhancing Marketing Analytics: A Comprehensive Guide to Connecting HubSpot and Power BI

Understanding the nuances of marketing data is no longer a luxury but a strategic necessity; and this is where the fusion of two powerful tools, HubSpot and Power BI, takes center stage, offering an integration that transforms raw data into meaningful intelligence.

Simple Talks Podcast | Episode 5 - SQL Server and Postgres

Steve, Grant and Ryan return to Simple Talks to discuss SQL Server and Postgres. The advocates share their experiences with both systems, highlighting what works and what doesn’t. From time series and Query Store to extended events, tooling and log shipping - this is a quick-fire deep dive into the pros, cons and differences between the two. There’s also conversation around making the transition from one system to the other, and Ryan reflects on his challenging introduction to Postgres…on the first day of a new job.