Transaction Isolation Archives - Page 3 of 3 - SQL Authority with Pinal Dave

Two forks, one red, pressing into the last slice of pie at the same moment

Preventing Overbooking When Two Sessions Grab the Last Seat

June 9, 2009

SQL Constraint and Keys, SQL Lock, SQL Server, SQL Transactions, Transaction Isolation

Learn preventing overbooking through a last-seat race, an atomic update, update locks, and a database constraint that rejects oversold inventory.

SQLAuthirty Author Visit - SQL SERVER - User Group Meeting - Ahmedabad - August 30, 2008

SQLAuthority Author Visit – SQL SERVER – User Group Meeting – Ahmedabad – August 30, 2008

September 4, 2008

Pinal Dave

SQL Tips and Tricks

MVP, SQL Scripts, SQL User Group, SQLAuthority Author Visit, Transaction Isolation

At the August 30 Ahmedabad User Group meeting we talked about the quality of programmers and hiring, and why free user groups are great for developers.

A hand turning a red stopcock between two glass flasks

ACID Properties Shown With Real Transactions

March 6, 2008

Pinal Dave

SQL Tips and Tricks

ACID, SQL Server, SQL Transactions, Transaction Isolation

ACID properties shown With Real Transactions uses short SQL Server scripts to explain atomicity, consistency, isolation, and durability.