Term
| Database Engine Services: |
|
Definition
| core database, notification, replication, full-text search components |
|
|
Term
| SQL Server Analysis Services (SSAS): |
|
Definition
| online analytical processing (OLAP) and data mining; enables you to work with aggregated data from multiple sources |
|
|
Term
| SQL Server Integration Services (SSIS): |
|
Definition
for extracting and transforming data from multiple sources and moving it to one or more destination data sources for data warehouses, data
marts, etc. |
|
|
Term
|
Definition
| Report Manager and Report Server for creating, managing, and distributing reports; built on IIS and .NET Framework technology |
|
|
Term
|
Definition
provides reliable queuing and messaging as a
central part of the database; allows queries to be stacked and performed as resources allow; delivers notification messages |
|
|
Term
|
Definition
| enables data synchronization for collaboration and offline use |
|
|
Term
Memory Guidelines
Minimum and Recommended |
|
Definition
| Minimum: 512 MB; Recommended: 2,048 MB |
|
|
Term
| What RAID Should we use for Data? |
|
Definition
|
|
Term
| What RAID should we use for Logs? |
|
Definition
|
|
Term
|
Definition
disk striping without parity
• Good read/write performance, but if any drive fails, SQL Server cannot continue until the drive is replaced |
|
|
Term
|
Definition
disk mirroring
Creates duplicate copies of data on separate drives; a drive can be rebuilt while the mirror allows processing to continue |
|
|
Term
|
Definition
disk striping with parity
Good protection against single drive failure but poor
read/write performance |
|
|
Term
| On a Windows server, SQL Server services can be configured to log on as... |
|
Definition
| the LocalSystem, LocalService, or NetworkService account, or to use Windows logon accounts |
|
|
Term
| when should you use a DOMAIN ACCOUNT for SQL Server with privileges that you configure? |
|
Definition
| Use this when the server requires access to resources across the network, when events must be forwarded to the application logs of other systems, and when you want to configure email or pager notifications |
|
|
Term
when should you use a LOCAL SYSTEM ACCOUNT for SQL Server that provides admin privileges to the
SQL Server on the local system but no privileges on a network |
|
Definition
| Use this when you want to isolate SQL Server and restrict it from interacting with other servers |
|
|
Term
| when should you use a NETWORK SERVICES ACCOUNT for SQL Server that provides same level of access to resources as is granted members of the Users group; can access the network and communicate with other servers |
|
Definition
• Use this when you want the SQL Server to interact throughout the network by using the credentials of the computer account
• Not recommended when other services that use this account are installed on the computer |
|
|
Term
when should you use a LOCAL SERVICE ACCOUNT for SQL Server that provides same level of access to
resources as is granted to members of the Users group; can access resources as a null session without credentials |
|
Definition
| Use this when SQL Server service does not need access to other servers |
|
|
Term
|
Definition
| for performing most core SQL Server admin tasks |
|
|
Term
|
Definition
| view & connect to SQL Server, Analysis Services, Integration Services, Reporting Services, and Compact edition |
|
|
Term
Registered Servers:
(VIEW) |
|
Definition
| shows currently registered servers; allow you to switch between servers of a particular type |
|
|
Term
|
Definition
| access to the default Query Editor templates and custom templates |
|
|
Term
Solutions Explorer:
(VIEW) |
|
Definition
| access to SQL Server, Analysis Server, and Compact edition projects |
|
|
Term
| SQL Server Configuration Manager: |
|
Definition
| perform essential service, setup, and network configuration tasks |
|
|
Term
| Analysis Services Deployment Wizard: |
|
Definition
| to deploy the output from an Analysis Services project to a target server |
|
|
Term
| Business Intelligence Development Studio: |
|
Definition
| develop & manage business intelligence objects |
|
|
Term
| Database Engine Tuning Advisor: |
|
Definition
|
|
Term
| Import & Export Data Wizard: |
|
Definition
| define SSIS packages for import and export |
|
|
Term
| Reporting services includes: |
|
Definition
• Tools for working with and viewing reports
• Engine for hosting and viewing reports
• Extensible architecture for integration with existing IT infrastructure |
|
|
Term
| Database mail allows a SQL Server to send outbound mail messages. What does it usually notify the user of? |
|
Definition
| performance conditions or changes made to objects |
|
|
Term
| What Transfer Protocol does Database Mail use? |
|
Definition
| Uses Simple Mail Transfer Protocol (SMTP) relay service available on all Windows systems |
|
|
Term
| Database Mail requires that what runs with it? |
|
Definition
|
|
Term
| In Database Mail, where are messages logged? |
|
Definition
|
|
