Rochester PASS

Gold Sponsors

           

     

Upcoming Chapter Events

Next Meeting: Thu, Feb 25 2016

Silent Killers Lurking in Your Schema with Mickey Stuewe

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: http://nextplex.com/rochester-ny/groups/rochester-pass-ssug/events/37040-silent-killers-lurking-in-your-schema-with-mickey-stuewe

Please note the change in location!

Parking: Parking is available on the street for free. The Court Street garage is advertised at $2.00/hour, but has a tunnel connecting to the building.

TEKSystems Office: When you enter the building, please take the main elevator to the 8th floor. You may have to check in at the security desk.


When

iCal
UTC : Thu, Feb 25 2016 23:00 - 01:00
Event Time : Thu, Feb 25 2016 18:00 - 20:00 (UTC-05:00) Eastern Time (US & Canada)
Your Local Time: Thu, Feb 25 2016 23:00 - 01:00

Where

800 Bausch & Lomb Place
Rochester, New York

Direction: None

Featured Presentation

Silent Killers Lurking in Your Schema

Speaker: Mickey Stuewe, Sr. Database Developer Quick Bridge Funding

Summary: A good database design goes deeper than the rules that Codd gave us. We need to leverage SQL Server to help enforce the Codd’s. In this class we’ll look at some common questions like: I have foreign keys, why do I need foreign key constraints too? Why are smart keys not so smart? If I use an identity field, do I still need to declare it as a primary key? The wrong answers to these questions can slow your queries down over time and even create bad data. Join me in my session as we look at demos to understand how silent killers can begin to lurk in your schema.

About Mickey: 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.

Attachments

Supplementary Materials

The following event attachments are available to you:

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids