Yep. It'll do exactly what you're asking. All seven instances in one view.

1. Some people do this. Filegroups in general are a very good idea. They allow for all sorts of management like piecemeal restores that would be much more difficult without...

Most of the major tools have mechanisms for monitoring replication in one way or another. Redgate Software's SQL Monitor (I work for Redgate by the way) uses custom metrics...

Here is one article and here is another. Between the two, we outline a bunch of ways to solve the versioned data approach. The core of it is,...

The issue is that internal developers can seem to get the script to work and there investigations point to the OPENROWSET Function part of the script as after...

Ha! You're placing way more confidence in my answer than I do.

It's possible to write directly to Azure, yes. However, it all depends on how you do it. SSIS is one mechanism. You can also use Powershell or sqlcmd.exe. Make...

Looks like an issue with how the application is configured and/or coded. Go to Bingle and look up "sql server connection pool" and ensure that your app is doing this.

Second, and enthusiastic, vote for sp_whoisactive.

And yes, there are Dynamic Management Views (DMVs) that are specific for locking and blocking. Microsoft has an article on how you can query...

I don't have an answer, only some questions.

Have you looked at the wait statistics? Specifically for the queries involved? What are they waiting on (yeah, obviously the buffer latch, but...

You are dealing with two distinct approaches to querying. The first, parameterized queries, involves what is called parameter sniffing. The process gets the values from the parameters and uses those...

What you're doing is a correlated sub-query in what is effectively the SELECT list and that query is returning more than one value. As the error says, you can't do...

None that I'm aware of. I'd suggest testing on a few disparate data sets, and generate a local one. The compression is consistent, but as you say, very dependent on...

I'd recommend doing a node in AWS and one in Azure. If you have the money for only one site, I would recommend AWS. AWS will be more...

1. Am i right in thinking that the timing of failing azure server and getting new one is very quick so we could avoid HA?
2. In the case of...