Recently I encountered a problem in a stored procedure that was caused by an unexpected result from the SQL Server ISNUMERIC() function. I was using SQL Server 2008 R2 but the issue has long been ...

SQL Server CLR that implements hashing for 4 different algorithms that does not have SQL Server's 8000 byte input limitation. This project also includes a function that uses both the HASHBYTES() ...

This is demo code how messages can be sent from Microsoft SQL Server (2005+) to a RabbitMQ message broker. The way it is implemented is by using SQLCLR, .NET running inside the SQL Server engine ...

T-SQL is great for database code, but writing procedural code in T-SQL has always been difficult. Invariably, your project includes a stored procedure or two, requiring some text parsing or complex ...

SQL Server 2005&'s new integrated Visual Studio features allow solution providers, who write lines of business applications, to be more productive by giving them faster access to data and more ...