$125

Keeping Your DBA Happy by Rick Lowe (#SQLSatLA)

Event Information

Share this event

Date and Time

Location

Location

Loyola Marymount University (LMU) in Playa Vista

1 LMU Drive

Malone Student Center - The Hill

Los Angeles, CA 90045

View Map

Refund Policy

Refund Policy

Refunds up to 1 day before event

Event description

Description

Keeping Your DBA Happy. Reasons Why Some Practices Drive Admins Nuts by Rick Lowe

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? Any 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

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.

The event includes Coffee, Lunch and Afternoon Snacks & Refreshments. This event does NOT include parking fee of $20.

Brought to you by

Register to attend 2018 SQL Saturday in Los Angeles

Share with friends

Date and Time

Location

Loyola Marymount University (LMU) in Playa Vista

1 LMU Drive

Malone Student Center - The Hill

Los Angeles, CA 90045

View Map

Refund Policy

Refunds up to 1 day before event

Save This Event

Event Saved