I’m very excited to announce I’ll be giving a session at the 15th edition of dataMinds Connect (in the beginning it was called SQL Server Day(s)). It will be my 11th session at the event (I think only Nico Jacobs has more; Nico has done a perfect strike: 15 sessions!). I will be talking about T-SQL performance tuning for the BI/DWH/ETL developer (also called data engineer nowadays I guess). 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, writing source queries for reports; all of those task 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. At the end, you’ll walk out with solid knowledge on how to improve your T-SQL skills and deliver results faster. Most of this will also be directly transferable to other databases vendors.
The agenda looks very promising, with many exciting sessions by international and local speakers. As usual, there’s also a precon track on Monday. So what are you waiting for? Get your tickets now, as seats are limited (and you get an early bird discount!).
Hope to see you in Mechelen at the 10th & 11th of October!
I'm hosting a free webinar at MSSQLTips.com at the 19th of December 2024, 6PM UTC.…
The slides and scripts for my session "Tackling the Gaps & Islands Problem with T-SQL…
Sometimes your Microsoft Entra ID account (formerly known as Azure Active Directory) is added as…
In Azure Data Factory (ADF, but also Synapse Pipelines and Fabric Pipelines), you have a…
I wrote a piece of SQL that had some new T-SQL syntax in it: IS…
I'm very excited to announce I've been selected as a speaker for dataMinds Connect 2024,…