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 discusses keys and constraints.… 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 powers. In July 2017 I... 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 of the years), and (I... 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 the process of designing and... 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 dominated the industry for a... 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 mess-up just one of these,... 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 to database development. If databases... 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 might not be well. These... 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 very beginning I am hoping... 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. We’ve done things a little... 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, but if you get them... 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 is it happening and what... 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 authors, Louis Davidson. Bob Sheldon... 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 in the typical size of... 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. For this, the intelligent use... 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 considerable time over meticulous database... 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 classic of bad database design,... 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 the problem, even with expert... 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 is absolutely nothing like Buck... 18 March 2010 3 min read
Anith Sen Five Simple Database Design Errors You Should Avoid Anith follows up his highly successful article Facts and Fallacies about First Normal Form with a fascinating discussion of five common database design errors which... 16 October 2009 18 min read