Here's a bit of theory: https://www.online-tech-tips.com/cool-websites/what-is-checksum/

HASHBYTES can use SHA1.

This is a quick check, but not necessarily an absolute one.

I miss adult contact and discussions, debates, etc. I get to work with lots of kids still, as a coach, but I miss conferences, the office, even random talks about...

I've had a few Kindle devices and I read almost exclusively with the Kindle app on my phone/iPad. I bought one of the first Kindle devices, and have likely read...

I'm not completely sure what you mean, but DNS is a central system, somewhat like your local network. you can't have cname1 as the same machine name. You can have...

There are SRV records, but I don't think the drivers look up these records.

As Jeffrey mentioned, you need to include the port, or have the instances listen on 1433. You...

Hi folks

I can't find anywhere else to ask this, so here it is. SQL Server 2017 Standard Edition is restricted to 24 cores. Does this mean that the...

How to Get Current Date in SQL Server: https://www.mssqltips.com/sqlservertip/6817/sql-current-date/

Reminded me of some discussions here.

I've seen both arguments. There's a good argument, maybe the best one IMHO, to have senior developers mentoring junior developers in building software. Which then leads to senior people catching...

The number doesn't too much matter in terms of which is better. Always plan for a large number. If it's a small number, then it doesn't matter in terms of...

stupid editor clicked the wrong button. Default/radix is correct.

Lol, still think...

Do you mean for those certain editions? I think those don't support the same T-SQL keywords in all cases.

Thanks, Joe. I think growing and understanding is a personal thing. I'm working on doing better.

Thanks, all

This is a joke. You cannot (as of Apr 2021) add Power BI reports to SSMS