North Texas SQL Servers Users Group

Next Meeting

Thursday,

February

19

19 FEB 2015 NTSSUG Meeting

  • In-Person @ 7000 North Highway 161 Irving, Texas, United States (map)
  • 18:00 - 21:00 (UTC-06:00) Central Time (US & Canada)
  • Language: English

RSVP Here: None

6:00 - 6:20 - Welcome, Announcements & Food

6:20 - 7:20 - Tracing and Extended Events - 3 Methods to end the Madness by Mindy Curnutt

7:30 - 8:30 - PowerShell Lessons Learned from a SQL Installation and Patch Management Implementation by Fany Vargas

8:30 - 8:45 - Raffle and closing

Featured Presentation:

Tracing and Extended Events - 3 Methods to end the Madness

Mindy Curnutt, Managing Partner Mindy Curnutt & Associates Consulting

In this Session, 3 different approaches to using Tracing and Extended Events will be covered. 1. The Long Running Query. 2. The Thousand Paper Cuts - De-Parameterization & Aggregation 3. Looking at Space Between SQL Calls (how to determine when application slowness does NOT involve the SQL Server). We will go over when to to each of these approaches, how to setup both tradtional Traces and the newer Extended Events to capture the right information, and how to analyze the captured data. Lots of demos and take-away scripts in this session.

About Mindy:
Mindy Curnutt is a 4X Microsoft Data Platform MVP and an Idera Ace whose specialties include SQL Server hardware, configuration, scalability and performance tuning. She has been actively involved in the SQL Server Community for over a decade and has become a well known speaker within the SQL and Transportation Management communities. She presented at the SQLPASS Summits in 2005, 2006, 2012, 2013 & 2015 and was awarded the SQL PASS Outstanding Volunteer award in both June 2015 and September 2016. She has spoken many times at her local North Texas SQL Server User Group where she currently serves on the Board of Directors, and at numerous SQLSaturdays throughout North America. In 2013 and 2014 she was a Team Lead for the SQLPASS Summit Abstract Review Process and from 2015-2017 she has served as one of the few SQLPASS Summit Program Managers. Mindy was also a SME for both the SQL 2012 and 2014 Microsoft Certification Exams and contributed to the Microsoft Press Book "SQL Server 2012 Step by Step". She has two new books in the works as a co-author, "SQL Server 2017 Inside Out" and "Let Her Finish". Mindy is an Independent Consultant. You can follow Mindy at her blog, mindycurnutt.com and on Twitter where she's known as @sqlgirl.

PowerShell Lessons Learned from a SQL Installation and Patch Management Implementation

Fany Vargas, Sr. Premier Field Engineer (Dedicated Support) Microsoft

This session will discuss lessons learned from a SQL installation and patch management automation project. Topics of discussion to include: · Why/When to use PowerShell for SQL administrative tasks · How to use PowerShell for automated SQL installations and patch management, including demo and scripts · Best practices and considerations when writing and organizing scripts to run both locally and remotely

About Fany:
Fany Vargas is a Sr. Premier Field Engineer (Dedicated Support) at Microsoft. She has worked in various roles within the Microsoft SQL services and support teams throughout the past 12+ years - ranging from Support Engineer, Technical Lead, Support Escalation Engineer, and Premier Field Engineer. She graduated with a bachelor’s degree in Computer Science from Florida International University and currently holds the MCSE: Data Platform certification.

Supplementary Materials

The following event attachments are available to you:


Thank You to the 

PLATINUM

SPONSORS 

of our May 2018 

SQL Saturday!











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