The company I work for has implemented ChatGPT 4 on its internal servers, actively promoting its usage among all employees. Given its deployment on company servers, there is also...

So you're ok with the loss of information assuming GMTOFFSET means what it appears to mean?  In SQL Server if you need to preserve the same information then you'd be...

Once a few years ago, at a prior job, I went on a sales engagement with one of our sales people.  At one point I got called into a meeting...

There's a huge disclaimer and warning associated with each of the items above.  Of course backup everything first.  There are also reasons NOT to do those things:

1. .vs is a...

VS does seem to get its signals crossed from time to time.  When things like this happen I close VS entirely and try the following:

1. delete the *.vs file in...

Nice one Drew.  CASE exits the expression once a true condition is found

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 Google...

Yes the current situation of set based development is quite conditional/permissional.  We're not at the final end state tho

I actually set the table option to have "large data types (LOBs)" be stored "out of row" (to prevent "trapped short rows" and other page density issues), which is...

Bump.  Maybe the prior posting was never visible

Error severity 20-25 are system errors so I wouldn't want to turn off logging and consider that the solution :).  There's a  packet size system setting for which there's a...

I can request that to happen, if it achieves the end result and can simplify the process. Its something we can work towards.

If I go down this path, I'll...

TBH, I don't see why the people making the JSON can't make it into a table and populate the table directly.  They even provide a datatype key and they...

Understand that I was speaking only from the SQL Server side... there is no "looping" required to pivot the JSON into a table.

While were on the subject, I wouldn't...

The JSON will always have the same values/pairs as that part is static.

That pairing is still not 100% as I'm taking suggestions provided by Phil/Steves to help improve the...