- Cover
- Title Page
- Copyright Page
- Contents at a glance
- Contents
- Introduction
- Chapter 1. Design and implement database objects
- Chapter 2. Implement programmability objects
- Skill 2.1 Ensure data integrity with constraints
- Skill 2.2 Create stored procedures
- Skill 2.3 Create triggers and user-defined functions
- Design trigger logic based on business requirements
- Determine when to use Data Manipulation Language (DML) triggers, Data Definition Language (DDL) triggers, or logon triggers
- Recognize results based on execution of AFTER or INSTEAD OF triggers
- Design scalar-valued and table-valued user-defined functions based on business requirements
- Identify differences between deterministic and non-deterministic functions
- Chapter summary
- Thought Experiment
- Though Experiment Answer
- Chapter 3. Manage database concurrency
- Chapter 4. Optimize database objects and SQL infrastructure
- Skill 4.1: Optimize statistics and indexes
- Skill 4.2: Analyze and troubleshoot query plans
- Skill 4.3: Manage performance for database instances
- Manage database workload in SQL Server
- Design and implement Elastic Scale for Azure SQL Database
- Select an appropriate service tier or edition
- Optimize database file and tempdb configuration
- Optimize memory configuration
- Monitor and diagnose schedule and wait statistics using dynamic management objects
- Troubleshoot and analyze storage, IO, and cache issues
- Monitor Azure SQL Database query plans
- Skill 4.4: Monitor and trace SQL Server baseline performance metrics
- Monitor operating system and SQL Server performance metrics
- Compare baseline metrics to observed metrics while troubleshooting performance issues
- Identify differences between performance monitoring and logging tools
- Monitor Azure SQL Database performance
- Determine best practice use cases for extended events
- Distinguish between Extended Events targets
- Compare the impact of Extended Events and SQL Trace
- Define differences between Extended Events Packages, Targets, Actions, and Sessions
- Chapter summary
- Thought experiment
- Thought experiment answer
- Index
- About the authors
- Free ebooks
- Survey
- Code Snippets
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.