No money from it, but I built a database and an application that stored information about the location of veterans grave sites. This was then used by the Veterans of...

Excellent feedback. Thanks Peter. Couldn't agree more.

Jeff's on target from what I can see. I don't see both queries and locks there in a way that you can accurately associate them with one another.

Oh! Missed that. Sorry. Yeah, you're hammering your CPU with that. I'd strongly suggest stopping.

Considering there's something urgent going on, why not tell us exactly what it is that you're trying to do and then we might be able to better help. All these...

Sp_whoisactive is querying the DMVs, and, depending on how you run it, an aggregation of multiple runs. Profiler is capturing through trace events, one execution at a time, providing more...

You sure it's a table and not a function or a view? A simple select on one table shouldn't place locks on a second table, even if there are foreign...

Whoever did the install needs to add your login to the admin role on the instance. And yeah, you need to be admin on the SQL Server instance to actually...

Like anything else, practice, practice, practice. Create a database in Azure SQL, then figure out how to access it, how it gets backed up, how to restore it, build tables,...

Spammed it.

To only do a subset of the data, you're very limited. Transactional replication is probably your best bet, but you will need to deal with the separation of the domains,...

There are probably an infinite number of ways to schedule a backup. However, most people will use SQL Agent, which is built right into SQL Server instances (assuming you're...

100% agreement

Extended Events are your bestest friend. Specifically, in addition to the normal query captures of rpc_completed and sql_batch_completed, you can look at ole_db_data_reader to see remote queries specifically.

My answer to this is always the same. What are the Recovery Point Objectives (RPO) and Recovery Time Objectives (RTO) of the organization? With those defined, can you prove that...