Sunday, May 24, 2009

Clixpy


Clixpy is a web usability testing tool. It’s very easy to install, just by pasting a few lines of JavaScript code in your site’s HTML. When users browse your website Clixpy traces everything they do and then plays it for you, giving you the opportunity to extract any information you may need.

Seth Godin:Tribes



Seth Godin argues the Internet has ended mass marketing and revived a human social unit from the distant past: tribes. Founded on shared ideas and values, tribes give ordinary people the power to lead and make big change. He urges us to do so.

Monday, May 4, 2009

Video: Learning from StackOverflow.com

Presented by Joel Spolsky, known for Fog Creek and his blog JoelOnSoftware.com.



YouTube Description:
Until recently, searching for help on highly technical programming problems has been a mess. A lot of what the search engines found was old discussions in forums, where you have a lot of wrong answers and out-of-date answers that you have to sift through yourself. You also found a lot of answers at sites that were hidden behind a pay wall, which uncloaked themselves for Google and then demanded membership fees to see the answers. More
The 9 issues mentioned in video:
  1. Voting: Override by best solution
  2. Tags: Smart tags, what you can maybe answer
  3. Editing: Edit your own and other people's entries
  4. Badges: No money, status
  5. Karma: No money, status
  6. Pre-search: Previously asked questions
  7. Google is UI: Google search important traffic source
  8. Performance: ASP.NET, C#, Jquery, Sql Server, Dell
  9. Critical Mass: "Empty restaurant syndrome"

Video: Don Norman: The Design of Future Things

In this talk, Don discusses his latest book, The Design of Future Things, which is about the increasing intrusion of intelligent devices in the automobile and home with both expected benefits and unexpected dangers.

Cool Presentation Template (Google Docs)

Cool presentation template, embedded from Google Docs (Get started, create your own)

A Few Good Resources on "Search"

Faceted search enables users to navigate a multi-dimensional information space by combining text search with a progressive narrowing of choices in each dimension.

http://en.wikipedia.org/wiki/Faceted_search



Flickr: Faceted Navigation











Yahoo Design Pattern Library

UI design patterns: What the user wants to accomplish, and when to use each pattern.

SEARCH
Search Pagination

NAVIGATION
Breadcrumbs
Links
Alphanumeric Filter Links
Tabs
Module Tabs
Navigation Tabs

BROWSING
Page Grids
Pagination
Item Pagination
Search Pagination

SELECTION
Auto Complete
Calendar Picker
Carousel

RICH INTERACTION
Drag and Drop
Drag and Drop Modules
Invitation
Cursor Invitation
Drop Invitation
Tool Tip Invitation
Hover Invitation
Transition
Animate
Brighten
Collapse
Cross Fade
Dim
Expand
Fade In
Fade Out
Self-Healing
Slide
Spotlight

SOCIAL
Ratings & Reviews
Architecture of a Review
Rating an Object
Vote to Promote
Writing a Review
Reputation
Competitive Spectrum
Named Levels
Numbered Levels
Identifying Labels
Points
Collectible Achievements
Ranking
Leaderboard
Top X
Sign-in Continuity

Sunday, May 3, 2009

How to create tabs with jQuery UI

Tabs are a space saver that are welcome on almost any site. This how-to shows you step-by-step how to quickly integrate them into your site using the jQuery UI.

Full article: http://tanguay.info/web/index.php?pg=howtos&id=21

Saturday, May 2, 2009

The Future of C#

Anders Hejlsberg is a Technical Fellow in the Developer Division. He is an influential creator of development tools and programming languages. He is the chief designer of the C# programming language and a key participant in the development of the Microsoft .NET framework.
http://channel9.msdn.com/pdc2008/TL16/

Google Documents List Data API

The Google Documents List Data API allows client applications to upload documents to Google Documents and list them in the form of Google Data API ("GData") feeds. Your client application can request a list of a user's documents, and query the content in an existing document.

Find Tables With Foreign Key Constraint in Database

SELECT f.name AS ForeignKey,
OBJECT_NAME(f.parent_object_id) AS TableName,
COL_NAME(fc.parent_object_id,
fc.parent_column_id) AS ColumnName,
OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName,
COL_NAME(fc.referenced_object_id,
fc.referenced_column_id) AS ReferenceColumnName
FROM sys.foreign_keys AS f
INNER JOIN sys.foreign_key_columns AS fc
ON f.OBJECT_ID = fc.constraint_object_id

/*** Script all Foreign Key Constraints ***/
/*** The Result Set can be used to copy constraints to your testing DB or to keep on hand in case of errors. ***/
SELECT
‘ALTER TABLE ‘+FK.TABLE_NAME+
‘ ADD CONSTRAINT ‘+C.CONSTRAINT_NAME+’ FOREIGN KEY’+
‘(’+CU.COLUMN_NAME+’) ‘+
‘REFERENCES ‘+PK.TABLE_NAME+
‘(’+PT.COLUMN_NAME+’)’ ForeignKeyScripts
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME
INNER JOIN (
SELECT i1.TABLE_NAME, i2.COLUMN_NAME
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS i1
INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2 ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME
WHERE i1.CONSTRAINT_TYPE = ‘PRIMARY KEY’
) PT ON PT.TABLE_NAME = PK.TABLE_NAME
–WHERE PK.TABLE_NAME IN (’Table1′, ‘Table2′)
–WHERE FK.TABLE_NAME IN (’Table1′, ‘Table2′)


Friday, May 1, 2009

Microsoft .NET Framework 3.5 Commonly Used Types and Namespaces

This poster shows the commonly used types and namespaces in the 3.5 Framework, including WPF, Windows Forms, ASP.NET, Communications/Workflow, Data, XML, LINQ and Fundamentals.

The poster also shows what's new with the .NET Framework 3.5 and .NET Framework 3.0, what's available in the .NET Compact Framework 3.5 and what's planned for implementaiton in Silverlight 1.1.

Format is 90 x 70 cm, so it's best suited for printing and not reading on your laptop.

Download (via Microsoft.com)

Poster is created by Paul Andrew , Kit George and Brad Abram.

Source: Paul Andrew