What it does: When you make a copy of a production database for development or testing, you may need to anonymize your personally identifiable information in order to reduce the risks of data breaches, snooping or other unauthorized use. The purpose of this free service is to provide an easy API that generates reasonably accurate samples of fictious customer names, addresses, birthdates, etc.

To get more than 200 rows per 60 seconds you'll need to request a free API key.

Try it: : get , token:

Invoke it from Powershell:

$rowset = (Invoke-WebRequest -Uri "").Content | ConvertFrom-Json

More detailed example? Here's a tutorial.

Did this make your day? Let me know on Twitter

Want to contribute? Get in touch if you want to help out with statistical/census files of first names, last names, zip codes and populations for your region!

Brought to you by Structured Concepts - we do SQL Server development, performance tuning and technical training! Legal

Image credit: unsplash-logoSamuel Zeller