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 4
Learn to leverage the power of the cloud with your existing web applications.
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.
This article was written mainly for developers who use Firebird Embedded SQL Server in .Net framework applications and want to speed up or optimize DB queries. We will describe how to create your own native Firebird extension and show some approaches how to use it in managed code applications.
Sometimes when you have all kinds of data what you really need is XML. LINQ to XML let's you employ functional construction to convert your data into XML.
Latest CodeGuru Developer Columns
Here, the proverbial rubber meets the road. Finish this project and create a working magnifier.
Create your own mouse maze game. Examples are both in C# and VB.NET.
Discover the world of Portable Class Libraries (PCLs) and how they can work for you.