Categories: Varia

T-SQL Tuesday #121: Gifts received for this year

It’s T-SQL Tuesday time again! This edition is hosted by Malathi (blog|twitter) and the subject is looking back at the past year.

So what do I have to be thankful for? A couple of quick thoughts:

  • Power BI Desktop finally has included the decomposition tree visualization! It was the last piece of the puzzel: PerformancePoint had it, but it was missing in Power BI for years. Now there’s no excuse to use SharePoint BI (or what’s left of it). Hoozah. Of course there are many more features released this year for Power BI; too many too mention. I’m really happy the Power BI team keeps cranking out features every month.
  • I got to speak at DataGrillen this year (formerly known as SQLGrillen). It’s a fantastic event and I met a lot of great people from the #SQLFamily. Interesting sessions and above all: nice beers. 🙂
    There were other cool events as well: Techorama, Dataminds Connect and Cloudbrew this Friday.
  • The Azure-SSIS Integration Runtime start-up time went from 30 minutes to 5 minutes. Awesome.
  • Azure Data Factory has put mapping data flows in general availability. If you want to create big data transformation pipelines, the days of writing code are over. 🙂
  • There is finally a preview of Power Query in SSIS!

I hope there’s much more to come in 2020!




------------------------------------------------
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.

Recent Posts

dataMinds Connect 2025 – Slides & Scripts

You can find all the session materials for the presentation "Indexing for Dummies" that was…

4 days ago

Cloud Data Driven User Group 2025 – Slides & Scripts

The slidedeck and the SQL scripts for the session Indexing for Dummies can be found…

2 weeks ago

Retro Data 2025 – Slidedeck

You can find the slides of my session on the €100 DWH in Azure on…

3 weeks ago

Secure Logic Apps with OAuth Authorization

I've used Logic Apps a couple of times over the past years for simple workflows,…

4 weeks ago

Free Online Sessions – Building the €100 DWH and Indexing for Dummies

I'm giving two online sessions soon on virtual events that are free to attend. The…

1 month ago

How to Install SQL Server 2025 RC0 on an Azure VM

I wanted to try out the new JSON index which is for the moment only…

1 month ago