Hitchhikers Guide to Visual Studio and SQL Server: Best Practice Architectures and Examples, 7th Edition (Microsoft Windows Server System Series)

Index

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

PageNavigation event

parameter-based queries

     access rights and

     ad hoc queries, inserting

     best practices

     default parameter values

     duplicate parameter names

     dynamic SQL

     marking parameters

     NULL values

     parameter-based updates

     Parameters collections

    query parameters

         adding

         capturing

         definition of

     SELECT queries

     SqlParameter class

     SqlParameterCollection class

     Unicode literals

    validation

         overview of

         sample application

     Value property

     what can be parameterized

parameters

    queries [See parameter-based queries.]

     report parameters

         creating

         definition of

         sample application

Parameters collections

Parameters property (SqlCommand object) 2nd

parent/child relationships

     updating

Parse function 2nd

Password keyword

passwords, System Administrators

patches

percent sign (%)

performance

     CLR executable performance, evaluating

         overview of

         with SQL Profiler

         stored procedures

         TVFs (table-valued functions)

         UDTs (user-defined types)

     connection pools

    DBMSs

         .NET Framework

         acceptable speed

         ADO

         DAO

         developer performance

         JET

         MDAC stack, sharing

         overview of

         performance metrics

         shareable and reusable components

         shared code

         team development

    performance counters

         activating

         selecting 2nd

         SqlClient performance counters

         viewing with Server Explorer

     Query plans

     SQL Server Express Edition 2nd

performance counters

     activating

     selecting

     SqlClient performance counters

     viewing with Server Explorer

PerformBack method

permissions, denying

Persist Security Info keyword

persistent connections 2nd

personas (security)

pick lists, prompting with

PID (process identifier)

plans, Query [See Query plans.]

polling

pools [See connection pools.]

populating data structures

     DataSet Load method

     DataSets with DataTable objects

     DataTable Load method

     design

     hard-coding DataTable objects

     InfoMessage messages

     OUTPUT and RETURN value parameters

     overview of

     resultset elements 2nd

     SqlDataAdapter Fill method

ports

Position property (BindingSource class) 2nd

PositionChanged event

Prepare method 2nd

PRIMARY KEY constraint

primary keys

     changing

     defining

     GUIDs (globally unique identifiers)

     multi-column primary keys

     PRIMARY KEY constraint

     primary key/foreign key relationships

Print event

Privacy Act of 1974

prjSampleVSReport application

     adding to project

     laying out

procedures, stored [See stored procedures.]

ProcessingMode property (Report Viewer class)

ProductByProfit report

     Data Sources, creating

     formatting

         background color

         expressions

     laying out

     Report Viewer control configuration

     testing

Professional Edition (Visual Studio)

Profiler [See SQL Profiler.]

projects

     adding reports to

     specifications

PromptAreaCollapsed property (Report Viewer class)

prompting

     for parameter values

     with pick lists

properties [See specific properties.]

protection [See security, application design.]

protocols

     Named Pipes

     Shared Memory

     TCP/IP (Transmission Control Protocol/Internet Protocol)

     VIA (Virtual Interface Adaptor)