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
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
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
"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
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
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
NuGet is the standard package manager for the Microsoft development platform including .NET. It has transformed the ease of getting and installing the latest version of .NET packages, tools and frameworks. It relies on NuGet package authors to get packages right but there is little documentation for them to go by, and there are a few inevitable problems. Ed Charbeneau offers advice from experience … Read more
'Immutable' databases operate under the principle that data or objects should not be modified after they are created. Once again they hold the promise of providing strong consistency combined with horizontal read scalability, and built-in caching. Are Immutable databases a new idea? Are they different in any way from the mainstream RDBMSs.… Read more
For many developers, does DBA really stand for Don't Bother Asking? David Poole thinks it is time to end the unnecessary conflict between developer and DBA, and explains how to deal professionally with the inevitable friction between development and operation activities in IT… Read more
Chris Date is famous for his writings on relational theory. At IBM in the seventies, and afterwards, he was a friend and colleague of Edgar Codd, who invented the principles of the relational database. Chris took on the role of communicating and teaching Codd's relational theory, and reluctantly admits to a role in establishing SQL as the dominant relational language. Richard Morris interviews the well-known author and computer scientist… Read more
Compliant Database DevOps
Standardize team-based development
Automate database deployments
Monitor performance and availability
Protect and preserve data
