Troy Hunt troyhunt

Time is money, and my 5+ year old desktop is costing me a heap of it right now. The final straw has come when processing several terabytes of stealer logs which has taken forever. Meanwhile, Stefan has been flying through them with a massive NVMe drive on a fast motherboard.

So, in no particular order, here's what I need it to do:

Read and write multi-terabyte files fast
Run SQL Server locally for both development and querying of large data sets (the latter is especially memory intensive)
Dev environment is largely Visual Studio, SSMS and other (less intensive) tools
Run a gazillion simultaneous Chrome tabs 😛

And here's my current thinking:

	Lovelyskin	3338541
	Jomashop Magento	2342771
	iTechDeals	1411036
	tilebar.com	910699
	AppliancesConnection	663130
	CANADIANAPPLIANCE.CA	645213
	MoodFabrics	585985
	Botach.com	488274
	BeachCamera	483356
	ezcontactsusa	464685

	Id	MapID	UserID	AddressId	Fax	Lat	Lon	Sex	Tel	Tel2	Email	Notes	State	Title	Banned	LastIP	Status	URLName	AddrCity	AgeRange	LastName	NickName	Services	FirstName	InitialIP	LastLogin	RFDIssuer	RFDNumber	TelMobile	TermsText	TermsWhen	AddrCounty	Categories	EmailOptIn	Facilities	ImageCount	ModifyTime	TradeTypes	TraderType	WebAddress	AddrCountry	AddrStreet1	AddrStreet2	AddrStreet3	BillStreet1	ConfirmHash	Description	LastBrowser	ShowAddress	TermsAgreed	AddrPostcode	BillPostCode	CreationTime	HideStockNos	InvoiceEmail	Organization	PasswordHash	DefaultAdText	PasswordScore	EmailValidated	MarketingOptIn	SpecialBilling	DistancePostcode	MarketingOptTime	EmailValidationString

	AddressID
	IndividualId
	personfirstname
	personmiddleinitial
	personlastname
	PersonSurnameSuffix
	persontitleofrespect
	housenumber
	predirection
	streetname

	<!--
	/* Font Definitions */
	@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
	@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
	@font-face
	{font-family:"Univers 45 Light";}

	Name Length
	---- ------
	admin.csv 113
	affiliate.csv 12241
	affsales.csv 86847
	apps.csv 600
	articlecomments.csv 68184
	articles.csv 237259
	articlesBackup.csv 224940
	campaigns.csv 183167

	Length Name
	------ ----
	4647 ad_pic_cache_202209032229.csv
	772 ad_publish_202209032229.csv
	7122 ad_publish_content_202209032229.csv
	564 ad_publish_job_202209032229.csv
	1039 ad_publish_job_his_202209032229.csv
	53 ad_publish_operation_del_202209032229.csv
	523 ad_publish_plan_time_202209032229.csv
	326 ad_publish_plan_time_his_202209032229.csv

	Length Name
	------ ----
	184 app_info_202209032248.csv
	145 app_server_info_202209032248.csv
	410 cookie_202209032248.csv
	537 oauth_client_details_202209032247.csv
	501 oauth_client_extend_202209032247.csv
	55 open_sms_phone_202209032247.csv
	76 open_sms_temp_202209032247.csv
	106 record_add_order_202209032247.csv

	dl-x.com 210383
	s.weibo.com 154193
	www.toke-loisirs.fr 137141
	www.danzyworld.com 90918
	gateauxridha.blogspot.com 82891
	xn--cumpleaosdefamosos-t0b.com 76441
	www.ufofxw.com 69427
	domoviefree4you.blogspot.com 67402
	moedacripto.blogspot.com 64628
	sexhikayelerimbenim.blogspot.com 64055

	{
	"id":"PMTPbtB79fUTnDS2f2Hn7Q_0000",
	"full_name":"niall merrigan",
	"first_name":"niall",
	"middle_initial":null,
	"middle_name":null,
	"last_name":"merrigan",
	"gender":"male",
	"birth_year":null,
	"birth_date":null,