The Handbook for Reluctant Database Administrators

Josef Finsel is a software consultant specializing in .NET and SQL Server. He has published a number of Visual Basic, .NET, and SQL Server-related articles and is the Q&A columnist for asp.netNOW, the e-newsletter for asp.netPRO magazine. When not working for clients, he works out the syntax for FizzBin.net, a programming language that works the way programmers have always suspected a programming language should.

1 Where Did Databases Come From?.- 2 How Do I Install SQL Server?.- 3 How Do I Visually Manage Objects?.- 4 How Do I Back Up and Restore My Data?.- 5 How Do I Define and Structure a Database?.- 6 What Is a View?.- 7 The Power of Indexing.- 8 Introduction to Query Analyzer.- 9 Working with Data: Basic Stored Procedures.- 10 Working with Data: Beyond the Basics.- 11 How Do I Secure My Data?.- 12 How Can SQL Server Agent Make Life Easier?.- 13 If SQL Server 2000 Is a .NET Server, Where’s the XML?.- 14 What Are the Data Transformation Services (DTS)?.- 15 Should I Bother to Learn SQL Profiler?.- 16 What Are System Monitor and Performance Monitor?.- 17 What a Reluctant DBA Needs to Know about .NET.- Last Words: Does Reading This Book Make Me a DBA?.- Appendix A How Do I Load the Examples?.- My Database Didn’t Restore.- Appendix B How Can I Find Information More Efficiently?.- Reading Books On Line.- Going to the Microsoft Developer Network.- Other Online Resources.- Calling on a Friend.- Other Reading Material.- Appendix C Recommended for the Bookshelf.- Magazines.- SQL Server Books.- Non-Programming Books.- Appendix D Bulk Copy Program.- What Are bcp’s Required Parameters?.- What Are bcp’s Security Parameters?.- How Does bcp Format Data?.- Is bcp Faster?.- Last Words.- Resources.