Microsoft® SQL Server® 2012 Bible
7 Chapter 1: The World of SQL Server 1 Database Mail The Database Mail component enables SQL Server to send mail to an external ...
8 Part I: Laying the Foundations SSAS The Analysis Services service hosts two key components of the BI toolset: Online Analytica ...
9 Chapter 1: The World of SQL Server 1 Data Mining Viewing data from cubes or even relational queries can reveal the obvious tre ...
10 Part I: Laying the Foundations FIGURE 1-2 SQL Server Management Studio Query Interface. SQL Profiler/Trace/Extended Events SQ ...
11 Chapter 1: The World of SQL Server 1 Database Engine Tuning Advisor The Database Engine Tuning Advisor analyzes a batch of qu ...
12 Part I: Laying the Foundations Editions of SQL Server 2012 The edition layout of SQL Server has changed again with this relea ...
13 Chapter 1: The World of SQL Server 1 ■ (^) Windows PowerShell ■ (^) Database Tuning Advisor enhancements ■ (^) New Dynamic Ma ...
14 Part I: Laying the Foundations Summary SQL Server 2012 has created many new opportunities for building some incredible scalab ...
15 CHAPTER 2 Data Architecture IN THIS CHAPTER Understanding Pragmatic Data Architecture Evaluating Six Objectives of Informatio ...
16 Part I: Laying the Foundations What’s New with Data Architecture in SQL Server 2012 SQL Server 2012 introduces a couple of ne ...
17 Chapter 2: Data Architecture 2 If the data is to be made readily available in the future, then current designs must be fl ex- ...
18 Part I: Laying the Foundations Extensibility The Information Architecture Principle states that the information must be readi ...
19 Chapter 2: Data Architecture 2 domain. In the case of the foreign key, the domain is the list of values in the related primar ...
20 Part I: Laying the Foundations Performance is enabled in the database design and development by ensuring the following: ■ A w ...
21 Chapter 2: Data Architecture 2 Planning Data Stores The enterprise data architect helps an organization plan the most effecti ...
22 Part I: Laying the Foundations ■ (^) Reference data stores are primarily read-only and store generic data required by the org ...
23 Chapter 2: Data Architecture 2 work around, not with, the database schema; poor performance because the database engine is de ...
24 Part I: Laying the Foundations FIGURE 2-2 Smart Database Design is the premise that an elegant physical schema makes the data ...
25 Chapter 2: Data Architecture 2 Agile Modeling Agile development is popular for good reasons. It gets the job done quickly and ...
26 Part I: Laying the Foundations However, queries cannot overcome the errors of a poor physical schema and won’t solve the perf ...
«
1
2
3
4
5
6
7
8
9
10
»
Free download pdf