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 Uncategorized | 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

HRSSUG March 2019 Meeting

This Month’s Speaker :

Speaker: Cameron Snapp

Bio:

Cameron Snapp is a MCSE and PMP certified IT Consultant with over 15 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.University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.

Title:

Azure Data Engineering

Abstract:

As Microsoft releases new Azure features, migrating your ETL processes to the cloud is becoming easier all the time, but also more confusing. Understanding the use and connectivity of the different storage and services is more critical than ever. I’ll start with an overview of Azure data components, detail how they can be integrated, and demo the lift and shift of existing SSIS packages to Azure. I’ll also demo some dynamic ways to program Data Factory and the features of the brand new Data Factory Data Flow! Throughout, we’ll discuss best practices for different Azure centric data migration strategies and explore the benefits of adopting an ELT approach.

Posted in Meetings | Leave a comment

February 2019 – Meeting

Speaker – Andrew J. Kelly (view bio)

Session – Getting your Daily Debrief

We will walk thru the code and process to automate the collection of several key aspects of your SQL Server instance that you should be aware of each day. This will include parsing the SQL Server Error logs, extracting key DDL / Audit events and finding the top offending SQL statements. The automation will include scheduled jobs that use standard TSQL, Extended events and PowerShell to gather and extract the necessary information so they can be loaded into tables for easy reporting.

Register for this meeting

Posted in Meetings | Leave a comment