Louis Davidson
Database design writer, speaker, and doer.
Cleveland, Tennessee, United States
Actions
Louis, also known as drsql (despite the lack of any post-graduate education) is a database design fanatic and has been for over 25 years when he started writing his first book on the topic. He has been a blogger, writer, editor, speaker, and champion of the idea that if you start any project with a firm foundation, it will serve you well for years and years. You can find out more on his website at drsql.link.
Badges
Area of Expertise
Topics
Relational Database Design Fundamentals
Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common SQL programming "difficulties" are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = 'A' is killing your performance, and more time for solving the next customer problem.
Please note that Sessionize is not responsible for the accuracy or validity of the data provided by speakers. If you suspect this profile to be fake or spam, please let us know.
Jump to top