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
Видео Power BI DirectQuery and SQL Databases: A Conversation with Bob Ward канала Guy in a Cube
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
Видео Power BI DirectQuery and SQL Databases: A Conversation with Bob Ward канала Guy in a Cube
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
![Power BI Get Data: Import vs. DirectQuery vs. Live (2021)](https://i.ytimg.com/vi/-ip7mKUdwRg/default.jpg)
![The How and Why of Power BI Aggregations](https://i.ytimg.com/vi/EhGF372t0sU/default.jpg)
![Native Query: Be careful when using in Power BI](https://i.ytimg.com/vi/DWbh7xp08l0/default.jpg)
![Import vs DirectQuery in Power BI](https://i.ytimg.com/vi/tDIsCVB7mnI/default.jpg)
![What the HECK is a Power BI Gateway Cluster?](https://i.ytimg.com/vi/sPFRLy6XL1s/default.jpg)
![Azure Synapse Analytics & Power BI for BANANAS SCALE!](https://i.ytimg.com/vi/vOSzw40TohM/default.jpg)
![DirectQuery Connection in Power BI How does it work Limitations and Advantages](https://i.ytimg.com/vi/GWAWPCAjkEY/default.jpg)
![Build a Slicer Panel in Power BI and take it to the next level](https://i.ytimg.com/vi/xy9nmSQeUWg/default.jpg)
![NEXT LEVEL Conditional Drill in Power BI Desktop with buttons](https://i.ytimg.com/vi/4Qy-bksqExI/default.jpg)
![Debugging a slow Power BI report with Phil Seamark](https://i.ytimg.com/vi/eABg872TAJU/default.jpg)
![2 ways to reduce your Power BI dataset size and speed up refresh](https://i.ytimg.com/vi/c-ZqToc85Yc/default.jpg)
![Taking Buttons in Power BI Desktop to the Next Level](https://i.ytimg.com/vi/hEAtbGrlKhY/default.jpg)
![9 things to know before getting into Power BI (Or, really anything)](https://i.ytimg.com/vi/EolSBRkNpbk/default.jpg)
![Using Images from a Database in Power BI](https://i.ytimg.com/vi/Q82yzcfkqAc/default.jpg)
![Get started with the Power BI Gateway](https://i.ytimg.com/vi/Vlv1tbuZNcM/default.jpg)
![Handling MULTIPLE fact tables in Power BI](https://i.ytimg.com/vi/TnyRsO4NJPc/default.jpg)
![DAX! Uggg - Where do you start? | Power BI](https://i.ytimg.com/vi/3gpXMMRJjw8/default.jpg)
![Blend Power BI datasets with Excel files? INSANE AMAZING!](https://i.ytimg.com/vi/ZSyYegfA6PQ/default.jpg)
![Power BI - What You Need to Know About Direct Query](https://i.ytimg.com/vi/X_itAoq4ink/default.jpg)
![Data modeling best practices - Part 1 - in Power BI and Analysis Services](https://i.ytimg.com/vi/kiVXI7zjSzY/default.jpg)