Pro SQL Server 2005 Database Design and Optimization

Pro SQL Server 2005 Database Design and Optimization will teach you effective strategies for designing proper databases. It covers everything from how to gather business requirements to logical data modeling and normalization. It then shows you how to implement your design on SQL Server 2005.

The authors also describe how to optimize and secure access to this data, covering indexing strategies, SQL design and optimization, and strategies for increased scalability to support large numbers of concurrent users. They provide in-depth advice on optimal code distribution in SQL Server 2005 applications, in the wake of innovations to be able to use .NET code in the database itself. This essential book will ensure that projects have a well-designed database and secure, optimized data access strategies right from the start.

Pro SQL Server 2005 Database Design and Optimization will teach you effective strategies for designing proper databases. It covers everything from how to gather business requirements to logical data modeling and normalization. It then shows you how to implement your design on SQL Server 2005.

The authors also describe how to optimize and secure access to this data, covering indexing strategies, SQL design and optimization, and strategies for increased scalability to support large numbers of concurrent users. They provide in-depth advice on optimal code distribution in SQL Server 2005 applications, in the wake of innovations to be able to use .NET code in the database itself. This essential book will ensure that projects have a well-designed database and secure, optimized data access strategies right from the start.

Louis Davidson has been in the information technology industry for ten years, as a corporate database developer and architect. Currently, he is serving as a Database Administrator for Compass Technology Management in their Nashville Data Center supporting the Christian Broadcasting Network and NorthStar Studios in Nashville, TN.
The majority of his experience, with slight deviations into Visual Basic, has been spent with Microsoft SQL Server from version 1.0 to whatever latest version that is in Beta. Louis' primary areas of expertise are in database architecture and coding in Transact-SQL, and he has written thousands of numerous stored procedures and triggers throughout the years.
Louis was the sole author on Professional SQL Server 2000 Database Design (Wrox, ISBN: 1-86100-476-1), and was a contributor to SQL Server 2000 Stored Procedure Handbook (Wrox, ISBN: 1-86100-825-2). It is said that in his ridiculously small amount of spare time he tends to play a lot of Nintendo as well as watching a great deal of television that was popular in a different era. Most notably old English programs such as the Avengers, The Saint, Monty Python, and Black Adder, to name a few. Quite often this spare time is also spent with his notebook computer writing something pertaining to SQL.