Episode

The Anatomy of a Connection String | SQL Tips for Developers 0104

with Jerry Nixon, Anagha Todalbagi

Azure Developers

SQL Tips for Developers covers basic concepts and techniques for developers new to SQL. In this video, we discuss the anatomy of the Database Connection String used in every application out there to access the database.

Chapters

  • 00:00 - Introduction
  • 01:00 - Server=.
  • 03:15 - Persist Security Info
  • 03:45 - Username & Password
  • 05:05 - Encrypt=true
  • 05:37 - TrustServerCertificate=true
  • 05:50 - Trust Connection=true
  • 06:38 - Connection Timeout=60
  • 07:10 - Application Name
  • 07:56 - Pooling=true
  • 08:27 - Application Intent=readonly
  • 09:16 - Conclusion

Developer
Azure
SQL Server