Inspector Insert And The Case Of The Mistaken IDENTITY

Kendal Van Dyke

About Kendal:
Kendal is a database strategist, community advocate, public speaker, & blogger. A practiced IT professional with over a decade of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, & debugging/troubleshooting mission critical SQL Server environments. Kendal is a Principal Consultant at UpSearch SQL (upsearch.com), a Microsoft MVP, & President of MagicPASS (magicpass.sqlpass.org), the Orlando, FL based chapter of PASS.

Inspector Insert And The Case Of The Mistaken IDENTITY - Session Abstract:
Think you know everything about working with identity values? Think again - they're not as straightforward as they seem! Follow along as Inspector Insert discovers the many ways to end up with a case of mistaken identity and learn how to make sure you're working with the right identity values every time. Attendees will: - Understand how identity columns work - Understand all the ways to return identity values and what factors influence their accuracy. - Learn how to always be sure they're working with the right identity values in TSQL.