CACTUSS North

CACTUSS

Capital Area Central Texas User of SQL Server

PASS affiliated user group for Austin, TX

Contact us: Email: CACTUSS.SQL (at) (gmail) (dot) (com)
Twitter: @CACTUSS_SQL
LinkedIn: https://www.linkedin.com/groups/149440
Meetup: https://www.meetup.com/Austin-SQL-Server-User-Group/

Upcoming Meeting Dates

  North
Mar 2020 Tue 3/17/2010
Speaker: Open
Topic: Submit your topic to speak
Apr 2020 Tue 4/21/2020
Speaker: Jeffrey Palermo
Topic: DevOps
May 2020 Tue 5/19/2020
Speaker: Open
Topic: Submit your topic to speak
Jun 2020 Tue 6/16/2020
Speaker: Open
Topic: Submit your topic to speak

Meeting Location

CACTUSS North

  • Meeting dates: 3rd Tuesday of the month
  • Meeting starts: 5:30 pm with food and a QA session
  • Presentation: 6:00 pm and goes to 7:15 pm
  • Address
    • Quarry Oaks II
    • Microsoft Office
    • Suite 225
    • 10900 Stonelake Blvd.
    • Austin, TX 78759
      • * Free parking
      • * Coming from Braker, go right/straight at the traffic circle and it's the building on the left.
      • * The building is also across from the outdoor basketball court
      • * Not the building attached to the parking garage
      • * Inside the Microsoft office, go right, past the reception desk, to the far back and left
      • * If there is interest, there is sometimes an after-gathering at a local place to talk casually
    • Map: http://binged.it/1HOSMWm

Next Meeting

Tuesday,

February

18

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

10900 Stonelake Blvd. Suite 225 - Microsoft Office
Austin, Texas 78759
Time: 05:30 - 07:30

Title: How Bad Are Bad Page Splits
by: Mike Byrd

Summary: (20 minute talk, presented first) 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.

Speaker: Mike Byrd, Senior Database Engineer ByrdNest Consulting:
Bio: 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.

Title: PowerShell for the DBA
by: Amy Herold

Summary: (main talk, presented second) 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.

Speaker: Amy Herold, Premier Field Engineer Microsoft:
Bio: 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.

Special Notes:

.

Available Attachments:

Our monthly meetings are made possible by the generosity of these sponsors:

This month's sponsor:

(Feature coming soon)

Ongoing sponsors:

Microsoft

SQL Watchmen  

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids