Designing a Database Strategy
o Identify which SQL Server components to use to support business requirements.
Design a database model.
o Design a data model by using the Entity Framework.
o Design an application strategy to support security.
o Design a solution by using Service Broker.
o Design a Full-Text Search strategy.
Designing Database Tables
o Identify the appropriate usage of new data types
o Design tables.
o Design data integrity.
Designing Programming Objects
o Design T-SQL stored procedures.
o Design views.
o Design T-SQL table-valued and scalar functions.
o Design Common Language Runtime (CLR) table-valued and scalar functions.
o Design CLR stored procedures, aggregates, and types.
o Evaluate special programming constructs.
Designing a Transaction and Concurrency Strategy
o Design the locking granularity level.
o Design for implicit and explicit transactions.
o Design for concurrency.
Designing an XML Strategy
o Design XML storage.
o Design a strategy to query and modify XML data.
o Design a query strategy by using FOR XML.
o Design a strategy to transform XML into relational data.
Designing Queries for Performance
o Optimize and tune queries.
o Analyze execution plans
o Evaluate the use of row-based operations vs. set-based operations.
Designing a Database for Optimal Performance
o Optimize indexing strategies.
o Design scalable database solutions.
o Resolve performance problems by using plan guides.
o Design a table and index compression strategy.
o Design a table and index partitioning strategy.
