With the rise of NoSQL databases that are exploiting aspects of SQL for querying, and are embracing full transactionality, is there a danger of the data-document model's hierarchical nature causing a fundamental conflict with relational theory? We asked our relational expert, Hugh Bin-Haad to expound a difficult area for database theorists.… Read more
Once more it is time for our readers to vote on the top
nominations for the Simple Talk Awards. Here we list the top nominations and the
dazzling award badges. Every vote makes our awards more valuable for the
recipients!… Read more
Although most of the geeks of the IT industry are famous for their software, it was the geeky entrepreneurs that changed society by bringing cheap microcomputers to the market. Sir Clive Sinclair is most famous for applying his background in electronic engineering to provide a whole generation, both in America and Europe, with their first taste of programming.… Read more
Effective team-based software development has more to do with the organisation than the technology. Teams that must cooperate are most productive when there are high levels of trust between teams and within teams. To grow a culture of trust, the participants must take conscious steps to set boundaries, agree on protocols and models, and let a shared purpose emerge.… Read more
Sometimes the stress of interdepartmental friction within organisations can get on top of you, especially between the business and IT when the going gets tough. Simple-Talk's answer is a board game to put it all into perspective. Instead of getting carried away, play the board game instead and reach catharsis.… Read more
The BASH shell is the most popular UNIX command-line scriptable shell. It became the inspiration for PowerShell. As with so many standard components of the Open Source movement, there is a hard-working and dedicated individual who quietly supports the tool over many years. Chet Ramey maintains and extends BASH by himself, and we all give thanks to him for his dedication.… Read more
Philip Greenspun is probably best known to other geeks for his Tenth Rule of Programming: "Any sufficiently complicated C or Fortran program contains an ad hoc, informally-specified, bug-ridden, slow implementation of half of Common Lisp." Amongst the general public, he is most famous for founding ArsDigita and suffering the subsequent miseries that came from accepting venture capital.… Read more
Although we like to think that our programming techniques are progressive and in tune with the bleeding edge of software development practices, too often they are directly influenced by restrictions faced in the post-war decades when computers
first became mainstream. As these restrictions no longer apply, is it time to relinquish such things as cursors,
'tibbling', storing display formats, using short names for symbols and primary keys?… Read more
DevOps isn't a particular technology, nor a job role. It is more of a software development method, initiating originally from system administrators, that promotes ways of enhancing collaboration and communication between development, QA, and IT operations throughout the entire software delivery pipeline with the aim of faster software delivery. Adam Bertrand answers the four most common questions that IT Pro's wonder about, but seldom ask publicly.… Read more
We all use software, and we all find it alarmingly easy to find bugs in it. Does that mean that we have a natural talent for testing software? Devyani suggests that there are some qualities that characterise software testers who are very good at their job. No matter whether you were born like that, or if you've worked upon, practised, developed and acquired them over time, they make all the difference.… Read more
"Facts and Fallacies of Software Engineering" by Robert L. Glass has become a classic of Software Engineering as cherished as 'The Mythical Man-Month: Essays on Software Engineering' by Frederick P. Brooks. They seem as radical today as when first written, mainly because the software industry repeatedly fails to learn from its mistakes. Dwain Camps reviews the book.… Read more
Michael Fal is a huge advocate of automation and many ways it can improve the lives of developers and DBAs alike, but you can't just automate all your problems away. The real challenge is breaking down barriers and having developers and DBAs functioning smoothly together. You may have heard of DevOps, and so Mike explores what the buzz might mean for database administrators.… Read more
In a development team, there are times when the relationships between developers and testers can become strained. How can you turn this potential conflict into something more positive? Is it part of the skill of team-working to find ways of avoiding friction, or should one blame a system that relies on good social skills to work well?… Read more
Alan Cooper helped to debug the most widely-used PC language of the late seventies and early eighties, BASIC-E, and, with Keith Parsons, developed C-BASIC. He then went on to create Tripod, which morphed eventually into Visual Basic in 1991. Alan remains enthusiastic and interested in development with strong views on Agile and Pair Programming.… Read more
Why do programmers work best at night? Is this related to the idea that drinking alcohol improves cognitive ability? Is programming a young person's game? How do you tackle spaghetti code and avoid job-burnout? Swizek Teller has achieved fame in providing a wry commentary on these questions, and the way that computers have come to dominate our lives.… Read more
Conrad Wolfram is the 'younger Wolfram' of Wolfram Research, the company behind Wolfram|Alpha and Mathematica. He wants to transform the way in which we engage with mathematics. In particular, he would like to reform mathematics education to make greater use of information technology, and he is also leading the way with interactive publishing technology. … Read more
What is IT Compliance and is it really necessary for contemporary Agile applications to be constrained by the requirements of compliance? William Brewer argues that if the objective is rapid delivery of applications, then compliance controls must be understood as early as possible in development.… Read more
XP is no general panacea; but for the right team, and for a product that needs to release bug fixes and new features as fast as possible, its benefits are obvious. Working on one of Red Gate's most popular tools, SQL Prompt, Aaron Law and David Priddle use Extreme Programming (XP) . But is their adherence to XP a personal preference or does it bring real benefits? We sent Matt Hilbert to find out.… Read more
The current popularity of the Salesforce software development platform has taken the industry by surprise. The current IT culture favours the esoteric, yet here is a development platform geared to the idea that anyone can use it: a populist language like BASIC. Does this threaten the careers of professional developers? Paradoxically, not at all, says Dan Appleman. … Read more
There's a joke doing the rounds at SQL conferences and seminars: three DBAs walk into a NoSQL bar and leave when they can't find a table. You may have heard it before, but it made Matt Hilbert sit down and ponder. What's happening? Is there a division opening up between the newly fashionable NoSQL followers and DBAs? Matt bravely enters the shiny new world of NoSQL to investigate.… Read more