Salakhetdinov Shamil
mcp2004 at mail.ru
Fri Apr 6 15:51:59 CDT 2012
Hi John -- Good to hear you'll get converted your "Database from Hell" into "Automation Paradise".... > and telling it to go... I wonder did you get automated this step too? :) A kind of kidding here but I have no doubt in two-three years you'll get it automated by using broadly available by that time inexpensive voice recognition software/(web) services: keep your eye on this MS UI Automation technology: http://en.wikipedia.org/wiki/Microsoft_UI_Automation to translate (voice) commands into UI interactions... Thank you. -- Shamil Fri, 06 Apr 2012 12:26:18 -0400 от jwcolby <jwcolby at colbyconsulting.com>: > > http://www.sqlservercentral.com/articles/Administration/88600/ > > I started with the "Database from hell" validating addresses manually. The first pass took > literally two weeks (~80 hours of my time) to validate 65 million addresses. Today it takes the > time required to create a supervisor record and telling it to go. The computer still takes an hour > to validate 2 million addresses but it takes me a minute or so. I now validate ~300 million records > every month and have just added another 220 million records. > > I use C# and SQL Server to automate this work. > > -- > John W. Colby > Colby Consulting > > Reality is what refuses to go away > when you do not believe in it > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com >