Relational databases are designed for multiple simultaneous users, and Microsoft SQL Server is no different. However, supporting multiple users requires some form of concurrency control, which in SQL Server's case means transaction isolation and locking. Read on to learn how SQL Server 2008 implements locking.
Latest Database Articles - Page 2
Learn how to use Microsoft's .NET Entity Framework to connect to, consume and update an Advantage database.
Do you need to create Dynamic Where Clauses at runtime? No need to use string concatenation with SQL, LINQ is fully capable of performing the same task.
Learn how to use SQL Modeling Services to hunt for interdependencies without having to access source code.
In today's column we'll demonstrate how and when to use the new TSQL MERGE statement and how this can be a helpful addition to your toolbox.
Learn how to define policies and use them to better manage your SQL Server 2008 instances.
Latest CodeGuru Developer Columns
Learn to implement exception handling mechanism in C++.
Bots are rapidly replacing the older technologies. Read through and become proficient with Bing Bots.
Learn how to insert, add, and remove items from Listboxes, ComboBoxes, CheckedListBoxes, ListViews, and TreeViews.
When building Virtual Reality user experience (VR UX), here are seven tips you should consider.