Introduction. Assessment Test. Chapter 1: Designing the Hardware and Software Infrastructure. Chapter 2: Designing Physical Storage. Chapter 3: Designing a Consolidation Strategy. Chapter 4: Designing Database-Level Security. Chapter 5: Designing Windows Server-Level Security Processes. Chapter 6: Designing SQL Server Service-Level Security. Chapter 7: Designing SQL Server Object-Level Security. Chapter 8: Designing a Physical Database. Chapter 9: Creating Database Conventions and Standards. Chapter 10: Designing a SQL Server 2005 Solution for High Availability. Chapter 11: Designing a Data Recovery Solution for a Database. Chapter 12: Designing a Data-Archiving Solution. Glossary. Index.
Steve Jones has been working with SQL Server for more than a decade, starting with v4.2 on OS/2 and enjoying the new features and capabilities of every version since. After working as a DBA and developer for a variety of companies, Steve founded SQLServerCentral.com along with Brian Knight and Andy Warren in 2001. SQLServerCentral.com has grown into a wonderful SQL Server community that provides daily articles and questions on all aspects of SQL Server to over 300,000 members. Starting in 2004, Steve became the full-time editor of the community and ensures it continues to evolve into the best resource possible for SQL Server professionals. Over the last decade, Steve has written more than 200 articles about SQL Server for SQLServerCentral.com, the SQL Server Standard magazine, SQL Server Magazine, and Database Journal. teve has spoken at the PASS Summits where SQLServerCentral.com sponsors an opening reception every year as well as written a prior book for Sybex on SQL Server 2000. David W. Tschanz is the coauthor of the recent Sybex book Mastering SQL Server 2005. He has been working with and managing large datasets for four decades. His work has included analysis of population dynamics, voting behavior, and epidemiological data. He has been writing on computer topics for the past several years, including 4 books and about 100 articles in the area. e is also a regular contributor to Redmond magazine. Dave currently lives outside the United States, where his eclectic nature allows him to pursue projects involving databases, IT infrastructure, web development, archaeology, the ancient Nabataean capital of Petra, medical history, military science, and demography. He can be reached by e-mail at email@example.com, or look for him in Connecticut, Saudi Arabia, or Tasmania, his three favorite haunts.