It's great that we can get json right from the query. It would be even better if the results came as a properly formatted json array with the leading [...

This answer is incomplete. Once you run that command, you need to wait for the process to complete and then at the minimum drop the database encryption key. Optionally, you...

Out of curiosity, I gave this question to Anthropic's Claude.

I have been using Claude Code quite a bit for development for the last 6 months and it has dramatically increased...

I just looked at the leaderboards. Just curious, with only 1 Question of the Day per day, how does somebody get a score like 79 in the last 30 days?

Thanks for the lesson. I am developer first but have used SQL Server since 6.5, Sybase, Mongo DB (doesn't really count for this discussion), MySQL, and Postgres. I have never...

How do a bunch of people in a design meeting sitting around a table have a conversation like this:

"Let's add a new concatenation operator to T-SQL. We don't really need...

I provide feedback when asked as long as the survey isn't too long. If t get's past 6 or 8 questions, I bail. Time is my most valuable asset.

I am an old salt having served 21 years in the United States Navy on submarines during the cold war. I have lots of stories but I only tell them...

A user should not be required to provide both possible right answers to be scored correct. You don't need both to get the amount of fragmentation. Even the example does...

This is a pretty good article but I would not call it an in depth analysis.

Sometimes the grass is greener because it's on top of a leaking septic tank.

I agree totally. In lots of other forums I am a member of I see those 'gatekeepers'. They think it's their job to humiliate the unknowing. They reprimand with "asked...

I have found no reason to use ISNULL over COALESCE. I believe ISNULL is specific to SQL Server while COALESCE is specified in the ISO/IEC standard.

I thought this article did...

I use JetBrains DataGrip on my Mac

• This reply was modified 1 years, 3 months ago by edmil.

No disappointment here. Think how much better SSMS could be if those hours were invested there. VS2022 is the most unstable version of VS I have ever used. JetBrains Rider...