SQLSaturday #514 - Houston 2016

Event Date: 05/14/2016 00:00:00

Event Location:

San Jacinto College - South Campus
13735 Beamer Rd
Houston, Texas

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

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: So what does it really take to get to four nines

Abstract: As ones responsibilities grow as a senior Database Administrator many more factors come into play to achieving both the realities and perception of high availability. The building of professional relationships, managing expectations, helping with setting standards and procedures are all critical components to success. While some Database Administrator will argue this is out of my scope of responsibilities why should I care about building of professional relationships, managing expectations, helping with setting standards and procedures? The answer is simple because the perception is that no matter where the process breaks down it’s always a database problem. Managing customer expectations what do you really mean by 99.99% up time, Translating business requirements to operational realities, commonly overlooked items that impact your 4 nines Avoiding human errors the realities and perception of high availability.

Speaker(s):

George Govantes

Track and Room: Strategy and Architecture - 149

Title: Overview of Security Investments in SQL Server 2016 and Azure SQL Database

Abstract: Join me for an overview of the most recent security investments for SQL Server 2016 and Azure SQL Database in the areas of encryption, data filtering and data masking. I will showcase a real-life user scenario with examples and demos of Always Encrypted, Row Level Security and Dynamic Data Masking. The demos include a real working .NET application with source code for testing. This is based on the session and demos I co-presented with Microsoft at SQL Summit 2015 so if you missed Summit or the presentation and are interested in learning what Microsoft is doing in the area of security in SQL Server 2016 and Azure SQL DB then this is the session for you.

Speaker(s):

Jamey Johnston

Track and Room: Enterprise Database Administration Deployment - 113

Title: Introduction to R and Data Science Tools in the Microsoft Stack

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, how to access and manipulate data, install packages, create and use variables, use control flows and some basic graphing and statistical analysis. We will finish with a very brief introduction of how R integrates in Azure ML, Power BI and SQL Server.

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 to Data Science!

Speaker(s):

Jamey Johnston

Track and Room: Analytics and Visualization - 113

Title: Designing Stored Procedure Solutions

Abstract: With a little T-SQL experience, you can create a stored procedure that completes a task. But it’s harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about:

Asking the right questions to set yourself up for success Making the case for stored procedures over ad hoc code and other objects Pro tips for standardization and cross-version compliance Reevaluating and expanding on your solution Limiting inputs to reduce unexpected behaviors and errors Choosing between alternate solutions Evaluating for performance

This session is for data professionals who can write T-SQL, but haven’t spent a lot of time in SQL development.

Speaker(s):

Jennifer McCown

Track and Room: Application Database Development - 147

Title: Introduction to Biml

Abstract: Have you ever needed to generate dozens (or even hundreds) of similar SSIS packages? Do you ever find yourself needing to regenerate a lot of packages when some piece of the upstream data format changes? Using native SSIS, this can be a tedious and error prone exercise. However, using Biml (Business Intelligence Markup Language) can greatly increase your productivity as an ETL developer.

In this session, we’ll cover the essentials of Biml. I’ll discuss what it is and what it can do for SSIS, demonstrating how it can easily generate dozens or even hundreds of packages in just a few minutes. I’ll also demonstrate some realistic examples and discuss how Biml fits into the enterprise ETL picture.

Speaker(s):

Tim Mitchell

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

Title: Making the Most of the SSIS Catalog

Abstract: Managing the SQL Server Integration Services (SSIS) ecosystem became significantly easier with the addition of the SSIS catalog in SQL Server 2012. The SSIS catalog offered many new features that made often-laborious tasks such as logging, parameterization, and variable collections much easier to develop and manage. For the SSIS developer as well as the operations staff in charge of day-to-day package execution, using the SSIS catalog helps to make their jobs easier by eliminating several tedious and error-prone processes.

In this session, we will survey and demonstrate many of the useful features of the SSIS catalog. We will discuss the structure of the catalog and review how it changes the way we interact with deployed packages in SSIS. We will also demonstrate how parameters and SSIS environments help to ease the burden of supplying runtime configuration values to packages. In addition, we will demonstrate how package logging is a far simpler exercise in the new SSIS catalog.

Speaker(s):

Tim Mitchell

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

Title: Profiler is Dead! Long Live Extended Events!

Abstract: Did you know that Profiler and SQL Trace are deprecated? I know it still works (even in SQL Server 2016 CTP2), but it will never be updated with the latest features. In fact it will never be updated at all! That means if you want to capture information about any new feature, from version SQL Server 2012 and beyond, you need to use another tool. That new tool is Extended Events (XE). Not only has it replaced Profiler, and can be used to capture information on all new features, but it is a substantially better tool! In this session we will discuss the architecture of Extended Events, how to setup a new trace from scratch or convert an existing Profiler trace, and the new abilities that never existed in Profiler. We will also cover the difference in overhead cost of Profiler and Extended Events.
Profiler was a friend of mine, but it is time to embrace the new king!

Speaker(s):

Keith Tate

Track and Room: Enterprise Database Administration Deployment - 115

Title: Gen2016™ and the Global “Hybrid” Cloud

Abstract: THEME: Like it or not, our industry is driving the world to Gen2016™ {Windows 2016, SQL Server 2016, Azure, etc.,} technologies. This GENeration shift is filled with buzzwords, that hover around or land-on “HYBRID Cloud”. Hint: HCCUG.org has been speaking, for many years, about “Hybrid Cloud” and its “Global” perspective/implications/offering, (e.g., the free-ish offerings in US/China/EU).

#171;#177;#187; SESSION: The focus is on Data (e.g., Big Data Small Data) in the Gen2016™ “Global Hybrid Cloud” offerings from both Microsoft and non-Microsoft – as it appears at this point-in-time/May2016. This is a Level-100 session (no pre-requisites), and is for those who want a jump-start on Gen2016™ offerings, irrespective of whether you are just getting started in the industry, and/or retooling/realigning/revamping your skill set.

#171;#177;#187; NOTE: The presenters, Tex (20+ year technologist) and Zane (budding technologist), are with Hybrid Decisions#174; Corp and are presenting on behalf of HCCUG.org

Speaker(s):

Anthony {Tex} Moreign

Track and Room: Cloud Application Development Deployment - 142

Title: Actively Proactive – Straightforward Ways to Manage and Diagnose SQL

Abstract: Becoming a proactive DBA is something that most SQL administrators strive to be but many fall short. Meetings, doing non-SQL related tasks, excessive workload and sometimes corporate culture often work against a DBA by creating conditions where it is nearly impossible to pay attention to the tasks involved in taking care of your SQL instances. Our presentation will cover those proactive tasks and alerts that will provide a straightforward method of ensuring that maintenance and monitoring are working for all SQL instances you are responsible for. Additionally, we will cover some ways to identify emergency performance problems that will allow a DBA to quickly resolve issues while making them look like the expert they truly are.

Speaker(s):

Lori Brown

Track and Room: Enterprise Database Administration Deployment - 115

Title: Monster Text Manipulation: Regular Expressions for the DBA

Abstract: Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures, filled with table variables, instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cut that work from hours or days to minutes or even seconds. Stop writing code manually and let regular expressions do it for you. Learn: • The most useful regular expression commands • The appropriate times to use regular expressions • How to use regular expressions to write code for you • How to incorporate regular expressions into large tasks and combine them with other methods

Speaker(s):

Sean McCown

Track and Room: Enterprise Database Administration Deployment - 115

Title: Simple Fun Modeling with SQL Server

Abstract: Ever want to grow your own data? Or test out simple algorithms? Explore the process with me in a fun easy to follow demonstration. We will build a simple population growth engine that feeds a report on a web page.

Speaker(s):

Dane Schilling

Track and Room: Application Database Development - 147

Title: Who’s Afraid of Entity Framework?

Abstract: Do any applications in your environment use SQL written not by a person but by the application itself? No, the system isn’t self-aware. Chances are it is using the Microsoft Entity Framework (EF).

EF and other object relational mapping technologies have been a boon for developers. But is EF a technology that developers should even be using? This session reviews what EF is and how it’s changed over time. We’ll also dive into how it works and what to look for when inspecting a database generated by EF Finally, we’ll review EF-generated T-SQL and give some tips on how to improve performance. If you’re a data professional who manages databases that are accessed through EF or want a basic knowledge of how EF works, this session is for you.

Speaker(s):

Richie Rump

Track and Room: Application Database Development - 148

Title: Introduction to Microsoft Mobile Reporting

Abstract: This is a must attend session for every data professional. Join me as I provide an overview of Microsoft Mobile Reporting, Microsofts newly acquired on-premises mobile BI solution. Mobile Reporting is optimized for SQL Server and designed to enable rapid development and publishing of business intelligence in a way that delivers premium user experience on any device. In this session I will provide an overview of Mobile Reporting, discuss its key features, provide an architectural overview and finally demonstrate how to author and publish dashboards.

Speaker(s):

Patrick LeBlanc

Track and Room: BI Information Delivery - 141

Title: Secure your sensitive data with Always Encrypted

Abstract: Data security is a major concern for organizations especially when they start to explore cloud-based data options. Microsoft is enhancing security options in almost every major release of SQL Server. In SQL Server 2016, Microsoft has implemented “Always Encrypted” option which is quite different from previously available options including TDE. It is encryption of data not only at rest, but also in use and in transit. We will have a deep discussion about this new end-to-end data encryption feature which can be implemented without any code change on application side for both on premises and cloud SQL Server databases.

Speaker(s):

Faheem Ismat

Track and Room: Enterprise Database Administration Deployment - 117

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 - 148

Title: The Life Cycle of a Query in Virtual Reality

Abstract: How would you like to learn about using Virtual Reality (VR) to present information? The ability to become immersed and walk around inside of a VR environment is a new and unique way to present and look at information. As data professionals we need to be open to novel displays of data and explore what VR can do that for us that we have not been able to do in the past. VR can provide a way for people to see relationships and interact among data sets which can be difficult for computers to display visually on a flat screen.

The Life Cycle of a Query in Virtual Reality is built using Epic Games video game engine called Unreal Engine 4 (UE4). With native support for VR, UE4 has been used for applications beyond just video games. With the commercial availability of affordable VR headsets, data professionals can now create visually compelling environments that were almost impossible or extremely expensive just a few years ago on both PC and mobile devices.

Speaker(s):

Todd Kleinhans

Track and Room: Information Delivery - 149

Title: Analyze your query plan like a Microsoft Engineer! (SQL 2016 Edit

Abstract: This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the “noteworthy” query plan patterns that go beyond the normal areas that customer tend to investigate. This session covers SQL Server 2005 forward and includes the new SQL Server 2016 Query Store and Live Query Statistics.

Speaker(s):

Daniel Janik

Track and Room: Application Database Development - 148

Title: SQL Omphaloskepsis: Enlightenment and Productivity Using System Tables

Abstract: Codd’s 4th rule for relational databases requires the database structure to be accessible within the database with the normal query tools. Turning SQL back on the database is a powerful technique that can yield productivity gains whether you are an analyst, a developer, or a DBA. This talk is designed to share information, techniques, and code examples for using the system metadata for reporting, management, and code generation. Get comfortable with where to find useful information. Understand common query patterns and use cases. Learn useful functions, coding tricks, and how and when to leverage dynamic code.

Speaker(s):

Brian Dudley

Track and Room: Application Database Development - 147

Title: Beginning Azure

Abstract: The cloud is here! Are you ready? Microsoft, Amazon and others are all vying for your cloud attention. In this session, we will review the different types of cloud platforms available and what they mean to you. We will pay close attention to Microsoft’s Azure platform that offers two hosting solutions. What are these hosting options and what are the differences between them? Most importantly, how do I get started with all of this cloud business? Let’s put SQL Server into the cloud!

Speaker(s):

Thomas Norman

Track and Room: Cloud Application Development Deployment - 142

Title: How answers.microsoft.com Overcame the key Challenges of Upgrading to SQL S

Abstract: As part of the company’s “Get Current/Stay Current” initiative, Microsoft’s IT organization planned to upgrade its community website, answers.microsoft.com from Microsoft SQL Server 2008 to Microsoft SQL Server 2014. At the same time, the site adopted virtualization and needed to maintain the zero downtime environment the group had built with mirroring. Given the site spans four data centers across the globe and supports more than 1.7 million visitors a day, Microsoft cannot afford downtime, not even for maintenance. This case study shares best practices for upgrading to SQL Server 2014, highlights the technologies Microsoft considered to enable continuous availability, and details how the site leveraged AlwaysOn without making application changes.

Speaker(s):

Dave Wiley

Track and Room: Enterprise Database Administration Deployment - 117

Title: Tintri SQL Sentry – Optimizing Your Virtualized Workload

Abstract: Come learn how Tintri and SQL Sentry can take the risk and guesswork out of virtualizing SQL databases. Tintri Virtual-Aware Storage (VAS) systems blend the predictable performance of solid-state disk (SSD), per-VM Quality-of-Service (QOS) and superior analytics to empower DBAs to confidently deploy even the most demanding enterprise applications with ease. Tintri makes complex database management tasks like cloning, backup/recovery, and test/dev refreshes a breeze through software automation that eliminates error-prone, manual processes. With the recent partnership between Tintri and SQL Sentry, DBAs can monitor specific performance metrics of their Tintri devices within SQL Sentry Performance Advisor. Visit our booth and attend our lunch session to see Tintri and SQL Sentry in action.

Speaker(s):

Victor Gentry

Track and Room: Enterprise Database Administration Deployment - 147

Title: Understanding Backups

Abstract: One of the most important functions a DBA can perform is the backup. And far too many DBAs rely on the wizard to perform this task. Here I’ll take you through everything you need to know about understanding command line backups, writing backup routines, and making the right decisions on how to do what kind of restore and when. I will take you through basic backup syntax and fully explain how things work the way they do and why. If you ever wanted to understand the ins and outs of SQL Server backups then this session will give you what you’re after.

Speaker(s):

Sean McCown

Track and Room: Enterprise Database Administration Deployment - 115

Title: Codd’s Rules, Normal Forms, and SQL Anti-Patterns - Recognition Repair

Abstract: In 1970 E.F. Codd presented a seminal set of ideas now known as the Relational Model of Data. Revolutionary for its time, these notions would give rise to many of the database engines of today including SQL Server. Too many software developers and database designers though are unfamiliar with these ideas or do not know how to effectively apply them. This presentation reviews Codd’s rules and the relational normal forms; explains the differences between the relational model of data and the SQL database engines these ideas inspired; identifies some of the SQL anti-patterns that avoidance of these rules and normal forms gives rise to; and discusses both technical and organizational strategies for improving existing applications and their associated database designs and implementations.

Speaker(s):

Ken Clement

Track and Room: Application Database Development - 148

Title: What’s New in SSRS 2016

Abstract: It’s been 10 years SQL Server Reporting Services has been updated. Hey Microsoft, what’s the hold up? Well the wait is over. Join me in this demo-heavy session where I will discuss and demonstrate all the new features of SSRS, from custom parameter layouts to pinning reports to Power BI.

Speaker(s):

Patrick LeBlanc

Track and Room: BI Information Delivery - 141

Title: A Choice Performance Tuning

Abstract: We don’t just throw resources to a server until we can prove it is going to be utilized. I was often asked how to know and when the SQL Server system needs additional hardware resources? or we can trim down the excessive usage of resources? It is a choice of judgement from experiences. The optimization goal is not to waste system resources but maintain database best performance. In this session, let me share with you my many years of experiences and show you the general rule of thumb to performance tuning. We will go over the following topics of discussions for typical scenarios that applies to SQL Server generally (not a specific version). The take-away is you would understand better what to do to help your SQL Server reach optimal performance and proactively prevent problems.

CPU: Memory: IO: Storage: SQL Server Default configuration: Development Design: Index: Performance T-SQL: Monitoring and Diagnosis: Demo: http://dbace.us

Speaker(s):

Jason Wong

Track and Room: Enterprise Database Administration Deployment - 117

Title: SQL Server Statistics – What Are The Chances?

Abstract: For far too long, I thought that statistics only contained information on table row counts. While they do contain that information, there is more to it than that. In this beginner session, we’ll go over statistics – how they are created, the different types of statistics that exist, how they’re maintained and how the Query Optimizer uses them. We will also touch on system tables and DMVs that will provide additional information on your statistics. We’ll also go over the cardinality estimator changes in 2014. At the end of this session, you should have a better idea of how the query optimizer within SQL Server makes decisions on how to gather data.

Speaker(s):

Lori Edwards

Track and Room: Enterprise Database Administration Deployment - 117

Title: “Transform into a Data-Driven Organization”

Abstract: Do you like Power BI – but your company is not ready to move to the CLOUD? Does your organization need a platform that will provide agility, speed, and scalability without sacrificing governance and security? Do you want to allow your business users to build Tabular models on the fly, or connect to your multi-dimensional cubes - and visualize them immediately? Come and learn from Matt White about Version 6 BI Office from Pyramid Analytics, an end-to-end platform that enables people across your organization to have governed access to trusted data—to form insights, collaborate freely, and make better data-driven decisions.

Speaker(s):

Matt White

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

Title: Watch Brent Tune Indexes

Abstract: You’re not starting from scratch - you have a database that’s already in production, and you can’t make too many changes to the app. You want to make it go faster with as little danger and disruption as possible. You’re comfortable writing queries to get the data you need, but you’re not so confident when it comes to picking the right nonclustered indexes. How many should you have? What fields should they be on?

In this session, you’ll learn Brent Ozar’s easy one-hour process to:

Review the indexes you’ve already got
De-duplicate your indexes to make inserts/updates/deletes go faster
Find the right nonclustered indexes you need
And use simple, free scripts that give you all the answers

Speaker(s):

Brent Ozar

Track and Room: Application Database Development - 149

Title: Change Tracking: A Near Bullet-Proof ETL Synchronization Control

Abstract: Change Tracking came out with SQL Server 2008, but SS2012 almost eclipsed it with Change Data Capture. Change Tracking is now the red-headed step child, but in many cases may be a better solution for data ETL movement from an OLTP database to a data warehouse database. This session will provide a review of change tracking syntax and implementation with detailed demos. It will then dive into an actual ETL subset implementation from the AdventureWorks database to a data warehouse solution (modified AdventureWorksDW) with detailed code discussion and demos.

Speaker(s):

Mike Byrd

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

Title: SQL Server Permissions and Security Principals

Abstract: A ground-floor introduction to SQL Server permissions starting with the basics and moving into the security implications behinds stored procedures, views, database ownership, application connections, consolidated databases, application roles and more. This class is perfect for DBA’s, developers and system admins.

Speaker(s):

William Assaf

Track and Room: Application Database Development - 148

Title: The Ins and Outs of Partitioned Tables

Abstract: As data rates continue to increase, databases are growing in size. One tool used to tame large database is table partitioning. It can speed ETL processes and simplify maintenance. This talk covers the What, Why, and How of Partitioned tables. Learn how to set them up, query and maintain them, and handle common ETL use cases.

Speaker(s):

Brian Dudley

Track and Room: Application Database Development - 147

Title: Row-level Security in SSRS and SSAS

Abstract: It is relatively straight-forward to grant a user access to a particular SSRS report, multi-dimensional cube, or tabular model table, but what happens when the user needs access to the object but should be denied access to view certain rows of data? In this session we’ll investigate a real-world solution to this common BI problem.

Speaker(s):

Chris Hyde

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

Title: What’s new in SQL Server 2016

Abstract: Join us for lunch and learn about the exiting new features coming in SQL Server 2016.

Speaker(s):

Mark Moore

Track and Room: Information Delivery - 113

Title: SQL Server Defaults SUCK!!

Abstract: If you just click next-next-next and think you have a good-to-go SQL Server THINK AGAIN!! :-) There are umpteen things you just GOTTA change right out of the box if you want your potentially very expensive and always precious SQL Server resource to perform and behave optimally. This session will cover a laundry list from High Power Setting to data file growth and many useful items in between.

Speaker(s):

Kevin Boles

Track and Room: Enterprise Database Administration Deployment - 113

Title: Performance Tuning SQL Server with sp_AskBrent#174; and sp_BlitzCache#174;

Abstract: You’ve already got a SQL Server application in production, and users are complaining about speed. You need to find the bottleneck as quickly as possible, and identify which queries are causing that bottleneck. In this session, you’ll learn how to use free tools to quickly analyze your server’s performance and pinpoint exactly which queries need to be tuned.

This session is for developers and DBAs who can change queries and indexes on their servers to speed up performance.

Speaker(s):

Brent Ozar

Track and Room: Application Database Development - 113

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 - 142

Title: A new paradigm for workload analytics in SQL Server

Abstract: In this session, you will learn how to utilize Foglight’s Performance Investigator to analyze and determine the root causes to SQL Server performance issues created by transaction workload. We will discuss the new monitoring architecture used as well demonstrate use-cases that allow for forensic-level analysis of real-time and historical data. Focus areas such as deep-dive lock analysis; comparing workload between time periods and instances; as well as change tracking for database configuration, objects execution plans and system configuration to quickly see the impact on database performance will be showcased during this session.

Speaker(s):

Amit Parikh

Track and Room: Other - 148

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 - 115

Title: Cisco UCS, Optimal Platform for SQL Server

Abstract: Features and capabilities of Cisco UCS, and how these benefit the deployment and administration of SQL Server.

Speaker(s):

Robert Moore

Track and Room: Enterprise Database Administration Deployment - 117

Title: Indexing Deep Dive

Abstract: Another in TheSQLGuru’s very popular “Deep Dive” series, this time covering indexing. You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes. We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes. There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.

Speaker(s):

Kevin Boles

Track and Room: Application Database Development - 113

Title: Scale out SQL Server PaaS in Azure Elastically

Abstract: You have heard all the hype how the cloud can help you scale your databases horizontally, providing you limitless capacity, but how do you do that? In this presentation we will take a look at the Elastic Database tools. We will focus on the key use cases for shard map management, data dependent routing and multi-shard querying.

Speaker(s):

Shawn Weisfeld

Track and Room: Cloud Application Development Deployment - 142

Title: Transform Database Agility with XtremIO

Abstract: All-Flash Arrays deliver IOPS in abundance. XtremIO goes further to provide predictable, consistent sub-millisecond latency and unleash agility for your SQL Server databases. Our unique XtremIO Virtual Copies (XVC) capabilities allow for fully writable copies for production, test/dev, reporting/analytics workloads on our market leading consolidation platform. This allows for consolidation of your SQL Server based environments onto a single array to maximize efficiency.

Speaker(s):

Bryan Walsh

Track and Room: Enterprise Database Administration Deployment - 142

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 - 113

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 - 117

Title: Using SQL to Avoid the SharePoint List Threshold

Abstract: What do you do when your SharePoint list exceeds the 5,000 item threshold? Do you turn off throttling for the list? Do you increase the limit in Central Admin? If either of these are your solution, you’re risking a SQL database lockup, which could affect more than the one list. Based on a real world scenario, this session will share how a major healthcare institution recently used a SQL view containing 6,000+ items to avoid SharePoint’s list threshold. Additionally, attendees will see how a Power View report built in SharePoint used the same SQL data to provide an interactive dashboard for data monitoring.

Speaker(s):

Theresa Eller

Track and Room: Information Delivery - 149

Title: T-SQL Tips Tricks

Abstract: Do you ever wonder how you can make T-SQL do what you really want? Do you want to know how to make it jump through loops, perform amazing twists and turns, and execute other wondrous performances? In this session you’ll learn about various features such as CTE, ROW_NUMBER, and other great features that will enable you to make your T-SQL queries and stored procedures more efficient and give you the results you really want.

Speaker(s):

Aaron Cutshall

Track and Room: Application Database Development - 147

Title: Introduction to SQL 2016 Temporal Tables

Abstract: SQL Server 2016 introduces the concept of temporal tables, also called system-versioned tables. This new feature allows SQL Server to automatically keep track of the history of rows in any table for which it is enabled. In this session we’ll cover the basics on how to create and work with temporal tables, including the new FOR SYSTEM_TIME query clause, and we’ll discuss some of the ways that they may or may not fill a need in your environment.

Speaker(s):

Vicky Harp

Track and Room: Enterprise Database Administration Deployment - 115

Title: Azure Database for DBA’s

Abstract: Did you think cloud databases like Azure Database could replace your job? It’s not, but it will redefine your job as you know it today. Platform as a service (PaaS) databases are here and adoption is growing. In this session, you will learn how to take your current DBA skills and utilize them with Azure Databases. We will focus on getting started, migrating databases, disaster recovery, performance, and security.

Speaker(s):

John Sterrett

Track and Room: Cloud Application Development Deployment - 142

Title: Cluster@#$%! High Availability Solutions. What Could Go Wrong?

Abstract: If you have a high availability need in your production environment – and who doesn’t, these days – you’ve probably had to think through the options. Clustering, Availabililty Groups, Mirroring, Replication, a third-party solution?

Even when you make an informed decision about what high-availability implementation you’ll use, are you sure it will come online and stay online? Join John in this review of some of the more prominent failures (and their solutions) in commonly used high-availability configurations.

Speaker(s):

John Harp

Track and Room: Enterprise Database Administration Deployment - 115

Title: Beyond the Where: Full Text Search tips and tricks

Abstract: Lots of people know that Full Text Search is a powerful tool for searching unstructured data but did you know that you can utilize its power for structured data as well? Functions like FREETEXTTABLE and CONTAINSTABLE open up some pretty groovy doors in terms of usability. We’ll discuss ways to give your users that search engine like interface that everyone has grown accustomed to without sacrificing query performance. We’ll also hit on creating synonyms to give your users results even when they aren’t quite sure what to search for. It’s an entirely different type of search altogether.

Speaker(s):

Kris Hokanson

Track and Room: Application Database Development - 148

Title: Avoiding the Pitfalls of Database Change Automation

Abstract: Automation and Continuous Delivery are at the forefront of software development processes today. However, databases are being neglected because database code is different, harder to automate, and DBAs just don’t seem to trust database automation. This is not surprising when you consider the number of incidents and instances of downtime that were caused by out-of-process updates, code overrides, and other database glitches. In this session, we will explain the options to automate database changes along with the benefits and issues with each option.

Speaker(s):

Cindy Bean

Track and Room: Enterprise Database Administration Deployment - 142

Title: Hostile Takeover

Abstract: In the spirit of Tim Ford’s year long Entry Level Challenge, what do you do when given a SQL Server to manage? This presentation will walk you through how to gain access to a SQL Server you have never seen before, what are the basic tools to use to collect inventory information, and what scripts I use to best determine the “health” of the server.

Speaker(s):

Robert Bishop

Track and Room: Enterprise Database Administration Deployment - 117

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 - 147

Title: Making the Leap from Developer to DBA

Abstract: You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.

Speaker(s):

Amy Herold

Track and Room: Professional Development - 149

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 - 149

Speakers

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

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

Dave Wiley

Dave Wiley is a professional in the L4-7 accelerated secure application delivery space with a focus on transformative technologies in both premise and cloud environments. Specialties include Security and Data Center Operations, Business Continuity, Application Delivery Acceleration, Program Management, Network Infrastructure Design / Implementation, Wireless Systems, and Disaster Recovery Planning amp; Implementation.

Jamey Johnston

Twitter: - STATCowboy

LinkedIn: Jamey Johnston

Contact: http://STATCowboy.com

Jamey Johnston is a Senior Data Scientist/Engineer for a large independent OG company. For over 25 years, he has worked for Fortune 500 companies architecting successful platforms in the cloud, on the edge, and on-premises for BI reporting, statistical analysis, ML, and AI. Lately, he spends his time in Azure, Python, R, Power BI, MS SQL, and SAS JMP. He holds a BS in Spatial Analysis from LSU and a Masters of Science in Analytics from Texas AM. He is a professor at the Mays Business School at Texas AM in the MS Analytics program. He is active in his PASS Local Group in Houston, co-leader of the local Power BI users group and data analytics group. He regularly speaks and volunteers at PASS events. He is also a Microsoft Data Platform MVP.

John 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.

Bryan Walsh

forthcoming

Brian Dudley

Brian is a seasoned consultant with experience in several industries. He has worked with SQL Server for more than 25 years, back to the Sybase days. as well as experience with other database platforms. He is also brings experience from the code development and design areas. He is equally comfortable leading a team or rolling up his sleeves and slinging code.

Jamey Johnston

Twitter: - STATCowboy

LinkedIn: Jamey Johnston

Contact: http://STATCowboy.com

Shawn Weisfeld

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

LinkedIn: Shawn Weisfeld

Contact: http://www.usergroup.tv

Shawn (http://www.shawnweisfeld.com, shawn@shawnweisfeld.com) is passionate about building awesome applications and websites with .NET technologies and Azure. He is currently a Technical Evangelist for Microsoft based in Austin TX and founder of http://UserGroup.tv. Read his full bio at http://about.me/shawnweisfeld

Lori Brown

Twitter: - @SQLSupahStah

LinkedIn: Lori Brown

Contact: http://blog.sqlrx.com

Lori is the SQLRx Practice Manager (sqlrx.com) and a Senior Consultant for Integrated Services, Inc., located in Dallas Texas(isi85.com). Lori has more than 18 years of experience with SQL. At ISI, she provides SQL Server expertise in performance tuning, disaster recovery/high availability, SQL upgrades and installation and DBA services. She has taught courses on SQL Server administration and performance tuning for many different companies. Lori has conducted numerous performance studies and has developed the methods and code used in SQLRx’s RemoteDBA offering. Ms. Brown has also published articles in SQL Server Magazine, contributed to SQLServerCentral.com and is a regular blogger on the SQLRx blog (blog.sqlrx.com)

Patrick LeBlanc

Twitter: - patrickdba

LinkedIn: Patrick LeBlanc

Contact: http://patrickdleblanc.com

Patrick LeBlanc is a currently a Principal Program Manager at Microsoft and a contributing partner to Guy in a Cube. Along with his 15+ years’ experience in IT he holds a Masters of Science degree from Louisiana State University. He is the author and co-author of five SQL Server books. Prior to joining Microsoft he was awarded Microsoft MVP award for his contributions to the community. Patrick is a regular speaker at many SQL Server Conferences and Community events.

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.

Ken Clement

LinkedIn: Ken Clement

Ken Clement has been an I.T. professional for over three decades in roles including software and database design, development, analysis, architecture, and management. He has successfully applied these technologies to diverse problem domains and in the process acquired a firm practical and theoretical understanding of the often opposing developer and database professional perspectives. While he has worked with several database technologies, the most notable is SQL Server which he has been involved with practically from its inception. He has over the years been a technical presenter at various conferences.

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.

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.

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.

Mark Moore

LinkedIn: Mark Moore

Contact: http://blogs.msdn.com/b/markm

Mark Moore is a Cloud Solutions Architect working for Microsoft in North Texas. Mark has been with Microsoft for 25 years serving in various roles in Services and Sales. Prior to Microsoft Mark worked at Digital Equipment Corporation serving Federal and Government customers in San Antonio, Texas. Mark currently resides with his Wife (Deanne) in the DFW area.

Brent Ozar

Twitter: - BrentO

LinkedIn: Brent Ozar

Contact: https://www.BrentOzar.com

Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.

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/

John Sterrett

Twitter: - JohnSterrett

LinkedIn: John Sterrett

Contact: https://johnsterrett.com/community/

Victor Gentry

Victor is a Senior Systems Engineer at Tintri, covering South Texas and Louisiana, and has previously held positions at storage and technology companies including VMware, Netapp and EMC. He resides in Houston, TX with his wife and two children. He holds a degree in Information Systems from Howard University, and interests include boating, fishing, and attending local sporting events.

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Brian Dudley

Thomas Norman

Twitter: - ArmorDba

LinkedIn: Thomas Norman

Contact: https://armordba.com/

Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.

Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

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.

Keith Tate

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

LinkedIn: Keith Tate

Contact: http://thesqlchef.com

Keith Tate is a Senior Database Administrator with over 17 years of experience as a data professional. During Keith#39;s professional career he has been a developer, DBA and data architect. Keith is also active in the SQL Server community and is currently the chapter leader of the Albuquerque SQL Server User Group.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

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.

Richie Rump

Twitter: - @jorriss

LinkedIn: Richie Rump

Contact: http://jorriss.net

Richie Rump is a dataveloper with Brent Ozar Unlimited, where he writes code to solve data problems. He developed statisticsparser.com and sp_DataProfile, two tools that help data professionals tune SQL Server. Richie is also the co-host of the Away From The Keyboard Podcast and founded dotNet Miami, a community focused on enterprise development with .NET. He holds the Project Management Professional (PMP) and Certified Scrum Master (CSM) certifications as well as certifications in various Microsoft development technologies. He can be found on Twitter at @Jorriss or at http://jorriss.com.

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.

Theresa Eller

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

LinkedIn: Theresa Eller

Contact: http://www.techresa.com

Theresa Eller is a SharePoint and Office 365 Administrator with a passion for customer success. Her diverse background includes degrees in Public Relations and Teaching and Learning with Technology, as well as 20 years of experience providing technical support, training, and project leadership. Theresa is a leader, speaker, and blogger in the SharePoint and Office 365 Community.

Amit Parikh

LinkedIn: Amit Parikh

My career in Information Technology spans 20 years where I#39;ve held various roles both in management and as an individual contributor. These roles include Pre and Post Sales Systems Consulting, Product and Project Management, Implementation and Training Services, Software Development as well as Systems Administration.

I am currently the Team Lead for Dell Software#39;s Federal Systems and Information Management Systems Consulting team where I am responsible for managing the technical strategy for several solution areas including Data Protection, Performance Monitoring and Database Replication. My notable specialties are in areas such as Applications and Database Management, Database Benchmarking and Performance Tuning.

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.

Patrick LeBlanc

Twitter: - patrickdba

LinkedIn: Patrick LeBlanc

Contact: http://patrickdleblanc.com

Todd Kleinhans

Twitter: - @toddkleinhans

LinkedIn: Todd Kleinhans

Contact: https://toddkleinhans.wordpress.com/

Todd Kleinhans has been using SQL Server since the last millennium. He has served in different roles across many industries but he’s mainly been a DBA. When not in virtual reality, he likes to speak at PASS sponsored events and volunteers in various groups like PASS, DSSUG, Colorado Virtual Reality and is the President of Denver/Boulder Unreal Engine group. He is on Twitter: @toddkleinhans and blogs at https://toddkleinhans.wordpress.com/

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.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

Amy Herold

Twitter: - @texasamy

LinkedIn: Amy Herold

Contact: http://www.sqlkitten.com/

Anthony {Tex} Moreign

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

LinkedIn: Anthony {Tex} Moreign

Contact: http://www.hccug.org

{Technologist | Speaker | Writer | Founder} … 25 years counting … – Founder Chief Architect, Hybrid Decisions® Corp (www.HybridDecisions.com | 2005) – Founder President, Houston Cloud Computing User Group (www.HCCUG.org | 2008) – for more info see http://linkedin.com/in/AnthonyTexM «±»

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

Contact: http://www.MidnightDBA.com/Jen

Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.

Vicky Harp

Twitter: - vickyharp

Contact: http://vickyharp.com

Vicky Harp is the Group PM Manager for the SQL Server Tools Team, which is responsible for the full set of experiences from drivers and scripting libraries, to GUI tools, to the Azure Portal. She has been building tools for SQL Server for 15 years.

Faheem Ismat

LinkedIn: Faheem Ismat

Faheem Ismat, PMP and Microsoft certified IT professional, working as Lead DBA at Marathon Oil. He has worked as Sr. Software Engineer, Data Integration Lead and Sr. DBA in ADP, Alcon, Allegro and Logix. He is a multi-platform DBA (SQL Server, Oracle, Sybase, MySQL, …) and got expertise in application and data integration, HA/DR, performance tuning, migration/consolidation and securing data in rest and transit states. His past presentations at SQLSaturday and HASSUG were focused on SQL Server data security features (data masking and encryption), usage of Service Broker for live data transfer across different domains (on-premise and cloud).

Matt White

LinkedIn: Matt White

Matt has been working with the Microsoft BI stack for over a decade. As an Account Manager for Pyramid Analytics he works with organizations to leverage their investment in SQL Server to create Business Intelligence solutions for IT and Business end users.

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.

Robert Bishop

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

Contact: http://sqlpadre.wordpress.com

Robert has been working with databases since SQL Server 2005. After 4 years as a .NET developer using SQL Server, Robert became a DBA out of necessity, a true “Accidental” DBA! Robert has presented at his local SQL Server User group, SQLSaturdays and PASS Virtual Chapters. As a Microsoft MSCA and an Idera ACE, Robert enjoys administrative tasks, configuring SQL Server for optimal performance, troubleshooting problematic SQL queries and making those query run faster than the speed of light. In the event of “free time”, Robert enjoys camping, playing his guitars and spending time with his family.

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

William Assaf

Twitter: - william_a_dba

LinkedIn: William Assaf

Contact: http://www.sqltact.com

William Assaf, Data Platform MVP, is a principal consultant in Baton Rouge, LA. Initially a .NET developer, and later into database administration and architecture, William currently works with clients on SQL Server and Azure SQL platform optimization, management, disaster recovery and high availability, and leads a crack multi-city team of consulting SQL DBA’s. William has written for Microsoft SQL certification exams since 2011 and was the lead author of the 2017 and 2019 editions of “SQL Server Administration Inside Out” by Microsoft Press. William is a member of the Baton Rouge User Groups board, a regional mentor for PASS, and past lead of the annual SQLSaturday Baton Rouge Planning Committee, having run one of the largest SQLSaturdays.

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.

Robert Moore

Twitter: - 20til6

LinkedIn: Robert Moore

Robert Michael Moore (Mike) has experience in enterprise application system design/deployment dating back to 1995 while working for Deloitte amp; Touche LLP. Client/Server was just beginning to be widely adopted at that time, and this fueled much growth. Especially in mid and commercial markets. Following Deloitte, Mike held engineering and SAP application architecture positions at Compaq and Hewlett-Packard competency/consulting centers. In 2011, Mike joined Cisco Systems and currently holds a subject matter expert position within their worldwide data center and virtualization group. He has visibility into enterprise application opportunities for on-premise, hosted, and cloud delivery models.

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.

Cindy Bean

LinkedIn: Cindy Bean

Cindy Bean is a Technical Consultant at DBmaestro, a pioneer and leading DevOps for database solution provider, enabling Agile development and Continuous Integration and Delivery for the database. She has worked with SQL Server and other relational database products for over 20 years as a DBA, product manager, and consultant. Cindy has previously worked at Idera, Bradmark Technologies, BMC Software, and Sybase.

Brent Ozar

Twitter: - BrentO

LinkedIn: Brent Ozar

Contact: https://www.BrentOzar.com

Brent Ozar loves to make SQL Server faster. He created sp_Blitz and the SQL Server First Responder Kit. He shares what he’s learned at BrentOzar.com.

Dane Schilling

Contact: http://www.daneschilling.com

From modeling databases to writing complex reports Dane Schilling has utilized MS SQL Server nearly every working day for the last sevenyears.

Jason Wong

http://dbace.us

SQLSaturday #514 - Houston 2016

Sessions

Title: So what does it really take to get to four nines

Title: Overview of Security Investments in SQL Server 2016 and Azure SQL Database

Title: Introduction to R and Data Science Tools in the Microsoft Stack

Title: Designing Stored Procedure Solutions

Title: Introduction to Biml

Title: Making the Most of the SSIS Catalog

Title: Profiler is Dead! Long Live Extended Events!

Title: Gen2016™ and the Global “Hybrid” Cloud

Title: Actively Proactive – Straightforward Ways to Manage and Diagnose SQL

Title: Monster Text Manipulation: Regular Expressions for the DBA

Title: Simple Fun Modeling with SQL Server

Title: Who’s Afraid of Entity Framework?

Title: Introduction to Microsoft Mobile Reporting

Title: Secure your sensitive data with Always Encrypted

Title: SQL Server Window Functions

Title: The Life Cycle of a Query in Virtual Reality

Title: Analyze your query plan like a Microsoft Engineer! (SQL 2016 Edit

Title: SQL Omphaloskepsis: Enlightenment and Productivity Using System Tables

Title: Beginning Azure

Title: How answers.microsoft.com Overcame the key Challenges of Upgrading to SQL S

Title: Tintri SQL Sentry – Optimizing Your Virtualized Workload

Title: Understanding Backups

Title: Codd’s Rules, Normal Forms, and SQL Anti-Patterns - Recognition Repair

Title: What’s New in SSRS 2016

Title: A Choice Performance Tuning

Title: SQL Server Statistics – What Are The Chances?

Title: “Transform into a Data-Driven Organization”

Title: Watch Brent Tune Indexes

Title: Change Tracking: A Near Bullet-Proof ETL Synchronization Control

Title: SQL Server Permissions and Security Principals

Title: The Ins and Outs of Partitioned Tables

Title: Row-level Security in SSRS and SSAS

Title: What’s new in SQL Server 2016

Title: SQL Server Defaults SUCK!!

Title: Performance Tuning SQL Server with sp_AskBrent#174; and sp_BlitzCache#174;

Title: Deploy SQL Server with Microsoft Azure Virtual Machine

Title: A new paradigm for workload analytics in SQL Server

Title: SQL Server Internals

Title: Cisco UCS, Optimal Platform for SQL Server

Title: Indexing Deep Dive

Title: Scale out SQL Server PaaS in Azure Elastically

Title: Transform Database Agility with XtremIO

Title: Why Did My Execution Plan Change? Introduction to Query Store

Title: Troubleshooting SQL Server Performance

Title: Using SQL to Avoid the SharePoint List Threshold

Title: T-SQL Tips Tricks

Title: Introduction to SQL 2016 Temporal Tables

Title: Azure Database for DBA’s

Title: Cluster@#$%! High Availability Solutions. What Could Go Wrong?

Title: Beyond the Where: Full Text Search tips and tricks

Title: Avoiding the Pitfalls of Database Change Automation

Title: Hostile Takeover

Title: Cursors temp tables and pivots oh boy

Title: Making the Leap from Developer to DBA

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

Speakers

Sponsors