SELECT TOP 20 Q.Id as [Post Link] ,Q.Body ,Q.CreationDate...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Genealogy and Family History Meta

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT TOP 20
  Q.Id as [Post Link]
  ,Q.Body
  ,Q.CreationDate
FROM Posts Q
WHERE
  Q.PostTypeId = 1 -- Question
  AND Q.Score > 0
  AND Q.Tags COLLATE Latin1_General_BIN LIKE '%aws%'
  AND Q.Body COLLATE Latin1_General_BIN LIKE '%AWS_SECRET_ACCESS_KEY%'
  AND UPPER(Q.Body) COLLATE Latin1_General_BIN NOT LIKE '%XXXXX%'
--ORDER BY Q.CreationDate
;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results