Making Deployments Simpler with Re-runnable Scripts
Make sure your SQL Server database release scripts to make life easier.
2018-04-20 (first published: 2015-11-17)
9,905 reads
Ed Elliott
2017-04-07 (first published: 2015-11-11)
12,380 reads
Plan for failure in automated deployments
Failures happen with manual and automated releases, they are a fact of life. Make sure you know how and when to rollback failed deployments
2015-12-31
1,679 reads
Write Cleaner T-SQL Using Version Control
If we only use version control as a way to back up our code then it is pure overhead but actually there are real benefits. We can use source control to write better, cleaner, more readable code.
2015-10-05
6,117 reads
Version Control - Just Start Doing It?
Read a call to get started using Version Control with your database code with a few ideas on how this can help you.
2015-09-15
6,163 reads
Is It Worth Writing Unit Tests?
What's the overhead for writing unit tests? Ed Elliot breaks it down, looking at the ways in which unit tests both take more time and save time.
2015-07-23
8,469 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