Blog Post

Free Webinar – T-SQL Best Practices and Tuning for the BI/DWH Developer

,

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.

The post Free Webinar – T-SQL Best Practices and Tuning for the BI/DWH Developer first appeared on Under the kover of business intelligence.

Original post (opens in new tab)
View comments in original post (opens in new tab)

Rate

You rated this post out of 5. Change rating

Share

Share

Rate

You rated this post out of 5. Change rating