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.

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.

If you're a Microsoft shop, it is a given that you have loads of SQL databases lying around with critical data in them. SquaredUp lets you connect to your SQL database and run SQL queries on the database to fetch data and build dashboards with it. Let's see how.

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).

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.

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?

SQL Server DROP INDEX is a command you’ll find yourself using regularly as you manage and optimize your databases. Indexes are important for performance, but they’re not a “set it and forget it” kind of thing. Sometimes, an index becomes obsolete, redundant, or even detrimental. That’s when you need to know how to use the DROP INDEX SQL statement effectively.

The SQL Server GETDATE() function grabs the current date and time of the server down to the millisecond. This makes it perfect for general timestamping, logging events, and simple date/time math. But what about time zones or when you need a rock-solid, consistent timestamp? Is GETDATE() enough, or do you need something else, like CURRENT_TIMESTAMP? In this article, we’ll show you how and when to use GETDATE() in SQL.

Dealing with different data sources without efficient data integration tools turns valuable information into a liability. These solutions give you a unified view of your data, eliminating silos and ensuring data consistency, accuracy, and accessibility. But, where do you start? Navigating the 2025 data integration market, with the shift towards scalable cloud platforms, self-service integrations, and AI automation, can be tough.

SQL Server data types are the foundation upon which your entire database structure rests. They define the kind of data you can store in each column, from simple integers and text strings to complex date/time values and binary data. Picking the right SQL data type means your data is stored efficiently, queries run fast, and your information stays accurate. Using an overly large data type wastes space and slows things down, while using a too small type risks data loss or errors.