Flylib.com
List of Figures
Previous page
Table of content
Next page
Chapter 1: Introducing Database Development with Microsoft SQL Server 2005
Figure 1-1: Monolithic application containing data and logic inside the application itself.
Figure 1-2: Monolithic application accessing external data to improve flexibility.
Figure 1-3: Monolithic application accessing shared external data.
Figure 1-4: Management of centrally stored data through a database management service.
Figure 1-5: Main components of a database application connecting to SQL Server 2005 through ODBC.
Figure 1-6: Main components of a database application connecting to SQL Server 2005 through OLE DB.
Figure 1-7: Main components of a database application connecting to SQL Server 2005 through the ADO.NET managed data provider.
Figure 1-8: Main components of a database application connecting to SQL Server 2005 through the SQL Server Native Client.
Chapter 2: Installing and Setting Up Your Microsoft SQL Server 2005 Development Environment
Figure 2-1: SQL Server 2005 Surface Area Configuration dialog box.
Figure 2-2: Startup options for Services.
Figure 2-3: Remote Connections configuration.
Figure 2-4: Features configuration.
Chapter 3: Reviewing Microsoft SQL Server 2005 Management Tools
Figure 3-1: SQL Server Configuration Manager.
Figure 3-2: The SQL Server 2005 Services node.
Figure 3-3: Advanced options for an instance of SQL Server 2005.
Figure 3-4: The SQL Server 2005 Network Configuration node.
Figure 3-5: TCP/IP Properties dialog box.
Figure 3-6: Windows Firewall exception configuration.
Figure 3-7: SQL Native Client Configuration Properties dialog box.
Figure 3-8: Client Protocols and their order of precedence.
Figure 3-9: Alias creation.
Figure 3-10: Initial screen of SQL Server Surface Area Configuration.
Figure 3-11: SQL Server Configuration For Services And Connections dialog box.
Figure 3-12: SQL Server Configuration For Features dialog box.
Figure 3-13: Object Explorer pane in SQL Server Management Studio.
Figure 3-14: Grouping nodes within a User Database node in Object Explorer.
Figure 3-15: Table actions in Object Explorer.
Figure 3-16: Table modification and script generation in Object Explorer.
Figure 3-17: Stored procedure actions in Object Explorer.
Figure 3-18: Include Client Statistics button in Object Explorer.
Figure 3-19: Database Tuning Advisor Recommendations.
Figure 3-20: SQLCmd input parameters.
Chapter 4: Gathering and Understanding Business Requirements before Creating Database Objects
Figure 4-1: Scalability
Chapter 5: Designing a Database to Solve Business Needs
Figure 5-1: Three-Step Database Model
Figure 5-2: Example of a Multi-Intersection Relationship
Chapter 6: Reading Microsoft SQL Server 2005 Data from Client Applications
Figure 6-1: MDAC Architecture.
Figure 6-2: ADO Architecture.
Figure 6-3: Classes in the data provider component of ADO.NET.
Chapter 11: Deleting Data from Microsoft SQL Server 2005
Figure 11-1: Specifying properties of foreign key relationhips.
Previous page
Table of content
Next page
Solid Quality Learning, Microsoft Corporation Staff - Microsoft SQL Server 2005 Database Essentials Step by Step
ISBN: N/A
EAN: N/A
Year: 2006
Pages: 130
BUY ON AMAZON
Software Configuration Management
Configuration Verification and Audit
A Practical Approach to Configuration Verification and Audit
Appendix A Project Plan
Appendix N Corrective Action Processing (CAP)
Appendix U Acronyms and Glossary
SQL Tips & Techniques (Miscellaneous)
Using Keys and Constraints to Maintain Database Integrity
Working with Comparison Predicates and Grouped Queries
Understanding Transaction Isolation Levels and Concurrent Processing
Retrieving and Manipulating Data Through Cursors
Working with SQL Database Data Across the Internet
Competency-Based Human Resource Management
Why a Focus on Jobs Is Not Enough
An Overview of Competency-Based HR Management Practices
Competency-Based Employee Recruitment and Selection
Competency-Based Performance Management
Competency-Based Employee Development
GO! with Microsoft Office 2003 Brief (2nd Edition)
Key Terms
Problem Solving
Key Terms
Objective 4. Open and Edit an Existing Query
Chapter Four. Linking Data in Office Documents
Java Concurrency in Practice
Immutability
Other Liveness Hazards
Reducing Lock Contention
Testing for Correctness
Publication
Java All-In-One Desk Reference For Dummies
Working with Variables and Data Types
Going Around in Circles (Or, Using Loops)
Working with Statics
Book VI - Swing
Creating Applets
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies