Microsoft® SQL ServerTM 2005 Database Essentials Step by Step
Get the guidance you need to start designing databases-one step at a time. With this practical tutorial, you'll teach yourself the core skills for building and managing databases with the next generation of SQL Server. Discover how to: Install and configure SQL Server 2005Design database comp...
| Autor principal: | |
|---|---|
| Autor Corporativo: | |
| Otros Autores: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Sebastopol :
Microsoft Press
2009.
|
| Edición: | 1st edition |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009627355806719 |
Tabla de Contenidos:
- Microsoft® SQL ServerTM 2005: Database Essentials Step by Step; How This Book Is Organized; Finding Your Best Starting Point in This Book; Conventions and Features in This Book; Other Features; System Requirements; Sample Files; Using the Sample Files; Uninstalling the Sample Files; Support for This Book; Acknowledgments; Technical Editor; I. Introduction to Database Development with Microsoft SQL Server 2005; Introducing Database Systems; Defining the Architecture of a Database Application; Using a Monolithic Application with Data Stored in an External File
- Using a Database Application with Data Managed by a Database ServerUsing an Application with a Generic Data Access Layer; Using an Application with Separated Presentation, Business, and Data Access Layers; Using a Complex Application with Multiple Options for Each Layer; Conclusion; 2. Installing and Setting Up Your Microsoft SQL Server 2005 Development Environment; Recommended Productivity Tools; Using Network Monitor; Using Upgrade Advisor; Recommended Development Tools; Microsoft SQL Server 2005 Editions; Microsoft SQL Server Workgroup Edition; Microsoft SQL Server Standard Edition
- Microsoft SQL Server Enterprise EditionInstalling SQL Server 2005; Using the Surface Area Configuration Tool; Surface Area Configuration For Features; Conclusion; 3. Reviewing Microsoft SQL Server 2005 Management Tools; Using SQL Server Books Online; Using SQL Server Configuration Manager; Using the SQL Server 2005 Network Configuration Node; Dynamic ports; Windows Firewall; What is the best configuration?; Using the SQL Native Client Configuration Node; Aliases; Using SQL Server Surface Area Configuration; Using Surface Area Configuration For Features; Sac Utility
- Using SQL Server Management StudioRegistering a Server in SQL Server Management Studio; Using Object Explorer in SQL Server Management Studio; Querying More than One Table; Managing Other Objects; Using Database Diagrams; Writing Scripts in SQL Server Management Studio; Starting a New Query Using the Database Context Menu; Retrieving Information about Your Queries; Retrieving Statistics; Writing Solutions and Projects in SQL Server Management Studio; Using SQL Server Management Studio Templates; Using SQL Server Profiler; When Should You Use SQL Server Profiler?; Accessing Event Types
- Running SQL Server Profiler and Performance Monitor TogetherViewing Deadlocks in SQL Server Profiler; Using Database Engine Tuning Advisor; Working with Database Engine Tuning Advisor; Evaluating the Recommendations; Managing Tuning Options; Managing Database Engine Tuning Advisor Sessions; Using SQLCmd; Executing Script Files; Conclusion; II. How to Create a Microsoft SQL Server 2005 Database; Capturing Requirements; Interviewing; Shadowing; Writing Requirements; Understanding Business Data and Its Lifetime; Availability; Manageability; Performance; Reliability; Scalability; Security
- Predicting the Volume of Information to Store and Manage and Predicting Database Utilization
