Weekly reading #18
Ready for vacations? The CodingFamily team is almost ready – we have some vacations plans including great conferences during summer and in the autumn.
Itzik Ben-Gan has written an excellent article about pitfalls and best practices. This one is the third one (you should read the entire series!!!) and Itzik focuses on joins. Joins are easy? Yes, they are but…
Brent has told us how you should change your attitude when you need to be a cloud-DBA. What are the important topic to learn? What questions should you ask? Great reasource!
Amit Bansal is a SQL Server MCM and he loves to share his knowledge. In this video you will understand how to find out the memory consumption by buffer pool and break it up further by databases and objects
Paul Randal continues his great series about not so trivial cases you might be facing when working with SQL Server. This time Paul describes a case when you need to identify on which page an index row is. Beware! He shows sys.fn_PhysLocCracker function!!!!
Leila had a great session about playing with AI inside the PowerBI . There is a huge demand to get more insight from the data using AI and advanced analytics. She has shown how to use current visual and custom visual in Power BI to get more insight from your data. Also, learn how to use current embedded AI features in Power BI.