SQL Server development work consists of considerably more than creating schemas and writing T/SQL code. Around this there has to be reliable source control, organised testing requires a managed release cycle and documentation needs to be created in synch with solution development.
Through the versions of SQL Server from 6.5 to 7 to 2000 to 2005, and now going on to 2008, the T/SQL language and SQL Server product have progressed to become a rich and flexible development environment. However, T/SQL is closer to a functional language than the more common procedural languages and a particular mentality is required to reach a truly productive fluency. Great code, aside from being efficient, isn't fancy or clever, it is clean, clear, consistent, readable and maintainable.