SQL Server Application Development Best Practices
Relational databases like SQL Server are powerful and complex systems. This course will teach you everything you need to know to get excellent performances from SQL Servers, including how to diagnose performance problems, and more.
What you'll learn
Relational databases like SQL Server are powerful and complex systems, and you need to know how to work with them to get the best out of them. In this course, SQL Server Application Development Best Practices, you will learn what you need to do to get excellent performances from SQL Servers. First, you will learn how SQL Server works and how to think like SQL. Next, you will see how to diagnose performance problems, how to solve those problems the SQL way, and how to choose between SQL and NoSQL. Is NoSQL worth the change? You will have the right arguments to decide. Finally, you will discover how to get predictable performances from SQL Server. When you’re finished with this course, you will have the skills and knowledge needed to improve the way you work with SQL Server.
Table of contents
- Introduction to the Course 3m
- What Is Pachadata, Our Fictional Company? 4m
- Understanding Imperative vs. Declarative Languages 4m
- The Power of a Declarative Language 4m
- Improving C# Code with Declarative Additions 5m
- Understanding Stateful and Stateless Programming 3m
- Why Is Set Theory Important? 3m
- An Example of Loop Operation with SQL Server 5m
- Implementing the Bulk Insert Solution 4m
- Trying the Data Type and XML Solutions 6m
- Conclusion 2m
- Introduction to the Module 2m
- What Is SQL Server Made Of? 2m
- Where to Put the Business Logic? 3m
- Analyzing Performances on the Database Side 4m
- Understanding Entity Framework 2m
- Analyzing Entity Framework Code First from the Database Perspective 10m
- Should We Use EF Code First from Database? 3m
- Why Should We Still Write SQL Code? 6m
- Why Are Stored Procedures Awesome? 5m
- Conclusion 1m
- Introduction to the Module 3m
- Why Are Database Performances Not Predictable? 4m
- Troubleshooting Production Server Performances 4m
- How to See Waits on the Server? 6m
- Generating Test Data with Cross Join 4m
- Using Red Gate SQL Data Generator 4m
- Using SQL Query Stress 4m
- Leveraging RML Utilities 9m
- Replaying Traces with RML Utilities 6m
- Course Conclusion 2m
About the author
Rudi Bruchez is a freelance consultant and trainer based in Paris, France. He has more than 15 years of experience with SQL Server and started to venture into NoSQL territories. He worked first as a developer and started as a DBA in 2001, in Switzerland at MSC (Mediterranean Shipping Company). He moved to France in 2005 and is working freelance since 2006. He provides consulting, administration, audits and training. As SQL Server evolves into a more complex solution, he tries to make sure that d... more