Skip to Content
Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®
book

Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®

by Robert D. Schneider, Darril Gibson
September 2008
Beginner to intermediate
768 pages
17h 40m
English
For Dummies
Content preview from Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®

Chapter I.5. Using SQL Server Management Studio

The average IT professional must be a master of multi-tasking. Because the demands of their jobs never end, wise database administrators, architects, and developers search for enhanced productivity wherever they can find it. That's where the SQL Server Management Studio comes in. Provided alongside every edition of SQL Server (even the free SQL Server 2008 Express), it's an excellent graphical query and administrative tool, especially when compared with those offered by other major, relational database vendors.

No matter your interaction with SQL Server, this chapter helps you see how this versatile tool can make life easier for you. To help you navigate, we begin by providing a 35,000-foot overview of its main menu structure and major icons. We then quickly dive in to what you can learn about your SQL Server instance by interacting with the Object Explorer. Next, we briefly touch on the Template Explorer and the Solution Explorer. The chapter closes with a detailed examination of how to run queries within the SQL Server Management Studio.

Although many character-based utilities are also at your disposal (most of them legacies from earlier versions), as time goes by you'll probably find yourself performing the majority of your database design and administrative tasks within SQL Server Management Studio. Note: We periodically refer ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Microsoft® SQL Server® 2008 Step by Step

Microsoft® SQL Server® 2008 Step by Step

Mike Hotek
Microsoft® SQL Server® 2008 Bible

Microsoft® SQL Server® 2008 Bible

Paul Nielsen, Mike White, Uttam Parui

Publisher Resources

ISBN: 9780470179543Purchase book