When using the asp:UpdatePanel server control for asyncronous communication with the web server the default timeout is 90 seconds. For some processes this may not be long enough. For example, I am currently working on a reporting application and at the »
Ever have to work on a database with a large number of views and you needed to search the content of the objects? Well, here’s a query which will allow you to search inside your view objects: DECLARE @search VARCHAR(1000) SET @search = '[text]' SELECT »
Frustrated by the inability to script SQL Server 2005 objects with BOTH a CREATE and DROP statement? Generally, I write all my scripts with both statements and then save them and include them in source control, so this hasn’t really been a problem for »
Update 2015 Dec 28: It has been brought to my attention that this code has been enhanced by Kyle Finley. You can read about his enhancements here and the source code is available on Github. Kyle has told me he plans to release a NuGet package which I »
The load balancer I wrote last year never made it into full production. While it was still in Q&A we hit our deadline and we stopped new development as we hit our “busy season”. At MaxPreps, once the fall season starts and football is in full swing our »
As I mentioned in my last post I’ve begun investigating the SQL Server CLR. I decided after getting warmed up to commit to an entire series of articles and I’ve just finished the first one on security. I figured it would be the best place to start as »