Event Location:
The University of North Florida Campus
1 UNF Drive
Jacksonville, Florida
Abstract:
Today’s SQL Server DBA has a myriad of options when it comes to implementing their backup and maintenance strategies. From internal maintenance plans to all-encompassing third-party solutions, the options are practically endless. One very popular solution revolves around a set of free scripts provided by Swedish data scientist, Ola Hallengren. These well admired scripts are used by corporations large and small worldwide in order to facilitate backups, integrity checks, and index maintenance operations. In this session, not only will we introduce these scripts to those unfamiliar with them, but just as importantly, we’ll take a detailed look into just how these scripts can be extended and customized even further. You’ll be amazed at the flexibility offered by the optional parameters. We’ll also take a gander into the remarkably detailed logging tables in order to inspect the raw data and possibly turn it into a valuable reporting data source.
Speaker(s): Troy Gallant,
Abstract:
This session will cover how to tune a multi-terabyte database where all of the data is stored a single file, primary file group. We will look at file groups, managing indexes and moving large amounts of data.
Speaker(s): Jeff Taylor,
Abstract:
Every data has meaning, but we had limitation to use data through big long running process Extraction, Transformation and Representation, but now Power BI solves your problem to kick start having Data extraction in Power Query, Data Modelling and Transformation in Power Pivot and reach data representation using power view and power map on demand any nearby device on your fingertips, You will learn all latest and greatest features of Power BI.
Speaker(s): Vishal Pawar,
Abstract:
This session will present the fundamentals needed to setup monitoring and alerting for a global Azure PaaS application to insure the application is available to your customers and is performing correctly. I'll review the Azure Portal navigation fundamentals in order to demonstrate how to monitor uptime and application performance for a globally deployed Azure PaaS application currently in use by major companies like ATT, Bell, and Vodaphone. Coverage will included how to monitor and alert on individual components in the Azure Portal, setting up alerts in Application Insights and configuring shared dashboards so that a production support team on a Follow-The-Sun schedule can effectively monitor the application.
Speaker(s): Ronald Dameron,
Abstract:
MongoDB is an open-source, document-oriented NoSQL database that provides high performance, high availability, and easy scaling. It has become the leader in non-relational database for Fortune 500 companies and SQL DBAs are inheriting the responsibility to deploy and maintain this new technology with little outside help and training. This session will focus on educating SQL DBAs in the necessary skills needed to perform day to day tasks to keep your MongoDB healthy, available and fast. This presentation will introduce MongoDB, provide a brief overview of the NOSQL platform, how to get started with MongoDb, patching MongoDB instances, intro to replica set, setting up backups restore and if time allows a brief introduction to perform most of these operations through Ops Manager 3.4.
Speaker(s): Ahmad Drshen,
Abstract:
In its origin, Hadoop was created as a distributed computing system designed to process data in batches, but the many advantages of the platform lead to an immediate desire to run interactive analytical queries against Data Lakes built on Hadoop. So a few years back the Stinger initiative was created as an ongoing effort to bring interactive SQL querying capabilities to Hive, and its latest release has finally delivered! In this session, Luis Figueroa (Solutions Engineer @ Hortonworks) will walk you through the latest advancements that make Hadoop a powerful SQL engine that expands you EDW capabilities with unlimited scale and amazing flexibility. Luis will provide a technical overview of the Hive engine, an update on SQL compatibility with the ANSI standard, real world use cases and a live demo. If you are a data pro this session is for you!
Speaker(s): Luis Figueroa,
Abstract:
The last two releases of SQL Server provided the capability to use SQL Server as the hub in a hub and spoke model for big data and data science. Our hub will use R In-database advanced analytics and Power BI. The technology is impressive, but data needs to be interesting. We are using data provided by RetroSheets.org to create a data set of play by play data and box scores for Major League Baseball games from 1922 to 2015. We set out to discover the answer to questions every baseball fan wants to know! Do you have a better chance to see your team win by going to a Double Header or regular game? Is there 'a the best day of the week' to see your favorite team win? How do winning and losing seasons impact this or home and away games? Come for the baseball, stay for the science!
Speaker(s): Bradley Ball,
Abstract:
Come join Susan Schneider for a new session on how to move from the non-technical realm to the fully employed technical realm, as she explores the latest free learning sites and developer tools for 2017; she will also throw in her top learning tidbits to help you excel in your career. Building on her SQL Saturday session from last year, Susan makes it easy to get started on the technical path by utilizing free learning sites and training. We can’t learn everything all at once, but we can focus on what will provide us the best leverage in today’s technical job market. We’ll focus on the top two 2017 free training sites to expand your technical skills, the top two Business Intelligence presentation tools you need to know, and the top two tidbits to increase your professionalism and efficiency levels. Join Susan as we continue our technical journey and increase our learning pace, two at a time!
Speaker(s): Susan Schneider,
Abstract:
Stagnancy in learning and personal growth often leads to frustration and undesired stress. It is vital to our everyday success that we seek to not only better ourselves through professional and personal development, but it is just as critical to ensure the methods we are using to absorb this content are effectively presented and better suit our learning abilities. I believe the question we need to answer, is not what we're learning, but rather how do we best learn? In this session, we will discuss three popular training methods and how we can customize these options to best fit our needs. This session will help the attendees better prepare themselves for Learning Development and will motivate the attendees to take action.
Speaker(s): Kenneth Wood,
Abstract:
DevOps came out of the Agile movement and the idea that operations needed to be part of the solution for agile development to be successful. The DBA was often the most resilient and robust member of the operations team and most resistant to change. This mentality was essential to the protection of company’s critical production data. This session discusses common database challenges and how they can be minimized or solved with newer DevOps practices without impacting the DBAs “safe zone”. We’ll discuss how to use these vital skills and motivate everyone towards solutions for more success in agile development environments. Development, testing, provisioning, patching, upgrading and managing will become easier with agile tools, virtualization and collaboration. The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as: • Develop, Rinse, Repeat • Test Until Your Five Year Old Can Do It • Human Intervention Creates Human Error- Automate EVERYTHING.
Speaker(s): Kellyn Pot'Vin-Gorman,
Abstract:
Amazon Web Services (AWS) is the world's largest public cloud hosting provider with many companies successfully running SQL server on AWS infrastructure. In this session, we explore the options available to you for running SQL server in AWS, either as an RDS managed service or using dedicated EC2 instances. We document the different storage options, HA strategies, security and maintenance caveats to be aware of. We will also detail various approaches to licensing you can take when running SQL server in AWS.
Speaker(s): Brian Carrig,
Abstract:
Please join me in this adventure of being a Great DBA. In this session you will learn what is needed and how you can get there. Measure / Automate / Promote Measure = How to get the numbers your manager wants to see Automate = Automation as a tool to improve your career Promote = Share your knowledge, create on the side projects
Speaker(s): Valentin Iamandi,
Abstract:
High availability can be different when in a virtual environment. Attendees will learn the pros and cons of running SQL server clusters or AlwaysOn Availability Groups in a virtual environment. Comparing all of the different high availability options between all of available technologies. How features of VMware and Hyper-V are impacted and how to work with the administrators of virtual environment. Walking through all of the storage options to determine which one is the best fit. Review key settings and configurations for the virtual platform, the virtual machine, and SQL server, and show which need to be set to ensure proper performance.
Speaker(s): Shawn Meyers,
Abstract:
Data Warehouse Theory can be a tough nut to crack. A late arriving dimension record tends to occur when you receive a fact record before the dimension record arrives in the data warehouse so you must create a placeholder record. In this session, we will give you a brief overview of Facts and Dimensions, and then do an in-depth discussion on what late arriving dimension records are, why they are important, and how to handle them. We will explain how not properly handling these can negatively affect your Financial Reports. We will also cover how to correct those records in the data warehouse once the proper dimension record arrives on the doorstep of the data warehouse.
Speaker(s): Felix Asencio,
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:
SQL Server reduces compilation and optimization overhead by caching and reusing execution plans for the queries. Plan caching helps to reduce CPU load on the server; however, it may also introduce unexpected issues and lead to suboptimal execution plans and performance problems. In this session, Dmitri will explain how plan caching works internally and demonstrate how to address several common issues related to the plan caching. He will talk about parameter sniffing, simple and forced parameterization, OPTIMIZE FOR UNKNOWN strategy, and several other related topics. Finally, Dmitri will provide the guidelines how to reduce CPU load and recompilation overhead in the systems with heavy ad-hoc workload and non-parameterized queries.
Speaker(s): Dmitri Korotkevitch,
Abstract:
Honey, Let Me Drive! See how husband and wife tech team, Steve and Susan Schneider, set up a Florida traffic database in Azure and build dynamic interactive presentations using Power BI, without killing each other or ‘driving’ each other crazy! In this fast pace seminar, you’ll get a quick overview of how to set up an Azure database and move data to Azure; then it’s off for a road trip with Power BI. Using Power BI visualizations, we’ll answer some questions like: 1- What color of vehicle is most likely to be in an accident 2- What make and model get into crashes most often 3- What counties in Florida have the highest amount of accidents? Hint: It is not Duval! 4- Do more accidents really happen on one day of the week over another day? And much more! Come along on this trip to see how you can stand up your own database in Azure and use Power BI to make your data ‘ready for the road’
Speaker(s): Steve Schneider,
Abstract:
In this 60 minute interactive workshop, attendees are given the knowledge tools to take charge of their listening skills to improve the quality of their communication with other professionals. Ever have trouble getting the right message across to your co-workers or clients? This topic deals with the ways we communicate – accurately and inaccurately – and includes 2 interactive elements: table exercise about voice inflection called “Really? REALLY?!” volunteer activity called the “Alien Press Conference” – a hilarious take on verbal non-verbal cues. Other topics include: Challenges of Communicating; Listening to Understand, Not Respond; 7 Stages of Communication; Verbal vs Nonverbal Cues; Tone is Everything; 5 Ways to Change Your Listening Habits Now; and more. Attendees will learn: • How to control their voice tone and inflection to improve their message delivery; • How to develop and improve their active listening skills; • How to use non-verbal cues to their advantage; more
Speaker(s): Brad Raney,
Abstract:
This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at runtime without the need to change and redeploy the package. Columns and fields are mapped automatically at runtime. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
Speaker(s): Diane Schuster,
Abstract:
With the proliferation of SQL, NoSQL and Big Data databases, organizations can now target specific fit-for-purpose database platforms that align with their particular application requirements regarding scalability, elasticity, functionality and manageability. Platform as a Service offerings make this even easier now, enabling developers to roll out their own database infrastructure in minutes with minimal management overhead. However, this same amount of flexibility also comes with the challenges of picking the right tool, on the right provider and with the proper expectations.
Speaker(s): Richard Weiss,
Abstract:
Azure Machine Learning is a fully managed predictive analytics service that you can use to create predictive models against your data in SQL Data Warehouse, and then publish as ready-to-consume web services. You will learn how to read data from your database; how to create, train, and score a predictive model; and how write data to your database or create a web service.
Speaker(s): Bogdan Visinescu,
Abstract:
The deployment process is frustrating; an object is missing, an object is deployed in the wrong order or an incorrect version. Deploying to multiple environments like Dev, QA, UAT and Prod is a challenge whither on premise or in the cloud. Source controlling database objects is paramount. Team development is required. Database code will only be deployed when changed. Proper security deployment will be repeatable per environment. Together, let us discover how using Database Project will help us with consistent releases. Deployments can cause you trouble but we will share a reliable deployment and version control process. Let’s see how Database Project can help us accomplish this goal.
Speaker(s): Thomas Norman,
Abstract:
XpressInsight is a Framework as a Service product that provides the modules and tools to rapidly implement an Enterprise Data Warehouse and Business Intelligence solution, at a fraction of the cost. It is built entirely on the Microsoft BI stack using SQL Server 2016, SQL Server Analysis Services (tabular), SQL Server Reporting Services, and Microsoft Power BI. In this session, we will demonstrate loading a data warehouse from multiple sources (A SQL server on Windows and an ORACLE DB on Linux) into a Kimball style dimensional model. We will demonstrate how to measure and report on data quality, correct data quality issues, load auditing, self-service reporting with SSRS and Power BI, and publishing your Power BI reports and dashboards to the cloud while allowing those applications to retrieve the data from a secure on-premise location.
Speaker(s): Paul Williams,
Abstract:
Beyond the Stars…Alternative Date Warehouse Structures to Empower Your Reporting and Analytics Team. Star schema has become ubiquitous with Data warehouses and unless you have a well define cube modeled on top of it, they can be difficult for even experienced report writers to use. In this session, we will explore alternative structures that once built, with allow for rapid report development, by anyone who can write a simple select statement; empowering your developers to provide business insight without the dubious task of ‘starting from scratch’. The following concepts and structures will be discussed: • Base/Detail Structures • Current State Structures • ‘Point In Time’ Data • Band Structures • Lifecycle/Timeline Structures Additionally, we will discuss the importance of granularity, naming, object selection and refresh rates within the context of the aforementioned SQL structures.
Speaker(s): Thomas Banyan McGowen,
Abstract:
In this session, we will discuss how to efficiently migrate your retrospective analytics from where it is now to Power BI, and do it in a way that saves you time in the future. Some of the topics include: • How to create a solution that is simple, automated, standardized and scalable • How to avoid common pitfalls and "death by a thousand reports" • How to most efficiently distribute the reports afterwards
Speaker(s): Taras Kaduk,
Abstract:
Bar graph, or pie chart? Color, or grayscale? Percentage, or absolute numbers? If you ever asked yourself these questions before presenting data, ever needed to put together a graph and didn’t know where to start, ever wanted your numbers to make a bigger splash - this talk is for you. We will cover the “why” and “how” of data visualization; and explore the do’s and don’ts. Come learn something new!
Speaker(s): Haim Shternshus,
Abstract:
In this presentation I will be showing you how to get Power BI added to your current web application. We will be using the Power BI API's to embed the analytics into you company web application.
Speaker(s): David Liebman,
Abstract:
Features or concepts like Change Tracking, Change Data Capture, Temporal Tables, and other similar delta systems are complex and may carry a stigma or misapprehension in your organization around performance or security or cost. Even if you do not directly implement these features or methods absolutely, most information systems rely on tracking changes especially from legacy line of business applications. I'm here to show you robust techniques for implementing delta systems in SQL Server to increase the trustworthiness of your data warehouse. I will also steer you away from common pitfalls.
Speaker(s): Doug McClurg,
Abstract:
Power BI is an incredible tool and as more companies and individuals adapt this new technology it is time to turn our focus from report development to Administration. Noone really wants to discuss Administration but it's important to understand the security risks and how to mitigate those risks through proper administration. In this session, we will discuss an overview of Power BI Administration as it relates to security and governance.
Speaker(s): Mitchell Pearson,
Abstract:
SNI Technology Presents, Creating Your Personal Brand Behind the Staffing Curtain I will share my experience over the years in Staffing to provide some tips and tricks to help the community. I will discuss online presence, personal branding, selecting a staffing vendor, resume tips and tricks, nailing a technical interview, industry trends and anything else that may come up!
Speaker(s): Ben Cusson,
Abstract:
This session will cover how to setup your database source code in a source code repository and configure continuous integration and continuous deployment of your database alongside your application using Visual Studio Online, Red Gate DLM SQL CI, and Octopus Deploy.
Speaker(s): Jeff Taylor,
Abstract:
Performance tuning can be complex.It's often hard to know which knob to turn or button to press to get the biggest performance boost. In this presentation, Janis Griffin, Database Performance Evangelist, SolarWinds, will detail 12 steps to quickly identify performance issues and resolve them. Attendees at this session will learn how to: 1. Quickly fine tune a SQL statement 2. Identify performance inhibitors to help avoid future performance issues 3. Recognize and understand how new SQL Server features can help improve query performance
Speaker(s): Janis Griffin,
Abstract:
How you can create json documents for sql server 2014 and below using integration services? On this session we are going to cover what is needed, how it can be done. This session will show you each step of the way to finally deliver that Json document across your organization.
Speaker(s): Jorge Novo,
Abstract:
If you need a dependable way to deploy SQL time after time, Powershell DSC provides methods for customizing deployments based on the type of role the Database server will take in your environment. Even though the SQL installer already has a script builder for automating installs, by using PowerShell DSC and community resources you may either push or pull a deployment to a full gui or core server.
Speaker(s): Joshua Corrick,
Abstract:
With the 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): Chris Albrektson,
Abstract:
Ever wonder why your resume ends up in a black hole when you submit it online? You know what your resume looks like, but do you wonder how a computer sees your resume? Let Brandi and Amanda teach you how to use word clouds for job postings and your resume. Guaranteed to be a light bulb moment for your career search efforts!
Speaker(s): Brandi Kiehl,
Abstract:
How to embed Power BI visuals on web pages has changed since the launch of Power BI Premium. This session will teach you how to get started on the new, unified Power BI API.
Speaker(s): T.J. Brown,
Abstract:
In higher education, student registration leads to student retention. In the session, I will explain the strategy we have used to model star schemas for these two critical business processes in our data warehouse. The presentation will focus on the logical model as well as some physical implementation decisions and successes using SQL Server 2016.
Speaker(s): Jason Jones,
Abstract:
Looking for a simple way to get started with Azure? Not sure if Azure SQL DB is right for you? Try it out by moving an existing database to the cloud! In this session, you will learn techniques to migrate your on-premises SQL Server databases to Azure SQL DBs, and why backup and restore is not one of the three. This session will also provide guidance on determining whether your on-premises SQL Server database is compatible with Azure SQL DB.
Speaker(s): Bob Rubocki,
Abstract:
Your personal brand is how you distinguish yourself from other people but how you develop and nurture your brand can be the difference between stagnation and opportunity in your career. We'll discuss your branding, the importance of taking control of your brand, and how to begin developing your personal brand. By the end of this session, you'll have a better idea of how to begin building your personal brand into something that can take your career to the next level.
Speaker(s): Dustin Ryan,
Abstract:
Go beyond the buzzwords and let's get real about how you can help transform your company as a data professional. Adam will walk through the major areas of business that are transforming, how you can help and give you tips on becoming more influential in your organization by leading this change.
Speaker(s): Adam Jorgensen,
Abstract:
I will be showing the latest build of SQL Server vNext for Linux. Everything you need to install and connect to SQL Server. Then, what tools are available to use from either Linux and Windows. Sample on querying for database information using Python and PowerShell between two environments. This will be a demo intensive session
Speaker(s): Maximo Trinidad,
Abstract:
Want to know the position Master Data Management and MDS play in an organization's overall data strategy? We'll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We'll then take a look at the features of SQL Server 2016 MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.
Speaker(s): Neal Waterstreet,
Abstract:
Kids camp! Pre-registered event.
Speaker(s): Eric Wisdahl,
Abstract:
A panel discussion with some of the great Women of the community.
Speaker(s): Brandi Kiehl,
Abstract:
Common mistakes you can avoid to run your queries very effiently
Speaker(s): Victor Ivantsov,
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!*
Speaker(s): Scott Gleason,
Abstract:
So you're using Azure Sql Database Platform As A Service. Now what? Without a physical machine, how do you do restore? Where are the backup files? When are service packs applied? Can service packs be rolled up thru dev to production? What's a service level and how does it impact database design? How do we encrypt, authorize, query tune, restore...? We'll go over these questions and any others that you may have.
Speaker(s): Jonathon Moorman,
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/in/haim-shternshus
Haim Shternshus is an Intelligence Analyst at the Citizens Property Insurance Special Investigation Unit (try to say that five times fast), and holds a Mechanical Engineering degree. He uses his engineering experience and analytics expertise to interact daily with endless rows of data, and find the stories within. Haim specializes in designing interactive dashboards that enable users to make smart, data-driven decisions in real time. He has been speaking and training throughout his career.
Brian Carrig is a Microsoft Certified Master of SQL Server and is currently a Senior Program Manager on the SQL Server Tiger Team at Microsoft focusing primarily on persistent memory technology and replication. In a previous life, Brian spent some time as an academic and holds a PhD in Computer Science. He is a native of Dublin, Ireland but now lives with his wife and two daughters in Redmond, Washington. If he is not talking about, thinking about or working with technology you will usually find him watching Chelsea FC.
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/in/adrshen/
Contact: https://adrshen.wordpress.com/
Over 15 years of Information Technology experience with the last 12 years focused on mastering the Microsoft SQL Server platform including Power BI and data Science algorithms. My diverse background of hands-on experience has resulted in a strong foundation of SQL Server knowledge, a mastery of the art of architect, managing and maintain very large scale of databases (2TB+ transnational). My background of administrating financial, healthcare, mortgage, and retails data makes me very unique database administer to work with. My overall experience and exposure to the IT infrastructure like virtualization, SAN planning and monitoring and understanding of advance networking concepts really compliments my dba skillset. After being expose
LinkedIn: https://www.linkedin.com/in/brandikiehl
Co-Organizer of the Women in Information Technology of Jacksonville, PyJax, IT Pro/Florida IT Server Group, IT Pro Camp, Tech Coast Conference, Women and Minorities in IT Conference, Bsides of Jacksonville, and Career Network Outreach. Co-Owner of Stardust Techologies and Career Network Outreach. A certified Project Manager and experienced IT professional with over 10 years of data science, analysis, and management experience. Enjoys teaching and helping people to find new or transition careers, with mock interviews, elevator speeches, clean up or create more professional social media profiles, change their way of thinking about job searching, reinvent their resumes, and how to network.
LinkedIn: https://www.linkedin.com/in/thomas-banyan-mcgowen-86403749/
Let the power of data compel you!!! Banyan is a data expert who strives to find new ways to transform and utilize data to drive process and organizational change. A believer that to empower an organization one needs to move past the star and the pivots tables, he has spent a career blurring the lines between IT and business, analysis and architecture. Holding such titles as Financial Analyst, Developer, Business Systems Analyst, DBA, Data Architect and Assistant Director, he has spent the bulk of his career working in Finical Services and Higher Education. Most recently, he has spent the last 1.5 years supporting the mission of Community Hospice and Palliative Care here in Jacksonville, FL.
LinkedIn: http://www.linkedin.com/in/rdameron
Contact: http://RonaldDameron.com
Ronald Dameron is The Only DBA at a small software company building planet-scale mobile resource management software. He has over 20 years IT experience on a variety of platforms. His current interests are Azure, PowerShell, SQL Server 2016 and Linux. He was a PASS Summit 2015 Speaker Idol contestant and has spoken at SQL Saturday Tampa, Orlando, South Florida, and the Tampa and Orlando SQL User groups. He has recently earned the Competent Communicator Award from Toastmasters International. He is most active on Twitter as @RonDBA.
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: http://www.linkedin.com/in/richardaweiss
Contact: http://www.Pythian.com
Richard Weiss is a Principal Consultant and Solution Architect at Pythian specializing in Cloud, SQL Server, and Wintel technologies. Over the past 20 years, he has held senior technology roles at First Data, Western Union, and AAA. Additionally, Richard serves on the Data and IOT standards committee for the National Retail Foundation
LinkedIn: Linkedin: http://www.linkedin.com/pub/max-trinidad/12/47/775/
Contact: http://www.maxtblog.com
Maximo Trinidad (Florida Aka – Mr. PowerShell), currently work as a SAPIEN Technologies Evangelist and specialing in scripting automation on SQL Server Microsoft Cloud Technologies. Also a Microsoft MVP (PowerShell) since 2009 and active speaker since 2007 participating at SQLSaturday, IT Pro .NET Code Camps events.
Contact: https://jasonjonesdata.blogspot.com/
After 10 years in the United States Air Force as a linguist, I decided to go into the world of computing. I graduated from the University of North Florida with a Bachelor of Science in Computing Info Sciences. Before graduating, I completed a yearlong internship with an excellent company where I learned how important it was to teach myself and follow my passions. As a .Net programmer my biggest surprise was how interested I was in database development. My current interest is getting information to decision makers as fast and easy as possible. From conceptual and logical data models to physical implementation, I want to get the right information to the right people with as little technological effort as possible.
LinkedIn: http://www.linkedin.com/pub/janis-griffin/0/914/aba
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
LinkedIn: https://www.linkedin.com/in/luisefigueroa
Contact: http://blog.luisfigueroa.net
Luis Figueroa is a data professional with more than 15 years of experience in Information Technologies across many industry verticals. Luis has held a variety of positions in IT such as Network Administrator, Systems Engineer, Database Administrator and EDW / BI Architect. In the most recent years Luis found his passion in architecting and developing open source data centric solutions that help businesses manage their data and gain a competitive advantage through analytics. Luis currently holds a position as Solutions Engineer for Hortonworks, Inc. where he works with many clients including Fortune 500 companies. Luis’ main focus areas are in Data Warehousing, Business Intelligence, Advanced Analytics, Big Data, IoT and Cloud Computing.
Senior SQL Server developer with 20+ years of experience. I have enjoyed many SQL Saturday as participant, now is my time to contribute
LinkedIn: https://www.linkedin.com/in/susan-schneider-01946019
Contact: http://susansblog.sqlinsight.net/
Susan Schneider is a certified Microsoft Professional with a concentration in Database Fundamentals. She is a Data Engineer for MoneySolvers , a Tax Defense Network company, in Jacksonville, Florida. Her passion is data, with a focus on T-SQL, Power BI and SSRS. She started her own technical journey ten years ago at a SQL Saturday event; and she wants to give back to the technical community that helped and encouraged her along the way. She has spoken at various SQL Saturday and IT Pro Camp gatherings, and enjoys meeting people new to technology. When she’s not working, learning, or blogging; she enjoys traveling and sailing with her husband, Steve. You can find her on LinkedIn or follow her blog. Happy Learning!
LinkedIn: https://www.linkedin.com/in/ericwisdahl
Eric Wisdahl is a computer engineer working in the database field. He has held multiple roles and positions in e-commerce, marketing and insurance industries. Currently, he is working as a database administrator in a development role for an e-commerce company. Eric Wisdahl does not like writing about himself in the third person. It is kind of creepy.
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: 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.
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/robertrubocki
Contact: http://bobrubocki.wordpress.com
Bob is a Senior Consultant at Pragmatic Works and a Microsoft Certified Professional. He has spent most of his career working in Business Intelligence, Data Warehousing, and Data Integration, both in industry and as a consultant. He has implemented solutions in financial services, healthcare, manufacturing, retail, and consumer goods industries. Bob has spoken at SQL Saturday, user group events, and webinar sessions. He is fascinated by the variety of opportunities available in the cloud.
LinkedIn: https://www.linkedin.com/in/taraskaduk/
I solve problems using data. Power BI, Tableau, and lots of R.
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: http://www.linkedin.com/in/nealwaterstreet
Contact: http://www.nealwaterstreet.com
Neal is a BI Architect/Consultant with more than 20 years of industry experience. Neal is skilled in the entire BI spectrum, including dimensional modeling, ETL design and development using Integration Services (SSIS), designing and developing multidimensional cubes and Tabular models using Analysis Services (SSAS) and Master Data Management using Microsoft Data Services (MDS). He's also involved with the database community and is the co-founder and co-leader of the PASS Healthcare Virtual Chapter and the Atlanta Modern Excel User Group.
LinkedIn: https://www.linkedin.com/in/kellynpotvin
Contact: http://dbakevlar.com
Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Idera ACE and Oracle ACE Director alumnus. She is a Data Platform Architect in Power BI with AI in the EdTech group at Microsoft. Kellyn is known for her extensive work with multi-database platforms, DevOps, cloud migrations, virtualization, visualizations, scripting, environment optimization tuning, automation, and architecture design. Kellyn has spoken at numerous technical conferences for Oracle, Big Data, DevOps, testing, and SQL Server. Her blog (http://dbakevlar.com) and social media activity under her handle, DBAKevlar, is well respected for her insight and content.
LinkedIn: http://www.linkedin.com/in/dianeschuster
Diane has worked with COZYROC since 2012. She has attended numerous SQL Saturdays to shine the light on the time-saving and capability-extending components and tasks that COZYROC offers in it’s SSIS+ library. Without even having a background in databases or SQL Server, Diane successfully configures packages in live demonstrations that use COZYROC components and tasks. She believes that, if the toolkit is this easy to use for a novice, then just imagine what a SQL Server expert can do with it! In Diane’s data networking days, Diane performed a variety of development-related and customer-facing roles for IBM, Lucent Technologies, North Carolina State University and Connectware.
LinkedIn: https://www.linkedin.com/in/sqldusty/
Contact: https://sqldusty.com
Dustin Ryan is a Data Platform Solution Architect at Microsoft. Dustin has worked in the business intelligence and data warehousing field since 2008, has spoken at community events such as SQL Saturday, SQL Rally, and PASS Summit, and has a wide range of experience using the Microsoft business intelligence stack of products across multiple industries. Prior to his time at Microsoft, Dustin worked as a business intelligence consultant for a Microsoft partner. Dustin resides outside Jacksonville, Florida with his wife, three children, two cats, two dogs and enjoys spending time with his family and serving at his local church. You can learn more about him at http://SQLDusty.com.
LinkedIn: https://www.linkedin.com/in/brandikiehl
Co-Organizer of the Women in Information Technology of Jacksonville, PyJax, IT Pro/Florida IT Server Group, IT Pro Camp, Tech Coast Conference, Women and Minorities in IT Conference, Bsides of Jacksonville, and Career Network Outreach. Co-Owner of Stardust Techologies and Career Network Outreach. A certified Project Manager and experienced IT professional with over 10 years of data science, analysis, and management experience. Enjoys teaching and helping people to find new or transition careers, with mock interviews, elevator speeches, clean up or create more professional social media profiles, change their way of thinking about job searching, reinvent their resumes, and how to network.
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: http://www.linkedin.com/in/armordba
Contact: https://armordba.com/
Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.
LinkedIn: https://www.linkedin.com/in/dmcclurg
Doug McClurg is the principal and founder of SOSRA Inc., an analytics leadership company. He brings both military and corporate experience to organizations who want to build or accelerate their analytics program. Doug has been building tailored Microsoft SQL Server solutions for many years. He brings deep knowledge of modern information architecture to projects ranging from innovating the traditional data warehouse to capturing WiFi presence and machine data to democratizing corporate analytics. He has served as a leader, mentor, and architect to teams in Government, Oil Gas, Hospitality, and Retail.
LinkedIn: https://www.linkedin.com/in/bradraney83/
Contact: https://bradraneyblog.wordpress.com/
Brad Raney is a national speaker, international author, sales/leadership/management trainer, entrepreneur and has almost 30 years’ experience in creating and developing high performance teams in a variety of industries across the country. Brad’s first book on how to find your perfect job has now sold on three continents and his latest book called Reach YOUR Peak:Become CEO of Your Success! is selling fast across the country in traditional and e-book formats. Brad has spoken to almost 100,000 people and was part of the highly successful “Pink Slip Tour presented by Virgin Mobile,” that made stops in Miami, Orlando, Jacksonville, Atlanta, Minneapolis, and Detroit. Brad has been on Advisory Boards for: • The University of North Flori
LinkedIn: https://www.linkedin.com/in/paul-williams-5569234/
With over 20 years of experience in creating solutions for various industries’ complex business problems, I have a proven track record of success. My experience is best suited for meeting with business stakeholders to determine how they measure success in their organization and identify the different business processes that contribute to that. With that information and access to their subject matter experts, I can build them a BI solution that provides a single unified view of their entire business and a single source of truth. This will drive efficiency into their organization allowing them to focus on their larger goals rather than spending all of their time manually gathering data.
LinkedIn: https://www.linkedin.com/in/bogdan-visinescu-b7988213/
I am working as an Assistant Professor of Mathematics at University of North Florida. As an Assistant Professor, I taught various statistics and mathematics courses. My research interests are in Operator Algebras, Matrix Theory and Data Science. I worked as an Actuarial Analyst at Kemper, where he prepared actuarial analysis of rates and rating plans for certain lines of insurance. Education • Microsoft Professional Program Certificate in Data Science • Microsoft Azure HDInsight Big Data Analyst • PhD in Mathematics - University of Cincinnati. • B.S. Degree in Computer Science and Mathematics, University of Bucharest.
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.
LinkedIn: https://www.linkedin.com/in/bencusson/
Contact: http://www.snitechnology.com/Blog
SNI Technology earned the Best of Staffing® Award for providing remarkable service quality. Fewer than 2% of all staffing agencies in the U.S. and Canada earned the 2015 Best of Staffing Award for service excellence. With satisfaction ratings more than three times higher than the industry average, the Best of Staffing winners truly stand out for exceeding expectations. This award identifies the staffing industry's elite leaders in service quality.
LinkedIn: https://www.linkedin.com/pub/dmitri-korotkevitch/5/980/b7
Contact: http://aboutsqlserver.com
Dmitri Korotkevitch is a Microsoft Data Platform MVP and Microsoft Certified Master, author of Pro SQL Server Internals and other books with years of experience working with SQL Server as an Application and Database Developer, Database Administrator, and Database Architect. Dmitri specializes in the design, development, and performance tuning of complex OLTP systems that handle thousands of transactions per second around the clock. He blogs at: http://aboutsqlserver.com.
LinkedIn: https://www.linkedin.com/in/liebmandavid/
Contact: http://www.bisqldave.com
I’m a developer specializing in .Net, SQL, and SSRS development for over five years of the eighteen years I have spent in the IT Industry. I have experience working for some big companies in Financial, Healthcare, and Insurance. I have written some custom reporting solutions and web applications for Large Companies in the Tampa Bay area using .Net, SSRS, and SQL.
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: 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/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/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/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.
LinkedIn: https://www.linkedin.com/in/joshua-corrick-6775638b
Contact: http://corrick.io/blog
Joshua is a Systems Engineer at the University of North Florida, and has been in this role for 2.5 years. Josh has many different hats on his team, but tends to be given the DBA responsibilities. He is also a passionate advocate for PowerShell and automation of any fashion. He is a husband and father of two boys. They have lived in Jacksonville FL since 2014.
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/pawarvishal
Contact: http://bimentalist.com/
Vishal Pawar is a Microsoft Data Platform MVP, Microsoft Certified Trainer (MCT), founder of the Global Power BI User Group and co-leader of the PASS Business Analytics Virtual Group. He is a Principal BI Architect in Green House Data, with decades of experience in BI solution architecture and best practices. He has published more than 1000 articles since 2011 in SQL and BI. Vishal teaches a free Power BI course through Udemy, which has more than 65K students from the glob. Vishal is an exceptional technology community of leaders worldwide who actively share their high quality, real-world expertise with the technical communities.
LinkedIn: https://www.linkedin.com/in/kenneth-ken-wood-01a1a22b/?trk=nav_responsive_tab_profile_pic
Currently I serve as the Learning Development Manager at Pragmatic Works. In this role, I am responsible for training content and distribution. I seek to build new business relationships with those in need of IT Training within Microsoft based applications (SQL, BI, SSAS, SSIS etc.) and nurture existing relationships. While IT was not my initial venture, I made the career move and have fallen in love with the world of technology over the last several years! I have a passion for Growth and motivating others to reach their potential. I firmly believe, if you're not challenging yourself, you're not growing.
LinkedIn: https://www.linkedin.com/in/sqltj/
I'm a Sr. Business Intelligence consultant with over 5 years of experience consulting in the SQL Server BI stack, and big data workloads on Azure. I'm from University of Florida graduate and currently reside in Jacksonville, FL.
LinkedIn: https://www.linkedin.com/in/felix-asencio-0054946/
My professional experiences includes Extracting, Transforming and Loading (ETL) using SQL Server Integration Services data into data warehouse using the Kimball methodology into MS SQL Server Database. In addition, my experience includes reporting using SQL and Access and data analysis using excel MS Reporting Services and Crystal Reports. I love the field I work in due to the variety of assignments and the ability to acquire new skills.
The following is a list of sponsors that helped fund the event.