Profile

Ilona Waisanen
Ilona Waisanen
This user account status is Approved
About About
Posts Posts
Comments Comments
Using a staging environment with a subset of production data is always a good approach for testing partition strategies.
On Recommend a table partitioning solution
I implemented page compression and my query performance improved. Thanks for the guide!
On Configure data compression
How do you handle type-checking for nested arrays in Cosmos DB?
On Implement queries that use array and type-checking functions
Fantastic post, very informative.
On Use component-based pipelines
What is the M language?
On Create queries, functions, and parameters by using the Power Query Advanced Editor
What are the limitations of custom conflict resolution in Cosmos DB?
On Implement a custom conflict resolution policy for Azure Cosmos DB for NoSQL
I've always used gateway mode. What are the challenges when switching to direct mode?
On Choose a connectivity mode (gateway versus direct)
Thanks for the insights!
On Write calculations that use DAX variables and functions, for example handling blanks or errors, creating virtual relationships, and working with iterators
Can someone explain how to handle the result from a PREDICT function in a Power BI dashboard?
On Use a machine learning PREDICT function in a query
I found the section on hyperparameter tuning particularly useful.
On Evaluate a model