Skip to main content
Under the kover of business intelligence
  • Home
  • Copyright
  • About

Tag: performance tuning

Book Review – Microsoft Power BI Performance Best Practices

November 19, 2024November 25, 2024 Koen Verbeeck Leave a comment

I was asked to do a review of the book Microsoft Power BI Performance Best Practices 2nd edition (Amazon link), which means I got a copy for free. The book is written by Thomas Leblanc and Bhavik Merchant and published by Packt. As the title obviously implicates, the book aims to give you a set […]

Read More

Book Review – SQL Server Query Tuning and Optimization (2nd Edition)

December 2, 2022December 2, 2022 Koen Verbeeck Leave a comment

The nice people from Packt Publishing sent me a digital copy of Benjamin Nevarez new book to review: SQL Server Query Tuning and Optimization – Optimize Microsoft SQL Server 2022 queries and applications. It says first edition on the cover, but that’s because it’s the first time this book has been published by Packt. The […]

Read More

Speaking at dataMinds Connect 2022

June 16, 2022June 16, 2022 Koen Verbeeck Leave a comment

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 […]

Read More

Optimize for Unknown for Inline Table-Valued Functions

September 17, 2020September 17, 2020 Koen Verbeeck Leave a comment

I had a curious performance issue today. An inline table-valued function (iTVF) was performing poorly for some parameter sets, and quite fast for other parameter values. In short, this one is fast: This one is slow: Turns out SQL Server used a plan with a hash join in the fast query, and a nested loop […]

Read More

An update on AutoAdjustBufferSize in SSIS 2016

July 27, 2016July 27, 2016 Koen Verbeeck Leave a comment

This week SQL Server 2016 Cumulative Update 1 was released and it contains a lot of updates/fixes for SSIS, SSAS, SSRS and MDS. If you are already working on SQL Server 2016, I’d urge to install this update as soon as possible. Anyway, one of the particular updates that caught my attention was Adds the adjusted […]

Read More

Feed

RSS

Social

  • Twitter
  • LinkedIn

MVP

Microsoft Data Platform MVP

star schema all the things
Get your star schema merchandise

Author of the Year 2014/2020/2023

Support this blog and buy me a beer

Recent Posts

  • Techorama 2025 – Slides
  • Redgate SQL Prompt in SSMS 21
  • Execute Fabric Data Pipeline from Azure Data Factory
  • Azure Data Factory Pipeline Debugging Fails with BadRequest
  • Call a Fabric REST API from Azure Data Factory

Categories

  • Azure (25)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (57)
  • Fabric (19)
  • Power BI (41)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (113)
    • MDS (8)
    • SSAS (12)
    • SSIS (46)
    • SSRS (13)
    • TSQL (9)
  • Varia (37)
  • Twitter
  • LinkedIn
  • Home
  • Copyright
  • About
Under the kover of business intelligence All rights reserved. Theme by Colorlib Powered by WordPress