Thank you, @tellery_frmt for your comment.

If you use months to calculate the DOB, then your age will inflate at the start of your birth month, which is not...

Thank you, @beervolk. Could you please also explain briefly why do you prefer to use sysdatetime over getdate?

Thank you for your comment, @Ray-Giacalone, and @pietlinden.

If you have a MonthNumber field in your dataset, you should sort all your month-wise charts by that field....

Thank you for this @steve-jones-ssc-editor.

This is one of the important factors that need to be addressed when developers start building any new data application. In my organization, we...

That's strange.

Ideally, if it is the default instance, I'd suggest you connect to it using the hostname only (from both SSMS and SQLCMD).

Hope this answers your question.

Can you please run the following query and share a screenprint?

SELECT SERVERPROPERTY('InstanceName')

If it returns NULL, then it is the Default Instance otherwise it will return the instance name.

@abacrotto

Hello @abacrotto,

If I understand correctly what you're trying to say, you have SQL Server running on a notebook (PC #1) and you're trying to connect to it from...

Hello,

I think you have to use the following format to connect to the named SQL instance inside your VM.

HOSTNAME\INSTANCENAME. (Hostname = VM PC Name)

I hope this helps.

Thank you for sharing the link, @Chris-Wooding.

Thanks @bob-56901. I'll add that to my to-do list. Will keep you posted of my upcoming posts on this topic.

That's interesting, @mvdba. Being a developer, I keep myself restricted from fire fighting with the production environment. It is a nightmare for me to update values in production...

@bryant-mcclellan, NOLOCK seems to be a bit scary to me, especially when reporting financial data. There's a huge possibility that the reports might be generated with incorrect data,...

Haha! Well said @patrickmcginnis59-10839. Reminded me of one of my old bosses.

Thank you @pailwriter. It's my pleasure to be helpful to the community.