Common Mistakes in SQL Server – Final
In this final and summary post on the blog series of Common Mistakes in SQL Server I have pen down about auto growth, use of null values, implicit conversion...
2023-11-15 (first published: 2023-10-30)
545 reads
Blog Posts
Deploying Indexes with SQL Compare
I suspect many people assume this is the case, but a customer recently asked if SQL Compare handles indexes. It does, and this post shows the basics of index...
2023-11-15
157 reads
PASS Data Summit 2023 KeyNote 1
Morning from the PASS Data Summit! I will be live blogging the event today, so check back for announcements and releases throughout the keynote. Today, we have Shireesh Thota,...
2023-11-15
97 reads
SQL Server Recovery Models
When I review customers database environments, I always check to see what the recovery model is for their databases and review that with the customer. I often times have...
2023-11-15
4 reads
Webinar: How to Harden SQL Server
On November 29, 2023, at 11 AM Eastern Standard Time, I'm presenting a webinar on how to harden SQL Server.
2023-11-15
173 reads
My data architecture book is now available for pre-order!
For those looking to be first in line when my book is available for a printed copy, I’m very excited to let you know that it is now available...
2023-11-14
19 reads
T-SQL Tuesday #168–Using Window Functions
I am the host for T-SQL Tuesday this month, and I hope that a lot of people like the topic. This idea actually came to me earlier this year...
2023-11-14
42 reads
About those Read-Only Replicas
In a post, I wrote last month I showed how you can take advantage of your replicas in SQL Sever by adding a single attribute to your connection string...
2023-11-13 (first published: 2023-10-26)
428 reads
Crosstream - Efficient Cross-Server Joins on Slow Networks in Python
Earlier this year I presented at PyCon 2023 in Salt Lake City, UT on the topic of "Efficient Cross-Server Data Joins on Slow Networks with Python". You can watch...
2023-11-13
Data Community Summit Week
I’m up in Seattle this week for the PASS Data Community Summit 2023. This is almost an annual event for me. I’ve missed a few since 1999, but not...
2023-11-13
11 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
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