July 2017 Monthly Meeting – Seven Points Administrators Should Know About Execution Plans

Come out and join us on Wednesday July 19th for an informative session!  Please remember to bring school supply donations in conjunction with Sentry One’s sponsorship of SQL Vacation!  Details of the contest and desired supplies can be found here.

Abstract: Seven Points Administrators Should Know About Execution Plans

Every time we send a query to SQL Server, the database has to execute your query. This session will review seven areas you should know about execution plans, how they work, and how to help make your job easier.

Speaker: Carlos Chacon

Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast. Carlos is regular contributor to the SQL Server community in Richmond and is planning a SQL Server conference in October. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven).

Additional info:  SQL Data Partners is hosting a two day conference on October 4-5, 2017 in downtown Norfolk.  They have graciously provided our User Group with a discount code ( B3F9EC) More details and registration can be found here.

The great SQL podcast from SQL Data Partners can be found here

Thank you to our Sponsors!

Posted in Meetings | Leave a comment

July 2017 SQL Vacation Meeting

We are honored to have Kevin Kline of SentryOne joining us as part of his “SQL Vacation” tour!  He will be presenting his famous session on end to end troubleshooting in SQL Server.

In addition to having Kevin Speak SentryOne will be collecting school supply donations and will be awarding an awesome Barbecue apron to 3 lucky individuals from all the entries.  Please see http://info.sentryone.com/sql-vacation-2017 for details on how to enter.

Come on out and join us for a

Posted in Announcement | Leave a comment

HRSSUG July 2017 Bonus meeting

 

Speaker: Kevin Kline

Bio:

Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, Google Author, and long-time blogger at sqlblog.com and at kevinekline.com. As a noted leader in the IT industry, Kevin’s blog covers Microsoft SQL Server features and best practices, third-party software, trends in the IT industry, and professional development for IT professionals.

Session Title:

FIRE! A Full-proof Checklist for Tuning and Troubleshooting

Abstract:

Learning how to detect, diagnose and resolve performance problems in SQL Server is tough.  Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.

In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:

 

  • XEvents, Profiler/Traces, and PerfMon
  • Using Dynamic Management Views (DMVs)
  • Advanced Diagnostics Using Wait Stats
  • Reading SQL Server execution plan

 

Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.

 

In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:

 

  • XEvents, Profiler/Traces, and PerfMon
  • Using Dynamic Management Views (DMVs)
  • Advanced Diagnostics Using Wait Stats
  • Reading SQL Server execution plan

 

Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.

Thank you to our Sponsors!

Posted in Meetings | Leave a comment

June 2017 Monthly Meeting – Moving Production Data Out of Production

Speaker: Tom Norman  

Bio:

In 1998, Tom changed his career focus to begin working with Sql Server. He has worked in all aspects of Sql Server including Administration, Database Development, BI and Reporting Services. He has worked in the Finance and Compliance industry. His experience has included International deployments. Tom is the Leader of the PASS Virtualization chapter and the past President of the Denver Sql Server User Group.

Session Title:

Moving Production Data Out of Production

Abstract:

Websites are slow or breaking due to unexpected data. We believe we know the data, but do we? Moving Production data requires us to meet government regulations. Obfuscating data and creating environmentally aware servers will allow us to mimic Production. Having better data and knowing what to expect in the data produces better development and testing results. Better results create better websites.

Thank you to our Sponsors!

 

 

Posted in Meetings | Leave a comment

May 2017 Monthly Meeting – Crazy Things Developers Do!

Speaker: Wayne Sheffield

Bio:

Microsoft Certified Master in SQL Server, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of SQL Server 2012 T-SQL Recipes, and enjoys sharing his knowledge by presenting at SQL PASS events and blogging at http://blog.waynesheffield.com/wayne

Session Title:

Crazy Things Developers Do!

Abstract:

Throughout my career, I’ve seen developers do some pretty crazy things to databases (and truth be told, I’ve done some of these myself!). Come to this session to learn what we do and why it’s bad to the database server (or your career)… and alternatives that can be used instead. Some of the topics that we’ll discuss are the pitfalls of using NOLOCK, how coding mistakes open up the database for SQL Injection attacks, and how design choices keep SQL Server dumb – and if it was allowed to be smart, it would be faster! Trust me… your DBA will love you for making these changes.

Thank you to our Sponsors!

 

 

Posted in Uncategorized | Leave a comment