Kendra’s Top 3 Tips for Working Remotely
A guest editorial today from Kendra has a few tips for working from home.
2024-04-15 (first published: 2020-03-12)
1,272 reads
Down Tools Week 2020 (10 minute video/podcast episode)
In this episode of Dear SQL DBA, I talk about how Redgate runs "Down Tools Week," what I'm working on as part of the project, and how this has...
2020-08-21 (first published: 2020-08-06)
188 reads
Things That Shouldn’t Be Normal in Database Development (28 minute video/podcast episode)
Many people use entrenched processes for database development that have been in place so long that it’s hard to imagine doing it any other way. In this episode, I...
2020-08-11 (first published: 2020-07-30)
730 reads
Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)
I'm not an expert on collation in SQL Server, but there are a few important facts which I've had to learn the hard way.
In this episode I share...
2020-07-27 (first published: 2020-07-16)
926 reads
How to Spell and Capitalize tempdb for SQL Server
No matter what I write in this post, some of y'all are going to tell me I'm wrong. That's inevitable, because I'm writing about tempdb: a database so complex...
2020-07-24 (first published: 2020-07-15)
619 reads
Why I’m Learning Git via the Command Line Interface
Today Kendra discusses the advantages of using a command line interface for Git.
2020-01-16
407 reads
The Case for Considering Git
Today we have a guest editorial from Kendra Little that looks at choosing a version control system as you adopt a Database DevOps software development process.
2019-04-19
542 reads
2019-03-05
870 reads
Why Redgate is Running a Database Development Disasters Contest?
Kendra Little explains why Redgate would like to hear your stories of how the database has been left behind.
2019-02-14
238 reads
2019-01-21
112 reads
Blogs
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...
My 2024 in Data: Speaking
By Steve Jones
This is my last week of the year working (I guess I come back...
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