select
	CAST(CONVERT(DATETIME, SWITCHOFFSET(CONVERT(DATETIMEOFFSET, timestamp), '-03:00')) AS DATE),
	count(1)
from ba.log2 with(nolock)
where severity='Error' and Message like 'Unable to connect to the remote%'
group by CAST(CONVERT(DATETIME, SWITCHOFFSET(CONVERT(DATETIMEOFFSET, timestamp), '-03:00')) AS DATE)
order by 1 desc