Technical Article

INF: Understanding How to Configure a SQL Server Connection Affinity

In an online transaction processing (OLTP) environment, the connection affinity mask option may provide performance enhancement in high-end, enterprise-level SQL Server environments that are running on computers with 16 or more CPUs. In particular, this option is useful when there are a significant number of network interactions (more than 10,000 per second) between the middle-tier application servers and the back-end SQL Server system.

SQLServerCentral Article

Data Warehouse Version Management

In most tables it is enough to have a stored procedure that performs Update Else Insert logic for data managment. However, in some cases we do not want to destroy the old data with an update statement. Instead we want to maintain history up to a certain number of versions. This article presents a method for doing so.

Blogs

DevUp 2025 Recap

By

Had an incredible time at DevUp in St. Louis this weekend! This conference gets...

How AI is Shaping Sustainable Textile Solutions

By

The textile world is undergoing a transformation, one where creativity meets computation, and tradition...

Microsoft Exchange Hybrid Deployment Vulnerability – Shared Service Principal

By

On August 6, 2025, Microsoft announced a vulnerability with hybrid deployments because of a...

Read the latest Blogs

Forums

Everyone Wants a Piece of the AI Pie

By dbakevlar

Comments posted to this topic are about the item Everyone Wants a Piece of...

MongoDB and NodeJS in action

By sabyda

Comments posted to this topic are about the item MongoDB and NodeJS in action

azure vm has to be rebooted more often than we'd like

By stan

Hi we're noticing this 2022 server gets into a funk now and then.   Specifically,...

Visit the forum

Question of the Day

Data recovery from an Index

Is it possible to recover data from a non-clustered index on the firstname and lastname columns in case of corruption?

See possible answers