Power BI DirectQuery and SQL Databases: A Conversation with Bob Ward

Power BI DirectQuery can have performance implications. Bob Ward shares his knowledge to help make SQL Databases perform better!

Automatic tuning: https://docs.microsoft.com/azure/sql-database/sql-database-automatic-tuning

ColumnStore Indexes: https://docs.microsoft.com/azure/sql-database/sql-database-in-memory

Forced parameterization: https://docs.microsoft.com/sql/relational-databases/performance/specify-query-parameterization-behavior-by-using-plan-guides?view=sql-server-ver15

Intelligent Query Processing: https://docs.microsoft.com/sql/relational-databases/performance/intelligent-query-processing?view=sql-server-ver15

PolyBase: https://docs.microsoft.com/sql/relational-databases/polybase/polybase-guide?view=sql-server-ver15

Connect with Bob Ward: https://twitter.com/bobwardms

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #SQLDatabase #GuyInACube