The Handbook for Reluctant Database Administrators

1. Auflage 2001
ISBN: 978-1-893115-90-3
Verlag: Apress

Buch, Englisch, 550 Seiten, Book w. online files / update, Format (B × H): 191 mm x 235 mm, Gewicht: 1061 g

Feeling reluctant? The Handbook for Reluctant Database Administrators provides you with a solid grasp of what you'll need to design, build, secure, and maintain a database. Author Josef Finsel writes from an understanding point of view; he also crossed over from programming to database administration. Furthermore, database administration veteran Francis Stanisci comments throughout the book, sharing insight from his own years of experience.

Zielgruppe

Professional/practitioner

Autoren/Hrsg.

Finsel, Josef

Fachgebiete

• Mathematik | Informatik EDV | Informatik Technische Informatik Wartung & Reparatur
• Interdisziplinäres Wissenschaften Wissenschaften: Allgemeines Enzyklopädien, Nachschlagewerke, Wörterbücher
• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Prozedurale Programmierung
• Mathematik | Informatik EDV | Informatik Daten / Datenbanken
• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Programmierung: Methoden und Allgemeines

Inhaltsverzeichnis

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.

Über Autor(innen)

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.