NORTH - How Bad Are Page Splits - Mike | PowerShell for the DBA - Amy Herold


Details
5:30 pm - Doors open and pizza is delivered
5:50 pm - General announcements
6:00 pm - How Bad Are Page Splits by Mike Byrd
6:20 pm - PowerShell for the DBA by Amy Herold
============
How Bad Are Page Splits by Mike Byrd
Abstract:
We've always been told that Bad Page Splits hurt performance, but there is little showing actual performance decrements. This session will review the difference between good and bad page splits and continue with an example highlighting the performance decrements encountered during a bad page split as well as the on-going effects of the bad page split on a SELECT query. Results for this example indicate a much larger performance hit than anticipated.
Mike Byrd - Senior Database Engineer, ByrdNest Consulting
Former rocket scientist and USAF Fighter Pilot -- now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.
Presenter at 17 SQL Sat sessions in 2016, 10 in 2017, 8 in 2018 (Cambridge) and Chicago, Jacksonville, Dallas, Pensacola, Austin, and Baton Rouge in 2019; as well as several local SQL Server user's groups in Ft. Worth, Austin, and San Antonio; and 2 Virtual DBA presentations in 2018.
============
PowerShell for the DBA by Amy Herold
Abstract:
PowerShell is a tool used by many people in DevOps and Infrastructure. Should the DBA get on board with using PowerShell? The answer is yes - as a DBA, PowerShell can have a significant impact on tasks that would be long and tedious with just T-SQL alone. Today there are specific modules that can be incorporated into PowerShell to help in automating every-day DBA tasks. Beyond that, PowerShell can be used to do things like automate deployments and audit permissions.
In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.
Amy Herold - Premier Field Engineer with Microsoft
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQL Saturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.


NORTH - How Bad Are Page Splits - Mike | PowerShell for the DBA - Amy Herold