In this chapter, we have discussed several topics:
How to deploy changes to a database already in production, using Visual Studio configurations or the Deployment Wizard.
Automating partition management using Integration Services and AMO code to create, merge, and delete partitions.
Processing strategies. Although we always want to minimize the amount of time spent processing, there is no one processing strategy that is appropriate for all projects. In most cases, a Process Update will handle any updates to dimensions; this can then be followed by a Process Default on our partitions, which will rebuild any aggregations that have been invalidated by dimension processing on existing partitions, and fully process any newly created partitions.
How processing can be managed using Integration Services. The Process Analysis Services Task is the easiest way of doing this, but other Control Flow tasks such as the Execute Analysis Services DDL Task can also be used. It's also possible to push...