In tsql when running stored procedures you may wish to output debug statements. The problem is that in a long running tsql the “Print” statements […]
SQL Server Print logging message function
I use this to log duration information when I am writing stored procedures with long running code.I find this useful when testing how long things […]
SQL Server Performance Testing
When attempting to assess the performance of a given script on SQL Server it is quite difficult. The caching of execution plans etc etc, lead […]
Reporting Service 2008 Install – “Input String was not in a correct format.”
I got this error the other day whilst trying to install Reporting services. After much digging I found this blog entry that fixed it: http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/c9cb944d-6264-4530-9e00-ee92da3e939f/ […]
Deploy reporting services web parts (RSWebParts) to SharePoint 2010
I had to do this the other day and here are the short and curlies of doing it. If you have SQL 2008 installed the […]
Windows form Label Control Autosize and wrap text vertically
The other day I was trying to get a label control to autosize vertically and struggled to do it… but there is a simple trick… […]
XP – MouseMove Event fired repeatedly by File Search Animation
This is a bug with windows XP, caused by the dog animation, that appears by default when you perform a file search. I had a standard […]
Case Sensitive T-SQL (TSQL) variables
I had an interesting problem the other day. Someone ran a sql script I had written on their SQL2005 database and it threw an error […]
SQL 2005 Unpivot Query
The other day I had need to use an unpivot query in SQL 2005. Thought it was really cool so here it is… Assume you […]
List<object> Find with delegate
Thought this was really cool. I have a generic List of objects, for example: [csharp]List<User> users = GetAllUsers();[/csharp] I want to find a user by […]