T-SQL Tuesday #96 – Folks Who Have Made a Difference in my career #TSQL2sday
This months TSQL Tuesday subject is a shout out and high-five to those people who have inspired or made a contribution...
2017-11-14
690 reads
T-SQL Tuesday #96 How did I get started?
Hi Folks,
I’m the new guy that my two colleagues are still trying to convince to write my first blog post...
2017-11-14
448 reads
UNDERCOVER TOOLBOX: Using Python To Copy A SQL Login From One Server To Another
Recently I’ve been thinking about Python and whether it can be useful to the DBA as well as the data...
2017-10-30
387 reads
UNDERCOVER TOOLBOX: Find Untrusted Foreign Keys and Orphaned Key data
SQL Server tracks untrusted Foreign keys in sys.Foreign keys with a column called is_not_trusted, there may be a number of...
2017-10-24
186 reads
Connecting to a Remote Instance of SQL Server Using Python
SQL Server’s integration of Python has been heavily marketed towards the machine learning and BI guys, but does it offer...
2017-10-18
960 reads
How Far Has My Update Got? Finding Out How Many Rows Your Long Running Insert, Update or Delete Has Actually Modified So Far
I’m pretty sure that we’ve all found ourselves in the situation where we’ve run an INSERT, UPDATE or DELETE script...
2017-10-05
169 reads
Failed to perform AlwaysOn Manual Failover using the wizard – Availability-group DDL Operations are permitted only when you are using the master database .
Routine maintenance rolls around and it’s time to failover your AG’s to new Primary’s to allow for patching and restarts…...
2017-10-04
305 reads
SQL Mirroring, Preserving the Log Chain During Database Migrations
This is a reblog of a post that I originally wrote back in January. After using this technique again last...
2017-10-03
127 reads
Concatenation Truncation – Are your strings being truncated?
It wasn’t until recently that i paid attention to truncation during concatenation, but that’s because whenever I used concatenation before...
2017-09-27
1,200 reads
Copying Data From One Table To Another – To Disable Indexes or Not To Disable Indexes, That’s the Question.
As the famous Bard once said, “To disable indexes or not to disable indexes, that is the question?”. Well maybe...
2017-09-25
150 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