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