Speaking at Data Community Austria Day 2023
Let me start by wishing everyone the best for the year 2023! We’re going to kick off the new year with a virtual conference: the Data Community Austria Day...
2023-01-09
20 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
How to Specify the Format of the Request Body of an Azure Function
This is a bit of a niche blog post, because you don’t actually need this to make your Azure Function work :). When you create a new HTTP-triggered Azure...
2023-01-02 (first published: 2022-12-16)
193 reads
Book Review – SQL Server Query Tuning and Optimization (2nd Edition)
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-12-26 (first published: 2022-12-02)
322 reads
How to Install Integration Services 2022
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...
2022-12-12 (first published: 2022-11-25)
799 reads
Read data from Azure Synapse Serverless SQL Pools with Azure Data Factory
We have some data we can query using the serverless SQL pools in Azure Synapse Analytics. For this blog post, I’m querying data that is stored in Azure Cosmos...
2022-12-09 (first published: 2022-11-23)
239 reads
How to Store Normalized SQL Server Data into Azure Cosmos DB
Recently I got a hold of my Untappd data. For those who don’t know the app, it’s a rating app for beers. You can check-in a beer each time...
2022-12-05 (first published: 2022-11-21)
249 reads
User Group Meeting – Migrate your SSIS skills to ADF & More
This Monday (the 5th of December 2022), my employer AE hosts a user group meeting for dataminds. There will be two sessions: It’ll be a very interesting evening, and...
2022-11-30
12 reads
How to Install SQL Server 2022
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...
2022-11-28 (first published: 2022-11-17)
1,791 reads
Session Materials – PASS Data Community Summit and Cloudbrew
You can find the slides and demo scripts for my sessions at Cloudbrew (Snowflake) and PASS Data Community Summit (Migrate SSIS skills to ADF) in my Github repo. If...
2022-11-19
9 reads
Webinar: Enhancing Your ETL Pipelines with Custom Data Cleansing and Matching
At Tuesday the 13th of December, I give a webinar about Unison, a self-service online data quality tool of Melissa Data. This is a 30-minute webinar, sponsored by Melissa...
2022-11-10
7 reads
Blogs
My 2024 in Data: Reading
By Steve Jones
This is my last week of the year working (I guess I come back...
My 2024 in Data: Speaking
By Steve Jones
This is my last week of the year working (I guess I come back...
Top 5 Advanced SQL Courses for 2025 (Must-Know)
Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...
Forums
Function Defaults
Comments posted to this topic are about the item Function Defaults
Big Data or Small Data
Comments posted to this topic are about the item Big Data or Small Data
Question of the Day
Function Defaults
I have created this function in SQL Server 2022:
CREATE FUNCTION dbo.AddInt (@one INT, @two INT = 1) RETURNS INT
AS
BEGIN
RETURN @one + @two
END
How can I call this and invoke the default value for @two? See possible answers