SQL Server: Developer and DBA Collaboration

Introduction

• Developers and DBAs
• Tools and techniques

1. Let’s Talk about Priorities

• DBA priorities
• Developer priorities
• Meeting in the middle

2. 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

3. 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

4. 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