Operations | Monitoring | ITSM | DevOps | Cloud

The latest News and Information on Databases and related technologies.

High Cardinality Is Eating Your Storage Budget-Here's Why

Have you noticed your storage costs rising even when you're keeping an eye on them? The reason might be something easy to overlook: high cardinality data. For data engineers and developers balancing performance and costs, understanding its impact isn’t just useful—it’s key to avoiding unnecessary spending and system slowdowns.

Top 10 performance issues in PostgreSQL and how to fix them

PostgreSQL is a powerful and widely used relational database, but like any system, it can suffer from performance bottlenecks. Without proper management, slow queries, inefficient indexing, and resource contention can lead to sluggish performance. In this blog, we will explore the top 10 PostgreSQL performance issues and how to fix them.

How to Make the Most of Redis Pipeline

If you’ve been using Redis but haven’t explored pipelining, you’re missing out on some significant performance benefits. Redis pipelining is like a hidden gem—those who know about it can’t imagine working without it. In this guide, we’ll break down why pipelining is important and how it can help improve the efficiency of your applications.

New in SSIS Data Flow Components 3.1: Optimized Performance & Expanded API Support

We are thrilled to announce a major release of our SSIS Data Flow Components, powerful tools designed to simplify the ETL process within SQL Server Integration Services (SSIS) packages. This update brings significant enhancements, including improved performance, support for new server versions and APIs, and the addition of new objects and properties to existing components.

How to Use SQL Server SUBSTRING Function

If you’ve ever worked with SQL Server databases, you know how vital string manipulation is to day-to-day workflows. Whether extracting specific details, reformatting text, or cleaning up inconsistent data, having the right tools isn’t just helpful—it’s essential. That’s where the SUBSTRING() function comes in. It’s one of the foundational tools for handling text in SQL Server, allowing you to isolate specific parts of a string with precision and ease.

Top SQL Data Tools: Alternatives to SQL Server Data Tools (SSDT)

SQL Server Data Tools (SSDT) has long been the default for SQL Server development, but is it still enough? As modern databases become more diverse, SSDT’s rigid focus on SQL Server, lack of advanced performance tools, and limited cross-platform support leave many teams struggling. If your database needs are growing beyond SQL Server—or you want more automation, performance optimization, and flexibility—you’ll need an upgrade. So, what’s replacing SSDT?