| |
| |
| Introduction | |
| |
| |
| |
| Converting Your Access Database to SQL Server | |
| |
| |
| Reasons to Upsize | |
| |
| |
| Getting Started with the Upsizing Wizard | |
| |
| |
| Upsizing Gotchas: What to Watch Out For | |
| |
| |
| What About Security? | |
| |
| |
| Using the Upsizing Wizard to Create Linked Tables | |
| |
| |
| Upsizing Using Data Transformation Services (DTS) | |
| |
| |
| Using Linked Servers for Data Access | |
| |
| |
| Beyond Upsizing: What's Next? | |
| |
| |
| Summary | |
| |
| |
| |
| SQL Server Fundamentals | |
| |
| |
| SQL Server Editions | |
| |
| |
| SQL Server Graphical Components | |
| |
| |
| The Server | |
| |
| |
| The Database | |
| |
| |
| What's New in SQL Server 2000 | |
| |
| |
| Installing SQL Server | |
| |
| |
| Summary | |
| |
| |
| |
| Understanding SQL Server Security | |
| |
| |
| Why Security Is Important | |
| |
| |
| Letting Users In | |
| |
| |
| Understanding Permissions | |
| |
| |
| What About Access Security? | |
| |
| |
| Upsizing Access Security Permissions on Tables | |
| |
| |
| Summary | |
| |
| |
| |
| Introduction to Access Projects (ADPs) | |
| |
| |
| About Access Projects | |
| |
| |
| Creating a New Access Project | |
| |
| |
| Forms in Access Projects | |
| |
| |
| Managing Your SQL Server Through an Access Project | |
| |
| |
| Summary | |
| |
| |
| |
| Linking to SQL Server Using Access Databases (MDBs) | |
| |
| |
| Advantages of Using a Jet Database (MDB) Front End | |
| |
| |
| How Jet Uses ODBC | |
| |
| |
| Working Efficiently with Linked Tables | |
| |
| |
| Creating Efficient Bound Forms | |
| |
| |
| Using Pass-Through Queries | |
| |
| |
| Caching Data in Local Tables | |
| |
| |
| Tweaking ODBC Settings to Tune Performance | |
| |
| |
| Summary | |
| |
| |
| |
| ActiveX Data Objects (ADO) Fundamentals | |
| |
| |
| A Short History of Data Access Technologies | |
| |
| |
| Getting Started with ADO | |
| |
| |
| Creating an ADO Connection Object | |
| |
| |
| Creating an ADO Recordset Object | |
| |
| |
| Creating an ADO Command Object | |
| |
| |
| Mixing and Matching the Three Objects | |
| |
| |
| Advanced ADO | |
| |
| |
| Other ADO Libraries | |
| |
| |
| Choosing the Best Tool for the Job at Hand | |
| |
| |
| Summary | |
| |
| |
| |
| Designing and Creating a SQL Server Database | |
| |
| |
| Designing a Relational Database | |
| |
| |
| Implementing Your Design in SQL Server 2000 | |
| |
| |
| Summary | |
| |
| |
| |
| Introduction to Transact-SQL (T-SQL) | |
| |
| |
| Defining Transact-SQL | |
| |
| |
| Referring to Objects | |
| |
| |
| Selecting Data | |
| |
| |
| Joins | |
| |
| |
| Updating Data with Action Queries | |
| |
| |
| Using Transact-SQL Functions | |
| |
| |
| Programming in Transact-SQL | |
| |
| |
| Other Querying Techniques | |
| |
| |
| Summary | |
| |
| |
| |
| Creating and Optimizing Views | |
| |
| |
| Defining Views | |
| |
| |
| Creating and Modifying Views | |
| |
| |
| Using Views to Update Data | |
| |
| |
| Indexed Views | |
| |
| |
| Optimizing Views and Queries | |
| |
| |
| Summary | |
| |
| |
| |
| Programming Effective Stored Procedures | |
| |
| |
| Stored Procedure Fundamentals | |
| |
| |
| What's Under the Hood | |
| |
| |
| Creating Parameterized Stored Procedures | |
| |
| |
| Error Handling in Stored Procedures | |
| |
| |
| Creating UPDATE, DELETE, and SELECT Stored Procedures | |
| |
| |
| Debugging Stored Procedures | |
| |
| |
| Advanced Stored Procedure Topics | |
| |
| |
| Stored Procedures and User-Defined Functions | |
| |
| |
| The System Stored Procedures | |
| |
| |
| Summary | |
| |
| |
| |
| Scaling Up with Unbound Access Applications | |
| |
| |
| What Is an Unbound Application and Why Build One? | |
| |
| |
| Using Stored Procedures | |
| |
| |
| Deciding Between Access Databases and Access Projects | |
| |
| |
| Unbound MDBs | |
| |
| |
| Unbound ADPs | |
| |
| |
| Summary | |
| |
| |
| |
| Building Access Reports from SQL Server Data | |
| |
| |
| General Guidelines for Creating Efficient Reports | |
| |
| |
| Using Access Features to Filter Data | |
| |
| |
| Reporting in Access Projects | |
| |
| |
| Reporting in Access Databases | |
| |
| |
| Reporting on OLAP Data | |
| |
| |
| Summary | |
| |
| |
| |
| Internet Features in Access and SQL Server | |
| |
| |
| Publishing SQL Server Data to the Web | |
| |
| |
| XML in SQL Server 2000 | |
| |
| |
| Access Internet Features | |
| |
| |
| Summary | |
| |
| |
| |
| Architecting Distributed n-Tier Applications | |
| |
| |
| Overview of n-Tier Development | |
| |
| |
| Creating Middle-Tier Components | |
| |
| |
| Security and Connection Pooling | |
| |
| |
| Summary | |
| |
| |
| |
| Deployment, Tuning, and Maintenance | |
| |
| |
| Tuning | |
| |
| |
| Monitoring Performance | |
| |
| |
| Backup and Maintenance | |
| |
| |
| Deployment | |
| |
| |
| Summary | |
| |
| |
| |
| Resources | |
| |
| |
| Books | |
| |
| |
| Web Sites | |
| |
| |
| Useful Downloads | |
| |
| |
| Magazines and Journals | |
| |
| |
| Index | |