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

Category: Snowflake

Cool Stuff in Snowflake – Part 14: Asynchronous Execution of SQL Statements

March 17, 2025March 17, 2025 Koen Verbeeck Leave a comment

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share. It might be some SQL function that I’d really like to be in SQL Server, it might be something else. It’s been a while since I […]

Read More

Book Review – Snowflake Security

April 2, 2022April 2, 2022 Koen Verbeeck 1 Comment

When I was working with Snowflake on a project, it seemed security (assigning roles to users, assigning permissions etc.) is not as straight forward as it is in SQL Server. That’s why I bought the book Snowflake Security – Securing Your Snowflake Data Cloud, written by Ben Herzberg and Yoav Cohen, and published by Apress. […]

Read More

Book Review – Mastering Snowflake Solutions: Supporting Analytics and Data Sharing

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

Disclaimer: Apress gave me a free copy of the book to review. People that know me, also know I always give honest feedback 🙂 I had the pleasure of reading the book Mastering Snowflake Solutions: Supporting Analytics and Data Sharing. The book is aimed at data professionals who have already taken their first steps developing […]

Read More

Execute SQL Scripts on Snowflake using Azure Data Factory

March 13, 2022March 13, 2022 Koen Verbeeck 1 Comment

Azure Data Factory has a new activity introduced this week (around the 10th of March 2022 for you future readers): the Script activity! This is not to be confused with the script task/component of SSIS, which allows you to execute .NET script (C# for most people, or VB if you’re Ben Weissman). No, this task […]

Read More

Speaking at SQLSaturday Denmark 2020

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

I’m delighted to announce I’m speaking at the virtual SQLSaturday Denmark at the 26th of September 2020. I’ll be speaking about the cloud datawarehouse Snowflake and its integration with Azure. The era of cloud data warehousing has finally begun. Gone are the days where you had to provision expensive servers and spend days configuring and […]

Read More

Speaking at GroupBy Conference – Spring 2020

May 6, 2020May 6, 2020 Koen Verbeeck Leave a comment

I’m excited to announce I’ll be speaking at the virtual GroupBy conference this year. Thanks everyone who voted! I’ll be speaking at the European day on May 12th at 10AM UTC. My submitted session with the most votes was: The modern Cloud Data Warehouse – Snowflake on Azure (you can find more information about this […]

Read More

Cool Stuff in Snowflake – Part 12: IS DISTINCT FROM

April 29, 2020September 10, 2020 Koen Verbeeck Leave a comment

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share. It might be some SQL function that I’d really like to be in SQL Server, it might be something else. Often you want to check the […]

Read More

Cool Stuff in Snowflake – Part 11: RESULT_SCAN

February 4, 2020February 4, 2020 Koen Verbeeck Leave a comment

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share. It might be some SQL function that I’d really like to be in SQL Server, it might be something else. This post builds upon part 6 […]

Read More

Cool Stuff in Snowflake – Part 10: RATIO_TO_REPORT

October 2, 2019September 10, 2020 Koen Verbeeck 1 Comment

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share. It might be some SQL function that I’d really like to be in SQL Server, it might be something else. This episode talks about a […]

Read More

Cool Stuff in Snowflake – Part 9: ILIKE

June 18, 2019October 2, 2019 Koen Verbeeck Leave a comment

I’m doing a little series on some of the nice features/capabilities in Snowflake (the cloud data warehouse). In each part, I’ll highlight something that I think it’s interesting enough to share. It might be some SQL function that I’d really like to be in SQL Server, it might be something else. Today I have a small […]

Read More

Posts pagination

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