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


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 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.

PASS Summit 2018 Registration

Please use this code  VGSTRP9II to register PASS Summit 2018 and also get Streaming Access to all PASS Summit 2017 Content. The registration fee is $1699 USD.

The regular $150 discount code will be released on March 23, 2018.

Twitter: Sat_Night_SQL

Sponsor - Thank you for your support: James Feary

Back to Top