Salt Lake City SQL Server User Group

Welcome to the Salt Lake City Chapter

EventDisplay

Next Meeting: Wed, Mar 06 2019

March SLC SQL Meeting - Lightning Talks

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Utah-SQL-Server-Group/events/brwrklyzfbpb/

March SLC SQL Meeting - IMED DOTY AUD WEST
Lightning Talks! There will be multiple presentations that are only 10 minutes each.

Wesley Warren - A DBA's Door to Powershell
Garrett Brimhall - Anatomy of Select
Jenny Adams - Short Circuit Bad User Queries
Steve Seeley - Clustered, non-clustered and covering indexes oh my!

When

iCal
UTC : Wed, Mar 06 2019 22:00 - 00:00
Event Time : Wed, Mar 06 2019 15:00 - 17:00 (UTC-07:00) Mountain Time (US & Canada)
Your Local Time: Wed, Mar 06 2019 22:00 - 00:00

Where

Doty Family Education Center
Murray, Utah

Featured Presentation

A DBA's Door to Powershell

Speaker: Wesley Warren, Director of Data Engineering Progressive Leasing

Summary: Here we will take a quick look at how you can grasp the powerful handle of PowerShell; giving you the tools to push through daunting tasks like creating a register of all your databases. Topics: Powershell, SQL, SQLCMD, Active Directory

About Wesley: Wes is a data tinkerer that specializes in T-SQL, PowerShell, and C#. He enjoys adventure, exploration and puzzle solving in its many different forms. He has worked with database code for the last 12 years, the most recent of which have been as the Director of Data Engineering at Progressive Leasing.

Anatomy of Select

Speaker: Garrett Brimhall

Summary: TSQL is one of the most valuable tools any SQL Server professional can add to their tool-set. More aptly, TSQL is a whole chest of tools for the SQL Server professional. One of the most important tools in that TSQL chest is a good understanding of the SELECT statement. When was the last time you sat down to evaluate a SELECT statement? What actually goes into the processing of that teeny little word? There might be a fair bit more to this simple term than just fetching data from the database. This session covers the simplicity of the select. Then we take it a step further to dive into some of the complexities tied directly to this particular statement. This session will help the attendee better understand the Select statement. With a more solid understanding of this statement, the attendee can return and implement some of this new knowledge to help improve processing and query response times in their own environments.

About Garrett: Garrett is a young computer enthusiast fascinated by coding and making things work. He enjoys figuring out how to solve complex problems and is very imaginative. He has been coding for just over 2 yrs and is looking forward to a great many more years doing it. Garrett is new to public speaking as it happens to be one of his bigger fears. He is full of fun and life and looks forward to opportunities to improve at speaking and coding.

Short Circuit Bad User Queries

Speaker: Jenny Adams, Data Engineer Progressive Leasing

Summary: How to prevent your users from writing bad queries. Tips for teaching the non-IT user how to query basic business data.

About Jenny: Jenny Adams: I have been passionately advocating for awesome database architecture for 17 years. I love the ugly beauty of data and uncovering the story it has to tell.

Clustered, non-clustered and covering indexes oh my!

Speaker: Steve Seeley, Senior Data Architect Health Catalyst

Summary: So you have a brand new table with lots of data and when you do a query it takes forever to return. So you add an index to improve performance and it still takes forever. Huh? Let's talk about what an index really is, the different kinds of indexes, and we will finish with a scenario where even though you have the perfect index, it is still not used.

About Steve: My database experience began almost 25 years ago while working in a small accounting department. I started working with MSSQL 6.0 and have used every version since. I am a former Microsoft Certified Trainer and am now leading a slower life as a programmer specializing in data warehouse design, ETL and BI development.

Announcements

PASSChapterLogo.jpg

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids