Microsoft SQL Server 2008: All-in-One Desk Reference for Dummies
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....
Search in google:
9 books in 1 — your key to SQL Server 2008 success!Your one-stop guide to the SQL Server 2008 database management systemYou already know that SQL Server 2008 is a blockbuster relational database management system. And because you want to get rolling with it right away, this book is the place to come. Here you find what's new in this version and how to build and maintain tables; retrieve, analyze, and report data; and keep your database healthy.Discover how to:Choose the right version of SQL ServerInstall SQL Server quicklyDesign a database and communicate with itMonitor, maintain, and protect your dataBuild solid, robust database applications
Introduction 1Bk. I Essential Concepts 7Ch. 1 Introducing SQL Server 2008 9Ch. 2 SQL Server Architecture and Key Concepts 15Ch. 3 Getting Started, Getting Around 23Ch. 4 Setting Up SQL Server 2008 35Ch. 5 Using SQL Server Management Studio 59Bk. II Designing and Using Databases 73Ch. 1 Setting Up a Database 75Ch. 2 Care and Feeding of Your Database 89Ch. 3 Data Types and How to Use Them 99Ch. 4 Constructing New Tables 121Ch. 5 Looking After Your Tables 141Ch. 6 Understanding Relationships 155Bk. III Interacting with Your Data 175Ch. 1 Using Proper Normalization Techniques 177Ch. 2 The SQL Server Optimizer 187Ch. 3 Using the Query Designer 201Ch. 4 Setting Query Options 213Ch. 5 Searching for Information 231Ch. 6 Organizing Query Results 257Ch. 7 Modifying Your Data 265Ch. 8 Taking Advantage of Views 273Ch. 9 Advanced Query Topics 291Bk. IV Database Programming 313Ch. 1 Understanding Transact-SQL 315Ch. 2 Stored Procedures and Functions 331Ch. 3 Triggers 349Ch. 4 Working with Visual Studio 361Ch. 5 Web Services 375Ch. 6 Developing Remote Applications 385Ch. 7 Advanced Development Topics 401Bk. V Reporting Services 419Ch. 1 Introduction to SQL Server Reporting Services 421Ch. 2 Creating Reports with Report Builder 435Ch. 3 Creating Reports with Report Designer 449Ch. 4 Integrating Reports 469Bk. VI Analysis Services 477Ch. 1 Introduction to SQL Server Analysis Services 479Ch. 2 Creating Business Intelligence Solutions with BIDS 493Ch. 3 Data Mining and Maintaining Analysis Services Objects 517Bk. VII Performance Tips and Tricks 529Ch. 1 Working with the SQL ServerOptimizer 531Ch. 2 Using Performance Monitoring Tools 541Ch. 3 Data Access Strategies 569Ch. 4 Tuning SQL Server 587Bk. VIII Database Administration 601Ch. 1 Configuring SQL Server 603Ch. 2 Performing Major Administrative Tasks 619Ch. 3 Security: Keeping SQL Server Safe 647Ch. 4 Integration and Your Database 661Ch. 5 Replication 677Ch. 6 Spreading the Load with Partitioning 693Bk. IX Appendixes 701App. A Ten Sources of Information on SQL Server 2008 703App. B Troubleshooting SQL Server 2008 707App. C Glossary 715Index 725
![SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]](/application/data/covers/44/31/9780321444431.jpg "SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]")
