Adrien Payong in Theory and design Database Sharding: Strategies for Seamless Scaling and Performance Optimization Companies of all sizes and across industries are struggling to cope with an explosion of data never before seen in... 13 September 2024 21 min read
Theory and design Joe Celko in Theory and design Constraints and declarative referential integrity Database systems have powerful features built right in that can ensure the integrity of data. In this article, Joe Celko... 06 May 2021 14 min read
Blogs Dennes Torres in Blogs Graph Edge Constraints and a Crystal Ball When I read the list of new features in SQL Server 2019 I became very proud of my crystal ball... 08 December 2018 2 min read
Blogs Louis Davidson in Blogs Speaking at SQL Saturday Memphis on October 6 There are several SQL Saturday events I have attended every event that has existed. Louisville, Nashville, Chattanooga (didn’t speak one... 01 October 2018 3 min read
Blogs Louis Davidson in Blogs Teaching a Database Design and Implementation Class in Orlando 9-13 Thanks to Andy Warren (@sqlandy), on Thursday, September 13, I will be in Orlando, FL teaching an all-day seminar on... 15 August 2018 3 min read
Robert Sheldon Five Online Database Modelling Services To design, or redesign, a database of any complexity, the Entity-Relationship modelling tool becomes essential. The specialized tools that have... 08 February 2016 13 min read
Robert Sheldon How to get Database Design Horribly Wrong Database Design is one of those tasks where you have to carefully get all the major aspects right. If you... 06 March 2015 34 min read
Thomas LeBlanc Defusing Database Time Bombs: Avoiding the Need to Refactor Databases Where applications are evolved by gradually molding them to a growing understanding of the business domain, this presents great challenges... 27 February 2015 23 min read
Phil Factor 119 SQL Code Smells Once you've done a number of SQL code-reviews, you'll be able to identify signs in the code that indicate all... 15 September 2014 3 min read
David Njoku Oracle for Absolute Beginners: Part 8 – Database Design and Normalization A wise man once said, I know one thing: that I know nothing. If you’ve followed this series from the... 27 June 2014 7 min read
David Njoku Oracle for Absolute Beginners: Part 7 – Creating Tables, Constraints and Triggers A wise man once said: start at the beginning and go on till you come to the end: then stop.... 10 June 2014 9 min read
Learn SQL Server Phil Factor in Learn SQL Server Primary Key Primer for SQL Server Every database developer uses keys, but without always understanding all the ramifications. They come with few hard and fast rules,... 02 December 2013 22 min read
Tony Davis Shawn McGehee Managing the SQL Server Transaction Log: Dealing with Explosive Log Growth You've just become responsible for a database, only to find that the log file is growing out of control. Why... 14 March 2013 13 min read
Robert Sheldon Book Review: Pro SQL Server 2012 Relational Database Design and Implementation A book on Relational Database Design and Implementation is always welcome, especially when written by one of Simple-Talk's most popular... 28 November 2012 9 min read
Feodor Georgiev Handling Backups for Rapid Resilience The backup and restore system in SQL Server hasn't changed a great deal over the years despite a huge growth... 20 November 2012 10 min read
Feodor Georgiev Designing Databases for Rapid Resilience As the volume of data increases, DBAs need to plan more actively for rapid restores in the event of failure.... 15 October 2012 12 min read
Alex Kuznetsov Developing Low-Maintenance Databases Alex's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take... 12 June 2012 21 min read
Joe Celko Look-up Tables in SQL Lookup tables can be a force for good in a relational database. Whereas the 'One True Lookup Table' remains a... 01 February 2011 18 min read
Joe Celko The DIS-Information Principle: A Splitting Headache You can easily re-factor bad DML code, but if a database design is wrong, you can do little to rescue... 17 August 2010 10 min read
Buck Woody Mission Critical: Database Design There is nothing like a checklist to make sure you've completed all the tasks in designing a database, and there... 18 March 2010 3 min read
