Steve, thanks for all the blogs. SQLServerCentral is the first email I read in the mornings. I plan to do my first presentation this month, and to start a...

Hey, Ray, I try to post these on the SQL Saturday site at: https://sqlsaturday.com/#reserved

So far, I have no confirmed dates, but I do have NYC looking at May as...

Thanks, and no horse chores for me. A little under the weather yesterday, but luckily my kids stepped up and shouldered the load

Happy Holidays and Merry Christmas, everyone. Enjoy the long weekend.

I've used AI mostly for things outside of SQL development.  Like git and C# and Powershell.  It seems like it saves time (not always tho) and I go to...

It was a weird thing I stumbled on when working with arrays and removing elements as dale_berta noted, the array is still the same size, which is expected. It shouldn't...

Hope you enjoy it. I've gone through 16 days so far, and I have some catching up to do after a busy week. I'll likely dig in this afternoon for...

Your opinion is wrong. The question asks for defaults for this T-SQL code. The defaults are not stored in sys.parameters. They are only in the code definition in sys.sql_modules.definition.

 

The state department I work for has blocked all generative AI. I don't know why. It might even be blocked for all state departments. I don't have access to...

It's crazy these aren't parsed and maintained in a DMV for T-SQL procs, but they're not

The docs note this has default values for SQLCLR procs, not T-SQL ones.

SQL 2019:

 

SQL 2022

December 21, 2023 at 5:18 pm

#4350333

Thanks, fixed

Yeah, the parsing for the code formatting is that there are so many cases with the regex and replacement that I think we're fixing one thing but breaking another.

Bug filed...

I'll log a bug. I hope this is an easy fix.

We that's interesting.