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

I disagree with the answer. The first answer is a better answer if you understand what's going on. Even the name is suggesting the process is shifting to an alternate...

I have a plan. I'm learning Spanish. I'm retiring in 18 months and plan to spend a year in Europe with a base in Spain. I'm training to live my...

When I conduct the technical portion of an interview for either a developer or DBA position, I spend considerable time on problems I know the candidate probably does not know...

MS needs to update the documentation.

https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-rename-transact-sql?view=sql-server-ver16 says, "Changes the name of a user-created object in the current database. This object can be a table, index, column, alias data type, or...

As a developer, there's nothing wrong with no braces. I would prefer it look like this though:

if (myVar == otherVar) return true;

It's more obvious what's going on when it looks...

I thought that also. So I ran a test. The compiler does not care. This runs and runs and runs.

• This reply was modified 11 months ago by edmil.

Expert is not a point, it is a position on a continuum. Certainly, there is a minimum level of knowledge where the masses would consider someone an expert but above...