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

Microsoft announces new cybersecurity AI multi-model

By

Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...

Getting the SQL Server MCP Server Running

By

If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...

Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations

By

Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...

Read the latest Blogs

Forums

ALAMAT KONTAK BCA KCP Alaydrus Telp:08218154392

By Layanan_BCA_24jam

WA CS (08218154392) Jl. Alaydrus No.47 & 47 A, RT.8/RW.2, Petojo Utara, Kecamatan Gambir,...

ALAMAT BCA KCU RAWAMANGUN Telp:08218154392

By Layanan_24jam

WA CS (08218154392) Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...

Alamat Kantor BCA KCU City Tower Telp:08218200233

By layanan_Bca88

Wa:628218200233 Alamat. Jl. M.H. Thamrin No.81 Ground Floor, RT.1/RW.6, Dukuh Atas, Menteng, Kec. Menteng,...

Visit the forum

Question of the Day

Symmetric Key Encryption

If I run this statement in SQL Server 2025, how is the password encrypted? 

CREATE SYMMETRIC KEY MySymmetricKey
WITH ALGORITHM = AES_256,
KEY_SOURCE = 'My secret key source passphrase',
IDENTITY_VALUE = 'My secret identity value'
ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7';
GO

See possible answers