Ask HN: Would you run SQL Server on Linux?
Hacker News is one of the best sources for technical news out there. I check HN at least once a...
2017-09-28
565 reads
The Database Avenger
Docker images for custom SQL Server Installations
I no longer install SQL Server on my workstation, I use Docker to spin up instances as and when I...
2017-08-22
1,727 reads
Automating tSQLt Unit Tests
This is the ninth part in the series: SQL Server and Continuous Integration. In this post I’ll add some unit tests...
2017-07-31
1,635 reads
Orchestrating SQL Server with Kubernetes
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-06-22 (first published: 2017-06-13)
6,391 reads
SQL Server on Docker with new Environment Variables
As of CTP 2.1 for SQL Server 2017 a set of new environment variables are available. These variables allow us...
2017-05-17
3,320 reads
T-SQL Tuesday #90 Shipping Database Changes – Wrap Up
I’d like to say a huge thank you to everyone who read or published a post for T-SQL Tuesday #90....
2017-05-16
411 reads
T-SQL Tuesday #90 – Shipping Database Changes
I was once asked to add a new feature to an application. It was installed on multiple SQL Server instances...
2017-05-02
399 reads
Avoiding Cloud Lock In – T-SQL Tuesday
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-04-11
597 reads
Building SQL Server Projects with GitLab Runners
This is the eighth part in the series: SQL Server and Continuous Integration. This post describes the set-up required for GitLab runners to...
2017-04-07 (first published: 2017-03-22)
7,901 reads
Is Your Data Open to Abuse? T-SQL Tuesday
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-03-24 (first published: 2017-03-14)
1,860 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