Good database design is extremely important if you want to have a database that performs well and is easily modifiable.

How many times did you have to go back and change countless lines of code because your database was not normalized and it was not easy to add another payment type to the existing database?

This is where Pro SQL Server 2008 Relational Database Design and Implementation comes in; in the first couple o...

Review of MCTS Self-Paced Training Kit (Exam 70-502): Microsoft .NET Framework 3.5 Windows Presentation Foundation

Written by Matthew A. Stoecker

This book has 524 pages

The reason I read exam preparation books is to learn things about the product which you would otherwise learn the hard way, you might have introduced bugs because you didn’t know why certain things worked the way they did. Taking the prep...

SQL performance tuning is probably one of those things you can do to really make a HUGE difference in performance. Let’s put this in perspective: take a typical application, if you can improve the performance by 100% then you really made a huge improvement. You can improve a SQL query by 1000% with 2 lines of code (sometimes all you have to do is take away a % sign). If you can make a query sargable so that the optimizer can do an index seek instead of an index scan your query might go from 12 seconds to 200 milliseconds. Now try doing that in an application, even if you change all th...