Profile

Dwayne Ward
Dwayne Ward
This user account status is Approved
About About
Posts Posts
Comments Comments
This blog is very helpful. Thanks!
On Implement aggregation persistence by using a change feed
One challenge I faced was incompatibility with older SQL Server versions. Any tips to handle this?
On Troubleshoot a migration
Any tips for optimizing cost-efficiency with high write workloads?
On Evaluate the cost of the global distribution of data
I find that using point operations wherever possible reduces our cost significantly.
On Choose when to use a point operation versus a query operation
Great post! It really helped me understand how to identify performance bottlenecks in Power Query.
On Identify data loading performance bottlenecks in Power Query or data sources
I didn't find the explanation on network considerations for hybrid HA/DR configurations very clear.
On Evaluate HA/DR for hybrid deployments
Does automatic tuning impact the performance during heavy load times?
On Configure database automatic tuning
This guide is good but a bit too generic. A few more specific examples would be more helpful.
On Configure batch retention
I have a question regarding the Change Feed: How do you ensure idempotency when processing changes to avoid duplicate entries?
On Denormalize data by using Change Feed and Azure Functions