238 reputation
28
bio website
location Rochester, NY
age 37
visits member for 1 year, 8 months
seen 2 days ago
stats profile views 8

I am a professional geek, working in enterprise data systems. I fill the role of systems engineer, architect, developer, project manager, etc... a one-stop enterprise IT kinda guy.

I develop in .NET, MVC, and IIS on Windows platforms; on *nix I favor to develop in PHP with some Cake.

For database systems I favor MSSQL, MySQL, and I'm moving into PostgreSQL for BI/ Warehousing.

Security is near and dear to my heart; a well-designed security system puts a satisfied smile on my face.

Scalability is important to me; planning for the future is one of my greatest strengths.

Thats me! Computer geek extraordinaire!


2d
awarded  Caucus
2d
awarded  Constituent
Feb
24
accepted PostgreSQL 8.4: How to tell if a procedural language is installed or not?
Feb
24
comment PostgreSQL 8.4: How to tell if a procedural language is installed or not?
Thanks; exactly what I was looking for.
Feb
24
asked PostgreSQL 8.4: How to tell if a procedural language is installed or not?
Jan
19
awarded  Yearling
Jan
14
awarded  Popular Question
Dec
7
comment How do I set and get custom database variables?
Thanks for the info.
Dec
7
accepted How do I set and get custom database variables?
Dec
7
comment How do I set and get custom database variables?
Hmmm. No way to do that from a SQL query in the database?
Dec
7
asked How do I set and get custom database variables?
Dec
6
awarded  Commentator
Dec
6
comment How to determine the collation of a table in PostgreSQL?
Thanks, that helped a lot.
Dec
6
accepted How to determine the collation of a table in PostgreSQL?
Dec
6
comment How to determine the collation of a table in PostgreSQL?
Hmm... and how can I tell what the default collation is?
Dec
6
asked How to determine the collation of a table in PostgreSQL?
Sep
7
awarded  Teacher
Sep
7
comment How to search a MySQL database with encrypted fields
@KenWhite, well, the meaning was clear to me, and apparently to most other people as well. It could have been worded better, but I do think you're being overly critical.
Sep
7
comment How to search a MySQL database with encrypted fields
Searching on the actual encrypted text would be a painful, inefficient experience; I think that the OP recognized this and was looking for a means to efficiently query protected data.
Sep
7
comment How to search a MySQL database with encrypted fields
you could probably extend this by making a "full text" index of hashes, if you needed to, but it could get complicated really fast.