Overview

If you’re in charge of database administration, developing database software, or looking for database solutions for your company, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies can help you get a handle on this extremely popular relational database management system. Here you’ll find what’s new in the latest version; how to choose and install the right variation for your needs; how to monitor, maintain, and protect your data; and what it takes to keep your database healthy. You’ll discover how to: Build and maintain tables Design a database and communicate with it Retrieve, analyze, and report data Build solid, robust database applications Use the SQL Server Optimizer and Query Designer Navigate SQL Server with Visual Studio Develop useful reports with the Report Builder and Report Designer Create Business Intelligence solutions with Business Intelligence Development Studio Configure your server and perform major administrative tasks To help you quickly find what you need, Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies is divided into nine minibooks: Essential Concepts Designing and Using Databases Interacting With Your Data Database Programming Reporting Services Analysis Services Performance Tips and Tricks Database Administration Appendixes Microsoft SQL Server 2008 All-In-One Desk Reference For Dummies gets you started, helps you solve problems, and will even answer your questions down the road!

Full Product Details

Author:   RD Schneider ,  Darril Gibson ,  Darril Gibson
Publisher:   John Wiley and Sons Ltd
Imprint:   John Wiley & Sons Ltd
Dimensions:   Width: 19.00cm , Height: 4.20cm , Length: 23.40cm
Weight:   1.376kg
ISBN:  

9780470179543

ISBN 10:   0470179546
Pages:   768
Publication Date:   26 September 2008
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Paperback
Publisher's Status:   Active
Availability:   Manufactured on demand  
We will order this item for you from a manufactured on demand supplier.

Table of Contents

Introduction 1 Book I: Essential Concepts 7 Chapter 1: Introducing SQL Server 2008 9 Chapter 2: SQL Server Architecture and Key Concepts 15 Chapter 3: Getting Started, Getting Around 23 Chapter 4: Setting Up SQL Server 2008 35 Chapter 5: Using SQL Server Management Studio 59 Book II: Designing and Using Databases 73 Chapter 1: Setting Up a Database 75 Chapter 2: Care and Feeding of Your Database 89 Chapter 3: Data Types and How to Use Them 99 Chapter 4: Constructing New Tables 121 Chapter 5: Looking After Your Tables 141 Chapter 6: Understanding Relationships 155 Book III: Interacting with Your Data 175 Chapter 1: Using Proper Normalization Techniques 177 Chapter 2: The SQL Server Optimizer 187 Chapter 3: Using the Query Designer 201 Chapter 4: Setting Query Options 213 Chapter 5: Searching for Information 231 Chapter 6: Organizing Query Results 257 Chapter 7: Modifying Your Data 265 Chapter 8: Taking Advantage of Views 273 Chapter 9: Advanced Query Topics 291 Book IV: Database Programming 313 Chapter 1: Understanding Transact-SQL 315 Chapter 2: Stored Procedures and Functions 331 Chapter 3: Triggers 349 Chapter 4: Working with Visual Studio 361 Chapter 5: Web Services 375 Chapter 6: Developing Remote Applications 385 Chapter 7: Advanced Development Topics 401 Book V: Reporting Services 419 Chapter 1: Introduction to SQL Server Reporting Services 421 Chapter 2: Creating Reports with Report Builder 435 Chapter 3: Creating Reports with Report Designer 449 Chapter 4: Integrating Reports 469 Book VI: Analysis Services 477 Chapter 1: Introduction to SQL Server Analysis Services 479 Chapter 2: Creating Business Intelligence Solutions with BIDS 493 Chapter 3: Data Mining and Maintaining Analysis Services Objects 517 Book VII: Performance Tips and Tricks 529 Chapter 1: Working with the SQL Server Optimizer 531 Chapter 2: Using Performance Monitoring Tools 541 Chapter 3: Data Access Strategies 569 Chapter 4: Tuning SQL Server 587 Book VIII: Database Administration 601 Chapter 1: Configuring SQL Server 603 Chapter 2: Performing Major Administrative Tasks 619 Chapter 3: Security: Keeping SQL Server Safe 647 Chapter 4: Integration and Your Database 661 Chapter 5: Replication 677 Chapter 6: Spreading the Load with Partitioning 693 Book IX: Appendixes 701 Appendix A: Ten Sources of Information on SQL Server 2008 703 Appendix B: Troubleshooting SQL Server 2008 707 Appendix C: Glossary 715 Index 725

Reviews

Author Information

Robert D. Schneider is a database optimization consultant who has been delivering software solutions for 15 years. Darril Gibson is a professional trainer specializing in certification and Microsoft technologies.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions