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

April 2017 Monthly Meeting – A Functional Review of Visual Studio Database Projects

Bio:

Cameron Snapp is a MCSE and PMP certified IT Consultant with 14 years of database architecture and development experience. He has worked on dozens of Microsoft SQL Server OLTP, Data Warehouse, and Business Intelligence projects. He holds a Computer Science degree from the University of Richmond and a Master’s degree in IT Management from the University of Virginia. Cameron specializes in IT Projects related to data strategy, modeling, integration and reporting.

Session Title:

A functional review of Visual Studio Database Projects with feature tips and demo

Abstract:

Visual Studio (VS) has finally delivered a great way to manage databases within the Software Development Lifecycle. While VS has offered a Database Project type for several years, to me, it was never really a sustainable way to create, manage, source control, schema compare, and deploy database objects. In this presentation, I’ll break down the feature set of database development in VS and offer some experience tips for SQL database developers to start working in what really is a great new way.

Posted in Uncategorized | Leave a comment

March 2017 Monthly Meeting -Automated SQL Server Installation and Configuration Using PowerShell

 

profileBio: Jamie Wick is the Systems & Database Engineer for The College of William & Mary and has been working with databases for the past 10+ years.  His background includes working for several years as a SQL SysAdmin for the University of Queensland (Australia), a Master’s degree in Computer Information Systems from Boston University, and assorted Microsoft SQL certifications.  He is a volunteer & speaker at regional SQL events (User Groups/SQLSaturdays), helps run the Richmond SQL Server Users Group and SQLSaturday RVA events, and is an avid photographer.

Session Title: Automated SQL Server Installation and Configuration Using PowerShell

Abstract: Using the SQL setup wizard and management studio (SSMS) to install and configure a new SQL server is a time-intensive process.  PowerShell scripts can greatly reduce the time required to complete the process.  They can also ensure build standardization throughout your SQL environment.  In this session we will look at PowerShell scripting, including the basic syntax and commandlets needed to automate the installation and post-install configuration of SQL Server (2016).

Download the presentation file

Posted in Meetings | Leave a comment