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
This Month’s Speaker :
Speaker: Joseph D’Antoni
Principal Consultant, Denny Cherry and Associate
Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry & Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. He holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.
Identifying and fixing problematic query plans got a lot easier in SQL Server 2016, with the introduction of the Query Store. SQL Server 2017 takes that power a few steps further. Have you ever:• Had a query suddenly slow down at 2 AM when you were on call? • Seen a query that received a giant memory grant that brought the rest of the work on your server to a screeching halt? • Had the optimizer choose the wrong type of join and send your query off to never finish? Don’t worry, you will still have your job, but the features introduced in SQL Server 2017 will make narrow your focus to the absolute worst queries in your environment. You will also get a sneak preview of what’s coming into future releases of SQL Server in terms of performance.
Map to Gordon Biersch
Register for this meeting
4561 Virginia Beach Blvd, Virginia Beach, VA 23462
This Month’s Speaker : David Stokes
David has been working as a SQL Server database administrator for the past 19 years. He has worked extensively with all versions of SQL Server from 2000 to 2016. He spent the first 14 years working as a Department of Defense contractor with Northrop Grumman and Lockheed Martin. He worked on various contracts for US Joint Forces Command and the Department of the Army. He is currently employed by Ferguson Enterprises (the nation’s largest supplier of plumbing and HVAC equipment) in Newport News. His primary focus has been on making the Relational engine “go faster” when the end users complain that “the database is slow.” David has been an active member of PASS since 2005 and help revive the Hampton Roads SQL Server Users Group (HRSSUG) as a member of the leadership team in 2014. He regularly attends SQL Saturdays and any other SQL Server training events whenever possible. In his off time David enjoys drawing, golf and reading science fiction.
A Brief Introduction to the PowerShell DBATools Module
SQL Server DBAs are busy! Whether you work as part of a team for a large organization or are the “lone DBA” in a SMB, time and money to train on new technologies is difficult, if not darn near impossible, to come by. As SQL Server DBAs, we’ve been hearing about the need to learn PowerShell for a number of years. It’s part of Microsoft’s Common Engineering Criteria (all server product functionality, even in the GUI, behind the scenes, must be able to be done using PowerShell.) Several prominent members of the SQL Server community have been evangelizing the product for years. We’ve all heard the reasons, but I never found that one compelling, “A Ha” reason to learn this new “scripting language” (Hint: it’s more than a scripting language!) …. until now!
A few years ago, a talented DBA (Crissy Lemaire, @cl) was assigned the task of migrating many SQL Servers supporting SharePoint. She knew there had to be a better way than just manually generating all the T-SQL scripts and so was the genesis of the PowerShell DBATools module. This open source module is being built by a dedicated group of PowerShell and SQL Server folks, specifically to make the job of SQL Server database administration easier.
This presentation is designed to give a brief overview of the tools and demonstrate several of the commands that changed this “GUI Guy” into a newbie, “wanna-be” PowerShell aficionado.
Speaker – Kenneth Jensen (view bio)
Session – Amazon Web Services (AWS), business and the data professional
In this session we will discuss why businesses of all sizes and verticals are moving to the cloud and what impact that business decision is having on all data professionals.
We will cover what services and solutions Amazon Web Services (AWS), the largest public cloud provider, has to offer so businesses and data professionals can remain competitive.
With a bias towards SQL Server, we will discuss; EC2, RDS, Glacier, S3, Glue, Redshift, Lamdba, Active Directory, alerting, data migration solutions and the AWS marketplace. We will also identify which third party SQL Server tools work with AWS.
By the end of the session you will understand the advantages the AWS cloud gives business and what tools are available for the data professional. You will be able to create your own free AWS account and start exploring AWS.
Register for this meeting