Viewing 15 posts - 16 through 30 (of 275 total)
SQL 2008R2 Standard Edition can only use 64Gb of memory, Enterprise Edition can use all of the memory available on the server. If you can upgrade to 2016 or higher,...
November 18, 2021 at 10:46 am
Check that port 445 is open outbound in the NSG, might be that
November 16, 2021 at 7:22 pm
If you have Business Critical tier you'll have a read-only instance available to you.
On General Purpose, transactional replication is probably the easiest way of getting another copy of all the...
November 16, 2021 at 4:47 pm
Do you mean replication to/from one Managed Instance? Why do you need that and not just use cross-database queries?
If you mean between Managed Instances then replication is the only SQL ...
November 16, 2021 at 11:14 am
Why are you thinking two runtimes? One runtime on-prem would enable you to use ADF to transfer from Azure to on-prem.
November 15, 2021 at 9:58 am
I think that would work and is kind of what the log shipping does anyway. Failback would be just running the steps again but on the opposite server to where...
November 12, 2021 at 4:09 pm
Richard, (rlDawson_SLC) You can access data outside of Azure (like on-prem SQL) by installing something called Integration Runtime on a server on-prem. You then connect the Integration Runtime to ADF...
November 12, 2021 at 3:58 pm
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...
October 29, 2021 at 11:41 am
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...
October 20, 2021 at 1:28 pm
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...
October 20, 2021 at 1:09 pm
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...
October 20, 2021 at 9:42 am
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...
October 19, 2021 at 9:23 am
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
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...
August 18, 2021 at 2:37 pm
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...
August 18, 2021 at 2:18 pm
Viewing 15 posts - 16 through 30 (of 275 total)