Delayed durability was announced late in the SQL Server 2014 development cycle, but offers something that many SQL Server professionals have wanted for years—the ability to disable transaction logging ...

Distributed transactions are one of the more powerful and important functions within SQL Server. A distributed transaction is just like any other transaction within the SQL Server database, with a ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Dany Lepage discusses the architectural ...

SQL Server 在医疗、海关、政务、制造等领域用得深，国产化替代过程中有它独特的技术难点。这些难点的根源，不是因为 SQL Server 的功能有多复杂，而是因为很多开发者已经习惯了它那些"非标准但好用"的特性。迁移的时候，要兼顾两件事：让数据库换掉，让开发者不用改习惯。 金仓数据库 KingbaseES 的 SQL Server 兼容产品化版本就是为了解决这个问题上线的。 GO 批处理、无 ...