Join Ami Levin for some pure T-SQL coding challenges fun! You'll take apart common programming challenges that are typically hard to solve using conventional means.
Fortunately, we have on our side the less-conventional window functions to get the job done. Ami will explore linear interpolation, temporal challenges, island issues, and other goodies, as time permits.
After this session, you'll have a few more tools in your arsenal to make your life easier, impress your colleagues (and boss!), and make your users happier :-)

You will be surprised how far reaching implications arise from the keys that you choose... In this session we will revisit some of the fundamental design principals of relational databases: normalization rules, key selection, and the controversies associated with these issues from a practical perspective. We will consider the benefits and challenges of using different types of keys - natural, surrogates, artificial (and others?) from multiple aspects: data consistency, application development, maintenance, portability and performance.