Does the following give you what you want?

select
   v.name,
   sed.referenced_server_name,
   referenced_database_name,
   referenced_schema_name,
   referenced_entity_name 
from
   sys.sql_expression_dependencies...

Is it because the node you are trying to switch to isn't allowed to be an owner of the cluster resources?  If you right-click on the Resource and look at...

Create synonyms for the missing objects, SQL Server doesn't check if the object really exists or not.  You can then create a proc that references the synonym.  When you are...

• This reply was modified 3 years, 2 months ago by  DNA_DBA.

That's an interesting point actually.  The way I read it is that the MI server can talk to the disks with latency of 5-10ms but the disks themselves add a...

On General Purpose MI, the disk speed is based on the size of the disk, and each log and data file is on a separate disk.  The bigger the disk...

When inserting a specific value into an identity column, you need to specify the columns in your table that you want to put values into, including the identity column.

eg:

            
October 19, 2021 at 9:15 am
            
#3941884

            
            
                                                
        

If you have a standard server build (things like the same drive letters on each server) you could have a standard config file that is used by the installer to...

Hi MillionQueries,

I'll have a go at answering:

1. Business Critical tier in Managed Instance comes with multiple secondaries, one of which is readable at a time (via ApplicationIntent=READONLY in the connect...

• This reply was modified 3 years, 4 months ago by  DNA_DBA.

In Win 2008r2 you can take the quorum offline and the cluster will stay up.

We moved from emc to NetApp last week which involved migrating the data between SANs via some device. We had two options around DTC and quorum:

1. we could create...

That sounds right. From memory, when you run the setup it looks a bit worrying...

Each instance in the cluster requires a distinct IP address to be entered at installation time and it gets checked by the install process - so you can't install two...

I think it depends on why you are doing it. You can pause a node so that no resources can be used on it (perhaps to perform maintenance on...

Do a test transfer of a large file in advance to gauge how long the 100gb databases will take to transfer across the network.

If the speed is slow...

See http://www.sqlservercentral.com/articles/System+Tables/66335 - it might help