Chapter 1. Choosing Which Application Data to Store in Your Database

After completing this chapter, you will be able to:

  • Make sense of where to store application settings

  • Determine the best place to store various types of user settings

  • Decide where to store XML data

  • Choose where to store external application files, such as Microsoft Word documents and Microsoft Excel spreadsheets

With the advent of better performing and more flexible database engines like the one in Microsoft SQL Server 2005, the line is blurring between what should be stored in a database and what should not. In the past, databases were good at storing only highly structured data. However, with recent advances in database engine technology, it is becoming easier and more feasible ...

Get Microsoft® SQL Server™ 2005: Applied Techniques Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial