I’m giving a free webinar for MSSQLTips.com at 11th of August 2022. The abstract:
When building a data warehouse (DWH) in the Microsoft Data Platform stack, you typically have to write a fair share of T-SQL. Loading data into the data warehouse, transforming it into the desired format, troubleshooting and debugging, and writing source queries for reports; all of those tasks require some T-SQL and preferably it’s fast as well.
In this session, we’ll go over some T-SQL best practices from the viewpoint of the BI developer. We’ll also cover indexing for the data warehouse and how you can make that SSRS report a bit faster. In the end, you’ll walk out with solid knowledge of how to improve your T-SQL skills and deliver results faster. Most of this will also be directly transferable to other database vendors.
Note – basic knowledge of T-SQL and SQL Server is assumed.
Basically this presentation is about the idea “if I had to coach a junior starting on a business intelligence project, what would I tell that person regarding T-SQL performance tuning?”. You can register here.
I recently read the book Agile Data Warehouse Design - Collaborative Dimensional Modeling, from Whiteboard…
You can find the slides for the session Building the €100 data warehouse with the…
I was asked to do a review of the book Microsoft Power BI Performance Best…
This is a quick blog post, mainly so I have the code available if I…
Praise whatever deity you believe in, because it's finally here, a tenant switcher for Microsoft…
This book was making its rounds on social media, and the concept seems interesting enough…
View Comments
i would be glap to attend such a webinar , am a business intelligence engineer aiming to reach expertise in this domain