T-SQL: How to create a million sample people
Duration: 60 minutes
Track: Keller 3-125
This session is a demo how you can create T-SQL code to create a table with a million rows of sample people with addresses, phone number, date of birth, and other demographic columns. Useful for creating realistic-looking data for a project that doesn't have any, or de-identifying existing data for development and testing purposes.
( Note: An article on this session has been published at http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/A_12174-SQL-Server-T-SQL-recipe-to-create-a-million-sample-people.html )