Additional Articles


Technical Article

Transaction locking and row versioning guide

In any database, mismanagement of transactions often leads to contention and performance problems in systems that have many users. As the number of users that access the data increases, it becomes important to have applications that use transactions efficiently. This guide describes the locking and row versioning mechanisms the SQL Server Database Engine uses to ensure the physical integrity of each transaction and provides information on how applications can control transactions efficiently.

2022-10-05

External Article

Redgate Summit: The Database DevOps Transformation

Digital transformation and data modernization are frequently cited as high-value strategic projects that are crucial to achieving competitive advantage. At the same time, delivery of code in agile and predictable ways has led to many businesses adopting DevOps practices. Throughout this event we will explore how Database DevOps can be the function that accelerates transformation projects.

Join us On October 6th as we invite experts to share their insider tips and tricks.

2022-09-28

Blogs

PGSQL Phriday #001: Two Truths and a Lie

By

As a part of my own journey of learning within PostgreSQL, I’ve decided that...

Daily Coping 7 Oct 2022

By

Today’s coping tip is to be willing to share how you feel and ask...

T-SQL Tuesday #155 –The Dynamic Code Invitation

By

Apologies for the late invitation. A minor snafu has me hosting again. This is...

Read the latest Blogs

Forums

Any reason to use AWS WAF over Cloudflare?

By obalikawa

I'm primarily using Cloudflare for security. I was wondering if AWS WAF is any...

OP identification

By kaj

In lengthy discussions and in developing trial and error scenarios I sometimes find it...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers