Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Testing Matters

By Steve Jones,

I've been watching the various articles and reports on the new website in the US. There have been a number of problems with the site and it's been somewhat amusing to see the various politicians and pundits complaining about the site. I've seen quotes that say Facebook and Google wouldn't have had these issues. I've heard various friends tell me the issues wouldn't happen in a private company.

It's amusing to me as a tech guy. I've seen numerous outages and issues from Facebook, Google, Microsoft, and more. I've seen them have downtime, security holes, outages, and problems with deployment of new code to existing sites. We've even had embarrassing "security certificate expiration" events from large companies. Any large scale site will have issues. None of the high tech companies would want to, or even likely be successful at, releasing a 1.0 version of a site to millions of users. We've seen numerous scale failures in the past from various companies, often because they never tested at scale. However many of these companies have improved their architectures and infrastructures over time, learning as they go. 

I don't know if the site can be improved in a timely manner, even given the "tech surge" that is taking place. Many of us have learned from experience that adding more programmers to a project doesn't necessarily get things done faster. Instead, I would bet most programmers would appreciate having more resources for testing and architecture up front when the important decisions are made.

The most glaring example of this in the site is shown in the security issues uncovered recently. The site received  provisional security approval and a large scale security test of the entire system wasn't performed. To me, that's inexcusable. There's no reason to skip security testing of any large scale application that deals with PII data, no matter whether it's public or private site.

Total article views: 85 | Views in the last 30 days: 1
Related Articles

Scaling Out

Scaling out is hard to do with SQL Server, but why doesn't Microsoft build a better solution?


Scaling Out

Kumar discusses the differences between scale up and scale out, then does a very good walk through o...


Scaling Out

Steve Jones likes Service Broker as a scale out technology, but it hasn't caught on. He thinks more ...


SQL 2016 Row-Level Security Demo: Users with various clearance levels

SQL 2016 is right around the corner and one of the new security enhancements promised is Row-Level s...


Company Rewards

Is there something that your company could do for you that would show that they valued your employme...


Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones