More SQL Date Time Comparisons

I found an article by Gregory Larsen called Working with SQL Server Date/Time Variables: Part Three - Searching for Particular Date Values and Ranges that helped me with a few different ways of verifying a date range I was trying to make sure included events scheduled for after today's date.

I'm sure there are more elegant ways of doing this, but I wanted to list all "upcoming" events which included events that may have already occured today (but have them fall off the list tomorrow). I went for the FLOOR approach with this code:

SELECT * FROM Events WHERE Event_Date >= CAST(FLOOR(CAST(GETDATE() AS FLOAT)) AS DATETIME)

I've always wished they had a slick date function that would just drop the seconds from a date for ease of comparison. Oh well.

Architectural Roles and Responsibilities

I found a post on Dinesh's Blog regarding architectural roles and responsibilities. I very much like the division and definition of these roles. However, I think the majority of companies combine these architect roles into much more traditional buckets: DBA, chief architect, and an application development manager. In fact, one of the more important roles in today's society, security, is just starting to get a more visible and political influence in organizations. It isn't that I don't agree that these roles should be identified and recognized, I just think it would be very common to see a name listed on several role definitions.