D

data pipelines, 26, 27

data presentation

exporting

ConvertTo-HTML cmdlet, 202, 203, 204

Export-CliXML cmdlet, 201, 202

Export-CSV cmdlet, 199, 200

filtering output

Where-Object cmdlet, 197, 199

formatting output

Format-Custom cmdlet, 191, 192

Format-List cmdlet, 186, 187

Format-Table cmdlet, 187, 188, 189

Format-Wide cmdlet, 189, 190, 191

GroupBy cmdlet, 192, 194

output redirection, 181, 182

Out-File cmdlet, 182, 183

Out-Printer cmdlet, 183

Tee-Object cmdlet, 184

sorting output

Sort-Object cmdlet, 194, 195, 196, 197

system forms, 205, 206, 207, 208, 209

Write-Host cmdlet, 184, 185

data types, 497, 498

advanced, 505

available, 505, 506

Boolean, 499

DateTime, 499, 500, 501

double, 501

Int, 502

string, 502, 503, 504, 505

Database.ps1 listing, 327, 329

databases, 314

example database, 326, 327, 329

tables, 314

elements, 314

ways to work with, 314, 315, 316, 317

closing connection, 326

connection, 320, 321

DataReader, 325, 326

defining query, 321, 322, 323, 324

executing query, 324, 325

persisting data tables, 317, 318, 319, 320

DataReader

closing connection, 326

databases, 325, 326

DataReaders, 320

Datatable.ps1 listing, 320

DateTime types, 499, 500, 501

-db (-Debug) parameter, 11

-Debug (-db) parameter, 11

debugging, 229, 236, 237, 238

mode to trace script execution, 239, 240, 241, 242, 243, 244

DebugTest.ps1 listing, 240

declarations

variables, 20

DELETE queries, 322

deleting

Windows management files, 251

Windows managmenet directories, 254

DemoPopup.ps1 listing, 206

digital signatures

security

scripts, 41

directories

Windows management

creating, 252, 253

deleting, 254

listing, 253, 254

Do Until operations

While statements, 171

Do While operations

While statements, 170, 171

documentation

WMI (Windows Management Instrumentation), 72, 73

domain names

regular expression matches, 157, 158

dot sourcing, 25

double-precision types, 501

downloads

SDK (Software Development Kit), 44

drives

listing mappings, 6