Profile

Mason Lavoie
Mason Lavoie
This user account status is Approved
About About
Posts Posts
Comments Comments
Awesome post! Helped me a lot.
On Implement data change tracking
How much of a difference does IQP make in transactional vs analytical workloads?
On Configure intelligent query processing (IQP)
Not sure this covers every aspect I'd hoped but generally good.
On Configure server and database audits
First, check for blocking sessions in your database. You can use the 'sp_who2' command in SSMS to identify any blocking.
On Troubleshoot SQL Server Agent jobs
This was incredibly useful. Thank you!
On Create and manage data assets
Thanks for the detailed explanation!
On Choose when to distribute data
I feel this blog post missed out on deeper technical details.
On Implement incremental refresh (including the use of query folding)
Imperative operations give you better control over the execution flow.
On Choose when to use declarative versus imperative operations
Is there a way to automate performance testing using DAX Studio?
On Choose when to use external tools, including DAX Studio and Tabular Editor 2
This is a great resource, thanks!
On Perform a query against the transactional store from Spark
load more comments