Event Location:
2112 N. 15th St
Tampa, Florida
Abstract:
Have you ever been wrought with end user complaints of database performance issues only to open your tools that show only live performance or limited historical performance and find no answers? After being bit by this many times, I developed my own eye in the sky to monitor CPU Physical IO at the database, user and application levels. This solution logs data continuously and parses it into an Analysis Services cube which can be queried by Excel. No need to requisition funds for 3rd party tools. You can do this with the tools you have and I’ll give you the scripts to get started. Using these tools I have been able to find needles in haystacks and effectively communicate the nature of the problems to people at all levels.
Speaker(s): Brian Flynn,
Abstract:
SQL Server Reporting Services is a fundamental part of Microsoft’s Business Intelligence suite of products which as its name suggests provides a centralized robust reporting solution for organizations. Using a familiar development environment we can create static and interactive reports that can be delivered to consumers in a variety of ways. In this deep dive session, I will cover topics like: - What is reporting services and what can it be used for? - Features added in 2008 R2 - Architectural Overview - Demonstrations to cover the entire process of developing, deploying and rendering reports using the built in Report Manager and URL Access. ** This session is SQLSaturday favorite and is always packed full. Don't miss it **
Speaker(s): Brian K McDonald,
Abstract:
The more you know about SQL Server the more you understand how it works. SQL Server is a product we use every day, and most of us know the big concepts. At the 10,000 foot view we know what Databases, Tables, and Columns are. But what makes up those Databases, Tables, and Columns. What are Records, Pages, Extents, and Allocation Units? What are Full, Simple, and Bulk-Logged Recovery? What are the differences between Full, Transaction Log, Differential, or Filegroup backups? What is a Peicemeal Restore? This is an introduction to these concepts using SQL 2012. In this session you will learn about the internal Structure, Recovery Models, and Backups and be better prepared to for Future Learning and Managing SQL!
Speaker(s): Bradley Ball,
Abstract:
You’ve heard it said, “If you have to do it twice, automate it.” Cut the learning curve and get a real handle on this powerful automation tool. This session walks you through a dozen scripts to simplify and easily automate time-consuming and tedious elements of your day to day job. This isn’t stuff you’ll use SOMEDAY, these are scripts you can use when you get home tonight. Harness the power of Power Shell to easily find Servers short on space. Script out tables and constraints across all of your databases at once. Backup databases and restore them to a different environment. These tricks and many others will allow PowerShell to simplify your job like no other tool.
Speaker(s): Aaron Nelson,
Abstract:
Virtualization has been growing in popularity for years and changes in Windows Server 2012 and ESX 5 make it so that even high end workloads that demand large amounts of memory, significant I/O, and lots of processing power can be virtualized. With over 8 years of experience virtualizing SQL Server in production, SQL Server MVP Jonathan Kehayias knows what it takes to successfully virtualize SQL Server for production workloads. This session will explain the features that make virtualizing SQL Server possible using both VMware and Hyper-V, and will explain the most common problems businesses encounter trying to virtualize SQL Server.
Speaker(s): Jonathan Kehayias,
Abstract:
Have you ever thought about speaking at a user group or SQLSaturday, but weren't quite sure how to get started? If so, this session is for you! Technical speaking is loads of fun, great for your career, and you get to hang out with some terrific people. This session will provide the tools necessary to get your first session off the ground, and prep you to be a great speaker. Attend this session and you'll be able to: * Identify your topic and build a killer abstract for it, * Design and build the presentation, and * Prepare and deliver your first session
Speaker(s): Eddie Wuerch,
Abstract:
You’ve got your Analysis Services cube created, and deployed in production. However, you notice that every night, the cube is taking longer and longer to process, and users are starting to complain about their data not being ready when they arrive in the morning. If you’ve found yourself in this situation, or want to avoid being in it in the first place, come to this session. We’ll cover how to benchmark processing performance, track down bottlenecks, and how to tune things to get the best performance for processing your cube.
Speaker(s): John Welch,
Abstract:
Managing data in ever-growing transaction and history tables can be challenging. Activities with large chunks of data such as moving data to archive tables, batch-importing many rows, or defragging an entire table when only the active portion changes introduces heavy I/O and blocking. Table partitioning seamlessly solves a host of headaches with minimal effort. Ever wanted to truncate or defrag part of a table, or insert an entire staging table of data into another table in milliseconds instead of hours? Come see what partitioning can provide for you.
Speaker(s): Eddie Wuerch,
Abstract:
I’ll be covering some of the different way we can use PowerShell to extend our T-SQL scripting. This session will include a mix of using SMO, .NET classes, and SQLPS to help you understand the power for new scripting technology. At the end we’ll be creating a solution that put together all this techniques.
Speaker(s): Maximo Trinidad,
Abstract:
See how to build your first Windows 8 app. We will use what I learned when creating the app: .NET Gurus Can Cook, which contains recipes from famous folks in the software industry such as Scott Hanselman and Mary Jo Foley. Join ComponentOne Developer Evangelist and former Microsoft Developer Evangelist, Russ Fustino in this session and learn the new programming paradigm for creating Windows 8 style apps. You will see how to build an application that incorporates many of the key characteristics of a great Windows 8 style app, including: * A modern UI user experience that leverages the signature Windows 8 controls such as GridView, ListView, FlipView, AppBar, Semantic Zoom and other Windows 8 controls. * Get data locally or from azu
Speaker(s): Russell Fustino,
Abstract:
In this session Dmitri talks about locking in Microsoft SQL Server. He covers various lock types that exist in the product and explains how transaction isolation levels affect locking behavior. Dmitri also discusses why we have blocking in the systems and how to troubleshoot blocking problems and deadlocks. This is PowerPoint-free session. Only Management Studio, T-SQL Code and bag of candies are in use.
Speaker(s): Dmitri Korotkevitch,
Abstract:
“What does a “Data Scientist” or a data professional that works in larger sets of data need to know? Buck Woody, a Senior Technical Professional at Microsoft, will explain a few of the major topics you need to be familiar with to enter this new level of working with data. Buck also assisted in the design of the Data Science program at the University of Washington, and teaches a database certification course there. You’ll learn which areas to study, the types of problem areas this knowledge solves, and how to develop a study plan, along with resources to learn more.
Speaker(s): Buck Woody,
Abstract:
SQL Server 2012 introduced several new features and tools that have sparked the self-service BI revolution. Learn how PowerPivot and the new ad-hoc dashboarding tool called PowerView are revolutionizing the way Business Intelligence is being delivered and consumed by the end users themselves. In this session you will also understand what is the role of IT in this new self-service paradox.
Speaker(s): Jose Chinchilla,
Abstract:
This session focuses on error handling in SQL Server Integration Services 2012. Different techniques and strategies will be introduced for error handling in control flow, data flow, and script tasks as well as how to dynamically handle errors.
Speaker(s): David Dye,
Abstract:
For anyone doing serious work with PowerPivot, you know that you must sometimes create additional columns calculated from the data in your existing data sources. If your data source is SQL Server, you could do this in SQL directly by just connecting to a custom view. However, for most other data sources (and for those users without development access to SQL Server) the best alternative is building expressions in PowerPivot to define new columns. DAX is also used to join tables on multiple columns and to create calculated measures. This session will explore DAX functions and expressions and how they differ from Excel expressions. We will even show how to use DAX expressions to create new measures.
Speaker(s): Michael Antonovich,
Abstract:
Everything you wanted to know about join optimization but were afraid to ask... Join types, indexing, and how the optimizer makes its selections.
Speaker(s): Jeffrey Garbus,
Abstract:
In a world...where DBAs are blamed, mistreated, and overworked...one man...WILL. GET. EVEN. In this entertaining and impractical follow-up to the entertaining and impractical Revenge: The SQL, Rob Volk will show you even more impractical but oh-so-tempting ways to get back at those who abuse SQL Server and make you clean it up. Techniques will cover: preventing sa use, preventing ad-hoc SQL, cursors and missing WHERE clauses, and the ever-popular trigger mayhem. And if you stay for the after-credits sequence you may encounter the evil twins, duplicate primary keys!
Speaker(s): Rob Volk,
Abstract:
Report Builder is a free and a powerful tool providing familiar Microsoft Office environment and targeted by Microsoft to business users. See for yourself if you as a developer would like to use this product or convince your power users to give it a try. In this session we'll look at differences between BIDS Report Designer and Report Builder. Then we'll walk through creating some reports to highlight Report Builder features and make a general overview of Report Builder benefits. Also we'll touch a bit on Report Manager that provides a user interface to a report server.
Speaker(s): Yelena Pavlyuk,
Abstract:
In this session we'll use SSIS in a real-world example to automate processes. We'll look at using Variables and Expressions. We'll look at several items in the Control Flow that can be used to automate a lot of integration processes. We'll import data from MS Excel, save it to a database, export aggregated data into a different format, archive the data source, zip the data source, encrypt the exported file, and submit it via SFTP or email.
Speaker(s): Robert Biddle,
Abstract:
SQL Server Extended Events can be used to gather a wide range of performance information, and in troubleshooting in SQL Server. Extended Events use less system resources and provide better information than SQL Profiler and they allow for correlation of SQL Server event data along side of OS or Application event data. This presentation will explore what Extended Events are, how to set them up and use them in several case studies.
Speaker(s): Janis Griffin,
Abstract:
We've all been here before: - You're the DBA and it seems like every day someone is telling you about some other server you never knew existed but you're responsible for - You're the consultant and you want to know what SQL Servers your new client has but they can't tell you - You're the IT Manager and your CTO asks you for an inventory of every SQL Server running in production How do you go about figuring out where the SQL Servers are, how they're set up, and what they're doing? This session will give you the answer by demonstrating how to use PowerShell and SQL Server Management Objects (SMO) to discover and document all of your instances - no PowerShell experience required!
Speaker(s): Kendal Van Dyke,
Abstract:
While DQS in SQL Server 2012 is a powerful tool for enforcing data quality through business rules, often times the time and complexity it takes to set-up is overkill for more mundane common problems. This session will focus on implementing a business rules engine in a SSIS custom component. A flexible, metadata-driven solution will be discussed including considerations for implementation as a custom SSIS component.
Speaker(s): Christopher Price,
Abstract:
In this session Dmitri continues to talk about locking in Microsoft SQL Server. He covers more advanced concepts related to locking such as Schema Locks, Application Locks, Lock Escalation and Optimistic Isolation Levels and discusses how to choose the right transaction strategy for the system. This is PowerPoint-free session. Only Management Studio, T-SQL Code and bag of candies are in use. Assuming there are still some candies left :)
Speaker(s): Dmitri Korotkevitch,
Abstract:
What happens before the flowchart
Speaker(s): Arvin Meyer,
Abstract:
SQL Server Database Tools (SSDT) provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. SSDT contains visual tools to enable Database Developers or DBAs to: • Develop tables, views, stored procedures, functions, etc., both live and offline. • Develop and manage partitions, compression, and other advanced features. • Refactor and Rename objects • Maintain database in source control • Perform schema comparisons • Easily deploy database schema updates without having to write complex alter scripts.
Speaker(s): James McAuliffe,
Abstract:
Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start? In this session we will walk through the process of creating a disaster recovery plan for your organization, the HA and DR options within SQL Server, and finally a demonstration of the new Availability Groups feature in SQL Server 2012 and see them in practice.
Speaker(s): Joseph D'Antoni,
Abstract:
Head starting to explode from all the technical information you’re absorbing? Come spend a session with us while we play games with Reporting Services…literally! Come watch as Stacia Misner and a special guest introduce you to some word play, all wrapped up in SQL Server Reporting Services. She'll push the limits with what can be built in SSRS and show you how to have fun while doing it. Board games and SQL…who could ask for more?
Speaker(s): Stacia Varga,
Abstract:
Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session
Speaker(s): Jeffrey Garbus,
Abstract:
The term "big data" dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.
Speaker(s): Stacia Varga,
Abstract:
Power View provides intuitive ad-hoc reporting for business users such as data analysts, business decision makers, and information workers. They can easily create and interact with views of data from tabular models based on Power Pivot workbooks or tabular models deployed to SSAS instances. In this session will dive in to what is needed to create Power View reports and an overview of the reporting enhancements in the new version of SQL Server.
Speaker(s): Guillermo Caicedo,
Abstract:
Wondering how all that big data is going to be moved around? Or how you are going to move any of it into your SQL Server environment? Come to this session, and learn about some of the familiar and not so similar tools you can use for moving big data. We’ll compare the options, discuss how they can work with your existing Microsoft technologies, and provide some guidance on when to use each of the tools.
Speaker(s): John Welch,
Abstract:
Plan the work and work the plan. Are you doing that when it comes to your professional development? Few of us have a formal approach to professional development and that usually means it gets pushed down the list as other things in life happen. This session is designed to get you thinking about all aspects of your career and from there moves into a discussion about time and money - how much of each are you willing to spend to get where you want to go? At the end of this presentation you'll be ready for spend a couple quiet hours charting all the things you want to do, and then figuring out which ones you really want to do.
Speaker(s): Andy Warren,
Abstract:
As cloud computing becomes more popular and cloud-based solutions the norm rather than the fringe, the need to efficiently migrate your database is crucial. This demo-filled session will discuss the tips and tricks, methods and strategies for migrating your on-premises SQL Server databases to Windows Azure SQL Database, AKA SQL Azure. Focusing primarily on SQL Server Data Tools and the DAC Framework, this session will focus on how these tools can make you a kung-fu migration master.
Speaker(s): Scott Klein,
Abstract:
The Business Intelligence adoption over the last few years has grown dramatically to the point where organizations require business insights, not only from what has already happened (typical data warehousing), but from real-time performance and how will the future be, based on the business and market trends. In this session we will explore and demonstrate the main decision-making capabilities in SQL Server 2012 using Analysis Services, Data Mining and the power behind PowerPivot and PowerView hosted within Excel.
Speaker(s): Jose L. Rivera,
Abstract:
This session will show you how a better understanding of how the Query Optimizer works can help you to improve the performance of your queries. I will show you the top 10 Query Optimizer topics that can give you the most benefit by focusing both on concepts and practical solutions. Several areas of the query processor will be covered, everything from troubleshooting query performance problems and identifying what information the Query Optimizer needs to do a better job to the extreme cases where, because of the its limitations, the Query Optimizer may not give you a good plan and you may need to take a different approach.
Speaker(s): Benjamin Nevarez,
Abstract:
I'll describe how I've used the Separation of Duties Framework and a Privileged Identity Management suite to minimize the permissions needed by DBAs to do routine work. I'll review the Separation of Duties Framework and the process I took to arrive at a workable solution that will give DBAs the access they need to maintain the server but not be able to view user data.
Speaker(s): Ronald Dameron,
Abstract:
Many DBAs don't realize it, but a plethora of free tools are available that make managing SQL Server easier and less time consuming. This session will take a look at a number of these tools and how they can simplify your life as a DBA. Whether you want to analyze trace data, query plans, or performance counter, or maybe just reduce the possibility of having one of those dreaded "Oops, that was production" moments as a DBA, this session will show you how, and the best part is it's all free.
Speaker(s): Jonathan Kehayias,
Abstract:
Have you ever read a job description (or needed to hire one yourself) asking specifically for a “BI DBA” and wondered what exactly that means? In this session we will discuss the expectations of the role, what the various pieces of the Microsoft BI stack are and what administrative components and gotchas are involved for each one. If you need to unveil the mysteries and intricacies of administrating an SSIS, SSAS and/or SSRS environment from a DBA perspective then check this session out!
Speaker(s): Jorge Segarra,
Abstract:
Exploring your data has never been easier with Power View included in SQL Server 2012. Learn how to quickly analyze and discover new trends in your information by using the intuitive, easy to use, and business-friendly tool. This session will not walk through installation of the tool, but will instead describe the different visualizations provided and how to use each one.
Speaker(s): Jessica Moss,
Abstract:
Learn how to create metadata driven ssis using the .net libraries. Learn how to traverse and extract ssis metadata information across servers. Build ssis packages dynamically for generic ETL solutions.
Speaker(s): Jorge Novo,
Abstract:
In this session I will walk you through a complete SSIS package from scratch to finish. The package will hit some of the key SSIS components in the control and data flow and along the way I will emphasize best practices that should always be followed. We will also cover variables and setting expressions on the variables to make the package the dynamic.
Speaker(s): Mitchell Pearson,
Abstract:
With the introduction of SQL Server 2012 data developers have new ways to interact with their databases. This session will review the powerful new analytic windows functions, new ways to generate numeric sequences and new ways to page the results of our queries. Other features that will be discussed are improvements in error handling and new parsing and concatenating features.
Speaker(s): Richie Rump,
Abstract:
The MDX query language is a powerful tool for extracting data from your cube but can often seem confusing and overwhelming to the untrained eye. But have no fear! It's easier than you might think. In this session, attendees will learn the basic MDX query syntax, how to navigate a hierarchy, how to create dynamic time calculations, and how to add calculations to your cube.
Speaker(s): Dustin Ryan,
Abstract:
In this session we will compare SQL Server's native backups with the compressed backups available in SQL Server 2008 Enterprise, Red Gate's SQL Backup Pro v7, and the various configurations of Red Gate's SQL HyperBac tools. We will compare them with real world scenarios so that you can decide which tool is the best for your scenarios.
Speaker(s): Ed Watson,
Abstract:
The plan cache in SQL Server 2005 and 2008 has a wealth of information available to assist DBA's in performance tuning. This session will show how to query the plan cache to find plan information and then how to parse the XML plans contained in the cache to identify missing indexes by query, high cost parallel queries with high usage counts, implicit column conversions caused by data type mismatches, and other interesting information about how queries have executed in the system.
Speaker(s): Jonathan Kehayias,
Abstract:
This session will be basic reporting of the different microsoft products excel, access, ssrs. In excel we will connect it to database and create simple report. In access we are going to connect to word and make basic report. In visual studio we are going to make simple ssrs report. This will be simple overview of different ways to create reports. Let's get creative and start creating some reports.
Speaker(s): Brook Ranne,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Contact: http://aka.ms/sqlscott
Scott Klein is a senior consultant with SQL Solutions Group with over two decades of experience working with Microsoft SQL Server. Prior to SSG, Scott spent almost 10 years at Microsoft, traveling the globe as a technical evangelist training and speaking about SQL Server and Microsoft’s Azure data services. Scott’s recent focus has been on advanced analytics, including big data and IoT, providing real-world training to help bring intelligence to your data. Scott has authored several books focusing on data and data analytics. Scott is continuously striving and looking for ways to help developers and companies grok the wonderful world of data.
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.
Contact: https://www.sqlskills.com/blogs/jonathan
Jonathan Kehayias is a Principal Consultant and trainer with SQLskills, and has been recognized as a Microsoft Data Platform MVP for over 10 years, and was the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification. He has presented at numerous conferences including PASS Summit and SQL Rally, SQLBits, VMware Open Forum, SQLintersection, and multiple SQLSaturdays around the world. As a performance tuning and high availability expert for SQL Server, Jonathan has architected and implemented complex systems and solutions for some of the worlds most challenging workloads.
I have been report developer for 6 plus years now. I enjoy using different Microsoft products to create different reports. In my career I have created reports in excel, access, word, ssrs. I have been volunteering and working SQLSaturdays for years. I enjoy meeting people and learning about SQL Server.
LinkedIn: http://www.linkedin.com/in/johncwelch/
Contact: http://agilebi.com/jwelch
John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.
Brian Flynn has a Computer Science and Math degree from Saint Louis University and has been working in IT for 20 years. He's served in many roles, both technical and managerial. Brian encourages IT pros to diversify skillsets to build more comprehensive big picture understandings that businesses care about.
LinkedIn: https://www.linkedin.com/profile/view?id=176471amp;trk=nav_responsive_tab_profile
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses. In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems. His latest book is "Transact SQL the Definitive Guide."
LinkedIn: http://linkedin.com/in/richierump
Contact: http://jorriss.net
Richie Rump is a dataveloper with Brent Ozar Unlimited, where he writes code to solve data problems. He developed statisticsparser.com and sp_DataProfile, two tools that help data professionals tune SQL Server. Richie is also the co-host of the Away From The Keyboard Podcast and founded dotNet Miami, a community focused on enterprise development with .NET. He holds the Project Management Professional (PMP) and Certified Scrum Master (CSM) certifications as well as certifications in various Microsoft development technologies. He can be found on Twitter at @Jorriss or at http://jorriss.com.
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/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 SQLSaturdays, SSUG's, SQL Rally, DevConnections, SQLBits, SQL Live 360, and the PASS Summit. Bradley can be found blogging on http://www.SQLBalls.com
LinkedIn: http://www.linkedin.com/in/eddiewuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
LinkedIn: http://www.linkedin.com/in/johncwelch/
Contact: http://agilebi.com/jwelch
John Welch joined SentryOne in spring 2018 as VP of Engineering with the acquisition by SentryOne of the software division of Pragmatic Works. John leads the development of a suite of products that make developing, managing, and documenting data solutions easier. John has been successfully delivering IT solutions to business problems since 1994, and has been focused on business intelligence and data warehousing technologies since 2001. He is a Microsoft Most Valued Professional (MVP), and a frequent presenter on SQL Server and data topics. He also contributes to several open source projects and community initiatives targeted toward making data professionals work more productive.
LinkedIn: http://www.linkedin.com/in/kendalvandyke
Contact: http://www.kendalvandyke.com
Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.
Contact: http://www.sqlbn.com
Jose L is a SQL Server MCITP and MCT with over 10 years of experience developing Business Intelligence solutions using SQL Server technologies, among others. He currently works as Consultant at Nagnoi, Inc. as well as College professor at University of Phoenix. In addition, he shares his knowledge and perspectives as PRPASS Vice President and Community Leader, Co-Leader for the Azure and Global Spanish virtual chapters and frequent speaker at user groups and SQLSaturday events, among others.
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.
Contact: https://www.sqlskills.com/blogs/jonathan
Jonathan Kehayias is a Principal Consultant and trainer with SQLskills, and has been recognized as a Microsoft Data Platform MVP for over 10 years, and was the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification. He has presented at numerous conferences including PASS Summit and SQL Rally, SQLBits, VMware Open Forum, SQLintersection, and multiple SQLSaturdays around the world. As a performance tuning and high availability expert for SQL Server, Jonathan has architected and implemented complex systems and solutions for some of the worlds most challenging workloads.
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning Optimization”, “Inside the SQL Server Query Optimizer” and has contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits.
LinkedIn: https://www.linkedin.com/profile/view?id=176471amp;trk=nav_responsive_tab_profile
Contact: http://mssqlperformance.blogspot.com/
Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses. In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems. His latest book is "Transact SQL the Definitive Guide."
Brian K. McDonald, MCDBA, MCSD is an Independent Business Intelligence consultant. Brian has served in many roles over his 14+ years in the IT industry. Brian was the lead author on Pro SQL Server 2012 Reporting Services (Apress) book, has written featured articles for industry leading websites and blogs on SQLServerCentral, SQLServerPedia and BIDN. Brian is an active member of the community and has presented at User groups, Code Camps, SQL Rally and SQLSaturday events across the South East.
Lena works at Pinellas County School Board in St.Petersburg, FL. It is the largest employer in Pinellas County with 17,000 staff who serve more than 100,000 pre-K through 12th-grade students. Lena has been working with SQL Server for more than 8 years, she is SQLSaturdays volunteer and speaker.
LinkedIn: http://www.linkedin.com/pub/robert-biddle/8/266/630
Contact: http://robert-biddle.com
Robert Biddle is a Data Architect for Hilton Grand Vacations in Orlando, Florida. He has over a decade of experience working with SQL Server in a variety of roles. He has a Bachelor’s degree in Computer Science from the University of Delaware and also has MCITP certifications for Database Administration and Database Development. In recent years, Robert has specialized himself working with data integration, ETL, and data warehousing. He is a frequent speaker at SQLSaturday and Code Camp events.
Contact: http://www.mitchellpearson.com
Mitchell is an experienced Business Intelligence Consultant and Trainer at Pragmatic Works and is currently the content training manager leading content development and delivery of training courses. Mitchell is experienced developing BI solutions using the full Microsoft BI Stack (SSRS, SSIS, and SSAS) as well as Microsoft Power BI. He is also very active in the community speaking at SQLSaturday events, local user groups, and online virtual events. Mitchell also blogs at mitchellpearson.com.
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/sqldusty
Contact: http://sqldusty.com
Dustin Ryan is a senior BI consultant and trainer with Pragmatic Works in Jacksonville, FL. Dustin specializes in delivering quality enterprise-level business intelligence solutions to clients using SSRS, SSIS, SSAS, SharePoint, and Power BI. Dustin has authored and contributed to SQL Server books. You can find Dustin speaking at events such as SQLSaturday, Code Camp, and online webinars.
LinkedIn: http://www.linkedin.com/pub/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.
Contact: https://www.sqlskills.com/blogs/jonathan
Jonathan Kehayias is a Principal Consultant and trainer with SQLskills, and has been recognized as a Microsoft Data Platform MVP for over 10 years, and was the youngest person ever to achieve the Microsoft Certified Master – SQL Server certification. He has presented at numerous conferences including PASS Summit and SQL Rally, SQLBits, VMware Open Forum, SQLintersection, and multiple SQLSaturdays around the world. As a performance tuning and high availability expert for SQL Server, Jonathan has architected and implemented complex systems and solutions for some of the worlds most challenging workloads.
LinkedIn: http://www.linkedin.com/profile/view?id=3997984amp;trk=hb_tab_pro_top
Contact: http://joeydantoni.com
Joseph D'Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book "Introducing SQL Server 2016”.
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 using automation, and dynamic programming for SSIS. Currently Jorge is working in the programming and development of Data Master Service for the organization.
David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa
Contact: http://www.clubfarpoint.com/Forums/blogs/russells_blog/
Russ Fustino heads up Developer Evangelism at ComponentOne as a Senior Developer Evangelist. He is also a highly experienced Windows Phone 7 software developer with a passion for conveying relevant, current, and future software development technologies and tools through live seminars, teaching, and internet video productions. Russ has a new innovative blog and interview video series with influentials, about current technology, ComponentOne products and developer community called ‘Russ Cam’!
LinkedIn: http://www.linkedin.com/in/jdsegarra
Contact: http://sqlchicken.com
Jorge Segarra is a senior consultant for Microsoft (Premier Support for Developers) and a former SQL Server MVP. Jorge has co-authored titles including "SQL 2008 Pro Policy-Based Management" and "SQL Server 2012 Bible" .
LinkedIn: https://www.linkedin.com/in/sqlvariant
Contact: http://sqlvariant.com/
Aaron Nelson is an author, public speaker, blogger, and leader in the community. He has over 15 years of experience in architecture, Business Intelligence, development, and performance tuning of SQL Server. Aaron has received many certifications and is a six time winner of the Microsoft MVP Award. Aaron leads the PowerShell Virtual Group of PASS (SQLPS.io), is a board member of PowerShell.org, and is a volunteer at his PASS Local Group, AtlantaMDF.
LinkedIn: http://www.linkedin.com/in/staciavarga
Contact: http://blog.datainspirations.com
Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, Stacia has provided consulting and education services for Microsoft's Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.
Contact: http://www.nagnoi.com/
Guillermo is an active member and alumni of the Professional Association of SQL Server (PASS) and PRPASS. He currently works as a Consultant at Nagnoi, Inc. and has more than six years of experience as Business Intelligence and applications developer. He is a Microsoft Certified Professional in Microsoft SharePoint 2010 and SQL Server 2012. His experiences include Data Warehousing implementations, ETL development using SSIS, metadata modeling and reporting using SSAS, Cognos and SSRS respectivel
Contact: http://www.jessicammoss.com
Jessica M. Moss is a well-known architect, speaker, author, and Microsoft MVP of SQL Server Business Intelligence. Jessica#39;s expertise includes data warehouse modeling, Integration Services ETL, Analysis Services semantic modeling, Reporting Services report design, and helping customers across industries successfully implement and enhance their BI solutions. She enjoys sharing her knowledge with the SQL community and has co-authored numerous technical books.
Contact: http://www.datastrat.com
A Microsoft Certified Professional and a 15 time awarded Microsoft MVP, Arvin writes freelance technology articles, is an author of a book on Access, leads the Access, Office, and Security, Special Interest Groups, and is the President Emeritus of the Central Florida Computer Society. Arvin works as a consultant, and is Chief Database Architect of a software technology firm in Orlando, FL.
Contact: http://sharepointmike.wordpress.com
Mike Antonovich is the Asst Director Web Services for OCPS in Orlando, FL where he manages the SharePoint portal team. He is also responsible for multiple .Net custom applications used throughout the district. In June of 2010, he published his 7th book: Office and SharePoint 2010 User's Guide. Mike has been using SQL Server since 1998 and SharePoint since 2007. He recently spoke at the PASS Summit in November 2012 on PowerPivot.
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.
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 SQLSaturday Tampa, Orlando, South Florida, and the Tampa and Orlando SQL User groups. He has recently earned the Competent Communicator Award from Toastmasters International. He is most active on Twitter as @RonDBA.
LinkedIn: http://www.linkedin.com/in/eddiewuerch
Contact: http://www.indydba.com
Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.
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.
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: http://www.linkedin.com/in/staciavarga
Contact: http://blog.datainspirations.com
Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology. Since 2000, Stacia has provided consulting and education services for Microsoft's Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.
LinkedIn: https://www.linkedin.com/in/rob-volk-134ba81
Contact: http://weblogs.sqlteam.com/robv/
Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.
Contact: http://bluewatersql.wordpress.com/
Chris Price is a Sr. BI Consultant with Pragmatic Works based in Tampa, FL. He has a B.S. in MIS and a MBA, both from the Univ. of South Florida. He previously worked as a software architect before being bitten by the BI bug. His current focus is on ETL and Data Integration, Data Quality and MDM, SSAS, SharePoint and Big Data. He regularly speaks at SQLSaturdays, Code Camps and other community events. He has authored multiple whitepapers and books and served as technical editor.
LinkedIn: http://www.linkedin.com/in/watsoned
Contact: http://sqlgator.com
Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQLSaturday Atlanta, Atlanta BI, and Pensacola.
The following is a list of sponsors that helped fund the event.