Non-Functional Dependencies - A talktorial on getting performance and scalability right through proper Database Design and understanding Set and Relational theory
Bad performance is often systemic of poor queries which are systemic of bad schema design which is systemic of non-relational thinking which is systemic of project time constraints and lack of understanding of Database Design. In this talk/tutorial I'll work my way through Normalisation, we'll look at the Relation Model and how to think in sets - it's very important; throughout I'll be referring to Codd and Date's teachings. Theory aside I'll do all my demonstrations in SQL Server - concurrency, indexing, good T-SQL practices and advice.
Speaker focus
Tony began his long IT career in July 86, completed an apprenticeship as a Production Systems Analyst in April 90, he has used many languages and products throughout that career the main ones being IDEF-0, Application System, PL/1, CICS, DB2, System W, Oracle, SQL Server, Visual Basic, Visual Basic .NET and C++. He has worked in many industries including Finance, Retail, Web and Engineering and provided consultancy to hundreds of companies. Tony currently works as a freelance SQL Server specialist and program manager/coordinator tackling consultancy, offsite project development and training/mentoring. Tony has had a solid presence in the SQL Server community since 1997, he started the UK SQL Server User Group, was one of the founding members of SQL Bits and Developer Developer Developer and runs SQLBlogcasts.com, he has received the SQL Server MVP award from Microsoft annually since 1998. Tony is currently taking a 2 year part time MSc in Business Intelligence at Dundee university.
Other sessions from this conference