SQL Server Storage internals: under the hood. - Brandon Leach, Network Health

Ever wonder what goes on under the hood of your SQL Servers? SQL Server is a complicated system. Understanding how your data is actually stored on disk can have a profound effect on the choices you make while designing and architecting a solution. In this session I'll show you how data is physically stored and how choices you make effect performance. We'll look at the structure of rows and data pages, index allocation maps, and the physical differences between heaps and clustered indexes.

Brandon is a veteran of IT in the healthcare industry. Originally starting out his career as a web developer, he fell in love with SQL Server and database development and administration. Currently he manages 100+ SQL Servers for Network Health in Medford, Ma. He works closely with the development and infrastructure teams as well as management in and out of IT to make sure the needs of the business and its future goals are met.

Join or login to comment.

  • Casey P.

    I have several direct hire, permanent SQL developer positions available in RI. Please contact me at your earliest convenience to discuss these opportunities. [masked]

    1 · August 4

  • Casey P.

    SQL Developer opportunity available in RI. Please contact me today to discuss the details. I look forward to speaking with you. [masked]

    July 7

  • Rabindra A.

    very expert Brandon.

    June 14

  • Jerry

    Very informative

    June 13

  • Robert P.

    June 13

  • Casey P.

    It was great meeting everyone Wednesday! Millennium Consulting is looking forward to sponsoring more events. I do have a long term contract SQL DBA opportunity available in Lexington, MA. Please contact me at your earliest convenience to discuss this role. I look forward to speaking with you. [masked]

    1 · June 13

  • Peter

    great presentation. looking forward to more.

    1 · June 12

  • Sundeep J.

    Thanks for sharing all of that knowledge . It was a very good introduction . It would be great if you could share the slides too.

    1 · June 12

  • Jay B.

    Very interesting discussion.

    1 · June 12

  • Frank

    Very useful. I would like to see a followup to this meeting to hopefully get even deeper in to the SQL server internals.

    1 · June 12

  • Ming

    Very good introduction to SQL internals.

    1 · June 12

  • Melanie B.

    Sadly, I have to withdraw from tonight's meetup as well. I do hope you will hold this one again!

    1 · June 11

  • Clay B.

    Ditto Steven's comment.... Wish I could attend but tomorrow night just isn't possible for me. Any chance this one might happen again at a future date? I'd def be interested!

    1 · June 10

    • Brandon L.

      I'll submit it to the next Boston sqlsaturday :)

      2 · June 10

    • Clay B.

      Thank you guys!!

      1 · June 11

  • Steven M.

    Hate to miss it, but i am out of town.

    June 5

  • Gunjan M.

    I will be there...

    May 27

Our Sponsors

  • SIOS

    Easy to Use. Easy to Own. Clusters Your Way.

  • Reg Gate Software

    Ingeniously Simple Tools

  • Ntirety

    Total Data Experts

  • PASS

    Professional Association for SQL Server

People in this
Meetup are also in:

Create a Meetup Group and meet new people

Get started Learn more

I decided to start Reno Motorcycle Riders Group because I wanted to be part of a group of people who enjoyed my passion... I was excited and nervous. Our group has grown by leaps and bounds. I never thought it would be this big.

Henry, started Reno Motorcycle Riders

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy