Index
A
- ACID / The need for big data platforms
- Add New Domain Value button / DQS versus T-SQL
- AdventureWorks database / New T-SQL analytical functions
- All Validations / Validating a project or package
- ALTER DATABASE command / Using availability groups
- AlwaysOn Availability Groups / Enterprise Edition
- Analysis Services
- using, with xVelocity engine / Tabular model database
- Extended Events / Extended Events for Analysis Services
- Analysis Services (SSAS) / Navigating the Installation Process
- Analysis Services Tabular Project / Creating a tabular model database
- availability groups
- about / Availability groups
- restrictions / Availability group restrictions
- advantages / Availability group advantages
- using / Using availability groups
B
- big data
- about / Big data and Hadoop: horses for courses
- velocity / What is big data?
- volume / What is big data?
- variability / What is big data?
- big data platforms
- need for / The need for big data platforms
- BISM
- Books Online (BOL) / Navigating the Installation Process
- Business Intelligence Developer Studio (BIDS) / Navigating the Installation Process
- Business Intelligence Edition
- about / Business Intelligence Edition
C
- cancel command / Canceling
- CAPEX / SQL Azure: SQL Server in the cloud
- CDC / Change Data Capture support
- CDC, components
- CDC Control Task / Change Data Capture support
- CDC Source / Change Data Capture support
- CDC Splitter / Change Data Capture support
- CDC Source / Change Data Capture support
- CDC Splitter / Change Data Capture support
- CentOS / About Hive
- Cleanse screen / Coupling rules to data: the Data Quality Project
- client
- about / Client
- cloud / Measure twice, cut once
- Cloudera / Getting started with Hadoop
- Cloudera Demo VM / Getting started with Hadoop
- clustered primary index / About Hive
- clustering / Mirroring, clustering and availability groups
- ColumnStore feature / Is SQL Server redundant?
- columnstore indexes
- about / Columnstore indexes
- creating / Creating a columnstore index
- ColumnStore Indexes / Enterprise Edition
- CompatibilityLevel property / Using scalable string storage
- CONCAT() function
- about / CONCAT
- configuration option, Distributed Replay
- about / Configuration
- SequencingMode / Configuration
- StressScaleGranularity / Configuration
- ThinkTimeScale / Configuration
- ThreadsPerClient / Configuration
- Configure ADO.NET Manager window / Shared connection managers
- Configure SSIS Logs dialog / Package execution logs
- connection managers
- about / Shared connection managers
- sharing / Shared connection managers
- adding, at package level / Adding a connection manager at the package level , Changing the scope of a connection manager
- scope, changing / Changing the scope of a connection manager
- connection Managers
- scope, changing / Changing the scope of a connection manager
- Connection Managers tab / Changing the scope of a connection manager
- contained databases
- about / Contained databases
- partially contained database, creating / Making an existing database partially contained
- logins, migrating / Migrating your logins to a contained database
- security holes / Contained database security
- Control / SQL Azure and the future of databases
- controller
- about / Controller
- conversion functions
- about / Conversion functions
- TRY_PARSE / TRY_PARSE, PARSE
- IIF / IIF
- Copy Column task / Setting up a Data Tap
- Create a domain button / DQS versus T-SQL
D
- Data Alert
- about / Data Alerts
- Data Alert Designer / Data Alerts
- Data Alert Manager / Data Alerts
- Database Engine Configuration screen / Navigating the Installation Process
- Database Owner (dbo) / Default schemas for groups
- database projects
- creating, from SQL Server Data Tools / Creating database projects
- Data Flow link / Setting up a Data Tap
- Data Flow Task tab / Setting up a Data Tap
- Data Quality Project
- about / Coupling rules to data: the Data Quality Project
- creating / Coupling rules to data: the Data Quality Project
- invalid records, identifying / Identifying invalid records and columns
- columns, identifying / Identifying invalid records and columns
- T-SQL / DQS versus T-SQL
- Data Quality Projects tab / Using Data Quality Services
- Data Quality Services (DQS) / Navigating the Installation Process
- data tap
- about / Data taps, Setting up a Data Tap
- setting up / Setting up a Data Tap
- DATEFROMPARTS / DATEFROMPARTS
- DATETIMEFROMPARTS / DATETIMEFROMPARTS
- Datetime functions
- about / Datetime functions
- EOMONTH / EOMONTH
- DATEFROMPARTS / DATEFROMPARTS
- TIMEFROMPARTS / TIMEFROMPARTS
- DATETIMEFROMPARTS / DATETIMEFROMPARTS
- DATETIMEOFFSETFROMPARTS / DATETIMEOFFSETFROMPARTS
- DATETIMEOFFSETFROMPARTS / DATETIMEOFFSETFROMPARTS
- dbo.sysssislog / View the results of logging
- deployment models
- project / Deployment models
- package / Deployment models
- disadvantages / Deployment models
- advantages / Deployment models
- package, validating / Validating a project or package
- project, validating / Validating a project or package
- SSISDB, querying / Querying the SSISDB
- DeploymentMode property / Determining a previously installed model
- deprecated features
- Scatter Plot / Deprecated feares
- Chart Data Viewers / Deprecated feares
- Histogram / Resources
- Developer Edition / Developer Edition
- DFS / About Hadoop
- Differential backups / Availability group restrictions
- Dimension Designer / Using scalable string storage
- DirectQuery mode / The xVelocity tabular engine mode
- Disaster Recovery (DR) / Availability group advantages
- Distributed Replay
- terminology / Terminology
- about / Distributed Replay
- trace file / Trace file
- intermediate file / Intermediate file
- controller / Controller
- client / Client
- target / Target
- DReplay / DReplay
- architecture / Architecture
- example / Distributed Replay – a hands on example
- installation / Installation
- usage / Usage
- additional resources / Additional resources
- Distributed Replay Client server / Target
- Distributed Replay Client service / Replay
- Distributed Replay Controller server / Client
- Distributed Replay usage
- capture step / Capture
- preprocessing / Preprocess
- intermediate file, replaying / Replay
- configuration / Configuration
- monitoring / Monitoring
- cancel command / Canceling
- DML / Capture
- DMVs
- about / New Dynamic Management Views (DMVs)
- OS Volume Stats DMV / The new OS Volume Stats DMV
- DocumentStore
- about / FileTable table type
- Domain Management task / Using Data Quality Services
- Domain Rules tab / Understanding domains
- DQS / Master Data Services (MDS)
- features / Reasons for using Data Quality Services
- using, for quality check / Reasons for using Data Quality Services
- installing / Installing Data Quality Services
- using / Using Data Quality Services
- domain / Understanding domains
- Data Quality Project / Coupling rules to data: the Data Quality Project
- versus T-SQL / DQS versus T-SQL
- resources / Resources
- DQS installation
- about / Installing Data Quality Services
- TCP/IP, enabling for remote access / Enabling TCP/IP for remote access to the DQS server
- data access, enabling for DQS operation / Making data accessible for DQS operations
- DQS role, granting on DQS_Main / Granting a DQS role on DQS_Main for DQS users
- DReplay
- about / DReplay
- DReplay.Exe.Preprocess.config / Configuration
- DReplay.Exe.Replay.config / Configuration
- DReplay status command / Monitoring
- DRU
- about / Distributed Replay
E
- editions, SQL Server 2012
- about / SQL Server 2012 Editions
- Enterprise Edition / Enterprise Edition
- Standard Edition / Standard Edition
- Business Intelligence Edition / Business Intelligence Edition
- cloud-based SQL Servers / Licensing in the Cloud
- Developer Edition / Developer Edition
- Express Edition / Express Edition
- Enable trace stop time checkbox / Resource usage reporting
- Enterprise Edition
- about / Enterprise Edition
- AlwaysOn Availability Groups / Enterprise Edition
- ColumnStore Indexes / Enterprise Edition
- environment / Deployment models
- EOMONTH / EOMONTH
- Error Reporting screen / Navigating the Installation Process
- Events Selection tab / Resource usage reporting
- Excel/CSV file / Coupling rules to data: the Data Quality Project
- Excel 2003 extension / Excel Renderer for Excel 2007-2010
- Excel 2007
- report, rendering to / Excel Renderer for Excel 2007-2010
- Excel 2007-2010
- Excel rendering / Excel Renderer for Excel 2007-2010
- Excel Add-in / Master Data Services (MDS)
- Execute button / Using scalable string storage
- Express Edition / Express Edition
- expression indicators
- about / Expression indicators
- Extended Event Object Model / Extended Events for Analysis Services
- Extended Events
- for Analysis Services / Extended Events for Analysis Services
F
- Feature Selection screen / Installing without Visual Studio 2010 pre-installed
- FETCH / OFFSET and FETCH
- FILESTREAM / FileTable table type
- FileTable
- about / FileTable table type
- fixed database-level roles
- about / Fixed database-level roles
- SQL Server 2005, upgrading to 2008 / Upgrading from SQL Server 2005 and 2008
- Flat File Connection Manager
- enhancements / Enhancements to the Flat File Connection Manager
- FORMAT() function
- about / FORMAT
- FQDN / Installation
- Full Recovery mode / Using availability groups
- functions, SSIS 2012
- left / New functions
- ReplaceNull / New functions
- TokenCount / New functions
- Token / New functions
G
- get_ServerLoggingLevel error message / SSISDB – the SSIS Catalog database
- GUID
- about / Comparing and merging packages
H
- HA/DR / Availability groups
- Hadoop
- about / About Hadoop
- and OLTP / Hadoop and OLTP
- starting with / Getting started with Hadoop
- HADRON / Availability groups
- HDFS / The need for big data platforms
- Hive
- about / About Hive
- HiveQL / About Hive
- Hortonworks / Getting started with Hadoop
- HQL / About Hive
I
- IdentificationString property / Setting up a Data Tap
- IIF / IIF
- installation, Distributed Replay
- about / Installation
- Installation Configuration Rules / Navigating the Installation Process
- Installation link / Navigating the Installation Process
- Install button / Navigating the Installation Process, Creating database projects
- installing
- multidimensional and data mining model / Multidimensional and Tabular models
- tabular model / Multidimensional and Tabular models
- PowerPivot for the SharePoint model / PowerPivot for SharePoint
- Instance Configuration / Navigating the Installation Process
- Integration Services Catalog node / SSISDB – the SSIS Catalog database, Package execution reports
- Integration Services Catalogs folder / Validating a project or package
- intermediate file / Intermediate file
- IOPS / Is SQL Server redundant?
- ITAR / SQL Azure and the future of databases
J
- Java Database Connectivity (JDBC) connector / The Microsoft Hadoop/Sqoop connector
K
- knowledge base / Using Data Quality Services
M
- MagicDisk / Navigating the Installation Process
- Management Studio
- keyboard shortcuts / Management Studio keyboard shortcuts
- spatial indexes / Spatial indexes
- columnstore indexes / Columnstore indexes
- restrictions / Restrictions
- contained databases / Contained databases
- Management Tools option / Navigating the Installation Process
- MapReduce algorithm / About Hadoop
- master database / Contained database security
- Master Data Services (MDS) / Navigating the Installation Process
- MDS / Master Data Services (MDS)
- MDX / Resource usage reporting
- Microsoft environment
- differences / Differences in the Microsoft environment
- migration business reasons, SQL Azure
- SQL Azure suitability / SQL Azure suitability
- hosted web/database services / How SQL Azure differs from hosted web and database services
- public cloud / Differences between a public and private cloud
- private cloud / Differences between a public and private cloud
- database migration / Migrating a database to SQL Azure
- public cloud costs / Public cloud costs
- SQL Server Standard/Enterprise editions / Differences between SQL Azure and SQL Server Standard/Enterprise editions
- mirroring
- model
- multidimensional and data mining / The three models, Multidimensional and data mining model
- tabular / The three models, Tabular model
- PowerPivot for SharePoint / The three models, PowerPivot for the SharePoint model
- previously installed model, determining / Determining a previously installed model
- msdb database / Using availability groups
- MS Hadoop/Sqoop connector / The Microsoft Hadoop/Sqoop connector
- multidimensional and data mining model
- about / Multidimensional and data mining model
- database, creating / Creating a multidimensional model database
- installing / Multidimensional and Tabular models
N
- New Data Quality Project button / DQS versus T-SQL
- New Knowledge Base button / Using Data Quality Services
- New Query Edition Window / Using scalable string storage
- NT / Installation
O
- Object Explorer pane / Fixed database-level roles
- OFFSET / OFFSET and FETCH
- OLTP
- and Hadoop / Hadoop and OLTP
- OPEX / SQL Azure: SQL Server in the cloud
- Options dialog box / Management Studio keyboard shortcuts
- Other Sources section / Change Data Capture support
- Output Data Preview grid / DQS versus T-SQL
P
- package
- validating / Validating a project or package
- merging / Comparing and merging packages
- comparing / Comparing and merging packages
- package execution logs
- about / Package execution logs
- basic logging, setting up / How to set up basic SSIS logging
- logging results, viewing / View the results of logging
- package execution reports / Package execution reports
- PackagePath property / Setting up a Data Tap
- PARSE / PARSE
- Planning screen / Navigating the Installation Process
- PowerPivot for the SharePoint model
- about / PowerPivot for the SharePoint model
- installing / PowerPivot for SharePoint
- PowerPivot workbooks / PowerPivot for the SharePoint model, Installing a model
- Power View
- about / Power View and SharePoint modes
- tutorial / Power View and SharePoint modes
- Data Alert / Data Alerts
- preprocessing / Preprocess
- private cloud / Differences between a public and private cloud
- public cloud / Differences between a public and private cloud
R
- @@RAISE_ERROR / Error handling with THROW
- RDL files / Power View and SharePoint modes
- redo / Undo and redo
- refId attribute / Comparing and merging packages
- regulation / SQL Azure and the future of databases
- Report Builder
- about / Report Builder 2012
- using / Report Builder 2012
- Reporting Services
- deprecated features / Deprecated features
- resources
- about / Resources
- Resource Usage reporting
- about / Resource usage reporting
- Run button / Capture
S
- SaaS / SQL Azure: SQL Server in the cloud
- SAN / The new OS Volume Stats DMV
- security management
- about / Default schemas for groups
- default schemas for groups / Default schemas for groups
- user defined server roles / User defined server roles
- SQL Server Audit enhancements / SQL Server Audit enhancements
- Sequence / SEQUENCE
- SequencingMode / Configuration
- Server Configuration screen / Navigating the Installation Process
- Server Roles node / User defined server roles
- Setup Support Rules screen / Navigating the Installation Process
- setup wizard / Navigating the Installation Process
- Shared Features / Installing without Visual Studio 2010 pre-installed
- SharePoint Server 2010
- Power View / Power View and SharePoint modes
- Show all events checkbox / Resource usage reporting
- Simple Recovery mode / Using availability groups
- SMEs
- solid state disks (SSD) / SQL Server 2012 Editions
- spatial indexes
- about / Spatial indexes
- SPIDs / Preprocess
- SQL Azure
- about / SQL Azure: SQL Server in the cloud
- migrating to, business reasons / Reasons for migrating to the cloud
- limitations / New skills
- SQL Server
- redundancy / Is SQL Server redundant?
- SQL Server 2012
- editions / SQL Server 2012 Editions
- evaluating / Evaluation
- retailing / Retail
- installation process, navigating / Navigating the Installation Process
- Analysis Services / Business Intelligence Semantic Model
- SQL Server Audit enhancements / SQL Server Audit enhancements
- SQL Server Data Tools / Package execution logs, Change Data Capture support
- SQL Server Data tools
- about / SQL Server Data Tools
- database projects / Database Projects
- version connection support / Support for SQL Server 2005, 2008 and SQL Azure
- IntelliSense / IntelliSense and debugging
- debugging / IntelliSense and debugging
- installing / Installing SQL Server Data Tools
- installing, without Visual Studio 2010 pre-installed / Installing without Visual Studio 2010 pre-installed
- installing, with Visual Studio 2010 pre-installed / Installing with Visual Studio 2010 pre-installed
- installinew project, creating / Creating a new project
- SQL Server Data Tools checkbox / Installing without Visual Studio 2010 pre-installed
- SQL Server Development Settings / Creating database projects
- SQL Server Distributed Replay Client service / Replay
- SQL Server Distributed Replay Controller service / Preprocess
- SQL Server Profiler
- using / Resource usage reporting
- Sqoop / The Microsoft Hadoop/Sqoop connector
- Sqoop connector / Differences in the Microsoft environment
- SSDT / Creating a multidimensional model database, Shared connection managers
- SSIS / Differences in the Microsoft environment
- SSIS 2012
- functions / New functions
- SSIS Control Flow tab / Change Data Capture support
- SSISDB
- ssis_admin role
- about / Introducing the ssis_admin role
- users access, giving to integration services / Giving users access to integration services
- SSMS / SQL Server Data Tools , Package execution reports
- Standard Edition
- about / Standard Edition
- Start Visual Studio button / Creating a new project
- status codes
- colour coded / Color coded and indicator status codes
- indicator / Color coded and indicator status codes
- STBuffer functions / Spatial indexes
- STDistance functions / Spatial indexes
- StreamInsight / What is big data?
- StressScaleGranularity / Configuration
- string functions
- about / String functions
- CONCAT() / CONCAT
- FORMAT() / FORMAT
- String store constraint
- about / String store constraint
- scalable string storage, using / Using scalable string storage
- StringStoresCompatibilityLevel property / Using scalable string storage
- sys.dm_db_mirroring_auto_page_repair / Using availability groups
- sys.dm_hadr_auto_page_repair / Using availability groups
T
- T-SQL
- versus DQS / DQS versus T-SQL
- T-SQL analytical functions
- about / New T-SQL analytical functions
- anout / New T-SQL analytical functions
- FIRST_VALUE / FIRST_VALUE
- LAST_VALUE / LAST_VALUE
- LAG / LAG
- LEAD / LEAD , SQL Server Data Tools
- tabular model
- about / Tabular model
- database / Tabular model database
- xVelocity engine mode / The xVelocity tabular engine mode
- database, creating / Creating a tabular model database
- installing / Multidimensional and Tabular models
- tabular model database
- creating / Creating a tabular model database
- target
- about / Target
- TechNet / SQL Server 2012 Editions
- The Feature Selection screen / Navigating the Installation Process
- ThinkTimeScale / Configuration
- ThreadsPerClient / Configuration
- TIMEFROMPARTS / TIMEFROMPARTS
- trace file / Distributed Replay , Trace file
- Trust / SQL Azure and the future of databases
- TRY_PARSE / TRY_PARSE
- TSQL_Replay / Capture
U
- undo / Undo and redo
- Upgrade Wizard / Upgrading from SQL Server 2005 and 2008
- user defined server roles / User defined server roles
V
- Validate Package window / Validating a project or package
- variability / What is big data?
- velocity / What is big data?
- Virtual Machines (VMs) / SQL Server 2012 Editions
- VMWare Player / Getting started with Hadoop
- volume / What is big data?
W
- -w parameter / Controller
- Windows event log / Package execution logs
- Windows Explorer window / FileTable table type
- WITH RESULT SETS option
- about / WITH RESULT SETS
- error handling, with THROW / Error handling with THROW
- WMI / New Dynamic Management Views (DMVs)
- Word 2007-2010
- Word Renderer / Word Renderer for Word 2007-2010
- workflow / Using Data Quality Services
- Work Offline / Changing the scope of a connection manager
- WSFC
X
- .xlsx extension / Excel Renderer for Excel 2007-2010
- XML / Package execution logs
- xVelocity database engine / Tabular model database