Microsoft SQL Server 2008 All-in-One Desk Reference For Dummies

Robert D. Schneider · Darril Gibson

Feb 2011 · John Wiley & Sons

About this ebook

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!

About the author

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.