Profile

Robert Shaw
Robert Shaw
This user account status is Approved
About About
Posts Posts
Comments Comments
Using OPTION (RECOMPILE) in your queries can help mitigate parameter sniffing.
On Recommend query construct modifications based on resource usage
Appreciate the detailed steps! Cleared up a lot of confusion I had.
On Recommend and configure an on-premises gateway in Power BI
This article is a bit lengthy, but valuable nonetheless.
On Implement a point operation that creates, updates, and deletes documents
I’ve been struggling with setting up the logging. Any tips?
On Implement and query Azure Cosmos DB logs
Any potential downsides to using synthetic partition keys?
On Construct and implement a synthetic partition key
Thanks for the detailed guide!
On Configure an Always On availability group
This is exactly what I was looking for. Thanks!
On Move data by using client SDK bulk operations
This post was really helpful, especially for preparing for the DP-203 exam. Thanks!
On Write encrypted data to tables or Parquet files
Are CTEs (Common Table Expressions) covered in the DP-900 exam?
On Identify common database objects
Not 100% clear on how patch operations impact indexing. Any insights?
On Implement an update by using a patch operation
load more comments