SQLSaturday #447 - Dallas 2015
Event Date: 10/03/2015 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: SS2014 In-Memory Tables: Formula 1 Performance Unleashed!
Abstract:
Query performance is what it is all about. SQL Server 2014 now has the new in-memory functionality that takes a completely different approach to data access and manipulation. Google “In-Memory Tables” and you’ll get a myriad of results from white papers, blogs, webinars, etc. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables over equivalent disk based tables.
This session is all about when and how to apply in-memory tables in a production environment.
After this session you will
- Understand what in-memory tables are and how to create and maintain them including their limitations
- Be able to identify performance gains over equivalent disk back tables
- Comprehend the new data monitoring needed for in-memory table
Speaker(s):
- Mike Byrd
Track and Room: Enterprise Database Administration Deployment - 100
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 - 100
Title: Big Data and the Data Lake from the Analyst Perspective
Abstract: The concept of a data lake is emerging as a popular way to organize and build the next generation of data systems to master new big data challenges. Organizations are seeking to create data lakes because they manage and use data with increased volume, variety, and unprecedented velocity. However, how can data professionals and analysts access the data lake for the expected insights at the velocity required by the business?
Come and join me for this practical session which will build on your existing SQL skills to demystify Big Data and the Data Lake for analysts. This session is aimed at people who want to keep pace with the latest Big Data technology by adopting the latest techniques to explore the data lake, building on their existing analytical knowledge.
Speaker(s):
- Scott Shaw
Track and Room: BI Information Delivery - 110
Title: (Near) Zero-Downtime Upgrades!
Abstract: SQL Server upgrades bring enticing new features and much needed enhancements, but can you perform them while maintaining high availability of your SQL Server infrastructure? You can actually do this, by leveraging rolling upgrades, which are upgrades performed with minimal downtime or service disruptions.
In this session you will:
- Understand how rolling upgrades are better than in place upgrades
- Learn how to use database mirroring or AlwaysOn Availability Groups for rolling upgrades
- Explore how you might use Log Shipping to perform a simpler type of rolling upgrade
This is a demo-intensive session, so you can see rolling upgrades live and up close. If you are considering upgrading to a major version of SQL Server, or just applying a Service Pack or a Cumulative Update, this session is for you.
Speaker(s):
- Argenis Fernandez
Track and Room: Enterprise Database Administration Deployment - 100
Title: Configuring SQL Server for Mission Critical and Scalable Deployments
Abstract: SQL Server offers various configuration settings and tuning parameters. As hardware capabilities increase rapidly, choosing the proper configuration settings is extremely important to scale SQL Server for the required application throughput rates. In the last two years, SQL Server Escalation Team has helped many systems administrators and database administrators scale their SQL Server with several configuration parameters and application patterns. In this session you will hear directly from an experienced member of the Microsoft SQL Server escalation team [Suresh Kandoth], about these specific learnings, configurations and approaches for scaling SQL Server on the largest hardware systems available on the planet. The goal of this session to help you and guide you to perform successful deployment of SQL Server for your largest SQL Server installations.
Speaker(s):
- Suresh Kandoth
Track and Room: Enterprise Database Administration Deployment - 100
Title: Incorporating Azure Machine Learning to SQL Server Environments
Abstract: Azure Machine Learning [ML] is a great tool for gathering more insight with your data, but how do you know if the models you are using are providing the best results? How do you apply modules customized to analyze your data? After this session you will have the answers to these questions, as well as the knowledge necessary to implement machine learning data analysis into your data environment. Using Azure based SQL Server, attendees will learn rules which can be used to classify the data and the type of analysis desired by Azure ML. Building upon this information, the best methods for determining which ML models to use will be shown. This presentation will demo how to extend the flexibility of Azure ML by implementing custom analysis from other sources. Incorporating items created in R and SQL will show the expanded capabilities available outside of the existing ML components. Lastly we will deploy the Azure ML solution and incorporate the results into our SQL Server Database.
Speaker(s):
- Ginger Grant
Track and Room: Advanced Analysis Techniques - 108
Title: Is AlwaysOn really as powerful? Tips and Tricks from the field
Abstract: CIOs and VPs everywhere are asking me, how do we achieve HA with SQL Server? Having architected and implemented over 100 architectures, see how to architect, design, setup, deploy, tons of gotchas and best practices from real production deployments With the introduction of AlwaysOn and the deprecation of Database Mirroring, Windows Clustering Services is now more critical than ever. If you have moved away from clustering or implemented database mirroring as an alternative to clustering and found it lacking AlwaysOn is the way forward for you. This talk will demonstrate a complete end-to-end solution using Windows Server Failover Clustering, AlwaysOn, SQL Server 2012 Enterprise edition, and Active Directory.
Speaker(s):
- Reinaldo Kibel
Track and Room: Strategy and Architecture - 108
Title: Wait Watchers: No Pain, All Gain Exercises to Increase Database Performance
Abstract: We’re all told to watch our weight and to exercise more. Join Dell Software experts who will show you painless exercises that you can do to watch your waits. You could even eat a Danish pastry while watching if you wish (Danish pastries not provided).
In this session, you will learn all about SQL Server’s wait statistics; statistics that the database engine stores about the resources it is waiting on. Armed with this information, SQL Server professionals like you can make better informed decisions on which areas of your environment to tune to ensure greater impact on performance. Join this session to discover where to find, interpret, and use this information to tie down problem areas in your SQL Server environment. This won’t be only be about how to fix that problem query, but we’ll also talk about how to improve overall performance for all your users.
Speaker(s):
- Patrick O’Keeffe
Track and Room: Enterprise Database Administration Deployment - 109
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: SSIS Performance Tuning with BimlScript
Abstract: You know that Biml can automate ETL loads, but your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we’ll discuss how to use BimlScript to accomplish the following:
- Dynamically create multiple SISS packages for a data warehouse ETL load, each following a different best practice design pattern.
- Automatically execute each package multiple times and record the results for analysis.
- Determine which package version should be used in production.
The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.
Speaker(s):
- David Stein
Track and Room: BI Platform Architecture, Development Administration - 106
Title: ColumnStore Index: Microsoft SQL Server 2014 and Beyond
Abstract: Column store technology was first introduced in SQL Server 2012 and has been significantly enhanced for SQL Server 2014 and SQL Server 2016. Column store indexes can not only accelerate data warehouse workloads by an order of magnitude but also reduce storage requirements by an order of magnitude. Column store indexes are a hybrid technology leveraging the best of disk in-memory capabilities. In this session we cover how to take advantage of column store capabilities in your applications and dive into the internals of how column store works in following areas. Business Rationale , Overview, Trends in the Data Warehousing Space, Data Compression, Query Performance, Clustered Column Store Index, Supportability: DMVs, Perfmon, XEvents, High Availability/Supportability
You will also learn what is available in SQL Server 2012, SQL Server 2014 and SQL Server 2016
Speaker(s):
- Jayaprakash Jothiraman
Track and Room: BI Platform Architecture, Development Administration - 111
Title: SQL Server Agent: The life preserver for the drowning DBA
Abstract: Automation is a key part to becoming a great DBA. Without automation a DBA can start to drown in a sea of repeating tasks. The SQL Server Agent can serve as the much-needed life preserver to pull your head above the water. In this session you will learn at how to setup the SQL Agent as well as creating jobs and alerts within the agent to help you automate daily, monthly, yearly tasks. In addition we will look into how to monitor the jobs and alerts created. Lastly we will talk about some common pitfalls to watch out for when dealing with the SQL Server Agent.
Speaker(s):
- Lance Tidwell
Track and Room: Enterprise Database Administration Deployment - 100
Title: Third-Party Application Deployment: Dispatches from the Trenches
Abstract: Before you install that third-party solution in your SQL Server environment, come to this fireside chat. John will spin tales from more than a decade of experience in application support to cover some of the more common, and more problematic gotchas you might encounter, as well as their workarounds and solutions. With luck, you’ll leave with an improved pre-checklist for deploying purchased products, whether in Development or Production environments.
Speaker(s):
- John Harp
Track and Room: Enterprise Database Administration Deployment - 110
Title: Managing SQL Server in the Enterprise with TLAs
Abstract: Technologists are overwhelmed with TLAs (Three-Letter Acronyms) in their everyday life. This session will introduce several SQL Server features designed to make a DBA’s life easier. If you aren’t using CMS (Central Management Server), PBM (Policy Based Management), and EPM (Enterprise Policy Management Framework) – come learn what they are and the potential benefits in using them to manage your environment - from SQL 2000 to SQL 2014!
Speaker(s):
- Nancy Hidy Wilson
Track and Room: Enterprise Database Administration Deployment - 100
Title: The “Data Loading Performance Guide” Presentation
Abstract: Loading huge amounts of data into SQL Server can be challenging. There are quite a few factors that can help, or hurt your goal for tuned performance. For this reason, bulk loading with large amounts of data requires a strategy.
For that strategy, Microsoft has published a famous whitepaper called “The Data Loading Performance Guide.” The problem is that this guide is long and full of small details that can be confusing and daunting at first glance.
In this session, we will turn this whitepaper into a presentation about creating a strategy to optimize your massive data loading processes by applying the techniques mentioned in the whitepaper, as well as other advanced techniques that have emerged since the whitepaper was published.
We will talk about solutions to achieve High Performance Data Loading, Minimal Logging and Bulk Loading, Indexing Techniques including Columstore, properly leveraging Parallelism and Partitioning, Truncate Partition, PolyBase, Delayed Durability, and more.
Speaker(s):
- Ryan Casey
Track and Room: BI Information Delivery - 106
Title: Predicting Customer Churn with Azure Machine Learning
Abstract: Using machine learning, we can tap into the patterns that tell us which of our customers are likely to defect to our competitors. This use case is not only applicable to a wide range of businesses but provides a highly accessible starting point for exploring machine learning.
Speaker(s):
- Bryan Smith
Track and Room: Analytics and Visualization - 108
Title: PowerBI / DataZen and Microsoft BI Roadmap
Abstract: Microsoft has made a significant leap forward with in the business intelligence world with the public release of PowerBI.com and acquisition of DataZen. Power BI allows customers to create rich visualizes on a cloud platform. DataZen is an intuitive platform with attractive dashboards and KPIs for desktop and mobile devices. Come learn about features of both platforms, pros and cons, and Microsoft’s BI roadmap.
Speaker(s):
- Brennan Bice
Track and Room: BI Information Delivery - 106
Title: Navigating the Hadoop Stack
Abstract: Hadoop distributions can be a complicated road to navigate. Application names such as Spark, Pig, Hive, Falcon, and Ranger are interesting but give no indication as to what purpose they server or how they can be helpful to your organization. We’ll take time in this session to work through the various components (Hortonworks HDP ships with 23 projects) and find which ones fit into your specific needs.
Speaker(s):
- Scott Shaw
Track and Room: Strategy and Architecture - 110
Title: Incremental Load Design Patterns
Abstract: The volume of data addressed by the typical ETL operation is constantly on the rise. Not so many years ago, a table with a few million records was considered to be huge. These days, it’s not uncommon to deal with multibillion row tables. As a result, ETL professionals are frequently tasked with finding efficient ways to incrementally process these large sets of data without resorting to expensive and time-consuming destructive reloads.
In this session, we will review the common decision points surrounding incrementally loading data, and will demonstrate some of the methods for incremental processing. Among the topics of discussion: –Deciding whether an incremental load is appropriate –Pick your tool: T-SQL or SSIS? –Methods for detecting new and changed records –Common incremental load design patterns
Speaker(s):
- Tim Mitchell
Track and Room: BI Information Delivery - 106
Title: High Availability Solutions with Enhanced SQL Server 2016 Always ON
Abstract:
SQL Server 2016 Always ON Availability Group delivers even Higher Availability for Mission Critical workloads. If you are interested in learning what is new in SQL Server 2016 Always ON Availability Groups, come to see this session where we will cover Always ON Availability Groups in details and present scenarios how it can be used as a solution for High Availability, Disaster Recovery and offload read-only workloads to secondary replicas using on premises or cloud based servers on a hybrid cloud scenario.
SQL Server 2016 Always ON Availability Group newest features will provide even Higher Available Database Server for Mission critical workloads required by most businesses today.
Speaker(s):
- Andre Hass
Track and Room: Enterprise Database Administration Deployment - 111
Title: What’s that up in the cloud?! It’s the Azure SQL DB in all its new glory!
Abstract: Azure SQL Database is great relational database platform in the cloud for developing, deploying, and managing data tier in a wide range of cloud applications. In this session we are going to introduce you to Azure SQL Database and its new incarnation, the V12 release and all its new features that helped minimize the gap between Azure and on-premises database environments.
The topics include new features in Azure V12 database; Elastic Database Pools, Enhanced Disaster Recovery features, Transparent Database Encryption, expanded T-SQL Surface Area to name a few. This session is going to be demo rich and is one session that you don’t want to miss if you are looking to learn more about Azure SQL Databases.
Speaker(s):
- Kal Yella
Track and Room: Application Database Development - 111
Title: SSIS Monitoring Framework
Abstract: Most Organizations use SSIS as the ETL tool of choice for Data movement. These ETL processes can vary from simple to extremely complex processes. Data from these processes can be consumed by a Data warehouse, various other internal systems or for reporting.
Monitoring these ETL processes from a centralized location can be complicated, and many times performance issues only become apparent when the process fails or continues to keep running abnormally. We shall talk about a framework to proactively monitor SSIS ETL processes for reporting and analysis and to examine performance trends of SSIS packages across servers over time.
This session will discuss the SSIS Monitoring framework and demonstrate a few visualizations to show a performance analysis of ETL processes with minimal effort.
Speaker(s):
- mahesh pujari
Track and Room: Other - 109
Title: Everything you Want to know about Power BI Dependency on O365
Abstract: For most users, you will sign up to use Power BI and never know that Office 365 is the background. For organizations that want to leverage the advanced features of Power BI, you MAY need to perform certain configurations within Office 365. Since most people do not realize that Office 365 is used under hood of Power BI, we will show you how to properly prepare your organization for the new Power BI service. In this demo heavy session we will dispel the myth that you may not need Office 365 to access the full capabilities Power BI.
Speaker(s):
- Adam Saxton
Track and Room: BI Platform Architecture, Development Administration - 106
Title: SQL Server 2016 Scale and diagnostics improvements in core database engine
Abstract: This session will discuss several core performance and scale improvements to the SQL 2016 Database Engine in order to many of of the most common customer pain points involving tempdb, new CE, partitioning , memory grants among others and will benefit any upgrade to SQL 2016. We will also discuss and demo new diagnostics improvements for faster troubleshooting and problem mitigation.
Speaker(s):
- Denzil Ribeiro
Track and Room: Enterprise Database Administration Deployment - 111
Title: Beginning Automation with Powershell
Abstract: This session will cover concepts of automating SQL processes with Powershell - the one tool no DBA should shy away from. If you haven’t gotten on the bandwagon yet now is the time. With some simple demos that you can take and expand upon, you will learn how you can leverage Powershell to not only efficiently meet the needs of your business, but also free up your time for other things.
Speaker(s):
- Amy Herold
Track and Room: Enterprise Database Administration Deployment - 109
Title: Practical Design Pitfalls in designing Enterprise Data Warehouse
Abstract: This session covers practical approaches in avoiding the common design issues in implementing Data Warehouse solutions. This also gives tips to spot the early symptoms on these issues
Speaker(s):
- Dr. Suresh Rajappa
Track and Room: BI Platform Architecture, Development Administration - 110
Title: Spark SQL and Hadoop - When to leverage in-memory SQL
Abstract: SQL on Hadoop has many variants. These SQL engines strive to make use of the plethora of data engineers already trained in SQL. A new class of tools, like Apache Spark, aims to increase the speed at which those SQL results can be leveraged by providing an in-memory, distributed framework to hold and process data. This introductory talk will walk through the pros and cons, plus look at a few real-world examples that can be solved more efficiently with the Spark engine.
Speaker(s):
- Paul Hargis
Track and Room: Advanced Analysis Techniques - 110
Title: Your DB in the cloud?
Abstract: Let’s face it the cloud is here to stay, and while not every workload will be moving tomorrow an understanding of running database workloads in Azure is a must for every DBA. In this session driven by real world customer conversations we will discuss some of the ramifications of moving your database workload to the cloud. We will look at the PaaS and IaaS offerings available in Azure and discuss the how to choose between them.
Speaker(s):
- Shawn Weisfeld
Track and Room: Cloud Application Development Deployment - 108
Title: How Active Directory affects SQL Server
Abstract: If you have ever had a Kerberos or SSPI context error, then you won’t want to miss this session. SQL Server has a large surface area and Active Directory can influence a big part of it. I will discuss AD DNS configuration, Group Policy Objects, Kerberos (of course), and how all of them affect your SQL Server. By the end of the session you’ll have a check list of things to discuss with your domain administrator when you return to work.
Speaker(s):
- Ryan Adams
Track and Room: Enterprise Database Administration Deployment - 100
Title: Configuration Manager and the SQL Broker Service - DRS under the covers
Abstract: When installed in a hierarchy Configuration Manager leverages the SQL Broker service to replicate data between the various sites. Understanding how Configuration Manager leverages SQL Broker and how to troubleshoot when things go wrong is critical to maintain proper hierarchy function. This session will describe how Configuration Manager replication works along with demonstrations that will highlight replication processing. We will also work through troubleshooting techniques that can be used from easiest to more complex.
Speaker(s):
- Steven Rachui
Track and Room: Other - 105
Title: Are You Optimistic About Concurrency?
Abstract: What exactly does it mean to have optimistic concurrency? What is the alternative? Is SQL Server 2012’s SNAPSHOT Isolation optimistic? How can SQL Server 2014’s In-Memory OLTP provide truly optimistic concurrency?
In this session, we’ll look at what guarantees the various isolation levels provide, the difference between pessimistic and optimistic concurrency, and the new data structures in SQL Server 2014 that allow the enormous benefits of having totally in-memory storage with no waiting!
Speaker(s):
- Kalen Delaney
Track and Room: Enterprise Database Administration Deployment - 105
Title: Analyze your query plan like a Microsoft Engineer!
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.
Speaker(s):
- Daniel Janik
Track and Room: Advanced Analysis Techniques - 110
Title: Develop SQL Server Databases from Visual Studio: SQL Server Data Tools
Abstract: Did you know you can design and develop databases from within Visual Studio using SQL Server Data Tools? Attend this session to learn robust and repeatable database development methods and take your team to the next level using Visual Studio. Discover simple ways to manage databases using a tool designed by Microsoft.
Speaker(s):
- Patrick Bewley
Track and Room: Application Database Development - 105
Title: Translating SANanese to English: How to manipulate your storage admin!
Abstract: This technical session covers everything you ever wanted to know about troubleshooting the storage in SQL Server. Have you ever observed high latency, only to be told “It’s not the disks” by the storage admin? This empowering session will give you the knowledge you need to dig down to the root cause! This session will cover DMVs, Performance Monitor, XPerf, and more!
Speaker(s):
- Daniel Janik
Track and Room: Enterprise Database Administration Deployment - 109
Title: SQL Server Security Basics
Abstract: In the modern age, data is a company’s most valuable resource and, unfortunately, data crimes are common. Because of this, everyone that works with SQL Server should have a basic understanding of database security. Attend this session to learn the what, how, and why of database security. Learn what permissions, securables, and principals are. Learn how to manage database security. Most importantly, learn what the best practices are and why they are important. Your company’s data is your responsibility, and after attending this session you can step up and keep it safe.
Speaker(s):
- Kenneth Fisher
Track and Room: Enterprise Database Administration Deployment - 105
Title: What is the SSIS Catalog? and Why do I care?
Abstract: SQL Server 2012 redefined how SSIS packages are stored and executed. The advent of the SSISDB catalog gives a central point for working with SSIS projects deployed to the server. From this catalog we can set project and package parameter, configure environments, and monitor execution. There is no need to build in package logging because Microsoft had done it for us. This presentation covers what is in the catalog, how to deploy packages, environment, tips and tricks as well as monitoring package execution.
Speaker(s):
- Stan Geiger
Track and Room: BI Platform Architecture, Development Administration - 108
Title: Cash in on the data dividend: how Power BI can realize the untapped value of your data
Abstract: IDC estimates that the economic value gap between companies that are innovative about data analytics and those that maintain a status quo is $1.6 trillion worldwide over the next four years. This presentation will look at the ways that the data dividend can be realized, and provides an overview of Microsoft Power BI (the tools in Excel and the cloud-based services) so you can understand how it can be applied to your organization.
Speaker(s):
- Mike Diehl
Track and Room: BI Information Delivery - 106
Title: Fast and Furious: Discovering Windowing Function
Abstract: The Windowing Functions are advanced SQL Server commands, existing since 2005, but many database developers forget to use them. In this session we will discuss about how they work, how we should use them and how we can combine them with other development techniques as the use of CTE, procedures, functions, etc.
Speaker(s):
- Ahias Portillo
Track and Room: Application Database Development - 105
Title: Modern Data Strategy
Abstract: Join to this session to look at evolving trends around Data and how you can understand and put a plan for a Data Strategy in your organization.
Speaker(s):
- Sri Sridharan
Track and Room: Strategy and Architecture - 108
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 - 105
Title: But it worked great in Dev! Perfomance for Devs
Abstract: If you’ve ever found yourself stating the above, this session is for you. For many developers, writing T-SQL that works is not the challenge. But too often, functional T-SQL is not the same as good T-SQL. In this session, we will examine why “SQL that works” is not good enough. Understanding indexes, exectuion plans, sargability, and more are all critical to writing good T-SQL. We will also examine several real-world examples of T-SQL that “worked great in dev” but caused major issues when it hit production.
Speaker(s):
- Randy Knight
Track and Room: Application Database Development - 109
Title: Finding root cause for unexplained Availability Group failover
Abstract: In this session, we will walk you step by step through one or more support cases that demonstrate how we determine root cause analysis of an unexplained failure in an Availability Group. Whether the databases simply became unavailable, synchronization stopped, or there was an unexplained failover. We will show you specifically what we look for in the OS Cluster logs, SQL error logs, Extended Events and other sources of information.
Speaker(s):
- Trayce Jordan
Track and Room: Enterprise Database Administration Deployment - 111
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
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.
Ahias Portillo
Twitter: - PortilloAhias
LinkedIn: Ahias Portillo
Soy un loco entusiasta por aprender nuevas tecnologías asociadas a base de datos, análisis de datos, Big Data y Ciencia de datos, cuento con más de 15 años de experiencia.
Cuento con una maestría en Base de datos, certificación profesional de Microsoft en ciencia de datos y Big Data, actualmente estoy estudiando una maestría académica en ciencia de datos.
Me gusta compartir el conocimiento lo que me ha permitido ser nombrado como MVP de plataforma de datos desde el 2014, también he participado como conferencista en países de El Salvador, Guatemala, Costa Rica, Panamá, Estados Unidos y España.
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.
Scott Shaw
Twitter: - @shawsql
LinkedIn: Scott Shaw
Contact: http://www.dbaexperience.com
Scott Shaw has over a decade of experience in data management. He is a frequent speaker at local and national community events and has co-authored two books on T-SQL. He teaches as well as implements Pig, Hive, Hadoop, as well as teaches courses on SQL Server, and Microsoft BI. He is currently working on a book titled quot;Practical Hive” to be published by Apress publishing. He lives in St. Louis and is a Sr. Solutions Engineer for Hortonworks.
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.
Reinaldo Kibel
Twitter: - @sqlmii
LinkedIn: Reinaldo Kibel
With over 20 years of experience in Microsoft SQL Server technology, working in one of the largest MS SQL installation in the world at Dell and having worked at Microsoft, Reinaldo is a consultant, an architect and leader in the database technology area. Reinaldo is an advisory and provides direct feedback to Microsoft SQL Server Product team part of Technology Adoption Program with MS on versions 2005, 2008, 2008R2, 2012, 2014, 2016 and 2017 leader at Dell. Reinaldo has written case studies, white papers and videos on Data technology available at Microsoft and Dell web sites. Reinaldo has presented at Ignite, SQL Summit, SQLSaturdays, and 24HOP as well as local users group in TX.
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.
Brennan Bice
LinkedIn: Brennan Bice
Strategic consultant with experience demonstrating business intelligence value, providing guidance on evaluating solutions, and highlighting business impacts.
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.
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.
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.
Mike Diehl
Twitter: - @MikeDiehl_Wpg
LinkedIn: Mike Diehl
Contact: http://weblogs.asp.net/miked
Mike Diehl is the practice lead for databases and Business Intelligence at Imaginet Resources, a Microsoft partner with offices in Dallas, Calgary, and Winnipeg. Mike has over 20 years of experience using Microsoft database technologies and is an expert in Agile Analytics, Scrum, Kanban, and Microsoft Team Foundation Server.
Steven Rachui
Contact: http://blogs.msdn.com/steverac
Steven has supported System Center products at Microsoft for 16 years and currently works in the premier field engineering group. He hosts a popular System Center blog, has served as an author and technical editor for several System Center books and has been an active participant and speaker at MMS for the past several years. He has also traveled extensively within the US and Internationally helping customers learn and better make use of System Center technology.
Paul Hargis
Twitter: - @pmhargis
Paul works with companies and individuals to expand their capabilities in the areas of Big Data, Data Science, and Hadoop.
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
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
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.
Denzil Ribeiro
Twitter: - denzilribeiro
LinkedIn: Denzil Ribeiro
Contact: http://blogs.msdn.com/b/sqlcat/
Denzil Ribeiro is a Principal Program Manager in the Azure SQL Database team. He is a Microsoft Certified Master (MCM) and has 15+ years of experience working with high scale SQL Server and Data pipeline architectures. Prior roles included stints in SQLCAT focusing on top tier customer scalability engagements across the data pipeline , SQL Server Escalation Engineer in CSS and Premier Field Engineer working with our top tier customers.
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.
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.
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.
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.
Kal Yella
Kal has 14+ years of experience in the SQL Server field as a DBA and Consultant for various financial and consulting organizations. In his current position as a Sr. Premier Field Engineer at Microsoft, Kal supports multiple customers in Health Care industry in maintaining and improving their large SQL Server environments. Kal holds several SQL Server certifications including MCSE, MCT (Microsoft Certified Trainer) and the esteemed MCSM (Microsoft Certified Solutions Master).
Patrick O’Keeffe
Twitter: - @pokeeffe
LinkedIn: Patrick O’Keeffe
Patrick O’Keeffe is Vice President, Software Engineering at Quest, where he leads the worldwide software engineering team for the Quest Database Tools BU. Patrick has over 25 years’ experience in leading software engineering teams, software engineering and architecture and is based in Austin, TX.
Jayaprakash Jothiraman
Jayaprakash Jothiraman (Jay) has worked with Microsoft SQL Server Escalation support team for 12 years. Jay has tremendous experience in troubleshooting, solving complex and challenging SQL Server issues. Jay has experience in Database corruption, Upgrades and Migration, Database Backup and Recovery, Installation, data warehouse related issues. Jay has created KB article, training documents for Microsoft engineers.
Nancy Hidy Wilson
Twitter: - @NancyHidyWilson
LinkedIn: Nancy Hidy Wilson
Contact: http://nancyhidywilson.wordpress.com
Nancy Hidy Wilson has been working with Microsoft SQL Server since 1994. She originally volunteered for PASS at the first Community Summit held in Chicago in 1999 and has served on various PASS Committees since that time. Nancy was a PASS Community Summit speaker from 2000-2007. Nancy led the Houston Area SQL Server User Group (HASSUG) from 2001-15 and presents there and at SQLSaturday events. She also currently volunteers as an editor for the SQL Server Benchmarks with CIS.
Andre Hass
Twitter: - @andrehass_pfe
Andre Hass has been working for Microsoft as Premier Field Engineer for 8 years primarily focused on SQL Server Engine, Analytics Platform System (PDW) and Cloud Data Platform Solutions. In 2006 and 2007 received from Microsoft an industry recognized MVP Award – Most Valuable Professional. Andre has 12+ years of experience on SQL Server Administration, Development and Design. Speaker on SQL Server technical summits, Microsoft conferences including TechEd and internal events. Andre started his
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).
mahesh pujari
Over 14 years of IT experience, majority of which is on Database systems and BI. Have worked extensively on Microsoft SQL Server, starting with version 7.0 onwards.
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.
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
Ganesh Gopalakrishnan
Ganesh is the Director of Logistics and Communications for NTSSUG. Ganesh is currently working as Database Consultant at AlixPartners. Ganesh has been working on SQL Server since year 2004. Ganesh has a masters degree in computer science and masters degree in business administration from The University of Texas at Arlington.
Ganesh Gopalakrishnan
Ganesh is the Director of Logistics and Communications for NTSSUG. Ganesh is currently working as Database Consultant at AlixPartners. Ganesh has been working on SQL Server since year 2004. Ganesh has a masters degree in computer science and masters degree in business administration from The University of Texas at Arlington.
Kalen Delaney
Twitter: - sqlqueen
Kalen Delaney is a Data Platform MVP who has worked with SQL Server for more than 32 years. She has provided performance consulting services and taught advanced courses on SQL Server to thousands of people and organizations. In addition to her courseware development, Kalen has been writing about SQL Server for decades. She is the primary author of SQL Server Internals and the Inside SQL Server series. Kalen is also one of the primary editors for the Red Gate SQL Server Stairways tutorials.
Adam Saxton
Twitter: - @GuyInACube
LinkedIn: Adam Saxton
Contact: https://guyinacube.com
Adam Saxton is just a guy in a cube doing the work! He is on the Power BI CAT team at Microsoft, working with customers to help adopt Power BI. He is based in Texas and started with Microsoft supporting SQL Server connectivity and Reporting Services in 2005. Adam has worked with Power BI since the beginning, on the support side, and with documentation. In addition, he produces weekly videos for his Guy in a Cube YouTube channel.
Kenneth Fisher
Twitter: - https://twitter.com/sqlstudent144
LinkedIn: Kenneth Fisher
Contact: http://www.sqlstudies.com
Kenneth Fisher works as a senior database administrator for a large multinational insurance company and has over two decades of experience as a DBA. He enjoys writing, and his credits include a number of technical articles and SQL Server related crossword puzzles. He also blogs incessantly at www.sqlstudies.com. Kenneth is honored to be a Data Platform MVP.
Ganesh Gopalakrishnan
Ganesh is the Director of Logistics and Communications for NTSSUG. Ganesh is currently working as Database Consultant at AlixPartners. Ganesh has been working on SQL Server since year 2004. Ganesh has a masters degree in computer science and masters degree in business administration from The University of Texas at Arlington.
Argenis Fernandez
Twitter: - DBArgenis
LinkedIn: Argenis Fernandez
Contact: http://blog.purestorage.com/author/argenisfernandez/
Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.
Dr. Suresh Rajappa
LinkedIn: Dr. Suresh Rajappa
Suresh Rajappa is a Principal @ Intellisee Group focusing on Enterprise Performance Management, Big Data, Business Analytics and In-memory computing. He has 20 years of experience in databases and Business intelligence. He holds a PhD in Data Mining and MBA degree in Strategy and Finance.
He had spoken in various SQLSaturday sessions across the country.
Scott Shaw
Twitter: - @shawsql
LinkedIn: Scott Shaw
Contact: http://www.dbaexperience.com
Scott Shaw has over a decade of experience in data management. He is a frequent speaker at local and national community events and has co-authored two books on T-SQL. He teaches as well as implements Pig, Hive, Hadoop, as well as teaches courses on SQL Server, and Microsoft BI. He is currently working on a book titled quot;Practical Hive” to be published by Apress publishing. He lives in St. Louis and is a Sr. Solutions Engineer for Hortonworks.
Patrick Bewley
LinkedIn: Patrick Bewley
Patrick Bewley is a developer turned DBA. He has worked with SQL Server and Microsoft development for 14 years. He specializes in technical and business process improvement, especially as it applies to SQL Server databases.
Suresh Kandoth
LinkedIn: Suresh Kandoth
Suresh Kandoth is a Technology Lead in the Microsoft Data Platform support team in Dallas, Texas. He has worked with Microsoft since 2001 and worked on SQL Server releases all the way from SQL Server 6.5 to SQL Server 2016. Suresh works on solving many complex issues for customers who deploy SQL Server for mission critical applications and environments. Suresh also works with the SQL Server development team constantly to improve the quality and customer experience of SQL Server features and components. Suresh has written many Knowledge Base articles, blog posts and whitepapers. Suresh also presents in SQLSaturdays and local conferences in Texas.
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.
Ganesh Gopalakrishnan
Ganesh is the Director of Logistics and Communications for NTSSUG. Ganesh is currently working as Database Consultant at AlixPartners. Ganesh has been working on SQL Server since year 2004. Ganesh has a masters degree in computer science and masters degree in business administration from The University of Texas at Arlington.
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.
Sponsors
The following is a list of sponsors that helped fund the event: