Shared Flashcard Set

Details

Installing Microsoft SQL Server lesson 2
Microsoft SQL Server 2008 Exam 70-432
40
Computer Science
Undergraduate 4
09/19/2013

Additional Computer Science Flashcards

 


 

Cards

Term
High Availability Implementation
Definition
Replication management; give access to clients of the server
Term
Supporting Customers
Definition
you support customers by use of KILLS or Locks which prevent a database user from Reading/Writing data to a database while another uses it
Term
Domain
Definition
sets a security boundary within:
tree & forest
Term
workgroup
Definition

no need of an Active Directory

Each server Each workstation inside local network

needs individual administrative attention

Term
Named Instances
Definition
these are essentially like running multiple SQL servers on one machine
Term
MSSQLSERVER
Definition
this is the default instance
Term
Service Account
Definition
gives the service access
to the machine and network
with privileges
Term
Windows Authentication Mode
Definition
Only clients with Windows OS account will be able to access the system
This is the Default mode
Term
sa account
Definition
built-in all powerful login account
It is used in the mixed mode (the opposite of the Windows Auth Mode)
to connect to SQL Server
It is the same as Admin Account in Windows
Term
collation setting
Definition

Collation means the gathering of pages as in bookbinding Here it is the combination of: character set / sort order / Unicode

this tells SQL Server how to 

store characters in tables

Term
What happened with collation settings prior to 2000?
Definition
You had to choose a:
character set
sort order
Unicode collation
That is all now combined into COLLATION SETTING
Term
What happens with collation settings in any OBJECT?
Definition
If it isn't a DB or column
you cannot change the collation setting
UNLESS you drop or recreate the object
Term
Code page
Definition

Bit Patterns!

This applies to character data

bit patterns that represent specific

letters

numbers

symbols

ASCII use 1 byte (each holding 1 to 256 bit patterns)

per character 

Unicode uses 2 bytes per character (each holding 1 to 65,536 bit patterns)

Term
Code point
Definition

UCS

Universal Character Set

encodes characters

each ID'd by name and integer

This name and integer is Code point

Term
SSAS
Definition

SQL Server Analysis Services

OLAP

OnLINE Analysis Processing

data mining for business intelligence applications

Term
SSIS
Definition

SQL Server Integration Services

Tool to manipulate data

Term
SSRS
Definition
SQL Server Reporting Services
Term

tree

AND

forest

Definition

These are TWO trees:

Microsoft.com

MSN.com

 

They are of the same forest;

 

These are of the SAME tree:

Research.Microsoft.com

Marketing.Microsoft.com

 

Same forest

 

 

Term

SQL Full-text Filter

Daemon Launcher Service

Definition

full-text indexes

of structured/partially structured data's

content and properties

are created with this

Term
SQL Server Service
Definition
SQL Server relational database engine's service
Term
SQL Server Agent service
Definition

Executes jobs

monitors SQL Server

fires alerts

enables automation of some administrative tasks

thus acts like a real "agent"

this requires administrative authority

Term
SQL Server Browser Service
Definition

name resolution for

connection info for 

client computers

Term
VSS Writer Service
Definition

This allows backups

You can restore apps to 

operate in 

Volume Shadow  Copy Service

framework

Term
Domain user
Definition

Used for 

files shares

linked server connections

server to server

Term
Local user account
Definition

not part of a domain

cannot communicate with other SQL Servers

over the network

Term
Local service account
Definition

built-in account

Users group

null session without credentials to access network resources

** Not Supported for the SQL Server

** Not Supported for the Server Agent services

Term
Local system account
Definition

very high-privileged 

built-in account

Term
Network service account
Definition

built-in account

more access to resources and objects

than members of Users group

Term

What does

SQL Server Agent

service

require?

Definition
It requires administrative authority
Term

ADMINISTRATION LOCAL GROUP

If you create one account

for SQL Server & SQL Server Agent services

you can add the user account

to the 

Administration local group

(there is no back to this card)

Definition
Term
Replication management
Definition

High availability

to give access to the clients

Replication is also known as 

Publishing

 

Term
Sort Orders
Definition

Binary

Binary code point

Case sensitive

Accent sensitive

Kana sensitive

Width sensitive

Term
Binary
Definition

default sort order

characters are in byte representation

Term
Binary Code Point
Definition

similar to binary sorting

Unicode is used

Term
Case sensitive
Definition
dictionary sort order
Term
Accent sensitive
Definition

dictionary sort order

that pays attention to accent marks

Term
Kana sensitive
Definition

kana marks

used in many Asian languages

Term
Width sensitive
Definition

single-byte characters

and 

double-byte characters

are treated differently

Term
SQL Server Management Studio
Definition

primary tool

for management objects

in the DB

integrated environment

for

accessing, configuring, managing, administering and developing

RDBMS components

Term
SQL Server Configuration Manager
Definition

start/stop

Windows Servers

to

enable and disable

network protocols

Supporting users have an ad free experience!