Event Location:
USF MUMA College of Business
12212 USF Maple Drive
Tampa, Florida
Abstract:
Thinking about migrating your data warehouse to the cloud? What about all those SSIS packages executing ETLs against your on-prem data sources? In this presentation we will discuss how to successfully "lift and shift" your ETL workloads to the Azure cloud. You will l learn how to configure and deploy an Integration Runtime, deploy and execute SSIS packages in an Azure Data Factory pipeline, and how to monitor and troubleshoot your ETL executions in the cloud. Attendees will walk-away with an understanding of the features, capabilities and limitations of Azure Data Factory and the Integration Runtime and a strategy to leverage your existing SSIS package development efforts to the cloud.
Speaker(s): Jose Chinchilla,
Abstract:
Storytelling and depiction of information has existed for hundreds of years in various forms and formats. In today’s era of artificial intelligence and machine-assisted analytics, accurately interpreting and effectively communicating findings is becoming a crucial skill to bridge the growing data literacy gap. To help decision makers get the most value from analytics projects to drive better outcomes, you need to help them make sense of the results. Machine learning and advanced analytics can be difficult to understand and explain. Describing the problem, the model, the relationships among variables and the findings are often subtle, surprising and technically complex. Effectively translating quantitative insights and telling a compelling story requires planning, compelling design, and visualization choices. Successful analytical communicators use the entire process to communicate with stakeholders. Don't miss this fun demo-packed educational session.
Speaker(s): Jen Underwood,
Abstract:
Power BI has grown into a very useful and powerful tool to analyze your corporate data, but not everyone knows that it is a product that is literally changing monthly. Each month Microsoft introduces new features to the downloaded and online versions of PowerBI. Keeping up can be time consuming. However, Microsoft provides documentation, videos, and other resources to not only help you up to date with these changes, but to also allow you to vote on potential new features and even to submit new feature ideas of your own. If you have not been keeping up with the changes to Power BI since you first downloaded your desktop version a year or more ago, you need to attend this session to learn how to keep up with this ever changing, ever improving product.
Speaker(s): Michael Antonovich,
Abstract:
Databases are growing. The way we use data is changing and growing. When you have a lot of change, it has to be managed, or bad things happen to your data and your job! A common problem with database change management is... database change management. This session walks the user through the concepts of database change management, why it's important, and how SQL Server Data Tools (SSDT) makes this process easy. There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be. Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.
Speaker(s): James McAuliffe,
Abstract:
Are you investing enough time and in right place when it comes to learning new stuff? Or do you feel like you're spending too much time? Or, more commonly, that you're setting goals and then falling off track? All of us struggle to manage learning while sustaining a career and family. But it IS possible! This session is designed to give you a prescriptive solution to the challenges of managing learning; identifying what you need to learn, how much time to invest in learning each topic, scheduling and tracking your learning, and recovering from the interruptions that life throws at us. My system won't make you rich, but it will make you feel in control of your career learning goals.
Speaker(s): Andy Warren,
Abstract:
In the excitement of the possibilities that Big Data technology and Data Science techniques are opening, we forgot that correlation is not equal than causation and that any design model has intrinsic limitations. Dr. Deming said "In God we trust, all others must bring data." but what he really wanted to reach was Wisdom! Data is just the raw material the real goal is Wisdom I have been thinking about the chain toward Wisdom (Data-Information-Knowledge-Wisdom) and wonder how many organizations have reached, at least, the level of Knowledge and if any at all have reached the pinnacle of Wisdom. We are drowning in a sea of data and we are starving for wisdom. How is Data Science and Big Data changing our profession? What is a Data Scientist? What is a Data Engineer? What is a Data Analyst? Which skills do we need?
Speaker(s): Frank Quintana,
Abstract:
Today, many organizations have already virtualized most of their non critical applications, these organizations are now employing a "Virtual First" policy, harnessing the efficiency and cost savings of virtualization for their most critical applications. Still, many IT architects and DBA's are hesitant of virtualizing their SQL workloads, they are worried about performance, scale, availability and support for what is usually considered their most critical applications. In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by a member of the VMware's SQL Server Experts Group.
Speaker(s): Shawn Meyers,
Abstract:
This session provides an introduction to the use of Power BI for Data Science. It covers the use of Power BI as part of the Data Science process; including EDA (Exploratory Data Analysis), Data Visualization along with its integration with Python, Scikit-Learn and SQL Server Machine Learning Services. This is an introductory session designed for those with basic Power BI skills; as well as, minimal or no Python and/or Data Science experience. This is an applied session focusing on the utilization of the tools, technologies and machine learning libraries; such as Pandas, Numpy, Scipy, etc. The demos are centered around Power BI and its integration with Python, ML engine and Data Science processes.
Speaker(s): Adriano da Silva,
Abstract:
This session is designed to introduce you or to re-engage your interest in all the options we have for setting constraints in a database. From datatypes to nulls to checks, defaults, foreign keys, and triggers we have a LOT of options, so it's important to know the options and also have a bit of a professional philosophy on when to use each of them - we will do a brief look at each of them. We'll talk about why getting them right on day 1 is so important, how to add them to existing tables (the syntax is the least interesting part!), and some patterns and anti-patterns you can look for when you get to the office on Monday. Constraints aren't glamorous, but they matter, and they require an advocate - you! A good session for DBA's, developers, and yes, even managers.
Speaker(s): Andy Warren,
Abstract:
Reports are no longer just black and white columns and rows of numbers. Reports combine tables with charts, KPIs and more. There is a lot to be concerned about when designing reports to provide information to your audience. Today, your company can face lawsuits if your reports are not accessible to all users. You must consider the way you display your data, the amount of data displayed, the use of color and maybe even the use of animation. Creating attractive reports is not just about making them pretty. It is about grabbing your audience's attention. It is making sure you don't inadvertently introduce accessibility problems that limit who can receive your message, your data. This session while looking at some reporting best practices will also give you information to steer you clear of accessibility concerns to insure access to your results by all consumers of your report. (Note: Accessibility is governed through the guidelines of the American Disabilities Act)
Speaker(s): Michael Antonovich,
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:
It’s no surprise that embarking upon a job search can be a high-anxiety time. However, following an effective job search process and applying best practices when it comes to your resume and professional online marketing channels (including 5 key resume truths), working with Recruiters, always attempting the "referral route," leveraging alerts and other strategies, etc. can help reduce frustrations and make it better. In this session, we’ll highlight our top 14 strategies to help you go from "I'm not finding jobs I'm interested in" and/or "I'm not hearing back on my resume or from Recruiters" to "it's time to prepare for my interview!"
Speaker(s): Erica Woods,
Abstract:
Everyone knows that it's critical to have backups but it's amazing how few people make sure those backups can be restored properly! Too many times to count, Tim has been brought in by organizations to help recover failed systems where administrators simply didn't know how to properly restore SQL Server backups when they have to. In this session, Tim will explain the various types of backups that can be taken and demonstrate how to restore each of them. Apart from covering the common full, differential and log backups, Tim will also cover partial, file group, and COPY_ONLY backups, backing up to and restoring from a URL, backup encryption, and how to perform a hack attach for the ultimate tail log restore. There's something here for everyone to learn!
Speaker(s): Tim Radney,
Abstract:
"I feel like I'm always the runner up or 2nd place candidate..." The job market is fierce, and Managers are interviewing several qualified candidates. When you combine that with the fact that 92% of interviewees are highly anxious, and nerves impact their performance, and that most candidates simply don't know how to effectively market themselves, it's easy to see why interviewing is one of the most frustrating parts of the job search. However, we'll teach you some tricks for preparing the right way, how to market yourself effectively, how to conduct a SWOT Analysis to guide your interview prep, provide example best practice questions to ask, share confidence building strategies and provide some favorite recommended resources and tools!
Speaker(s): Erica Woods,
Abstract:
In this session we will cover the best strategies to track and improve SSRS / Power BI Report Server performance and scalability. We will cover methods of tracking report performance through DMVs, leveraging the Report Server ExecutionLog3 catalog view, and monitoring Power BI Report Server / Reporting Services using performance monitor (perfmon), and more. We will analyze this information through T-SQL queries in SSMS and Power BI analysis. We will discuss when to scale out the Report Server and when to focus on the reporting dataset queries that driven through report execution. We will cover methods of isolating Report Server performance from OLTP activity and solutions to isolate expensive reports when you cannot isolate the OLTP and reporting overhead. Finally, we will cover Reporting Services and Power BI Report Design techniques to improve report performance and scalability. We will cover Azure Data Studio extensions, Power BI Dashboards, and examining the exec
Speaker(s): David Pless,
Abstract:
Power BI is Microsoft's industry leading data analytics discovery and visualization tool that has disrupted the way data professionals interact and derive insights from their data. It is one of the most in-demand and sought-after tools to know in today's IT career market. Join us for a fun and interactive learning opportunity to learn how to ingest, transform and visualize data from a wide variety of sources using Power BI. Learn how to create rich and interactive reports incorporating slicers, drill-down and drill-through actions. Attendees will also learn how to create, publish and share reports and dashboards for desktop and mobile consumption. Attendees will walk-away feeling like real Power BI *superstars, capable of tackling any data project in their paths! *Awesomeness may vary.
Speaker(s): Jose Chinchilla,
Abstract:
DevOps lives at the fast paced intersection of developers and IT professionals. Our business partners are learning and expanding their analytics toolkit, putting more pressure on technical teams to deliver analytics at an accelerated operational cadence. I'm here to show you how to automate your production database code delivery even in large data warehouse environments.
Speaker(s): Doug McClurg,
Abstract:
With SQL 2016, Microsoft introduced Temporal tables. In this session we will learn what a Temporal table is, and discuss uses in current environments. We will learn how to create the tables, query the data from the tables for different scenarios, and optimize them for query performance allowing simplicity for the consumers of the data.
Speaker(s): Dale Sullenberger,
Abstract:
Database corruption could happen to you. When it happens to you, do you know what to do? Will you realize quick enough that you have corruption? The presentation begins by talking about how to detect the corruption and the different strategies for handling unique corruption issues. Highlight of topics 1. Why corruption occurs? 2. Detecting corruption – how SQL Servers detects corruption at the page level. 3. Different types of corruption- e.g. False alarms, memory corruption etc. 4. Limitation of DBCC how to speed the DBCC process. 5. Undocumented DBCC commands. 6. Monitoring I/O errors. 7. Verifying backup for corruption.
Speaker(s): Stephen Muliokela,
Abstract:
2016 SSIS packages can access data anywhere throughout the network, but normally run on the server they are deployed on. And if something terrible happens to that server, the manual setup of the SSISDB can be time consuming. With 2017, SSIS packages can be deployed once and run on several servers, even simultaneously. This session will teach you how to set up 2017 SSIS Scale Out packages so that your SSIS packages can now be in a Highly Available and Disaster Recovery environment.
Speaker(s): Paul LaGrone,
Abstract:
In this session you will learn how SQL Server 2019 implements an elastically scalable storage layer that integrates SQL Server on Linux, PolyBase, Containers, Kubernetes, Spark and HDFS to scale to petabytes of data storage. You’ll get a complete explanation about the architecture for this platform, and you’ll also learn about common use case scenarios for using big data clusters.
Speaker(s): Buck Woody,
Abstract:
Tired of paying too much in taxes? Learn how to save on your taxes by taking advantage of every credit and deduction you are eligible for. Jo Willetts will explain tax reform changes and delve into the deductions and credits you could be eligible for so you can keep more of your money come tax time.
Speaker(s): Jo Willetts,
Abstract:
To improve the performance, sustainability, security and scalability of enterprise-grade Power BI implementations with constant velocity, we need to adhere best practices In this session Vishal will go over Power BI Ecosystem with Example, PBI RS evolution from its inception Architecture of Enterprise Power BI Report Server and usage through various tool available to publish -SSDT SSRS, Power BI Desktop(Optimized Version), Report Builder and mobile report builder and various Best Practices for PBI Report Server.
Speaker(s): Vishal Pawar,
Abstract:
A concise and systematic approaches rather than guessing to analyze SQL Server performance will be presented. Through measuring the response time and wait time at the query level, the performance bottleneck is pinpointed and tuned. The presentation will look at the basic of gathering the stats from SQL Server DMVs.
Speaker(s): Eddy Djaja,
Abstract:
SSRS 2017 has recently added a RESTful API to the Reporting Server, in addition to its classic SOAP interface. Using Powershell's Invoke-RestMethod , we will explore the new API with examples for creating folders, permissions, altering Timed Subscriptions and firing them off.
Speaker(s): George Walkey,
Abstract:
SQL is conceptually different than most programming languages. Join us for a conversation about SQL, why it's different from traditional procedural languages, and how to effectively use this truly elegant programming language. Rather than focus on the kinds of information easily located on the Web, we'll concentrate on how to use SQL for the tasks that it's really good at. Beginners will get a great introduction to the style of thought that gets the most out of SQL. Experienced developers will find a good refresher and an opportunity to share their experiences with others.
Speaker(s): Robert Hatton,
Abstract:
Power BI has taken the world by storm since it's release in mid-2015. Since then, Microsoft's cloud analytics service has matured and grown in scope and complexity. In this session, we'll seek to understand the moving parts of the Power BI ecosystem including Power BI Pro, Premium, Report Server, Embedded, Data Flows, and more. By the end of this session the audience should have a firm grasp on the components ecosystem and how those components work together.
Speaker(s): Dustin Ryan,
Abstract:
You just walked into that fancy new gig, and you're getting your first cup of coffee. Your boss walks up and asks, "Who has access to that prod server?", do you know how to get the answers in the next hour? More importantly, do you know what these permissions mean, what an attacker could do with these permissions? In this session we'll start from scratch assuming that you have no experience with an audit with this question in mind. We'll work back from here to develop a strategy of how to harden your server.
Speaker(s): Travis Page,
Abstract:
Time and time again the same misunderstandings by developers and query writers appear when query performance issues arise. In this demo heavy presentation, we will review these specific topics such as data types, implicit conversions, sargability, and some others that all have an impact on query performance. Come join me and by the end of this session you will have the knowledge to boost your query performance!
Speaker(s): John Wells,
Abstract:
This will be a beginner level session on SQL clauses and the key parts of a SQL statement. We will cover the main building blocks of the language with the SELECT, INSERT, UPDATE and DELETE commands. We will do a syntax breakdown of the statement structure with special focus on the JOIN clauses in the FROM statements and conditional statements in the WHERE clause.
Speaker(s): Carolyn Risk,
Abstract:
Learn how easy to write powershell As being DBA Use powershell for reporting and check database status Run one powershell script for all instance and many more
Speaker(s): Jignesh Patel,
Abstract:
Abstract: Dell Technologies has infrastructure platforms to Accelerate, Protect, and Modernize your SQL Server environments. SQL Server 2017/2019 coupled with advanced hardware platforms from Dell allows you to move to the next level of performance. Learn how next-gen hardware integrates directly into SQL Server.
Speaker(s): Craig Allen,
Abstract:
In this session, we will cover the new features that are being introduced in SQL Server 2019 CTP 2.x.
Speaker(s): Jeff Taylor,
Abstract:
This session is for people who are brand new to SQL Server or are looking for a review of the fundamentals of SSMS. We will review features presented in version 17.9, specifically creating tables and views; choosing data types; creating indexes, constraints, rules and triggers; creating basic queries using select, from, where, order by; simple joins; more complex queries and operators; primary key, foreign key, composite key; generating a system data diagram.
Speaker(s): Harvey Hyman,
Abstract:
This session will include an explanation of what indexed views are, the types of problems that they solve, and their limitations. Additionally, I will provide a methodology for determining whether or not you should consider using indexed views to solve problems in your environment - including how to test and compare them to some alternatives. I will then go through some demonstrations in order to clarify my points further and provide more opportunities for the audience to ask questions.
Speaker(s): Alexander Fleming,
Abstract:
You’re company is transitioning to the Cloud. Initially, your Azure deployment was small and could be managed primarily via the Azure portal but now it spans the globe with implementations in several countries. You have too many resources to manage with the Azure portal alone. You can automate these tasks with PowerShell without being a PowerShell expert. I’m Ronald Dameron. I’m responsible for managing the resources of twelve Azure subscriptions containing hundreds of resources. I can show you how. I’ve done it.
Speaker(s): Ronald Dameron,
Abstract:
Today's hiring environment is very different from even 1 year ago. If you have applied online to jobs and have not had success this interactive session is for you. Come learn how to craft a resume to start getting results with online submissions. MOre interviews = more offers. Let's learn how to beat the applicant tracking systems.
Speaker(s): Suzanne Ricci,
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 semantic modeling technologies like SQL Server Analysis Services or Power BI and how the choices we make during the data warehouse design phase can make or break our reports.
Speaker(s): Dustin Ryan,
Abstract:
Database masking, obfuscation, CI, CD... What is this stuff? This is a story about how we did a complete overhaul on our development life cycle to create more outcomes for our users, resolve communication issues with the team, and provide pre-production databases for our developers through database obfuscation. We will discuss our why, our team structure, the preparation work completed, the database obfuscation process tools available.
Speaker(s): Katie Schmidt,
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:
Since the end of the previous decade, our profession has been kicked by a set of new models, technologies, and architectures that are revolutionizing our practice. I pretend to clarify the position of SQL as the LINGUA FRANCA for Data and the relational model versus the allegations of deprecation of the relational model, and the NoSQL movement presentation of SQL as a language with no future. These among others are the topics of my presentation. In this presentation, I will depict the Hadoop evolution from version1 to version 3, and its relation to legacy architectures models and in particular to SQL.
Speaker(s): Frank Quintana,
Abstract:
Quick Introduction and Agenda Overview Roles and Responsibilities Audit and Compliance Teams Data Owners and Technology Owners Tips for Successful Collaboration Framing the Audit or Assessment Agreed Upon Findings Responding to Inquiry Partnering with Compliance and Audit Teams Questions and Contact Info
Speaker(s): Martina Tesar,
Abstract:
Nearly everyone one who attends a SQL Saturday has something to share, which others can learn from. This session covers how to take your knowledge and ideas and turn them into a presentation. Most of the focus will be on content generation and organization of your idea into a presentation and demonstrations, to allow you to present.
Speaker(s): Shawn Meyers,
Abstract:
Most DBAs use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exported because they live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, Server Triggers and much more
Speaker(s): George Walkey,
Abstract:
My journey of survival and overcoming discrimination, harassment, divorce, layoffs , single mothering and death . Independent of any industry women share many struggles, but it is more difficult when you try to do in an industry dominated by men. I will be sharing my experiences and tools to grow in your personal and professional life.
Speaker(s): Gilda Alvarez,
Abstract:
Ever wondered on what is the buzz about Internet of Things (IoT)? and interested in making your own? We will take an look on what is Internet of Things (IoT), the impact of IoT to the world, industries that IoT can disrupt and then, we will provide an overview of building an IoT solutions using various technologies in Azure such as IoT Hub, Functions, Stream Analytics, Power BI, and more.
Speaker(s): John Wang,
Abstract:
Features and 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,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
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.
Contact: http://blogs.msdn.com/b/sql_pfe_blog/
For the past nine years, I have been a Technical Solution Professional with Microsoft. As a TSP I conduct full training workshops, conduct demo sessions, and perform architectural reviews on all supported builds of SQL Server. I mainly support the Southeast focusing on Florida, but I can be anywhere in the world. My core areas are Performance Tuning and Optimization, Azure, AlwaysOn, Reporting Services (SSRS), custom monitoring, building custom dashboards, and more.
I’ve been in the technology space in the Tampa Bay Area for over 20 years starting with Salomon Brothers (through various mergers to Citigroup). In 2007 I joined the IT Team at Publix Supermarket's focusing on IT Compliance, then moving into management in the Identity and Access Governance area. In 2018, I joined Jackson Hewitt as the IT Compliance Program Manager.
LinkedIn: https://www.linkedin.com/in/suzannericci/
With a passion for technology and education, Suzanne established LaSalle Computer to fill a market need for an adult learning center with a focus on high-quality, hands-on training and high-level customer service. By age 27, she had purchased and sold, for a profit, a second school while still growing and leading LaSalle. A life-long student with a deep dedication to education and continuous improvement, Suzanne was able to lead and grow LaSalle to become a successful acquisition by the second largest private equity firm specializing in the knowledge sector. With a love of helping others she established Computer Coach to continue to help IT and business professionals find career success through strategic career plans.
LinkedIn: http://www.linkedin.com/profile/view?id=11710667amp;trk=tab_pro
James McAuliffe is a Cloud Solution Architect with CCG Analytics, a Microsoft Gold Partner. He is also a Microsoft Preferred Partner Solutions expert and has been worked with clients of all sizes, from local businesses to Fortune 500 companies. Today’s mix of Big Data and cloud offerings make yesterday’s dream today’s possibility. Let’s talk about it!
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/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: http://linkedin.com/in/tradney
Contact: http://www.timradney.com
Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQL Saturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.
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.
She graduated from the University of Central Florida with MIS and Computer science degrees. She has over a decade of experience in Enterprise Information Technology solutions for several Fortune 500 companies. In depth and applied knowledge of database administration with emphasis on high availability and disaster recovery solutions, security audits, database health checks, capacity planning, resource utilization analysis and enterprise database migrations. She is a big advocate of technical and leadership education in her community. She loves to spend time with her family, friends and dance Latin music.
LinkedIn: https://www.linkedin.com/in/jenunderwood
Contact: http://www.jenunderwood.com
Jen Underwood is a Senior Director at DataRobot. Over the past 20 years, Jen has held worldwide product management roles at Microsoft and served as a technical lead for system implementation firms. She has a unique blend of product management and “hands-on” experience in data warehousing, reporting, visualization, and advanced analytics. In addition to keeping a constant pulse on industry trends, she enjoys digging into oceans of data to solve complex problems with machine learning. Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.
Paul is currently in his fourth year as the ETL Manager for a local CRM software firm. Paul's database work dates back to early database platforms like Dbase III and has worked with every version of SQL Server since SQL 7.0 was introduced. His certifications include MCSE, MCDBA, and MCT. Along with holding a DBA job for the City of Fort Worth, Texas, he also taught T-SQL Intro and Advanced classes to several departments and the North Texas GIS community. In 2006, he founded and ran the Greater Fort Worth SQL Server group for three years, which still continues today. While moving data and other SSIS tasks are Paul's responsibility now, he has also been a Production DBA, worked heavily in the GIS database co
LinkedIn: https://www.linkedin.com/in/harvey-hyman-phd-681a2561
Harvey Hyman is an instructor specializing in MS SQL Server at University of South Florida's MUMA College of Business. His current research areas include software delivery, cloud architecture, IT infrastructure and data analytics/visualization. He has 25+ years of experience in the fields of law, technology, and military service. His most recent professional positions include The Library of Congress, H. Lee Moffitt Cancer Center, and Queens CUNY College. He has previously taught at St. Leo University, New College of Florida, Georgia Southern University and Florida Polytechnic University.
LinkedIn: https://www.linkedin.com/in/rob-hatton-3ab4b845
Contact: http://www.RobertJHatton.com
Rob Hatton is the author of the Business Intelligence Team Handbook. Rob is also a past president of the PASS Business Intelligence User Group here in Tampa. He is a veteran B.I. developer with more than 30 years of database experience and dozens of successful B.I. project deployments.
LinkedIn: https://www.linkedin.com/in/ericawoods
Contact: https://www.mssqltips.com/sqlserverauthor/128/erica-woods/
Erica Woods is the Manager of Contractor and Community Relations at Apex Systems, a national IT Staffing and Services firm. Her focus is on program management, training and development, customer relations, community evangelism and corporate social responsibility, communications, marketing and social media. She has 10 years of IT staffing, an MBA from Loyola University, is an Author at MSSQLTips, and runs a group called Techies for Good.
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: 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.
I think T-SQL is the best thing since sliced bread and I thoroughly enjoy reading and writing T-SQL whenever I can. I’m also doing increasingly advanced PowerShell scripting and ETL development with SSIS, PowerShell, and TSQL.
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/jignesh-patel-7296817
Learning about SQL Server database administration last 7 years
LinkedIn: https://www.linkedin.com/in/ericawoods
Contact: https://www.mssqltips.com/sqlserverauthor/128/erica-woods/
Erica Woods is the Manager of Contractor and Community Relations at Apex Systems, a national IT Staffing and Services firm. Her focus is on program management, training and development, customer relations, community evangelism and corporate social responsibility, communications, marketing and social media. She has 10 years of IT staffing, an MBA from Loyola University, is an Author at MSSQLTips, and runs a group called Techies for Good.
LinkedIn: http://www.linkedin.com/in/craigdallen
Contact: http://www.msftdude.com
Craig Allen is a Dell EMC mSpecialist (Microsoft Specialist). His role as a technical consultant is to help customers in understanding Dell EMC's products for the Microsoft platform. Craig can assist in the initial planning and evaluation of Dell EMC’s Proven Solutions for Microsoft, including requirements gathering, architectural guidance, and integration considerations. Craig is located in Dallas, TX and comes to Dell EMC with 25 years of experience in IT.
LinkedIn: https://www.linkedin.com/in/michaelpantonovich?
Contact: http://sharepointmike.wordpress.com
Michael Antonovich is the assistant director of Web and Technology Services in the Communications Division for Orange County Public Schools in Orlando, FL, where he manages the Internet and intranet infrastructure. He has published seven books, ranging from an Apple II User Guide to Office and SharePoint 2010 User's Guide. His blog has focused mainly on PowerPivot and Power BI, but for the last year Mike has taken a break to pursue some other activities. He hopes to restart his blog later this year focusing more on style and presentation. Mike has used SQL Server since 1998 and, for the past 7 years, has been promoting SSAS, PowerPivot, and Power BI for the masses.
LinkedIn: https://www.linkedin.com/in/adasilvatek/
Adriano da Silva is a Lead Power BI Trainer at Intellinsight LLC and a Principal Consultant at Bright International Corporation a consulting company focused in addressing complex business problems with innovative, effective and robust Solutions in the BI, AI, Big Data, Machine Learning Power BI. He is has years of experience in partnering with businesses leaders to advise and implement technical and process oriented solutions. He is engaged in knowledge sharing initiatives by presenting on conferences, user groups and authoring articles. He is also a lead organizer at the South Florida Power BI (SFPBI) and the Microsoft Data and AI South Florida user groups..
LinkedIn: https://www.linkedin.com/in/michaelpantonovich?
Contact: http://sharepointmike.wordpress.com
Michael Antonovich is the assistant director of Web and Technology Services in the Communications Division for Orange County Public Schools in Orlando, FL, where he manages the Internet and intranet infrastructure. He has published seven books, ranging from an Apple II User Guide to Office and SharePoint 2010 User's Guide. His blog has focused mainly on PowerPivot and Power BI, but for the last year Mike has taken a break to pursue some other activities. He hopes to restart his blog later this year focusing more on style and presentation. Mike has used SQL Server since 1998 and, for the past 7 years, has been promoting SSAS, PowerPivot, and Power BI for the masses.
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: http://www.linkedin.com/in/dale-sullenberger-73295413
Dale lives in Valrico, FL with his wife Connie and son Nathan, three dogs and two cats. While there is some prior user level database experience, Dale has been working with SQL Server in some manner since 1997, and has been in a DBA role for 13 years.
LinkedIn: https://www.linkedin.com/in/jillofalltradeskatie/
Katie Schmidt has many years experience in SQL and started in the SQL PASS community as a professional student in 2011.
LinkedIn: http://www.linkedin.com/in/josechinchilla
Contact: http://www.sqljoe.com
Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.
LinkedIn: https://www.linkedin.com/pub/stephen-muliokela/32/a45/830
I have been a DBA for many years now and currently hold multiple SQL Server certificates. In addition, I am also a Six Sigma Blackbelt.
Currently working for a non profit in the insurance industry that facilitates arbitration between member companies as a BI Tester. Have over 20 years experience as a developer across several industries, manufacturing, education, medical, insurance, and non profit for companies such as Rolls-Royce Aerospace, Ameritech, and IUPUI. I consider myself a full cycle developer for both front and backend by doing the requirements gathering, the designing, the programming and the security and maintenance of the applications. I also analysis data and processes and create reports, dashboards and visuals where needed. My experience crosses several languages and platforms, including SQL, VB, HTML, SQL Server, Oracle, ASP.Net, VB.Net, and reporting.
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/FrankQuintanaDataArchitect
Contact: http://www.businessintelligencematters.us
Doctor Quintana has been involved in optimization and math modeling since the ’80s. He is an IT University professor of Data Science, Databases, Data Mining, and Knowledge Discovery. He is a former head of an RD department. He worked as a research engineer at the Memorial University of Newfoundland. He also worked as a consultant in the role of a technical team leader and software architect for EDS responsible for critical parts of the SDLC for multi-million dollar projects. He is one of the Software Architects that designed and built the "Health and Benefits System for the of the Veteran Affairs of Canada" He is a regular speaker at national and international events In 2004 he started his consulting practice in South and Central Flori
Contact: http://insyncva.com
SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area Interested in pushing the limits of both hardware software and my own brain
LinkedIn: http://www.linkedin.com/in/FrankQuintanaDataArchitect
Contact: http://www.businessintelligencematters.us
Doctor Quintana has been involved in optimization and math modeling since the ’80s. He is an IT University professor of Data Science, Databases, Data Mining, and Knowledge Discovery. He is a former head of an RD department. He worked as a research engineer at the Memorial University of Newfoundland. He also worked as a consultant in the role of a technical team leader and software architect for EDS responsible for critical parts of the SDLC for multi-million dollar projects. He is one of the Software Architects that designed and built the "Health and Benefits System for the of the Veteran Affairs of Canada" He is a regular speaker at national and international events In 2004 he started his consulting practice in South and Central Flori
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.
LinkedIn: https://www.linkedin.com/in/travispage/
Most recently a Senior Database Administrator with Jackson Hewitt, Travis is on the leadership team of the Pinellas SQL User group and an active member of PASS. Passionate about all things related to technology, he maintains a CISSP certification.
LinkedIn: http://www.linkedin.com/in/josechinchilla
Contact: http://www.sqljoe.com
Jose Chinchilla is an experienced data analytics professional with multiple certifications including Microsoft Certified Database Administration (MCSE), Microsoft Certified Data Management and Analytics (MCSE), and Microsoft Certified Trainer (MCT). Jose specializes in Data Warehouse and Data Lake Architecture and Development as the Data Analytics Practice Lead at AgileThought, a full-service custom software and analytics consulting firm based in Tampa, FL. Jose is a book author (SQL 2012 Bible, Professional SQL Server 2012 Administration, Exam Ref 70-767 Implementing a SQL Data Warehouse 2016) and leads the Tampa Bay BI Data Analytics PASS Chapter in Tampa, FL.
Contact: http://dbaworld.blogspot.com/
I have worked as a SQL DBA since 1997. I have managed SQL Server starting from version 6.5 to the latest version. Throughout my career I also worked as Oracle DBA, database architect, lead DBA and managing DBA team.
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.
Jo is an Enrolled Agent and what you might call a Tax Geek. She started in the tax industry as a tax preparer and over the past 30 years worked her way to the role - Director of Tax Resources for Jackson Hewitt. From showing self-employed people all the tax credits and deductions they should consider to solving complicated tax issues for experienced preparers, Jo loves helping everyone with all things tax-related.
LinkedIn: https://www.linkedin.com/in/john-wells-33367a59/
Contact: https://sqlrookieinthe318.wordpress.com/
I'm a DBA at Lamar Advertising in Baton Rouge. I'm a member of the Baton Rouge User Groups Board as well as a co-organizer for the ONLY SQLSaturday that serves Jambalaya for lunch! I started speaking in 2018 and enjoy everything about this powerful community! I enjoy performance tuning, helping developers with best practices and DBATools.
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
John Wang is a Back-end .NET Developer. Currently, his interests are IoT, big compute, services, cloud computing, Powershell and SQL topics. He is an frequent speaker at the various Code Camp, Meetup, IT Pro Camp and SQL Saturday.
Contact: http://insyncva.com
SQL Server DBA, Developer, IT Manager, Business Owner from the Richmond, VA USA Area Interested in pushing the limits of both hardware software and my own brain
Contact: https://sqlandy.com
Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.
LinkedIn: http://www.linkedin.com/in/buckwoody
Contact: http://buckwoody.wordpress.com/
Born helpless, naked, and unable to provide for himself, Buck Woody overcame these amazing handicaps to become a software developer, data professional, teacher, and a productive invertebrate member of society.
The following is a list of sponsors that helped fund the event.