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] SAC (Surface Area Configuration) tool SAFE setting (CLR executables) saving Visual Studio custom configurations scalability application design architectures SQL Server Express Edition Scalar Functions 2nd SchemaOnly Command Behavior (ExecuteReader function) schemas SQL Server 2nd scope for connections selecting object instantiation scripts CLRtest scripts creating executing security application design CLR executables connection pools ConnectionStrings 2nd data restoration hackers of connections selecting connection strategy Slammer worm SQL Server addressing objects authentication authorization connections logins 2nd object ownership overview of ownership chains roles schemas security personas special accounts usernames SQL Server Express Edition 2nd SQLEv (SQL Server Everywhere Edition) SQLinjection attacks, preventing security personas, creating SELECT queries CLR UDTs (user-defined types) creating executing generating with Query Designer JOIN behavior joins 2nd Cartesian products inner joins outer joins limiting number of rows returned ORDER BY clause ordering rows returned parameters WHERE clause SELECT statement creating cursors with SELECT INTO SelectCommand object SelectCommand property (SqlDataAdapter class) selecting [See choosing, application architectures.] SequentialAccess CommandBehavior (ExecuteReader function) serialization Server Explorer assemblies, managing CLR executables, viewing compared to SQL Server Object Explorer configuring creating databases with database connections Database Diagrams creating definition of servers managing registering stored procedures creating complex stored procedures creating simple stored procedures CustomerByState 2nd CustomerUpdate1 debugging against local instances debugging from code debugging on remote instances debugging with breakpointss executing with Run Selection feature naming Synonyms T-SQL Functions advantages of Inline Functions return values Scalar Functions structure of Table Functions tables, editing UDTs (user-defined types), creating Server Explorer command (View menu) server name keyword server reports accessing on Reporting Services methods and functions parameters 2nd rendering ServerReport class server-side cursors ADO.NET implementation of creating disadvantages of dynamic cursors fetching data from fetching entire cursor forward-only cursors importance of keyset cursors managing opening, closing, and reopening connections static cursors updating server-side logic updates executing with RowUpdating event overview of UpdateEvent sample application CustomerUpdate stored procedure DataRow versions Update application Update method ServerReport class [See server reports, accessing on Reporting Services.] ServerReport property (Report Viewer class) servers [See also client/server architectures, advantages/disadvantages; SQL Server, action commands.] competing demands on definition of 2nd finding for establishing connections managing with Server Explorer registering with Server Explorer Service Accounts (SQL Server) Service Packs 2nd services connecting to service instances inspecting starting viewing with Server Explorer SET DEFAULT constraint SET NULL constraint SetDataSourceCredentials method SetParameters method 2nd Setup program (SQL Server) Setup program (Visual Studio) sharing in SQLEv (SQL Server Everywhere Edition) MDAC stack shareable components, building shared code performance Shared Memory ShowCredentialPrompts property (Report Viewer class) ShowDocumentMapButton property (Report Viewer class) ShowExportControls property (Report Viewer class) ShowFindControlsproperty (Report Viewer class) ShowPageNavigationControls property (Report Viewer class) ShowPrintButton property (Report Viewer class) ShowPromptAreaButton property (Report Viewer class) ShowRefreshButton property (Report Viewer class) ShowReportBody property (Report Viewer class) ShowToolbar property (Report Viewer class) ShowZoomControl property (Report Viewer class) Simple Object Access Protocol (SOAP) SingleResult CommandBehavior (ExecuteReader function) SingleRow CommandBehavior (ExecuteReader function) 2nd SKUs (stock-keeping units) Slammer worm 2nd Sleep function smalldatetime data type smallint data type smallmoney data type Smart Tags SNC (SQL Server Native Client) SOAP (Simple Object Access Protocol) SoftConnectsPerSecond performance counter SoftDisconnectsPerSecond performance counter Sort property BindingSource class DataView class sp_addextendedproperty stored procedure sp_dropextendedproperty stored procedure sp_prepexec stored procedure sp_updateextendedproperty stored procedure special accounts (SQL Server) specifications (project) SQL engine (SQLEv) SQL injection attacks SQL pane (Query Designer) SQL Profiler Application Name property CLR executable performance, evaluating configuring evaluating traces filter criteria, adding profiling CLR executable deployment process 2nd starting traces 2nd tips and recommendations SQL Server action commands INSERT UPDATE administrative functions Auto Close option backups importing/exporting data .MDF database files, attaching batches buffer cache business rules extended properties overview of T-SQL Rules CLR executables [See CLR executables, ADO.NET.] comparison of editions Configuration Manager 2nd connections [See connections, client/server connection management.] constraints costs Developer Edition Enterprise Edition Express Edition administration 2nd capabilities common instances configuring as server crippled features database deployment default instances deployment eployment independent instances overview of 2nd performance 2nd replication scalability 2nd security 2nd Service Packs 2nd System Administrator's password tools 2nd user instances ExpressAdvanced Services Edition Identity values, managing installing Advanced Services options authentication mode collating sequences instance names quiet installs Service Account Setup program User Instances, enabling instances multiple instances overview of logins Management Studio CLR executables, viewing creating queries stored procedure management monitoring with performance counters activating performance counters selecting counters SqlClient performance counters monitoring with SQL Profiler Application Name property configuring evaluating traces evaluting CLR executable performance filter criteria, adding profiling CLR executable deployment process starting traces tips and recommendations object addressing Object Explorer object ownership overview of ownership chains performance QO (Query Optimizer) queries [See queries, ad hoc queries, integrating into applications.] Query plans cached Query plans client statistics and alternate plans executing tuning viewing Reporting Services [See Reporting Services, architecture.] roles schemas scripts security addressing objects authentication authorization connections injection attacks logins object ownership overview of ownership chains roles schemas security personas special accounts usernames services connecting to service instances inspecting starting special accounts SQLEv (SQL Server Everywhere Edition) implementation overview of programming and maintenance security sharing and replication SQL Server tools SQLEngine Visual Studio support Standard Edition statements [See statements, ALTER PROCEDURE.] stored procedures [See stored procedures.] system databases TDS (Tabular Data Stream) transaction logs transactions triggers DDL triggers DML triggers UDTs (user-defined datatypes) user databases creating managing usernames views creating Database Snapshots indexes T-SQL views Workgroup Edition 2nd SQL Server Everywhere 2nd SQL Server Everywhere Edition [See SQLEv (SQL Server Everywhere Edition), implementation.] SQL Server Management Studio SQL Server Native Client (SNC) sql_variant data type sql_variant datatype SqlBulkCopy class SqlClient namespace ADO.NET performance counters overview of 2nd SqlBulkCopy class SQLClientFactory class SqlCommand class SqlConnection class SqlConnectionStringBuilder class SqlDataAdapter class Fill method properties Update method updates SqlDataReader class SqlDependency class SqlError class SqlErrorCollection class SqlException class SqlParameter class SqlParameterCollection class SqlTransaction class SQLClientFactory class SqlCommand objects ad hoc queries, integrating into applications 2nd creating executing asynchronously BeginExecuteNonQuery function BeginExecuteReader function BeginExecuteScalar function BeginExecuteXmlReader function callback 2nd cautions IAsyncResult interface 2nd overview of polling threads WaitHandle objects 2nd executing synchronously [See also populating data structures, DataSet Load method.] connection management ExecuteNonQuery function ExecuteReader function ExecuteScalar function 2nd ExecuteXmlReader function 2nd overview of SqlDataReader object methods Cancel Dispose New Prepare 2nd ResetCommandTimeout 2nd parameter-based queries access rights and ad hoc queries, inserting best practices default parameter values duplicate parameter names dynamic SQL marking parameters NULL values Parameters collections SqlParameter class SqlParameterCollection class Unicode literals Value property what can be parameterized properties CommandText CommandTimeout 2nd CommandType Connection 2nd Notification 2nd NotificationAutoEnlist 2nd Parameters 2nd Transaction 2nd UpdatedRowSource 2nd SQL injection attacks, preventing stored procedures executing RETURN values support functions Clone CreateParameter 2nd validation overview of sample application SqlCommandBuilder [See CommandBuilder, action commands, generating.] SqlConnection class [See connections, client/server connection management.] SqlConnectionStringBuilder class 2nd SqlContext class 2nd SqlDataAdapter class Fill method properties Update method updates SqlDataReader class best practice designs fetching all columns fetching individual rows fetching metadata Get functions GetSchemaTable method HasRows function overview of testing stream for data 2nd SqlDependency class SqlError class SqlErrorCollection class SQLEv (SQL Server Everywhere Edition) implementation overview of programming and maintenance security sharing and replication SQL Server tools SQLEngine Visual Studio support SqlException class 2nd SqlMethodAttribute property SqlParameter class 2nd access rights and best practices default parameter values duplicate parameter names dynamic SQL marking parameters NULL values Parameters collections ResetDbType method ResetSqlType method Unicode literals validation overview of sample application Value property what can be parameterized SqlParameterCollection class 2nd SqlTransaction class SqlUserDefinedTypeAttribute (UDTs) SSEE (SQL Server Express Edition) administration 2nd capabilities common instances configuring as server crippled features database deployment default instances deployment eployment independent instances overview of 2nd performance 2nd replication scalability 2nd security 2nd Service Packs 2nd System Administrator's password tools 2nd user instances stand-alone applications (client/server architectures) advantages/disadvantages building connection management connection pools data binding data entry paradigms data retrieval data storage limits data validation definition of hybrid architectures server-side cursors stored procedures temporary tables Standard Edition (SQL Server) Standard Edition (Visual Studio) starting SQL Profiler traces SQL Server services Visual Studio state, managing StateChange event (connections) statements ALTER PROCEDURE batches case-sensitive queries CREATE PROCEDURE CREATE RULE DECLARE DELETE Imports INSERT generating with Query Designer Identity values NULL and DEFAULT values IS NOT NULL IS NULL NULL values preparing for execution scripts SELECT CLR UDTs (user-defined types) creating creating cursors with executing joins ORDER BYclause ordering rows returned parameters SELECT INTO WHERE clause UNION UPDATE BLOBs concurrency decimal and floating point numbers generating with Query Designer parameter-based updates SET clause strings strongly typed data columns updating cursors Using block static cursors static ports statistics, client stepping through code stock-keeping units (SKUs) stored procedures CLR stored procedures compared to functions CountWords example creating performance returning resultsets with SqlContext class testing creating simple complex procedures simple stored procedures CustomerByState 2nd CustomerUpdate CustomerUpdate1 debugging with breakpoints from code against local instances on remote instances ESPs (Extended Stored Procedures) executing 2nd managing 2nd naming RETURN values sp_addextendedproperty sp_dropextendedproperty sp_prepexec sp_updateextendedproperty TableAdapters updating tables with streams SqlDataReader fetching all columns fetching individual rows fetching metadata Get functions overview of testing for data 2nd TDS (Tabular Data Stream) strings concatenating strongly typed data structures [See also configuring, TableAdapters.] building Web Services consuming and testing Web Services data columns DataSets exposing Web Services Data Sources in the UI need for SubReport item summary reports SUMUSD aggregate Surface Area Configuration (SAC) tool synchronous execution of SqlCommand objects connection management ExecuteNonQuery function ExecuteReader function 2nd CommandBehavior.CloseConnection CommandBehavior.Default CommandBehavior.KeyInfo CommandBehavior.SchemaOnly CommandBehavior.SequentialAccess CommandBehavior.SingleResult CommandBehavior.SingleRow ExecuteScalar function 2nd ExecuteXmlReader function 2nd overview of SqlDataReader object best practice designs fetching all columns fetching individual rows fetching metadata Get functions overview of testing stream for data 2nd Synonyms 2nd sysname data type System Administrator passwords system databases System.Data namespace DataColumn objects DataRow objects DataSet objects overview of 2nd populating strongly typed DataSets DataTable objects DataColumns DataRows joins overview of 2nd populating DataSets with naming conventions overview of System.Data.SqlClient namespace System.Data.SqlTypes namespace SystemDataAccess setting (SqlMethodAttribute property) |
Категории