The simplest (but not the most efficient) way is to just crawl up the nodes with ../ to move up each level

select
  a.Server, a.[Report],
  Hyperlink...

AGs in two different clusters can be connected into a Distributed Availability Group (https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-2016), which will provide you with AG-to-AG (in your case, site-to-site) replication. When using Distributed Availability Groups,...

Use a single-quote twice.

SELECT 'Men''s Large' AS [Result]

You need to update the secondary server first. SQL Server 2012 cannot read transaction log backups from SQL2014 or later.

https://docs.microsoft.com/en-us/sql/database-engine/log-shipping/upgrading-log-shipping-to-sql-server-2016-transact-sql?view=sql-server-2016

The optimizer does not respect your join order unless you force it (which is usually the wrong thing to do). Based on the JOIN conditions and the filters in the...

I was happy to see that I don't need to turn that off every time I post.

You must execute that ALTER statement in the context of the database that contains the object.

When calling an object over a linked server, you must use a four-part name:

[1...

• This reply was modified 6 years, 5 months ago by Eddie Wuerch.
• This reply was modified 6 years, 5 months ago by Eddie Wuerch.

You'll need Broker Endpoints on both servers, because Broker conversations are two-way (send-ack). You also need the following four routes:

1. On Initiator database: Route to target Service and...

(pasting a reply from a similar question from last year)

The behavior changed in SQL 2016:
https://support.microsoft.com/en-us/help/4010261/sql-server-and-azure-sql-database-improvements-in-handling-some-data-t

If you run queries on a SQL 2017 database set...

When planning for recovery, I favor 'lower tech' solutions - keep things as simple as you can while still hitting your RPO/RTO. I deal with log shipping on 100TB++ databases...

It seems weird that the offline upgrade occurred on all three nodes. Once the database is upgraded, it's upgraded. The changes made to the database during the upgrade propagate to...

If you're running Windows Pro 8.1 or later, Hyper-V is built in. Just hit the Windows key, type "Hyper-V" and then select the option to add Windows components. Select Hyper-V...