T-SQL Brush-up:The Best Things You Forgot You Knew About SQL

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. 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.
Presented by Jennifer McCown at SQLBits X
  • Downloads
  • SpeakerBIO
    Jen McCown is a Microsoft Certified Master in SQL Server, and co-owner of MidnightSQL Consulting, LLC and MinionWare, LLC. She produces IT training material for MidnightDBA.com, including training videos, the DBAs@Midnight webshow, blogs, reviews, and podcasts. In her consulting work, she specialized in performance tuning, troubleshooting, server maintenance, installations, and enterprise management. She is a member, volunteer, and speaker in PASS, and PASS Women in Technology. She has presented at multiple technology conferences, including SQL Saturday, SQL Bits, and the PASS Summit. She is a vocal advocate of the Oxford comma.
    http://www.MidnightDBA.com/Jen http://www.midnightdba.com/Jen/feed/
  • Video