Tools

Blender
A free open source 3D content creation suite.

QAvimator
A free animation editor.

SculptyPaint
A free tool for generating 3D sculpted models for SecondLife.

The Gimp
The GIMP is the GNU Image Manipulation Program, a free alternative to Photoshop

Wood Workshop
A free texture editor that specializes in the creation of seamless wood textures.

General

S.L.O.S.T Second Life Open Source Tutorials
Good tutorials on using some of the open source tools e.g. Blender, The Gimp, SculptyPaint etc.

Mermaid Diaries: Natalia Zelmanov
An enormous collection of building techniques and tutorials - objects, clothes, hair, poses, sculpties etc.

Nicola Escher - Second Life tutorials
Tutorials on creating clothes, tattoos, and even a complete avatar.

Second Life Video Tutorials
The official Second Life Video Tutorials covering all aspects of using and creating in Second Life.

Animation

Qavimator Videos
Qavimator Video Tutorials.

Building

Replicate a Real Life Building
Tutorial: How to Replicate a Real Life Building in Second Life.

Shiny Life Top 10 Second Life Building Tips
Tips for beginner/intermediate Second Life builders.

Ultimate guide to prim twisting
Ayumi Cassini Does Second Life: The ultimate guide to prim twisting

Scripting

LSL Portal - Second Life Wiki
The official LL hosted wiki intended to provide accurate documentation for LSL, the Second Life scripting language. Includes examples and tutorials.

LSL Wiki - Second Life Wiki
The original LSL wiki, still active and provides some useful information not available on the official wiki.

SL Forums - Scripting Tips
The first place to go for any scripting questions.

LSL Particles System script generator
A web based particle system script generator

nand Nerd's Web-Based Particle System Interface
A web based particle system script generator that can directly updated an in-world object for previewing the particle effects

Scripting Recipes for Second Life - Heaton Research
An online book that provides reusable scripts that may be used as fully functioning objects, or as starting points for other projects.

Sculpties

Sculpted Prims - Second Life Wiki
The definitive guide to sculpted prims for SL

Amanda Levitsky - How to Make Sculpted Prims with Blender
How to make a sculpted vase using Blender.

Cailet's page on how to make a sculpted prim.
Sculpted Prims Tutorial using Blender.

Sculpt Blend - Second Life Blender Resources
Tutorials and more for using Blender to make sculpties.

The blender trail
A very good series of video tutorials for using Blender to make sculpties. Starting from installing Blender to advanced techniques.

Textures

CG Textures - The worlds largest free texture site
An awesome collection of free textures that you may use on items that you make and sell, but not free for you to sell the textures on their own or as part of a texture pack.

Texture Tools - Second Life Wiki
Resources to help you texture better in Second Life - Links to tools and tutorials.

Making Seamless Background Tiles
Examples & instructions for creating seamless tiles

Texture Alignment Pattern
A texture alignment pattern and tutorial on using it