Category Archives: Microsoft SQL Server

Enforcing Mutex On A SQL Server Database – Part 2

In May I wrote about how application-level mutual exclusivity could easily be implemented on SQL Server by using sp_getapplock and sp_releaseapplock: sp_getapplock tries to get a lock and returns one of a possible set of values which indicate various forms … Continue reading

Posted in .Net, Microsoft SQL Server, Visual C# | Tagged , , , | Leave a comment

Enforcing Mutex On A SQL Server Database

I’ve been working on a project which involved several different components. These components had the potential to interact with a SQL Server database at the same time and  I had to come up with a way of ensuring that each … Continue reading

Posted in Microsoft SQL Server, Visual C# | Tagged , , | 3 Comments

SQL Server: Using Table Aliases In Delete And Update Queries

A couple of posts ago I said that I would blog about counting unique and distinct values using VBA. I promise I will get to that but today I want to talk about the syntax for using tables aliases in … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , | 1 Comment

The Colour of Null

Today was a learning experience. I’ve been working on a project which partly involved tweaking existing tables and stored procedures in a SQL Server database. I performed some tests between dev and production to make sure I hadn’t messed anything up … Continue reading

Posted in Microsoft SQL Server | Tagged , , , , , , , , | 4 Comments