Kenneth Fisher

My name is Kenneth Fisher and I am Senior DBA for a large (multi-national) insurance company. I have been working with databases for over 20 years starting with Clarion and Foxpro. I’ve been working with SQL Server for 12 years but have only really started “studying” the subject for the last 3. I don’t have any real "specialities" but I enjoy trouble shooting and teaching. Thus far I’ve earned by MCITP Database Administrator 2008, MCTS Database Administrator 2005, and MCTS Database Developer 2008. I’m currently studying for my MCITP Database Developer 2008 and should start in on the 2012 exams next year. My blog is at https://sqlstudies.com/.

sp_SrvPermissions & sp_DBPermissions V4.0

by Kenneth Fisher

SQLStudies

These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...

2014-01-15

894 reads

Transactions: Rolling back a transaction inside a stored procedure.

by Kenneth Fisher

SQLStudies

So over the last couple of posts I’ve talked about the fact that the ROLLBACK command will roll back an...

2014-01-13 (first published: 2014-01-06)

7,036 reads

Transactions: What are they?

by Kenneth Fisher

SQLStudies

I’ve done a couple of posts now talking about how rolling back a transaction works. I thought this time I...

2014-01-08

1,392 reads

Happy new year!

by Kenneth Fisher

SQLStudies

Happy New Years! It’s the first day of the year and it’s a day known for setting goals. I had...

2014-01-01

631 reads

The 12 days after release

by Kenneth Fisher

SQLStudies

On the first day after release my developer gave to me
a performance problem on a crucial query
On the second day...

2013-12-24

784 reads

SSMS Shortcuts and more

by Kenneth Fisher

SQLStudies

I went and voted for #tribalawards and when I was finished they offer you links to 6 different free PDFs....

2013-12-23

681 reads

Transactions: Rolling back part of a transaction.

by Kenneth Fisher

SQLStudies

In my previous post I mentioned the fact that the ROLLBACK command rolls back the entire transaction all the way...

2013-12-19

653 reads

Transactions: Rolling back a nested transaction

by Kenneth Fisher

SQLStudies

Transactions are great and wonderful things. They make sure that our work stays atomic, consistent, isolated and durable (yes ACID)....

2013-12-17

1,517 reads

T-SQL Tuesday #49: Wait for it

by Kenneth Fisher

SQLStudies

It’s T-SQL Tuesday again and this time it’s being hosted by the SQL Soldier. He’s picked the subject of Waits....

2013-12-10

849 reads

Finding active DTS packages

by Kenneth Fisher

SQLStudies

DTS is dead, long live SSIS. Way back when SQL 2005 was announced then released DTS was pronounced DOA. SSIS...

2013-12-09 (first published: 2013-11-27)

3,163 reads

Blogs

My 2024 in Data: Reading

This is my last week of the year working (I guess I come back...

My 2024 in Data: Speaking

This is my last week of the year working (I guess I come back...

Top 5 Advanced SQL Courses for 2025 (Must-Know)

By Tracy McKibben

Want to seriously boost your data skills? Mastering advanced SQL is the key, whether...

Read the latest Blogs

Forums

Need ADF pipeline suggestion to copy 1 million files

I have an ADF pipeline that copies Files from source to destination. Both Source...

Backup issues

I''m running a stripped backup (2 files) to a Network share. It's a 32gig...

Function Defaults

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Function Defaults

Visit the forum

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