Article re-featured on SQLServerCentral
The second article I had published on SQLServerCentral, ANSI PADDING, Trailing Whitespace, and Variable Length Character Columns, was re-featured in...
2009-07-31
1,408 reads
Jack Corbett
- Interests: Sports, books, Bible
ActiveAugust –> Getting More Fit
ActiveAugust started as a discussion on Twitter and Mike Walsh (@mike_walsh) has set the bar with his blog post about...
2009-07-28
1,193 reads
SQLSaturday 21 – Orlando Announced!
Andy Warren and crew at OPASS have announced that SQLSaturday 21 – Orlando will be held at Seminole Community College, 100...
2009-07-28
1,294 reads
Learning some javascript
As part of my work I need to be a “Jack of all trades” meaning I not only need to...
2009-07-24
638 reads
Meet, Greet, & Remember?
How many of you have said, “I have a real hard time remembering names” or “Excuse me, I know we...
2009-07-21
410 reads
Mystery of Failing Database Mail
Have you ever seen this error when you have setup database mail:
The mail could not be sent to the recipients...
2009-07-20
415 reads
July OPASS Meeting Recap
Last night I attended, along with about 20 others, the latest and greatest OPASS meeting. I got there early to...
2009-07-15
526 reads
Off Topic – Why I’m unclebiguns on Twitter
There may be some people wondering why I go by the name @unclebiguns on Twitter. I am basing this on...
2009-07-15
390 reads
OPASS Meeting July 14th
Hey, Orlando area SQL Server folks, don’t forget the OPASS meeting 6pmTuesday, July 14th at End to End Training (map). ...
2009-07-13
442 reads
Mid-year update on my goals
I recently saw that Steve Jones had posted an update on his 2009 goals and realized that is was about...
2009-07-07
363 reads
Blogs
My 2024 in Data: Health and Workouts
By Steve Jones
This is my last week of the year working (I guess I come back...
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...
Forums
Windows could not start the SQL server (SQLEXPRESS) service (macOS)
I have a common problem that I just cannot figure out after scrolling through...
Adventureworks data does not load
Hello, I am a new member here so forgive me if I am not...
Restore Procedure not working
I created a small procedure that reads the backup file and restores the DB...
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