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

Category: SQL Server

Redgate SQL Prompt in SSMS 21

May 21, 2025May 21, 2025 Koen Verbeeck Leave a comment

Disclaimer: this post is not sponsored by Redgate 🙂 For those who’ve missed it, the new version of SSMS is now generally available. It’s a big new version and it now uses Visual Studio 22 behind the scenes, so it’s now installed through the Visual Studio Installer. Anyway, I’m a big fan of Redgate SQL […]

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

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

How to Install Integration Services 2022

November 25, 2022November 25, 2022 Koen Verbeeck Leave a comment

The title of this blog post is a bit misleading, because what we actually want to do is to install the SSIS development functionality in Visual Studio 2022. SSAS and SSRS have been available for some time now in VS 2022, but the extension for SSIS has only just been released in preview. For those […]

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

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

t-sql tuesday long

T-SQL Tuesday #149 – T-SQL Advice you’d give to your younger self

April 12, 2022April 12, 2022 Koen Verbeeck Leave a comment

It’s the second Tuesday of the month, so it’s time for the T-SQL Tuesday blog party! This month’s topic is chosen by Camila Henrique (blog): what T-SQL advice would you give to your younger self? Here’s a little list I’d tell anyone starting out with T-SQL: you can configure most tools that when you hit […]

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

Convert Local Datetime to UTC (pre-SQL Server 2016)

February 17, 2022February 26, 2024 Koen Verbeeck Leave a comment

Recently I was working with a client who was still on SQL Server 2012. Support issues aside, there are some very useful T-SQL functions/clauses who didn’t exist in 2012, but were introduced in a later version. One of them is AT TIME ZONE, which you can use the convert dates between time zones, as demonstrated […]

Read More

t-sql tuesday long

T-SQL Tuesday #143 – Short code examples

October 12, 2021October 8, 2021 Koen Verbeeck Leave a comment

It’s this time of the month again! T-SQL Tuesday is a monthly blogging party on the second Tuesday. This month’s topic is “What are your go to handy short scripts?” brought to you by John McCormack. What are those little short bits of code that you can’t live without? I’m talking about little snippets that […]

Read More

Posts pagination

1 2 … 12 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

  • 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
  • Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements

Categories

  • Azure (25)
  • Azure Data Factory (25)
  • Azure Devops (4)
  • Book Review (26)
  • Business Intelligence (29)
  • Events (56)
  • 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