The Performance Virtual Group's mission is to empower the global Microsoft SQL Server database community with technical content regarding performance related to SQL Server.

Login to Subscribe

Welcome to the Performance Virtual Group

Next Meeting

August Meeting

Thu, Aug 25 2016 18:00 UTC

SQL Server Storage

Understanding how SQL Server organizes your data under the hood can seem like a daunting task. But Brandon Leach makes it fun by explaining the concepts and telling humorous stories along the way. In this session, Brandon will focus on how objects are stored in a data file. <BR><BR> You'll hear how these concepts tie in to your work as a DBA or developer. You’ll get to see the concepts in through demos and learn how you can use this knowledge to design better solutions. Brandon will also demo some neat tools to help you dig in and learn further. <BR><BR> After this session you will understand: <BR>• The three basic types of storage in SQL Server <BR>• The physical structure of a row and how it affects performance <BR>• Differences in how SQL Server works with heaps and clustered indexes <BR>• How pages are allocated and tracked <BR>• How to use various tools to continue your learning


Brandon Leach

Brandon is a Senior DBA and Microsoft Data Platform MVP. He is a frequent speaker at events like SQLSaturdays and user groups.

Contact the Performance Virtual Group

Are you interested in being a Presenter, getting involved with the Group or simply provide us with some feedback? Please fill in the form below

Your Contact Information

Your Feedback

Thank you for contacting us, we will get back to you as soon as possible!
Back to Top
cage-aids
cage-aids
cage-aids
cage-aids