Make SQL Server generate SQL for you using SELECT literals

Suppose that I’ve got an instance of SQL server setup for testing, and I’ve programmatically created databases on this instance, but never cleaned them up. This can leave you with hundreds of databases that you’ll never use again, and there’s no reason for them to continue taking up space and cluttering things which you do…

6

Don’t trust user supplied data – Real World Example

Suppose I have a notion of a User Account in my application, and I want to allow 3rd parties to tie that user account to one or more objects in an external directory/authentication system.  Let’s say, for the sake of argument, that I’m going to use System.DirectoryServices.DirectoryEntry to represent links to external directory objects.  I…

0

The feature I just thought of has been there all along..

So I was thinking about something or other today and wanted to refresh my mind on the details of it.  I know that i had visited a site on exactly the topic at hand sometime recently.  This happens pretty often.  I think browser bookmarks are next to useless, as the web seems to 404 itself…

1

Mac OS X – when it doesn’t "just work"

My wife, mother in law, father in law, and sister in law all grew up using Macs.  I grew up using various unix machines.  I had to say that I was excited, if for no other reason than family tech support, to see that OS9 would be leaving our home and theirs and being replaced…

38