Saturday Night SQL Virtual Group is an open forum for discussions about Business Intelligence and Databases. This chapter sets the stage for every Microsoft SQL Server professional to share knowledge, to learn new techniques, to get answers on various topics related to data technologies, and to resolve real world issues.

"Silent Killers Lurking in Your Schema" and Open Forum

Sat, Aug 06 2016 21:00 Eastern Daylight Time

RSVP: https://attendee.gotowebinar.com/register/5624182668202905857

Silent Killers Lurking in Your Schema

You’ve inherited a database that needs to be refactored. Is your database inundated with orphaned records, or worse dirty data? Is your database lacking foreign key constraints, or any other constraints? Do you know where to start? If you’ve answered yes to any of these questions, then join me in this demo heavy session. We’ll look at some bad design patterns that can hurt performance. We’ll look at how dirty data and orphaned records can creep into your database over time. We’ll also identify data types that can be causing your database to grow faster than expected. Finally, you’ll learn how to search for these issues by analyzing system tables in your database, collecting information on indexes, and learning how to set up extended events for additional analysis. When you finish this session, you’ll be armed with knowledge to hunt down the silent killers that can be lurking in your schema.


Mickey Stuewe

Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design. She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQL Saturdays, User Groups and other events. When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often...just ask her children.

Sponsors

PASS VC

Thank you for your support: James Feary

2017 PASS Summit discount code: VC15QVS7


Twitter: Sat_Night_SQL
Email: SaturdayNightSQL@sqlpass.org
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids