Event Location:
The University of North Florida Campus
1 UNF Drive
Jacksonville, Florida
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 1. Understand what in-memory tables are and how to create and maintain them including their limitations 2. Be able to identify performance gains over equivalent disk back tables 3. Comprehend the new data monitoring needed for in-memory table
Speaker(s): Mike Byrd,
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,
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,
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,
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,
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,
Abstract:
My technical path started at a SQL Saturday 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: 1. How to learn/improve T-SQL on your own? The Best and the Cheapest Way to Learn T-SQL 2. The Importance of the Technical Community in the learning process 3. Finding a Mentor and being a good mentee!
Speaker(s): Susan Schneider,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
Abstract:
1. Missing indexes for queries and sprocs 2. Rank missing indexes based on logical reads and/or execution time 3. Record missing indexes and query plans for later analysis 4. Verify indexing results Bonus: Update only necessary statistics using Ola Hallengren Index Optimize sproc
Speaker(s): Valentin Iamandi,
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,
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,
Abstract:
**For SQL Saturday 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 SQL Saturday while their kids are in the program. An Adult must remain on campus at SQL Saturday during the day.
Speaker(s): Devin Knight,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
Abstract:
Using indexing to improve performance
Speaker(s): Arvin Meyer,
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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/pub/michael-keleher/3/b09/a56
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.
LinkedIn: https://www.linkedin.com/in/thomasgrohser/
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.
LinkedIn: https://www.linkedin.com/in/aspnerd
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.
LinkedIn: https://www.linkedin.com/in/deknight/
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, SQL Saturdays 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).
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 SQL Saturdays 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.
LinkedIn: https://www.linkedin.com/in/keith-seedorf-21047b8
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).
LinkedIn: http://www.linkedin.com/in/shawnmeyers42
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 SQL Saturday events. Current focus is on improving DBAs lives with better infrastructure.
LinkedIn: https://www.linkedin.com/pub/arvin-meyer-mvp/24/882/376
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.
LinkedIn: https://www.linkedin.com/pub/jorge-novo/1/546/b70
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.
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, SQL Saturdays, the PASS Summit and other technical conferences.
LinkedIn: https://www.linkedin.com/in/pacosql/
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.
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 SQL Saturday events, local user groups, and online virtual events. Mitchell also blogs at mitchellpearson.com.
LinkedIn: https://www.linkedin.com/in/deknight/
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, SQL Saturdays 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).
LinkedIn: https://www.linkedin.com/in/susan-schneider-01946019
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.
LinkedIn: https://www.linkedin.com/in/rgosling
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.
LinkedIn: https://www.linkedin.com/in/wadamjorgensen/
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.
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 SQL Saturdays 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.
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
LinkedIn: http://www.linkedin.com/in/steveschneider1/
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.
LinkedIn: ?https://www.linkedin.com/in/sayed-saeed-68079a18?
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.
LinkedIn: https://www.linkedin.com/in/wadamjorgensen/
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.
LinkedIn: https://www.linkedin.com/in/jonathonmoorman
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.
LinkedIn: https://www.linkedin.com/in/shabnamwatson
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, SQL Saturdays, PASS Business Analytics and Women in Technology virtual chapters, and many other local user groups and conferences. She is one of the organizers of SQL Saturday 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).
LinkedIn: https://www.linkedin.com/in/aspnerd
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.
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.
LinkedIn: http://www.linkedin.com/pub/alan-faulkner/31/b79/932/
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.
LinkedIn: https://dk.linkedin.com/in/danieltaylor3
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.
LinkedIn: https://www.linkedin.com/in/mattberseth
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.
LinkedIn: http://www.linkedin.com/pub/alan-faulkner/31/b79/932/
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.
LinkedIn: http://www.linkedin.com/in/mikedavissql
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, SQL Saturday, and SQL Rally. Mike is an active member at his local user group (JSSUG) in Jacksonville, FL.
LinkedIn: https://www.linkedin.com/pub/kevin-feasel/7/716/504
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.
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 SQL Saturday, user group meetings.
LinkedIn: http://www.linkedin.com/pub/mike-byrd/1/aa0/bbb
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 SQL Saturdays 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 SQL Saturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd
LinkedIn: https://www.linkedin.com/in/scgleason
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.
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/
LinkedIn: https://www.linkedin.com/in/sqlballs
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 SQL Saturdays, SSUG's, SQL Rally, DevConnections, SQLBits, SQL Live 360, and the PASS Summit. Bradley can be found blogging on http://www.SQLBalls.com
LinkedIn: https://www.linkedin.com/in/alexey-bogomolov-mba-30403a6
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.
LinkedIn: https://www.linkedin.com/in/sqlballs
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 SQL Saturdays, SSUG's, SQL Rally, DevConnections, SQLBits, SQL Live 360, and the PASS Summit. Bradley can be found blogging on http://www.SQLBalls.com
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.
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, SQL Saturdays, the PASS Summit and other technical conferences.
LinkedIn: https://www.linkedin.com/in/sqldusty
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.
LinkedIn: http://www.linkedin.com/pub/robert-biddle/8/266/630
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 SQL Saturday and Code Camp events.
The following is a list of sponsors that helped fund the event.