Thursday, June 30, 2011

SQL To Find Records That Do Not Have Association

SQL Server Query to determine specific records that do not have a specific association to them:

select distinct documentid, ownername from contenttextpub where documentid in (select distinct documentid from contenttext where contentid in (Select contentid from contentsecuritytag where tagid=(select recordid from tag where referencekey='NULLTAG')))

Feels like recursion, but its more tied to the SQL Query grammer and how the SQL Server interpreter parses the query to get the final query results.

Tuesday, June 28, 2011

Mathematical Proofs and Business Requirements for Product Design

In College I took advanced math classes that taught us about Symmetric, Transitive, and Reflexive Relations. I thought these relations in proofs was not required, but then as we went through different equations I then started to understand the importance of these concepts.

With product development, I think a lot of these concepts should be thought about when designing a product. Because users will always attempt to use your product in ways that you had never imagined. And to attempt to foresee these usages of the product can become cost prohibitive.

Thursday, June 9, 2011

URL link creation

// Create URL link that social media sites can use
String linkUrl = java.net.URLEncoder.encode(request.getScheme() + "://" + request.getServerName()
+ ":" + request.getServerPort() + request.getContextPath() + "/index?"
+ request.getQueryString());