Platinum Sponsor

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 SQL Server MVP awardee, developer and DBA, and independent consultant. She is Senior Editor at, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in professional and Women in Technology organizations. She has presented at multiple technical conferences nationwide.
  • Video