Andrew Clarke

Andrew Clarke has been developing software applications for over 35 years. He is a database expert, but also has had many years of experience in designing and programming applications and software tools. He has a particular interest in website-publishing and ECommerce. Before joining Redgate, he worked with the first two winners of the 'Apprentice' program at Amstrad, creating various business applications, He is the editor of Simple-Talk.

03 November 2008
03 November 2008

Winners of the Bejewelled Puzzle

0
There are three winners: Timothy Walters – for his second solution with the offset table; He gets a $50 Amazon Voucher. Ryan Randall – for his first and second solutions; He gets a choice between a license for SQL Prompt and SQL Data Generator DrLechter – for his first and second solutions; He gets a … Read more
0
22 October 2008
22 October 2008

.NET Reflector: Soup to Nuts

.NET Reflector is almost an intrinsic part of the .NET Framework, a free tool for browsing the contents of a .NET assembly. When Lutz Roeder passed responsibility for development of the code to Red Gate, the team preserved the characteristic minimal look, focussing on updates and code improvements. Then they added a free add-in that allowed it to be accessed from within Visual Studio. Reflector Pro is a paid-for extension that allows Visual Studio users to debug code in .NET Reflector.… Read more
12 September 2008
12 September 2008

The LSE TradElect incident: We all lose

0
The crash of the TradElect trading system on the London, and Johannesburg, Stock Exchange for seven hours was a disaster that probably led to the loss of around £3bn  in trading. The system was based on SQL Server 2000. High volumes of trading on global exchanges were expected that day, following the news that Fannie … Read more
0
15 July 2008
15 July 2008

Pasting code into a Blog.

0
One reason that I often hear for the apparent inability of certain people to blog is that there is no way for Community Server to display code. It isn’t actually that hard. The obvious choice is to use Phil Factor’s prettifier. It is the reason he wrote it. If you need to show exactly what … Read more
0
02 April 2008
02 April 2008

A Prompt Delivery

0
I wandered into Red-Gate’s offices the other day. I’d been momentarily distracted by the autumn leaves, thoughtfully strewn in the hallway, probably by a visiting Zen Buddhist to remind us of the sacred presence of nature even in the Techno Park. Suddenly I was waylaid by the charming Tanya to take part in a bug-hunt. … Read more
0
27 March 2008
27 March 2008

Selling Software

In some ways, wanting to make a living as a Software tool writer is like wanting to be a professional rock star or footballer. The success-stories are more visible than the others. Here, Andrew Clarke salutes the others and explains some of the pitfalls. Despite everything, he is always keen to wish anyone luck who wants to give it a try. … Read more
26 February 2008
26 February 2008

Coram magnificos manifeste scalpere nolis …

0
‘Coram magnificos manifeste scalpere nolis Torquendo digitos nares…’ Daniellis Becclesiensis c1200 AD (meaning: Do not pick your nose in front of managers) One of the delights of being Simple-Talk’s subeditor, under the watchful eye of Tony (sir), Anna and Simon, is to interact with our team of regular writers. When I use the word ‘Team’, … Read more
0
07 February 2008
07 February 2008

Thick and Fast

0
There is a great deal of activity on the Red-Gate forums at the moment. In fact, they are a fascinating read. Often, the threads take off in ways that nobody can really predict. My particular pleasure is in reading the ‘off the cuff’ remarks such as ‘I have servers in NYC, Los Angeles, Pakistan, and … Read more
0
16 January 2008
16 January 2008

The Waffle Generator

Sometimes, silly programs have a less obvious useful purpose. Andrew Clarke takes his classic 'Waffle Generator', and provides it in various forms, including a CSS Stylesheet tester, and as a Generator for SQL Data Generator. The Waffle Generator puts text into your test database!… Read more