LinkedIn | FaceBook | Twitter
OK, this will probably never happen, and I have no official affiliation with the Professional Association of SQL Server (PASS) at all, everyone will think is crazy, but at the PASS yearly conference I would really like to see this competition:
There’s a special race called the “Dakar Rally”, which runs for weeks at a time over some of the most difficult terrain in the world. Hundreds of cars, bikes and trucks (!) start out, only a few finish. People get hurt in this race; some have even died. It goes from extreme deserts to high snowy mountains, through towns and rocky roads. It’s a speed and endurance test that proves you’re the best racer there is on almost any terrain. In the cars there is a driver and a navigator – a team of two.
So here’s what I think would be awesome. Take a series of standard PCs – nothing fancy – and display a data requirement. Users create a database design and a standardized client application (using PowerShell or even SQLCMD) on another standard workstation that does Create, Read, Update and Delete operations for the database. Network is between those systems only.
Each day, the “organizers” of the PASS Dakar set up a series of CRUD operations. Some are small, and lots of them, others are huge BLOBS, streaming data and so on. Two of the “competitors” would run those requirements through their app and to their database. As long as the results match across all competitors, it’s a clean “race”. Round-trip performance is measured for each competitor. Each day they can tune their database, workstation and even the network system for best throughput. That forms a “stage”. Each day, the “Stage Winner” is posted. Competition is held throughout each day.
At the end of the week, the team with the most stage wins is the overall winner. Trophy goes home with them. Next year, the process repeats, and the trophy goes to the new winner.
That would be so cool.