There are good points being made here. The thought I had was that Einstein and J. Robert Oppenheimer were both were at pains to point out the threat that...

Yeah! A trigger that deletes any sensitive information pertaining to the good folks in the SQL Server Central community would suit just fine. Nobody seems to notice triggers in production...

For production stored procedures, I usually have a section of code that can be switched in or out very quickly that provides debug information. The routine information I need are...

David,

At $5,499.00, a Visual Studio Team System Developer license is going to be minority interest, surely? C# or VB.net developers can use .NET Reflector and Peli's code Metrics...

Thanks for breaking the silence, both of you.

It is difficult to compare SQL with a conventional language. It is like comparing C# to Postscript. Writing SQL gives me more...

I wrote a blog about this on Neil Davidson's "Business of Software" site. Trust underlies all western commerce. There can never be any compromise in this. I...

Remember the advice in 'The C Programming Language by Dennis M. Richie and Brian W. Kernighan'...

I use templates in conjunction with the SQL Prompt and the combination of the two is greater than the sum of the parts.

What SQLPrompt needs is a few more constructs...

Here is a sample of a customised template. There is a type of service table I use whose basic structure is pretty similar. I just delete the bits I don't...

Hmm. Cntrl Shift M. It works on the version of SSMS 2008 I have here, but maybe my version is a bit old (10.0.1600.22 ). I'd be surprised...

Actually, I think I've found a very good use for CLRs, and that is to handle JSON and YAML within a database. you can create a JSON data type...

Oooh. This is getting very useful. I'd missed out on the advantages of passing string parameters as SQLStrings and the trick of passing back a NULL. It makes perfect...

I'd be interested to see if anyone has a solution to the problem of preventing a barf when an invalid path is passed to DirectoryInfo. The obvious idea would...

Yes, Agreed! However, I've recently started using NET Reflector with...

I thought the install script for this CLR routine was nicely done, and very useful. The Asymmetric Key side is so often left out.

I can see why a CLR routine...