Microsoft SQL Server 2008 R2 Dokumentacja Strona 66
- Strona / 236
- Spis treści
- BOOKMARKI
Oceniono. / 5. Na podstawie oceny klientów
46 CHAPTER 3 Data-Tier Applications
4. In the Project Template pane, select Data-Tier Application.
5. Specify the name, location, and solution name for the data-tier application, as shown
in Figure 3-2, and click OK.
FIGURE 3-2 Selecting the Data-Tier Application project template in Visual Studio 2010
6. Select Project, and then click Add New Item to add and create a database object based
on the Data-Tier Application project template. Some of the database objects included
in the template are scalar-valued function, schema, table, index, login, stored proce-
dure, user, user-dened table type, view, table-valued function, trigger, user-dened
data type, database role, data generation plan, and inline function.
Figure 3-3 illustrates the syntax for creating a sample Employees table schema for a
data-tier application in Visual Studio 2010. The Solution Explorer pane also includes the
other schema objects—specically the tables associated with the data-tier application.
- Database Administration 1 1
- —Ross MistRy 3
- —stacia MisneR 3
- Contents at a Glance 5
- Contents 7
- viii Contents 8
- Contents ix 9
- x Contents 10
- Contents xi 11
- xii Contents 12
- Contents xiii 13
- Acknowledgments 15
- xvi 16
- Introduction 17
- Pre-Release Software 18
- Support for This Book 19
- We Want to Hear from You 19
- Database 21
- Administration 21
- SQL Server 2008 R2 Editions 23
- Upload collection 27
- Premium Editions 32
- Core Editions 32
- Specialized Editions 33
- Hardware Requirements 34
- Software Requirements 35
- The In-Place Upgrade 36
- Side-by-Side Migration 38
- Multi-Server Administration 41
- REAL WORLD 43
- UCP Prerequisites 45
- Creating a UCP by Using SSMS 46
- UCP Post-Installation Steps 49
- Windows PowerShell 52
- Connecting to a UCP 53
- The Policy Tab 54
- The Security Tab 57
- The Data Warehouse Tab 59
- 1 year, or 2 years 60
- Data-Tier Applications 61
- Supported SQL Server Objects 64
- Visual Studio 2010 65
- Management Studio 69
- Data-Tier Application Wizard 72
- High Availability and 83
- Virtualization Enhancements 83
- Windows Server 2008 R2 86
- Server 2008 R2 86
- Guest Failover Clustering 87
- Real World 88
- /cc732035(WS.10).aspx 89
- Enabling CSV 96
- Click Next 101
- Consolidation and Monitoring 105
- SQLInstance01 106
- Monitoring 109
- Development 127
- Business Intelligence 127
- Scalable Data Warehousing 129
- Processing Architecture 130
- The Multi-Rack System 130
- The Data Rack 131
- The Control Rack 132
- The Control Node 132
- The Landing Zone Node 134
- The Backup Node 134
- The Management Node 134
- The Compute Node 134
- Hub-and-Spoke Architecture 135
- Shared Nothing Architecture 135
- Replicated Strategy 136
- Distributed Strategy 136
- DDL Extensions 137
- CREATE DATABASE 138
- CREATE TABLE 138
- Data Types 140
- Query Processing 141
- Data Load Processing 141
- Monitoring and Management 142
- Integration Services 143
- Reporting Services 143
- Master Data Services 145
- Master Data Manager 148
- Model Objects 149
- Product hierarchies 150
- Master Data Maintenance 151
- Business Rules 152
- Business rule validation 153
- Transaction Logging 154
- Importing Master Data 155
- Exporting Master Data 156
- Versions 157
- Security 158
- A user’s model permissions 159
- Programmability 162
- Matching Functions 163
- Complex Event Processing 165
- StreamInsight Highlights 166
- Data Structures 167
- The CEP Server 167
- Input Adapters 168
- Output Adapters 169
- Query Instances 169
- Deployment Models 169
- Hosted Assembly 169
- Standalone Server 169
- Event Types 170
- Adapters 171
- Query Templates 174
- The Event Stream Object 174
- The QueryTemplate Object 174
- Projection 175
- Filtering 175
- Event Windows 176
- FIGURE 8-3 Hopping windows 177
- Aggregations 179
- Grouping 180
- User-dened Functions 181
- Query Template Binding 182
- The Query Binder Object 182
- The Query Object 183
- Diagnostic Views 183
- Enhancements 185
- Aggregation 188
- Aggregation of an aggregation 189
- Page Numbering 190
- Read/Write Report Variable 190
- Layout Control 191
- Pagination Properties 192
- Data Synchronization 193
- Text Box Orientation 194
- Data Bars 195
- Sparklines 196
- Indicators 196
- Indicator types 197
- Reusability 198
- Shared Datasets 199
- Cache Refresh 199
- Report Parts 200
- Reusability CHAPTER 9 181 201
- Atom Data Feed 202
- Edit Sessions 203
- The Report Part Gallery 203
- Report Manager Improvements 204
- Report Viewer 205
- The report menu 205
- Report Viewer Improvements 206
- Improved Browser Support 206
- RDL Sandboxing 206
- RS Utility Scripting 207
- Self-Service Analysis with 209
- PowerPivot 209
- Modications to Excel 210
- Data Sources 211
- Linked Tables 213
- Copying and Pasting 213
- Data Preparation 213
- Relationships 214
- PowerPivot Reports 216
- PivotTables 216
- PowerPivot data 216
- Cube Functions 217
- The CUBEVALUE function 218
- Data Analysis Expressions 219
- Calculated Columns 219
- Measures 219
- DAX Functions 220
- Architecture 221
- The PowerPivot System Service 222
- The PowerPivot Database 223
- The PowerPivot Web Service 223
- Content Management 224
- The PowerPivot Gallery 224
- The Data Feed Library 225
- Data Refresh 225
- Linked Documents 225
- About the Authors 235
- What do 236
© 2020, manymanuals.pl. Wszelkie prawa zastrzeżone. | 0.037 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Komentarze do niniejszej Instrukcji