Feb 2015 ~ Basic Database Design ~ John Miner

I am thrilled about presenting to the Southern New England SQL Server User Group (SNESSUG) on February 11, 2015.

I always love the home team advantage by knowing the audience very well. It makes for a relaxing environment to teach and attendees to learn.

Here is the gritty details of the presentation that I will be exploring during the 60 minute talk.


Basic Database Design


You just found out that a client needs a SQL database to be designed from scratch. However, your existing DBA has given two weeks notice.
This presentation is meant for the Accidental DBA that has little to no experience with creating a database from the group up.

Topics are focused on data storage structures, security, and integrity.
After this presentation, will be ready to meet that clients need.

1 – Files & File Groups
2 – Logins & Users
3 – Security using schemas
4 – Database roles for access.
5 – Table design via SSMS or TSQL.
6 – Default, Check, and NULL constraints
7 – Handling table relationships (PK vs FK).
8 – To index or not to index?
9 – Testing database integrity using DML.


John is the recent recipient of the Microsoft 2014 MVP award for SQL Server. He has over twenty years of IT experience including a Masters degree in Computer Science from the University of Rhode Island with concentrations in database technologies and programming languages. He also has Microsoft Certificates for Database Administration (MCDBA) and System Administration (MCSA).

John is currently a Senior Consultant at Atrion. He is the PASS chapter leader for Southern New England SQL Server Users Group.

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *