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.

26 March 2013
26 March 2013

Towards Security as a Service?

There’s some fuss around the additional security risks of moving an existing service within a corporate data center, to a cloud-hosted virtual machine, with a shared infrastructure. I appreciate the caution, but I wonder if they aren’t overstated. Sure, there are new risks, intrinsic to the cloud. For example, the so-called Hyper-jack is a security … Read more
05 July 2011
05 July 2011

The Cookie Crumbles

Cookies were never intended to invade your privacy. Transient session cookies were invented out of necessity, by Lou Montulli at Netscape in June 1994, purely to make the use of a shopping cart possible on the stateless web. Permanent, or tracking, cookies soon followed, in order to identify users between sessions and so save users … Read more
10 May 2011
10 May 2011

Cloud Cuckoo Land

Does it strike you odd that, despite the outage of Amazon Elastic Compute Cloud (EC2) and Elastic Block Storage on April 21 2011, many of the customers who were affected are still so keen on the service? It puzzled me until I considered the huge diversity of applications out there. If these customers had been … Read more
15 March 2011
15 March 2011

The Hot-Add Memory Hogs

One of the more difficult tasks, when virtualizing a server, is to determine the amount of memory that Hypervisor should assign to the virtual machine. This requires accurate monitoring and, because of the consequences of setting the value too low, there is a great temptation to err on the side of over-provisioning. This results in … Read more
17 February 2011
17 February 2011

Opportunity Nokia’s

Nokia’s alliance with Microsoft is likely to be good news for anyone using Microsoft technologies, and particularly for .NET developers. Before the announcement, the future wasn’t looking so bright for the ‘mobile’ version of Windows, Windows Phone. Microsoft currently has only 3.1% of the Smartphone market, even though it has been involved in it for … Read more
14 February 2011
14 February 2011

RSS Feeds currently on Simple Talk

0
0
(Updated November 2017) There are a number of news-feeds for the Simple-Talk site, but the icon to click on isn’t particularly easy to spot. It at the top of the browser window next to the ‘Log in’/’Log out’ link. Now we have reorganised the site and it has become part of the Redgate hub, I … Read more
0
0
02 September 2010
02 September 2010

SQL Source Control: The Development Story, Part II

When creating SQL Source Control, the team had to make decisions as to which source control systems the tool would support, and needed to accomodate a range of different development practices. It also had to avoid the potential problems from the fundemental differences between database builds and application builds, David and Stephanie, from the team that wrote the tool, explain what they did, and why.… Read more
23 July 2010
23 July 2010

WebMatrix and SQL Server Compact Edition. Something for the rest of us?

WebMatrix, currently in beta,  is Microsoft’s newest initiative aimed at those of us who take no pleasure in using the overweight Visual Studio, but need to develop websites easily. For  web-based applications such as blogs, forums,  CMSs and wikis, WebMarix’s design seems ideal, though it is currently working only in parts. At the heart of … Read more
22 July 2010
22 July 2010

SQL Source Control: The Development Story

Often, there is a huge difference between software being easy to use, and easy to develop. When your pilot users tell you "by week three of any development project you've thrown out anything that takes time or just gets in your way", then it is time to be serious about usability, as well as quality. We decided to find out from some of those at the sharp end of the development of Red Gate's SQL Source Control.… Read more
19 February 2010
19 February 2010

Who Tests the Tester?

It is scarcely surprising that it can take up to five years to release a new version of SQL Server when one understands the extent of the effort required to test it. When enterprises depend on the reliability of an application or tool such as SQL Backup, the contribution of the tester is of paramount importance. It is an interesting and enjoyable role as well, as Andrew Clarke found out by chatting to testers at Red Gate. … Read more