91
Chapter 5: SQL Server Management and Development Tools
5
■ (^) Tables: Used to create and modify the design of tables, view and edit the con-
tents of tables, and work with the tables’ indexes, permissions, and publications.
Triggers, stored procedures that respond to data-modifi cation operations (insert,
update, and delete), may be created and edited here.
■ (^) Views: Stored SQL statements are listed, created, and edited, and the results
viewed, from this node.
■ (^) Synonyms: Alternative names for SQL Server database objects.
■ Programmability: A large section that includes most of the development objects,
stored procedures, functions, database triggers, assemblies, types, rules, defaults,
Plan Guides and Sequences.
■ (^) Service Broker: Used to view and create Server broker objects, such as message
types, contracts, queues, services, routes, remote service bindings, and broker pri-
orities. You can now quickly create Service Broker applications using pre-defi ned
templates. These code templates are presented when you right-click any node under
Service Broker and choose to create a new item of that grouping’s type.
■ Storage: Used to manage nonstandard storage, such as full-text search and table
partition schemes and functions, Full Text Stoplists, and Search Property Lists.
■ Security: Used to manage security at the database level.
The Security node is used to manage server-wide security:
■ Logins: Server-level authentication of logins.
■ (^) Server Roles: Predefi ned security roles. You can now also create your own custom
server-lever roles.
■ (^) Credentials: Lists credentials.
■ Cryptographic Providers: Used for advanced data encryption.
■ (^) Audits: Part of SQL Audit, collects data from Extended Events.
■ Server Audit Specifi cations: Defi nes a SQL Audit for a server-level audit.
■ (^) Server Objects: Holds server-wide items:
■ Backup Devices: Organizes tapes and fi les for backup operations.
■ (^) Endpoints: HTTP endpoints used by database mirroring, service broker, SOAP,
and T-SQL.
■ (^) Linked Servers: Lists predefi ned server credentials for distributed queries.
■ Triggers: Contains server level DDL triggers.
Replication is used to set up and monitor replication:
■ Local Publications: Lists publications available from this server.
■ (^) Local Subscriptions: Lists subscriptions this server subscribes to from other servers.
The AlwaysOn High Availability node contains information about AlwaysOn Availability
Groups.
c05 July 23, 2012 11:44 AM V1
c05.indd 91c05.indd 91 7/30/2012 4:14:46 PM7/30/2012 4:14:46 PM
http://www.it-ebooks.info