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