Give your SQL Strings Names!
This is such a useful debugging practice I had to share it. How often have you come to debug a problem and had to resort to SQL Tracing to pinpoint the problem, or had to use SQL’s Activity Monitor to…
Category Development
Making WCF-SQL Send Port work with Stored Procedure
[Disclaimer: I’m learning BizTalk the hard way – without a training course and with an impending deadline. These are my learnings, notes and reminders. If you find them useful, hurrah. If not, I doubt I can help you. This might…
Getting your SQL Backup Models right
[this was an email I just sent to the IT Team I work with] People of the development world, When creating databases on the SageServer (or anywhere for that matter), please consider your recovery models. Hereâs a simple decision tree:…
Sackboy Thermometer
This is a bit geeky, but I had a plastic Sackboy, an LCD display, a thermometer chip and a Arduino board lying around, so I thought I’d combine them to highlight my sad and stuffy office situation: 26.5 degrees! And…
Reporting Services: Achieving Text Flow with Columns
In a previous post I described how to create a Table of Contents for various sections of your report, to make it easier to navigate. One of the issues with the Index I created was that it was quite long.…