B

backup and restore, 60

of concurrent databases and logs, 64

and Database Page Checksums, 63–64

enhancements in Analysis Services, 225

media reliability enhancements in, 62–63

partial restore, 62

backup media mirroring, overview of, 62–63

backups, improved verification of, 63

banded report designers, significance of, 164

BaseDirectoryPath tag in config.xml file, significance of, 113

BCP (Bulk Copy Program), relationship to bulk data loading, 13–14, 33

BEGIN DIALOG statement, using with SQL Server Service Broker application, 136

BEGIN DIALOG T-SQL DML statement, description of, 133

BEGINxxx method, using with asynchronous queries, 98–99

BI (business intelligence), significance of, 216

Binary Adjacent Broker protocol, using with SQL Server Service Broker, 130–131

BreakpointTargetDescription system variable, purpose in Integration Services, 195

breakpoints, defining in packages, 210

broker* sp_configure parameters, descriptions of, 139

bulk data loading, support for, 13–14

bulk insert, ADO.NET support for, 102–103

bulk load feature for XML, overview of, 156

Business Intelligence Development Studio

Cube Browser feature in, 232–233

Cube Editor in, 230–232

Cube Wizard in, 228–230

data sources and data source views in, 226–228

Dynamic Help window in, 37

guidelines for use of, 37–38

online and offline modes in, 226

overview of, 33–34

Properties window in, 37

Solution Explorer window in, 35–37

source control feature in, 37

Toolbox window in, 34

using with Analysis Services, 226–233