SQLSaturday #572 - Oregon 2016

Event Date: 10/22/2016 00:00:00

Event Location:

  • Washington State University Vancouver
  • 14204 NE Salmon Creek Ave
  • Vancouver, Washington

PDF of Schedule

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: Mobile, Paginated, KPIs, and Power BI, Oh My! SSRS 2016 Reporting

Abstract: SQL Server Reporting Services (SSRS) 2016 is getting the biggest update since SQL Server 2005! This session will define and demo each of the SSRS report types are and how they are developed and supported: Mobile (previously DataZen reports), Paginated (SSRS RDL reports), KPIs (new standalone Key Performance Indicators), and Power BI (now Power BI can be managed in SSRS for an on-premises solution). All of these report types can now be managed in SSRS for a single reporting solution.

We will also look at the new SSRS Web Portal (replacement for Report Manager) and how the development environment will change as well. Sometime will also be spent on how to support all of these report types and the impact it will have on IT. If you have been curious about what has changed with SSRS in SQL Server 2016 and you want to be ahead of the curve, this is the session for you!

Speaker(s):

  • Steve Wake

Track and Room: BI Information Delivery - MMC6


Title: Execution Plans for Mere Mortals

Abstract: For beginning database professionals, execution plans can be intimidating. This 1-hour session takes you through the basics of reading graphical execution plans and drills into key operators, warnings, and properties. Learn how, why, and when an execution plan is created and saved to plan cache.

Reading execution plans becomes much less intimidating as we walk through the flow and process of a graphical execution plan. After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance-tuning opportunities. Finally, you will be able to capture the execution plan and save it for analysis and comparison after modifications.

Speaker(s):

  • Mike Lawell

Track and Room: Enterprise Database Administration Deployment - MMC219


Title: New SQL Server 2016 Feature: “Query Store”

Abstract: Do you have any SQL Server monitoring tool in your production environment? If so, what would you do when you find a trouble-making query? Do you write a request to software developers to tune it?

In SQL Server 2016 you have an option not only monitor worst performing queries, but also decide how they have to be executed in your system. You can look at different query plans and force SQL Server to use the quickest one or one which uses less memory or IO.

During that session we will go through major new features of SQL Server 2016 and nail down the “Query Store”.

You will learn about that new SQL Server feature and maybe you find how it would help you in your current production environment.

Speaker(s):

  • Slava Murygin

Track and Room: Enterprise Database Administration Deployment - MMC23


Title: Making Row Level Security and Dynamic Data Masking work for you!

Abstract: Security by design, it is how we should be building data platforms and applications. Security is not an afterthought that should be tacked on. With Azure SQL DB and SQL Server 2016, this got a lot easier with the new security features that have been added, notably Dynamic Data Masking and Row Level Security.

Here we will explore these two new tools that have been added to our toolbox of SQL Server security. Looking to understand what the features are, and how they work. More importantly, we will look at the use cases for these features. When they are, and are not appropriate. Finally looking at how we can incorporate them into the systems that we are building, and whether we can design them into our existing systems.

Understanding the capabilities that we have available is important, as the threats change so must the technology and our approach. By the end of this session, you will be in a position to decide if these capabilities will help you secure the data you manage.

Speaker(s):

  • John Martin

Track and Room: Application Database Development - MMC214


Title: Analysing your online presence using Power BI

Abstract: In this session we will look at how you can use Power BI to analyse you company’s online presence.

We will look at how you can source data from Google Analytics, Facebook, Twitter, LinkedIn and finally from web pages. We will then show how you can work with the data to get some meaningful analysis from it and ask the question: Can you get a holistic view of your online presence?

This is a demo rich session where we will go through getting the data in and looking through how we can extend the model using DAX to get more insight before visualizing the results.

The participants will leave the session with ideas on how they can use Power BI (or indeed some other BI tool) to start analyzing their company#39;s online presence plus the pbix file used in the session with all the code.

Speaker(s):

  • Asgeir Gunnarsson

Track and Room: BI Information Delivery - MMC6


Title: Real World In-Memory OLTP 2016

Abstract: In-Memory OLTP was a fascinating feature addition for performance nerds in 2014, but real world use has been somewhat low. With the release of SQL Server 2016, it might be time for a second look.

An impressive list of improvements to In-Memory OLTP have changed the original release from a somewhat edge case solution to a practical consideration for an increasingly larger number of scenarios.

In this demo heavy session, we will implement and benchmark three real world use cases for memory optimized objects while showcasing In-Memory OLTP features new to SQL Server 2016.

Many presentations, books, and deep dives describe the internals of In-Memory OLTP objects. The focus of this course is real world implementation and best practice.

Speaker(s):

  • Russ Thomas

Track and Room: Enterprise Database Administration Deployment - MMC23


Title: Azure Machine Learning: From Design to Integration

Abstract: Machine Learning is a subfield of computer science concerned with systems that learn from data. So this isn’t about systems that follow explicitly programmed instructions, but rather about systems that find patterns and trends within datasets, and use them to deliver insight and predictions.

In this session, you will learn how an Azure Machine Learning solution comes to life: From the creation of a workspace, to the preparation of data, to experimentation with Machine Learning algorithms, and then finally to the integration and embedding of predictive insights into applications.

This session has been specifically designed to describe Machine Learning fundamentals, and to help enable and inspire existing data professionals taking their first steps to leverage cloud-based predictive models delivered with Azure Machine Learning. It is guaranteed to thrill you with potential, and excite you with the relative ease by which it can be accomplished.

Speaker(s):

  • Peter Myers

Track and Room: Advanced Analysis Techniques - MMC22


Title: Reporting Services 2016: New Features Smart Migration Strategy

Abstract: With the release of SQL Server 2016, Reporting Services is finally getting some love! In this session you will get a brief peek at some of the new features and functionality including a look at the new Report Manager interface and the new control we have over the parameter placement on screen. We will then dive into how to use a custom report, based on the ReportServer database transaction log table, to see which reports are actually being used and use that report to determine a smart strategy for which reports to migrate to a new 2016 installation. You will see how to combine this understanding of active reports with the power of linked reports to simplify your Reporting Services implementation as you convert to SQL Server 2016. The session will conclude with a look at my “Ultimate Footer”, which you can use on any version of Reporting Services, that shows report utilization, performance details, stored procedures and data sets used and discover any inline TSQL being abused.

Speaker(s):

  • Ted Stathakis

Track and Room: BI Platform Architecture, Development Administration - MMC217


Title: WhereScape RED - an agile IDE for Data Warehouses

Abstract: This session shows how you can use WhereScape RED to accelerate project delivery and drive agile development of your data warehouse.

There is a proliferation of beautiful tools for providing data visualizations and self-service data delivery to business users - but these tools rely on having data available, often in a data warehouse. And building / maintaining the data warehouse is often the lengthy, fraught part of BI projects.

WhereScape RED is an IDE for building and managing data warehouses, marts, stores and vaults. RED supports all common modeling approaches and architectures in an open, flexible and scalable environment. Developers use RED to massively accelerate delivery and documentation of rapid / agile projects without sacrificing control.

Join us for a discussion and demonstration on how you can deliver projects with the business to empower your enterprise with data - leveraging the MS BI Stack!

Speaker(s):

  • Douglas Barrett

Track and Room: BI Platform Architecture, Development Administration - MMC217


Title: PowerShell for Absolute Beginnners

Abstract: Have you wanted to learn PowerShell, but didn’t know where to start? Have you been scared off by all the pipes and curly braces, or maybe you’re just not sure what PowerShell can do for you? This session will teach you the very basics of PowerShell and give you the fundamentals you need to start writing your own scripts and functions. You’ll also get a list of resources to continue learning and take your skills to the next level.

Speaker(s):

  • Michael Wells

Track and Room: Enterprise Database Administration Deployment - MMC16


Title: Temporal Tables in SQL 2016

Abstract: Introducing Temporal Databases in SQL Server 2016

Temporal tables in SQL Server is a new feature of SQL Server 2016 that will allow you to keep track of previous versions of records. It allows you to go back to specific point in time and display what the data was at that time. it’s also known as “Time Travel”.

This presentation will go through the requirements, some use cases, technicalities. There will be some demos which will help understanding how the feature works and how to use it.

Speaker(s):

  • Dan de Sousa

Track and Room: Enterprise Database Administration Deployment - MMC23


Title: SQL Server R Services in SQL 2016

Abstract: One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we’ll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We’ll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We’ll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we’ll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!

Speaker(s):

  • Chris Hyde

Track and Room: Analytics and Visualization - MMC22


Title: Inside the SQLPS PowerShell Module

Abstract: SQLPS has been evolving since 2012 and the SQL Provider/cmdlets have been around since 2008. Have you taken advantage of the PowerShell infrastructure that is on your servers? This session takes you behind the scenes of the SQLPS module that is installed with the tools. We will cover how to get it without the tools, how to use it once you have it and why you will want to use it for simple tasks or complex ones. When you learn how to navigate SQL Server and all its services using Paths, you won’t go back. Join me for a fun filled hour and learn how to keep SQLPS from becoming frustrating and a black box. You will be glad you did. Let’s continue the journey to becoming a PowerShell DBA.

Speaker(s):

  • Ben Miller

Track and Room: Enterprise Database Administration Deployment - MMC16


Title: Why Should I Care About … Partitioned Views?

Abstract: Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It’s possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away.

Speaker(s):

  • Rick Lowe

Track and Room: Enterprise Database Administration Deployment - MMC23


Title: 10 Amazing Things About Power BI You Don’t Know

Abstract: Have you spotted a location on Power BI map without having an exact address (like earthquake location)? Have you looped through source files in your Power Query and applied custom functions on them? Have you changed your data model to help Power QA to respond intelligently? Have you used Power BI for real-time data analysis? Have you used Power BI and Azure Data Factory to have an end to end Azure BI solution? Have you done many other amazing things with Power BI?

In this session you can expect many live demos and to be impressed by the extraordinary things you can do with Power BI. You will learn tips and tricks to empower your Power BI solution. Tips and tricks that you learn in this session helps you to make your Power BI solution more scale-able, robust, and high performance.

Speaker(s):

  • Reza Rad

Track and Room: BI Information Delivery - MMC6


Title: SQL Server Debugging Made Easy using Extended Events

Abstract: This is a demo filled session that will show you how to debug several common issues in SQL server database engine and identify hotspots as well failures using only extended events. We will showcase how extended events make scenario based troubleshooting easier without having to collect disparate sets of diagnostic data, gather memory dumps and comprise on performance. There have been a plethora of Extended Events which have been added to SQL Server recently based on customer feedback which deprecates the need to run profiler in many commonly encountered situations in production environments. This session covers the new enhancements and capabilities available for Extended Events.

Speaker(s):

  • Amit Banerjee

Track and Room: Enterprise Database Administration Deployment - MMC219


Title: Performance Pitfalls from Code Reuse

Abstract: Have you ever found yourself deconstructing endless layers of nested code? Is your T-SQL codebase written in an object-oriented format with functions views? Did you know that object-oriented code reuse can come at a significant penalty?

Come to this session and learn why applying object-oriented principles can be extremely detrimental to your T-SQL’s performance. You will learn how T-SQL is not like other common programming languages. We will peek inside the Query Optimizer to see how it handles these scenarios. Through extensive demos, we will explore solutions to maximize performance. You will be introduced to a T-SQL tool that will aid you in unraveling nested code. Alternate design patterns will be shown to help you mitigate these performance pitfalls.

Speaker(s):

  • Andy Yun

Track and Room: Application Database Development - MMC214


Title: Advanced Spatial Analysis Beyond Bubble Charts

Abstract: Are you finally ready to unlock the power in your spatial data? In this session, we will explore some advanced spatial analysis techniques, including clustering, binning, and the basic use of spatial statistics. We will then discuss several options for visualizing the results in SQL Server Reporting Services and Power BI. Get ready to go beyond bars and bubble charts!

Speaker(s):

  • Jason Horner

Track and Room: BI Information Delivery - MMC6


Title: Diagnosing Common Query Performance Problems with Execution Plans

Abstract: Ever scratched your head in bemusement at how an apparently ‘simple’ T-SQL query could perform so poorly or erratically? SQL Server’s execution plan for the query will likely reveal the root cause. It will tell you exactly which tables and indexes SQL Server accessed, and what operations it performed, in order to return the data that your query needed. If your query logic confused the optimizer, or if it had inaccurate statistical knowledge of the data, then prepare for some nasty surprises in the plan, such as expensive scans, sort and join operations that spill to disk, and more. We’ll examine common causes of these problems, such as use of ‘generic’ SQL, parameter sniffing, stale statistics, and misuse of functions. We’ll cover techniques that will allow you to locate quickly the execution plans for high-cost queries in the workload, and we’ll use some of the new execution plan features in SQL Server 2016 to detect and diagnose more easily the underlying query performance issues.

Speaker(s):

  • Tony Davis

Track and Room: Application Database Development - MMC219


Title: Consolidated Essential Performance Health Check using PowerShell

Abstract: Standardizing essential performance health check is the key in responding quickly to production issues and can cut down initial evaluation phase to 1/3rd of the time, whether you have been requested to do health check or you may want to run these due to an alert. These sets of essential checks can be the first major checkpoint for a DBA, they can look quickly on consolidated email stats first to decide if any further action is required to fix an issue or is it feasible to jump into in-depth troubleshooting. This will cut down on time and effort while responding to Production issues.

First part of the email shares some key observations about SQL Server performance which can be the key to quick resolution of the issue. Rest of the email shows different set of stats regarding CPU/Disk IO/Disk Space/Memory/Network/Blocking and database performance which could lead to the slowness observed in the application. This consolidated email can be shared with technical stakeholders to give a snaps

Speaker(s):

  • Prakash Heda

Track and Room: Enterprise Database Administration Deployment - MMC16


Title: Introduction to Indexes and SARGability

Abstract: Did you know that there is more than one type of index? Do you know the differences between them? Do you know when SQL Server flat out can’t use an index? Join Jared Karney as he explains the differences between the types of indexes and when they can and cannot be used (SARGability). He will talk about the different ways they are used and how you can make good indexes even better. You will leave this session understanding the basics of indexes and how they work, which is crucial to making your queries and servers perform well.

Speaker(s):

  • Jared Karney

Track and Room: Application Database Development - MMC1


Title: Biml for Beginners: Speed Up Your SSIS Development

Abstract: Are you tired of creating and updating the same SSIS packages again and again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and really speed up your SSIS development?

Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.

In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.

Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!

Speaker(s):

  • Cathrine Wilhelmsen

Track and Room: BI Platform Architecture, Development Administration - MMC217


Title: Hierarchical Queries

Abstract: Employee/manager relationships, family trees, and the like are all hierarchical data. In this session, we’ll look at a common way to represent such relationships, common methods of querying them, and how we can leverage the hierarchyid datatype to make queries go a lot easier and faster!

Speaker(s):

  • Ben Thul

Track and Room: Application Database Development - MMC214


Title: Power BI - Dashboard in an Hour

Abstract: A hands-on session using Microsoft Power BI to show you how to build a Power BI dashboard from Excel spreadsheets, or a local/public database. It is led by Microsoft Gold Partner, CSG Pro.

This is intended as a Bring Your Own Device (BYOD) session, however feel free to attend as an observer if you don’t have your laptop with you.

What is Power BI? Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Whether your data is a simple Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses, Power BI lets you easily connect to your data sources, visualize (or discover) what’s important, and share that with anyone or everyone you want.

Speaker(s):

  • Ron Ellis Gaut

Track and Room: Analytics and Visualization - MMC6


Title: 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: Application Database Development - MMC1


Title: Getting More from your Data with Azure Data Catalog

Abstract: Azure Data Catalog is a service that helps data producers and data consumers get more value from existing data sources by making them easier to discover and understand. Users can register data sources to add them to the catalog with tags and annotations to share their purpose and intended use, and can discover them through searching, browsing and filtering.

If you want the data you produce to have more impact, or you want to spend less time looking for the right data to use, please join us for this interactive session. We will cover the capabilities of the Azure Data Catalog, common scenarios for its use, and information about how to get started putting Data Catalog to work for you.

Speaker(s):

  • Matthew Roche

Track and Room: Information Delivery - MMC22


Title: Learn about Pyramid Analytics BI Office Platform

Abstract: Pyramid Analytics’ industry-leading Modern BI platform balances IT control and business user success. It offers enterprise capabilities such as advanced data modeling, self-service data discovery, interactive dashboards, and narrative reporting on any device. Here’s what makes Pyramid Analytics unique: (1) A true analytics platform that combines the security and stability of IT governance with the flexibility and utility of user-driven analysis (2) A scalable platform that supports the volume and variety of data, subject areas, and users across the enterprise (3) The BI Office collaboration engine lets users share analysis, comments, and context to bring the power of the collective to every decision (4) Enterprise-grade, role-based security that enables the right access for the appropriate audiences across the platform – even down to the cell level of content (5) Merging advanced visuals and powerful analytics provides real-world utility, and gives users the power to answer challenging

Speaker(s):

  • Jason Picker

Track and Room: BI Platform Architecture, Development Administration - MMC214


Title: Server Storage Performance Best Practices

Abstract: 2016 is the year of All-Flash for primary storage, and DELL EMC’s industry leading portfolio of All-Flash arrays unlock the speed, efficiency, and agility that your business stakeholders have been demanding. Whether supporting 1,000 or 10,000,000 IOPS, DELL EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type. Beyond just production database performance, DELL EMC provides robust database repurposing via our iCDM or Integrated Copy Data Management capabilities. Creating and maintaining test/dev, near real-time analytic, or sandbox environments has never been simpler. Join us and hear how we can address the needs of all of your Microsoft SQL Server instances.

Speaker(s):

  • Craig Allen

Track and Room: Enterprise Database Administration Deployment - MMC1


Title: Power BI developer features easy as 1-2-3: live tiles, REST APIs,

Abstract: In this session Charles Sterling will show us how to use Power BI in your development efforts specifically how to call REST APIs with Power BI without writing any code. Parsing, modeling and transforming the resulting JSON to make creating rich interactive reports a snap and integrating this into your development efforts by embedding the Power BI data visualizations into your web applications.

Speaker(s):

  • Charles Sterling

Track and Room: Cloud Application Development Deployment - MMC22


Title: In memory OLTP - what can it do for me?

Abstract: In Memory OLTP came along in SQL Server 2014 along with several limitations. It was still really useful – as long as your use case suited the limitations. SQL Server 2016 removes several of these limitations and widens the use cases of in-memory OLTP. For example, even if you are not taking advantage of in-memory tables, you can probably leverage performance improvements by replacing traditional table variables and both local and global temporary tables with in memory implementations. Now you’ll be able to say that table variable is truly in memory! Come along to this session and learn about some of features of in memory OLTP - or Hekaton as a lot of people refer to this - and how you may be able to leverage these high performance features in both new and existing applications.

Speaker(s):

  • Martin Catherall

Track and Room: Application Database Development - MMC214


Title: Keeping your SQL Objects Safe In Development

Abstract: It has been a long established practice to keep maintain application code in version control. Versioning your application code allows you to view changes made by several developers working on the same project. It allows the team to get the latest changes in a consistent and reliable manner. It allows you to return your code to a prior state. It even acts as a safety net for when that day comes when your developer’s computer won’t turn on.

So, what about your SQL Objects?

Join me in this demo heavy session where we will explore the benefits of versioning your SQL Objects and learn how it can enable streamlined database development without sacrificing control and visibility. We’ll be using Red Gate’s SQL Source Control tool for demos, and we’ll see how it integrates with your existing version control software to manage your SQL Objects just like application code.

Speaker(s):

  • Mickey Stuewe

Track and Room: Enterprise Database Administration Deployment - MMC16


Title: Cluster Standalone SQL Server Instances at “Ludicrous” Speed

Abstract: Join CTO of DH2i, OJ Ngo, for a live demo and discussion as he builds out a very unconventional SQL Server failover cluster. He will show you how to take standalone SQL Server instances on a mix of different OS and SQL Server versions/editions and transform them into an automated HA cluster with multi-subnet geo-clustering capability—all in just a few minutes.

With speed like that, there will still be plenty of time to show you: • QoS controls at the instance level • SQL and OS updates as fast as an application stop/start • How this solution can save you 30-60% on licensing costs

Stop slaving over your traditional WSFC environments and learn why Global 500 customers have adopted this profoundly simple, Microsoft certified solution.

Speaker(s):

  • OJ Ngo

Track and Room: Enterprise Database Administration Deployment - MMC23


Title: Lightening Talks

Abstract: See Printed Lightning Talk Schedule at Event

Speaker(s):

  • Misc Speakers

Track and Room: Advanced Analysis Techniques - VDEN110


Title: Split, Merge and Eliminate - An Introduction to Partitioning

Abstract: In my life as a Consultant, partitioning is one of the least used or even inefficiently used components of SQL Server that I have seen. Partitioning provides many potential benefits such as easier index maintenance, data loads and archiving using partition switching and improved query performance through partition elimination.. In this session we’ll cover the basics of partitioning - from getting started with partition switching to partition elimination to make your queries go faster - with plenty of demos for you to take away.

Speaker(s):

  • Martin Cairney

Track and Room: Enterprise Database Administration Deployment - MMC23


Title: The Lost Science of Set Theory

Abstract: Many database developers today do not have a Computer Science degree and may also have begun their career developing software using procedural programming languages (Java, C#, etc.). As a result, they may not have the background needed to conceptualize solutions in terms of sets of data and therefore may not be able to develop efficient set-based queries. In this session, we will review the basics of set theory and how it applies to database development to enable you to turn cursors, loops, and other procedural programming practices into efficient set-based operations that make the most use of a relational database engine.

Speaker(s):

  • Aaron Cutshall

Track and Room: Application Database Development - MMC1


Title: What You’re Missing If You Aren’t Using SQL Windowing Functions

Abstract: We’ll explain and demo techniques you are missing out on that you can use to solve difficult sql problems using sql windowing functions including: - Determining how many stops a sport-band user made during a day and how long their average stop was, adjusting for altitude and position using both windowing functions and sql spatial functions. - Merging separate fiscal calendars with differing periods and different granularities (month vs. day, etc.) - Finding equivalent fiscal days or calendar days in previous or future years - Calculating percentiles on data to be used for Analytic tools and more!

Speaker(s):

  • Steve Moss

Track and Room: BI Platform Architecture, Development Administration - MMC217


Title: SQL Server 2014/2016 Technology Enhancements for Developers

Abstract: Your team is planning to upgrade from an early version of SQL Server environment. Learn what’s new and which features and enhancements are really important to the work life of a SQL Server Developer. In this presentation we’ll explore SQL Server 2014/2016 new possibilities, showing you how to use new T-SQL functions, features and enhancements that are only available in SQL Server 2014/2016.

Speaker(s):

  • Wylie Blanchard

Track and Room: Application Database Development - MMC214


Title: Using a gateway to leverage on-premises data in Power BI

Abstract: I look at how you can take advantage of an on-premises gateway to make use of local data when creating reports and dashboards for Power BI. This will start with Power BI Desktop, and the choices you have for SQL Server and Analysis Services. It will then move to the cloud and look at hosting your files on OneDrive for Business, and what this means for data freshness. We will then look at options for personal use or a more centralized use. It will finish off with looking at some troubleshooting tools available to you when working with data refresh.

Speaker(s):

  • Adam Saxton

Track and Room: BI Platform Architecture, Development Administration - MMC6


Title: Using Powershell to Automate Your Restore Strategy

Abstract: As DBAs, our most important job is protecting the data. Making sure our backups are running successfully gets us halfway there, but those backups are useless if we can’t restore them. Join me for this session to learn how to use Powershell to automate a restore process for backup validation.

Speaker(s):

  • Frank Gill

Track and Room: Enterprise Database Administration Deployment - MMC16


Title: Cortana Analytics : Transform Data into Intelligence

Abstract: Cortana Analytics delivers an end-to-end platform with an integrated and comprehensive set of tools and services to help users to build intelligent applications. This session will show Cortana can be used for collecting data from different resources, storing data, getting insights from collected data, creating analytics services, and finally showing the results through web apps, mobile apps, or rich client apps.

Speaker(s):

  • Leila Etaati

Track and Room: Analytics and Visualization - MMC22


Title: Women in Technology: Identifying and Understanding Gender Bias Inequality

Abstract: Gender Bias is something we’re all guilty of. It’s typically unconscious and often stems from long held misperceptions about women job responsibilities. We’ll learn how to identify gender bias when we see it. We’ll discuss why it’s important, how it affects our work, decision making, hiring, etc. We’ll discuss strategies for how both men and women can combat this at work in our every day lives. This session is about developing positive solutions to a problem that often goes undiscussed.

Speaker(s):

  • Rie Irish

Track and Room: Professional Development - MMC219


Title: Security 101

Abstract: Integrating security into your database design. Learn how to use roles, schemas and encryption to secure the data. A very demo rich session that will introduce you to security on the database level. We start with understanding GRANT, REVOKE and DENY while working our way through the object hierarchy till we end up at the column level when we have a lock at encryption. This session will also cover new SQL 2016 security features and how to use them correctly.

Speaker(s):

  • Thomas Grohser

Track and Room: Application Database Development - MMC1


Title: Remove Repetitive SQL Agent Jobs from Your Plate, from Your Plate

Abstract: Learn how to centrally automate and manage repetitive SQL jobs across your entire SQL Server environment. We’ll show you how to use JAMS to add intuitive scheduling logic, triggers, dependencies, and source control to critical SQL batch processes. We’ll demonstrate how JAMS helps companies overcome some of the most common challenges associated with scheduling, monitoring, and reporting using native SQL Agent tools.

Plus, we’ll explore some of the ways JAMS can integrate SQL processes into cross-platform workflows that extend across numerous business applications and scripts outside the SQL environment.

Speaker(s):

  • Kevin Vliet

Track and Room: Enterprise Database Administration Deployment - MMC219


Title: Hi, my name is Powershell, let’s be friends! An Intro to PoSH

Abstract: Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known “gotchas” when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.

Speaker(s):

  • Amy Herold

Track and Room: Enterprise Database Administration Deployment - MMC16


Title: SSIS Deployment Methods and Dynamic Execution

Abstract: This session focuses on the different deployment methods available in SSIS. SSIS 2012 introduced the new project deployment method which supports project and package parameters as well as the use of environments to make projects more portable. This session will take a detailed look at the package and project deployment methods as well as the best way to easily deploy across different environments or servers.

Speaker(s):

  • David Dye

Track and Room: BI Platform Architecture, Development Administration - MMC217


Title: Role Based Security in Azure SQL Database

Abstract: Azure SQL Database has a different security model than on premise SQL Server. Although similar, the differences are important and sometimes subtle. In addition to role based security in Azure SQL Database, Azure itself has a role based security model that is independent from the role based security model of Azure SQL Database. This PowerPoint free presentation is all demos where the different security models are deconstructed and explained.

Speaker(s):

  • John Cook

Track and Room: Cloud Application Development Deployment - MMC22


Title: Introduction to SQL Server Integration Services

Abstract: Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!

Speaker(s):

  • Ed Watson

Track and Room: BI Platform Architecture, Development Administration - MMC217


Title: Why NULL is not a value (and other SQL gotchas)

Abstract: Allowing NULL “values” in your database is simple, but managing them is a whole different story. Learn what NULL really means and why you may want to avoid it in your systems. I will share techniques for overcoming NULL and other SQL idiosyncrasies leading to bad data or incorrect query results.

Speaker(s):

  • Wendy Pastrick

Track and Room: Application Database Development - MMC1


Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

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.

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

Mike Lawell

Twitter: - @sqldiver

LinkedIn: Mike Lawell

Contact: http://sqlserverassociates.com/Blog

Mike Lawell is an 19 year veteran of SQL Server, working with all versions since 6.5. He specializes in performance tuning and high availability as an independent consultant.

He is a Linchpin People Teammate, he also consults with SolidQ, Intellinet and Microsoft Consulting Services.

He is also a certified Scuba instructor with a long bucket list of dive sites.

He resides in Atlanta, GA and you can catch him at many of the SQLSaturdays in the SE region of the United States.

Rick Lowe

Twitter: - DataFLowe

LinkedIn: Rick Lowe

Contact: http://dataflowe.wordpress.com/

Rick is a Microsoft Certified Master with more than 20 years of SQL Server experience in a variety of roles. He currently lives in Washington state and works as an independent consultant providing remote performance DBA and performance tuning services for clients in the USA and Canada. His first exposure to SQL Server was as a database developer, but over time he became more and more interested in how the database engine operated… eventually specializing more on performance issues than code.

Rick will work with all things relational, but most enjoys helping smaller companies get better performance from MSSQL, as well as smoothing over relationships between DBA and development teams.

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.

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.

Leila Etaati

Twitter: - @leila_etaati

LinkedIn: Leila Etaati

Contact: http://blog.radacad.com

Leila Etaati is the First Microsoft AI MVP in New Zealand and Australia, as well as a Data Platform MVP. She has a Ph.D. from the University of Auckland and is the co-director and data scientist in RADACAD company with many clients around the world. Additionally, she is the co-organizer of Microsoft Business Intelligence and Power BI Use group in Auckland with more than 1300 members. Leila has also co-organized 3 main conferences in Auckland: SQLSaturday Auckland (from 2015), Difinity (from 2017) and Global AI Bootcamp. She is a data scientist, BI consultant, trainer, and speaker. She is a well-known International speaker to many conferences such as MS Ignite, SQL PASS, Data Platform Summit, SQLSaturday, Power BI World Tour and in Europe, USA, Asia, Australia, and NZ. She has over 10 years’ experience with databases and software systems. Leila is an active Technical Microsoft AI blogger in RADACAD.

Martin Cairney

Twitter: - martin_cairney

LinkedIn: Martin Cairney

Martin has 20 years’ experience in SQL Server technologies. His experience spans both the Database Engine and infrastructure requirements, and Data Warehousing and BI implementations. He has worked across many industry sectors including London’s global financial institutions and both State and Federal Government Departments. He is a SQL Server MVP, MCT and an experienced conference presenter, having presented at PASS Summit, SQLBits, and SQLSaturday events and User Groups round the world

Jason Picker

LinkedIn: Jason Picker

Jason has over 20 years of BI experience developing datawarehouses, SSAS cubes, and end-user solutions using SQL Server Reporting Services, PerformancePoint, ProClarity and now Pyramid Analytics#39; BI Office. He has spent time as the BI Architect and Lead Developer for a major computer hardware manufacturer, a national home builder, and a regional hospital system. Jason also worked as an independent consultant and trainer on the Microsoft SQL stack. He loves to read and write MDX! Ask him to show you how to parameterize your MDX statements and queries.

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.

Steve Moss

LinkedIn: Steve Moss

Steve Moss is a Solutions Architect consulting in data and business intelligence with Slalom Portland . He is passionate about delivering enterprise data architecture solutions, the performance of data systems and data quality/master data management and in particular Azure Data technologies. He has over 18 years experience in SQL Server including roles as BI Architect, Data Architect, DBA Manager, Sr. DBA and .Net Developer. He has previously presented at SQLSaturday Redmond, SQLSaturday Oregon (4 years). He has attended Microsoft’s internal Cloud Solution Architect Training and is also a Certified AWS Solution Architect - Associate.

OJ Ngo

Thanh quot;OJquot; Ngo is a Co-Founder of DH2i Company and is one of the principal architects for its core technology. Prior to DH2i, OJ was a software architect for Hewlett-Packard working on Windows software solutions. OJ was also a software architect at PolyServe Inc., where he was responsible for the design of the world#39;s first application virtualization solution for Microsoft SQL Server. From 2002-2008 he was a Microsoft SQL Server MVP. OJ earned his degree in Chemical Engineering degree from OSU.

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.

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.

Prakash Heda

Twitter: - @prakashheda

LinkedIn: Prakash Heda

Contact: http://www.sqlfeatures.com/

Prakash Heda works as Manager (Data-IT) at SSC Advent. His expertise encompasses the work of automation, performance tuning/troubleshooting, high availability, san configuration and windows administration. Heda has 13+ years of experience managing enterprise-wide data needs in both high volume transactional and data warehouse environments. Heda holds certifications for MCDBA and MCITP. His background includes administration development using VB/ASP/SSIS with SQL server 2000 to 2017. He is an active member of PASS, SQLSaturday, and as well a frequent presenter at user groups, SQLSaturdays, and other community events. He is also an avid tweeter, blogger and runner.

Adam Saxton

Twitter: - @GuyInACube

LinkedIn: Adam Saxton

Contact: https://guyinacube.com

Adam Saxton is just a guy in a cube doing the work! He is on the Power BI CAT team at Microsoft, working with customers to help adopt Power BI. He is based in Texas and started with Microsoft supporting SQL Server connectivity and Reporting Services in 2005. Adam has worked with Power BI since the beginning, on the support side, and with documentation. In addition, he produces weekly videos for his Guy in a Cube YouTube channel.

Michael Wells

Twitter: - @SqlTechMike

LinkedIn: Michael Wells

Contact: http://sqltechmike.com

Michael Wells is a Microsoft Specialist at Dell EMC covering enterprise customers. He has worked in IT since 2000 and has supported all versions of SQL Server from SQL Server 2000 to SQL Server 2014. Michael has been presenting since 2007 for local user groups, CodeCamps, SQLSaturday events, IT Pro Camps, and large conferences like PASS Summit and Oracle OpenWorld.

Dan de Sousa

Twitter: - @dcasousa

LinkedIn: Dan de Sousa

Contact: https://sqlblog2017.wordpress.com/

Dan de Sousa is a Senior Data Consultant for DSI in Mississauga, Canada. He has been working with SQL Server for the last 10 years and has been involved in the development of datawarehouses as well as creating reports and dashboards. Dan is currently working on a data security compliance project for Europe which involves making sure any personal information is secured/encrypted before leaving its country of origin.

Amit Banerjee

Twitter: - banerjeeamit

LinkedIn: Amit Banerjee

Contact: http://www.troubleshootingsql.com

I am a data professional with over a decade of experience in Relational Database Management Systems. I lead Program Management for the SQL Server engineering team focusing on the SQL Server database engine (Windows and Linux) and Azure SQL Edge.

My past experiences include Program Management for Business Continuity and Disaster Recovery (HADR), Data Movement and Performance for SQL Server, Azure Database for PostgreSQL and Azure Database for MySQL.

I am an active blogger, co-author of Pro SQL Server on Microsoft Azure and Professional SQL Server 2012: Internals and Troubleshooting and a regular speaker at various community events like Microsoft Ignite, SQL PASS, TechEd, Virtual Tech Days, SQLSaturday and User Group meetin

Matthew Roche

Twitter: - SQLAllFather

LinkedIn: Matthew Roche

Contact: https://ssbipolar.com/

Matthew Roche is a Senior Program Manager in Microsoft’s Cloud + Enterprise Group, where he focuses on business intelligence, enterprise information management, metadata, and data warehousing.

Matthew is currently a member of the Power BI CAT team, where he was saddened to learn that there were not actually any cats. Previously he has worked on Azure Data Catalog, SQL Server Integration Services, Master Data Services, and Data Quality Services. Before joining Microsoft, he worked as an architect, consultant, and trainer focusing on ETL, data warehousing, and business intelligence.

When he’s not enabling the world to get more value from its data, Matthew enjoys reading, baking, heavy metal, and competitive longsword combat.

Charles Sterling

Twitter: - https://twitter.com/chass

Contact: https://blogs.msdn.microsoft.com/charles_sterling/

Charles Sterling came to Microsoft from being a marine biologist working for United States National Marine Fisheries doing marine mammal research on the Bering Sea. He started out at Microsoft supporting Excel and moved through a couple of support teams to being an escalation engineer for Microsoft SQL Server. Taking his love for customers (and diving), Chuck moved to Australia as a product manager and developer evangelist for the .NET Framework. In 2008 he moved back to Redmond as a Visual Studio community program manager and just recently moved to the Power BI team to continue his community passion and looking after the Power BI influencers and MVPs.

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.

Mickey Stuewe

Twitter: - @SQLMickey

LinkedIn: Mickey Stuewe

Contact: http://www.MickeyStuewe.com

Mickey Stuewe has been working with SQL Server since 6.5. That gives her over 20 years of experience. She has not only been a database developer, but also an application developer, even before Visual Studio existed. She is now thankful to be focusing on database design, t-SQL development, and query optimization. She also has a habit of enjoying SSIS and data warehouse design.

She blogs regularly on her website mickeystuewe.com and contributes to sites such as SQL Server Central and SQL Server Pro. She enjoys presenting at PASS Summit, SQLSaturdays, User Groups and other events.

When she is not immersed in SQL related activities, she enjoys action movies, art, reading, and laughing. She laughs loudly and often…just ask her children.

Asgeir Gunnarsson

Twitter: - bidgeir

LinkedIn: Asgeir Gunnarsson

Ásgeir Gunnarsson is a Data Platform MVP and Chief Consultant at Datheos in Denmark. He works on Business Intelligence solutions using the whole of the Microsoft BI stack. Ásgeir has been working in BI since 2007 both as a consultant and internal employee. Before turning to BI, Ásgeir worked as a technical trainer and currently teaches BI courses at the Continuing Education Department of the University of Iceland.

Ásgeir speaks regularly at events both domestically and internationally, and is the group leader of the Icelandic PASS Group, as well as the Icelandic Power BI User Group.

Ásgeir is passionate about data and loves solving problems with BI.

Tony Davis

Twitter: - @tonytheditor

Contact: https://www.simple-talk.com/blogs/author/2130-tony-davis/

Tony Davis is an Editor with Red Gate Software, based in Cambridge (UK), specializing in databases, and especially SQL Server. He edits and writes for both the Simple-talk.com and SQLServerCentral.com websites and newsletters, with a combined audience of over 1.5 million subscribers. He is the editor behind most of the SQL Server books published by Red Gate, and also the lead author of the book, SQL Server Transaction Log Management (http://bit.ly/1B2gWuB).

Aaron Cutshall

Twitter: - sqlrv

LinkedIn: Aaron Cutshall

Contact: http://sqlrv.com

Aaron N. Cutshall is an Enterprise Data Architect with 20 years of experience in analysis, design and development for applications and databases in manufacturing and warehousing plus over 15 years in the Healthcare Informatics field. His primary focus is in designing and developing solutions for extremely large data sets that perform quite well in SQL Server. He is active in the SQL Server community and speaks at SQLSaturday sessions across the country.

Rie Irish

Twitter: - IrishSQL

LinkedIn: Rie Irish

Rie lives with her family just north of Atlanta, Georgia. She worked as a SQL Server DBA, manager director for over 20 years. She’s worked in many industries including the non-profit sector, education, big pharma, and e-commerce. She was awarded the MVP in the Data Platform 3 times beginning in 2017 and gave that up to accept her role as a Senior Program Manager with Microsoft in 2019. She is very involved with the Atlanta MDF User Group, SQLSaturday Atlanta and is co-leader of the PASS Women in Tech virtual group.

Ron Ellis Gaut

Twitter: - @ronellisgaut

LinkedIn: Ron Ellis Gaut

Contact: https://www.csgpro.com/blog

Ron Ellis Gaut is President of CSG Pro, a Portland-based consulting firm specializing in Analytics, BI and custom application development. Ron has focused on the architecture, design and delivery of data applications for over two decades. As an early adopter of Power BI, Ron has built an impressive team of practitioners and though leaders. Ron is the founder/organizer of the Portland Power BI User Group. With over 370 registered members the group has been meeting monthly since February of 2015. Ron is a member of the Power BI Advisor group, is a member of the PUG advisors board. CSG Pro is a Microsoft Gold Partner and Power BI Showcase partner.

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.

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.

Reza Rad

Twitter: - Rad_Reza

LinkedIn: Reza Rad

Contact: http://radacad.com/blog

Reza Rad is a Microsoft Regional Director, MVP, author, trainer, speaker and consultant. He is a Microsoft Data Platform MVP for nine years from 2011. Reza wrote many books on Power BI subjects including the Power BI from Rookie to Rock Star, and Pro Power BI Architecture. Reza is the invited speaker at the world’s well-known conferences such as Microsoft Ignite, Microsoft Business Applications Summit, Ignite Tour, PASS Summit, and many other conferences. Reza is an active blogger and writes regularly about Power BI at https://radacad.com.

Kevin Vliet

Kevin Vliet is a Senior Support Engineer with MVP Systems Software, the leading provider of enterprise job scheduling and workload automation software. He brings more than 10 years of IT experience to the JAMS team and provides both onsite and remote implementation and training sessions for the solution’s rapidly growing user community. His expertise ranges from the conversion of native batch processing tools to specialized automation with applications such as Oracle, MS Dynamics, SAP and Informatica.

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.

Ed Watson

Twitter: - http://twitter.com/SQLGator

LinkedIn: Ed Watson

Contact: http://sqlgator.com

Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQLSaturday Atlanta, Atlanta BI, and Pensacola.

Slava Murygin

Twitter: - SlavaSQL

LinkedIn: Slava Murygin

Contact: http://slavasql.blogspot.com/

Started working with SQL Server 7.0 as DBA and Developer. Since then went through all SQL Server versions, migrations and multiple companies of different sizes and industries. Currently working as a contractor with all aspects of SQL Server, including, but not limited to: troubleshooting performance, designing/developing: databases, systems, processes, data warehouses, cubes, reports, ETLs; Refactoring old code; Migrating data from other systems to SQL Server; Securing the data on enterprise level.

John Cook

Twitter: - johnpaulcook

LinkedIn: John Cook

Contact: https://www.red-gate.com/simple-talk/author/johnpaulcook-2/

John Paul Cook is a psychiatric nurse practitioner and instructor of psychiatric nursing. He is former Data Platform Solutions Architect for Microsoft and before that a 9 time Microsoft MVP. John understands both the clinical aspects of healthcare and the technical aspects. He provides a unique perspective in being able to explain clinical concerns and issues to technical people. John is passionate about improving mental health in the community, including in the technical community.

Wylie Blanchard

Twitter: - WylieBlanchard1

LinkedIn: Wylie Blanchard

Contact: https://WylieBlanchard.com/?utm_source=sqlsaturday.comutm_medium=profileutm_campaign=website

Wylie Blanchard, MCSE is an IT consultant, SQL Server professional and web strategist who enjoys helping people learn how to use technology as a tool to amplify their professional lives. He has 15+ years of experience in the IT Industry and holds several certifications in SQL and Oracle systems. He is a father of twin-girls, a gadget enthusiast and a self-proclaimed pizza connoisseur. Learn more about Wylie at: www.WylieBlanchard.com.

Russ Thomas

Twitter: - @SQLJudo

LinkedIn: Russ Thomas

Contact: http://www.sqljudo.com

Prior to focusing full time on IT Management and Database Administration in the Denver Colorado financial sector, Russ spent several years in law enforcement including four as a training Sergeant and Washington CJTC Instructor specializing in Emergency Vehicle Driving at Portland Intl Raceway. An experienced public speaker and trainer, Russ also has two decades of hands on IT work and leadership experience. Russ is a SQL Server Data Platform MCSE and is active in the SQLSaturday community.

Peter Myers

LinkedIn: Peter Myers

Peter Myers is a consultant, trainer and presenter, and has worked with Microsoft database and development products since 1997. Today he specializes in all Microsoft Business Intelligence products and also authors training course content for Microsoft products and services.

He has a broad business background supported by a bachelor’s degree in applied economics and accounting, and he extends this with extensive experience backed by current MCSE certifications. He has been a Data Platform MVP since 2007.

Douglas Barrett

Contact: http://wherescape.com

Douglas is a Senior Solution Specialist for WhereScape, and has worked in data warehousing primarily on SQL Server for 12 years. In that time he has worked as a BI Specialist, moved on to work as a BI consultant for Microsoft and finally to WhereScape as a solution specialist. Doug has managed projects for airlines, banks, casinos, retailers and utility companies using all aspects of SQL Server.

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.

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.

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.

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.

David Dye

David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa

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.

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.

Wendy Pastrick

Twitter: - @wendy_dance

Contact: http://wendyverse.blogspot.com

Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page