نمایهٔ کتاب، معرفی نویسندگان و نظرسنجی
صفحهٔ ۲۶۹ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۶۹
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
Index
Symbols ALTER USER DEFAULT_SCHEMA option, 59
AlwaysOn, 4–6, 21–23
32-bit editions of SQL Server 2012, 17 AlwaysOn Availability Groups, 4–5, 23–32
64-bit editions of SQL Server 2012, 17 availability group listeners, 28–29
64-bit processors, 17 availability replica roles, 26
debugging on, 99 configuring, 29–31
[catalog].[executions] table, 137 connection modes, 27
data synchronization modes, 27
A deployment examples, 30–31
deployment strategy, 23–24
absolute environment references, 133–135 failover modes, 27
Active Directory security modules, 71 monitoring with Dashboard, 31–32
Active Operations dialog box, 130 multiple availability group support, 25
active secondaries, 32–34 multiple secondaries support, 25
Administrator account, 176 prerequisites, 29–30
Administrator permissions, 211 shared and nonshared storage support, 24
administrators AlwaysOn Failover Cluster Instances, 5, 34–36
data alert management, 250 Analysis Management Objects (AMOs), 217
Database Engine access, 72 Analysis Services, 199–217
entity management, 192 cached files settings, 225
master data management in Excel, 187–196 cache reduction settings, 225
tasks of, 135–139 credentials for data import, 204
ADO.NET connection manager, 112–113 database roles, 210–211
ad reporting tool, 229 DirectQuery mode, 213
Advanced Encryption Standard (AES), 71 event tracing, 215
affinity masks, 216 in-memory vs. DirectQuery mode, 213
aggregate functions, 220 model designer, 205–206
alerting service, 248–249. See also data alerts model design feature support, 200–202
All Executions report, 138 multidimensional models, 215
allocation_failure event, 90 multiple instances, 201
All Operations report, 138 with NUMA architecture, 216
Allow All Connections connection mode, 33 PowerShell cmdlets for, 217
Allow Only Read-Intent Connections connection mode, Process Full command, 215
33 processors, number of, 216
All Validations report, 138 programmability, 217
ALTER ANY SERVER ROLE, permissions on, 72 projects, 201–202
ALTER ANY USER, 70 query modes, 214
ALTER SERVER AUDIT, WHERE clause, 63 schema rowsets, 216
تصویر مرجع صفحهٔ ۲۶۹ فایل PDF
صفحهٔ ۲۷۰ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۷۰
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
Analysis Services
Analysis Services (continued) failover, 25
server management, 215–216 hosting of, 26
server modes, 199–201 availability group listeners, 28–29
tabular models, 203–214 availability groups. See AlwaysOn Availability Groups
templates, 201–202 availability replicas, 26
Analysis Services Multidimensional and Data Mining
Project template, 202
Analysis Services tabular database, 233, 234
B
Analysis Services Tabular Project template, 202 backup history, visualization of, 39–40
annotations, 191, 198 backups on secondaries, 33–34
reviewing, 191 bad data, 141
applications batch-mode query processing, 45
data-tier, 10 beyond-relational paradigm, 11, 73–90
file system storage of files and documents, 77 example, 76
asynchronous-commit availability mode, 27 goals, 74
asynchronous database mirroring, 21–22 pain points, 73
asynchronous data movement, 24 bidirectional data synchronization, 9
attribute group permissions, 184–185 BIDS (Business Intelligence Development Studio), 93.
attribute object permissions, 183 See also SSDT (SQL Server Data Tools)
attributes binary certificate descriptions, 71
domain-based, 193–194 binary large objects (BLOBs), 74
modifying, 193 storage, 75
Attunity, 103, 104, 111 BISM (Business Intelligence Semantic Model)
auditing, 62–67 connection files, as Power View data source, 233
audit, creating, 64–65 Connection type, adding to PowerPivot site
audit data loss, 62 document library, 233–234
audit failures, continuing server operation, 63 schema, 217
audit failures, failing server operation, 63, 65 BLOBs (binary large objects), 74
Extended Events infrastructure, 66 storage, 75
file destination, 63, 64 B-tree indexes, 42–43
record filtering, 66–67 situations for, 48
resilience and, 62–65 bubble charts in Power View, 239
support on all SKUs, 62 Business Intelligence Development Studio (BIDS), 93
user-defined audit events, 63, 65–66 Business Intelligence edition of SQL Server 2012, 14
users of contained databases, 63 Business Intelligence Semantic Model (BISM).
audit log See BISM (Business Intelligence Semantic
customized information, 63, 65–66 Model)
filtering events, 63, 66–67
Transact-SQL stack frame information, 63
authentication
C
claims-based, 231, 233 cache
Contained Database Authentication, 68–69 managing, 225
middle-tier, 66 retrieving data from, 213
user, 9 Cache Connection Manager, 98
automatic failover, 27 calculated columns, 207
availability. See also high availability (HA) cards in Power View, 238
new features, 4–6 catalog, 119, 128–135
systemwide outages and, 62 adding and retrieving projects, 119
availability databases administrative tasks, 129
backups on secondaries, 33–34 creating, 128–129
تصویر مرجع صفحهٔ ۲۷۰ فایل PDF
صفحهٔ ۲۷۱ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۷۱
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
CONMGR file extension
adding and retrieving projects (continued) clustering. See also failover clustering
database name, 128–129 clusters
encrypted data in, 139 health-detection policies, 5
encryption algorithms, 130 instance-level protection, 5
environment objects, 132–135 multisubnet, 34
importing projects from, 121 code, pretty-printing, 139
interacting with, 129 collections management, 183
operations information, 130–131 columns
permissions on, 139 calculated, 207
previous project version information, 131 with defaults, 40
properties, 129–131 filtering view, 109
purging, 131 mappings, 108–109
catalog.add_data_tap procedure, 137 reporting properties, 212–213
Catalog Properties dialog box, 129–130 variable number, 105
catalog.set_execution_parameter_value stored columnstore indexes, 6, 41–56
procedure, 127 batch-mode query processing, 45
CDC (change data capture), 57, 111–114 best practices, 54
CDC Control Task Editor, 113 business data types supported, 46
CDC Source, 113–114 columns to include, 49–50
CDC Splitter, 113–114 compression and, 46
certificates creating, 49–54
binary descriptions, 71 data storage, 42–43
key length, 71 design considerations, 47–48
change data capture (CDC), 57, 111–114 disabling, 48
control flow, 112–113 hints, 53–54
data flow, 113–114 indicators and performance cost details, 52–53
change data capture tables, 111 loading data, 48–49
chargeback, 8 nonclustered, 50
charts in Power View, 237, 241 query speed improvement, 44–45
Check For Updates To PowerPivot Management restrictions, 46–47
Dashboard.xlsx rule, 227 storage organization, 45
child packages, 102 updating, 48–49
circular arc segments, 87–89 Columnstore Index Scan Operator icon, 52
circular strings, 88 column store storage model, 42
claims-based authentication, 231, 233 composite domains, 151–153
cleansing, 162 cross-domain rules, 152
confidence score, 150 managing, 152
corrections, 163 mapping fields to, 162, 172
exporting results, 163–164 parsing methods, 152
scheduled, 171 reference data, 152
syntax error checking, 146 value relations, 153
cleansing data quality projects, 161–164 compound curves, 88–89
monitoring, 167 compression of column-based data, 44
Cleansing transformation, 141 Conceptual Schema Definition Language (CSDL)
configuring, 171–172 extensions, 217
monitoring, 167 confidence score, 150, 162
client connections, allowing, 33 specifying, 169
cloud computing licensing, 15 configuration files, legacy, 121
Cloud Ready Information Platform, 3 CONMGR file extension, 99
cloud services, 9
تصویر مرجع صفحهٔ ۲۷۱ فایل PDF
صفحهٔ ۲۷۲ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۷۲
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
connection managers
connection managers data
creating, 104 cleansing. See cleansing
expressions, 100 data integration, 73–74
package connections, converting to, 99 de-duplicating, 141, 146, 173
sharing, 98–99 loading into tables, 48–49
connection modes, 27 log shipping, 22
Connections Managers folder, 98 managing across systems, 11
Connections report, 138 normalizing, 146
Contained Database Authentication, 68–69 partitioning, 47, 48–49
enabling, 68–69 protecting, 23
security threats, 70–71 redundancy, 4
users, creating, 69–70 refreshing, 227
contained databases, 9 spatial, 86–90
auditing users, 63 structured and nonstructured, integrating, 73–74
database portability and, 69 volume of, 41
domain login, creating users for, 70 data-access modes, 104
initial catalog parameter, 69 Data Alert Designer, 246–248
users with password, creating, 70 Data Alert Manager, 249–250
control flow data alerts, 229, 246–250
Expression Task, 101–102 alerting service, 248–249
status indicators, 101 configuring, 250
control flow items, 97–98 creating, 247
Convert To Package Deployment Model command, 118 Data Alert Designer, 246–248
correct domain values, 147 Data Alert Manager, 249–250
CPU usage, maximum cap, 8 email messages, 249
Create A New Availability Group Wizard, 28 email settings, 248
Create Audit Wizard, 64 errors, 249
CREATE CERTIFICATE FROM BINARY, 71 managing, 249–250
Create Domain dialog box, 147 retry settings, 250
CreateSchedule event, 250 scheduling, 248
CREATE SERVER AUDIT, WHERE clause, 63 Data Analysis Expression (DAX). See DAX (Data
CREATE SERVER ROLE, permissions on, 72 Analysis Expression)
CREATE USER DEFAULT_SCHEMA, 59 data and services ecosystem, 74–75
cross-domain rules, 152 Database Audit Specification objects, 62
cryptography database authentication, 67–71
enhancements, 71 Database Engine
hashing algorithms, 71 change data capture support, 111
CSDL (Conceptual Schema Definition Language) local administrator access, 72
extensions, 217 upgrading, 175
CSV files, extracting data, 105 user login, 67
curved polygons, 89 database instances. See also SQL Server instances
Customizable Near operator, 82 orphaned or unused logins, 68
Custom Proximity Operator, 82 database mirroring, 23
alternative to, 23
D asynchronous, 21–22
synchronous, 22
DACs (data-tier applications), 10 database portability
dashboard contained databases and, 69–70
AlwaysOn Availability Groups, monitoring, 31–32 Database Engine authentication and, 67
launching, 31 database protection, 4–5
تصویر مرجع صفحهٔ ۲۷۲ فایل PDF
صفحهٔ ۲۷۳ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۷۳
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
data visualization
Database Recovery Advisor, 39–40 Data Quality Client log, 170
Database Recovery Advisor Wizard, 34 data quality management, 141
database restore process, visual timeline, 6 activity monitoring, 166–167
databases configuring, 167
Analysis Services tabular, 233 improving, 107
authentication to, 67 knowledge base management, 143–161
bidirectional data synchronization, 9 data quality projects, 143, 161–166
contained, 9, 68–69 cleansing, 161–164
failover to single unit, 4 exporting results, 161
portability, 9 matching, 164–166
report server, 231 output, 146
SQL Azure, deploying to, 9 Data Quality Server, 141–142
Database Wizard, 176 activity monitoring, 166–167
datacenters, secondary replicas in, 4 connecting to Integration Services package, 171
Data Collection Interval rule, 226, 227 installation, 141–142
data destinations, 103–104 log settings, 170
ODBC Destinations, 104–105 remote client connections, 142
data extraction, 105 user login creation, 142
data feeds, 247–248 Data Quality Server log, 170
refreshing, 248 Data Quality Services (DQS). See DQS (Data Quality
data flow Services)
capturing data from, 137 data sources. See also source data
components, developing, 107 creating, 103–104
groups, 109–110 importing data from, 204
input and output column mapping, 108–109, installing types, 104
172–173 ODBC Source, 104–105
sources and destinations, 103–106 data stewards, 143
status indicators, 101 master data management in Excel, 187–196
data flow components, 97–98 data storage
column references, 108–109 column-based, 42–43
disconnected, 108 in columnstore indexes, 42–43
grouping, 109–110 row-based, 42–43
data flow designer, error indicator, 108–109 data synchronization modes, 27
data-flow tasks, 103–104 data tables. See also tables
CDC components, 112 converting to other visualizations, 237–241
data latency, 32 designing, 234–237
DataMarket subscriptions, 168 play axis area, 239–240
Data Quality Client, 142–143 data taps, 137
Activity Monitoring, 166–167 data-tier applications (DACs), 10
Administration feature, 166–170 data types, columnstore index-supported, 46
client-server connection, 143 data viewer, 110–111
Configuration area, 167–170 data visualization, 229
Configuration button, 167 arrangement, 238
domain value management, 149 cards, 238
Excel support, 143 charts, 237
installation, 143 multiples, 241
New Data Quality Project button, 161 play axis, 239–240
New Knowledge Base button, 145 in Power View, 237–241
Open Knowledge Base button, 144 separate views, 241–242
tasks, 143 slicing data, 243
تصویر مرجع صفحهٔ ۲۷۳ فایل PDF
صفحهٔ ۲۷۴ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۷۴
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
data visualization
data visualization (continued) DOCX files, 230
sort order, 241 domain-based attributes, 193–194
tile containers, 243–244 domain management, 143–154
tiles, 239 DQS Data knowledge base, 144–145
view filters, 244–245 exiting, 154
visualization filters, 245 knowledge base creation, 145–154
data warehouses monitoring, 167
queries, improving, 6 domain rules, 150–151
query speeds, 44–45 disabling, 151
sliding-window scenarios, 7 running, 155
date filters, 219–220, 244–245 domains
DAX (Data Analysis Expression) composite, 151–152
new functions, 222–224 creating, 146
row-level filters, 211 data types, 146
dbo schema, 58 importing, 146
debugger for Transact-SQL, 7 linked, 153–154
debugging on 64-bit processors, 99 mapping to source data, 158, 161–162, 164
Default Field Set property, 212 properties, 146–147
Default Image property, 212 term-based relations, 149
Default Label property, 212 domain values
default schema cross-domain rules, 152
creation script, 59 domain rules, 150–151
for groups, 58–59 formatting, 146
for SQL Server users, 58 leading values, 148–149, 173
delegation of permissions, 139 managing, 156–157
DeleteSchedule event, 250 setting, 147
delimiters, parsing, 152 spelling checks, 146
DeliverAlert event, 250 synonyms, 148–149, 163, 173
dependencies type settings, 147–148
database, 9 downtime, reducing, 40
finding, 216 dqs_administrator role, 142
login, 67 DQS Cleansing transformation, 107
Deploy Database To SQL Azure wizard, 9 DQS Cleansing Transformation log, 170
deployment models, 116–122 DQS Data knowledge base, 144–145, 196
switching, 118 DQS (Data Quality Services), 107, 141–173
deployment, package, 120 administration, 143, 166–170
Description parameter property, 123 architecture, 141–143
Designing and Tuning for Performance Your SSIS configuration, 167–170
Packages in the Enterprise link, 96–97 connection manager, 171
destinations, 103–105 Data Quality Client, 142–143. See also Data
Developer edition of SQL Server 2012, 15 Quality Client
Digital Trowel, 167 data quality projects, 161–166
directory name, enabling, 79 Data Quality Server, 141–142. See also Data
DirectQuery mode, 213–215 Quality Server
DirectQuery With In-Memory mode, 214 Domain Management area, 143–154
disaster recovery, 21–40 Excel, importing data from, 147
disconnected components, 108 integration with SQL Server features, 170–173
discovery. See knowledge discovery knowledge base management, 143–161
DMV (Dynamic Management View), 8 Knowledge Discovery area, 154–157
documents, finding, 85 log settings, 169–170
تصویر مرجع صفحهٔ ۲۷۴ فایل PDF
صفحهٔ ۲۷۵ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۷۵
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
FILESTREAM
DQS (Data Quality Services) (continued) exporting content
Matching Policy area, 157–161 cleansing results, 163–164
profiling notifications, 169 matching results, 165
dqs_kb_editor role, 142 exposures reported to NIST, 10
dqs_kb_operator role, 142 Express edition of SQL Server 2012, 15
DQS_MAIN database, 142 Expression Builder, 101–102
DQS_PROJECTS database, 142 expressions, 100
DQS_STAGING_DATA database, 142 parameter usage in, 124
drop-rebuild index strategy, 47 size limitations, 115–116
DTSX files, 139 Expression Task, 101–102
converting to ISPAC files, 121–122 Extended Events, 66
Dynamic Management View (DMV), 8 event tracing, 215
management, 12
E monitoring, 216
new events, 90
EKM (Extensible Key Management), 57 Extensible Key Management (EKM), 57
encryption extract, transform, and load (ETL) operations, 111
enhancements, 71
for parameter values, 130
Enterprise edition of SQL Server 2012, 12–13
F
entities. See also members failover
code values, creating automatically, 178–179 automatic, 23, 27
configuring, 178 of availability databases, 25
creating, 192–193 manual, 23, 27
domain-based attributes, 193–194 modes, 27
managing, 177–179 to single unit, 4
many-to-many mappings, 179 startup and recovery times, 5
permissions on, 183–185 failover clustering, 21–22. See also clustering
entry-point packages, 119–120 for consolidation, 39
environment references, creating, 133–135 flexible failover policy, 34
environments limitations, 23
creating, 132 multi-subnet, 5
package, 119 Server Message Block support, 39
projects, connecting, 132 TempDB on local disk, 34
environment variables, 119, 132 Failover Cluster Instances (FCI), 5
creating, 132–133 Failover Cluster Manager Snap-in, 24
error domain values, 148 failover policy, configuring, 34
errors, alert-processing, 249 failures, audit
events, multidimensional, 215 , 62, 63
event tracing, 215 FCI (Failover Cluster Instances), 5
Excel. See Microsoft Excel fetching, optimizing, 44
Excel 2010 renderer, 229–230 file attributes, updating, 186
Execute Package dialog box, 136 file data, application compatibility with, 11
Execute Package task, 102–103 files
updating, 122 converting to ISPAC file, 121
Execute Package Task Editor, 102–103 copying to FileTable, 80
execution objects, creating, 135–136 ragged-right delimited, 105
execution parameter values, 127 FILESTREAM, 74, 76–77
execution, preparing packages for, 135–136 enabling, 78
file groups and database files, configuring, 79
تصویر مرجع صفحهٔ ۲۷۵ فایل PDF
صفحهٔ ۲۷۶ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۷۶
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
FILESTREAM
FILESTREAM (continued) hierarchies, 208–209
FileTable, 77 arranging members in, 177, 179, 181
scalability and performance, 76 filtering, 216
file system, unstructured data storage in, 74–75 managing, 180
FileTable, 77–81 permissions inheritance, 184
creating, 80 in PowerPivot for Excel, 221
documents and files, copying to, 80 high availability (HA), 4–6, 21–40
documents, viewing, 80–81 active secondaries, 32–34
managing and securing, 81 AlwaysOn, 21–23
prerequisites, 78–79 AlwaysOn Availability Groups, 23–32
filtering, 204 AlwaysOn Failover Cluster Instances, 34–36
before importing, 204 technologies for, 21
dates, 219–220 HostRecordTTL, configuring, 36
hierarchies, 216 hybrid solutions, 3
row-level, 211
view, 244–245
visualization, 245
I
FireAlert event, 250 Image URL property, 212
FireSchedule event, 250 implicit measures, 220
Flat File source, 105–106 Import from PowerPivot template, 202
folder-level access, 139 Import from Server template, 202
Full-Text And Semantic Extractions For Search indexes
feature, 83 columnstore, 6, 41–56
full-text queries, performance, 81 varchar(max), nvarchar(max), and varbinary(max)
full-text search, 11–12 columns, 7
scale of, 81 index hints, 53–54
word breakers and stemmers, 82 initial catalog parameter, 69
initial load packages, change data processing, 112
G in-memory cache, 213
In-Memory query mode, 214
GenerateAlert event, 250 In-Memory With DirectQuery query mode, 214
geometry and geography data types, 86 in-place upgrades, 17–19
new data types, 87–89 Insert Snippet menu, 7
Getting Started window, 95–97 installation, 17
global presence, business, 5 hardware and software requirements, 16–17
grid view data viewer, 110–111 on Windows Server Core, 38
groups Insufficient CPU Resource Allocation rule, 226
data-flow, 109–110 Insufficient CPU Resources On The System rule, 226
default schema for, 58–59 Insufficient Disk Space rule, 226
guest accounts, database access with, 71 Insufficient Memory Threshold rule, 226
Integration Services, 93–139
H administration tasks, 135–139
catalog, 128–135
hardware change data capture support, 111–114
active secondaries, 32–34 Cleansing transformation, 171–172
utilization, increasing, 4 connection managers, sharing, 98–99
hardware requirements, 16 Connections Project template, 94
for migrations, 20 control flow enhancements, 101–103
HASHBYTES function, 71 data flow enhancements, 103–111
health rules, server, 226–227 data viewer, 110–111
تصویر مرجع صفحهٔ ۲۷۶ فایل PDF
صفحهٔ ۲۷۷ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۷۷
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
manual failover
Integration Services (continued) matching, 157–161
deployment models, 116–122 source data, 154
DQS integration, 171–172 knowledge bases
Execute Package Task, 102–103 composite domains, 151–153
expressions, 100 creating, 145–146
Expression Task, 101–102 defined, 143
Getting Started window, 95, 96–97 domain rules, 150–151
interface enhancements, 93–101 domains, 145–146. See also domains
New Project dialog box, 93–94 domain values, 147
operations dashboard, 138 DQS Data, 144–145
package design, 114–116 knowledge discovery, 154–157
package-designer interface, 95–96 linked domains, 153–154
package file format, 139 locking, 144, 154
packages, sorting, 100 matching policy, 157–161
parameters, 122–127 publishing, 154, 157
Parameters window, 95 reference data, 150
Project template, 94 updating, 157
scripting engine, 99 knowledge discovery, 154–157
SSIS Toolbox, 95, 97–98 domain rules, running, 155
status indicators, 101 domain value management, 156–157
stored procedure, automatic execution, 128 monitoring, 167
templates, 93 pre-processing, 155
transformations, 106–107, 141, 171–172 KPIs (key performance indicators), 208
Undo and Redo features, 100
Variables button, 95
zoom control, 95 L
Integration Services Deployment Wizard, 120 Large Objects (LOBs), 45
Integration Services Import Project Wizard, 94, 121 LEFT function, 116
Integration Services Package Upgrade Wizard, 121 legacy SQL Server instances, deploying SQL Server
Integration Services Project Conversion Wizard, 121 2012 with, 19–20
IntelliSense enhancements, 7 licensing, 15–16
invalid domain values, 148 line-of-business (LOB) re-indexing, 40
IO, reducing, 44 linked domains, 153–154
isolation, 8 Load To Connection Ratio rule, 226
ISPAC file extension, 119 LOBs (Large Objects), 45
ISPAC files local storage, 5
building, 119 logging
converting files to, 121–122 backups on secondaries, 33
deployment, 120 package execution, 137
importing projects from, 121 server-based, 137
logon dependencies, 67
K log shipping, 22, 23
Keep Unique Rows property, 212
Kerberos authentication, 57, 233 M
key performance indicators (KPIs), 208 machine resources, vertical isolation, 8
key phrases, searching on, 82–85 manageability features, 7–10
knowledge base management, 143–161 managed service accounts, 72
domain management, 143–154 MANAGE_OBJECT_PERMISSIONS permission, 139
knowledge discovery, 154–157 manual failover, 27
تصویر مرجع صفحهٔ ۲۷۷ فایل PDF
صفحهٔ ۲۷۸ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۷۸
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
mappings
mappings loading data into worksheet, 190
data source fields to domains, 154–155, 158, 172 master data management tasks, 187–192
input to output columns, 108–109 MDS database connection, 187–188
many-to-many, 179 model-building tasks, 192–194
master data management, 177. See also MDS (Master shortcut query files, 194
Data Services) MDS databases
bulk updates and export, 197 connecting to, 187–188
entity management, 177–179 upgrading, 175
in Excel, 187–196 MDS (Master Data Services), 175–198
integration management, 181–183 administration, 198
sharing data, 194 bulk updates and export, 197
Master Data Manager, 177–185 configuration, 176–177
collection management, 180–181 Configuration Manager, 175–176
entity management, 177–179 DQS integration, 195
Explorer area, 177–181 DQS matching with, 173
hierarchy management, 180 filtering data from, 188–189
Integration Management area, 181–183 Master Data Manager, 177–185
mappings, viewing, 179 MDS Add-in for Excel, 187–196
Metadata model, 197 Metadata model, 197
permissions assignment, 183–185 model deployment, 185–187
Version Management area, 183 new installations, 176
Master Data Services (MDS). See MDS (Master Data permissions assignment, 183–185
Services) publication process, 191–192
matching, 165 SharePoint integration, 197
exporting results, 165 staging process, 181–183
MDS Add-in entities, 194–196 system settings, 176–177
MDS support, 141 transactions, 198
results, viewing, 160 upgrades, 175–176
rules, 158–159 MDSModelDeploy tool, 185–186
score, 158, 169 measures, 207–208
matching data quality projects, 164–166 members
monitoring, 167 adding and deleting, 177–178
matching policy attributes, editing, 178
defining, 157–161 collection management, 180–181
mapping, 158 hierarchy management, 180
matching rule creation, 158–159 loading in Excel, 188–190
monitoring, 167 transactions, reviewing, 191
results, viewing, 160 memory allocation, 216
Similarity parameter, 159 memory management, for merge and merge join
testing, 159 transformations, 107
Weight parameter, 159 memory_node_oom_ring_buffer_recorded event, 90
Maximum Files (or Max_Files) audit option, 63 Merge Join transformation, 107
Maximum Number of Connections rule, 226 Merge transformation, 107
mdm.udpValidateModel procedure, 183 metadata, 108
MDS Add-in for Excel, 173, 175, 187–196 managing, 108–109
bulk updates and export, 197 updating, 186
data quality matching, 194–196 Metadata model, 197
filtering data, 188–190 Micorsoft Word 2010 renderer, 230
installation, 187 Microsoft Excel, 143. See also worksheets, Excel
link to, 177 data quality information, exporting to, 167
تصویر مرجع صفحهٔ ۲۷۸ فایل PDF
صفحهٔ ۲۷۹ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۷۹
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
page_freed event
Microsoft Excel (continued)
Excel 2010 renderer, 229–230
O
importing data from, 147 ODBC Destination, 104–105
MDS Add-in for Excel, 173, 187–196 ODBC Source, 104–105
PowerPivot for Excel, 218–222 On Audit Log Failure: Continue feature, 63
tabular models, analyzing in, 211–212 On Audit Log Failure: Fail Operation feature, 63
Microsoft Exchange beyond-relational functionality, On Audit Shut Down Server feature, 62
76 online indexing, 7
Microsoft Office Compatibility Pack for Word, Excel, online operation, 40
and PowerPoint, 230 operations management, 130–131
Microsoft Outlook beyond-relational functionality, operations reports, 137
76 outages
Microsoft PowerPoint, Power View exports, 246 planned, 18
Microsoft.SqlServer.Dts.Pipeline namespace, 107 systemwide, 62, 68
Microsoft trustworthy computing initiative, 10 overlapping clusters of records, 160, 165
middle-tier authentication, 66
migration strategies, 19–20
high-level, side-by-side, 20
P
mirroring package connections, converting connection
asynchronous, 21–22 managers to, 99
synchronous, 22 package deployment model, 116–117
Model.bim file, 203 package design
model deployment, 185–186 expressions, 115–116
Model Deployment Wizard, 185 variables, 114–115
model permissions object tree, 184 package execution, 136
MOLAP engine, 215 capturing data during, 137
mount points, 39 logs, 137
multidimensional events, 215 monitoring, 136
multidimensional models, 215 preparing for, 135–136
multidimensional server mode, 199–201 reports on, 137
multisite clustering, 34 scheduling, 136
multisubnet clustering, 34–35 package objects, expressions, 100
multiple IP addresses, 35 package parameters, 124
multitenancy, 8 prefix, 125
packages
change data processing, 112
N connection managers, sharing, 98–99
NEAR operator, 12 deploying, 120, 185–186
network names of availability groups listeners, 28 entry-point, 119–120
New Availability Group Wizard, 29 environments, 119
Specify Replicas page, 30 file format, 139
New Project dialog box (Integration Services), 93–94 legacy, 121–122
“New Spatial Features in SQL Server 2012” location, specifying, 102
whitepaper, 89 preparing for execution, 135–136
nonoverlapping clusters of records, 160, 165 security of, 139
nonshared storage, 26 sorting by name, 100
nontransactional access, 78 storing in catalog, 119
enabling at database level, 78–79 validating, 126, 135
normalization, 146 page_allocated event, 90
numeric data types, filtering on, 244 page_freed event, 90
تصویر مرجع صفحهٔ ۲۷۹ فایل PDF
صفحهٔ ۲۸۰ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۸۰
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
Parameterizing the Execute SQL Task in SSIS link
Parameterizing the Execute SQL Task in SSIS link, 97 DAX, 222–224
parameters, 95, 122–127 Design tab, 219
bindings, mapping, 102–103 installation, 218
configuration, converting to, 122 Mark As Date Table button, 219
configuring, 122 model enhancements, 221–222
environment variables, associating, 119 Sort By Column button, 219
execution parameter value, 127 usability enhancements, 218–221
in Expression Builder, 102 PowerPivot for SharePoint, 224–227
implementing, 124–125 data refresh configuration, 227
package-level, 120, 122, 124 disk space usage, 225
post-deployment values, 125–126 installation, 224
project-level, 120, 122–123 management, 224–227
properties for, 123 server health rules, 226–227
scope, 119 workbook caching, 225
server default values, 126–127 PowerPivot for SharePoint server mode, 199–201
parameter value, 123 PowerPivot workbooks
parsing composite domains, 152 BI Semantic Model Connection type, adding, 233
partitioning new data, 47–49 as Power View data source, 233
Partition Manager, 209–210 Power View design environment, opening, 234
partitions, 209–210 Power View, 229, 232–246
number supported, 7 arranging items, 238
switching, 48–49 browser, 232
patch management, 40 cards, 238
Windows Server Core installation and, 36 charts, 237
performance current view display, 236
data warehouse workload enhancements, 6 data layout, 232
new features, 6–7 data sources, 232, 233
query, 41, 44–45 data visualization, 237–241
permissions design environment, 234–237
on ALTER ANY SERVER ROLE, 72 display modes, 245–246
on CREATE SERVER ROLE, 72 filtering data, 243–245
delegation, 139 Filters area, 244
management, 139 highlighting values, 242
on master data, 183–185 layout sections, 236
on SEARCH PROPERTY LIST, 72 moving items, 237
SQL Server Agent, 231 multiple views, 241–242
updating, 186 PowerPoint export, 246
per-service SIDs, 72 printing views, 246
perspectives, 209, 220 saving files, 237
in PowerPivot for Excel, 222 tiles, 239
pivot tables, 218–222, 224–227 views, creating, 241–242
numeric columns, 221 pretty-printing, 139
Pivot transformation, 106 primary database servers, offloading tasks from, 23,
planned outages for upgrades, 18 32–34
Policy-Based Management, 57 Process Full command, 215
portability, database, 9 Process permissions, 211
PowerPivot, 42 profiling notifications, 169
PowerPivot for Excel, 218–222 programmability enhancements, 11–12, 73–90
Advanced tab, 220 project configurations, adding parameters, 123
Data View and Diagram View buttons, 218
تصویر مرجع صفحهٔ ۲۸۰ فایل PDF
صفحهٔ ۲۸۱ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۸۱
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
Resource Governor
project deployment model, 117 survivorship results, 165
catalog, project placement in, 128 Recovery Advisor visual timeline, 6
features, 118–119 recovery times, 5
workflow, 119–122 reference data, 150
project parameters, 123 for composite domains, 152
prefix, 125 reference data service (RDS), 150, 167–168
Project.params file, 98 ReferenceType property, 102
projects refid attribute, 139
environment references, 133–135 regulatory compliance, 62–67
environments, connecting, 132 relational engine, columnstore indexes, 6
importing, 121 relationships, table
previous versions, restoring, 131 adding, 206
validating, 126, 135 in PowerPivot for Excel, 221
property search, 81–82 viewing, 205
provisioning, security and role separation, 72 relative environment references, 133–135
publication process, 191–192 Remote BLOB Store (RBS), 75
renderers, 229–230
Q REPLACENULL function, 116
Report Builder, 232
qualifier characters in strings, 105 Report Designer, 232
queries Reporting Services, 229–250
execution plan, 52 data alerts, 246–250
forcing columnstore index use, 53–54 Power View, 232–246
performance, 41, 44–45 renderers, 229–230
small look-up, 48 scalability, 231
star join pattern, 47 SharePoint integrated mode, 229, 232
tuning, 41. See also columnstore indexes SharePoint shared service architecture, 230–232
query modes, 214 SharePoint support, 230–231
query processing Reporting Services Configuration Manager, 231
batch-mode, 45 Reporting Services Shared Data Source (RSDS) files,
in columnstore indexes, 47 233
enhancements in, 6 reports. See also Reporting Services
authentication for, 231
R data alerts, 246–250
design environment, 234–237
ragged-right delimited files, 105 DOCX files, 230
raster data, 87 fields, 235–236
RBS (Remote BLOB Store), 75 filtering data, 243–245
RDLX files, 232, 237 RDLX files, 232, 237
RDS (reference data service), 150 reporting properties, setting, 220
subscribing to, 167–168 sharing, 237
Read And Process permissions, 211 table and column properties, 212–213
reader/writer contention, eliminating, 32 tables, 235
Read permissions, 210 views, 234, 241–242
records XLSX files, 229–230
categorization, 162 report server databases, 231
confidence score, 150, 162, 169 Required parameter property, 123
filtering, 66–67 resilience, audit policies and, 62–65
matching results, 165 Resolve References editor, 108–109
matching rules, 158–159 Resource Governor, 8
تصویر مرجع صفحهٔ ۲۸۱ فایل PDF
صفحهٔ ۲۸۲ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۸۲
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
resource_monitor_ring_buffer_record event
resource_monitor_ring_buffer_record event, 90 secondary replicas
resource pool affinity, 8 backups on, 33–34
resource pools connection modes, 27, 33
number, 8 moving data to, 27
schedules, 8 multiple, 23, 25, 25–26
Resource Usage events, 215 read-only access, 33
Restore Invalid Column References editor, 108 SQL Server 2012 support for, 4
restores, visual timeline, 6, 39–40 synchronous-commit availability mode, 26
role-based security, 59 securables, permissions on, 60
role separation during provisioning, 72 security
roles, user-defined, 60–61 Active Directory integration, 71–72
role swapping, 26 auditing improvements, 62–67
rolling upgrades, 40 of Contained Database Authentication, 70–71
Row Count transformation, 106–107 cryptography, 71
row delimiters, 105 database authentication improvements, 67–71
row groups, 45 database roles, 210–211
Row Identifier property, 212, 213 manageability improvements, 58–61
row-level filters, 211 new features, 10–11
row store storage model, 42–43 during provisioning, 72
row versioning, 32 SharePoint integration, 71–72
RSDS (Reporting Services Shared Data Source) files, of tabular models, 210
233 Windows Server Core, 36
RSExec role, 232 security manageability, 58–61
RsReportDesigner.config file, 230 default schema for groups, 58–59
RsReportServer.config file, 230 user-defined server roles, 60–62
alerting configuration settings, 250 segments of data, 45
runtime, constructing variable values at, 101 Select New Scope dialog box, 115
self-service options, 229
S data alerts, 246–250
Power View, 232–246
scalability semantickeyphrasetable function, 85
new features, 6–7 semantic language statistics database
Windows Server 2008 R2 support, 7 installing, 84
scatter charts in Power View, 239 semantic search, 11, 82–85
schema rowsets, 216 configuring, 83–84
schemas key phrases, finding, 85
default, 58 similar or related documents, finding, 85
management, 58 semanticsimilaritydetailstable function, 85
SCONFIG, 37 semanticsimilaritytable function, 85
scripting engine (SSIS), 99 Sensitive parameter property, 123
search separation of duties, 59–60
across data formats, 73–74, 76 Server Audit Specification objects, 62
Customizable Near operator, 82 server-based logging, 137
full-text, 81–82 Server + Client Access License, 15
of structured and unstructured data, 11 Server Core. See Windows Server Core
property, 81–82 Server Message Block (SMB), 39
semantic, 11 server roles
statistical semantic, 82–85 creating, 60–61
SEARCH PROPERTY LIST, permissions on, 72 fixed, 60
تصویر مرجع صفحهٔ ۲۸۲ فایل PDF
صفحهٔ ۲۸۳ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۸۳
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
SQL Server Audit
server roles (continued) spatial data, 86–90
membership in other server roles, 61 circular arc segments, 87–89
sysadmin fixed, 72 index improvements, 89
user-defined, 60–62 leveraging, 86
servers performance improvements, 90
Analysis Services modes, 199–201 types, 86–87
configuration, 37 types improvements, 89
defaults, configuring, 126 sp_audit_write procedure, 63
managing, 215–216 Speller, 162
server health rules, 226–227 enabling, 146
shutdown on audit, 62–63 sp_establishId procedure, 66
SHA-2, 71 spherical circular arcs, 87–89
shared data sources, for Power View, 233 sp_migrate_user_to_contained procedure, 70
shared service applications, 231 SQLAgentUserRole, 232
configuration, 231–232 SQL Azure and SQL Server 2012 integration, 9
shared storage, 26 SQL Azure Data Sync, 9
SharePoint SQLCAT (SQL Server Customer Advisory Team), 96
alerting configuration settings, 250 SQL Server 2008 R2, 3, 4
backup and recovery processes, 231 PowerPivot, 42
Create Alert permission, 247 security capabilities, 57
MDS integration, 197 SQL Server 2012
PowerPivot for SharePoint, 224–227 32-bit and 64-bit editions, 17
Reporting Services feature support, 230–231 Analysis Services, 199–217
security modules, 71 beyond-relational enhancements, 73–90
service application configuration, 231–232 BI Semantic Model (BISM) schema, 217
Shared Service Application pool, 231 capabilities, 3
shared service applications, 229 Cloud Ready Information Platform, 3
shared service architecture, 230–232 data and services ecosystem, 74–75
SharePoint Central Administration, 231 Data Quality Services, 141–173
shortcut query files, 194 editions, 12–15
side-by-side migrations, 19–20 hardware requirements, 16
SIDs, per-service, 72 hybrid solutions, 3
slicers, 243 licensing, 15–16
sliding-window scenarios, 7 Master Data Services, 175–198
snapshot isolation transaction level, 32 migration, 19–20
snippet picket tooltip, 7 new features and enhancements, 4–12
snippets, inserting, 7 PowerPivot for Excel, 218–222
software requirements, 16–17 PowerPivot for SharePoint, 224–227
Solution Explorer prerequisites for Server Core, 37–38
Connections Manager folder, 98 programmability enhancements, 73–90
packages, sorting by name, 100 Reporting Services, 229–250
Project.params file, 98 security enhancements, 57–72
Sort By Column dialog box, 219 software requirements, 16–17
source data upgrades, 17–19
assessing, 156 SQL Server Agent, configuring permissions, 231
cleansing, 161–164 SQL Server Analysis Services (SSAS), 199. See
mapping to domains, 154–155, 158, 161–162, also Analysis Services
164 SQL Server Audit, 57. See also auditing
matching, 164–166
for Power View, 233
تصویر مرجع صفحهٔ ۲۸۳ فایل PDF
صفحهٔ ۲۸۴ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۸۴
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
SQL Server Configuration Manager
SQL Server Configuration Manager nontransactional access, enabling, 78–79
FILESTREAM, enabling, 78 operations reports, 137
Startup Parameters tab, 10 Recovery Advisor, 6
SQL Server Customer Advisory Team (SQLCAT), 96 server defaults, configuring, 126
SQL Server Database Engine server roles, creating, 60–61
Deploy Database To SQL Azure wizard, 9 staging process, 181–183
scalability and performance enhancements, 6–7 collections and, 183
SQL Server Data Tools (SSDT). See SSDT (SQL Server errors, viewing, 182
Data Tools) transaction logging during, 183
SQL Server Extended Events, 66, 90, 215 Standard edition of SQL Server 2012, 13–14
SQL Server Installation Wizard, 17 startup
SQL Server instances management, 10
hosting of, 26 times, 5
maximum number, 39 statistical semantic search, 82–85
replica role, displaying, 31 stg.name_Consolidated table, 181
specifying, 30 stg.name_Leaf table, 181, 197
TCP/IP, enabling, 142 stg.name_Relationship table, 181
SQL Server Integration Services Expression stg.udp_name_Consolidated procedure, 182
Language, 101 stg.udp_name_Leaf procedure, 182
new functions, 116 stg.udp_name_Relationship procedure, 182
SQL Server Integration Services Product Samples storage
link, 97 column store, 42. See also columnstore indexes
SQL Server Integration Services (SSIS), 93. management, 73
SQL Server Management Studio (SSMS). See SSMS row store, 42–43
(SQL Server Management Studio) shared vs. nonshared, 26
SQL Trace audit functionality, 62 stored procedures, 182
SSDT (SQL Server Data Tools), 93, 201–202, 213 stretch clustering, 34
building packages, 119–120 string data types
deployment process, 120 filtering, 244
import process, 121 language, 146
project conversion, 121–122 spelling check, 146
ssis_admin role, catalog permissions, 139 storage, 215
"SSIS Logging in Denali" (Thompson), 137 structured data, 11, 73
SSIS Toolbox, 95, 97–98 management, 74
Common category, 97–98 Structure_Type columns, 216
Destination Assistant, 103–104 subnets, geographically dispersed, 5
Expression Task, 101–102 survivorship results, 165
Favorites category, 97–98 synchronization, 31
Source Assistant, 103–104 synchronous-commit availability mode, 26, 27
SSMS (SQL Server Management Studio) synchronous database mirroring, 22
audit, creating, 64–65 synchronous data movement, 24
availability group configuration, 24 synchronous secondaries, 4
built-in reports, 137 synonyms, 146–149, 156, 163, 173
columnstore indexes, creating, 50 syntax error checking, 146
Contained Database Authentication, enabling, sysadmin fixed server role, 72
68–69 Sysprep, 17
converting packages, 122 sys.principal table, 59
Create A New Availability Group Wizard, 28 system variables, accessing, 102
environments, creating, 132 systemwide outages, 62
FileTable documents, viewing, 80–81 database authentication issues, 68
manageability features, 7
تصویر مرجع صفحهٔ ۲۸۴ فایل PDF
صفحهٔ ۲۸۵ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۸۵
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
uptime
T tiles in Power View, 239
TOKENCOUNT function, 116
Table Detail Position property, 213 TOKEN function, 116
Table Import Wizard, 203, 204 transaction logging
tables on secondaries, 33–34
calculated columns, 207 during staging process, 183
columnstore indexes for, 48 transactions, 198
maintenance, 47 annotating, 198
partitions, 209–210 reviewing, 191
pivot tables, 218–222, 224–227 Transact-SQL
relationships, 205–206. See also relationships, audit, creating, 65
table audit log, stack frame information, 63
reporting properties, 212–213 code snippet template, 8
tabular models, 203–214 columnstore indexes, creating, 51–52
access to, 210–211 Contained Database Authentication, enabling, 69
analyzing in Excel, 211–212 debugger, 7
calculated columns, 207 FILESTREAM file groups and database files,
Conceptual Schema Definition Language configuring, 79
extensions, 217 nontransactional access, enabling, 79
Conceptual Schema Definition Language, server roles, creating, 61
retrieving, 216 user-defined audit event, 65–66
database roles, 210–211 transformations, 106–107
DAX, 222–224 Transparent Data Encryption (TDE), 57
deployment, 214, 222 trickle-feed packages, 112
DirectQuery mode, 213 trustworthy computing initiative, 10
hierarchies, 208–209 TXT files, extracting data, 105
importing data, 204 Type columns, 216
key performance indicators, 208
measures, 207–208
model designer, 205–206 U
partitions, 209–210 Unified Dimensional Model (UDM) schema, 217
perspectives, 209 UNION ALL query, 49
query modes, 214 unstructured data, 11, 73
relationships, 205–206 ecosystem, 74–75
reporting properties, 212–213 management, 74
schema rowsets, 216 raster data, 87
Table Import Wizard, 204 semantic searches, 11
tutorial, 203 storage on file system, 74, 76–77
workspace database, 203–204 updates, appending new data, 48
tabular server mode, 199–201 UpdateSchedule event, 250
task properties, setting directly, 125 Upgrade Database Wizard, 176
TCP/IP, enabling on SQL Server instance, 142 upgrades, 17–19
TDE (Transparent Data Encryption), 57 control of process, 18, 20
TempDB database, local storage, 5, 34 high-level in-place strategy, 18–19
term-based relations, 149. See also domains; domain rolling, 40
values version support, 17
testing tabular models, 211–212 uptime. See also availability
Thomson, Jamie, 137 maximizing, 4–6
thread pools, 216 Windows Server Core deployment and, 6
tile containers, 243–244
تصویر مرجع صفحهٔ ۲۸۵ فایل PDF
صفحهٔ ۲۸۶ فایل PDF — نمایهٔ کتاب
نمایهٔ فنی — صفحهٔ ۲۸۶
نام محصولات، فرمانها، اشیای پایگاهداده، گزینههای رابط کاربری و اصطلاحات تخصصی برای قابلیت جستوجوی دقیق به زبان اصلی حفظ شدهاند؛ عنوان بخش و راهنمای استفاده به فارسی ارائه شده است. شمارههای کنار هر مدخل، شمارهٔ صفحهٔ چاپی کتاب هستند.
user accounts, default schema for
user accounts, default schema for, 58–59 Windows Server 2008 R2, scalability, 7
user databases Windows Server Core
user authentication into, 9 prerequisites for, 37–38
user information in, 68 SCONFIG, 37
user-defined audit events, 63, 65–66 SQL Server 2012 installation on, 5, 17, 36–38
user-defined roles, 60–61 SQL Server feature support, 38
server roles, 60–62 Windows Server Failover Cluster (WSFC), 5, 26
users deploying, 24
authentication, 9 Word 2010 renderer, 230
migrating, 70 word breakers and stemmers, 82
workbooks, Excel
V caching, 225
data refreshes, 227
validation, 135 workflow, adding Expression Tasks, 101
varbinary max columns, 74 workloads, read-based, 47
variables worksheets, Excel
adding to packages, 115 creating data in, 192
dynamic values, assigning, 101–102 data quality matching, 195–196
in Expression Builder, 102 filtering data from MDS, 188–189
scope assignment, 115 loading data from MDS, 188–190
vector data types, 86–87 publishing data to MDS, 191–192
vendor-independent APIs, 75 refreshing data, 190
vertical isolation of machine resources, 8 workspace databases, 203–204
VertiPag compression algorithm, 44 backup settings, 203
VertiPaq mode, 199, 215 hosts, 203
view filters, 244–245 names, 203
virtual accounts, 72 properties, 203
virtual network names of availability groups, 28 query mode, 214
visualization filters, 245 retention settings, 203
Visual Studio 2010 Tools for Office Runtime, 218 WSFC (Windows Server Failover Cluster), 5, 24, 26
Visual Studio, Integration Services environment, 93
Visual Studio Tools for Applications (VSTA) 3.0, 99
vulnerabilities reported to NIST, 10
X
XLSX files, 229–230
W XML files
annotations, 139
Web edition of SQL Server 2012, 15 attributes, 139
Windows 32 Directory Hierarchy file system, 74 refid attribute, 139
Windows Authentication, 71 XML For Analysis (XMLA) create object scripts, 215
Windows Azure Marketplace, 167–168
Windows file namespace support, 11
Windows groups, default schema for, 58–59
Z
Windows PowerShell zero-data-loss protection, 23
MDS administration, 198
PowerPivot for SharePoint configuration cmdlets,
224
تصویر مرجع صفحهٔ ۲۸۶ فایل PDF
صفحهٔ ۲۸۷ فایل PDF
دربارهٔ نویسندگان
Ross Mistry
Ross Mistry نویسندهای پرفروش، سخنران عمومی، مروج فناوری، حامی جامعهٔ فنی، معمار ارشد سازمانی در Microsoft و MVP پیشین SQL Server است.
Ross برای بسیاری از مدیران ارشد سازمانی مشاور و راهنمای مورد اعتماد بوده و مسئولیت تدوین موفق نقشههای راه فناوری، از جمله طراحی و پیادهسازی راهکارهای پیچیده برای برخی از بزرگترین شرکتهای جهان، را بر عهده داشته است. او در سازمانهای متعددی از فهرست Fortune 500 از جمله Network Appliance، McAfee، The Sharper Image، CIBC، Wells Fargo و Intel نقش معمار راهبر را ایفا کرده است. حوزههای تخصصی او سکوی داده، بهرهوری کسبوکار، ارتباطات یکپارچه، زیرساخت هستهای و ابر خصوصی هستند.
Ross در جامعهٔ فناوری، بهویژه جامعهٔ Silicon Valley، حضوری فعال دارد. او حساب Twitter مربوط به SQL Server را بهصورت مشترک مدیریت میکند و در همایشهایی مانند SQL PASS Community Summit، SQL Connections و SQL Bits سخنرانی دارد. او نویسندهٔ مجموعههای فنی است و مقالهها و Whitepaperهای متعددی برای Microsoft، SQL Server Magazine و TechTarget نوشته است. از کتابهای تازهٔ او میتوان به Windows Server 2008 R2 Unleashed و SQL Server 2012 Management and Administration, Second Edition اشاره کرد.
شناسهٔ او در Twitter، @RossMistry، و دامنهٔ معرفیشده برای تماس، rossmistry.com است.
Stacia Misner
Stacia Misner مشاور، مدرس، راهنما و نویسندهای است که از سال ۱۹۹۹ در راهکارهای هوش تجاری (Business Intelligence یا BI) تخصص دارد. او در این مدت چندین کتاب دربارهٔ BI نوشته یا در نگارش آنها مشارکت داشته است. Stacia از طریق Data Inspirations خدمات مشاوره و آموزش سفارشی ارائه میکند و بهطور منظم در همایشهای جامعهٔ SQL Server سخنرانی دارد. او تجربههای خود در BI را در دامنهٔ blog.datainspirations.com مینویسد و با شناسهٔ @StaciaMisner فعالیت میکند.
تصویر مرجع صفحهٔ ۲۸۷ فایل PDF
صفحهٔ ۲۸۸ فایل PDF
نظر شما دربارهٔ این کتاب چیست؟
مایلیم نظر شما را بشنویم. برای شرکت در نظرسنجی کوتاه اینترنتی، نشانی متنی زیر در نسخهٔ اصلی ارائه شده است:
microsoft.com/learning/booksurvey
به ناشر بگویید این کتاب تا چه اندازه نیازهای شما را برآورده میکند، چه بخشهایی مؤثر عمل میکنند و چه چیزهایی را میتوان بهتر کرد. بازخورد شما به بهبود پیوستهٔ کتابها و منابع آموزشی کمک میکند.
از مشارکت شما پیشاپیش سپاسگزاریم.
Microsoft Press
تصویر مرجع صفحهٔ ۲۸۸ فایل PDF