Microsoft® SQL Server® 2012 Bible

(Ben Green) #1

107


Chapter 5: SQL Server Management and Development Tools


5


■ (^) Registered Servers can be useful if you have lots of servers to manage or if you
want to easily query groups of your servers simultaneously.
■ (^) Management Studio offers a scalable experience. The accidental DBA can use the
wizards and GUI, whereas the master DBA can work with raw T-SQL, PowerShell,
DMVs, and wait states.
■ The Query Editor is the place where T-SQL happens. Take the time to master its
little features, such as bookmarks, to get the most out of SQL Server.
■ IntelliSense takes some getting used to. But when it’s mastered, it’s great.
c05 July 23, 2012 11:44 AM V1
c05.indd 107c05.indd 107 7/30/2012 4:14:52 PM7/30/2012 4:14:52 PM
http://www.it-ebooks.info

Free download pdf