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
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
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
Patrick Roach has already introduced us to the first set of software engineering Greats features in the Release! card game, and they already make up a strong hand. Now that the team at Inedo have interviewed everyone who's lending their face and support, Patrick introduces the rest of the roster, covering everyone from Kathy Sierra to Gene Kim, and points out just how they've contributed to our field.… Read more
Around the middle of last year, Alex Papadimoulis introduced us to Release!, the game about building software. With their wildly successful kickstarter, and enthusiastic support from many pillars of modern software development, the team have create a fun game with a strong pedigree. Patrick Roach is the lead game designer for Release!, and who better to introduce us to the software engineering Greats who have contributed their support and their faces to the game.… 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
"You cannot inspect quality into a product" - Harold Dodge. The adoption of Continuous Delivery often leads to the discovery of suboptimal practices within an organisation, and the Release Testing antipattern is a common example. Steve Smith explores the questions: what is Release Testing, and why is it an example of Risk Management Theatre?… 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
Matt Hilbert has noticed a term that keeps popping up: The Next Generation DBA. He believes it's been coined because change is afoot, and a lot of change that will transform the way DBAs work. But what exactly is going on - and what can you do to actually become a Next Gen DBA?… 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
As a society, we have an unrealistic respect for data, especially if it has a decimal point somewhere and uses metric units. We who are in the business of data need to cultivate a renewed interest in the sceptical and rigorous science of statistics: it is too important to leave to 'Data Scientists'. If the data is wrong, or the way we analyse or report it is misleading, much of what we do is pointless… Read more
What do Technical Architects (TAs) actually do when in a development role? Are they just senior developers 'pushed upstairs' into a management role? Is there a clear distinction between a TA and a product, or project, manager? In an increasingly automated and joined up development environment, the role is important, varied and wide-ranging; as Grzegorz Strzelecki explains… Read more
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
