Just cost myself a few hours on this one. I have recently installed the 2008 R2 Nov CTP, I also have RS reports that use […]
Canon CameraWindow and Windows 7
After upgrading to windows 7 my camera software refused to work. I did a lot of searching and even emailed Canon and got a really […]
Textbox – supress previous entries – auto complete off
Hi, I am developing a website and noticed that all my text boxes were repeating the content that had been entered previously. Found this blog […]
SQL Server Date Format – Convert to varchar
Below is a nice little script to output the various formats displayed by sql server when using convert(varchar, getdate(), n). It just outputs the current […]
SQL Server Reporting Services (SSRS) – IIF statement divide by zero error
If you use the IIF statement to solve your divide by zero errors, you will most likely find that you still get divide by zero […]
SQL Server Reporting Services – Access textbox value in expression
If you need to progamatically access a control on your report then use the following expression [csharp]ReportItems!textbox1.Value[/csharp]
SQL Server Print Logging in TSQL / Stored Procedures
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/ […]