SQL Server: Developer and DBA Collaboration
1h 3mBeginner2018-11-09
Authors
Joey D'Antoni
Consultant and Thought Leader
Course details
Developers and database administrators (DBAs) sometimes have competing priorities—but they need to meet in the middle to ensure a successful user experience. In this one-hour class, you can learn why developers and DBAs approach application design differently, and how you can achieve compromise without sacrificing quality. Learn how to use Entity Framework and optimized queries, leverage stored procedures, and set up continuous development and deployment pipelines for your databases, while gaining some understanding about how to work together to build more robust, scalable applications.
Learning objectives
Schema design
Building good queries
Writing stored procedures
Building a CI/CD pipeline for database deployment
Learning objectives
Schema design
Building good queries
Writing stored procedures
Building a CI/CD pipeline for database deployment
Skills covered
SQL ServerDatabase AdministrationDatabase ManagementPersonaMicrosoft
Concepts
Introduction
- Developers and DBAs
- Tools and techniques
Let s Talk about Priorities
- DBA priorities
- Developer priorities
- Meeting in the middle
Why Your DBA Hates Entity Framework
- Let s look at the T-SQL it puts out
- Schema design - Databases shouldn t be objects
- Functions aren t your friends
- Understanding the importance of good queries
Why Your DBA Wants You to Write Stored Procedures
- Compilation is expensive
- Code reuse is good
- Don t put all of your program logic in stored procs
- But you should still use SPs
Database Deployment
- Visual Studio database projects
- Why it s hard to deploy code to a database
- CI CD for the database
- Redgate ReadyRoll
Conclusion
- Next steps