-- 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/

Yes, you can export the data to Excel or PDF.

I want tp create a scenario when I perform failover from Node1 to Node2, I want the database to get stuck in Reverting/In Recovery state on Node1 for longer...

Try this:

SELECT 
  A.custnbr, 
  AvgLag = CASE WHEN COUNT(*)-1 <> 0 THEN CONVERT(decimal(7,2), 
          ...

@dennis Jensen: I do not understand what is your problem?

Have you read the OP's original post? OP wants to remove Min(ShipDate).  I answered to him as I understood his requirements....

For more accuracy, you can use Record_Add_Dt = DateTime.UTCNow;

Replace Min(ShipDate) with the following LAG function to get the Previous Ship Date.

Lag(ShipDate, 1, '1/1/1900') OVER(Partition by Custnbr ORDER BY ShipDate ASC)

Your final query will be along the following lines:

I would like output to show:

Custnbr ---- (Lastest-Order date) ----(Previous Order Date) ----  Lag

Any Help?

SELECT 
  custnbr, 
  AvgLag = CASE WHEN COUNT(*) >...