-- The database name 'My SQLDB' has a space in it, so you must wrap the name in [brackets]
SELECT @SQL = 'BACKUP DATABASE ['+@DBNAME+'] TO DISK =...

SELECT db_name(database_id), * 
  FROM sys.database_mirroring 
 WHERE mirroring_state IS NOT NULL;

From the online documentation for sys.database_mirroring:

Contains one row for each database in the instance...

You need to shred the XML into a resultset of nodes using the XQuery .nodes method. Then you can address each <ST> block as a single unit.

Note: I added an...

Scheduling refers to how the operating system handles running threads from multiple separate processes on each CPU core. A CPU Core can only do one thing at a time. If...

From a fragmentation point of view, there's no difference. If you run a shrinkfile after either dropping or truncating those tables, you will have fragmentation, and the same fragmentation either...

You have a few options.

Before considering them, I highly advise restoring a recent backup to the target 2016 system WITH NORECOVERY, then execute RESTORE WITH RECOVERY so you can see...

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

You can connect to Heroku PostGres from an external client: "...except for private and shield tier databases, they are accessible from anywhere and may be used from any application using...

You can create a single-database AG in each cluster (Primary only, no secondaries) and the create an AG on top of that between the two clusters. The 'AG-of-AGs' is called...

This is a great excuse to write a recursive query 🙂

DECLARE @InputDate datetime;
DECLARE @InputYear smallint, @EndYear smallint;

-- test date:
SELECT @InputDate = '2011-05-04', @EndYear = YEAR(getdate());

-- Fun with...

There's a link to the SQL 2017 Licensing Guide at https://www.microsoft.com/en-us/sql-server/sql-server-2017-pricing

Pages 26-29 of that guide cover HA licensing, including this line on p.27:

For each server licensed with SQL Server 2017...

during the period where the endpoint was one stop can I have lost data?

You will not lose data when the Primary Replica cannot communicate with a Secondary Replica. The Primary...

FCI + AG is supported. We're running many FCI+AG clusters in production.

The error message is informing you that an AG with at least one replica hosted on an FCI instance...

+1 for Lowell's comments that the expiring lab OS can be a driver for learning the Powershell and command-line install steps to re-build a domain and some clusters. Home labs...

Go to https://www.microsoft.com/en-us/learning/browse-all-certifications.aspx

Under "Filter Role-based certifications by technology or job role", click the 'Technology" box and select 'SQL Server'.

The current certs will be shown.

MTA: Base certification, single test. This is...

A database backup carries no details about any mirroring or AG configuration.

Leave your current mirroring in place. Any backup you take (or have already taken) of a mirrored database may...