For many decades now both developers and DBA’s have viewed the database as somewhat of a slow moving monolith which should be altered as little as possible and designed very clearly upfront. This mind set often leads to large parts of the database becoming unused but never being cleaned. It also leads to the classic issue of tables that no one wants to clean out because they still contain a single column that is being used by some part of the solution… but no one remembers why or how.
Databases, like our code, are an integral cog in the solutions we work with. This is especially true in the Enterprise space, and as such need to be maintained and refactored with the same diligence as code. Refactoring a database! An absurd concept!
Join us at the Durban Agile User Group September 2014 Meet-up hosted at SA Home Loans on Tuesday, September 16, 2014 at 5:30 PM where Chris Tite will share how his team has been applying agile principles in database design and maintenance on their projects and products with great success.
Chris will be sharing the practices and principles applied to some of their largest and most complex databases, including a banking product, run by one of South Africa’s largest banks, which managed 2 Billion Rand per annum and was successfully migrated between major versions 2.0 to 4.2 with minimal downtime.
Recorded on the 19 November 2013 at the Coastlands Hotel in Durban – this session was hosted by Chris Tite, entrepreneur, software architect and speaker.
More details on Chris can be found on his website www.christite.net.
The lecture introduces what developers need to know about databases to provide scalable and highly performant architectures.
The complete video recording of the recent SQL High Performance Relational Databases lecture presented by Chris Tite.
The Q&A from the SQL High Performance Relational Databases lecture.
This session on relational databases focuses on:
• The anatomy of a database call, primarily to bring to the for the importance of memory and physical disks (log and data files)
• SQL row and table structure and points to consider when writing enterprise systems.
• SQL Table structures heaps vs tables
• Indexes; Clustered and Non-Clustered Indexes and their structure and effects on database performance.
• Database architecture; data and log files and how they affect performance
About the author and presenter, Chris Tite:
Chris is a software architect with 20 years experience. He is passionate about quality software and great architecture, while forging the growth of this generation of software developers. Chris holds a B.Sc. Electronic Engineering degree with over 18 years of development experience spanning several platforms and industries. He sports extensive experience with Microsoft tools like ASP.Net, C#.Net, VB.Net and SQL, as well as with ETL and Data Warehousing tools.
Chris is a true software professional, well versed with open source tools and languages, including such staples as PHP, Perl, Postgres, and MySQL hosted on Linux. He has a passion for software architecture and processes. Since 2005, Chris has been enthused by Agile development methods, seeing first hand the delight of clients experiencing progressive and effective delivery of a shared vision.