SQLSaturday #371 - Tampa 2015
Event Date: 02/28/2015 00:00:00
Event Location:
- USF College of Business Bldg
- 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: Turbocharge Your Career With a Learning Plan
Abstract: What will you learn next quarter and why? How will you learn it? How much time and money will it cost? What is the ROI on learning those skills? Those are the questions that you answer by building a learning plan and, if you do it well, you’ll find yourself steadily pulling away from your peers.
It starts with a learning list, a place to capture skills you think you need to learn. That’s where you score each topic by estimating the effort to learn it in time and money and the value it adds to your career now and later. It’s absolutely an analog process, but it gives you the framework for answering one question: what do I learn next and why?
Once you’ve picked a topic, how do you learn more about it? Do you read blogs, buy books, or attend a class? Or all of the above? How much time makes sense? Join this session and learn how to dig into the topic to answer the questions that lead to a learning plan. After that, it’s just a matter of executing the plan!
Speaker(s):
- Andy Warren
Track and Room: Azure / Prof Dev - N/A
Title: DevOps for the DBA - Bridging the Gap Between Infrastructure, Administration, and Development
Abstract: DevOps is a term that has come to mean many things to many people. At its core, this important concept represents a way to remove old barriers between the infrastructure, application, and development tiers within an IT organization. An understanding of scripting and automation platforms is becoming a critical skill for SQL Server Database Administrators. Additionally, as hardware is increasingly virtualized, new opportunities for scripted deployment and configuration are available. This session will utilize demos to illustrate the many ways SQL Database Administrators can automate routine tasks from deployment through configuration.
Speaker(s):
- Denis McDowell
Track and Room: Misc - N/A
Title: Transactional Replication: Tuning and Troubleshooting
Abstract: At some point in every DBA’s career they’ll be probably be asked to work with transactional replication but most DBAs don’t look under the covers once they’re done walking through the setup wizards. In this session we’ll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies. Session Goals: • Learn how to baseline performance metrics by gleaning information from the distribution database • Show how to tune replication agent performance with agent profiles • Demonstrate advanced troubleshooting techniques to apply when problems occur
Speaker(s):
- Kendal Van Dyke
Track and Room: BI 2 - N/A
Title: Transactional Replication: Architecture, Setup, and Monitoring
Abstract: At some point in every DBA’s career they’ll be probably be asked to work with transactional replication. While it may seem scary at first, it’s not that complicated once you understand how all the parts and pieces work together. In this session we’ll cover the fundamentals of how transactional replication works, walk through setting up a working replication topology, and learn how to keep an eye on things to make sure everything is working properly. Session Goals: • Understand core concepts of transactional replication including: replication topologies, publishers, distributors, agents, agent profiles. • Learn how to configure a working replication topology • Learn how to how to monitor transactional replication performance
Speaker(s):
- Kendal Van Dyke
Track and Room: DBA 2 - N/A
Title: Introducing Cube World To Users From Flat Table Land
Abstract: This session explores the tabular approach to building cubes in SQL Server Analysis Services 2012 for those DBAs and developers who are more comfortable working with relational databases than cubes. Starting with a ‘normal’ relational database, the attendee will learn how to build a basic model by loading data from several data sources, establish relations between these data sources, define measures and dimensions, build hierarchies, create KPIs and deploy functional cubes that can be used to answer management’s questions about what is really going on with their data. For users already familiar with PowerPivot, this session provides a good transition into the world of SSAS as both use essentially the same techniques.
Speaker(s):
- Michael Antonovich
Track and Room: BI 2 - N/A
Title: Friendlier Data Profiling with the SSIS Data Profiler Task
Abstract: The SSIS Data Profiler Task contains great functionality, but is not very flexible nor dynamically configurable. Worse, it outputs to xml files only. In this session I will demonstrate an SSIS solution which uses dynamic expressions to flexibly configure what is profiled. The solution also writes to a custom database instead of xml, enabling trending, auditing and reporting. The solution will be made available to attendees.
Speaker(s):
- Julie Smith
Track and Room: SSIS - N/A
Title: SQL Server 2014 for the DBA
Abstract: SQL Server 2014 is the newest version of SQL Server available from Microsoft. This session is designed to introduce SQL Server DBA’s to some of the new and exciting features available in that version. Topics covered in this session include AlwaysOn enhancements, Clustered ColumnStore indexes, Memory-optimised tables (In-Memory OLTP, code-named Hekaton) and Extended Events enhancements. The target of this session is SQL Server DBA’s, developers, architects or IT professionals who are excited about the new SQL Server 2014 features and are looking to learn more about them. This class assumes that you have average to good T-SQL skills already and a good understanding of SQL Server fundamentals.
Speaker(s):
- Gareth Swanepoel
Track and Room: SSIS - N/A
Title: A practical guide to Windows Azure SQL Database for the DBA
Abstract: What is “Windows Azure SQL Database” all about ? What does this mean for me as a DBA ? What is the process for setting up a Windows Azure database ? How would I go about migrating one of my databases to “The Cloud” ? How do I possibly leverage this new technology in my production environment ? If you are a production DBA and have contemplated one or more of these questions, this session is for you! Maybe, you have been tasked with finding out about “The Cloud”. Join me in exploring the cloud where I will show you how SQL Server works in the Windows Azure SQL Database world. We will run through the simple process of configuring a Windows Azure SQL database. We will investigate the similarities and differences between on premises SQL Server and Windows Azure SQL Databases. We will even look into the DR, HA, monitoring and performance tuning options available with Windows Azure.
Speaker(s):
- Gareth Swanepoel
Track and Room: Azure / Prof Dev - N/A
Title: Sentiment Analysis with Big Data
Abstract: People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning
Speaker(s):
- Paco Gonzalez
Track and Room: BI 1 - N/A
Title: Real World SQL Server Administration with just a bit of sysadmin
Abstract: It is becoming increasingly difficult to allow SQL Server database administrators to retain sysadmin permission 24x7x365 on production servers due to IT Security, Audit, and Compliance concerns.
This session will review the fundamentals needed to define a configurable permission model that allows your company’s DBAs to do routine work without them having unfettered access to business data. Several demonstrations will prove that many DBA tasks can be done without sysadmin access. Attendees will also learn how to deploy a permission model that allows DBAs to do routine work, elevate DBA permissions quickly to respond to production emergencies and how to grant sysadmin permissions during disaster recovery scenarios. Scripts will be reviewed and demonstrated that secure the database server and that can undo the permission model in case of unforeseen circumstances.
Speaker(s):
- Ronald Dameron
Track and Room: DBA 2 - N/A
Title: Powershell Working with Windows Azure SQL Database Server
Abstract: In this presentation I will be covering how to subscribe to Azure, setup PowerShell to connect your subscription, use scripting to create a SQL Database Server and then use SMO with PowerShell push data to your SQL Azure tables. All this using PowerShell scripting plus showing some editor, scripting techniques, and tips to avoid issues when working and setting Azure with PowerShell. (Live demo with Windows Azure)
Speaker(s):
- Maximo Trinidad
Track and Room: Azure / Prof Dev - N/A
Title: Manage Both On-Prem and Azure Databases with PowerShell
Abstract: In today’s world you’re more likely to have databases both on premises and in the cloud. Managing databases in different environments can make your life more complicated, but with the new PowerShell cmdlets introduced with SQL Server 2014 it actually becomes easier. In this session we’ll introduce you to the new cmdlets and show you how to manage your on-prem and Azure databases consistently.
Speaker(s):
- Allen White
Track and Room: Azure / Prof Dev - N/A
Title: Common SQL Server Security Mistakes (And The Fixes)
Abstract: Are your instances secure? Or do you worry that you’ve missed something, or made a mistake without realizing it? From install and configuration to day to day operations there are plenty of opportunities for mistakes to happen that can give an attacker a opening they can exploit. This presentation will discuss common security mistakes and how to fix them in areas including installation, patching, performance tuning, and more. We’ll also look at mistakes that are made by your users and what you can do to mitigate those. Intended for beginner to intermediate users, even experienced DBA’s will find this presentation a useful refresher.
Speaker(s):
- Andy Warren
Track and Room: DBA 2 - N/A
Title: APPLY Yourself
Abstract: Microsoft introduced the APPLY operator in SQL Server 2005. This under-used, non-standard operator can help us solve a number of common (and not-so-common) problems with elegant code which performs well. We will look several problem spaces in which the APPLY operator shines, such as joining to table-valued functions, getting the top N child records for each parent record, string splitting, and word matching. With the use of these examples, we will gain a deeper understanding of when to use the APPLY operator.
Speaker(s):
- Kevin Feasel
Track and Room: DBA 1 - N/A
Title: SQL Server 2014 In-Memory Programming
Abstract: SQL Server 2014 introduces a game changer technology; in-memory objects. This session is a hands-on demo based presentation that will introduce you to what the technology is and how to use it. You will come out of this session with the knowledge and scripts that you can take back to your shop and instantly be productive. You will gain an understanding of the architecture, how to get started, indexes, natively compiled stored procedures and the limitations.
Speaker(s):
- miguel Cebollero
Track and Room: SSIS - N/A
Title: SQL 2014 In Memory OLTP and Natively Compiled Stored Procedures
Abstract: With the release of SQL Server 2014 one of the most talked about new features is the In Memory OLTP (project “Hekaton”) and natively compiled stored procedures which promise to deliver dramatic performance increases. But, is this new feature ready for prime time or another version one that should be avoided until the next release? In this session we will look at how you implement memory optimized tables and compiled procedures, do some quick demos and comparisons to see what the hype is about, and examine some of the considerations and requirements.
Speaker(s):
- Eric Wisdahl
Track and Room: DBA 2 - N/A
Title: Introduction to Wait Types and Response Time Analysis
Abstract: Using Response Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Response time performance analysis to solve the most difficult performance related issues.
Speaker(s):
- Janis Griffin
Track and Room: DBA 1 - N/A
Title: DAX 101
Abstract: In this session, we will look at the new BI query language for PowerPivot and Tabular - DAX. This session will give you an introduction to Data Analysis eXpressions (DAX) and will provide you the necessary understanding to start using in your environment for data analysis. No prior experience with DAX is needed to attend this session.
Speaker(s):
- Damu Venkatesan
Track and Room: BI 1 - N/A
Title: Advance SSIS development using .NET framework –Real work Situations–
Abstract: On this session we are going to deal with real work situations such as the loading and transformation of fixed width files in EBCDIC. Conversion of comp-2 and comp-3 fields using custom ssis components and the creation of metadata to dynamic generate ssis at run time.
Speaker(s):
- Jorge Novo
Track and Room: SSIS - N/A
Title: Query Tuning - Get it Right the First Time
Abstract: SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis and SQL diagramming techniques. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path with no guessing. If you are a beginner or expert, this approach will save you countless hours tuning a query.
Speaker(s):
- Janis Griffin
Track and Room: DBA 1 - N/A
Title: Master Data Service in Practice: An Integrated Approach
Abstract: Businesses depend on reliable, consistent and correct data that can be managed effectively and shared through-out the enterprise. Master Data Services provides a powerful, feature-rich platform for arriving at this destination but the successful journey to this end requires a proven integrated approach. This session will discuss how MDS fits in the overall EIM architecture within your customer’s organization including real-world strategies for integrating (cleansing, matching and loading) Master Data into MDS and for making it available organization-wide.
Speaker(s):
- Christopher Price
Track and Room: Misc - N/A
Title: Getting Started with Analysis Services Tabular mode
Abstract: Analysis Services Tabular is an in memory analytics engine introduced in SQL Server 2012. It has shown to be a quick and effective way to transform your organization with modern analytics. Join Phillip and learn how easy it is to create a tabular solution and provide valuable insight into your organization’s data.
Speaker(s):
- Phillip Labry
Track and Room: BI 2 - N/A
Title: Maintain SQL Server Performance Baseline w/PowerShell
Abstract: Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.
Speaker(s):
- Allen White
Track and Room: BI 2 - N/A
Title: Introduction to Azure Machine Learning Experiments
Abstract: With a renewed emphasis on data mining and machine learning, the Azure Machine Learning service offers customers a solid and approachable platform for developing intelligent, analytical systems. In this session, we will explore how the Azure Machine Learning service can be leveraged in the context of a typical data mining project methodology. From experiment design and model development to integration of the experiment into a line of business application, we will walk through a full lifecycle demonstration while exploring the most common and useful features.
Speaker(s):
- Christopher Price
Track and Room: BI 1 - N/A
Title: Extend the Reach of Power BI with Easy Data Integration
Abstract: In this session we will show you how to extend the reach of Power BI using easy to use tools from the Dell Information Management Group to connect to Relational, NoSQL and Cloud Sources. Using standard Ansi SQL means that you can talk across all of these platforms with one language and one tool to enable data to be provisioned in a secure collaboration environment for your end users.
Speaker(s):
- Peter Evans
Track and Room: BI 1 - N/A
Title: Indexing for performance
Abstract: Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
Speaker(s):
- Jeffrey Garbus
Track and Room: DBA 1 - N/A
Title: SSIS performance Tuning
Abstract: The class would be an entry level course to tuning SSIS packages and little tips and tricks to help you along the way.
Speaker(s):
- Dan King
Track and Room: SSIS - N/A
Title: Virtualize Clusters and AlwaysOn Availability Groups
Abstract: Traditional SQL server clusters present some challenges when running under VMware this session will cover why to virtualize your SQL server cluster, when you should not virtualize your SQL server cluster and when virtualization technologies can replace clustering methods. The session will then cover best configuration options for clusters and AlwaysOn Availability Groups (AAOG). This session assumes you understand clustering and AAOG and is focusing impact of running being in a virtual environment.
Speaker(s):
- Shawn Meyers
Track and Room: DBA 2 - N/A
Title: Introducing the Reimagined Power BI Platform
Abstract: You have seen glimpses of the new Power BI offering at WPC and PASS in 2014. Microsoft has totally reimagined the Power BI platform, user experience, added developer APIs, custom apps, hybrid direct connectivity to on-premise data sources without data copying and other top secret enhancements that we can dive into by the time of this session. Join me to explore all these great changes for both BI professionals and Power BI users.
Speaker(s):
- Jen Underwood
Track and Room: BI 1 - N/A
Title: “A New Data Architecture: Business Intelligence (BI) and Big Data Management Systems (BDMS)”
Abstract: The arrival of the Big Data movement (Hadoop and NoSQL) is changing the Enterprise Data Architecture. This presentation is a continuation of my previous presentation “An Introduction of Business Intelligence and Big Data” In this presentation, I will describe advantages and disadvantages of OLTP, OLAP and Big Data, and the rise of BDMS (BIG DATA MANAGEMENT SYSTEMS). I will show how the Modern Database Architecture landscape is changing.
Speaker(s):
- Frank Quintana
Track and Room: BI 1 - N/A
Title: Access as a fron-end ro SQL-Server
Abstract: Microsoft Access makes an unparalleled front-end for any version of SQL-Server. This session will explain the how and why.
Speaker(s):
- Arvin Meyer
Track and Room: Misc - N/A
Title: How to be a GREAT DBA
Abstract: This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication.
Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.
Speaker(s):
- Jeffrey Garbus
Track and Room: Misc - N/A
Title: Business Rules, Data Governance, and Workflow with MDS and Maestro
Abstract: In this session we will show you how to use business rules and workflow to facilitate data governance and business processes around master data management using the built in MDS tools and Maestro.
Speaker(s):
- Gene Webb
Track and Room: BI 2 - N/A
Title: Reusable ssis development using Parent - Child methodology
Abstract: On this session we are going to cover the creation of independent packages and how to create a package controller using package configuration features to create a parent - child work flow. what would be cover: Creation of ssis package controllers, How to used package configuration features Passing parameters from a parent package to a child package
Speaker(s):
- Jorge Novo
Track and Room: SSIS - N/A
Title: Performance Tuning - Index Optimization
Abstract: This topic will cover best practices when optimizing index performance in your DBMS. This presentation is targeted for mid to senior level DBA’s. You will learn the optimal strategy for selecting both clustered and non-clustered indexes in your database. Along the way, we will discuss how column and index statistics can affect the performance in your queries. Finally, we will take a look at the benefits and pitfalls of using filtered, full-text search and composite indexes, their best practices, and exceptions to the rules.
Speaker(s):
- Konstantin Melamud
Track and Room: DBA 1 - N/A
Title: Exploring Azure for Storage Options
Abstract: Cloud is full of buzz nowadays, even for data storage. But is it right for you? When might you might want to use Azure for your data storage? During this session we’ll explore the various Azure data storage options include SQL via IaaS, SQL DB, Azure Storage, DocumentDB, and using third party solutions like Mongo and MySQL in Microsoft Azure. You’ll leave having a good idea of what each Azure storage option is good for, along with some of the tips and tricks of working with each. We’ll also explore how to provision up storage instances and use them in your applications.
Speaker(s):
- Joe Healy
Track and Room: Azure / Prof Dev - N/A
Title: .NET for Data Professionals
Abstract: Are you a DBA who knows nothing or very little about .NET? It’s a more common than you might think, but most DBA’s cringe at the thought of seeing C# code. Still, there are a lot of gems in this tried and tested toolbox. In this session, we’ll cover the portions of .NET that are useful for any data professional. If you’re into database development, administration, or ETL - .NET has some useful implementations that you can leverage easily.
No .NET experience is needed for this session. Basic understanding of programming concepts such as if/then logic and loops is suggested.
Speaker(s):
- Robert Biddle
Track and Room: Misc - N/A
Title: Size does matter: 10 ways to reduce the database size and improve performance
Abstract: Large multi-terabyte databases are fun to work with; however, they are expensive to host and hard to support.
In this session, Dmitri will show you the set of techniques that help to reduce the size of the databases, lower hardware requirements and improve performance of the systems.
Speaker(s):
- Dmitri Korotkevitch
Track and Room: DBA 1 - N/A
Title: Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience
Abstract: As SSRS report developers, we take for granted the security that is built in to Reporting Services. This Session explores the possibilities available to us by querying AD.
Speaker(s):
- Wes Springob
Track and Room: BI 2 - N/A
Title: Sliding Window Table Partition Intro
Abstract: A walk-through of creating a sliding window table partition on an AdventureWorks table.
Speaker(s):
- Jeff Reinhard
Track and Room: DBA 2 - N/A
Title: Analysis Services: Multidimensional vs Tabular
Abstract: The difference between Analysis Services Multidimensional versus Analysis Service Tabular can be difficult to understand for both new and seasoned Microsoft business intelligence developers. However, this understanding helps you to pick the model type that will provide the best possible solution for your end users. This session will describe each model type, list the pros and cons of each model type, and show developer and end user functionality for both model types. After this session, you will be able to successfully pick the right Analysis Services model type for you.
Speaker(s):
- Jessica Moss
Track and Room: Misc - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Robert Biddle
Twitter: - @robert_biddle
LinkedIn: Robert Biddle
Contact: http://robert-biddle.com
Robert Biddle is a Data Architect for Hilton Grand Vacations in Orlando, Florida. He has over a decade of experience working with SQL Server in a variety of roles. He has a Bachelor’s degree in Computer Science from the University of Delaware and also has MCITP certifications for Database Administration and Database Development. In recent years, Robert has specialized himself working with data integration, ETL, and data warehousing. He is a frequent speaker at SQLSaturday and Code Camp events.
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.
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.
Kendal Van Dyke
Twitter: - SQLDBA
LinkedIn: Kendal Van Dyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
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.
miguel Cebollero
Twitter: - SQLMiguel
LinkedIn: miguel Cebollero
Miguel is a father, husband and database professional with more than 18 years of experience. He has held positions in management, database administration, development, architect and BI development. Miguel is a regular speaker at local user groups, regional SQLSaturday and the national PASS Summit conference on various database topics. He has been an avid volunteer, chapter leader, contributor for PASS and published author of Pro TSQL Programmers Guide; ApressMedia, Published 2/27/2015
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.
Jeff Reinhard
Twitter: - @SQLMajor
LinkedIn: Jeff Reinhard
I have 25 years of database development experience, mostly with SQL Server, with companies such as Ernst amp; Young, Internet Security Systems/IBM, AirWatch, WebMD, CheckFree and others. My recent focus has been on AlwaysOn availability groups and database DevOps.
Phillip Labry
Twitter: - @philliplabry
Contact: http://phillip.labry.com
Phillip Labry is a Senior BI Consultant and Trainer with over 20 years experience in SQL Server and over 30 in IT. He has been lucky enough to work on data projects spanning telecom, banking, retail, law enforcement, health care, insurance, financial services and energy sectors. As a national consultant he provides training and builds solutions utilizing the full MS BI stack. He is an active member of the Madison, WI PASS chapter and speaks at events in the USA and Canada.
Denis McDowell
Twitter: - mcdowell_is
LinkedIn: Denis McDowell
Denis McDowell is a Microsoft Data Professional with over 20 years of experience with SQL Server, scripting, virtualization, IT operations, and Cloud implementations across multiple industries. He currently works as the Solutions Engineering Manager for SentryOne and owns a consulting practice in the Charlotte, NC area. Denis has been a regular presenter at local, regional, and national conferences and events, including PASS Summit, Microsoft Hosting Summit, and numerous SQLSaturday and SQL User Groups around the U.S. In his free time, Denis enjoys traveling with his family, playing and recording in his home music studio, and catering to the needs of his three dogs.
Wes Springob
Twitter: - /SQLWes
LinkedIn: Wes Springob
Contact: http://SQLWes.com
Wes Springob is a Premier Field Engineer (PFE) at Microsoft and speaks regularly on Business Intelligence, Power BI, database and report development.
Joe Healy
Contact: http://blogs.msdn.com/devfish
— Joe Healy is a Technology Evangelist for Microsoft covering North and Central Florida. He can be reached at jhealy@microsoft.com or http://blogs.msdn.com/devfish ….
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.
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.
Christopher Price
Contact: https://bluewatersql.wordpress.com/
Chris is a Senior Consultant with Microsoft based out of Tampa, FL. He has a B.S. in MIS and a MBA, both from the University of South Florida. He started his career as a developer and worked as a software architect before being bitten by the BI bug. He has an extensive SSIS background includes performance tuning and development of custom tasks and transformations. His interests include: ETL and Data Integration, Data Quality and MDM, SSAS, SharePoint and Big Data.
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.
Jeffrey Garbus
LinkedIn: Jeffrey Garbus
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses.
In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.
His latest book is “Transact SQL the Definitive Guide.”
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.
Kendal Van Dyke
Twitter: - SQLDBA
LinkedIn: Kendal Van Dyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
Jen Underwood
Twitter: - @idigdata
LinkedIn: Jen Underwood
Contact: http://www.jenunderwood.com
Jen Underwood is a Senior Director at DataRobot. Over the past 20 years, Jen has held worldwide product management roles at Microsoft and served as a technical lead for system implementation firms. She has a unique blend of product management and “hands-on” experience in data warehousing, reporting, visualization, and advanced analytics. In addition to keeping a constant pulse on industry trends, she enjoys digging into oceans of data to solve complex problems with machine learning.
Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.
Christopher Price
Contact: https://bluewatersql.wordpress.com/
Chris is a Senior Consultant with Microsoft based out of Tampa, FL. He has a B.S. in MIS and a MBA, both from the University of South Florida. He started his career as a developer and worked as a software architect before being bitten by the BI bug. He has an extensive SSIS background includes performance tuning and development of custom tasks and transformations. His interests include: ETL and Data Integration, Data Quality and MDM, SSAS, SharePoint and Big Data.
Gene Webb
Twitter: - None
LinkedIn: Gene Webb
Contact: http://None
Gene Webb is a Regional Sales Executive with The Profisee Group based in Alpharetta Georgia. Profisee is the successor to Stratature the company that built Master Data Services (MDS) and sold the product to Microsoft in 2007. Profisee focuses around Master Data Management (MDM) and as a Gold ISV provides solution sets built on MDS and the Microsoft Stack. Gene spent 7 years working at Microsoft as a SQL Server and Developer Tools solution specialist and an ISV Developer Evangelist.
Peter Evans
Contact: http://www.peterevansbi.com
Peter Evans is the Senior Integrated Solutions Development Consultant for the Information Management Group at Dell. Specializing in Data Virtualization, Business Intelligence and Advanced Analytics and is a recognized expert in the design, implementation and delivery of bespoke Business Intelligence and Analytics systems utilizing various technologies to a large number of major international companies in over 16 years in the field
Konstantin Melamud
Twitter: - @kmelamud
Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQLSaturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.
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.
Jessica Moss
Twitter: - @jessicammoss
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
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.
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.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
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.
Jeffrey Garbus
LinkedIn: Jeffrey Garbus
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses.
In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.
His latest book is “Transact SQL the Definitive Guide.”
Arvin Meyer
Contact: http://www.datastrat.com
A Microsoft Certified Professional and a 15 time awarded Microsoft MVP, Arvin writes freelance technology articles, is an author of a book on Access, leads the Access, Office, and Security, Special Interest Groups, and is the President Emeritus of the Central Florida Computer Society. Arvin works as a consultant, and is Chief Database Architect of a software technology firm in Orlando, FL.
Jorge Novo
Twitter: - @ETLDEVDBA
LinkedIn: Jorge Novo
Contact: http://etldevelopernotes.blogspot.com/
Jorge Novo is a database developer with more than 10 years of experience in the design, implementation, and maintenance of OLAP, ROLAD database system for the enterprise. Jorge specialize himself on ETL processes, SQL tunning, and much more. Jorge is always eager to learn and shared his ideas and challenges with the SQL Community.
Dan King
Contact: http://www.rdx.com/Blog/dba_tips/2014/04/the-merge-join-transformation-and-an-ssis-sorting-tip/
My name is Dan King. Believe it or not I am a huge computer geek. I have worked in the System Admin role and for the past 9 years I have worked with RDX holding many positions. My current role is Sr. Manager of Data Analytics. I am a father of one. I love sports and I am a huge outdoors man. I have a few blogs published by my company that can be found on there website.
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.
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
Julie Smith
Twitter: - @juliechix
LinkedIn: Julie Smith
Contact: http://datachix.com
Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer–but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.
Allen White
Twitter: - SQLRunr
LinkedIn: Allen White
Contact: http://dataperfpro.com/blog/
Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.
Eric Wisdahl
Twitter: - @EricWisdahl
LinkedIn: Eric Wisdahl
Eric Wisdahl is a computer engineer working in the database field. He has held multiple roles and positions in e-commerce, marketing and insurance industries. Currently, he is working as a database administrator in a development role for an e-commerce company.
Eric Wisdahl does not like writing about himself in the third person. It is kind of creepy.
Damu Venkatesan
Twitter: - @vdamu
LinkedIn: Damu Venkatesan
Damu Venkatesan is a Business Intelligence Consultant with over 25 years of IT experience including architecting and implementing BI/DW solutions using Microsoft SQL Server, PDW, SSIS, SSAS, SSRS, and Power BI. He has been speaking at many SQLSaturdays and user groups on data analytics and is actively involved in the Atlanta SQL community for several years. He has successfully delivered several BI/DW solutions and data migrations to various clients. He is also currently serving as President of DAMA Georgia chapter in Atlanta. He is the co-organizer of BI SQLSaturday in Atlanta.
Jorge Novo
Twitter: - @ETLDEVDBA
LinkedIn: Jorge Novo
Contact: http://etldevelopernotes.blogspot.com/
Jorge Novo is a database developer with more than 10 years of experience in the design, implementation, and maintenance of OLAP, ROLAD database system for the enterprise. Jorge specialize himself on ETL processes, SQL tunning, and much more. Jorge is always eager to learn and shared his ideas and challenges with the SQL Community.
Sponsors
The following is a list of sponsors that helped fund the event: