I have no words for how bad this is

I think this should win the “Most Horrible Sproc Parameters” contest if there were such a thing. And then people wonder why I get mad when I see stuff like this. Just wow… Like I...

How to use Excel and tSQL to help you Generate Code

Introduction It’s amazing to me the reactions I get when I show people seemingly simple tricks on how to automate or generate code and/or script generation. Whenever I see a pattern, that means there is...

TSQL: Passing objects to stored procedures via XML

Introduction This is a subject I have heard about repeatedly, but I never bothered looking into it until recently. I was told that writing hard coded insert and update statements is bad practice. To which...

Dyslexic Apps Updated

I have updated the Dyslexic Apps page with all of the software that I have available on google code. Compiled version of the executables and/or installers are available via drop box. Check it out here

Recycle Application Pool using WMI via Powershell

Introduction I handle the builds for a particular piece of software at my place of work. I am responsible for deploying any new versions of code to all environments; including but not limited to: Development...