{"id":62,"date":"2014-03-15T00:00:00","date_gmt":"2013-01-01T00:00:00","guid":{"rendered":"https:\/\/www.sqlhammer.com\/blog\/session-review-brent-ozar-at-rssug"},"modified":"2026-03-18T21:50:53","modified_gmt":"2026-03-18T21:50:53","slug":"session-review-brent-ozar-at-rssug","status":"publish","type":"post","link":"https:\/\/sqlhammer.com\/index.php\/2014\/03\/15\/session-review-brent-ozar-at-rssug\/","title":{"rendered":"Session review &#8211; Brent Ozar at RSSUG"},"content":{"rendered":"<p>Yesterday (Friday, March 14th, 2014) <a href=\"http:\/\/richmondsql.org\/\">Richmond, VA\u2019s SQL Server user group<\/a> was fortunate enough to have Brent Ozar ( <a href=\"http:\/\/twitter.com\/brento\">@BrentO<\/a> | <a href=\"http:\/\/www.brentozar.com\/\">BrentOzar.com<\/a>) stopped by and present a 101 level session on SQL Server Internals.<\/p>\n<p>I made the 4 hour round trip drive out and wasn\u2019t disappointed.<\/p>\n<p>Brent\u2019s presentation covered clustered and non-clustered index structures, how queries parse the data, sargable queries, and how user-defined functions and table variables are a black box to the optimizer. He also explained\u00a0statistics and how execution plans are compiled.<\/p>\n<p>As expected Brent\u2019s information was flawless and presented in an easy to understand way. For me, however, his presentation was not the highlight of the night. EventBright listed the session to run from 6pm-9pm but the presentation didn\u2019t start until 6:45pm and it ended around 8pm. This left a large amount of time of on-topic and off-topic Q&#038;A with Brent. Those Q&#038;A times alone were worth the trip for me because we were able to discuss real world architectures, specifically stackoverflow.com\u2019s.<\/p>\n<p>I\u2019d like to thank Brent for taking his time to come out to RSSUG and look forward to more presentations from himself and the\u00a0rest of the Brent Ozar Unlimited team.<\/p>\n<hr \/>\n<p><img decoding=\"async\" src=\"\/wp-content\/uploads\/dh.jpg\" alt=\"\" \/><strong>Written by Derik Hammer of <a href=\"http:\/\/www.sqlhammer.com\/\">SQL Hammer<\/a><\/strong><\/p>\n<p>Derik is a data professional focusing on Microsoft SQL Server. His passion focuses around <a href=\"http:\/\/www.sqlhammer.com\/blog\/category\/high-availability\/\">high-availability<\/a>, <a href=\"http:\/\/www.sqlhammer.com\/blog\/category\/general\/disaster-recovery\/\">disaster recovery<\/a>, continuous integration, and automated maintenance. his experience has spanned long-term database administration, consulting, and\u00a0entrepreneurial ventures.<\/p>\n<p>Derik gives the SQL community credit for plugging the gaps in his knowledge when he was a junior DBA and, now that his skills have matured, started <a href=\"http:\/\/www.sqlhammer.com\/\">SQLHammer.com<\/a> as one small way to give back and continue the cycle of shared learning.<\/p>\n<p>Derik is the owner and lead author of SQL Hammer, a <a href=\"http:\/\/www.sqlhammer.com\/\">Microsoft SQL Server resource<\/a>.<\/p>\n<p>For more information, visit <a href=\"http:\/\/www.sqlhammer.com\/\">http:\/\/www.sqlhammer.com<\/a>. Follow Derik on <a href=\"http:\/\/twitter.com\/SQLHammer\">Twitter<\/a> for <strong>SQL tips and chat<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Yesterday (Friday, March 14th, 2014) Richmond, VA\u2019s SQL Server user group was fortunate enough to have Brent Ozar ( @BrentO | BrentOzar.com) stopped by and present a 101 level session on SQL Server Internals. I made the 4 hour round trip drive out and wasn\u2019t disappointed. Brent\u2019s presentation covered clustered and non-clustered index structures, how [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":523,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-62","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/62","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/comments?post=62"}],"version-history":[{"count":1,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/62\/revisions"}],"predecessor-version":[{"id":325,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/posts\/62\/revisions\/325"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/media\/523"}],"wp:attachment":[{"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/media?parent=62"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/categories?post=62"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlhammer.com\/index.php\/wp-json\/wp\/v2\/tags?post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}