August 2019 – Meeting

Speaker – Justin Randall (view bio)

Session – Managing In-Memory OLTP – A DBA Field Guide

In-Memory OLTP can provide a significant performance boost to a range of workloads where lock contention, logging, and disk-based page structures limit query performance. In this session, we will explore the technology behind memory-optimized tables, what workloads will achieve the greatest performance gains, and highlight critical issues in implementing and managing SQL Server instances and databases containing in-memory objects.

Register for this meeting

Posted in Uncategorized | Leave a comment

July 2019 – Meeting

Speaker – Matt Gordon (view bio)

Session – Top 5 Tips to Keep Always On AGs Always Humming and Users Happy

Have you ever wondered what it takes to keep an Always On availability group running and the users and administrators who depend on it happy? Let my experience maintaining several production Always On Availability Groups provide you some battle-tested information and hopefully save you some sleepless nights. From security tips to maintenance advice, come hear about some less than obvious tips that will keep users happy and the DBA’s phone quiet.

Register for this meeting

Posted in Meetings | Leave a comment

June 2019 – Meeting

Speaker – Monica Rathbun (view bio)

Session – Performance Tuning, Getting the Biggest Bang for Your Buck

Everyone wants to know if there are magic buttons you can push to make SQL Server run faster, better and more efficiently. In this session we will go over some of my go-to performance tricks that you can implement to get the biggest improvement with the least amount of change. When it comes to performance tuning, every second counts. We will cover memory optimization, isolation levels, trace flags, statistics, configuration changes and more. I’ll go over real life scenarios we come across as consultants and the changes we made to fix them.

Register for this meeting

Posted in Meetings | Leave a comment

HRSSUG May 2019 Meeting

This Month’s Speaker :

Speaker: Kevin Feasel

Title: SQL Server Machine Learning Services in Production

Writing code which uses SQL Server Machine Learning Services is easy enough, but that is just the beginning of the story. In this talk, we will cover the rest of the R development story for database administrators. We will look at the methods available to install and maintain R packages, learn good practices for deploying and maintaining custom SQL Server Machine Learning Services code, and learn where to find critical information when things break. These battle-tested tips will make it easier for you to integrate R and SQL Server Machine Learning Services in your existing deployment processes and get the most out of this feature.

Bio:
Kevin Feasel is a Microsoft Data Platform MVP and Engineering Manager of the Predictive Analytics team at ChannelAdvisor, where he specializes in T-SQL and R development, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com) and author of PolyBase Revealed (forthcoming). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.

Posted in Meetings | Leave a comment

April 2019 – Meeting

Speaker – Anders Pedersen (view bio)

Session – “Cursors are bad, never use them!”

How many times have you been told this by your senior DBAs or developers? In this session I will explore why I use cursors to solve certain problems. Discuss when they are appropriate, and when they are not.

Register for this meeting

Posted in Meetings | Leave a comment