You may also want to look into creating an SSIS package since it's job is to extract, transform, and load (ETL) data. I'm assuming you've already looked into this but...

What you can do right now is take a look at the execution plan of the queries that are running when a card is scanned at the reader. That may...

You may be able to do this using sub queries but that won't really help you with one single query. CTE is probably the way to go like SQLian mentioned.

It always made me nervous to use MERGE since MS put a disclaimer on the KB page for MERGE (https://docs.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql?view=sql-server-2017).

I work in a OLTP shop. We have had issues...

I would check the SSRS logs on the new server and see what errors are showing. When you say the URL is not working, do you mean you cannot get...

If you haven't already done so, you may want to read through this and follow any instructions: https://docs.microsoft.com/en-us/sql/database-engine/install-windows/rename-a-computer-that-hosts-a-stand-alone-instance-of-sql-server?view=sql-server-2017

If you are looking to get better performance for queries running against the readable secondary, I would look at indexes. Unfortunately, you will have to add them to the actual...

Do you already have an automated way to install and configure SQL Server? If so, you should be able to script out the existing trigger in SSMS and add that...

Try running a NSLOOKUP against the Listener name. If it returns more than 1 IP address you have Multi-Subnet Failover enabled. Some applications cannot use this feature or it must...

Typically, you should be able to specify the directories for user database, tempdb, etc. during setup. If not, you can change the location of the files after the installation: 

You may also want to read up on RTO and RPO: https://www.sqlskills.com/blogs/paul/the-accidental-dba-day-6-of-30-backups-understanding-rto-and-rpo/

This may be very important to your company and/or customers depending on what their needs or...

Changes to Read Only Routing should take effect immediately after making the change. However, applications must contain the parameter ApplicationIntent=ReadOnly in the connection string to use the readable secondary. If...