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
Agile Project Management: Creating Innovative Products (2nd Edition)
Champion Technical Excellence
Explore Summary
A Scaled Adaptive Framework
A Hub Organizational Structure
Summary
Image Processing with LabVIEW and IMAQ Vision
NI Vision Builder for Automated Inspection
Video Standards
Image Distribution
Gray-Scale Operations
Spatial Image Filtering
PostgreSQL(c) The comprehensive guide to building, programming, and administering PostgreSQL databases
Defining a Simple Data Type in PostgreSQL
PL/pgSQL
Client 1Connecting to the Server
Client 4Working with transactors
Overview
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
Common pitfalls of adopting SOA
Correlation
Service-orientation and contemporary SOA
Contrasting service modeling approaches (an example)
Service-Oriented Design (Part I: Introduction)
After Effects and Photoshop: Animation and Production Effects for DV and Film, Second Edition
Blue-Screen Garbage Mattes
Rotoscoping Techniques with Photoshop
Static Matte Painting in Photoshop
Color, Light, and Focus
Atmosphere, Film, and Noise Effects
User Interfaces in C#: Windows Forms and Custom Controls
Creating Usable Interfaces
Forms
Modern Controls
Design-Time Support for Custom Controls
Dynamic User Interface
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