Category Archives: SQL Server

SqlDependency – Creating a Smarter Cache

I recently got the chance to learn about a technology that has interested me for quite some time: SQL dependencies.  The premise of my encounter with SqlDependency was to create a smarter cache.  The project I’m currently working on was employing a … Continue reading

Posted in SQL Server | Tagged , | Leave a comment

.NET CLR in SQL Server 2005

Of recent interest to me has been the ability to deploy user-defined managed functions, stored procedures, and other objects to SQL from within Visual Studio 2005. With the .NET CLR in SQL Server 2005, these managed functions can be written … Continue reading

Posted in .NET Framework, SQL Server | Tagged , | Leave a comment