DaveCorun.com Dave Corun's Free Development Resources and Music

 

SQL Server 2000 Resources

Favorite Links

Microsoft Links
SQL @ Microsoft
MSDN: SQL
SQL Server Express Try out the new desktop SQL Server, as well as the other 2005 products for free.
Cross-Database Ownership Chaining Behavior Changes in SQL Server 2000 Service Pack 3
MSF: Microsoft Solutions Framework How solutions are designed and developed.
MOF: Microsoft Operations Framework How solutions are implemented in the 'real world'
Patterns and Practices

Other Links:
Experts-Exchange.com
Database Journal
SQL-Server-Performance.com
SQL Team.com
CodeProject.com
Google Groups
MSSQLServer.com
SQL Server Version Tracking

Recommended Reading:


MSPress: Code Complete 2nd Ed.

Excellent intro into project management, writing readable code, and much more. Rapid Development at it's best.

The Guru's Guide to Transact-SQL

Brilliant. This book is absolutely brilliant.


The Guru's Guide to SQL Server Stored Procedures, XML, and HTML

Great reference for SQLXML and Stored Procedure Tuning.


The Guru's Guide to SQL Server Architecture and Internals

If you're interested the sick, sick details of how SQL Server actually operates... this book is for you.


Inside SQL Server 2000

Straight from the horse's mouth on how to work w/ SQL Server.


SQL Server Query Performance Tuning Distilled, Second Edition

This book has saved me countless hours of research. It goes into the details of Execution Plans and the Query Optimizer, as well as the SQL Profiler.


Writing Secure Code

Required reading at Microsoft. Save yourself from buffer overrun and SQL injection attacks.

Technology

Below are some useful links, including free training material and curriculums I've developed.

Music