Open Source Power BI Desktop Workshop
I’ve created a free, open-source workshop to teach people the capabilities and features of Power BI Desktop. I was inspired...
2017-02-13
1,139 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
Microsoft Data Platform MVP Award
I’m very pleased, humbled, surprised and overall gleeful to announce I’m awarded the Microsoft Data Platform MVP 2017 Award.
This is...
2017-02-02
504 reads
Speaking at Techorama 2017
I’m delighted to announce that I’m selected as a speaker for the Techorama event.
Techorama is a developer congress focusing (but...
2017-01-31
670 reads
Help me raise money for cancer research #tourneeminerale
In Belgium, a national campaign is launched to raise money for cancer research: #TourneeMinerale. In this campaign, people can be...
2017-01-19
555 reads
T-SQL Tuesday 86: SQL Server Bugs & Enhancement Requests
Let’s kick off the new year with a T-SQL Tuesday! This month’s edition is hosted by Brent Ozar:
Announcing T-SQL Tuesday...
2017-01-10
473 reads
Clustered Columnstore Index really hates Updates
First a little background. I’m working on a large fact table that behaves itself as a slowly changing type 2...
2017-01-03 (first published: 2016-12-23)
4,921 reads
Master Data Services Error – Missing Temp Directory
I recently had to install SQL Server 2016 again on my Windows 10 machine. This also meant that I had...
2016-12-15
2,005 reads
SSIS Naming Conventions 2.0
People who have been working for a while with Integration Services probably know the legendary blog post by SQL Server...
2016-12-13 (first published: 2016-12-02)
5,363 reads
Problem where you can only browse Google websites
Note: not a SQL/BI related post like usual, but since it’s a common issue I want to share my solution...
2016-12-01
528 reads
SQL Server 2016 service pack 1 is here!
SQL Server 2016 service pack 1 has been released and it is a mayor one! You can download it here.
Why,...
2016-11-30 (first published: 2016-11-22)
2,428 reads
Blogs
My 2024 in Data: Health and Workouts
By Steve Jones
This is my last week of the year working (I guess I come back...
My 2024 in Data: Reading
By Steve Jones
This is my last week of the year working (I guess I come back...
Book Review – Agile Data Warehouse Design
I recently read the book Agile Data Warehouse Design – Collaborative Dimensional Modeling, from...
Forums
Need ADF pipeline suggestion to copy 1 million files
I have an ADF pipeline that copies Files from source to destination. Both Source...
Function Defaults
Comments posted to this topic are about the item Function Defaults
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