Wednesday, May 10, 2017 - On site
I am a Default Blame Assignee/Acceptor (DBA) with over 10 years' experience breaking and then subsequently fixing various database-based solutions. My hobbies include coming up with new ways to get my kids to listen to me, falling asleep before my bedtime, and convincing my coworkers our HelpDesk ticketing system is actually operational.
Index 360 - Looking at Indexes from Multiple Perspectives
If you have used a database, chances are almost certain you've utilized indexes as well. In this presentation, I will discuss why indexes are important to anyone that interacts with a database, covering what they are, how they are utilized, how best to take advantage of them, and even when they can be problematic. It is my intention that this presentation help anyone become more comfortable with indexes and understand what they can do for you and your role, be it a DBA, Developer, or BI Professional.
Wednesday, June 14, 2017 - On site
A functional programming and data science geek. Loves research, analysis of data, and developing algorithms to solve complex programming problems.
Intermediate R - Shiny, Working with SQL Server, and Docker
Intermediate to advanced R concepts. In this session, we'll look at connecting and working with SQL Server. This includes offloading data processing to Microsoft R Services. Along with that, we'll look at Shiny, and creating dashboard-like content in Shiny and how to deploy to a Shiny server. We'll use Docker for everything in this presentation, from the creation of the R/Shiny projects, to using SQL Server.