If I understand correctly, there is some trace in progress.  It could be default trace, try to stop the trace or disable it after bringing the cluster offline. Also check...

what version of SSRS are you using?

If you are on SQL Server 2022, there is a new feature container availability group that you need to implement which will address all...

It looks like you are using PaaS. It is better to rollback and restore the DB to an earlier state as it was before this deployment.

Check this URL:

https://www.sqlshack.com/how-to-change-an-azure-sql-database-collation/

Also redeploy...

Provide more details about the data in the table. Is the data in the table double counting? As an alternative try to fix the ETL process.

There could be many reasons:

a) Password expires (check account policies or take help from network team)

b) AD Server offline to authenticate the user.

c) Unable to generate Kerberos ticket ... with...

I experienced the same few weeks ago using the latest SSMS 2019 version.

I had multiple SSMS versions on my machine, I tried the same with SSMS 2016 and it worked.

For the...

@shivrudra:

Using Automated patching, it is possible to apply both SQL Server updates and Windows updates Azure. Automated Patching establishes a maintenance window for an Azure virtual machine running...

-- For repeating values you can remove them from the Fact and add it to a dimension/or create a Junk dimension.

-- You can go ahead with two fact tables, one...

Using ADF, you can create source, sink, and watermark datasets. You can pass a list of source table names as a parameter to the pipeline. The pipeline will then iterate...

What is your objective or purpose of collecting queries?

If you do not want to use Trace then you may use QUERYSTORE. It is a different animal altogether if that might...

Here is another way.

DROP TABLE IF EXISTS #CustomerData;

CREATE TABLE #CustomerData(
    [ID] [int] IDENTITY(1,1) NOT NULL,
    [CustomerName] [varchar](500) NULL
) 
GO

INSERT INTO #CustomerData...

Just curious - but if you had to transfer PII/PCI/PHI for a conversion (for example) where the unencrypted data is required by the receiving party, how would you do...

check this link.

https://learn.microsoft.com/en-us/azure/storage/blobs/blob-powershell

Try this:

Replace * with your required columns

SELECT *
FROM final_output fo
WHERE fo.[G/L Transaction Type Desc] = 'GL Posted'
and fo.[Freight Bill Number] is not null

You can add more conditions...

check this link, try this in a test environment first:

https://en.dirceuresende.com/blog/sql-server-entendendo-as-permissoes-e-roles-do-sql-agent-sqlagentuserrole-sqlagentreaderrole-sqlagentoperatorrole/