Samsung Galaxy S2

This is the phone I really want:

CNET
PhoneArena

It really makes me happy thinking about it. It's been available since April but not in the U.S. Supposedly it will come out this August just ahead of the next iPhone announcement. A buddy at work bought the European version without contract for a lot of $$$. I can't justify doing that so I have until AT&T releases an American version with contract. I really should get over my tech porn problem.

Does anybody have this phone or seen others with it? Any impressions?

Fall 2011 Utah Code Camp

I'm planning on attending this fall's Utah Code Camp. It will be my first time attending but I have heard great things about it. Best part is that it's free.


http://utahcodecamp.com/

Query Trigger

I had a need recently to programattically query the triggers for a set of tables in my database. Here's the code that I used:

 SELECT DISTINCT
 Tables.Name TableName
, Triggers.name TriggerName
, Triggers.crdate TriggerCreatedDate
, [Type] = CASE WHEN Triggers.xtype = 'TR' THEN 'SQL Trigger'
        ELSE 'CLR Trigger'
      END 
, [Disabled] = OBJECTPROPERTY(OBJECT_ID(Triggers.name), 'ExecIsTriggerDisabled')
FROM
 sysobjects Triggers
INNER JOIN sysobjects Tables
 ON Triggers.parent_obj = Tables.id
   AND Tables.xtype = 'U'
   AND Tables.name = 'eperson'
LEFT JOIN syscomments Comments
 ON Triggers.id = Comments.id
WHERE
 Triggers.xtype IN ( 'TR', 'TA' )
ORDER BY
 Tables.Name
, Triggers.name

Updated the above query to handle CLR triggers and to show if the trigger is disabled.

Regular Expression Editor/Helper

I’ve been using Expresso for a while now. It’s a handy tool for working with regular expressions. It has a library of regular expressions which is very helpful. The editor lets you try your regular expression against a whole bunch of test data so you can test your expression against all sorts of data. The tool has been key in my getting better at regular expressions. The best part is that it’s FREE. That just makes me feel so good.

http://www.ultrapico.com/Expresso.htm

Wow, Two Years

Wow, it's been two years since my last post. I think I've been recovering from my masters degree. I'm now feeling more inclined to get involved with the blog again, if anybody cares. I expect to start posting again. My current job has me doing more and more SQL projects so my posts will be more focused to that. Besides, we're still on .NET 3.5 and really need to get up-to-date on .NET 4.0 before I start posting .NET again. So embarrassing :D