SQLSatSac PreCon with Rick Lowe: "Keeping Your DBA Happy and Understanding Why"

Jul 27, 2018 · Sacramento, United States of America

Note: To attend this pre-con, you must register via the Eventbrite link provided below. Early bird pricing available - see Eventbrite for detail!

Keeping Your DBA Happy and Understanding Why - Rick Lowe
https://www.eventbrite.com/e/sqlsat-757-precon-keeping-your-dba-happy-and-understanding-why-with-rick-lowe-tickets-44381127146

ABOUT THE SESSION:
Ever used a NOLOCK hint, only to find that nothing broke the next day? Odds are most folks reading this have. So if fire and brimstone did not rain from the sky, why do we worry so much about this hint? What could actually go wrong?

SQL Server supports two table types - heaps and tables with clustered indexes. We almost always create a unique clustered index on tables ... but why? Since heaps are part of the product they must have a use case but what is it? And what is the secret sauce in clustered indexes that makes them so popular?

There is a substantial body of best practice information in the SQL Server community. Many of these practices are routinely ignored in some organizations, presumably because the consequences of not following aren't always clear. Come join this full day session for in-depth explanations of _why_ we give some of the advice that we do.
Query hints, indexing, LINQ to Entities, common table expressions, looping vs set-based operations and more.

ABOUT RICK LOWE:
Rick is a Microsoft Certified Master with more than 15 years of experience working with SQL Server. He currently works as an independent performance DBA/Developer for clients across the USA and Canada. He started his career as a database developer, but over time became more and more interested in how the database engine operated ... eventually becoming more focused on operational and performance issues than code. Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

Keeping Your DBA Happy and Understanding Why - Rick Lowe
https://www.eventbrite.com/e/sqlsat-757-precon-keeping-your-dba-happy-and-understanding-why-with-rick-lowe-tickets-44381127146

Event organizers
  • Sacramento SQL Server User Group

    The Sacramento SQL Server User Group is a local chapter of the Professional Association for SQL Server (PASS). The mission of PASS is to empower data professionals who leverage Microsoft technologies to connect, share, and learn through networking, knowledge sharing, and peer-based learning. We meet the first Wednesday of each month (6PM to 8PM) to discuss anything SQL Server.  Additionally, we host a SQLSaturday event every July. We are new to Meetup.com, but we are not a new group; we've been meeting si

    Recent Events
    More

Are you organizing SQLSatSac PreCon with Rick Lowe: "Keeping Your DBA Happy and Understanding Why"?

Claim the event and start manage its content.

I am the organizer
Social
Rating

based on 0 reviews