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.

NHibernate vs Entity Framework Core: Which ORM Is Right for You?

Your ORM choice shapes your app’s performance, scalability, and future growth. Pick the right one, and your app runs smoothly, scales with ease, and handles complex queries without breaking a sweat. Pick the wrong one, and you’re in for a world of late-night debugging sessions you didn’t sign up for. For most.NET developers, the decision often comes down to NHibernate vs Entity Framework Core (EF Core).

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.