webcast signup header

Data Modeling Scenarios and Best Practices


In this session we'll look at typical data models used for relational databases whether for transactional systems or warehousing solutions. We'll also consider cases where non-relational solutions provide a better option and how we ultimately bring that back into a relational model for reporting and analysis. As a result, we'll look at the power of the Entity-Relationship model along with best practices for normalization. We'll also cover when denormalization makes sense, which is often the case in warehousing models like with star and snowflake schema.

Webcast Date

Wednesday, January 23, 2019
8:00:00 PM UTC | 3:00:00 PM EST

Speaker(s)

presenter 1
K. Brian Kelley is a SQL Server author, columnist, and Microsoft MVP focusing primarily on SQL Server and Windows security. In addition to being a database administrator, he has served as an infrastructure and security architect encompassing solutions with Citrix, virtualization, and Active Directory. Brian is also a Certified Information Systems Auditor (CISA) and has been the head of a financial organizationís computer incident response team. Brian is active in the IT community having spoken at DevConnections, SQL Saturdays, code camps, and user groups. He is also the President of the Midlands PASS Chapter, a Professional Association for SQL Server Chapter located in Columbia, SC.

Sponsored by

sponsor logo


Register for this webinar:

First Name*


Last Name*


Business Email*


Organization*


Org Address*


Org City*


Org State


Org Postal Code*


Org Country*


Org Phone*


Industry*


Job Title*


# of SQL Servers*


Organization Size*


SMS reminder
carrier: number: (5551234567)


Save My Details

Register me for these webinars too:

 
Are your SQL Server databases suffering from deadlocks?
Tuesday, January 22, 2019 - 3:00:00 PM EST
Speaker(s): Todd Phillippe - Sponsor: IDERA

 
Why Clustering for SQL Server High Availability?
Thursday, January 24, 2019 - 1:00:00 PM EST
Speaker(s): Dave Bermingham - Sponsor: SIOS

 
Donít Be the Next Data Breach - How to Secure SQL Server in the Cloud
Tuesday, January 29, 2019 - 3:00:00 PM EST
Speaker(s): Connor Cox - Sponsor: DH2i

 
Getting Started with SQL Server Query Tuning
Thursday, January 31, 2019 - 1:00:00 PM EST
Speaker(s): Joey DAntoni - Sponsor: Quest

 
Do you need to manage SQL Server instances in hybrid environments?
Tuesday, February 05, 2019 - 3:00:00 PM EST
Speaker(s): Justin Wilkes - Sponsor: IDERA

 
SQL Server Database Administration Made Easy
Tuesday, February 19, 2019 - 3:00:00 PM EST
Speaker(s): Devin Gallagher - Sponsor: IDERA

 
Break Out of Your Silo Ė Know Your SQL Server Storage!
Tuesday, February 26, 2019 - 3:00:00 PM EST
Speaker(s): Rob Mandeville and Kevin M. Sparenberg - Sponsor: Confio

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


 

 


Copyright (c) 2006-2018 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.