Responsive Web Design

For me, Responsive Web Design is a relatively new term.  Basically it refers to a web design layout that alters to it's environment.  So the layout can alter depending on the screen size or resolution. This is not the same as a fluid design though, with Responsive Design the lay can actually change rather than just scale down.

A List Apart has a fantastic article on Response Web Design

I really like the idea of Responsive Web Design but it does seem a lot of effort, so I intent to start messing around with some CSS frameworks that embrace it.

Read rest of entry

Free eBook for Web Designers: 5 Tips for Better Sites

Webvantas 5 tips for better sites:

1. Draw the line between design and implementation
2. Think in terms of information architecture
3. Pick the best CMS for your needs
4. Know What jQuery Can Do for You
5. Drive traffic with SEO and social media

Free eBook for Web Designers: 5 Tips for Better Sites

A good set of guidlines which may seem obvious but are often overlooked, especially once development has begun. Many times development projects go astray because developers "cannot see the wood for the trees". I participially like tip 3 but would not limit it to the CMS, choose the right tool for job period.

Read rest of entry

SQL: Format Dates with DATENAME()

DATNAME() is an ANSI compliant, fast date part function built into SQL Server.

It accepts two arguments datepart and date. The datepart parameter specifies which part of the date to return - day, month, year with the function returning an nvarchar.

Syntax

DATENAME ( datepart ,date)

Example

SELECT DATENAME(m, GETDATE())

Result

January

http://msdn.microsoft.com/en-us/library/ms174395(v=sql.90).aspx

Read rest of entry

Capitalise first letters in SQL Server

SQL Server has no built in function to capitalise the first letter of each word in a string.  The function outlined below will do just that.

This function has proved very valuable!

Source: http://www.sql-server-helper.com/functions/initcap.aspx

Read rest of entry