Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies
Published on 10. February 2011
768 pages
978-1-118-05194-8 (ISBN)
Description
If you're in charge of database administration, developingdatabase software, or looking for database solutions for yourcompany, Microsoft SQL Server 2008 All-In-One Desk Reference ForDummies can help you get a handle on this extremely popularrelational database management system. Here you'll findwhat's new in the latest version; how to choose and installthe right variation for your needs; how to monitor, maintain, andprotect 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 ReportDesigner
* Create Business Intelligence solutions with BusinessIntelligence Development Studio
* Configure your server and perform major administrativetasks
To help you quickly find what you need, Microsoft SQL Server2008 All-In-One Desk Reference For Dummies is divided into nineminibooks:
* 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 ForDummies gets you started, helps you solve problems, and willeven answer your questions down the road!
More details
Other editions
Additional editions
Robert D. Schneider | Darril Gibson
Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies
Book
09/2008
Wiley
Unfortunately, price unknown
Article exhausted; check different version
Persons
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.
Content
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
