December 2003 Blog Posts

Using CLR to call an encryption routine in Yukon

Good article here. I'm posting here as a bookmark for myself, but also so you should check it if you haven't already.

posted @ Sunday, December 21, 2003 8:21 AM | Feedback (0)

Area man blames tools for own lack of knowledge.

Sounds like a headline from The Onion doesn't it ? Something I've mentioned once or twice is my annoyance at people who use the GUI tools that Microsoft supply as an excuse to not know what is actually going along behind the scenes. Then when they hit the brick wall they were heading for by not understanding their toolkit, they rant and rave about how Microsoft is crap, or SQL Server is crap, or HTML is crap, or whatever it is they don't get. This is a perfect example.

posted @ Sunday, December 21, 2003 7:24 AM | Feedback (4)

SQL Server "Yukon" and the CLR

Mike Gunderloy wrote an excellent article introducing the use of CLR code to manipulate data in Yukon. If you are wondering what .NET stored procs are going to look like, check this article out.

posted @ Tuesday, December 16, 2003 6:17 PM | Feedback (1)

don't log on as sa, dummy

Phil Scott gives an excellent rundown on why your application shouldn't use the SA account to log in with. This link might serve you well as a handy page slap next time you see "sa" in a connection string. Not only that, but very cool use of a Spinal Tap reference in the blog. Way to go Phil!

posted @ Thursday, December 11, 2003 6:29 PM | Feedback (1)

More on CodeSmith

A good article at AspAlliance on using CodeSmith for generating database documentation.

posted @ Monday, December 08, 2003 7:38 PM | Feedback (0)