SQLSaturday #522 - Jacksonville 2016

Event Date: 05/07/2016 00:00:00

Event Location:

The University of North Florida Campus
1 UNF Drive
Jacksonville, Florida

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

Sessions
Speakers
Sponsors

If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).

Sessions

This is a list of sessions from the event, based on the schedule in the XML files.

Title: SS2014/2016 In-Memory Tables: Formula 1 Performance Unleashed!

Abstract: Query performance is what it is all about. SQL Server 2014 gave us the new in-memory functionality that takes a completely different approach to data access and manipulation. Google “In-Memory Tables” and you’ll get a myriad of results from white papers, blogs, webinars, etc. This session will consolidate the relevant information from all these sources so the production DBA/Developer will be able to understand, create, use, maintain, and trouble-shoot in-memory table functionality. This session will also examine several demo scripts showing performance gains using the in-memory tables over equivalent disk based tables.
This session is all about when and how to apply in-memory tables in a production environment. After this session you will

Understand what in-memory tables are and how to create and maintain them including their limitations
Be able to identify performance gains over equivalent disk back tables
Comprehend the new data monitoring needed for in-memory table

Speaker(s):

Mike Byrd

Track and Room: Application Database Development - 1002

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, will explore the improvements to SQL Server self-service reporting and talk about creating blended 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.

Speaker(s):

Sayed Saeed

Track and Room: BI Information Delivery - 1406

Title: A SQL Developer’s Guide to MDX Basics

Abstract: You already know how to write SQL queries against a data warehouse but your new job responsibilities require you to write MDX queries against Analysis Services (SSAS). MDX is the query language of SSAS in multidimensional mode. While SQL and MDX share some common keywords, they have very different syntax and concepts. In fact, the common keywords can be confusing if you are used to thinking in SQL.

In this session you will explore how data is organized in SSAS in a data structure called a cube. Next, we will write MDX queries while comparing them with SQL queries that return similar results. You will see how certain queries are much easier to write in MDX, especially when it comes to querying data that contains hierarchies such as a date rollup. Finally, you will learn how to capture MDX queries generated by Excel and SQL Server Management Studio, to use as practical examples of how to write MDX queries.

Speaker(s):

Shabnam Watson

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

Title: Inside the Query Optimizer

Abstract: When it comes to SQL Server one of the biggest request you hear is “How can I make my Query Run FASTER!?”. The answer understanding the first step in that process Is understanding the Query Optimizer. Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.

Speaker(s):

Bradley Ball

Track and Room: Enterprise Database Administration Deployment - 1202

Title: Azure Machine Learning with Stock Data

Abstract: This session is focused on leveraging Microsoft Azure Machine Learning with stock data to build a predictive model. This session will cover gathering and loading the data, building a predictive model, evaluating the model, publishing and using the web service for predicting stock movement.

Speaker(s):

Alexey Bogomolov

Track and Room: Advanced Analysis Techniques - 1402

Title: Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Abstract: As the threat of Cybercrime and data breaches increases, it is important to know and understand the variety of options available to protect Personally Identifying Information and other business sensitive data. You need to be prepared to defend yourself from the threat of data theft by learning about and combining methods of encrypting data at rest and in transit. In this presentation, you will learn about encrypting data at rest, data in transit, securing the channels through which data is transported and other topics related to cryptography in SQL Server including details about validating certificates and preventing man in the middle attacks against your server. Other topics include an overview of replicating encrypted data and designing systems so that the DBA can’t decrypt the data. By the end of the session, you will understand how and when to use and combine every available encryption feature to design a defense in depth strategy for protecting data from escaping your network.

Speaker(s):

Michael Keleher

Track and Room: Enterprise Database Administration Deployment - 1404

Title: From Non-Technical to Fully Employed Technical: The Road Less Traveled.

Abstract: My technical path started at a SQLSaturday event in Jacksonville in 2010. Today I am Microsoft Certified and working full time as a Business Intelligence Report Developer. Sometimes it’s hard to envision the finished product of your labors when you’re in the middle of the construction mess. And it’s hard not to become frustrated when you can’t instantly learn all the great technical stuff out there. Well, you’re heard that Rome wasn’t built in a day, and neither will your technical studies. Building a solid technical foundation takes time and a ‘no quit’ attitude. If there was another way to do it, I would have found it by now!
Three foundation bricks for your technical base:

How to learn/improve T-SQL on your own? The Best and the Cheapest Way to Learn T-SQL
The Importance of the Technical Community in the learning process
Finding a Mentor and being a good mentee!

Speaker(s):

Susan Schneider

Track and Room: Professional Development - 1002

Title: Automated Cancer Detection with Deep Learning

Abstract: Deep Learning as a general approach to image processing tasks like detection, recognition and localization have enjoyed tremendous success in recent years. However, deep learning has not yet been applied to certain ripe areas of medical imaging - specifically detecting cancer in gigabit sized scanned slides (commonly referred to as whole slide images or WSIs). In this session Matt will describe the development of an end-to-end image processing system that NLP Logix developed to automate the process of detecting WSI that contain cancer cells. The session will walk through the process of designing the system, training a deep model using TensorFlow (expect a discussion on GPUs) and call out all challenges encountered along the way.

The system developed by NLP Logix received an IEEE award for image process as part of the 2016 Grand Challenges in Biomedical Image Analysis.

Speaker(s):

Matt Berseth

Track and Room: Advanced Analysis Techniques - 1402

Title: BI DBA Performance Tuning

Abstract: Data Warehouses and OLTP systems are different! But there are some core concepts that we need to understand for managing and maintaining both. Do you want to know how you can load data faster, just by setting up your database correctly? Are your queries running slow? Want to understand how you can reduce locking and blocking in reporting queries? Do you have a system with views, that reference views, which reference more views? Let’s discuss some core concepts and techniques that will get you out of the slow lane and on your way to a faster Data Warehouse!

Speaker(s):

Bradley Ball

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

Title: SSIS Destination Fast

Abstract: Ever face the problem of having slow SSIS packages due to either large lookups on dimensions or complicated merge methods used in SSIS? Free yourself from this tasks with no third-party tools or stage tables required. In this session Mike will demonstrate a totally different way of Increasing speed of destination merges and also eliminating large dimension lookups in SSIS via SQL triggers. He will also demonstrate how to use this same code to create a “Fast” even customizable slowly changing dimension insert.

Speaker(s):

Michael Mollenhour

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

Title: The Future of the Data Professional

Abstract: The world of data is changing rapidly. Come learn what this means for your role as a data professional and what you can do to make sure you stay at the front of your field. What does the future look like for DBA’s, BI Developers and Architects? Come get the lay of the land and guidance on keeping your career and learning on the right path. I will go through the updated landscape and decisions facing data professionals today and help chart a course to make sure your plans are right for you and your organization.

Speaker(s):

Adam Jorgensen

Track and Room: Professional Development - 1406

Title: What’s new in Reporting Services 2016

Abstract: With the upcoming release of SQL Server 2016, Microsoft has blown the dust off the tried and true SSRS and injected some much needed life. SSRS 2016 introduces a shiny new portal with a new Dashboard/Mobile report types. In this session, we’ll take a look at what has changed in SSRS 2016 and how to get up and running using the new Dashboard/Mobile reports. Through demos we’ll walk through everything you need to create your first Mobile ready SSRS 2016 Dashboard!

Speaker(s):

Brad Gall

Track and Room: BI Information Delivery - 1102

Title: Designing a Data Warehouse from the Ground Up

Abstract: What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session we’ll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We’ll also discuss how the design of our dimensional model affects a SQL Server Analysis Services solution and how the choices we make during the data warehouse design phase can make or break our SSAS cubes.

Speaker(s):

Dustin Ryan

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

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: Application Database Development - 1402

Title: SQL Server Storage Engine under the hood

Abstract: How SQL Server performs I/O

How is SQL Server really accessing the data and log files on the disk? What’s done asynchronous and what’s synchronous and what impact does that have on our queries and DML statements. Which impact have features like database mirroring and replication, what’s different when SQL Server is starting up. #160; Which I/O Subsystems (including SSD) are best for which type of data and what’s the impact if you choose a different one. Which files can be placed on the same volume and which should not.

Speaker(s):

Thomas Grohser

Track and Room: Enterprise Database Administration Deployment - 1400

Title: Introduction to the R programming language

Abstract: This will be an introduction to the R programming language. The Session will cover the history, basic structure and syntax of the Language along with a demonstration of some basic scripts using the application (IDE) RStudio. A use case will be presented from a Voter Identification project currently underway.

Speaker(s):

Keith Seedorf

Track and Room: Analytics and Visualization - 1404

Title: Breaking into the Azure-PowerBI World

Abstract: How to get started in Azure-PowerBI from a DBA background. You know SQL. You probably have SQL installed on your own box; you’re familiar and comfortable with SSMS. There’s all this talk of Azure. There’s all this talk of PowerBI. You’re not sure how to start. You’re not sure where you even want to go. You’re not sure why you would use Azure… You’re not quite sure what tools you need, let alone how to tie them together. That’s why you want to come to this session. I’ll start you off with what you know…SSMS, and add tools and connections until you have filled Azure with data from SSMS and then tied Azure to PowerBI. Along the way we’ll highlight key parts of the techniques that tie all these pieces together. At the end you’ll see a PowerBI presentation sourced from Azure that you saw created from your favorite, comfortable tool…SSMS. This set of knowledge can help you in your career planning, and if nothing else, should help you in creating a technical strategy!

Speaker(s):

Steve Schneider

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

Title: Advanced Power BI: Solving the Hard Problems

Abstract: By now you have probably seen many Power BI demos and likely love what you see in the product. However, you may have noticed in most Power BI demos that they tend to show scenarios where everything just works right on the first try. So what do you do when your data is not perfect or your business problem is more complex? In this session, you will see what happens when you go beyond the basics and try to solve those difficult problems that you inevitably will run into when you’re back at work. This session will give you many tips on how to solve real world problems with Power BI.

Speaker(s):

Devin Knight

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

Title: Building your First Cube with SSAS

Abstract: So now that your data warehouse is complete now what? In this session Chris will show you how to create your first fully functional Cube in 1 hr. In this session we will cover all of the basics including some best practices to get you up to speed when working with analysis services. This session was designed for someone with little to no experience with SSAS.

Speaker(s):

Chris Albrektson

Track and Room: Analytics and Visualization - 1102

Title: Enterprise Machine Learning with R and SQL Server

Abstract: R is a pure data science and statistics scripting language. It is considered the best fit for Machine Learning. With more than 5000 packages all machine learning algorithms are covered and improving. R packages help you prepare the data, e.g.: packages for cross validation with N folds, build machine learning models, validation, create plots and to generate predictions. SQL Server 2016 and R Server are a perfect match for building enterprise grade solutions that support deployments for real time predictions and continuous model updates. Join this session for an overview based on sample cases about how to build enterprise grade machine learning solutions with SQL Server and R.

Speaker(s):

Paco Gonzalez

Track and Room: BI Information Delivery - 1404

Title: Index Sql Server databases for high performance

Abstract:

Missing indexes for queries and sprocs
Rank missing indexes based on logical reads and/or execution time
Record missing indexes and query plans for later analysis
Verify indexing results Bonus: Update only necessary statistics using Ola Hallengren Index Optimize sproc

Speaker(s):

Valentin Iamandi

Track and Room: Enterprise Database Administration Deployment - 1402

Title: Why do I need Analysis Services?

Abstract: Do you write a lot of SSRS reports with SQL queries or stored procedures? Have you heard about analysis services but don’t know if it’s a good fit for you? Are you trying to decide whether you should go with Tabular or OLAP? Are you thinking about using Power BI? In this session Phillip will go over use cases for Analysis Services and highlight the differences and strengths of each flavor of SSAS. If you have a data warehouse and aren’t using SSAS come learn how SSAS will make your users love you.

Speaker(s):

Phillip Labry

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

Title: Database Projects: An Introduction

Abstract: A look at the advantages of using Database Projects within Visual Studio. We’ll look at partial database projects, tools for sql developers, TFS integration, DACPACs, and what happens during the build and publish steps. This will be demo heavy with a slide deck to remind you of the key points of the session.

Speaker(s):

Jonathon Moorman

Track and Room: Application Database Development - 1402

Title: Kids Camp

Abstract: For SQLSaturday attendees’ children only (children 9-15) Registration for this event must be done from our meetup site. You cannot register on the day of the event for Kids Camp.

http://www.meetup.com/Jacksonville-SQL-Server-User-Group/events/228535929/

The students will get to create there own exciting games and robots while learning fundamental concepts or programming. Lunch will be included. The $10 fee holds your place but please email us if you wish to cancel. Parents will need to remain on campus at SQLSaturday while their kids are in the program.

An Adult must remain on campus at SQLSaturday during the day.

Speaker(s):

Devin Knight

Track and Room: Other - 1026

Title: More than Just a basic Database Backup and Recovery

Abstract: During our time together we are going to take a quick look into backup and recovery techniques for Full, Differential, and log backups. We will then take a look at how SQL Server keeps track of what will be included within out differential backups. While we’re at it lets look at our transactions logs prior to and post log backups. Next up we will look into advanced recovery scenarios such as piecemeal, point in time, file group, and page recoveries. If you manage databases or like doing recoveries let’s have some fun together during this sessions.

Speaker(s):

Daniel Taylor

Track and Room: Enterprise Database Administration Deployment - 1202

Title: Data Migration Using BIML

Abstract: Many companies scale out their databases horizontally, partitioning data by customer (or some other identifier) into separate databases or instances. Sometimes, it becomes important to move that data from one database to another. SQL Server Integration Services is a fantastic tool for ETL, but creating and maintaining dozens or hundreds of data flows by hand is exhaustingly tedious. Instead of doing it the hard way, use the BI Markup Language (BIML) to automate package development. This talk will show how we can use metadata tables and BIML to auto-create SSIS packages to migrate data from one database to another, handling foreign key constraints along the way.

Speaker(s):

Kevin Feasel

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

Title: Mastering the Technology Interview

Abstract: Mike shows you how to be prepared for technology job interviews. Learn the do’s and don’ts of interviewing for technology jobs. Learn what your resume says about you and your ability to grow. Learn how passion can overcome a lack of skills. If you are the hiring manager and you are struggling to find the right people, come learn techniques to find the right fit for your company.

Speaker(s):

Mike Davis

Track and Room: Professional Development - 1002

Title: SSAS Design and Performance Best Practices

Abstract: A journey through best practices in relation to scalable SQL Server Analysis Services cube design. From dimension design to SSAS engine internals we will explore SSAS multidimensional design patterns that will take you through steps to assist in getting your SSAS cubes better optimized to better match the needs of your organization. After this session you will be able to take these performance design patterns and apply them to new and existing cubes to tune your SSAS cube environment.

Speaker(s):

Alan Faulkner

Track and Room: BI Information Delivery - 1400

Title: Indexing your Data Warehouse

Abstract: One of the primary skill sets most database professionals are initially required to “master” is the art of proper indexing in our databases. We learn early on that an effective indexing configuration will go further in making our databases perform efficiently than probably any other single tuning technique. What’s not so commonly discussed though are the varying approaches one may wish to utilize when indexing your SQL Server enterprise data warehouse. This session will hopefully cause you to take a good look at your current indexing to see if indeed it could be operating even more efficiently.

Speaker(s):

Troy Gallant

Track and Room: Enterprise Database Administration Deployment - 1002

Title: Accelerating Batch Processing with Apache Spark

Abstract: The Apache Spark framework can accelerate processing 100x or more on Hadoop from diverse data sources such as Cassandra, Hive, or HBase. Using Azure’s HDInsight and Spark we’re going to look at the architecture and go step by step through examples with R and Python against public data sources.

Speaker(s):

Rowland Gosling

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

Title: Availability Groups: Monitoring and Alerting

Abstract: So you have your availability groups configured and everything reports green. How do you measure SLA compliance? Do you know when replication is delayed? Were you notified when it failed over last night? This session will answer all these questions and more, and will show you what you should be looking at to ensure no surprises… We will look at the DMVs, extended event sessions, perfmon counters, SQL agent jobs and alerts to show what to monitor in your AG and how to setup alerting so you know when to take action.

Speaker(s):

Shawn Meyers

Track and Room: Enterprise Database Administration Deployment - 1202

Title: Parent, Child development Using SSIS Framework

Abstract: Learn how to extend and reuse SSIS development using package controllers and drivers. Extend parallel process and view the different options for SSIS package configurations and become the GURU on ETL development for your organization

Speaker(s):

Jorge Novo

Track and Room: BI Information Delivery - 1400

Title: SSIS Performance Tuning

Abstract: SSIS is a powerful ETL tool, but by nature ETL developers are always looking for better performance. In this hour long presentation we will cover many basic options and features that you can use to performance tune any SSIS package.

Speaker(s):

Shawn Harrison

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

Title: SQL 2012 2014 Extended Events

Abstract: In this session, come and learn how to perform monitoring and troubleshooting of your SQL Server using the new and improved Extended Events that are found in SQL Server 2012 and 2014. You will also learn about the improved XEvents interfaces and how to use XEvents to performance tune your server by tracking issues. This session will dive into the internals of XEvents and investigate the details of some of the events themselves.

Speaker(s):

Gareth Swanepoel

Track and Room: Enterprise Database Administration Deployment - 1202

Title: Changing Inline Dynamic SQL Statements To Stored Procedures

Abstract: If you are a Developer or a DBA and have dynamic SQL statements in your application, you need to attend this session! In this session we will walk through a simple method to change inline dynamic SQL statements to stored procedures. This method will allow Developers and DBA’s to have reusable execution plans and the ability to more specifically tune stored procedures.

Speaker(s):

Jeff Taylor

Track and Room: Application Database Development - 1404

Title: Database Security Permissions ( you don’t need to grant SA )

Abstract: Lets talk about Database Security Permissions Roles and I’ll show you how to correctly grant the access needed to allow other to their job without risking the entire database. I will also touch on auditing so you can prove who did what! Furthermore, I’ll show you some tips and tricks to getting SQL itself to accomplish task that you may not to grant access to a human.

Speaker(s):

Scott Gleason

Track and Room: Enterprise Database Administration Deployment - 1202

Title: What’s New in SQL Server 2016 ?

Abstract: SQL Server 2016 is the newest version of SQL Server available from Microsoft. This session is designed to introduce SQL Server DBA’s and architects to some of the exciting features available in that version. Topics covered in this session include Query Store, Polybase, Stretch Database, JSON Support, Row Level Security, Always Encrypted, Enhancements to In-Memory OLTP tables and enhancements to AlwaysOn. If you are a SQL Server DBA or developer, an architect, or an IT professional who is excited about the new SQL Server 2016 features and are looking forward to learn more about them, this session is for you.

Speaker(s):

Gareth Swanepoel

Track and Room: Enterprise Database Administration Deployment - 1400

Title: Advanced T-SQL for BI Developers

Abstract: So you know the basics and fundamentals of T-SQL, what’s next? Come join Mitchell in this demo heavy session as he walks through more advanced T-SQL concepts and how they can make you more efficient in your T-SQL development. Some of the items covered in this session include CTEs, Window Functions, Merge Statement, and more!

Speaker(s):

Mitchell Pearson

Track and Room: BI Information Delivery - 1400

Title: What’s New In SQL Server 2012/2014/2016 For The Developer

Abstract: This session covers the new functionality directly related to SQL Server developers in the last several releases of SQL server.

Speaker(s):

Jeff Taylor

Track and Room: Application Database Development - 1202

Title: Step by Step - How to Build World Class Data Culture

Abstract: Most organizations are struggling to figure out how to use data to drive their organization. Their biggest challenge is building it into the culture of the firm. Over 96% of the Fortune 100 are developing these types of cultures and you’ll learn how to get started in this session. Using data to communicate is the key. This takes confidence in the data, the people and the mission. Let’s talk about how we bring all these together to add a rocket booster to your businesses. Get a step by step plan you can start using Monday!

Speaker(s):

Adam Jorgensen

Track and Room: Strategy and Architecture - 1406

Title: Intelligent Indexing

Abstract: Using indexing to improve performance

Speaker(s):

Arvin Meyer

Track and Room: Application Database Development - 1002

Title: Introduction to Azure Data Factory Service

Abstract: Data Factory is a cloud-based data integration service that orchestrates and automates the movement and transformation of data. Just like a manufacturing factory that runs equipment to take raw materials and transform them into finished goods, Data Factory orchestrates existing services that collect raw data and transform it into ready-to-use information.

In this session, we will review key concepts associated with Azure Data Factory to understand how key entities work together to define input and output data, processing events, and the schedule and resources required to execute the desired data flow.

Speaker(s):

Alan Faulkner

Track and Room: Cloud Application Development Deployment - 1406

Speakers

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

Michael Keleher

Twitter: - @makeleher

LinkedIn: Michael Keleher

Michael Keleher is a Microsoft Certified Professional and is currently the Database Administrator at Bisk Education, Inc in Tampa, Florida. He has over twenty years of experience working in all areas of the Software Development Life Cycle plus another three as a Database Administrator. He enjoys getting involved in security and performance tuning projects.

Thomas Grohser

LinkedIn: Thomas Grohser

Thomas Grohser has spent most of the past 26+ years exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical, and financial services industries. His primary focus is to architect, plan, build, and operate reliable, highly available, secure, and scalable infrastructures for SQL Server. Over the years he has managed thousands of SQL Server instances, processing trillions of rows, taking up petabytes of storage. Thomas has been a Microsoft Data Platform MVP for 9 years and has spoken regularly at conferences, SQLSaturdays, and user groups for 12 years.

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.

Devin Knight

Twitter: - @knight_devin

LinkedIn: Devin Knight

Contact: http://devinknightsql.com

Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. He is an author of seven SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQLSaturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG).

Troy Gallant

Contact: http://www.troygallant.com

Troy has been a SQL Server professional for over 18 years, filling various roles as analyst, developer, and for the last decade, DBA. As a regular speaker at SQLSaturdays up and down the east coast, he’s taught on a multitude of topics from disaster recovery to performance tuning to professional development. Currently residing in Jacksonville once again, he just got back from two years as Sr. DBA for the EDW of a major international insurance company in New York City.

Keith Seedorf

Twitter: - @KeithSeedorf

LinkedIn: Keith Seedorf

Keith is a well rounded IT guy from the Atlanta, Ga. area. He has carried out most IT roles including Senior Systems Analyst and Senior Network Engineer. Keith recently (past few years) went back to school and completed a degree in psychology which helped with one of his passions - behavioral analysis. He, also, enjoys statistics and predictive analysis along with machine learning. For hobbies, Keith has been collecting comics since he was 10 and enjoys movies (he is listed on IMDB.com as an actor).

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.

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.

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 tuning, and much more. Jorge is always eager to learn and shared his ideas and challenges with the SQL Community.

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.

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.

Mitchell Pearson

Twitter: - @MitchellSQL

Contact: http://www.mitchellpearson.com

Mitchell is an experienced Business Intelligence Consultant and Trainer at Pragmatic Works and is currently the content training manager leading content development and delivery of training courses. Mitchell is experienced developing BI solutions using the full Microsoft BI Stack (SSRS, SSIS, and SSAS) as well as Microsoft Power BI. He is also very active in the community speaking at SQLSaturday events, local user groups, and online virtual events. Mitchell also blogs at mitchellpearson.com.

Devin Knight

Twitter: - @knight_devin

LinkedIn: Devin Knight

Contact: http://devinknightsql.com

Susan Schneider

LinkedIn: Susan Schneider

Contact: http://sqlinsight.net/susanschneiderblog/

Susan Schneider is a certified Microsoft Professional with a concentration in Database Fundamentals. She works as a BI Reports Developer in Jacksonville, Florida. She is firmly entrenched in the Microsoft camp and loves learning the latest technologies. Susan is a member of Jacksonville SQL Servers Group (JSSUG) and Professional Association of SQL Servers (PASS). When she’s not learning, working, or blogging; she enjoys sailing and fishing with her husband, Steve.

Rowland Gosling

Twitter: - @BigSQL

LinkedIn: Rowland Gosling

I’ve worked on a variety of data platforms including SQL Server, Oracle, DB 2 and Hadoop. SQL Server has been my choice OLTP/Data Warehouse platform for many business needs. These days I’m working almost exclusively in the cloud using Microsoft’s Azure and a variety of new products like Azure Data Warehouse, Azure Cosmos DB and Data Factory. As a Microsoft employee, my focus is working on our data platform for our financial services customers.

Adam Jorgensen

Twitter: - wadamj

LinkedIn: Adam Jorgensen

Contact: http://www.pragmaticworks.com

As President of Pragmatic Works Consulting Adam drives market strategy, sales, partnerships, implementation and thought leadership. He has over 15 years of experience helping companies use their data to fuel their growth. Adam has been wowing audiences around the world for over a decade. He has delivered hundreds of sessions, published over a dozen books and hundreds of online videos and webinars on data and cloud topics. His passion is growing companies and mentoring leaders and companies to help them achieve their dreams.

Chris Albrektson

Twitter: - @ChrisAlbrektson

Contact: https://chrisalbrektson.wordpress.com/

Chris Albrektson is an experienced Business Intelligence consultant and trainer for Pragmatic Works in Jacksonville, Florida. Chris is an experienced speaker and has presented at many SQLSaturdays and Code Camps across the United States. He’s also an active member of the Jacksonville SQL Server User Group (JSSUG), is a regular blogger on WordPress and has been a technical editor of a few Business Intelligence related books.

Brad Gall

Bradley Gall comes from a long line of excellence at Pragmatic Works. He is the coveted winner of the “We Still Have A Brad Award”, as well as a Senior Consultant for Pragmatic Works specializing in the Business Intelligence stack. His skills range from SharePoint, SSIS, SSAS, SSRS, Data Zen, and PowerBI. During his 10 years of delivering successful data solutions he has seen Brad’s come and seen them go, and he is lucky to count himself among them. Bradley Gall immediately regretted letting Bradley Ball write his bio for him, to find out his thoughts on this and other things follow him on twitter at @bradgallsql

Steve Schneider

LinkedIn: Steve Schneider

Contact: http://sqlinsight.net/blog/

Speaker Bio: Steve Schneider is a Business Intelligence developer for the City of Jacksonville (Florida), and has been embedded in SQL for over 20 years. He is a Microsoft Certified Systems Engineer and a Microsoft Certified Database Administrator. Along with his passion for SQL, he spends his time running half marathons and sailing. His current focus of interest is performance tuning, security, and cube building. He tries to maintain a constant sense of gratitude to God for the wonderful things he has been enabled to do.

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.

Adam Jorgensen

Twitter: - wadamj

LinkedIn: Adam Jorgensen

Contact: http://www.pragmaticworks.com

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.

Shabnam Watson

Twitter: - ShbWatson

LinkedIn: Shabnam Watson

Contact: https://shabnamwatson.wordpress.com/

Shabnam Watson is a Business Intelligence architect with 20 years of experience developing data warehouse and business intelligence solutions. Her work focus within the Microsoft BI Stack has been on Analysis Services and Power BI.

She is an active member of PASS community and has spoken at PASS Summit, SQLSaturdays, PASS Business Analytics and Women in Technology virtual chapters, and many other local user groups and conferences. She is one of the organizers of SQLSaturday Atlanta BI Edition.

She holds a master’s degree in computer science, a bachelor’s degree in Computer Engineering, and a Certified Business Intelligence Professional (CBIP) certification by The Data Warehouse Institute (TDWI).

Jeff Taylor

Twitter: - reviewmydb

LinkedIn: Jeff Taylor

Contact: https://blog.reviewmydb.com

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.

Alan Faulkner

Twitter: - #FalconTekNik

LinkedIn: Alan Faulkner

Contact: http://falconteksolutionscentral.com/

I am an IT professional with over 20+ years of progressive technical experience with managing, consulting, software development, data integration architecture, data warehousing, and business intelligence development projects. The focus of my work is to work closely with stakeholders to develop architecture frameworks that align with organizational strategy, processes, and IT assets. Specializing in Business Intelligence (BI), Data Warehousing, database architecture, design and implementation.

Daniel Taylor

Twitter: - @DBABulldog

LinkedIn: Daniel Taylor

Contact: http://dbabulldog.wordpress.com/

Daniel Taylor started his DBA life at Nielsen Media Research Company working with Sybase ASE 11 thru 12.5, Sybase IQ, eventually moving to SQL server. Post Nielsen Media Research Daniel worked for Publix Supermarket a Forbes recognized industry leader, Forbes top 100 best places to work, and tops in customer service and satisfaction. Following Publix Daniel worked at New York Like which is recognized as a Fortune 500 company, Fortune 500 Global company, and recognized as top 50 company for diversity. Currently Daniel h is a Consultant with Pragmatic Works. You can find him on Twitter as @DBABullDog. Daniel has worked with SQL Server version from 7.0 to 2014. You can find him on Twitter as @DBABullDog.

Matt Berseth

LinkedIn: Matt Berseth

Matt has experience using data to solve problems in a variety of different industries, including Healthcare, Marketing, Human Resources, Bio-medical Imaging, Financial Services. Matt was born and raised in Fargo ND, but has lived and worked in Jacksonville since 2005.

Alan Faulkner

Twitter: - #FalconTekNik

LinkedIn: Alan Faulkner

Contact: http://falconteksolutionscentral.com/

Mike Davis

Twitter: - @mikedavisSQL

LinkedIn: Mike Davis

Contact: http://MikeDavisSQL.com

Mike Davis, MCITP, is a Consulting Team Lead at Pragmatic Works. He is an author with books covering Business Intelligence and SSIS. Mike is an experienced speaker and has presented at many events such as several SQL Server User Groups, Code Camps, SQL Server Launches, SQLSaturday, and SQL Rally. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.

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.

Shawn Harrison

Twitter: - @ShawnBHarrison

Contact: http://www.thesqlgoth.com

Shawn Harrison is a BI Developer at Community Hospice and Palliative Care. He oversees the data warehouse and works within other levels of the MS BI stack. He also speaks at community events such as SQLSaturday, user group meetings.

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

Scott Gleason

LinkedIn: Scott Gleason

Scott is a vice president of the Jacksonville FL SQL Users group with over 10 years experience as a database administrator, working in both Healthcare and Financial industries. He is both Energetic and animated teacher. His passion is learning new technology and sharing his Sql experiences (the good and the lessons learned) with others.

Valentin Iamandi

Contact: http://logicalreads.wordpress.com/

Valentin brings more than 10 years of database experience in tuning, architecture, backup, large data transaction, and more. He has a solid background in database analysis and development and his skills cover SQL Server and Oracle as well as a slew of different operating systems. Valentin fluently speaks English, French, and Romanian. Valentin has a passion for performance and optimization and shares his experience on the topic in his blog http://logicalreads.wordpress.com/

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

Alexey Bogomolov

LinkedIn: Alexey Bogomolov

Contact: http://standupdata.com

Alexey is the author of Microsoft Azure Machine Learning with Stock Data, http://amzn.to/1rnrwsR . With over a decade of IT experience in consulting, DBA, BI development and architecture, he currently leads Data and Analytics team at a market research and web analytics company, MarketOnce.com a subsidiary of Oceanside Ten Management, Inc. Primarily working with Microsoft BI Stack, building business intelligence solutions, from data warehousing to predictive analytics. He is Microsoft Certified IT Professional in Business Intelligence, Database Development and Database Administration. He has a Bachelor of Science Degree in Computer Information Systems from the College of Charleston, and an M.B.A. from the University of North Florida.

Bradley Ball

Twitter: - @SQLBalls

LinkedIn: Bradley Ball

Contact: http://www.sqlballs.com

Michael Mollenhour

Mike has worked with Database performance and troubleshooting for over 20 years. His experience has been gained from both Large Corporations (Citi-Group) to smaller organizations. Mike currently works as an Independent Contractor.

Gareth Swanepoel

Twitter: - @GarethSwan

Contact: http://mygareth.com

Dustin Ryan

Twitter: - @SQLDusty

LinkedIn: Dustin Ryan

Contact: http://sqldusty.com

Dustin Ryan is a senior BI consultant and trainer with Pragmatic Works in Jacksonville, FL. Dustin specializes in delivering quality enterprise-level business intelligence solutions to clients using SSRS, SSIS, SSAS, SharePoint, and Power BI. Dustin has authored and contributed to SQL Server books. You can find Dustin speaking at events such as SQLSaturday, Code Camp, and online webinars.

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.

SQLSaturday #522 - Jacksonville 2016

Sessions

Title: SS2014/2016 In-Memory Tables: Formula 1 Performance Unleashed!

Title: The Business Intelligence Side of SQL Server

Title: A SQL Developer’s Guide to MDX Basics

Title: Inside the Query Optimizer

Title: Azure Machine Learning with Stock Data

Title: Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Title: From Non-Technical to Fully Employed Technical: The Road Less Traveled.

Title: Automated Cancer Detection with Deep Learning

Title: BI DBA Performance Tuning

Title: SSIS Destination Fast

Title: The Future of the Data Professional

Title: What’s new in Reporting Services 2016

Title: Designing a Data Warehouse from the Ground Up

Title: .NET for Data Professionals

Title: SQL Server Storage Engine under the hood

Title: Introduction to the R programming language

Title: Breaking into the Azure-PowerBI World

Title: Advanced Power BI: Solving the Hard Problems

Title: Building your First Cube with SSAS

Title: Enterprise Machine Learning with R and SQL Server

Title: Index Sql Server databases for high performance

Title: Why do I need Analysis Services?

Title: Database Projects: An Introduction

Title: Kids Camp

Title: More than Just a basic Database Backup and Recovery

Title: Data Migration Using BIML

Title: Mastering the Technology Interview

Title: SSAS Design and Performance Best Practices

Title: Indexing your Data Warehouse

Title: Accelerating Batch Processing with Apache Spark

Title: Availability Groups: Monitoring and Alerting

Title: Parent, Child development Using SSIS Framework

Title: SSIS Performance Tuning

Title: SQL 2012 2014 Extended Events

Title: Changing Inline Dynamic SQL Statements To Stored Procedures

Title: Database Security Permissions ( you don’t need to grant SA )

Title: What’s New in SQL Server 2016 ?

Title: Advanced T-SQL for BI Developers

Title: What’s New In SQL Server 2012/2014/2016 For The Developer

Title: Step by Step - How to Build World Class Data Culture

Title: Intelligent Indexing

Title: Introduction to Azure Data Factory Service

Speakers

Sponsors