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.
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.
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.
The Transactional File System (TxF), which allows access to an NTFS file system to be conducted in a transacted manner through extensions to the Windows SDK API. MFC 10, has been extended to support TxF and related technologies. This support allows existing MFC applications to be easily extended to support kernel transactions.
The original release of the .NET Framework included collections as .NET was introduced to the Microsoft programming world. The .NET Framework 2.0 introduced generics to complement the System.Collections namespace and provide a more efficient and well performing option. Read on to learn more...
The key to working with strings is to know what functions are available. Hannes du Preez shows you 25 of the most common string functions and manipulation techniques .
SignalR is an Asp.Net library that pushes data to a wide variety of clients. The burden of worrying about which server push transport to use and deciding on the fallbacks has been removed from developers. Read on to learn more.
