This is where talent and knowledge end up getting conflated but often aren't really the same thing.  Someone who's talented should both be able to acquire new knowledge and then...

I had someone ask me how many a couple was this morning, it was just one of those weird moments where I assumed that was just standard knowledge but the...

Can this be done with a populated table with 24MM rows and 130 fields? I keep getting errors that the tempdb is full (?) I tried copying the table,...

Well you could just check the number results in the return and if it's zero hardcode the desired output.

Json is tricky like that because functionally both of those represent the...

Welp then start adding columns one by one until it breaks 🙂

Does just this work?

SELECT
SUM(CAST([Convo] AS DECIMAL(10,2)))
FROM [a2hr].[dbo].[FinalPayroll] where period = 18

What is the exact problem?

This works fine for me,

$messageParameters = @{
From = "xxxx@xxx.com"
To = @("asfadsf@dsdasf.com", "djshgfkdhas@hcbvmxc.com")
Subject = "DBLocks "
Body = "Job Status"
SMTPServer = "SMTPSERVER"
}

Send-MailMessage @messageParameters

Don't convert it to a string at all, the to parameter should just be the array if it's going to multiple addresses.

The to list needs to be an array @() not a comma separated string 🙂

Well there's a difference between a poor design choice and a legitimate bug.  And I don't see how using while(1=1) without a proper break condition is any worse than while...

Well you're probably going to have to have something to handle issues in the GUI, for example when all the slots are full.  But this should fix the other issue.

That kind of formatting would likely better be done in the GUI, especially if you want any kind of custom formatting if there's no matches etc.... but if you have...

Cloud, SaaS, web application are all extremely broad terms that have a lot of overlap.

Cloud basically just means on the internet not hosted by you(there is no mythical in the...

Where are you getting those execution times from?  From SQL Server or from the application?