Term
| High Availability Implementation |
|
Definition
| Replication management; give access to clients of the server |
|
|
Term
|
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
|
Definition
sets a security boundary within:
tree & forest |
|
|
Term
|
Definition
no need of an Active Directory
Each server Each workstation inside local network
needs individual administrative attention |
|
|
Term
|
Definition
| these are essentially like running multiple SQL servers on one machine |
|
|
Term
|
Definition
| this is the default instance |
|
|
Term
|
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
|
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
|
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
|
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
|
Definition
UCS
Universal Character Set
encodes characters
each ID'd by name and integer
This name and integer is Code point |
|
|
Term
|
Definition
SQL Server Analysis Services
OLAP
OnLINE Analysis Processing
data mining for business intelligence applications |
|
|
Term
|
Definition
SQL Server Integration Services
Tool to manipulate data |
|
|
Term
|
Definition
| SQL Server Reporting Services |
|
|
Term
|
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
|
Definition
| SQL Server relational database engine's service |
|
|
Term
|
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
|
Definition
This allows backups
You can restore apps to
operate in
Volume Shadow Copy Service
framework |
|
|
Term
|
Definition
Used for
files shares
linked server connections
server to server |
|
|
Term
|
Definition
not part of a domain
cannot communicate with other SQL Servers
over the network |
|
|
Term
|
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
|
Definition
very high-privileged
built-in account |
|
|
Term
|
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
|
Definition
High availability
to give access to the clients
Replication is also known as
Publishing
|
|
|
Term
|
Definition
Binary
Binary code point
Case sensitive
Accent sensitive
Kana sensitive
Width sensitive |
|
|
Term
|
Definition
default sort order
characters are in byte representation |
|
|
Term
|
Definition
similar to binary sorting
Unicode is used |
|
|
Term
|
Definition
|
|
Term
|
Definition
dictionary sort order
that pays attention to accent marks |
|
|
Term
|
Definition
kana marks
used in many Asian languages |
|
|
Term
|
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 |
|
|
