SQLSaturday #808 - Oregon 2018
Event Date: 11/03/2018 00:00:00
Event Location:
- Franz Hall
- University of Portland, 5000 North Willamette Blvd
- Portland, Oregon
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: SQL Server Take Over: Establishing a Baseline
Abstract: SQL Server Take Over: Establishing a Baseline
Performance assessment and tuning for the beginner DBA Have you ever inherited a group of servers with not a lot of documentation to accompany them? Do you have a lot of undocumented or new servers in your environment and you want to establish some baseline configuration setting prior to making changes? You need up to date information on the system very quickly. The server is running slowly… or is it? Slow compared to what? Before you being digging into performance issues, there are some baseline metrics you should have established. Only after the information has been gathered, can a plan of attack be developed to help resolve issues with performance. Attendees in this session will learn how to quickly gather information, review the results and get an action plan on the next step in performance tuning.
Speaker(s):
- Lowry Kozlowski
Track and Room: DBAdmin - 223
Title: How to Migrate your in house data to the cloud [VIDEO]
Abstract: Now that you have decided to migrate to the cloud you may be thinking all I have to do is back and restore my database then change some connection strings. While sure this will work in some cases you’ll soon find yourself banging your head against the wall wondering why your having performance issues or suddenly getting errors. Depending on the type of database and workload you are migrating there are certain steps that should be taken to ensure that your migration goes smoothly. In this session we will go over what those checklists should be and also cover common performance issues and techniques to rectify them during your migration.
Speaker(s):
- James Phillips
Track and Room: Cloud Data - 034
Title: The Big Picture: SQL Overview -Getting the Most of SQLSaturday
Abstract: Targeted to anyone new to SQL server technologies, this is a holistic overview of multiple core technologies, career paths and how to maximize your SQLSaturday experience. This presentation starts with a business approach to structured data for business to introduce relational database concepts. We review key differences between operational and analytical databases for decision support and how the extract, transform and load (ETL) process is used to change operational into analytical data. We finish with a short intro to data analysis and Power BI to generate new insights from data. We will highlight complementary sessions that relate to the different topics and also briefly review necessary skills and career paths for those considering this exciting field. Audience QA encouraged. Materials include slides and a short introductory video.
Speaker(s):
- Michael Curry
Track and Room: Essentials - 006
Title: Power BI data preparation with Dataflows [VIDEO]
Abstract: Data preparation is often the most labour-intensive component of an analytics project and getting this right is vital if the results are to be accurate. While the growth of self-service BI has empowered users to answer important questions, ensuring well managed data is available to all employees remains one of businesses biggest challenges. Dataflows is an extension of the Power BI ecosystem, providing a low code approach using Power Query to create curated datasets that can be easily consumed by business analysts, thereby improving the speed at which business value can be delivered. Dataflows provides a single-version-of-the-truth which was traditionally attained by building a data warehouse. You will learn -How Dataflows can be used to create rich, vetted datasets -How Dataflows can be created with the click of a button, ingesting data from many well knows SAAS solution such as Dynamics and Salesforce -How to manage Dataflows using advanced data preparation tools such as Databricks
Speaker(s):
- Michael Johnson
Track and Room: BI Arch/Admin - 206
Title: Tame Your Unruly Data With Constraints
Abstract: Bad data comes in many forms: duplicate rows, wrong data type, invalid values, and orphaned or missing foreign keys. Time is wasted cleansing, reviewing and correcting data, not to mention the potential hazards bad data can cause. This introductory presentation will explain the data types and constraints available in SQL Server, and how they can replace or augment business rules that would otherwise be written in application or procedure code. Performance benefits provided by constraints will be demonstrated. We will examine the various system views and procedures that describe constraints and how to use them to document your databases. You will be able to apply this knowledge to your database environments and see significant improvements in data quality, performance, and reliability.
Speaker(s):
- Rob Volk
Track and Room: Essentials - 006
Title: Performance Tuning for Salary Negotiations [VIDEO]
Abstract: Because little in business or life gets done without negotiation, this session has the potential to deliver significant upside in your professional and personal outcomes. In this session, you will be introduced to basic negotiation concepts and tactics, followed by a focus on important aspects of the negotiation process—obstacles to effective communication at the bargaining table, the maximization of multiple interests, and preparation tactics for your next negotiation. We will put it all together by examining a special type of negotiation: YOUR SALARY!
Participants will:
• Learn strategies for negotiation analysis and preparation • Understand different strategic choices and interpersonal skills necessary for success • Know what information is needed to negotiate effective outcomes • Experiment with new techniques and test their effectiveness in a safe environment
Speaker(s):
- Je’Anna Lanza-Abbott
Track and Room: Prof Dev - 217
Title: Introduction to Managed Instances [Video]
Abstract: What are Azure SQL Database Managed Instances? The range of options for storing data in Microsoft Azure keeps growing, the most notable recent addition is the Managed Instance. But what is it, and why is it there? Join John as he walks through what they are and how you might start using them.
Managed Instances add a new option for running workloads in the cloud. Allowing near parity with a traditional on-premises SQL Server. Including SQL Agent, Cross Database Queries, Service Broker, CDC, and many more. Overcoming many of the challenges to using Azure SQL Databases.
But, what is the reality, how do we make use of it, and are there any gotcha’s that we need to be aware of? This is what we will cover, going beyond the hype and looking at how we can make use of this new technology, working through a full migration including workload analysis, selecting the appropriate migration pathway and then putting it in place.
Speaker(s):
- John Martin
Track and Room: Cloud Data - 034
Title: 3D printing at HP and spreadsheets; how HP broke free of data bottlenecks.
Abstract: Join Jeff and guest speaker from HP to hear their story. In today’s complex world, we know inherently simple gets it done now. And “now” is the typical deadline of our supervisors. The difficulty is they demand tough requirements and often make changes that take extra time and staff. In HP’s world of 3D printing, they discovered a new simplicity in consuming data daily, pivoting quickly in new directions, and keeping their users in control within IT boundaries. Learn about HP 3D printing ingenuity in your own back yard and how Interject provided a spreadsheet platform for them to run even faster and collaborate on data in record time. What took months or weeks, now takes days or hours, and users need minimal training.
Be the first 20 to attend and pick a cold red bull or hot latte/mocha that will be waiting. Even better, at the end of the session we will be giving another $300 lightsaber like last year that is too cool for the kids. Space is limited so arrive early.
Speaker(s):
- Jeff Honsowetz
Track and Room: Essentials - 006
Title: Uhms and Bunny Hands: Tips for Improving Your Presentation Skills
Abstract: Are you considering becoming a speaker, but feel nervous about getting on stage for the first time? Have you already presented a few sessions and want advice on how to improve? Do you learn more from seeing examples of what you should NOT do during a presentation instead of reading a list of bullet points on how to become a better speaker?
Don’t worry! I have made plenty of presentation mistakes over the years so you won’t have to :)
In this session, we will go through common presentation mistakes and how you can avoid them, as well as how you can prepare for those dreaded worst-case scenarios. Don’t let those “uhms” and “uhhs” dominate your presentation, help the audience focus on the key message you’re delivering instead of making them read a wall of text in your slides, recover gracefully from any demo failures, and stop distracting your attendees with floppy bunny hands.
All it takes is a little preparation and practice. You can do this!
Speaker(s):
- Cathrine Wilhelmsen
Track and Room: Prof Dev - 128
Title: Code Like a Snake Charmer - Intro to Python! [VIDEO]
Abstract: Python is the one of the most popular programming languages used today and one of the most useful tools in the data scientist’s tool belt especially for machine learning. Python is integrated into the Microsoft stack in tools like Azure ML and now SQL Server 2017.
The session will be an introduction to the Python language including:
1.) Installing and Configuring Python 2.) Access and Manipulate Data 3.) Install and Manage Packages 4.) Create and Use Objects/Variables 5.) Control Flows and Functions 6.) Managing the Python installation in MSSQL
Attend this session to learn how to use Python to take your data analytics to the next level. We will use Python, SQL Server and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learns some basic data science fundamentals.
No prior statistics knowledge needed.
Speaker(s):
- Jamey Johnston
Track and Room: Data Science - 223
Title: Select Stars: A SQL DBA’s Introduction to Azure Cosmos DB
Abstract: Azure Cosmos DB has quickly become a buzzword in database circles over the past year, but what exactly is it, and why does it matter? This session will cover the basics of Azure Cosmos DB, how it works, and what it can do for your organization. You will learn how it differs from SQL Server and Azure SQL Database, what its strengths are, and how to leverage them. We will also discuss Azure Cosmos DB’s partitioning, distribution, and consistency methods to gain an understanding of how they contribute to its unprecedented scalability. Finally, we will demonstrate how to provision, connect to, and query Azure Cosmos DB. If you’re wondering what Azure Cosmos DB is and why you should care, attend this session and learn why Azure Cosmos DB is an out-of-this-world tool you’ll want in your data toolbox!
Speaker(s):
- Bob Pusateri
Track and Room: Cloud Data - 034
Title: Introduction to SQL Server Reporting Services [VIDEO]
Abstract: This session will cover the basics of developing, publishing and using SQL Server Reporting Services. You will learn all the steps needed to get started from connecting to the data source, creating data sets through putting the data on the page and publishing the report to the report server. See how easy SSRS is to use and how powerful it can be. The demo will be using SSRS 2016 but the concepts covered are applicable to any version of SQL Server. The session will also include: A tour of a wide variety of report examples including interactive graphical dashboards that you can do in SSRS, even in older versions. A comprehensive discussion of design elements to include and avoid when creating reports. Report printing and export considerations for optimal output depending on rendering format. You will leave this session able to return to the office and present meaningful data to your end users with minimal time and effort with easy to use and powerful BI tool that you already own
Speaker(s):
- Ted Stathakis
Track and Room: BI Design - 231
Title: The SQL Server Transaction Log for Developers
Abstract: SQL Server tracks all changes to a database’s data and schema in the transaction log. This makes it the most important file in any database. Understanding transaction log architecture and behavior will help you develop code that will maximize performance and minimize resource consumption. Join me to learn about transaction log architecture, batching transactions, rollback activity, and the effect these things can have on performance.
Speaker(s):
- Frank Gill
Track and Room: DBDev - 015
Title: Everything You Need to Know About SQL Server Indexes
Abstract: You probably already know that indexes make your queries go faster. But do you know all the different types of indexes in SQL Server and when to use them? Also with each new release of SQL Server, there are new features that can impact how indexes function and are maintained. Finally, knowing how the different types of indexes work can help you make better indexing choices when tuning your queries. This presentation will review current SQL Server index structures and options, discuss how they work, when they should be used and how to maintain them. Examples of all the index types such as hash, in-memory, columnstore, filtered, etc… will be shown. This presentation is a must see for DBAs, Developers, Application Architects and anyone else who is interesting in maintaining high performance SQL Server applications.
Speaker(s):
- Janis Griffin
Track and Room: DBAdmin - 034
Title: Intermediate Security Topics in SQL Server
Abstract: How many times have you been told by your customers:
- “just grant db_owner/sysadmin to my application and it will work”
- “I need to be able to issue raw DML against these tables”
- “my login doesn’t work the way it should!”
- “this query that is accessing objects in multiple databases isn’t working”
In this session, we’ll talk about ways to service requests like these without having to give away the world. We’ll start with authentication and authorization, for context.
We will then go into different methods to augment the “normal” means of obtaining permissions that will allow you to help your customers while at the same time not needing to be overly permissive.
In the course of this presentation, you’ll learn about:
* Module signing
* Permission chaining
* Impersonation
and more!
Speaker(s):
- Ben Thul
Track and Room: DBAdmin - 214
Title: Predictive Analytics with R in Power BI [VIDEO]
Abstract: Power BI reports are typically used for descriptive analysis: a historical look of what has happened. But what if your report could visualize what is likely to happen and recommend what you can do about it now?
This session will introduce how to start the shift from descriptive to predictive analysis and how you can begin to leverage the power of machine learning in your business intelligence solutions. No previous knowledge of R or predictive modeling is required!
We will cover the basics and best practices of predictive modeling and then these concepts will be applied to create three different predictive models in R. Then we will cover three ways to integrate the predictive power of these models into a Power BI report.
Speaker(s):
- Joseph Yeates
Track and Room: Data Science - 223
Title: Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2
Abstract: In this session, we will start with an overview of Azure Data Factory V2 concepts, then show you how you can use metadata to quickly build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution. Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.
Speaker(s):
- Jason Horner
Track and Room: BI Arch/Admin - 206
Title: High Availability/Disaster Recovery 101
Abstract: How do you design a SQL Server 2017 infrastructure in order to meet specific Recovery Time Objective (RTO) and Recovery Point Objective (RPO) service levels? There are many aspects to consider, from technology choices and licensing, to policies and procedures. This session outlines and compares the various HA/DR technologies available in SQL Server 2017, showing how you can combine them to design and build a solution to help meet your HA/DR goals. This session also teaches you how to formulate policies that enable effective use of technology in your organization.
Speaker(s):
- Glenn Berry
Track and Room: DBAdmin - 214
Title: What is DevOps? - and why should I care?
Abstract: If you like an interactive and lively sessions them this is the place for you. We’ll look at the background of this term – and see how it has transformed to bring focus to the data professional. We’ll take a peak at what it means for the technology professional as well as what it means for the business professional - and we’ll see Visual Studio Team Services (VSTS) and the cloud in action. We’ll look at the different kinds of disciplines that lead to a well-rounded DevOps set up. We’ll have a run through some of the motivations for developing a DevOps mindset and we’ll also hear about some of the arguments for non-adoption. We’ll look at some of the other IT methodologies that we’ve seen emerge over the years and examine exactly what sets DevOps apart from these. Regardless of if you’re never heard this term before or you have strong feeling about the subject – either way – you’ll leave the room with a new perspective and quite likely you’ll have contributed to your fellow delegates kn
Speaker(s):
- Martin Catherall
Track and Room: DBDev - 015
Title: Successfully Virtualizing and Maintaining SQL Server on VMware vSphere [VIDEO]
Abstract: Microsoft SQL server is the most virtualized enterprise mission critical application today. In recent years it has become a mainstream effort among VMware customers to virtualize critical databases to allow better agility and scale while increasing availability and operational efficiency. In this session we will focus on the configuration of vSphere and SQL server for maximizing the benefits of virtualizing SQL server. The session is aimed at providing VMware customers and partners guidance on how to achieve best performance and efficiency with the latest versions of Microsoft SQL server and VMware vSphere.
Speaker(s):
- Victor Isakov
Track and Room: DBAdmin - 214
Title: T-SQL Habits and Practices That Can Kill Performance
Abstract: All too often we are on a project or given a task where the time or financial constraints require us to develop T-SQL “quick-and-dirty”. Or maybe we have been tasked with quickly improving the performance of some existing T-SQL. These situations often lead to code that later needs to be tuned for better performance. Wouldn’t it be nice if we could satisfy those tight time constraints while also avoiding many of the pitfalls that later plague performance? In this session we will see ten common T-SQL writing habits that contribute to poor performance. We’ll see WHY each of these patterns can have such negative impact on performance, including examples, and we’ll see one or more alternatives for each that don’t have the same negative impact. Armed with this knowledge, you will definitely impress your boss with your ability to create fast T-SQL within tight time constraints, and also quickly fix existing T-SQL code. Enjoy the merit raise you’ll get due to your new tuning talents.
Speaker(s):
- Vern Rabe
Track and Room: DBDev - 026
Title: Building Your Own Power BI Image Generating Measures
Abstract: With the August 2018 version of Power BI, you can now write DAX measures that generate dynamic chart images using the SVG (Scalable Vector Graphics) standard. This means the long sought-after chart types of “small multiples” and “spark lines” are suddenly available, letting report authors create a sort of pivot table, not of numbers, but of dozens of tiny dynamic charts. However, this only works if you know how to leverage DAX to write dynamic SVG code, a rather oblique use of the language. In this session we’ll be showing users how to do exactly that live on stage. We’ll create several chart measures, from KPI indicators, to spark lines, to the game-changing bullet charts. Folks will walk away with some basic patterns they can use to create their own chart measures at home in no time at all.
Speaker(s):
- Brian Grant
Track and Room: BI Design - 206
Title: Execution plans … where do I start? [VIDEO]
Abstract: SQL (the language) is not a third generation language, where the developer tells the computer every step it needs to take. It is a declarative language that specifies the required results. SQL Server itself will figure out what steps it takes to get to those results. Most of the time, that works very well.
But sometimes it doesn’t. Sometimes a query takes too much time. You need to find out why, so you can fix it. That’s where the execution plan comes in. In the execution plan, SQL Server exposes exactly which steps it took for your query, so you can see why it’s slow.
However, execution plans can be daunting to the uninitiated. Especially for complex queries. Where do you even start?
In this session you will learn how to obtain execution plans. and how to start reading and understanding them.
Speaker(s):
- Hugo Kornelis
Track and Room: Essentials - 006
Title: Relational Data Architecture 101
Abstract: This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!
You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!
This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.
Speaker(s):
- Pat Phelan
Track and Room: DBAdmin - 128
Title: DBA vNext
Abstract: Not long ago, being a Microsoft DBA meant be specialized in Microsoft SQL Server and all the whistles and bells shipped together in the same box. That was the on-prem age.
Now in the cloud computing age, all cloud providers support multiple database engines in order to welcome all applications to their infrastructure. SQL Server is not always the way to go for an application.
In this session full of demos, we will discuss what it takes to be an all-rounded Azure cloud DBA, best applicable scenarios, price budgeting and tuning.
Speaker(s):
- Armando Lacerda
Track and Room: DBAdmin - 026
Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming
Abstract: This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker(s):
- Diane Schuster
Track and Room: BI Arch/Admin - 206
Title: Be Friendly to SQL Server with TSQL Best Practices [VIDEO]
Abstract: TSQL is a necessity when interacting with SQL Server so knowing can be half the battle. Performance is always good as the database starts to grow, but building in resilience when you begin is a greater advantage than refactoring. I will go over 5 key things to know when you write TSQL, use DataTypes and/or variables in comparisons and you will also learn about the procedure cache and how to avoid pitfalls there. This is a beginners session but the concepts in this session are a great foundation to begin with. If you are looking for a solid foundation to build on and need the basics to start, this session is definitely for you.
Speaker(s):
- Ben Miller
Track and Room: DBDev - 026
Title: Power BI Report Design for the aesthetically challenged
Abstract: Do you ever worry that your reports look they were born in the 90s, or designed by a grade 1? Do you feel overwhelmed when tasked with creating attractive reports which tell the customer a story?
Thankfully, a few simple design concepts can have big impacts on your reports. There are easy-to-learn techniques and patterns to create a pleasing look and feel to our reports, and some well defined principles to decide which visual is most appropriate in your situation.
Join me in this session to learn:
- How to choose the right visual to complement the data message.
- Best practices for visual formatting to tell a complete story.
- Colour theory - designing a colour palette, and ensuring accessibility.
- Layout techniques for clean and simple reports.
- Real estate management, or how to fit everything on a report without it looking cluttered and losing effectiveness.
Speaker(s):
- James McGillivray
Track and Room: BI Design - 231
Title: Test Driven Development in SQL Server – how to deploy code safer [VIDEO]
Abstract: Test Driven Development (TDD) is a design approach which has enabled application developers to write cleaner code. It is relevant for database development as it ensures that code produced using TDD and unit tests will be of higher quality which means interactions with data will be safer.
TDD is not a new method of unit testing, it is an essential design practice for improving the quality of your deployed code.
In this session it will be shown how we can use TDD to design and write better unit tests using open-source frameworks and industry standard tools. These tools can be run within SQL Server Management Studio which means DBAs can also take advantage of TDD and unit test, to ensure more reliable code is deployed to databases. TDD can result in code that can be deployed more reliably and faster when using DevOps processes such as Continuous Integration and Continuous Delivery.
A comprehensive DEMO will reveal how Test Driven Development can help you deploy database code safer.
Speaker(s):
- Hamish Watson
Track and Room: DBDev - 015
Title: Data Testing Integrity – BI Edition
Abstract: Unit Testing and Test-Driven Development are common practices in application development. In SQL development we’ve even got tSQLT! In the realm of BI with desperate systems, integration layers, data warehouses and even cubes we need a better approach.
In this session, we’ll discuss different problem scenarios and practical solutions. We’ll identify the need to look at the data from the business perspective and define specific integrity checks to ensure our data is accurate. Then the fun part! Using the Microsoft BI tool-set, we will walk-through a working solution demonstrating a way to efficiently centralize this process.
At the end of the session, we’ll all still agree that we can’t use a unit test or record counts to ensure that data is accurate. You will have a simple solution that you can start with to work in your environment and look at data testing integrity differently.
Speaker(s):
- Rob Long
Track and Room: BI Design - 231
Title: 3 tips for getting executive buy-in for DevOps
Abstract: DevOps practices are a powerful tools to build productive, engaged teams who constantly learn and regularly deliver value to their customers. High DevOps performers report greater workplace satisfaction than their peers. But implementing DevOps isn’t a matter of being great at writing code: to become a high DevOps performer, you need the powerful catalyst of executive support. In this talk, we will discuss the value of DevOps from the perspectives of CEOs, CIOs/CTOs, and Managers. We will explore how the role of CIOs and CTOs are undergoing a major transformation, and how DevOps aligns with that transformation. You will leave the session with a fresh take on how to discuss DevOps with company leaders, and an understanding of how to explain the value of DevOps to people in these roles.
Speaker(s):
- Kendra Little
Track and Room: DevOps - 231
Title: Detecting and Capturing Change for Data Warehousing
Abstract: There are many ways of detecting and capturing changes to the data in your business system in order to populate your data warehouse. In this session we will compare and contrast several methods for loading slowly-changing dimensions in your ETL solutions, including SSIS design patterns, T-SQL code, change data capture (CDC) and temporal tables.
Attendees will gain a full understanding of the pros and cons of each of these solutions and become confident in choosing and implementing them in their own ETL solutions.
Speaker(s):
- Chris Hyde
Track and Room: BI Design - 231
Title: Data Modeling and Prototyping in Power BI Desktop [VIDEO]
Abstract: Power BI Desktop is often shown as a self-service reporting and analytics tool, but it can also be used earlier in the development cycle for prototyping and data modeling and can do it quicker and easier than other tools made for this purpose. In this session we will go through multiple examples showing how Power BI Desktop is the perfect tool to quickly model data from multiple data sources (including web sites, databases, cubes, online services and even flat files) perform quick actions to cleanse and connect these various sources to each other using M and DAX functions built-in to Power BI Desktop. Once this model has been built it can be used to create some quick reports to show how this will be used to help get a project approved/funded. Best of all using Power BI Desktop to do all of this is completely free to use, no licensing or Power BI login required!
Speaker(s):
- Steve Wake
Track and Room: BI Design - 231
Title: SQLOpsStudio Vs SSMS - There can be only one
Abstract: SQLOpsStudio is the new kid in town for the data professional. Is it a replacement for good old SSMS? In this session we will take you on a journey of comparing SSMS and SQLOpsStudio so that you can understand the ins and outs of both these tools, making it easier to know what each brings to the table. In this demo heavy session we not only hear about the differences but we match them up against each other to better learn what each can do.
Speaker(s):
- Warwick Rudd
Track and Room: DBAdmin - 214
Title: Indexing for Beginners [VIDEO]
Abstract: To a beginner, indexes may seem like magic. The right index can drastically reduce query time. But, how do you know which indexes are the right ones? SQL Server will suggest helpful indexes in the graphical execution plan and with the Database Engine Tuning Advisor, but follow that advice with caution. This session will explain how indexes work and how to tune indexes so that your application has the best performance.
Speaker(s):
- Kathi Kellenberger
Track and Room: Essentials - 006
Title: Don’t Use Cursors or Why You Maybe Should Use a Cursor After All
Abstract: You might have heard “don’t use cursors, they are slow!”. In this presentation, you will learn what actually means: you should normally write set-based statements instead and I will explain why they generally are faster than writing your own loops. But I will also look at situations where using a loop for one reason or another is preferrable, and you will learn that the best way to run a loop in most cases is exactly a cursor, provided that you implement it properly. The presenation also gives some tips how you can troubleshoot performance problems with loops.
Speaker(s):
- Erland Sommarskog
Track and Room: DBDev - 026
Title: Educating yourself will make a SQL career more fulfilling
Abstract: Do you want to turn your SQL knowledge into a possible career? This session will show you what options are available to learn about MS SQL Server and make you more knowledgeable about the product This session will show the many different options available to learn MS SQL Server ranging from free events thru to international conferences It will also show how to make any conference more affordable and justify the benefits
Speaker(s):
- Chris Wood
Track and Room: Prof Dev - 217
Title: Administrating SQL Server with PowerShell dbatools
Abstract: Let me show you how easy it is to use PowerShell to accomplish many everyday tasks straight from the command line with the community developed module dbatools.
Afraid of PowerShell? Worried its too complicated? Don’t want to go through the learning curve?
Let me show you with plenty of demos how easy and straight forward it can be and I will save you time starting Monday
Want to restore an entire servers databases to the latest available point in time of the backups in just one line? Be useful to know the Last DBCC Check for your entire estate in only one line of code? Need to test your restores but its complicated? and many many more All this in a fast paced, fun session
Speaker(s):
- Rob Sewell
Track and Room: DBAdmin - 034
Title: Locks, Blocks, and Deadlocks, Oh My!
Abstract: “I’ve got a locking problem”, “I need to get rid of blocking,” and “deadlocks are normal behavior” are all things heard way too many times.
In this session targeted at the accidental or new DBA, we will walk through each of these items, what they are, what their causes are, which of them are normal behavior and which are not, and some common causes of deadlocks and excessive blocking.
Speaker(s):
- Randy Knight
Track and Room: DBAdmin - 214
Title: SSIS Deployment Smackdown! Package vs. Project!
Abstract: SSIS Package deployment was the first, but is it the best? Project deployment promised so much, but did it deliver? Find out which method is best for you when you see two expert practitioners go head-to-head, presenting their best-case solution for their method, and then take on the weaknesses of their opposition! Which will emerge as the supreme deployment method? BE THERE!!!
Speaker(s):
- Peter Kral
Track and Room: BI Arch/Admin - 206
Title: Azure Intelligent Services
Abstract: Discover the ways Azure transforms AI and Predictive Analytics making it easier and more accessible through services like Azure Machine Learning and pre-built Cognitive Services, while also supporting custom development and deep-learning.
Speaker(s):
- Amie Mason
Track and Room: Data Science - 026
Title: Lightning Talks: Session Five
Abstract: TBD
Speaker(s):
- Misc Speakers
Track and Room: - 120
Title: Containerized databases: SQL Server and DevOps
Abstract: What are containers? When would you use them? Are they supported for production? Do they run on Windows? Do they run on Linux? Can they persist data?
These are just a few of the questions we will answer in this session. Containers are all the rage today - don’t get left behind!
Speaker(s):
- Ned Otter
Track and Room: DevOps - 206
Title: Lightning Talks: Session One
Abstract: Best in Class: A DAX Pattern for Identifying Top Performers | Creating a Time Inspector Measure in Power BI for Easier Time Intelligence | Data Science in 15 Minutes! Predictive Analytics with R in Power BI
Speaker(s):
- Misc Speakers
Track and Room: - 120
Title: Running SQL Server on Amazon Web Services
Abstract: You can run SQL Server on Amazon Web Services (AWS). In this session, Richard will review how you can run SQL Server, including both EC2 and RDS deployments. He will explore how Amazon RDS helps you cover the requirements for high availability, backup, and encryption, freeing you to focus on improving your schemas and application performance.
Speaker(s):
- Richard Waymire
Track and Room: Cloud Data - 015
Title: Lightning Talks: Session Three
Abstract: Comment Your Code! ProperCase - My Favorite UDF PLE, it’s not what you think it is!
Speaker(s):
- Misc Speakers
Track and Room: - 120
Title: Game, Set, Match: Set Theory for Beginners [VIDEO]
Abstract: Set Theory is the basis for designing relational databases and working with them. Understanding it can help you to design better databases and write better performing code. In this session, Jared Karney will give you the basics of Set Theory that you can take with you to design a relational database and write SQL that is scalable and performant.
Speaker(s):
- Jared Karney
Track and Room: DBDev - 128
Title: Lightning Talks: Session Four
Abstract: Using Text Manipulation For Great Good The top 3 Availability Groups pitfalls and how to avoid them The top five things DBAs need to know about DevOps
Speaker(s):
- Misc Speakers
Track and Room: - 120
Title: Data Types Do Matter [VIDEO]
Abstract: They’re just numbers, right? A date’s a date. It’s just string data, who cares? I can’t tell you how many times I’ve heard these phrases. This session will help you understand why choosing the correct data type for your data is so important. It affects data quality, storage and performance. It can even produce incorrect query results.
Speaker(s):
- Angela Henry
Track and Room: DBDev - 015
Title: What is Temporal Tables
Abstract: In this session we will take an introduction look at Temporal Tables in SQL Server. How do we query a temporal table and how do we manage a large temporal table with Stretch Database to Azure. We will look at when to use Temporal tables and why would you use it.
Speaker(s):
- Jean-Pierre Voogt
Track and Room: DBDev - 015
Title: Real-time monitoring and detailed workload analysis with Spotligh
Abstract: In this overview you’ll see how Spotlight on SQL Server gives you real-time performance alerts and brings together all of your critical SQL Server metrics into a single dashboard-style screen, color-coded for problem severity and clickable for rapid diagnostics. You’ll also see how Spotlight’s Wait Event and Workload Analysis screens enable a deep dive into which queries caused exactly how much of each type of workload at particular times.
Speaker(s):
- Trent Mera
Track and Room: DBAdmin - 217
Title: PowerShell for the DBA
Abstract: PowerShell is a tool used by many people in DevOps and Infrastructure. Should the DBA get on board with using PowerShell? The answer is yes - as a DBA, PowerShell can have a significant impact on tasks that would be long and tedious with just T-SQL alone. Today there are specific modules that can be incorporated into PowerShell to help in automating every-day DBA tasks. Beyond that, PowerShell can be used to do things like automate deployments and audit permissions.
In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.
Speaker(s):
- Amy Herold
Track and Room: DBAdmin - 214
Title: Establishing a SLA form
Abstract: Most rookie DBA’s do not establish a Service Level Agreements (SLA) with the management and if they do they sometimes just come up with some random numbers for availability. Then when at some point later something goes wrong everybody wonders why it takes so long to bring everything back online. This Session will teach you how to ask the right questions, analyze your databases and servers and generate from the gathered data a realistic SLA and communicate it to the rest of the comapany
Speaker(s):
- Thomas Grohser
Track and Room: Essentials - 006
Title: Lightning Talks: Session Two
Abstract: What’s it like to have a career in consulting? Why Solidity is Solid - Basic of Ethereum, Smart Contracts, and Blockchain. Managing Execution Plans [VIDEO]
Speaker(s):
- Misc Speakers
Track and Room: - 120
Title: Going Beyond Monitoring With SentryOne
Abstract: Hopefully you are monitoring your SQL Servers using DIY scripts or a 3rd party tool. Active monitoring is invaluable to enable the operational DBA to identify and address issues quickly. But did you know that SentryOne offers capabilities beyond just monitoring? Join me and I’ll show you how SentryOne provides environment wide visibility and aids in managing cross-server activities. I’ll showcase how alerting can be tuned to be effective and not noise. And you’ll discover how SentryOne can give you both operational and business value to address your application challenges.
Speaker(s):
- Andy Yun
Track and Room: DBAdmin - 034
Title: Encrypting Data within Sql Server
Abstract: Data breaches abound! SQL Server has several options to encrypt the data, Transparent Data Encryption, Cell Level Encryption and SQL Server 2016 Always Encrypted. Let’s review each option to hide the encrypt the data and learn about my experiences implementing Always Encrypted.
Speaker(s):
- Thomas Norman
Track and Room: DBDev - 026
Title: Maximum performance for SQL with Dell EMC
Abstract: Get maximum performance for SQL Server with Dell EMC’s modern infrastructure using the latest technology #GetModern
Speaker(s):
- Craig Allen
Track and Room: DBAdmin - 120
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Frank Gill
Twitter: - skreebydba
LinkedIn: Frank Gill
Contact: http://skreebydba.com/
Frank Gill is a Senior Data Engineer at Concurrency With 21 years of IT experience, the first 8 as a mainframe programmer, he has developed a love of all things internal. Over the past several years, he has worked extensively with SQL Server solution in Azure, including Managed Instance. When not administering databases or geeking out on internals, Frank volunteers at the Art Institute of Chicago and reads voraciously.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Angela Henry
Twitter: - SQLSwimmer
LinkedIn: Angela Henry
Contact: http://SQLSwimmer.com
Angela is a Solution Architect, living in High Point, NC and loves what she does. She’s worked with all versions of SQL Server worn all the hats that come with dealing with SQL Server throughout the years: developer, administrator, data architect and BI developer. She has her MSCE in Data and Analytics (f.k.a., Business Intelligence), is a Data Platform MVP, and a Microsoft Certified Trainer (MCT). She is the former chapter leader for the PASS Triad SQL User Group in Greensboro, NC. In her spare time you can probably find her in or at the pool, she’s an avid US Masters Swimmer, Coach and Instructor.
Thomas Grohser
LinkedIn: Thomas Grohser
Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.
Ben Miller
Twitter: - DBAduck
LinkedIn: Ben Miller
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.
Glenn Berry
Twitter: - GlennAlanBerry
LinkedIn: Glenn Berry
Contact: https://glennsqlperformance.com/
Glenn works as a Principal Consultant for Dr. DMV, LLC in Elizabeth, CO. He was a Data Platform MVP from 2007-2017, and he has a whole collection of Microsoft certifications, including MCITP, MCDBA, MCSE, MCSD, MCAD, and MCTS, which proves that he likes to take tests. His expertise includes DMVs, high availability, hardware selection, performance tuning, and Azure SQL Database. He is also an Adjunct Faculty member at University College - University of Denver, where has been teaching since 2000. He has completed the Master Teacher Program at Denver University - University College. He is heavily involved in the SQL Server community, and is a frequent speaker at user groups, SQLSaturdays, and the PASS Community Summit.
Rob Sewell
Twitter: - sqldbawithbeard
LinkedIn: Rob Sewell
Contact: http://sqldbawithabeard.com
Rob was once a production SQL Server DBA, but is now generally found automating the Data Platform and providing training for clients. He has a passion for PowerShell, Data, and DevOps. He is an MVP, an officer for the DevOps PowerShell VG, and has spoken and volunteered at many PowerShell and Data events. He is a member of the committee that organises Data In Devon and the European PowerShell Conference. He is a proud supporter of the Data and PowerShell communities.
He relishes sharing and learning and can be found doing both via Twitter @sqldbawithbeard and his blog sqldbawithabeard.com. He spends most of his time looking at a screen and loves to solve problems.
Jeff Honsowetz
Twitter: - https://twitter.com/simplegetsdone
LinkedIn: Jeff Honsowetz
Contact: http://www.gointerject.com/never-stand-still-blog/
Jeff is a rogue CPA/accountant disguised as a SQL guy who cares about code literacy for kids, simplifying work, and pondering the next era of spreadsheets. Jeff leads a 20+ person team in Vancouver WA that has built a framework to unlock Excel as a presentation tier for middle tier services. They enable development partners to remove the frustration that typically is found where software ends and spreadsheets begin. Jeff is a committee member for Oreg
Richard Waymire
Twitter: - rwaymi
LinkedIn: Richard Waymire
Richard Waymire is a technical expert on Microsoft SQL Server. He has been involved in numerous Microsoft early adaptor projects and new technologies. Richard has broad ranging experience from the relational data modeling phase through the production implementation of database solutions built with SQL Server, including data loading, monitoring, and performance tuning. Richard has worked on SQL Server for more than 26 years, including 12 years as part of the SQL Server team at Microsoft. In his role with Amazon Web Services, Richard is the Americas specialist for SQL Server, as well as for Amazon Aurora.
Brian Grant
Twitter: - @csgpro
LinkedIn: Brian Grant
Contact: https://www.csgpro.com/blog
An Analytics Consultant with CSG Pro, Brian has several years of experience training people in DAX, M, and data visualization. He’s happiest when solving complex DAX problems and breaking down difficult concepts for people in ways that are easy to understand.
James Phillips
Twitter: - @JPhillips_Data
James Phillips is the VP Technology for Mizuho Americas and has over 20 years of experience with SQL technologies with the last 10 years focused on Business Intelligence. He is a past Leader of the Northern NJ SQL Server User group and current Leader for SQLSaturday NYC. He has worked in a wide array of industries including finance and insurance. Regularly speaks about Database Performance Tuning, SSIS and Power BI topics. Also an avid softball player and father to 5 beautiful children.
Erland Sommarskog
Contact: http://www.sommarskog.se
Erland Sommarskog is an independent consultant based in Stockholm, working with SQL Server since 1991. He was first awarded SQL Server MVP in 2001, and has been re-awarded every year since. His focus is on systems development with the SQL Server Database Engine and his passion is to help people to write better SQL Server applications.
Victor Isakov
Twitter: - @victorisakov
LinkedIn: Victor Isakov
Contact: http://www.victorisakov.com
Victor Isakov (MCA, MCM, MCSM, MCT, MVP) is a Database Architect and trainer who provides consulting and training services to various organizations in the public, private, and NGO sectors globally. He regularly speaks at international conferences such as Microsoft TechEd/Ignite, PASS Summit, IT/Dev Connections, and SQLSaturdays. Victor has written a number of books on SQL Server and has worked with Microsoft to develop the SQL Server exams and certification. In 2017 he authored “Exam Ref 70-764 Administering a SQL Database Infrastructure (1st Edition)”. He is one of only three non-Microsoft, Microsoft Certified Architects in the world.
Vern Rabe
Twitter: - @VernRabe
LinkedIn: Vern Rabe
Contact: http://www.rabedata.com
Vern Rabe is an independent SQL Server consultant and contract trainer in Portland, OR, and leader of the Oregon Data Community user group, formerly OregonSQL. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been passionate about databases since 1992 and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server knowledge gained from the mixture of academic and practical experiences acquired from his classroom instructing and varied consulting contracts. Vern regularly presents technical sessions at SQL Server user group meetings, SQLSaturdays, and PASS Summit.
Jamey Johnston
Twitter: - STATCowboy
LinkedIn: Jamey Johnston
Contact: http://STATCowboy.com
Jamey Johnston is a Senior Data Scientist/Engineer for a large independent OG company. For over 25 years, he has worked for Fortune 500 companies architecting successful platforms in the cloud, on the edge, and on-premises for BI reporting, statistical analysis, ML, and AI. Lately, he spends his time in Azure, Python, R, Power BI, MS SQL, and SAS JMP. He holds a BS in Spatial Analysis from LSU and a Masters of Science in Analytics from Texas AM. He is a professor at the Mays Business School at Texas AM in the MS Analytics program. He is active in his PASS Local Group in Houston, co-leader of the local Power BI users group and data analytics group. He regularly speaks and volunteers at PASS events. He is also a Microsoft Data Platform MVP.
John Martin
Twitter: - SQLDiplomat
LinkedIn: John Martin
Contact: https://www.mssqltips.com/sqlserverauthor/291/john-martin/
John Martin is a Data Platform Engineer working in the financial sector, as well as Vice President Marketing for the PASS organization and currently a Microsoft Data Platform MVP. Previously John has worked as a product manager for SentryOne and a Premier Field Engineer with Microsoft UK.
John has over a decade of experience working with SQL Server and the Microsoft Data Platform. Working as a DBA, developer and consultant for Microsoft, he has been lucky enough to see how best, and how not, to use SQL Server and the Data Platform effectively.
Trent Mera
Trent Mera has been a database performance Systems Consultant with Quest Software for 11 years. He specializes in showing customers how to identify and resolve performance bottlenecks in their SQL Server systems. His experience prior to Quest includes 7 years as a Database Developer and Administrator in the Real Estate, Finance and Defense Industries.
Rob Volk
Twitter: - sql_r
LinkedIn: Rob Volk
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
Armando Lacerda
Twitter: - arlacerda
LinkedIn: Armando Lacerda
Over 30 years in the computing field as a developer and system integrator; over 20 years working with SQL Server since version 6; cross platform experience with Oracle and IBM SQL/DS and DB2; Microsoft Certified Trainer for over 20 years.
Diane Schuster
LinkedIn: Diane Schuster
Diane has worked with COZYROC since 2012. She has attended numerous SQLSaturdays to shine the light on the time-saving and capability-extending components and tasks that COZYROC offers in it’s SSIS+ library. Without even having a background in databases or SQL Server, Diane successfully configures packages in live demonstrations that use COZYROC components and tasks. She believes that, if the toolkit is this easy to use for a novice, then just imagine what a SQL Server expert can do with it!
In Diane’s data networking days, Diane performed a variety of development-related and customer-facing roles for IBM, Lucent Technologies, North Carolina State University and Connectware.
Martin Catherall
Twitter: - MartyCatherall
LinkedIn: Martin Catherall
Contact: http://martincatherall.com
Martin is a data consultant in Melbourne, Australia, a Microsoft Data Platform MVP, and PASS Regional Mentor for the Asia Pacific (APAC) region. Martin founded the Christchurch, New Zealand PASS Local Group and lead the group for a number of years before relocating to Melbourne. He has been using SQL Server in various roles since 2000. In addition to anything data related, he enjoys playing the guitar and having fun with his family.
Chris Hyde
Twitter: - ChrisHyde325
LinkedIn: Chris Hyde
Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
Steve Wake
Twitter: - stevewake
LinkedIn: Steve Wake
Contact: http://blog.wakebi.com
Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.
Jean-Pierre Voogt
Twitter: - @CloudySQL
Jean-Pierre is an SQL Developer and Data Analysis Team Lead from South Africa. He is MCSA (Microsoft Certified Solutions Associate) and owner of a bachelor’ degree in Software Engineering with good experience with Database design, Data warehousing and development. He has a great passion for SQL server and he enjoys solving complex business problems.
Jean-Pierre speaks at the Johannesburg SQL User Group, trying to give back to the SQL community as much as possible. He loves to tinker with SQL Server and see how he can approach a problem with a different angle.
Rob Long
Twitter: - @robjlong
Rob Long is Chief Architect and Co-Founder of Talavant. Rob is passionate about developing solutions that improve the delivery of data warehousing and business intelligence solutions. He has a breadth of experience including development, network administration and database administration. For the last 8 years, Rob has focused his efforts on delivering solutions on the Microsoft BI stack. He is a proud father of four, a Certified Business Intelligence Professional, and enjoys spending time with family and keeping up with the ever changing data management industry.
Chris Wood
Twitter: - ChrisAVWood
He has been an MS SQL DBA since 1997 starting with 6.5. Worked with 7/2000/2005/2008/2008R2/2012/2014/2016 and 2019 during those 23 years. He has attended 14 Pass Summits, 3 SQLCruises and 2 SQLConnections conferences. He has been the Communications Director for EDMPASS chapter since its inception in 2008. Spoken at 6 SQLSaturdays including the keynote at SQLSaturday 710 Edmonton in 2018. Passionate about SQL and educating himself to know more about it. He has migrated systems while always attempting to take advantage of any new features from 7.0 all the way to 2014 and 2016 and now 2019 He has learned and implemented lots of best practices from SQL Server MVPs.
Ned Otter
Twitter: - @NedOtter
LinkedIn: Ned Otter
Contact: http://www.nedotter.com
DBA with vast experience administering Microsoft SQL Server since version 4.21 to the present.
Certifications:
MCSE SQL Server 2012 Data Platform
MCTS SQL Server 2008
Overall computer experience: 25 years
SQL Server experience: 23 years
Currently obsessed with In-Memory technology.
Please see LinkedIn profile for more details.
Kendra Little
Twitter: - Kendra_Little
LinkedIn: Kendra Little
Contact: http://littlekendra.com
Kendra Little is a Microsoft Certified Master and a Microsoft MVP. Kendra fell in love with the challenge of deploying software to a complex database environment when she worked in a build operations team at a software startup. She went on to become a database administrator for performance critical databases at Microsoft Corporation. Since then, Kendra has worked internationally as a teacher and consultant, and founded the training site SQL Workbooks. She joined Redgate as a Product Evangelist in 2018.
Amy Herold
Twitter: - @texasamy
LinkedIn: Amy Herold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
Amie Mason
LinkedIn: Amie Mason
Consultant with a demonstrated history of working with clients across multiple verticals to leverage their data to improve reporting and decision making in their business. Able to quickly assess business requirements and skilled in report design and predictive analytics enabling a direct translation from those requirements to business impact. Broad background includes experience in the public sector, survey design, and grassroots campaign management.
Misc Speakers
Oregon SQL provides opportunities for SQL Server developers, .NET and other developers accessing SQL Servers, SQL Server administrators, and Business Intelligence professionals to meet and discuss SQL Server technologies that are of specific interest to the developer community. Discussion topics include ‘Best Practices’, T-SQL code, Query Optimization, Reporting, ETL, Indexing, and new (as well as undiscovered ‘old’) features.
Thomas Norman
Twitter: - ArmorDba
LinkedIn: Thomas Norman
Contact: https://armordba.com/
Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.
Hugo Kornelis
Twitter: - Hugo_Kornelis
LinkedIn: Hugo Kornelis
Contact: http://sqlblog.com/blogs/hugo_kornelis/default.aspx
Hugo Kornelis is an established SQL Server community expert who spends a lot of time at various conferences. He is author of “the Execution Plan Reference” (sqlserverfast.com/epr), blogger, technical editor of Grant Fritchey’s “SQL Server Execution Plans, 3rd edition” and some other books, and Pluralsight author. He was awarded SQL Server MVP and Data Platform MVP 12 times (2006 - 2016, and 2019-present).
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.
When not working for the community, he is busy at his day job: freelance database developer/consultant.
Hugo has over 20 years of SQL Server experience in various roles. He loves to write and tune complex queries, but he also has a strong database design background.
Joseph Yeates
Twitter: - https://twitter.com/FthrsAnalytics
LinkedIn: Joseph Yeates
Contact: https://www.feathersanalytics.com
Joseph is a data enthusiast and blogs about all things Power BI on Feathers Analytics. He has a passion for crafting compelling data narratives and making insights accessible to a wider range of users through visualization. He holds the Certified Analytics Professional designation as well as a DBA certification with a focus on SQL Server Analysis Reporting Services. He uses R Studio, Power Query and Power BI to model, manipulate, analyze, and visualize data. He integrates R into Power BI to bring the power of predictive analytics into reports and dashboards. He is a member of the Vancouver Power BI User Group and has presented on Power BI Tips Tricks and Predictive Analytics with R in Power BI.
Craig Allen
Twitter: - @msftdude
LinkedIn: Craig Allen
Contact: http://www.msftdude.com
Craig Allen is a Dell EMC mSpecialist (Microsoft Specialist). His role as a technical consultant is to help customers in understanding Dell EMC’s products for the Microsoft platform. Craig can assist in the initial planning and evaluation of Dell EMC’s Proven Solutions for Microsoft, including requirements gathering, architectural guidance, and integration considerations. Craig is located in Dallas, TX and comes to Dell EMC with 25 years of experience in IT.
Lowry Kozlowski
Twitter: - @lowrykoz
LinkedIn: Lowry Kozlowski
Lowry Kozlowski is a SR SQL DBA and SR Consultant for SWC Technology Partners. Been involved with SQL for 17 years. Co-Leader of the Chicago Suburban SQL User group. Part of the SQLSaturday team for Chicago. Love SQL, photography, solving problems and trying new food. Goal in life is to minimize off hours calls by proactive work on systems.
Hamish Watson
Twitter: - theHybridDBA
LinkedIn: Hamish Watson
Contact: http://www.sqlservercentral.com/blogs/the-hybrid-dbas-blog/
Hamish Watson is a Microsoft Data Platform MVP and VMware Expert with a passion for efficient database and application deployment using DevOps methodologies.
He has 20+ years of IT experience in managing and deploying large scale databases on SQL Server technologies.
He has been managing SQL Server since SQL Server 2000, and pragmatic approaches to delivering business value to clients is his career passion.
Educating and helping others learn is a driver for Hamish. He is a Director-At-Large on the PASS Board, international speaker, and a repeat guest lecturer at a local university.
Jared Karney
Twitter: - jaredkarney
LinkedIn: Jared Karney
Jared Karney has been working with SQL Server since 2007. He currently works as a Premier Field Engineer for Microsoft. His specialties include performance tuning, big data, cloud, automation, internals, and overall architecture. He is an MCT and holds a number of Microsoft certifications. He is also a leader for the Chicago SQL Server Users Group.
Cathrine Wilhelmsen
Twitter: - @cathrinew
LinkedIn: Cathrine Wilhelmsen
Contact: https://www.cathrinewilhelmsen.net/
Cathrine loves teaching and sharing knowledge :) She is based in Norway and works as a Senior Business Intelligence Consultant in Inmeta, focusing on Data Warehousing, Data Integration, Analytics, and Reporting projects. Her core skills are Azure Data Factory, SSIS, Biml and T-SQL development, but she enjoys everything from programming to data visualization. Outside of work she’s active in the SQL Server community as a Microsoft Data Platform MVP, BimlHero Certified Expert, author, speaker, blogger, organizer and chronic volunteer.
Je’Anna Lanza-Abbott
Twitter: - @STATWonderWoman
LinkedIn: Je’Anna Lanza-Abbott
Dr. Je’Anna Lanza-Abbott holds the Spec’s Charitable Foundation Endowed Professorship in Social Responsibility at the University of Houston. She has a joint appointment with the Conrad N. Hilton College and the C.T. Bauer College of Business. She teaches primarily in the areas of hospitality business law, organizational behavior/conflict management, and negotiations. She has written multiple refereed articles in these areas, as well as two textbooks.
She has multiple advanced degrees including: JD and LLM from University of Houston (UH), MBA from University of Chicago, MS in Analytics from Texas AM and PhD in Management Science from UH Bauer College of Business.
Pat Phelan
Twitter: - @YetAnotherSQL
LinkedIn: Pat Phelan
Pat Phelan first joined a computer user group (DECUS) in High School, and has joined many more since then. Pat worked many jobs in high school and college, and over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team. Involta builds, owns and operates world class colocation datacenters and also provides managed services and support staff to clients.
Kathi Kellenberger
Twitter: - auntkathi
LinkedIn: Kathi Kellenberger
Contact: http://auntkathisql.com
Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.
Andy Yun
Twitter: - SQLBek
LinkedIn: Andy Yun
Contact: http://sqlbek.wordpress.com
Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP. He has been working with SQL Server for nearly 20 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQLSaturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQLSaturday Organizing Committee.
Ben Thul
Twitter: - @spartansql
Contact: http://www.spartansql.com
Born naked and defenseless, he overcame these obstacles to become a mender of broken things, seeker of magic rings, and occasional watcher of slow pings.
James McGillivray
Twitter: - JamesMcG_MSBI
LinkedIn: James McGillivray
Contact: https://jimbabwe.co.za/blog-posts/
James McGillivray, Data Management and Analytics MCSE, has been working in Business Intelligence for over a decade. He spends his working hours building solutions that allow people to make informed decisions quickly and accurately. James is a director at Cobalt Analytics.
Before his career in data, James was an avid musical theatre student and musician. This love for performance has developed into a passion for developing and delivering presentations that are informative and enjoyable. James speaks frequently at the Johannesburg SQL User Group, and has delivered sessions at numerous SQLSaturdays, PASS Summit, Power BI World Tour and SQL Bits.
Jason Horner
Twitter: - jasonhorner
LinkedIn: Jason Horner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.
I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.
In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
Misc Speakers
Oregon SQL provides opportunities for SQL Server developers, .NET and other developers accessing SQL Servers, SQL Server administrators, and Business Intelligence professionals to meet and discuss SQL Server technologies that are of specific interest to the developer community. Discussion topics include ‘Best Practices’, T-SQL code, Query Optimization, Reporting, ETL, Indexing, and new (as well as undiscovered ‘old’) features.
Misc Speakers
Oregon SQL provides opportunities for SQL Server developers, .NET and other developers accessing SQL Servers, SQL Server administrators, and Business Intelligence professionals to meet and discuss SQL Server technologies that are of specific interest to the developer community. Discussion topics include ‘Best Practices’, T-SQL code, Query Optimization, Reporting, ETL, Indexing, and new (as well as undiscovered ‘old’) features.
Warwick Rudd
Twitter: - @warwick_Rudd
LinkedIn: Warwick Rudd
Contact: http://www.sqlmastersconsulting.com.au/Blog
Warwick Rudd is a Microsoft Certified Master – SQL Server 2008 and Principal Consultant at SQL Master Consulting. He is a frequent speaker at local SQL Server User Groups and SQLSaturday events in Australia. When not playing with the SQL stack, Warwick likes to get away to the cold and spend time snowboarding.
Peter Kral
Twitter: - https://twitter.com/pkral
LinkedIn: Peter Kral
Peter Kral is a Premier Field Engineer (Data AI) at Microsoft. He holds SQL Server MCSA 2012/2014/2016 and Data Platform MCSE certifications, and was the winner of the Speaker Idol Award at PASS Summit 2016. Peter lives in the San Diego area where he is an active member of the local PASS chapter. He has spoken at many SQLSaturdays, SoCal Code Camps, and at PASS Summit 2017 and 2018.
Bob Pusateri
Twitter: - @SQLBob
LinkedIn: Bob Pusateri
Contact: http://www.BobPusateri.com
Bob Pusateri is a Microsoft Certified Master, DBA, and systems architect with over 10 years of experience on SQL Server. His interests involve internals, performance optimization, and cloud technologies. He is an active member of two Chicago-area PASS Local Groups, a community speaker, and maintains a web presence through both Twitter (@SQLBob) and his blog (bobpusateri.com).
Ted Stathakis
Twitter: - fishheadted
LinkedIn: Ted Stathakis
Contact: http://fishheadted.com
Ted Stathakis is a data professional passionate about the presentation layer. He has worked with SQL Server since the turn of the century, has mastered Reporting Services since he began working with it when it was released in 2004, and is super excited about Mobile Reports and Power BI. Ted hosts the local PASS user group, is the organizer of SQLSaturday Orange County and presented on SSRS at Summit in 2019. As a 40+ year veteran of the restaurant industry, he is been an advisor, speaker and panelist at national trade shows. When he isn’t consulting on Business Intelligence projects he can be found presenting at a conference, enjoying some live music or teaching kids, both young and old, fishing and archery at a nearby Scout camp.
Michael Johnson
Twitter: - MikeJohnsonZA
LinkedIn: Michael Johnson
Contact: http://michaeladrianjohnson.com/
Michael Johnson is a Microsoft data platform MVP and leader of the Johannesburg SQL User Group and Business Analytics Virtual Group. He works as an Independent Business Intelligence Consultant and regularly presents at local user groups, SQLSaturdays and PASS Virtual Chapters.
Misc Speakers
Oregon SQL provides opportunities for SQL Server developers, .NET and other developers accessing SQL Servers, SQL Server administrators, and Business Intelligence professionals to meet and discuss SQL Server technologies that are of specific interest to the developer community. Discussion topics include ‘Best Practices’, T-SQL code, Query Optimization, Reporting, ETL, Indexing, and new (as well as undiscovered ‘old’) features.
Michael Curry
LinkedIn: Michael Curry
I am an academic, data professional and behavioral cybersecurity researcher and very active in the Portland and SW Washington community. I am passionate about increasing equity in the tech field and have made contributions to improving gender diversity. I am part of the Oregon SQL leadership and the organizing committee for Oregon SQLSaturday.
Misc Speakers
Oregon SQL provides opportunities for SQL Server developers, .NET and other developers accessing SQL Servers, SQL Server administrators, and Business Intelligence professionals to meet and discuss SQL Server technologies that are of specific interest to the developer community. Discussion topics include ‘Best Practices’, T-SQL code, Query Optimization, Reporting, ETL, Indexing, and new (as well as undiscovered ‘old’) features.
Sponsors
The following is a list of sponsors that helped fund the event: