Listed below is a list of recommended reading that comes from a developer users group, I'm a member of. It has a microsoft leaning towards it because of the focus of the user group, but there's a lot of good design and architecture books listed. I think good sources of ideas should also come from looking at source code of public domain projects similar to what you're doing. Examine how other people did what you're trying to do and see what style, methods, patterns and architecture work for you.
Design Patterns: Elements of Reusable Object-Oriented Software. Gamma,Helm,Johnson,Vlissides.
Code Complete Steve McConnel
Patterns of Enterprise Application Architecture
Anti Patterns
Refactoring: Improving the design of existing code
Refactoring Databases: Evolutionary Database Design
The Mythical Man Month
The pragmatic programmer
Writing Secure Code
Peopleware
Rapid Development
Testing Computer Software
Don’t make me think
Facts and Fallacies of Software Engineering
Dynamics of Software Development
Herding Cats: A primer for Programmers Who Lead Programmers
Software Project Survival Guide
Beautiful Code
A Sane Approach to Database Design
Programming Pearls
Clean Code
Pro LinQ Joseph Rattz, Jr
Professional SQL server Integration services (P to P series)
Pro C# 2008 and the .NET 3.5 Platform Andrew Troelsen
Programming WCF Services Juval Lowy
Software Craftsmanship. McBreen.
XSLT 2.0 Michael Kay
Xquery Priscilla Walmsley.
Inside c# Archer, WhiteChapel
PRO ASP.NET 3.5 in C# 2008 McDonnald Szpusta.
Java in a Nutshell
Beginning Pojos Sam-Bodden.
XPATH 1.0 Michael Kay
Domain-Driven Design: Tackling Complexity in the Heart of Software Eric Evans
Head First: Design Patterns Elisabeth Freeman, Eric Freeman, Bert Bates, Kathy Sierra
Windows Presentation Foundation Unleashed Adam Nathan
The best Software Writing Joel Spolsky
Agile Software Development, Principles, Patterns, and Practices Robert C. Martin
Applying Domain-Driven Design and Patterns: With Examples in C# and .NET Jimmy Nilsson
Why Software Sucks
Code Leader Patrick Cauldwell