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

Tag: sql server

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

How to Install SQL Server 2022

November 17, 2022November 21, 2022 Koen Verbeeck 6 Comments

SQL Server 2022 has been released! In this blog post, I’ll walk you through how you can install the latest version of SQL Server on your machine. I’ll be using the developer edition of SQL Server 2022, which can be downloaded here. The download link will only download a small 4MB file. Opening this file […]

Read More

Speaking Engagements for Fall 2022

August 23, 2022August 23, 2022 Koen Verbeeck Leave a comment

The summer holiday is almost over, and this means conference season will be back in full swing again. I’ll be speaking at a couple of events in the second half of this year: Data Bash. A new free virtual conference focusing on the German-speaking nations in Europe. And on data of course. There are sessions […]

Read More

Cool Stuff in SQL Server 2022 – IS DISTINCT FROM

August 4, 2022August 4, 2022 Koen Verbeeck Leave a comment

I have a blog post series about some nice features in the Snowflake cloud data warehouse; one of them is about the IS [NOT] DISTINCT FROM predicate. I was excited to find out this is now also included in the T-SQL language since the SQL Server 2022 CTP 2.1 preview! You can find the official […]

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

Parsing JSON in SQL Server with OPENJSON

March 28, 2022March 28, 2022 Koen Verbeeck Leave a comment

Recently I had a piece of JSON of which I needed to extract data from to put into a table in Azure SQL DB. Unfortunately, the structure of the JSON itself was too complex to map automatically in Azure Data Factory. It might be possible though, but after a few tries to map it manually […]

Read More

Posts pagination

1 2 … 6 Older posts

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