What are the trade-offs between using a relational database like SQL Server versus a NoSQL database like DynamoDB?