Jen McCown, hugely popular speaker at SQL Saturday Oklahoma City this past August, is our remote speaker. Jen is a SQL Server MVP, Co-Host of the popular MidnightDBA postcast, author, community leader and all around educator of masses..
T-SQL Brush-up: The Best Things You Forgot You Knew About SQL Code (aka Forgotten T-SQL) and will cover:
You’re a good SQL professional – you attend conferences and webinars, you read articles and books, and you know your way around SQL Server. But sometimes – just SOMEtimes – some piece of T-SQL slips by you unnoticed, or falls out of memory. Most of us are working with at least two or three out of the last five versions of SQL Server, so who can blame us for missing a feature or two? Come and revisit old favorites, and brush up on new T-SQL features and enhancements. In this session you will see SELECT turned inside-out. You’ll get really, really excited about OVER and PARTITION BY. You’ll learn that Common Table Expressions are, in fact, very cool, and that FOR XML isn’t as scary as it looks. And what’s more, we’ll look and BRAND-new features like SQL Server Denali’s new SEQUENCE object! This session is chock full of code examples, including before-and-after demos and how-to illustrations.