Table of Contents

1. Selecting and Designing SQL Server Services to Support Business Needs. 2. Designing a Logical Database 3. Designing a Physical Databae 4. Designing a Database for Performance 5. Using Appropriate Database Technologies and Techniques for your Application 6. Designing Objects That retrieve Data 7. Designing Objects that extend server functionality 8. Designing a Secure Application Solution 9. Designing a Secure Database 10. Designing a Unit Test Plan for a Database 11. Creating a Database Benchmarking Strategy 12. Creating a Plan for Deploying a Database 13. Controlling Changes to Source Code 14. Designing for Data Distribution 15. Designing Applications that support reporting and use reporting services 16. Developing Applications for Notification Services 17. Developing Packages for Integration Services Case Scenario Answers

About the Author

Dejan Sarka, Adolfo Wiernik, Javier Loria, and Andy Leonard are all SQL Server experts with 60 years’ combined experience. They work at Solid Quality Mentors where they combine deep technical expertise and real-world implementation experience to provide advanced solutions and training for the Microsoft SQL Server database platform.