Categories: Events

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.


------------------------------------------------
Do you like this blog post? You can thank me by buying me a beer 🙂
Koen Verbeeck

Koen Verbeeck is a Microsoft Business Intelligence consultant at AE, helping clients to get insight in their data. Koen has a comprehensive knowledge of the SQL Server BI stack, with a particular love for Integration Services. He's also a speaker at various conferences.

View Comments

  • i would be glap to attend such a webinar , am a business intelligence engineer aiming to reach expertise in this domain

Recent Posts

Free webinar – Tackling the Gaps and Islands Problem with T-SQL Window Functions

I'm hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC.…

5 days ago

dataMinds Connect 2024 – Session Materials

The slides and scripts for my session "Tackling the Gaps & Islands Problem with T-SQL…

4 weeks ago

Connect to Power BI as a Guest User in another Tenant

Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as…

2 months ago

How to use a Script Activity in ADF as a Lookup

In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a…

4 months ago

Database Build Error – Incorrect syntax near DISTINCT

I wrote a piece of SQL that had some new T-SQL syntax in it: IS…

4 months ago

Speaking at dataMinds Connect 2024

I'm very excited to announce I've been selected as a speaker for dataMinds Connect 2024,…

5 months ago