SQLSaturday #699 - Tampa 2018
Event Date: 02/24/2018 00:00:00
Event Location:
- USF School of Business - BSN
- 12212 USF Maple Drive
- Tampa, Florida
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: Modern Concerns about Reporting Style with Power BI
Abstract: Reports are no longer just black and white columns and rows of numbers. Reports combine tables with charts and KPIs and more. Visually, there is a lot to be concerned with when designing your report to get the right information across to your audience. You must consider the way you display your data, the amount of data displayed, the use of color and maybe even the use of animation. Creating attractive reports is not just about making them pretty. It is about grabbing your audience’s attention. It is making sure you don’t inadvertently introduce ADA (American Disabilities Act) problems that will detract from your message if your audience cannot understand or interpret your data. This session while looking at some reporting best practices will also give you information to steer you clear of ADA concerns to keep your data’s message on track.
Speaker(s):
- Michael Antonovich
Track and Room: BI Information Delivery - 120
Title: Full Azure Automation with PowerShell
Abstract: PowerShell is the robust automation language for Windows. When extended Azure modules, you get a robust Azure automation platform. In this presentation, we’ll explain how to create, inquire about, and manage Azure resources from the client-side using PowerShell. Then we’ll look at how to create PowerShell automation jobs called Runbooks within Azure and the features of using this approach. Finally, we’ll see how we can get the best of both approaches by using the Azure Automation Authoring Toolkit, a PowerShell ISE Add-On that seamlessly integrates local PowerShell development and testing with cloud based Azure Runbooks. If you plan to use Azure, you need PowerShell, the Azure automation language so come to this presentation to get started.
Speaker(s):
- Bryan Cafferky
Track and Room: Cloud Application Development Deployment - 123
Title: The Business Intelligence Side of SQL Server
Abstract: This session focuses on Microsoft’s BI capabilities within SQL Server and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. Through several releases, Microsoft dramatically enhanced the Microsoft BI platform. During this session Plus Consulting, one of Microsoft’s top global BI partners, value from your BI platform. We’ll show you why the combination of Microsoft Office, PowerBI and SQL Server are an excellent solution for creating self-service dashboards, scorecards, KPIs, pivots, data exploration and discovery.will explore the improvements to SQL Server self-service reporting and talk about creating blended
Speaker(s):
- Sayed Saeed
Track and Room: BI Platform Architecture, Development Administration - 118
Title: Uptight Database Security
Abstract: Do you work for an institution that fears it’s DBAs could go rogue on their production databases? Do you want to revoke continuous sysadmin permissions from your DBA team in an attempt to avoid being the next WikiLeak? Do you have concerns that the DBA team is querying sensitive databases? Then, you need Uptight Database Security. Come to this session to learn how to deploy a configurable permission model that provides on-demand access to SQL Server databases. This model allows DBAs to do routine work without sysadmin, elevate permissions to sysadmin only during production emergencies or disaster recovery scenarios. Attendees will leave this session with the fundamental knowledge and scripts to implement a low hassle solution that provides DBAs the minimum necessary access required to maintain a production database server.
Speaker(s):
- Ronald Dameron
Track and Room: Enterprise Database Administration Deployment - 1101
Title: SQL Server Then and Now: Changing the State of Long-held Beliefs
Abstract: We’ve all heard the rules for SQL Server like separate your data from your log, watch for a disk queue length over 2, and a low Page Life Expectancy always means memory pressure. All of these used to be true, but on today’s hardware and SQL Server versions – they are dangerously outdated. In this session, we will take on a bunch of these old “givens” of SQL Server that everybody has heard and followed, the underlying technological reasons they were true then, how today’s technology has rendered them obsolete, and what the new rules are that you need to know. So whether you are one of the old guard looking to refresh your set of working SQL Server rules or a member of the up-and-comers looking for the facts to win over the old guard, this session is for you.
Speaker(s):
- Maxwell Myrick
Track and Room: Enterprise Database Administration Deployment - 112
Title: Collecting Performance Metrics
Abstract: Have you ever had a manager standing over your shoulder, wanting to know why a server is running slowly? Or whether or not a server can handle additional workload? What information would you use to answer these questions? How would you share this information with your manager? The answer is baseline metrics.
Only if you have baseline performance information can you answer these questions and form a plan to address the issues at hand. In this session, we will be discussing several open source tools you can combine into an inexpensive baselining system you can use to troubleshoot issues and answer important questions.
Attendees in this session will learn how to collect important metric data, what data to collect, and how to interpret that data and develop a plan of action to address any issues.
Speaker(s):
- Tracy Boggiano
Track and Room: Enterprise Database Administration Deployment - 1102
Title: Database Project Makes Deployment Consistent
Abstract: The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT, and Prod is a challenge whether on-premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.
Speaker(s):
- Thomas Norman
Track and Room: Enterprise Database Administration Deployment - 124
Title: The Modern Data Architecture, Big Data and Data Science
Abstract: Data Science techniques are becoming popular and because statistics usually is teach at the Math Department people think of it as an exact science but Statistic is the science of prediction and expectations. In the exciting of the possibilities that Big Data technology and Data Science techniques are opening, we are forgetting that correlation is not equal than causation and that any design model have intrinsic limitations because of the false positives and false negatives. Dr. Deming said “In God we trust, all others must bring data.” but what he really wanted to reach was Wisdom! Data is just the raw material the real goal is Wisdom I have been thinking about the chain toward Wisdom (Data-Information-Knowledge-Wisdom) and wonder how many organizations have reach, at least, the level of Knowledge and if any at all has reached the pinnacle of Wisdom. We are drowning in a sea of data and we are starving for wisdom. In this presentation I intent to expose limitations and opportunities
Speaker(s):
- Frank Quintana
Track and Room: BI Platform Architecture, Development Administration - 115
Title: Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry
Abstract: Like parents having to break up a fight between battling siblings, SQL Server must do the same for conflicting transactions. We call these Deadlocks and they can present a problem to many DBAs. Deadlocks can be minor fights or major issues making SQL Server continually choose a side like constantly quarreling siblings.
To understand how Deadlocking occurs, we must understand what caused the fight . Learning about basic locking and blocking of SQL Server is a great place to start.
By the end of this session you will walk away with the knowledge of how the locking/blocking mechanism works, the basics of deadlocking, and what Isolation Levels are . You will know how these can help or hurt your situation. Finally you will have the power to capture, report, and stop the family fighting.
Speaker(s):
- William Wolf
Track and Room: Application Database Development - 115
Title: SQL Server Standard Now Does All the Cool Tricks
Abstract: With the introduction of SQL Server 2016 SP1 Microsoft has made all of the database design and programming techniques that had been Enterprise Edition features available in Standard Edition. This talk introduces the newly available features and show how they can be of great benefit to Standard Edition users. Some of the highlighted features are: • Compression and COLUMNSTORE • In-Memory database tables and natively compiled code • Table partitioning • Always Encrypted • Row-Level Security and Dynamic Data Masking These features will be explained with examples of how them can benefit even a small or medium size database under standard edition.
Speaker(s):
- Andrew Novick
Track and Room: Application Database Development - 123
Title: A Rocket Scientist Perspective on Indexes
Abstract: Indexes can be a boon or detriment for database performance. This presentation will present what they are (in layman’s terms) and how they may affect query performance – both from a read (SELECT) viewpoint as well as a data modification aspect (INSERT, UPDATE, DELETE). This session will focus on a deep dive into clustered indexes, Primary Keys, and nonclustered indexes (including B-tree traversal), their syntax and utilization, and their effect on performance in transaction and data warehouse databases. Covering nonclustered indexes will also be examined in detail. There will be many live query demos illustrating index utilization and performance using statistics and query plans. Some knowledge of Management Studio and TSQL is recommended.
Speaker(s):
- Mike Byrd
Track and Room: Application Database Development - 123
Title: Going Asynchronous with Service Broker
Abstract: Do you have complex operations that have already been tuned for optimum performance, but still run too long for a good end user application experience? If you do, Service Broker may be the solution.
This session will explain the benefits of asynchronous processing in Service Broker compared to other options like SQL Agent jobs or SSIS packages, and how to implement the basic components required. Even in SQL Server 2014, Service Broker lacks a UI integration, which is sometimes a road block for implementations. Not to worry, this session will show you how to configure Service Broker correctly the first time so you can develop easy, foolproof deployments to solve complicated problems.
Speaker(s):
- Jonathan Kehayias
Track and Room: Application Database Development - 115
Title: Cautionary Tale of Recompilations, Excessive CPU Load and Plan Caching
Abstract: SQL Server reduces compilation and optimization overhead by caching and reusing execution plans for the queries. Plan caching helps to reduce CPU load on the server; however, it may also introduce unexpected issues and lead to suboptimal execution plans and performance problems.
In this session, Dmitri will explain how plan caching works internally and demonstrate how to address several common issues related to the plan caching. He will talk about parameter sniffing, simple and forced parameterization, OPTIMIZE FOR UNKNOWN strategy, and several other related topics. Finally, Dmitri will provide the guidelines how to reduce CPU load and recompilation overhead in the systems with heavy ad-hoc workload and non-parameterized queries.
Speaker(s):
- Dmitri Korotkevitch
Track and Room: Enterprise Database Administration Deployment - 115
Title: Spot the Potential Breakpoints in your Automated Process
Abstract: We all have automated processes that were built in a rush and as long as everything is right, it works very well. Then, several months later, after you have shoved the relevant knowledge about it to the corner of your brain, something happens that you didnt expect and the process fails. You fix it, and it works again, but something else comes up and it breaks again. This interactive presentation helps to show how to identify the potential break-points in a proces. We will review 2 case scenarios: SFTP process which pulls files from a vendor and a log shipping process. For each scenario, we will disect each part of the process and find out where the vulnerabilities are.
Speaker(s):
- Glenda Gable
Track and Room: Enterprise Database Administration Deployment - 112
Title: Tuning Like CSS: With These Tools There’s No Need Call Support
Abstract: What do you do when you have a performance or troubleshooting problem that you can’t figure out? One option is to open a support ticket with Microsoft Support (CSS). The CSS engineer will use a specific set of tools to collect and analyze workload data from your SQL Server. Based on this information they might recommend patches, configuration changes, or identify the worst-performing queries. But what if you could bypass support and do all of this analysis yourself? In this session, you’ll learn how to use battle tested tools to analyze your workload, read crash dumps, and error logs. Armed with this information, you’ll understand the root cause of the problem and propose solutions to performance and stability problems. Finally, you’ll learn the basics of debugging SQL Server so that when you finally run into a problem you can’t solve, you’ll be able to help Microsoft support help you.
Speaker(s):
- Kerry Tyler
Track and Room: Enterprise Database Administration Deployment - 115
Title: Python in SQL Server 2017
Abstract: SQL Server 2017 has finally arrived, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let’s get started!
In this introductory session we’ll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We’ll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We’ll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we’ll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!
Speaker(s):
- Chris Hyde
Track and Room: Advanced Analysis Techniques - 120
Title: vNUMA, pNUMA, save your SQL Servers from certain DoomA
Abstract: When presented with large SQL Server workloads in a virtual environment, which cross NUMA boundaries, it is very important to understand how the hypervisor presents vNUMA to the SQL Server virtual machine. When there is a NUMA imbalance, it can have as much as a 40% impact on performance, causing a significant effect on your virtual environment. In this session attendees will learn ways to optimize vNUMA including: • How vNUMA works across different processors; and the ways that Intel and AMD are different • Methods for determining if a NUMA imbalance exists • Which settings at the hypervisor, or virtual machine level, should be changed to ensure the best performance
Speaker(s):
- Shawn Meyers
Track and Room: Enterprise Database Administration Deployment - 115
Title: Twitter Data Sentiment Analysis: Staring Logic Apps, Azure ML, Twitter Data, Power BI, and Python
Abstract: Six months ago we went to Spider-man: Homecoming. On the way home I thought “I wonder what the rest of the world thinks of this movie? I wonder what people on Twitter are saying? I wonder if this is that tied to box office performance?” Over the last six months we’ve been building data sets on movies and collecting sentiment analysis of Twitter data. This lead to a journey of data discovery. First to figure out how to capture and analyze social media data from Twitter. Next we needed box office information. After that we wanted to capture sentiment. Then we wanted stock market data. Then we wanted movie information, runtime, rating, Metacritic score, IMDB score, and then how do we get historical data if we want to increase our data set? Once you collect the data how do you store it? How do you display it? All this and more….. but probably just this….because that’s a lot.
Speaker(s):
- Bradley Ball
Track and Room: Analytics and Visualization - 124
Title: Enabling EDW and BI workloads on Hadoop with Hive / LLAP + Druid!
Abstract: In its origin, Hadoop was created as an open source distributed computing system designed to process massive amounts of data in batches, but the many advantages of the platform lead to an immediate desire to run interactive analytical queries against Data Lakes built on Hadoop. The Stinger initiative accomplished just that! In this session, Luis Figueroa (Solutions Engineer @ Hortonworks) will walk you through the latest advancements that make Hadoop a powerful SQL engine that expands you EDW capabilities with unlimited scale and amazing flexibility. Luis will provide a technical overview of the Hive engine, an update on SQL compatibility with the ANSI standard, real world use cases and a live demo. If you are a data pro this session is for you!
Speaker(s):
- Luis Figueroa
Track and Room: BI Platform Architecture, Development Administration - 124
Title: SQL Server R Services in SQL 2016
Abstract: One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we’ll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We’ll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We’ll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we’ll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!
Speaker(s):
- Chris Hyde
Track and Room: Advanced Analysis Techniques - 120
Title: Eliminating Low Hanging Fruit for Faster Performance
Abstract: You know they are there, those small issues that affect performance and are easy to fix, but finding them can be a challenge. This session will show you how to find the low hanging fruit in your environment, explain why the problem exists, and step through how you can make the necessary changes to boost your SQL Server’s performance with a minimal amount of effort. With over 15 years experience, Jonathan will show you how to find common schema and code design problems, to help you get the most bang for your buck when performance tuning SQL Server. By focusing on real-world examples with reproducible workloads, you will easily be able to see the impact of common problems and learn how to fix them quickly for improved performance from the least amount of effort.
Speaker(s):
- Jonathan Kehayias
Track and Room: Application Database Development - 1101
Title: Don’t Get Lost in Translation: Multilingual Reporting in SSRS
Abstract: Today’s modern global business environment necessitates information being available in the end user’s native language. In the past this challenge has been met in a variety of ways with mixed results. Often companies maintain multiple sets of reports and data per language or implement solutions which perform poorly and are difficult to manage. The solution presented here is scalable, easily managed and performs better than commonly used solutions. This session will highlight how to create a pivoted dataset for the translated text, use native SSRS functions and change translations based on the user’s browser locale information. At the end of this session you will have a dynamic and robust method to handle multiple languages for reporting.
Speaker(s):
- David Scott
Track and Room: BI Platform Architecture, Development Administration - 124
Title: Artificial Intelligence, Cognitive Services, and Power BI
Abstract: Microsoft Cognitive services is a series of services based on Microsoft Research using Deep Learning techniques, ready for you to enrich your unstructured data. Microsoft Services includes: Vision (Computer Vision, Emotion, Face, Video), Speech/Language (Speaker Recognition, Spell, Sentiment, Language, Key Phrases, Topic detection, Linguistic Analysis), Knowledge, and Search. These services are consumed by using the Cognitive Services APIs. Power BI enables you to consume the APIs to enrich your unstructured data inside your Power BI solutions. During this session, we will cover how to consume the API using Power Query to then visualize the results with Power BI visuals. We will also consume the Cognitive services API by using a R script inside Power BI. This session is structured with a B2C Survey case study solution with a real time Dashboard using a streaming dataset.
Speaker(s):
- Paco Gonzalez
Track and Room: BI Information Delivery - 124
Title: SQL Server ColumnStore Indexes
Abstract: Come and learn how the SQL Server 2012 feature, ColumnStore Indexes, can parallelize your Data Warehouse aggregations. I will be doing a deep dive into the inner workings of ColumnStore indexes; how they work, key characteristics, dos and don’ts, restrictions, and more. I will have some insight into how CSI’s have been updated in SQL Server 2014 2016, as well. If you are a production DBA who needs to find out more about some of the additional hot features that have been included with CSI’s, like batch mode processing and data segments, then this session is for you. If you are a BI DBA or developer who needs to find out how CSI’s can increase the performance of your aggregations and star-joins by up to 40 times, then this session is also for you.
Speaker(s):
- Gareth Swanepoel
Track and Room: BI Platform Architecture, Development Administration - 118
Title: Securing SQL Server
Abstract: A default SQL Server installation is reasonably secure, but quot;reasonably securequot; doesn’t cut it in an era in which one bad line of code, one weak password, or one open port can result in your customer database ending up on Pastebin. In this talk, we will look at different methods of securing a SQL Server instance, from venerable (principle of least privilege, Transparent Data Encryption) to novel (Always Encrypted, row-level security). These tools and techniques will show us ways for developers, database administrators, and network specialists to work together to secure SQL Server instances.
Speaker(s):
- Kevin Feasel
Track and Room: Enterprise Database Administration Deployment - 1101
Title: Database Creation Process
Abstract: How to set up a Requirements Analysis to develop successful databases
Speaker(s):
- Arvin Meyer
Track and Room: Application Database Development - 123
Title: Azure Sql PAAS: Lessons from the Real World
Abstract: So you’re using Azure Sql Database Platform As A Service. Now what? Without a physical machine, how do you do restore? Where are the backup files? When are service packs applied? Can service packs be rolled up thru dev to production? What’s a service level and how does it impact database design? How do we encrypt, authorize, query tune, restore…? We’ll go over these questions and any others that you may have.
Speaker(s):
- Jonathon Moorman
Track and Room: Strategy and Architecture - 1102
Title: Temporal Tables: Creation, Use, and Optimizing
Abstract: With SQL 2016, Microsoft introduced Temporal tables. In this session we will learn what a Temporal table is, and discuss uses in current environments. We will learn how to create the tables and optimize them for query performance allowing simplicity for the consumers of the data.
Speaker(s):
- Dale Sullenberger
Track and Room: Enterprise Database Administration Deployment - 1102
Title: How To Tune A Multi-Terabyte Database For Optimum Performance.
Abstract: This session will cover how to tune a multi-terabyte database where all of the data is stored a single file, primary file group. We will look at file groups, managing indexes and moving large amounts of data.
Speaker(s):
- Jeff Taylor
Track and Room: Enterprise Database Administration Deployment - 1101
Title: Introduction to IoT using Azure
Abstract: Ever wondered on what is the buzz about Internet of Things (IoT)? and interested in making your own? We will take an look on what is Internet of Things (IoT), the impact of IoT to the world, industries that IoT can disrupt and then, we will provide an overview of building an IoT solutions using various technologies in Azure such as IoT Hub, Functions, Stream Analytics, Power BI, and more.
Speaker(s):
- John Wang
Track and Room: Strategy and Architecture - 112
Title: Welcome To the 2016 Query Store!
Abstract: One of my favorite new features in SQL Server 2016 is the Query Store. The Query Store houses valuable information on performance of your queries as well as gives you great insights into your query workload. This presentation will take a look at the Query Store, how it works and the type of information it holds. You will learn how to use the Query Store to quickly find plan changes and analyze performance issues caused by them. New DMVs will be introduced and the performance impact of enabling the Query Store will be discussed. Both DBAs and developers can increase their performance tuning skills by attending this session.
Speaker(s):
- Janis Griffin
Track and Room: Enterprise Database Administration Deployment - 1101
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 - 124
Title: Master Data Management with SQL Server 2016 MDS
Abstract: Want to know the position Master Data Management and MDS play in an organization’s overall data strategy? We’ll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We’ll then take a look at the features of SQL Server 2016 MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.
Speaker(s):
- Neal Waterstreet
Track and Room: BI Platform Architecture, Development Administration - 118
Title: Power BI administration made easy(ier)
Abstract: Now that you have Power BI in your organization the fun has just started! Making sure users get the best experience requires some thought and planning though. Come learn the fundamentals of the Power BI architecture and hear about best practices with assigning licenses, delegating roles, audit log analysis, gateway management and overall Power BI administration based on real-world experiences.
Speaker(s):
- Dan Evans
Track and Room: BI Platform Architecture, Development Administration - 123
Title: The DBA Survival Guide for In-Memory OLTP
Abstract: You know it’s coming . . . one day soon, you’ll be asked to take ownership of a database that uses In-Memory OLTP. Then what?
Deploying In-Memory OLTP affects the database ecosystem, including monitoring, data migration, logging, capacity planning, backup, restore, recovery, and more.
DBAs need to know optimal methods of migrating large data sets from disk to In-Memory, the differences between restore and recovery for memory-optimized databases, and many other facets of the In-Memory world.
Attendees will gain a clear understanding of the knowledge and skills required to administer In-Memory OLTP environments.
Speaker(s):
- Ned Otter
Track and Room: Enterprise Database Administration Deployment - 118
Title: A Beginner’s Guide to Power BI
Abstract: Are you new to Power BI Server? Do you want to learn what all the buzz is about and how to use it from a purely novice standpoint? Do you need to ramp up quickly to be able to build some great visualizations? This session is the session that you need! We will walk you through the basic architecture and nuances of Power BI all the while taking a fun adventure to building your first Power BI report. The attendee will leave the class ready to start using Power BI in the real world.
Speaker(s):
- Ed Watson
Track and Room: BI Information Delivery - 120
Title: Intro into SQL Server High Availability Technologies
Abstract: In this session, Harold will provide the overview of SQL Server HA/DR Technologies such as AlwaysOn Failover Clustering, AlwaysOn Availability Groups, Log Shipping, and Replication. You will learn how those technologies are implemented, their benefits, downsides, best use-cases, and choose the propper technology to meet business requirements.
Speaker(s):
- Harold Velazquez
Track and Room: Enterprise Database Administration Deployment - 112
Title: Migrations 101
Abstract: The only constant thing is change. As companies continue to migrate to newer versions or different data centers, we need to develop strategies and tools to make sure we can perform successful migrations. What if we had a checklist? Just like moving to a new home the success of the “move” relies on the preparation. This presentation will go over a checklist of steps needed to prepare for a database migration.
Speaker(s):
- Gilda Alvarez
Track and Room: Enterprise Database Administration Deployment - 1102
Title: How To Improve Your Career And Market Yourself For Success.
Abstract: This session will cover how to successfully market yourself by attending UserGroups, SQLSaturdays (You are off to a good start) and utilizing Social Media. I will be using real life examples on how I got to where I am today. This session is a motivational topic and will help individuals getting into the field or students.
Speaker(s):
- Albert Lau
Track and Room: Professional Development - 112
Title: PowerShell Core working with Python (Anaconda) and SQL Server Cross-platform
Abstract: As PowerShell is the main technology for automation in Windows Datacenters Infrastructure, now becomes clear its importance in other non-Windows Operating Systems. I’ll be providing sample on querying database information using Python and PowerShell cross-platform. This demo will show integrate technology using both PowerShell and Python (Anaconda).
Speaker(s):
- Maximo Trinidad
Track and Room: Application Database Development - 1102
Title: Lessons Learned from Two Years as a Devops DBA
Abstract: Join me as I talk about lessons learned from two years on a Devops team. Process, source control, changes that block, rolling back changes, out of band changes, and more! I still don’t have all the answers (or maybe even all the questions), but I can say this - DBA’s have nothing to fear and a lot to gain when an org adopts a devops culture.
Speaker(s):
- Andy Warren
Track and Room: Enterprise Database Administration Deployment - 1102
Title: Power BI-Create a Dashboard from Zero to Hero
Abstract: Every data has meaning, but we had limitation to use data through big long running process Extraction, Transformation and Representation, but now Power BI solves your problem to kick start having Data extraction in Power Query, Data Modelling and Transformation in Power Pivot and reach data representation using power view and power map on demand any nearby device on your fingertips. Learn how to create Power BI Dashboard from scratch.
Speaker(s):
- Vishal Pawar
Track and Room: BI Platform Architecture, Development Administration - 118
Title: #GetModern with Dell EMC’s iCDM
Abstract: Dell EMC’s unique integrated copy data management (iCDM) offering combines performance scalability with reduced operational risk through automation and self-services. Maximize the value of your company’s storage deployment by simplifying MS SQL database application workflows and reducing development timelines. In this session, we will discuss how application admins and DBAs can repurpose different copies SQL Server DBs instantaneously and become more agile.
Speaker(s):
- Bryan Walsh
Track and Room: Other - 115
Title: 13 Tips for an Effective Job Search
Abstract: It’s no surprise that embarking upon a job search can be a high-anxiety time. However, following an effective job search process and applying best practices when it comes to your resume and professional online marketing channels (including 4 current key resume truths), working with Recruiters, always attempting the “referral route,” leveraging alerts and other strategies, etc. can help reduce frustrations and make it better. In this session, we’ll highlight our top 13 strategies to help you go from “I’m not finding jobs I’m interested in” and/or “I’m not hearing back on my resume or from Recruiters” to “it’s time to prepare for my interview!”
Speaker(s):
- Erica Woods
Track and Room: Professional Development - 120
Title: Big Data on Azure: Processing, Wrangling Analysing DataSets using Scalable Programming Languages
Abstract: The world is changing rapidly and the big data ecosystem is enriching their capabilities even more, now there are a set of scalable languages that you can use in the Microsoft Azure environment to tackle and solve different problems, in this session you will learn the best practices, common scenarios and use cases for Hive, Pig, PolyBase, Scala, Python, Spark-SQL and U-SQL, in the end you will be able to understand the best fit for each one of those scalable languages.
Speaker(s):
- Luan Moreno Medeiros Maciel
Track and Room: Cloud Application Development Deployment - 120
Title: Introduction to Business Intelligence
Abstract: Are you curious about Business Intelligence and how it drives the world around us? In this session, we’ll cover high-level technical components of a BI system and the business processes that drive them. Whether you are new to IT in general or considering a career change, you’ll come out of this session with a basic understanding of the BI world.
Speaker(s):
- Kerry Tyler
Track and Room: Other - 1101
Title: Hack / Protect SQL Server - Come learn both.
Abstract: In this session, I’ll show you how to hack SQL Server using a simple C# console application and other tools. Most importantly, I’ll show you how to protect these vectors that perhaps you’re trying to use to safeguard sensitive data for GDPR compliance.
- Tabular Data Stream (TDS) Protocol
- Dynamic Data Masking
- Row Level Security (Yep…)
- Database Source Control
Perhaps, you’ve seen these exploits before but do you really know how to reproduce them? Or, how to even protect yourself against them?
No worries, I’ll show you the way along with a load test.
Speaker(s):
- Hiram Fleitas
Track and Room: Application Database Development - 118
Title: SQL Style
Abstract: SQL is different than most languages. As such, there’s a particular style of though that works best with SQL. This presentation will focus on the things that books and tutorials don’t. It will provide some perspective about the language and how to break large problems in smaller, more manageable ones.
Even if you’ve been writing SQL, this discussion might make challenging tasks easier!
Speaker(s):
- Robert Hatton
Track and Room: Application Database Development - 123
Title: Dynamic Data Masking - A Deep Dive Implementation
Abstract: One of the highly touted features of SQL 2016 is Dynamic Data Masking (DDM). In this session, we will take an in-depth deep dive into implementing DDM and discover its good, bad, and indifferent features. We will discuss use cases where DDM can help and where it may hinder development, QA, or auditing use cases. Attendees will leave the session with the knowledge needed to deploy a comprehensive DDM solution in their environments should DDM be a match for their use cases. High level data protection and auditing topics will be discussed as well.
Speaker(s):
- Bill Portman
Track and Room: Enterprise Database Administration Deployment - 112
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Tracy Boggiano
Twitter: - TracyBoggiano
LinkedIn: Tracy Boggiano
Contact: http://databasesuperhero.com
Tracy Boggiano is a Senior Database Administrator for DocuSIgn. She has spent over 20 years in IT, using SQL Server since 1999, and is currently certified as an MCSE Data Platform. Tracy has worked on SQL Server since 6.5. She has spoken at local user groups and numerous SQLSaturdays. She is currently a co-leader of a TriPASS Local Group in Raleigh, NC.
Tracy also tinkered with databases in middle school to keep her sports card collection organized. She blogs at databasesuperhero.com.
Her passion outside of SQL Server is volunteering with foster children as their advocate in court through volunteerforgal.org and being a mental health advocate as part of the PAIMI NC Advisory Council.
Paco Gonzalez
Twitter: - @pacosql
LinkedIn: Paco Gonzalez
Paco Gonzalez is the CEO of SolidQ North America, and a Microsoft Data Platform MVP. Focused on Business Analytics and Artificial Intelligence, he specializes in helping organizations become data driven from a strategic and technical perspective. Paco is a speaker at small and large conferences such as PASS Summit, Ignite, and Business Applications Summit, and he has published several books and whitepapers. He is based in Atlanta, GA.
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
Vishal Pawar
Twitter: - Vishal_BI
LinkedIn: Vishal Pawar
Contact: http://bimentalist.com/
Vishal Pawar is a Microsoft Data Platform MVP, Microsoft Certified Trainer (MCT), founder of the Global Power BI User Group and co-leader of the PASS Business Analytics Virtual Group. He is a Principal BI Architect in Green House Data, with decades of experience in BI solution architecture and best practices. He has published more than 1000 articles since 2011 in SQL and BI. Vishal teaches a free Power BI course through Udemy, which has more than 65K students from the glob. Vishal is an exceptional technology community of leaders worldwide who actively share their high quality, real-world expertise with the technical communities.
Maxwell Myrick
Twitter: - https://twitter.com/SQLHA
LinkedIn: Maxwell Myrick
Contact: http://sqlha.com/blog
Max Myrick is a SQL Server consultant whose experience includes 15 years at Microsoft with 5 years on the SQL Server development team where he ran the SQL Customer Lab and then the Sustained Engineering team. He was an founding member of Microsoft#39;s Mission Critical team where he worked with the largest SQL Server applications worldwide for almost a decade. Max was a regular speaker for Microsoft and has continued to speak at various PASS and other SQL Conferences since becoming a managing partner of SQLHA LLC.
Luan Moreno Medeiros Maciel
Twitter: - @luansql
LinkedIn: Luan Moreno Medeiros Maciel
Contact: https://luanmorenodba.wordpress.com/ amp; http://www.sqlshack.com/author/luan-moreno-m-maciel/
Based out of Brazil, Luan Moreno credits his ability to solve problems to thinking critically before acting. He values working with a team because he and his clients can benefit from various perspectives and collaboration, particularly when faced with difficult issues. When Luan Moreno first became interested in technology, he didn’t have a mentor, so he made a commitment to teaching others in the community and sharing his knowledge through blogging, speaking engagements.
Luan Moreno is a addicted Brazilian blogger and speaker. SQL Server MCT, MCSE and MVP living in Brazil. Nowadays he#39;s a Database Consultant at Pythian, company based in Ottawa - Canada.#160;
Shawn Meyers
Twitter: - 1dizzygoose
LinkedIn: Shawn Meyers
Shawn Meyers is a Field CTO working at Tintri. Shawn has worked in IT for 25+ years and specifically with SQL Server for 20+ years, beginning with version 6.5. A frequent speaker at many events including PASS Summit, VMworld, VMUGs, Virtual Chapter sessions, and many SQLSaturday events. Current focus is on improving DBAs lives with better infrastructure.
Albert Lau
Twitter: - PCOibo
LinkedIn: Albert Lau
Albert Lau is a Database Administrator (DBA) and has been working with database for over 8+ years starting with SQL Server 2000. Albert started as at Client Services working on SQL Server Reporting Services Reports and worked his way up to becoming a Database Administrator.
Kerry Tyler
Twitter: - AirborneGeek
LinkedIn: Kerry Tyler
Contact: http://airbornegeek.com
Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.
Ronald Dameron
Twitter: - @RonDBA
LinkedIn: Ronald Dameron
Contact: http://RonaldDameron.com
Ronald Dameron is The Only DBA at a small software company building planet-scale mobile resource management software.
He has over 20 years IT experience on a variety of platforms. His current interests are Azure, PowerShell, SQL Server 2016 and Linux.
He was a PASS Summit 2015 Speaker Idol contestant and has spoken at SQLSaturday Tampa, Orlando, South Florida, and the Tampa and Orlando SQL User groups. He has recently earned the Competent Communicator Award from Toastmasters International.
He is most active on Twitter as @RonDBA.
Frank Quintana
Twitter: - Frankqr2
LinkedIn: Frank Quintana
Contact: http://www.businessintelligencematters.us
Doctor Quintana has been involved in optimization and math modeling since the ’80s. He is an IT University professor of Data Science, Databases, Data Mining, and Knowledge Discovery. He is a former head of an RD department. He worked as a research engineer at the Memorial University of Newfoundland. He also worked as a consultant in the role of a technical team leader and software architect for EDS responsible for critical parts of the SDLC for multi-million dollar projects. He is one of the Software Architects that designed and built the “Health and Benefits System for the of the Veteran Affairs of Canada” He is a regular speaker at national and international events In 2004 he started his consulting practice in South and Central Flori
Bill Portman
Twitter: - @bpportman
LinkedIn: Bill Portman
Global DBA Manager with over 20 years experience in data architecture, database administration, and software development leadership roles. Highly successful hands on team leader and mentor. I first fell in love a language called SQL on the AS400. Since then, I’ve worked with SQL Server versions 6.5 through 2016. I currently manage a 500 server, 10k database infrastructure with a team of five people. My specialties include database administration and architecture, enterprise software development, process re-engineering, project management, policy standards development, vendor management, offshore vendor management, training, team development and leadership.
John Wang
John Wang is a Back-end .NET Developer. Currently, his interests are IoT, big compute, services, cloud computing, Powershell and SQL topics. He is an frequent speaker at the various Code Camp, Meetup, IT Pro Camp and SQLSaturday.
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.
Bryan Walsh
Twitter: - @BryanJWalsh
20 years into a career focused on Microsoft technologies and the impact of they make for companies across all industries and verticals. Started at EMC in 2006 and have held numerous leadership roles that champion Microsoft to our field, partners and customers. In my current role at XtremIO, my primary focus is SQL Server and how to unlock agility and end storage inefficiency.
Bryan Cafferky
LinkedIn: Bryan Cafferky
Contact: https://www.youtube.com/user/Bryancutube256123
Bryan Cafferky is a Big Data and AI consultant. Bryan was previously a Senior Data Science Training Content Developer for Microsoft Worldwide Learning. Prior to this he was a Microsoft Data and AI Enabler for healthcare customers. He is a Microsoft 2017 Data Platform MVP and a 2016 Cloud and Data Center Management MVP. Bryan is the author of Pro PowerShell for Database Developers by Apress, available on Amazon. He leads The RI Microsoft BI User Group, and The Greater Boston Area Data Science Group. He has been working with the SQL Server stack since 1997 and implemented projects in the banking, insurance, e-commerce, utility, and health care industries. He holds a bachelor of science in computer information systems and an MBA.
Bradley Ball
Twitter: - @SQLBalls
LinkedIn: Bradley Ball
Contact: http://www.sqlballs.com
Bradley Ball is a Sr. Azure Engineer for Microsoft, and former Data Platform MVP. During his IT career Bradley has spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States, and the former Data Platform Practice Manager for Pragmatic Works Consulting. He has presented at SQLSaturdays, SSUG’s, SQL Rally, DevConnections, SQLBits, SQL Live 360, and the PASS Summit. Bradley can be found blogging on http://www.SQLBalls.com
Andy Warren
Twitter: - @sqlandy
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
Glenda Gable
Twitter: - @ggable313
Contact: http://sql313.com
Glenda has worked with databases in some form or another for 13 years, and loves working with data. She has worked in the healthcare, state park, construction licensing, and not-for-profit industries. She currently works for LHC Group in Lafayette, LA in BI, handling everything from servers/software maintenance to reporting and all the ETL transactions in between. Glenda is the President of the Acadiana SQL User Group in Lafayette and speaks at local events.
Neal Waterstreet
Twitter: - @nealwaterstreet
LinkedIn: Neal Waterstreet
Contact: http://www.nealwaterstreet.com
Neal is a BI Architect/Consultant with more than 20 years of industry experience. Neal is skilled in the entire BI spectrum, including dimensional modeling, ETL design and development using Integration Services (SSIS), designing and developing multidimensional cubes and Tabular models using Analysis Services (SSAS) and Master Data Management using Microsoft Data Services (MDS). He’s also involved with the database community and is the co-founder and co-leader of the PASS Healthcare Virtual Chapter and the Atlanta Modern Excel User Group.
Dmitri Korotkevitch
Twitter: - aboutsqlserver
LinkedIn: Dmitri Korotkevitch
Contact: http://aboutsqlserver.com
Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect.
Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.
Ed Watson
Twitter: - http://twitter.com/SQLGator
LinkedIn: Ed Watson
Contact: http://sqlgator.com
Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQLSaturday Atlanta, Atlanta BI, and Pensacola.
Jonathan Kehayias
Twitter: - @SQLPoolBoy
Contact: https://www.sqlskills.com/blogs/jonathan
Jonathan Kehayias is a Principal Consultant and trainer with SQLskills, and has been recognized as a Microsoft Data Platform MVP for over 10 years, and was the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification. He has presented at numerous conferences including PASS Summit and SQL Rally, SQLBits, VMware Open Forum, SQLintersection, and multiple SQLSaturdays around the world. As a performance tuning and high availability expert for SQL Server, Jonathan has architected and implemented complex systems and solutions for some of the worlds most challenging workloads.
Gilda Alvarez
Twitter: - @Latina_DBA
She graduated from the University of Central Florida with MIS and Computer science degrees. She has over a decade of experience in Enterprise Information Technology solutions for several Fortune 500 companies. In depth and applied knowledge of database administration with emphasis on high availability and disaster recovery solutions, security audits, database health checks, capacity planning, resource utilization analysis and enterprise database migrations. She is a big advocate of technical and leadership education in her community. She loves to spend time with her family, friends and dance Latin music.
Jonathon Moorman
LinkedIn: Jonathon Moorman
Jon has developed using Sql Server since version 6.0! Easily distracted by shiny objects, he has always been on the bleeding edge of sql development. When not presenting, Jon might be found backpacking, hiking, camping, canoeing, or simply resting at home with a good scifi book.
Gareth Swanepoel
Twitter: - @GarethSwan
Contact: http://mygareth.com
Gareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 25 years. He enjoys solving the complex problems that customers encounter when performance tuning SQL Server or when deploying SQL Server in large data warehouse environments. He is originally from South Africa and is currently a Dedicated Support Engineer (PFE) with Microsoft. He is a passionate member of the SQL Server community and is an accomplished author and speaker having presented at various user groups, SQLSaturdays, the PASS Summit and other technical conferences.
Arvin Meyer
LinkedIn: Arvin Meyer
Having 16 consecutive MVP awards, Arvin maintains the Access Web http://www.mvps.org/access, an Access download site on his domain (http://www.datastrat.com), owns and is webmaster of http://www.accessmvp.com, and several client websites. A Microsoft Certified Professional and Microsoft MVP, Arvin writes freelance technology articles, is an author of a book on Access, leads the Access, Office, and Security Special Interest Groups at the Central Florida Computer Society.
Maximo Trinidad
Twitter: - maxtrinidad
LinkedIn: Maximo Trinidad
Contact: http://www.maxtblog.com
Maximo Trinidad (Florida Aka – Mr. PowerShell), currently work as a SAPIEN Technologies Evangelist and specialing in scripting automation on SQL Server Microsoft Cloud Technologies. Also a Microsoft MVP (PowerShell) since 2009 and active speaker since 2007 participating at SQLSaturday, IT Pro .NET Code Camps events.
Dan Evans
Twitter: - @danthebiman
LinkedIn: Dan Evans
Dan Evans is a Data and Analytics evangelist with over 25 years’ experience deploying strategic and innovative analytic solutions. He’s focused on Microsoft technologies including Data Platform, Advanced Analytics and Business Applications. Current focuses include SQL Server, Power Suite, Cognitive Services, Artifical Inteligence and other Data Platform related topics in Azure. Dan presents at many local, regional and national events including SQL PASS, DAMA, TDWI, TechEd and Ignite and supports best practices in Microsoft data and analytics across North America.
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.
Kevin Feasel
Twitter: - feaselkl
LinkedIn: Kevin Feasel
Contact: http://www.catallaxyservices.com
Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.
Harold Velazquez
Harold (MSCE, MSMIS) has been working with SQL Server for over 18 years focusing on high availability, disaster recovery, OLTP databases, virtualization, and performance troubleshooting. Currently he is working as Sr. Enterprise Database Administrator at Chewy.com managing mission-critical, highly transactional SQL Servers environments with little or no maintenance windows, and 100% uptime business requirement.
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.
David Scott
LinkedIn: David Scott
Dave is a Florida native who grew up and attended high school in St. Petersburg, FL. He served six years (1994 -2000) in the US Army as a UH-60 Black Hawk mechanic and crew chief with the 50th Medical Company (Eagle DUSTOFF) of the 101st Airborne Division at Ft. Campbell, KY. After leaving the Army he attended the University of Central Florida in Orlando, FL where he received is BS in Information System Technologies in 2004. Dave recently earned his MCSA in Business Intelligence and is currently employed with eBECS N.A. as a Business Intelligence Consultant. In his spare time Dave enjoys inshore fishing, BBQ, and spending time with friends and family. Seeking a new challenge, Dave recently took up Golf. He had the shirts, so why not?
Robert Hatton
LinkedIn: Robert Hatton
Contact: http://www.RobertJHatton.com
Rob Hatton is the author of the Business Intelligence Team Handbook.
Rob is also a past president of the PASS Business Intelligence User Group here in Tampa. He is a veteran B.I. developer with more than 30 years of database experience and dozens of successful B.I. project deployments.
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.
Jeff Taylor
Twitter: - reviewmydb
LinkedIn: Jeff Taylor
Contact: https://blog.reviewmydb.com
Jeff Taylor is a Senior Software Data Architect. His work with databases began with SQL Server 6.5 over 22 years ago. He specializes in performance tuning and critical operational database issues. Currently he is serving as the President of the Jacksonville SQL Server Users Group and is an active board member of the Jacksonville Development Users Group.
Luis Figueroa
Twitter: - @luisefigueroa
LinkedIn: Luis Figueroa
Contact: http://blog.luisfigueroa.net
Luis Figueroa is a data professional with more than 15 years of experience in Information Technologies across many industry verticals. Luis has held a variety of positions in IT such as Network Administrator, Systems Engineer, Database Administrator and EDW / BI Architect. In the most recent years Luis found his passion in architecting and developing open source data centric solutions that help businesses manage their data and gain a competitive advantage through analytics. Luis currently holds a position as Solutions Engineer for Hortonworks, Inc. where he works with many clients including Fortune 500 companies. Luis’ main focus areas are in Data Warehousing, Business Intelligence, Advanced Analytics, Big Data, IoT and Cloud Computing.
Michael Antonovich
Twitter: - @SharePointMikeA
LinkedIn: Michael Antonovich
Contact: http://sharepointmike.wordpress.com
Michael Antonovich is the assistant director of Web and Technology Services in the Communications Division for Orange County Public Schools in Orlando, FL, where he manages the Internet and intranet infrastructure. He has published seven books, ranging from an Apple II User Guide to Office and SharePoint 2010 User’s Guide. His blog has focused mainly on PowerPivot and Power BI, but for the last year Mike has taken a break to pursue some other activities. He hopes to restart his blog later this year focusing more on style and presentation. Mike has used SQL Server since 1998 and, for the past 7 years, has been promoting SSAS, PowerPivot, and Power BI for the masses.
Ned Otter
Twitter: - @NedOtter
LinkedIn: Ned Otter
Contact: http://www.nedotter.com
DBA with vast experience administering Microsoft SQL Server since version 4.21 to the present.
Certifications:
MCSE SQL Server 2012 Data Platform
MCTS SQL Server 2008
Overall computer experience: 25 years
SQL Server experience: 23 years
Currently obsessed with In-Memory technology.
Please see LinkedIn profile for more details.
Jonathan Kehayias
Twitter: - @SQLPoolBoy
Contact: https://www.sqlskills.com/blogs/jonathan
Jonathan Kehayias is a Principal Consultant and trainer with SQLskills, and has been recognized as a Microsoft Data Platform MVP for over 10 years, and was the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification. He has presented at numerous conferences including PASS Summit and SQL Rally, SQLBits, VMware Open Forum, SQLintersection, and multiple SQLSaturdays around the world. As a performance tuning and high availability expert for SQL Server, Jonathan has architected and implemented complex systems and solutions for some of the worlds most challenging workloads.
William Wolf
Twitter: - sqlwarewolf
LinkedIn: William Wolf
Contact: http://www.sqlwarewolf.com
Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQLSaturday veteran speaking at nearly 40 SQLSaturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.
Erica Woods
Twitter: - ericawoodsgo
LinkedIn: Erica Woods
Contact: https://www.mssqltips.com/sqlserverauthor/128/erica-woods/
Erica Woods is the Manager of Contractor and Community Relations at Apex Systems, a national IT Staffing and Services firm. Her focus is on program management, training and development, customer relations, community evangelism and corporate social responsibility, communications, marketing and social media. She has 10 years of IT staffing, an MBA from Loyola University, is an Author at MSSQLTips, and runs a group called Techies for Good.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Andrew Novick
LinkedIn: Andrew Novick
Andrew Novick is a SQL Server consultant building business solutions with the Microsoft tools. His expertise in database design, T-SQL coding, SQL Server security, database performance tuning, and database partitioning can be a valuable asset to many projects. Andrew Novick also offers training and mentoring services to relevant projects. His writing on computing can be seen at his web site http://www.NovickSoftware.com
Kerry Tyler
Twitter: - AirborneGeek
LinkedIn: Kerry Tyler
Contact: http://airbornegeek.com
Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.
Sayed Saeed
LinkedIn: Sayed Saeed
Contact: http://www.plusconsulting.com/blog/
Sayed Saeed is the Business Intelligence Practice Director at Plus Consulting. He is highly proficient in developing targeted BI solutions for clients and offers solid knowledge and experience in BI products that help organizations better leverage information to effectively manage business. He is a Microsoft Certified Solutions Expert in Business Intelligence as well as Oracle Certified Professional.
Hiram Fleitas
Twitter: - @hiramfleitas
LinkedIn: Hiram Fleitas
Contact: http://fleitasarts.com
Hiram Fleitas develops and manages database applications and AI bots using Machine Learning models trained on natural language, claims, policy, and social media data to predict business opportunities that grow customer satisfaction and loyalty in real-time.
He’s worked with SQL Server for over 20 years, with some of the largest companies in the world. He’s spoken on SQL Server, Azure and Power BI at User Groups, Code Camps, SQLSaturdays, and corporate events. He coded his first program in BASIC at 13 years old and developed a passion for computers ever since.
Hiram is also a code contributor to several open source projects and serves as the IS Flotilla Staff Officer for the United States Coast Guard Auxiliary.
Dale Sullenberger
LinkedIn: Dale Sullenberger
Dale lives in Valrico, FL with his wife Connie and son Nathan, three dogs and two cats.
While there is some prior user level database experience, Dale has been working with SQL Server in some manner since 1997, and has been in a DBA role for 13 years.
Sponsors
The following is a list of sponsors that helped fund the event: