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]

EBooks

editing tables with Server Explorer

EDM (Entity Data Modeling)

embedded spaces, avoiding in object names

EnableExternalImages property (LocalReport class)

EnableHyperlinks property (LocalReport class)

enabling

     CLR executables

     connection pools

     User Instances

End User License Agreement (EULA)

EndEdit method

Enterprise Edition (SQL Server)

Entity Data Modeling (EDM)

error handling [See exception handling, connection pool overflows.]

ESPs (Extended Stored Procedures)

EULA (End User License Agreement)

evaluating performance [See performance, CLR executable performance, evaluating.]

event logs

events

     BindingSource class

     connections

     DoWork

     Drillthrough

     ListChanged

     LocalReport events

     Report Viewer events

     RowUpdated

    RowUpdating

         executing Update logic with

         trapping

Events Selection dialog (SQL Profiler)

exact numerics

Exception class

exception handling

     connection pool overflows

     connections

         SqlException class

         types of exceptions

executables [See CLR executables, ADO.NET.]

ExecuteNonQuery function

ExecuteReader function 2nd

     CommandBehavior.CloseConnection

     CommandBehavior.Default

     CommandBehavior.KeyInfo

     CommandBehavior.SchemaOnly

     CommandBehavior.SequentialAccess

     CommandBehavior.SingleResult

     CommandBehavior.SingleRow

ExecuteReportInCurrentAppDomain method

ExecuteReportInSandboxAppDomain method

ExecuteScalar function 2nd

ExecuteUpdateEvents BatchMode example

ExecuteXmlReader function 2nd

execution

    asynchronous execution (SqlCommand objects)

         BeginExecuteNonQuery function

         BeginExecuteReader function

         BeginExecuteScalar function

         BeginExecuteXmlReader function

         callback 2nd

         cautions

         IAsyncResult interface

         overview of

         polling

         threads

         WaitHandle objects 2nd

     Query plans

     SELECT queries

     stored procedures 2nd

     synchronous execution (SqlCommand objects) [See also populating data structures, DataSet Load method.]

         connection management

         ExecuteNonQuery function

         ExecuteReader function 2nd

         ExecuteScalar function 2nd

         ExecuteXmlReader function 2nd

         overview of

         SqlDataReader object

     test scripts

Export Template command (File menu)

Export Template Wizard

exporting data

exposing Web Services Data Sources

Express Edition (SQL Server)

     administration 2nd

     capabilities

     common instances

     configuring as server

     crippled features

     database deployment

     default instances

     deployment 2nd

     independent instances

     overview of 2nd

     performance 2nd

     replication

     scalability 2nd

     security 2nd

     Service Packs 2nd

     SystemAdministrator's password

     tools 2nd

     user instances

Express Edition (Visual Studio)

ExpressAdvanced Services Edition (SQL Server)

Expression Editor

Expression property (DataColumn objects)

expressions

     BETWEEN

     concatenated T-SQL expressions

     creating for reports

     IN

     LIKE

extended properties (business rules)

Extended Relational Analysis

Extended Stored Procedures (ESPs)

extensibility

EXTERNAL_ACCESS setting (CLR executables)