About this Article:
Setting up a connection to SQL Server, with all its protocol checking and security, is one of the slowest things you'll ever do. Windows Server provides connection pooling services so your application doesn't have to know anything about it; you just request a connection and release it when done. Learn how connection pooling works with your SQL Server temporary tables.
Richard Campbell is president of Campbell & Associates in Vancouver, British Columbia. He has more than 20 years experience working with computers, and consults with numerous companies including Johnson & Johnson, Barnes&Noble.com, and ADP. In addition to consulting on development issues, Richard speaks at Advisor DevCon and other technical conferences around the world. He has been writing for Advisor publications since 1996. Richard is a technical editor of Advisor Guide to Microsoft Access Magazine, and an Advisor technical board member of Advisor Summit.
Keyword Tags: Database, Database Development, Microsoft, Microsoft Access, Microsoft SQL Server