SQLSaturday #563 - Dallas 2016
Event Date: 09/24/2016 00:00:00
Event Location:
- University of Texas at Arlington
- 416 Yates Street
- Arlington, Texas
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: Create a Data Loading Strategy
Abstract: Loading large amounts of data into SQL Server can be challenging. Many factors may challenge your goal for tuned performance. To make the decision making process more difficult, many of the choices listed below have both Pros and Cons to their implementation. For this reason, bulk loading large amounts of data requires a strategy.
Create a strategy to optimize your massive data loading processes. • High Performance Data Loading • Minimal Logging and Bulk Loading • Indexing Considerations • Delayed Durability • Eager Write
This session uses a Virtual Sandbox to demonstrate “real” data loads using these techniques listed above. We will look at the T-SQL used in these data loads. We will briefly discuss how the different settings and configurations effect the data loads. Power Point slides and sample SQL will be provided.
Speaker(s):
- Ryan Casey
Track and Room: BI Platform Architecture, Development Administration - 110
Title: Seamlessly Scaling Azure SQL DB with Elastic Database Tools
Abstract: Elastic Database Tools for Azure SQL DB offers a set of features that make it easier to build and manage a scaled-out data tier for cloud applications. With elastic database tools, applications can easily access data spanning multiple DBs, coordinate management tasks and manage how data is distributed among them. As part of the session, we explore workloads that are a natural fit for Azure SQL DB’s elastic database tools. Patterns discussed in depth include multi-tenant applications created by cloud ISVs and SaaS vendors, and applications relying on temporal data distribution. The session will illustrate how easy it is now to build, scale and manage cloud applications in SQL DB when using elastic tools capabilities such as the elastic database client library for .NET.
Speaker(s):
- Silvia Doomra
Track and Room: Cloud Application Development Deployment - 111
Title: Indexes: Everything You Wanted to Know – Help or Hinder
Abstract: Indexes can be a boon or decrement for query performance. This presentation will present what they are (in layman’s terms) and how they may affect query performance – both from a read (SELECT) viewpoint as well as a data modification aspect (INSERT, UPDATE, DELETE). This session will concentrate with a deep dive into clustered indexes and nonclustered indexes, their syntax and utilization, and their effect on performance in transaction and data warehouse databases. Covering nonclustered indexes will also be examined in detail and the scenarios they should be applied. There will be many query demos illustrating index utilization using statistics and query plans. Attendee should have some TSQL and Management Studio experience.
Speaker(s):
- Mike Byrd
Track and Room: Application Database Development - 105
Title: Imposter Syndrome: Are You Faking It Will they Find Out?
Abstract: Have you ever thought to yourself “All these people think I’m smarter than I really am” or “I really don’t know what I’m doing, they’re going to figure out I’m a fraud!” If yes, then you suffer from the Impostor Syndrome. And despite all the accomplishments, awards and accolades, you still doubt yourself. It’s rampant in the modern day tech workplace, and the fear will make you shrink back from opportunities. You dismiss praise. You overcompensate by working harder, being charming and demanding perfection from yourself. What would happen if you were released from this bondage, and kicked your impostor to the curb? In this session, learn 3 powerful techniques that can help to improve your confidence and silent that annoying voice in your head!
Speaker(s):
- Mindy Curnutt
Track and Room: Professional Development - 109
Title: Code Like a Pirate … Intro to R and Data Science Tools in MS
Abstract: R is the most popular statistics language used today. It is one of the most useful tools in the data scientist’s tool belt. It is also integrated into the MS stack in tools like Azure ML, SQL Server and Power BI and can be used to take your data analytics to the next level.
Come to this session to get an introduction to the R language including:
- Installing and Configuring R and RStudio
- RStudio Overview and Debugging
- How to Access and Manipulate Data
- Install and Manage Packages
- Create and Use Variables
- Control Flows
- Functions
- Basic Graphing and Statistical Analysis
We will finish with a brief introductions of how R integrates in Azure ML, Power BI and SQL Server 2016 using real demos.
The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!
Speaker(s):
- Jamey Johnston
Track and Room: Analytics and Visualization - 106
Title: MICROSOFT: SQL Server 2016 Stretch Database
Abstract: Your SAN consumption is increasing faster than your budget, you have tables so big that you dread re-indexing, or your end-users demand their cold or archived data always be online. There’s a solution that lets you take advantage of the Cloud, on your terms, all without impacting your existing end-user applications or queries.
Come and meet some of the SQL Server Stretch database product team, and find out how you can move your data securely and transparently, free up disc space and reduce your SAN consumption, while retaining full control from the on-premises SQL Server. You’ll reduce maintenance operations time and resources, plus lower overall cost. Learn how SQL Stretch database will simplify your journey to the Cloud!
Speaker(s):
- Anthony van Gemert
Track and Room: Application Database Development - 105
Title: Polybase and Time Travel (Temporal Tables)
Abstract: “With the release of SQL Server 2016, Microsoft has included two features that could fundamentally change the way we look at Data Warehousing. The addition of Polybase for connecting to external data sources such as Hadoop and Azure Blob for native TSQL queries extends the reach of the DW. The Temporal Table feature creates all kinds of possibilities for implementing Type 1 and 2 dimensions as well as time based reporting and logical data recovery. In this session we will take an in depth lock at the features and scenarios for use. We will also look at some actual demos of the technologies so you can get a feel for the technologies in action.”
Speaker(s):
- Stan Geiger
Track and Room: BI Platform Architecture, Development Administration - 110
Title: Developing R and SQL Server 2016
Abstract: If you have heard about R and want to learn how to write it yourself and run it within SQL Server 2016 you will want to come to this session. As Microsoft is now incorporating the R language into SQL Server 2016, the language is going to be a required skill for all data professionals in the near future. SQL Server 2016 uses a non-open source version of R, and the benefits of using that version will be reviewed too.
Using SQL Server 2016, attendees will learn how to incorporate R in SQL Server as well write R code in Visual Studio which gets data from and runs on SQL Server. The version of R which ships with SQL Server incorporates the ability to run with more data than can be loaded into memory, and attendees will learn the best use cases for it.
Attendees will learn the setup requirements for running R from within SQL Server 2016, and learn how to run R code from within Server Management Studio.
Speaker(s):
- Ginger Grant
Track and Room: BI Information Delivery - 109
Title: A DBA’s guide to whole stack performance troubleshooting
Abstract: Performance troubleshooting is a required skill for every DBA. Knowing the deep internals of how a query functions and why SQL Server chose to run it in a certain way is important. Knowing how to design a table or configure a database to squeeze every ounce of performance is our lifeblood.
What if I told you that you may be doing this all wrong? What if all the work and laborious effort put into design or configuration don’t improve the situation because the issue was never in SQL to begin with? Truth be told, the biggest differentiator between a good DBA and a great DBA is knowing the hardware and O/S; not just SQL.
Join me as I guide you through troubleshooting SQL Server performance from tip to toe to demonstrate the common performance problems you never knew you had.
Speaker(s):
- Daniel Janik
Track and Room: Advanced Analysis Techniques - 100
Title: IoT – Particle Photon to Azure and PowerBI integration
Abstract: This session is an introduction into integrating the Particle Photon Wi-Fi development kit and Microsoft Azure to analyze, collect, and provide PowerBI reports on IoT data.
Azure Event Hubs is a highly scalable publish-subscribe event ingestor that can intake millions of events per second to process and analyze massive amounts of data. Once collected into Event Hubs the data can be transformed and stored using any real-time analytics provider or a batching/storage adapters.
The Particle Photon has a simple but very robust development environment. When combined with Microsoft Azure using webhooks it is capable of ingesting millions of events per second using a remotely programmable Particle Photon.
For this training we will specifically look at publishing data from a Particle Photon (equipped with a Photon Weather Shield) to an Azure Event Hub. Next we will store the data using blog storage, SQL database, and data lake storage to then graphically represent the IoT data in PowerBI.
Speaker(s):
- Louis Mangiacapra
Track and Room: Other - 111
Title: Optimizing your data warehouse for OLAP Processing
Abstract: Analysis Services have become a major part of upper management daily decision making activities. However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS and the database engine to ensure optimal performance, as well as enterprise level features within the database engine and SSAS available to us and how aligning those to work side by side would yield us significant improvement in our processing time.
Speaker(s):
- Konstantin Melamud
Track and Room: BI Platform Architecture, Development Administration - 111
Title: RESTful JSON API Microservices and SQL Server
Abstract: Transforming your enterprise or startup using micro services that rely on SQL Server data can be a challenge. There are so many options out there. I will introduce how you can jump into API driven develop with lightning fast frameworks that make your job easy and simple. Explore how we leverage Entity Framework to quick start your data models with code-first prototyping. Then we will explore how to transition back when you’re ready for deployment. SQL Server offers native tools for JSON support in the newest 2016 release but if you don’t have that luxury we’ll explore legacy versions as well. API driven development can transform your software development lifecycle so join me as we get you going in the right direction with the latest frameworks and tools. Source code will be provided of a standard API framework with a real data model to accompany your efforts. We will also touch on OAuth 2.0, Unit Testing, and Continuous Integration (CI) for truly streamlined SQL powered apps.
Speaker(s):
- Jared Nielsen
Track and Room: Application Database Development - 108
Title: Managing MSDB
Abstract: You put a lot of time into managing your databases, but MSDB often flies under the radar or only gets backed up. There are a ton of things that get stored in MSDB, so how are you supposed to know what all those items are? More importantly, how do you manage the data that is getting stored in there and keep it from growing out of control? We will take an in-depth look at all the SQL features that put data in MSDB and the best approach to managing that data. You will walk away with scripts you can use to automate the grooming of MSDB.
Speaker(s):
- Ryan Adams
Track and Room: Enterprise Database Administration Deployment - 111
Title: Standardize Your Baseline
Abstract: The concept of baselines have been around for many years, yet all too often they are not executed on a regular basis and don’t contain enough information, I believe this is because most DBA’s don’t have a standard baseline to execute. Baselines can tell you how the server should be performing under normal workloads with the configuration that is currently in place.
During this session we will look at the kinds of data that you should be collecting while spending the majority of our time reviewing the methods on how this data can be collected, stored, automated and reported on.
These standardized baselines will give you a head start the next time you are looking to upgrade your server to new hardware, recover a server and performance troubleshooting.
Speaker(s):
- Chris Shaw
Track and Room: Enterprise Database Administration Deployment - 111
Title: Stop Doing That! 5 Common T-SQL Anti-Patterns
Abstract: There are several programming design patterns that work great in object oriented code but do not scale inside SQL Server. Things like Scalar-Value functions, Unions, CTEs, and row by row processing can make for more work then you would expect.
In this session, we will focus on several anti-patterns like these and show how to rework them to improve scale in the database engine.
By the end of the session, you will be able to quickly identify these common anti-patterns and analyze their sometimes unclear cost to the engine. Heading back to the office, you’ll be able to identify pain points in your longest running queries from a T-SQL perspective and become a code tuning rockstar!
Speaker(s):
- William Wolf
Track and Room: Application Database Development - 100
Title: Tips for SQL Server Performance and Resiliency
Abstract: After working 20 years in the industry on hundreds of SQL Servers clear patterns emerge. These observations of patterns and best practices directly relate to the health of the server.#160; During this session we will review the patterns of healthy SQL Servers and identify unhealthy behavior that clearly shows servers that are at risk.#160; We will review shared patterns, configuration and practices.#160;#160; Which of these repeating patterns represent healthy Servers and which of these patterns are#160; shared with servers that are having issues daily.#160; These patterns are so clear in fact that I many SQL Servers will benefit from the application of at least one if not more of the tips we will cover.#160; At the end of this session attendees will have the tools to identify and correct common issues that impact SQL Servers Performance and Resiliency.
Speaker(s):
- Chris Shaw
Track and Room: Enterprise Database Administration Deployment - 109
Title: Troubleshooting SQL Server Performance
Abstract: Microsoft SQL Support Engineers troubleshoot performance issues all day, every day. They use a set of tools that not only gather all the data necessary to troubleshoot any performance issue, but the tools also analyze the data and generate visually attractive reports. These tools have been available to the public for free for years. This presentation explains the tools, how to run them and how to interpret the results, including how to determine disk latency root cause, top reasons for high cpu, and what to do when you have excessive waits.
Speaker(s):
- Stacy Gray
Track and Room: Enterprise Database Administration Deployment - 106
Title: Random Acts of Senseless Databasing
Abstract: After years of snake oil salesmen and good-meaning but part-time developers, Acme Oil Gas company’s databases have become something Rube Goldberg would be proud of and they’ve hired you to sort everything out. What are some of the things you can expect to find and how can you fix them? From spaghetti code that references views inside of views nested in other views, to overly indexed tables that generate 10x the disk IO and contention they should, we’ll talk about database development, administration, and plenty of things in between.
Speaker(s):
- Kris Hokanson
Track and Room: Application Database Development - 105
Title: Agile Leadership Skills and Building High Performing Teams
Abstract: How do you build an environment that inspires innovation and individual ownership to deliver operational excellence? How to move away from the Command and Control leadership style that is so pervasive within the IT culture? How do you move from Manager to Leader? In today’s modern Enterprise, attracting and keeping talented employees is a challenge. We’ll cover the importance of: Spirit of Service, Project Vision, Allowing Team Input, and Trust in Team Members, and the impact these areas make on both Individual and Team performance. Thus altering how the organization is Managed/Lead from: “How do I accomplish corporate goals?” to the more empowering: “How do WE accomplish our corporate goals?”.
Speaker(s):
- George Govantes
Track and Room: Professional Development - 106
Title: SQL Server 2016: It Just Runs Faster
Abstract: Join me in taking a deep dive and a behind the scenes look at how SQL Server 2016 ‘It Just Runs Faster’, focused on scalability and performance enhancements. This talk will discuss the improvements, not only for awareness, but expose design and internal change details. The beauty behind ‘It Just Runs Faster’ is your ability to just upgrade, in place, and take advantage without lengthy and costly application or infrastructure changes. If you are looking at why SQL Server 2016 makes sense for your business, you won’t want to miss this session.
Speaker(s):
- Bob Ward
Track and Room: Enterprise Database Administration Deployment - 100
Title: JSON in SQL Server 2016
Abstract: There have been many data lingua franca over the years (EDI, CSV, XML). Let’s meet a new comer JSON (aka Jason). JSON is the web developers new best friend, providing a schema free way to transmit and persist data. SQL Server 2016 has provided new functionality to work with JSON. In this session we will look at how to read a JSON document using the OPENJSON function. We will also look at other methods for extracting information from JSON. Finally, we will look at how to generate JSON documents from TSQL queries.
Speaker(s):
- Russel Loski
Track and Room: Application Database Development - 110
Title: Dell EMC - Maximizing Microsoft SQL Server Storage Investments
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):
- David Stein
Track and Room: Professional Development - 105
Title: Ways SQL Server Lies and the Performance Tuning Headaches It Can Cause.
Abstract: Have you ever tried to tune a query or searched for a performance bottleneck just to have SQL Server lead you down a rabbit hole? In this session we will look at some common performance issues that can occur that might be masked or hidden by misleading information you get from SQL Server. We will also talk about why SQL Server gives you the information it does, and how to see past this information and find the real issues causing your performance problems.
Speaker(s):
- Lance Tidwell
Track and Room: Enterprise Database Administration Deployment - 106
Title: Power Networking for Data Professionals
Abstract: In this session we will discuss industry trends, career trends and just have a open dialogue with other Data Professionals, understand their wins, challenges and share ideas on how to navigate through them.
Speaker(s):
- Sri Sridharan
Track and Room: Professional Development - 110
Title: Why Did My Execution Plan Change? Introduction to Query Store
Abstract: Join John Sterrett, Principal Consultant at Procure SQL LLC to learn how execution plans get invalidated and why data skew could be the root cause to seeing different execution plans for the same query. We will look at the options for forcing a query to use a particular execution plan. Finally, you will learn how this complex problem can be identified and resolved simply using a new feature in SQL Server 2016 called Query Store.
Speaker(s):
- John Sterrett
Track and Room: Enterprise Database Administration Deployment - 108
Title: Dell EMC - Maximizing Microsoft SQL Server Storage Investments
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: Professional Development - 105
Title: WIT: Start ‘em Young - Growing Women in IT
Abstract: Do an internet search on “Women in Technology” and you’ll find lots of articles with surveys, graphs and percentages telling you that there are not enough women in technology related fields. They’ll give you just as many reasons why girls don’t start in IT or women don’t stay in IT. Is this true? As women in technology, are we wired differently? Was there some lightbulb moment that to put us on the path to innovate with code? Why are you in technology in the first place? From Grace Hopper to that 6th grade girl gaming with people around the globe - while technology has changed and is more accessible, what makes women pursue IT careers hasn’t. With opportunities now spanning a wide array of fields and technologies, what does it take to inspire the young girls of today? In this session we will try to cut through a lot of the noise and get down to what drives young girls who grow to be women in technology, how we can encourage them, and not get in their way.
Guest Speakers : Abha Jos
Speaker(s):
- Amy Herold
Track and Room: Professional Development - 110
Title: Objective SQL Server Performance
Abstract: “It’s slow! FIX IT!” is not a fun way to walk into the office on a Monday morning. However, putting objective metrics to the subjectivity of ‘slow’ is as much a science as it is art. Performance engineering takes effort well before an issue arises. Collecting the right metrics, trending and comparing against an established baseline, and identifying bottlenecks are all part of the performance process. This interactive session will help the DBA fine-tune their performance tuning approach so that the foundation for long-term proactive performance review is in place. The DBA can then shift the job responsibilities from a reactive response to a more predictive and proactive role.
Speaker(s):
- David Klee
Track and Room: Enterprise Database Administration Deployment - 100
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 - 108
Title: How To Plan Meetings That Work
Abstract: Too often we find ourselves in meetings that seem to have no purpose, that run long and we walk out with little more information than we started with. In this session, you’ll learn how to organize meetings that are both efficient and effective from the start. We’ll provide tips to help with participation, keeping the meeting rolling and even ending on time. Be the person whose meetings people actually look forward to. Both Lori and Allen have years of experience participating in and planning meetings both for work and volunteer settings including the PASS Board of Director, Election Review Committee and the Nominations Committee meetings.
Speaker(s):
- Lori Edwards
Track and Room: Professional Development - 110
Title: SQL Server Window Functions
Abstract: Window functions are a great TSQL tool that will allow you to write simpler, more elegant code. They were first introduced in SQL 2005, and then expanded in SQL 2012. By using TSQL Window functions you can simply your code and make it easier to understand. They allow you to see both aggregations and details all at the same time. In this demo-centric session we will begin with the basics introduced in SQL 2005, then move on to examine the new functions that were added with SQL 2012.
Speaker(s):
- Steven Ormrod
Track and Room: Application Database Development - 105
Title: Power BI Performance Tips
Abstract: It is quick and easy to build large, complex data models in Power BI (based on Power Pivot). However, building a model that performs well might seem hit or miss unless you are aware of how Power BI manages your data. This session provides design techniques and tips that will have you building your own models to deliver solutions without those nasty performance surprises!
Speaker(s):
- Rachael Martino
Track and Room: Analytics and Visualization - 108
Title: The AG-ony of Defeat: Let’s Break Some SQL Server Availability Groups!
Abstract: Some database administrators create availability groups. Some database administrators have availability groups thrust upon them. Whether you’re just starting to investigate SQL Server’s own high availability solution, or if you’ve become responsible for an Always On Availability Group that’s already been built, come get a glimpse of what can/will go wrong in an Availability Group implementation, from the commonplace to the spectacular.
Speaker(s):
- John Harp
Track and Room: Enterprise Database Administration Deployment - 108
Title: Step by Step SSIS Import Package Creation
Abstract: Go step by step to create an SSIS package to import files. This will use SSIS variables, loops, expressions, and passing variables to SQL Server. The 6 objectives covered are: 1 - Read multiple files from a folder with changing file names 2 - Import to a Raw table 3 - Include a step to clean data into a Staging table 4 - Log the file name and the number of rows imported 5 - Move the imported file to a Done folder 6 - Send an email report for each file imported
Speaker(s):
- Mike Burek
Track and Room: BI Platform Architecture, Development Administration - 105
Title: Intro to SQL Server 2016 - Always Encrypted, Masking Row level security
Abstract: In this session we will go into depth of several new security features in SQL Server 2016: Always Encrypted, Data Masking and Row Level Security just to name a few. We will discuss how the features work and demonstrate how to implement.
Speaker(s):
- Trayce Jordan
Track and Room: Enterprise Database Administration Deployment - 105
Title: Know what your machines are doing besides SQL Server! WMI,WQL,CIM and PoSH
Abstract: There’s far more happening on your Windows servers than just SQL Server, and looking at ERRORLOG won’t show you the whole story: other applications stealing your memory, OS issues, hardware errors, and more. We’ll start by looking at several different ways to collect Event Logs automatically. From there we’ll delve into WMI and WQL, which allow us to query servers (remotely or locally) to get information such as performance statistics, System and Event Logs, and even changes within SQL Server.
We’ll finish it off with two immediately-usable implementations you can set up on Monday.
Speaker(s):
- Michael Bourgon
Track and Room: Enterprise Database Administration Deployment - 106
Title: Cursors temp tables and pivots oh boy
Abstract: Will do an overview of the PIVOT and UNPIVOT functions and how to manipulate your data in really cool ways. Then we will move on to how to deal with Cursor functions and looping through data, then the joys of #tables vs @tables for your temporary table issues.
Speaker(s):
- Steve Allison
Track and Room: Application Database Development - 108
Title: Build ETL efficiently (10x) with Minimal Logging
Abstract: This session is designed to teach DBAs and developers the best strategy to transfer large data.
We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode.
Speaker(s):
- Simon Cho
Track and Room: BI Platform Architecture, Development Administration - 110
Title: SQL Server Internals
Abstract: How does SQL do what it does? Take a look under the hood at how the SQL database engine works with the storage engine. What causes those waits and where do we look to resolve them!
Speaker(s):
- Naomi Williams
Track and Room: Enterprise Database Administration Deployment - 109
Title: Agile Data Warehouse and ETL Design with Biml
Abstract: Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive presentation you’ll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use BimlScript to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.
Speaker(s):
- David Stein
Track and Room: BI Platform Architecture, Development Administration - 109
Title: Understanding SQL Server R Services
Abstract: SQL Server 2016 introduces a new platform for building intelligent, advanced analytic applications called SQL Server R Services. This session is for the SQL Server Database professional to learn more about this technology and its impact on developing and managing a SQL Server environment. We will cover the basics of this technology but also look at how it works, troubleshooting topics, and even usage case scenarios. You don’t have to be a data scientist to understand SQL Server R Services so come upgrade you career by learning more about SQL Server and advanced analytics
Speaker(s):
- Bob Ward
Track and Room: Enterprise Database Administration Deployment - 100
Title: SQL Server 2016: Data Masking and Encryption
Abstract: Learn about data masking and encryption, the pros and cons of each, as well as when to use which.
Speaker(s):
- Sean Werick
Track and Room: Application Database Development - 106
Title: Using Failover Clusters for High Availability
Abstract: As DBAs, we know that AlwaysOn AGs and Failover Cluster Instances are built on the foundation of Windows Server Failover Clustering and that HA is their goal, but have you ever seen it work? Are they a good solution for your org? Do you know if your SysAdmins can do their part? We’ll discuss these points and more, diving in under the hood of WSFC in demos and showing a few scripts to make support and troubleshooting a little easier.
Speaker(s):
- Rowdy Vinson
Track and Room: Enterprise Database Administration Deployment - 109
Title: IA-Database Development using SQL Server Data Tools projects
Abstract: In this session we will use SSDT to create and deploy a database project that includes unit tests to validate the stored procedures and post deployment scripts to insert data. We will also look at the other capabilities of SSDT like being able to refactor columns and do a schema compare.
By the end of the session, you will have the working knowledge on how to use database projects to simplify your next development project. We will also look at the different methods for deploying your changes and why one may be better than the other.
Speaker(s):
- Mark Wheeler
Track and Room: Professional Development - 100
Title: SSMS Tips and Tricks
Abstract: In this talk, we’ll go through tips and tricks to make you much more productive and efficient with SQL Server Management Studio, so that IDE does not get in your way and lets you focus on writing SQL.
Speaker(s):
- Latish Sehgal
Track and Room: Enterprise Database Administration Deployment - 105
Title: The Journey from Data to Insight
Abstract: Regardless of the tools and techniques we might employ, the fundamental task of the analyst is to turn data into business-relevant insight. This is not a simple task and not one that is fully under our conscious control. In this session, we will discuss the our current understanding of how this process works and practices analysts can employ to improve the quantity and quality of insights they produce.
Speaker(s):
- Bryan Smith
Track and Room: Professional Development - 111
Title: Deploy SQL Server with Microsoft Azure Virtual Machine
Abstract: Microsoft Azure provides multiple options to migrate SQL Server to the Cloud. But migrating SQL Server requires good understanding of the different options and the constraints. This session focuses on Microsoft Cloud option for SQL Server, how to deploy SQL Server on Azure Virtual Machine, how SQL Licensing works on Azure Virtual Machine, deploying Alwayson AG and Hybrid Cloud Scenarios.
Speaker(s):
- Bala Shankar
Track and Room: Cloud Application Development Deployment - 109
Title: Azure SQL Database v12 - Lessons learned from the trenches
Abstract: In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database on production environments. You will learn how to monitor and improve Azure SQL Database query performance. I will cover how Microsoft CSS has been using Query Store, Extended Events, Azure SQL Database Advisor and PerfStat Scripts with SQL Nexus to help customers monitor and improve query response times when running their databases in the Microsoft Azure cloud. These learnings are all fruit of CSS support cases, and customer field engagements. This session includes several demos.
Speaker(s):
- Roberto Cavalcanti
Track and Room: Cloud Application Development Deployment - 111
Title: Creating Access Web Apps with Power BI Integration
Abstract: In this session, you’ll learn how to quickly build an Access Web App within SharePoint, tour the online development environment and see a real, live working app in action. We’ll discuss sharing the app and Power BI integration. And lastly, you’ll learn the pros/cons of Access Web Apps and hybrid solutions in a corporate environment as well as how to extend the data to iPhone and Android phones. Presented by Andy Tabisz, Microsoft MVP, WorkSmart Database Masters (Michigan).
Speaker(s):
- Andy Tabisz
Track and Room: Application Database Development - 111
Title: Detecting and Preparing for Corruption
Abstract: Corruption is a scary thing, so if it happens tomorrow are you prepared for it? In this introduction we’ll look at what causes corruption and the things you can do now to be able to detect it when it happens. We’ll even see how you can implement a self healing configuration. You will also learn the different techniques for recovering from corruption. Preparation is key and you’ll be prepared to handle the situation without panic.
Speaker(s):
- Ryan Adams
Track and Room: Enterprise Database Administration Deployment - 100
Title: Getting Started With Your First SQL Server AWS RDS Migration
Abstract: Cloud Computing is all the rage but how do you get data from your on-premise SQL Server to your shiny new Amazon RDS instance? We’ll go over the various iterations and offerings of AWS, proper sizing, cost, etc. and then we’ll dive into the nitty gritty on how to migrate your data either in one shot or continuously over time.
Speaker(s):
- Matthew Brimer
Track and Room: Enterprise Database Administration Deployment - 110
Title: Kaminario - Pushing the SQL Turbo Button with All Flash Storage
Abstract: TBD
Speaker(s):
- Michael Minichino
Track and Room: Professional Development - 106
Title: Weird stuff I saw … while supporting a Java team
Abstract: After spending more than a decade completely devoted to the Microsoft stack, over the last few years I’ve been getting pulled into work supporting Java teams. Yes, sure, Java is just another language so there aren’t really and issues that are absolutely unique to the Java world. But it is a different stack, different culture, and different group of folks giving bad advice to developers … just enough different to keep life interesting. Come hear about my misadventures with server side cursors, output parameters, integrated authentication, and NOCOUNT settings.
Speaker(s):
- Rick Lowe
Track and Room: Application Database Development - 108
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Trayce Jordan
Working with SQL Server for almost 20 years, Trayce is one of the first certified masters, holding an MCM for SQL 2005 and has been working at Microsoft since 2006. Prior to joining Microsoft, he worked for a major online travel company as well as financial institutions and has served as a consultant working with companies in many different industries. His specialties include database performance tuning, operations management and support, high availability and disaster recovery.
Ryan Casey
Twitter: - @AimYourData
LinkedIn: Ryan Casey
Contact: https://www.AimYourData.com/
Microsoft Data Platform MVP, Public Speaker, and Group Moderator
SQLSaturday Speaker @ • Houston, TX 2018 • Dallas, TX 2018, 2017 (BI), 2016, 2015 • Phoenix, AZ 2018, 2017 (BI) • Kansas City, MO 2017 • Baton Rouge, LA 2017 • Oklahoma City, OK 2016 • San Antonio, TX 2016
SQL User Group Speaker @ • NTSSUG, Dallas, TX • CACTUSS, Austin, TX • OKCSQL, Oklahoma City, OK • MSBIC, Dallas, TX • SALSSA, San Antonio, TX • FWSSUG, Fort Worth, TX
AIM Business Driven Data Solutions combines the collaborative and creative arts included in Technical Communication, the business acumen of a Harvard MBA program, and the technical discipline of object-oriented programming and business intelligence (data warehouses).
Michael Bourgon
Twitter: - @mbourgon
LinkedIn: Michael Bourgon
Contact: http://thebakingdba.blogspot.com
Michael Bourgon started his IT career by performing tech support and managing Sybase databases on Unix starting in 1995, before moving to SQL Server 7… continuing all the way to SQL Server 2017. His focus on automation has led him to such diverse topics as Service Broker, WMI, Table Partitioning, Shell scripting, In-Memory Tables, and Powershell. He’s currently a senior DBA with a large healthcare company, dealing with millions of transactions of day and managing hundreds of servers. In his spare time he rides a bicycle, reads science fiction, blogs about SQL Server and Baking, and tries to raise his daughter to be a geek, too.
Stacy Gray
Twitter: - @stacylaray
LinkedIn: Stacy Gray
Contact: http://stacylaray.wordpress.com
Stacy is a leader of some of the best SQL Server Azure SQL VM support engineers at Microsoft. Her team troubleshoots and overcomes obstacles all day, every day, for the largest companies in the world. She has worked with every version of SQL Server from SQL 6.5 to now, and recently certified to be a Microsoft Specialist: Design and Implement Cloud Data Platform Solutions. An experienced speaker, she’s presented at the following SQLSaturdays: Oklahoma City, Dallas, Houston Baton Rouge.
Andy Tabisz
Twitter: - @AccessWisdom
LinkedIn: Andy Tabisz
Contact: http://www.worksmartdb.com/blog/
Andy Tabisz is a Microsoft MVP and owner of WorkSmart Database Masters based in Grand Rapids, MI. WorkSmart provides custom database and mobile solutions for small to mid-sized corporations using Access, SQL/Azure, ASP.NET, SharePoint, Power BI, Excel and integration with many technologies. Through rapid application development, WorkSmart empowers organizations to work smarter and make better decisions by automating workflow, alerts and reporting capabilities.
Ginger Grant
Twitter: - desertislesql
LinkedIn: Ginger Grant
Contact: http://www.DesertIsleSQL.com
Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.
Silvia Doomra
LinkedIn: Silvia Doomra
Silvia is a Program Manager in Azure SQL Database Team. She has experience of over 8 years in Microsoft working on different technologies like Windows Server, Visual Studio, Mobile Operators. Currently she is working in Azure SQL Database team building scale-out database technologies.
Rachael Martino
Twitter: - @RMartinoBoston
LinkedIn: Rachael Martino
Rachael has been both an IT Executive and a Consultant. Systems training, data based application development experience and leadership training have prepared her to build stable. maintainable and successful solutions.
Rachael has been in the industry working with SQL Server since SQL 2000. She started out her IT life as an application developer and lead a team of developers, creating data centric applications using SQL Server and Oracle. She has worked in the Business Intelligence field using SSAS, multi-dimensional and Tabular, SSRS, SSIS, and PowerBI. She has two Masters degrees from MIT, Systems Design and Management amp; Civil Engineering Information Technology. Her interests surround the Big Data and Data Science areas.
Steve Allison
Contact: http://steve.evengame.com
I am a long time IT person who started programming in 1976 with my father. I started with Basic on a TI994A, TV on Channel 4 as the monitor and my cassette player as my hard drive. I grew into Microsoft Basic and text files for data in the 80#39;s, ASP, Access, Excel, and Visual Basic in the 90#39;s, and in the 2000#39;s I did MySql and MSSql and moved the front end to Coldfusion platform. I have moved my apps to web based and build most everything in JQuery, Coldfusion, Coldbox, and MSSql for the db.
David Stein
Twitter: - @Made2Mentor
LinkedIn: David Stein
Contact: http://www.Made2Mentor.com
David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.
Simon Cho
LinkedIn: Simon Cho
Contact: http://simonsql.com
Simon Cho is one of the founders of SQLAngeles.com, which is a Los Angeles Korean Tech PASS community group.
As a Local Group leader, he is a Microsoft SQL community speaker. He has presented many times at SQLSaturdays and to PASS Local Groups.
He moved his passion to VISA Inc, the largest credit card provider in the world, where he used database technology to build a strong solution and a secure environment, with new strategies and features to maintain thousands of SQL Servers.
He has now joined the Nowcom Corp, as a Director of DevOps, where he leads the DevOps team and DBA team.
He is pretty much working on SQL server running on kubernetes.
Naomi Williams
Twitter: - naomithesqldba
LinkedIn: Naomi Williams
Naomi Williams is a SQL Server professional working in the San Antonio area. Currently a seasoned Database Administrator for both Oracle and SQL Server doing database development, SSIS, SSRS and SSAS. Naomi has been working with SQL Server for almost 15 years. Naomi is passionate about performance, high availability, and creative non standard solutions to complex problems
Kris Hokanson
Kris has been building databases for over 20 years. Since SQL Server 7 he’s been looking for ways to shave a second (or an hour) off any query he comes across. His work experience ranges from small construction firms to fortune 200 Oil amp; Gas corporations. He has designed and administered everything from 10 MB single user databases to enterprise data warehouses using SQL Server and SSIS to consolidate data from hundreds of disparate ERP systems.
Ryan Adams
Twitter: - @ryanjadams
LinkedIn: Ryan Adams
Contact: http://www.ryanjadams.com
Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.
Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.
Chris Shaw
Twitter: - @SQLShaw
LinkedIn: Chris Shaw
Contact: http://chrisshaw.wordpress.com/
Chris Shaw started his database career in 1993. Following the Marines, Chris continued working with databases for companies such as Wells Fargo, Pulte Mortgage, and Yellow Pages Inc. Chris has been writing and speaking about SQL Server for over 15 years at events such as SQL Connections, PASS Summit, and SSWUG Ultimate conferences. Chris received his 5th Microsoft MVP award.
Bob Ward
Twitter: - bobwardms
Contact: http://aka.ms/bobsql
Bob Ward is a Principal Architect for the Microsoft Azure Data SQL Server team, which owns the development for all SQL Server versions. Bob has worked for Microsoft for 26+ years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2019 including Azure SQL. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, and performance at events such as PASS Summit, Red Hat Summit, Microsoft Ready, SQLBits, SQLIntersection, Microsoft Inspire, and Microsoft Ignite. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the books Pro SQL Server on Linux and SQL Server 2019 Revealed available from Apress Media. Twitter: http://twitter.com/bobwardms.
Bryan Smith
LinkedIn: Bryan Smith
Bryan is a Data Solution Specialist with Microsoft Las Colinas, focused on data-driven solutions in the Azure cloud. He also teaches analytics technologies within the MBA amp; MSBA programs at SMU Cox School of Business.
Daniel Janik
Twitter: - @SQLSME
LinkedIn: Daniel Janik
Contact: http://www.sqltechblog.com
Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQLSaturdays.
John Harp
Twitter: - @sekainohaten
LinkedIn: John Harp
With 17 years in the technical support field and more than a decade working with Microsoft SQL Server, John has seen some of the weirdest errors and most spectacular failures SQL Server can generate. And he#39;s solved most of them, with a little help from his friends in the SQL Server Community. John is the Technical Support Manager for Idera#39;s SQL Server Products.
Anthony van Gemert
Anthony has more than 14 years in IT leadership positions, including 8 years of program management with Microsoft leading and managing diverse teams globally. He currently works with the SQL data systems engineering team on SQL Stretch database, part of the SQL Server 2016 release. His focusing on front end UX, customer engagement, and the upgrade experience.
Stan Geiger
Data Architect and BI Architect. Experience building Data Warehouse and ETL platforms, BI Analytics and OLTP systems. He is currently a Director of Product Manager at Idera, responsible for the development of the multi-platform tools.
Mike Burek
Twitter: - mikeburek
LinkedIn: Mike Burek
Contact: http://tikiwiki.mikeburek.com
He started by building a complete computerized inventory management system for a multi-state store. Next, he managed Texas Medicare and Medicaid claim data to keep it processing, and building new monitoring metrics. Afterwards, he processed and analyzed marketing data on tens of millions of customers and sent hundreds of millions of multi-lingual marketing messages worldwide. Upgrading those marketing skills, he then worked to process and query tune marketing data for tens of thousands of worldwide enterprise customers, bringing in tens of millions of dollars per campaign. Now he monitors database servers to keep them running well, tunes queries, and helps businesses build new ETL processes. He also runs the Austin, TX user group.
Mike Byrd
Twitter: - ByrdNest_TX
LinkedIn: Mike Byrd
Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com
Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.
Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.
Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).
Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd
George Govantes
LinkedIn: George Govantes
SQL Architect and Senior SQL Database Administrator with over 20 years of experience turned Chief Information Security Officer, Certified Information Security Manager, and Governance Risk and Compliance Certified Professional that helps organizations develop cloud and on-prem Identity and Information Security programs. He also trains and consults in the area of IT leadership and the development of high-performance teams.
Latish Sehgal
Twitter: - latish
Contact: http://www.dotnetsurfers.com
Latish is a .NET Principal Consultant with Improving Enterprises and very passionate about software development and solving customer problems. He also created SqlSmash, a productivity plugin for SSMS. He can be reached via his blog at http://www.dotnetsurfers.com/ or twitter (http://twitter.com/latish).
Sean Werick
LinkedIn: Sean Werick
Contact: http://www.seanwerick.com
I have been in the data industry for 15 years, specializing in Microsoft business intelligence for the last decade. I have architected, developed and integrated end to end solutions for customers in various sectors including finance, government, health care and retail. I am extremely passionate about data and the endless possibilities for companies utilizing it in the best ways. I enjoy data science and business intelligence because the possibilities and magnitudes of impact are immeasurable.
Konstantin Melamud
Twitter: - @kmelamud
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQLSaturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
Mindy Curnutt
Twitter: - @sqlgirl
LinkedIn: Mindy Curnutt
Contact: http://www.mindycurnutt.com
Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.
William Wolf
Twitter: - sqlwarewolf
LinkedIn: William Wolf
Contact: http://www.sqlwarewolf.com
Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQLSaturday veteran speaking at nearly 40 SQLSaturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.
Chris Shaw
Twitter: - @SQLShaw
LinkedIn: Chris Shaw
Contact: http://chrisshaw.wordpress.com/
Chris Shaw started his database career in 1993. Following the Marines, Chris continued working with databases for companies such as Wells Fargo, Pulte Mortgage, and Yellow Pages Inc. Chris has been writing and speaking about SQL Server for over 15 years at events such as SQL Connections, PASS Summit, and SSWUG Ultimate conferences. Chris received his 5th Microsoft MVP award.
David Stein
Twitter: - @Made2Mentor
LinkedIn: David Stein
Contact: http://www.Made2Mentor.com
David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.
Roberto Cavalcanti
LinkedIn: Roberto Cavalcanti
Roberto Cavalcanti is a Sr. Support Escalation Engineer with the Microsoft CSS Azure SQL Database support team. He is a database specialist with over 20 years working in the database industry. Since joining Microsoft CSS SQL Escalation team in 2008, Roberto has been passionate about customer support. He has been supporting Azure SQL Database since 2010, when it was still called SQL Azure. Roberto has written many articles about Azure SQL Database for MSDN/TechNet, SQL Magazine, and has been a speaker in internal and external events such as TechReady, Microsoft Insights/TechEd, and has delivered SQL training to many Microsoft SQL Support Engineers in multiple countries.
Rowdy Vinson
Twitter: - https://twitter.com/RowdyVinson
LinkedIn: Rowdy Vinson
Reformed SysAdmin with 15 years in IT. I’m a geek at heart and enjoy 3d printing, gardening, and Minecraft in my free time.
Sri Sridharan
Twitter: - @sqlrocks
Contact: http://sqlrocks.com
Sri is the President of North Texas SQL Server User Group. Sri has been involved with SQL Server since version 4.2 and has held various roles developer/dba/ architect / pre-sales over the years. He is largely responsible for some of few features in SQL 2008 like TDE and tools like MAPS. Sri holds a Bachelor’s Degree in Physics , Masters in Computer Information Systems and an MBA in Finance. His wife Hema, made sure he got a 3rd Masters in parenting their 2 sons.
Lance Tidwell
Twitter: - @Lance_LT
Contact: http://lancetidwell.com
Lance Tidwell, from the Austin, TX, area, has worked as a SQL Server DBA for the last 11 years. During his time as a DBA he has found his passion for all things SQL, but specifically for performance tuning. He has a life-long quest to always be learning new things; currently this quest has lead him to explore more about the Data Analytics/ Data Science areas.
Bala Shankar
Bala is a Senior Escalation Engineer in the Microsoft Data Platform support team in Dallas, Texas. Bala has worked 11 Years at Microsoft supporting SQL Server stretching back to SQL 7.0. He has interacted with many large SQL Server deployments on various component of SQL Server like the database engine, performance, replication and Azure. Bala is the lead for SQL Server on Azure Virtual Machine within Microsoft Support.
David Klee
Twitter: - kleegeek
LinkedIn: David Klee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
Jared Nielsen
Twitter: - https://twitter.com/FUZIONAgency
LinkedIn: Jared Nielsen
Contact: http://www.FUZIONAgency.com
Rather than accepting the status quo, I believe in learning everything, and nothing, and mixing it all together until you have a strange, unique and ethereal blend of technology, marketing, knowledge, wisdom, creativity, passion, charity, caring, and humility. I think that being uncategorizable is the goal since life is the voyage, not the destination, so too should work be that extension of the undefinable so you
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.
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.
John Sterrett
Twitter: - JohnSterrett
LinkedIn: John Sterrett
Contact: https://johnsterrett.com/community/
John Sterrett is a MCSE: Data Platform, Principal Consultant, and the Founder of Procure SQL LLC. John has experience presenting at community events, including Microsoft Ignite, PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturdays, PASS Chapters, and Virtual Chapter meetings. John is a leader of the Austin SQL Server User Group and is the founder of the HADR Virtual Chapter. John’s community activities can be found at https://johnsterrett.com/community/
Ryan Adams
Twitter: - @ryanjadams
LinkedIn: Ryan Adams
Contact: http://www.ryanjadams.com
Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.
Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.
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.
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.
Lori Edwards
Twitter: - www.twitter.com/loriaedwards
LinkedIn: Lori Edwards
Contact: http://www.sqlservertimes2.com
Lori Edwards currently holds the position of Solutions Engineer for SentryOne. Prior to working with SQLSentry, she spent 11 years working as a production DBA. She also has volunteered for PASS since 2009 on the Program Committee, ERC, Nomination Committee and speaking at SQLSaturdays.
Matthew Brimer
Twitter: - @sqlcenturion
LinkedIn: Matthew Brimer
Contact: http://www.sqlcenturion.com
Matthew Brimer has 10 years experience with SQL Server, 3 of which was spent as a Database Security expert for a Department of Defense Agency and 5 as the Database/Security Manager for a leading Pharmacy Services Company. These days Matt can be found helping customers get the most out of the Databases/Servers/Networks as a Consultant for InterWorks. Matt also holds several Security and Microsoft Certifications, is the President of OKC SQL PASS Chapter and is the former Event Chair for SQLSaturday Oklahoma City.
Mark Wheeler
LinkedIn: Mark Wheeler
I have been working with SQL Server for 20+ years. SQL Server has come a long way in that time. My current role is helping clients implement solutions on various versions of SQL Server either as a BI or application database developer .
In my off time, I enjoy the peace and quiet of scuba diving.
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.
Louis Mangiacapra
Twitter: - https://twitter.com/tamulou24
LinkedIn: Louis Mangiacapra
Louis Mangiacapra is a business intelligence consultant with a variety of experience in consulting and industry. He has demonstrated the ability to incorporate business intelligence with enterprise architecture and integration. With his diverse experience of both business and IT functions, he has a great ability to act as a liaison to understand business requirements and apply it to a technical audience. Louis has worked in a variety of industries including insurance, banking/credit unions, retail, and education
Bob Ward
Twitter: - bobwardms
Contact: http://aka.ms/bobsql
Bob Ward is a Principal Architect for the Microsoft Azure Data SQL Server team, which owns the development for all SQL Server versions. Bob has worked for Microsoft for 26+ years on every version of SQL Server shipped from OS/2 1.1 to SQL Server 2019 including Azure SQL. Bob is a well-known speaker on SQL Server, often presenting talks on new releases, internals, and performance at events such as PASS Summit, Red Hat Summit, Microsoft Ready, SQLBits, SQLIntersection, Microsoft Inspire, and Microsoft Ignite. You can follow him at @bobwardms or linkedin.com/in/bobwardms. Bob is the author of the books Pro SQL Server on Linux and SQL Server 2019 Revealed available from Apress Media. Twitter: http://twitter.com/bobwardms.
Michael Minichino
LinkedIn: Michael Minichino
Michael Minichino is a pre-sales SA supporting the TOLA region of the US for Kaminario. Michael has worked in Information Technology for over 23 years in both leadership and individual contributor roles. Prior to Kaminario he worked for Oracle in a pre-sales role in the Engineered Systems group serving as a database and storage specialist. He has also worked for the Oracle Platinum Partner Actifio as a database and DevOps pre-sales consultant. Prior to Oracle and Actifio he worked for HP as a pre-sales Enterprise Architect. However he has spent most of his career as a technology consumer in IT manager and director roles with both small and large organizations.
Steven Ormrod
Twitter: - @DBOrmrod
Contact: http://stevenormrod.com
Steven Ormrod is a Database Administrator. He focuses on high-availability and clustering, with a dash of performance tuning thrown in for fun. His environments consist of hundreds of servers spread across multiple countries. He is on the board of directors for the Austin, Texas PASS Chapter and speaks at user groups and SQLSaturdays. Steven holds a BS in Computer Science and a Masters of Education. He is a SQL Server MCM.
Russel Loski
Twitter: - sqlmovers
LinkedIn: Russel Loski
Contact: http://www.sqlmovers.com
Russ Loski is a SQL Server BI Developer based in Dallas-Fort Worth. He current works as a Data Analytics Engineer for Navisite, a remote managed IT services company. Twenty years ago, he began working with SQL Server 6.5. He has since continued to develop applications connected to all of the versions of SQL Server. He has worked with clients in industries from insurance to healthcare, from movie theaters to American football. Russ is a regular speaker at SQLSaturday events, as well as the SQL Server Users Groups in the North Texas region. Russ likes working with data in various shapes.
Sponsors
The following is a list of sponsors that helped fund the event: