Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Database Lifecycle Management Content on MSDN

DZone's Guide to

Database Lifecycle Management Content on MSDN

· Database Zone
Free Resource

Learn how to create flexible schemas in a relational database using SQL for JSON.

 

Database lifecycle management (DLM) is a policy-based approach to managing databases and data assets. DLM is not a product but a comprehensive approach to managing the database schema, data, and metadata for a database application. A thoughtful and proactive approach to DLM enables an organization to manage data resources according to appropriate levels of performance, protection, availability, and cost.

DLM begins with discussion of project design and intent, continues with database develop, test, build, deploy, maintain, monitor, and backup activities, and ends with data archive. This topic provides an overview of the stages of DLM that begin with database development and progress through build, deploy, and monitor actions (Figure 1). Also included are data management activities, and data portability operations like import/export, backup, migrate, and sync.

How to Use this Topic


Use the SQL Server Database Lifecycle Management diagram to identify the applications and actions that apply to your database scenarios. To get additional information about a specific DLM task, scroll down to the links and click a topic name.

To communicate with the author of this topic with comments or suggestions, send e-mail to Louis Berner: Louisb@microsoft.com. Please mark your message with Subject: “DLM topic on MSDN.”image 

...image 

This is something that every dev and app that stores data has had to deal with, updates and changes over time. This is interesting guidance and series of links. Looks a little complicated, but it's not an easy problem to solve either...

Create flexible schemas using dynamic columns for semi-structured data. Learn how.

Topics:

Published at DZone with permission of Greg Duncan, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}