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

Tag: sql server

dataMinds Connect 2025 – Slides & Scripts

October 8, 2025October 6, 2025 Koen Verbeeck Leave a comment

You can find all the session materials for the presentation “Indexing for Dummies” that was presented at the dataMinds Connect 2025 conference at GitHub.

Read More

Cloud Data Driven User Group 2025 – Slides & Scripts

September 25, 2025September 25, 2025 Koen Verbeeck Leave a comment

The slidedeck and the SQL scripts for the session Indexing for Dummies can be found on Github.

Read More

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

September 11, 2025September 11, 2025 Koen Verbeeck Leave a comment

I’m giving two online sessions soon on virtual events that are free to attend. The first one is at Retro Data (20th of September), a new virtual conference focusing on established technology, instead of preview features. My session Building the €100 data warehouse with the Azure Data Platform at 10AM UTC+2. The other session is […]

Read More

How to Install SQL Server 2025 RC0 on an Azure VM

September 5, 2025September 5, 2025 Koen Verbeeck Leave a comment

I wanted to try out the new JSON index which is for the moment only available in the SQL Server 2025 preview version. I know, it’s not even available in Azure SQL DB. Cloud not first? What? I already had a virtual machine in Azure, running SQL Server 2025 CTP 2.0 (which uses a pre-made […]

Read More

Free Webinar – Build a data warehouse on Azure Data Platform for $150

June 11, 2025June 11, 2025 Koen Verbeeck Leave a comment

I’m presenting a free webinar at MSSQLTips.com at Thursday, July 10, 2025 at 6PM UTC (8PM CET or 2PM EDT). The abstract: As you might learn from the abstract, the session is aimed at people working with “small data”. Just a couple of gigabytes, biggest table is below 100 million rows. But you would be […]

Read More

dataMinds Connect 2024 – Session Materials

October 10, 2024October 10, 2024 Koen Verbeeck Leave a comment

The slides and scripts for my session “Tackling the Gaps & Islands Problem with T-SQL Window Functions” at dataMinds Connect 2024 can be downloaded from GitHub. If you want to run the sample scripts, some of them require an installation of the AdventureWorks DW sample database.

Read More

New Stars of Data – SQL Bad Practices caught in the Wild

May 11, 2023May 12, 2023 Koen Verbeeck Leave a comment

At the 12th of May 2023, a new edition of New Stars of Data takes place. If you’re not familiar with the concept, it’s a free virtual event focusing on the Microsoft Data Platform, organized by the fine folks of DataGrillen. The twist is that only new speakers are allowed; people who have never spoken […]

Read More

Book Review – SQL Query Design Patterns and Best Practices

March 5, 2023March 5, 2023 Koen Verbeeck 1 Comment

Disclaimer: The publisher – Packt – sent me a free copy of the book for the intended purpose of a review. At the time of writing, the book is yet to be released (the date is set at the 22nd of March 2023). The book SQL Query Design Patterns and Best Practices: A practical guide […]

Read More

CONCAT_WS Function Truncates Text

January 31, 2023January 31, 2023 Koen Verbeeck 2 Comments

I was writing some dynamic SQL that generates some SQL statements to load my facts and dimensions into a data warehouse. Some of those SQL statements can become very long, for example if a dimension has a lot of columns. When debugging, I noticed a couple of statements failing with various errors. Turns out, they […]

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

Posts pagination

1 2 … 7 Older posts

Feed

RSS

Social

  • Twitter
  • LinkedIn

Former MVP

Former Microsoft Data Platform MVP (2017-2025)

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

  • dataMinds Connect 2025 – Slides & Scripts
  • Cloud Data Driven User Group 2025 – Slides & Scripts
  • Retro Data 2025 – Slidedeck
  • Secure Logic Apps with OAuth Authorization
  • Free Online Sessions – Building the €100 DWH and Indexing for Dummies

Categories

  • Azure (28)
  • Azure Data Factory (27)
  • Azure Devops (5)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (61)
  • Fabric (19)
  • Power BI (42)
  • Professional Development (9)
  • Snowflake (14)
  • SQL Server (114)
    • 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