I’ve started investigating the SQL CLR and decided as my first article to tie in a bit to my article on using SQL parameters in ad hoc queries. This time I’m touching on an advanced topic of sql parameters - how to pass an array as a parameter. This takes »
CodeProject.com has several Windows Vista coding competitions running at the moment so I thought I’d throw my hat in and give the Gadgets competition a try. Mostly because they promised a Zune to the top 5 January articles and I didn’t want to wait 3 »
As I look around the net at different articles and tutorials I’m surprised at how many use Dynamic SQL for samples. Even after the many warnings about SQL injection attacks. But there are other issues besides security. One of which is performance - dynamic »
Well after a long absence due to a crazy workload, I’m baaaack! Keepin’ it simple at this point. I’ve resumed studying for MCTS exams and I’ve been reading about dynamic management views. I love them. What’s more, I love the detail they provide and the »
I have been working on a “load balancing” application for OLAP applications and one or two of my previous posts touch on some things I’ve learned in the process. But now that I’ve got a working beta version I’ve decided to write my first “formal” article »
I’ve been pretty busy and haven’t had time to post in a while, but this week I ran into something I thought was worthy of posting. I’m working on writing a “poor man’s” load balancer for our databases. I won’t go into the background this time as I will »