You don't delete the users on the secondary - users are part of the database and since that database is not accessible you cannot make any changes to the users. ...

Logins are created at the server level - and users are added at the database.  To have the logins on the secondary server tie to the users in the database...

I think the confusion is that the documentation references availability groups - specifically in relation to high availability mode.  By default, if that setting is enabled then the containedag availability...

If you're using SSIS, I assume Visual Studio, you need to download and install the 32bit version. Visual Studio is still only a 32bit application, so only supports the...

This is going to be quite difficult to accomplish - because the Oracle Cloud instance requires an SSH tunnel before you can connect.  Generally, the SSH tunnel is setup and...

One of the nice things about project deployment is that you can now create a new project from an existing project with a new name.  Whether or not that project...

From what I have read - SQL Server 2019 includes support for 'Big Data Clusters'.  If you setup and configure this (https://docs.microsoft.com/en-us/sql/big-data-cluster/deployment-high-availability?view=sql-server-ver15) then the system databases are automatically included.

Thanks Brian.

Since checking the AG was set against the datasource and dataset correctly, my Administrator has been able to enable remote errors for me this morning and I now...

You can calculate the start/end of quarter dates with the following:

Declare @quarter int = 3
      , @year int = 2019;

 Select FirstDayOfQuarter...

You really should use the Oracle Connection - and make sure you have installed the Oracle client on your workstation and the SSRS server.

https://docs.microsoft.com/en-us/sql/reporting-services/report-data/oracle-connection-type-ssrs?view=sql-server-ver15

If using the Oracle provider, your parameters...

Not sure what you are trying to accomplish here - shrinking isn't going to magically free up space that is allocated and used in the database.  The first file has...

If you look at the SQL Server Agent properties - under the History page you will see these settings:

The first setting (Limit...

The grouping needs to be defined in the report - not in the SQL.  By setting up a group in the report - you can display the detail rows for...

One of the benefits of SSRS is that you can allow the users the ability to access and use Report Builder.  For this you would define a data/report model and...

It looks like you do not have a group defined - therefore you are getting each row in the data set as a distinct row in the tablix.  You need...