T-SQL Best Practices and Tuning for the BI/DWH Developer
MSSQLTips sponsored on-demand webinar
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.
Speaker - Koen Verbeeck
To access materials please fill out the form below.