Chapter 15. Using SQL Server Management Studio to the fullest

Rodney Landrum

As a DBA or SQL Developer, how often do you use SQL Server Management Studio (SSMS) in your path? That’s what I thought: every day, except for the days you’re on vacation (and even then you’re probably thinking about using it). SSMS is generally our tool of choice for all manner of DBA-related activities and tasks, from backups to writing T-SQL queries. We all become accustomed to using an application the same way, over and over again through the years. In this chapter, I’ll introduce you to some features that are available in SSMS 2008 and 2008 R2 that I’ve found raises an “Ahhh, cool” from people who were unaware of the existence of these features.

There are specifically ...

Get SQL Server MVP Deep Dives Vol. 2 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.