SQLSaturday #248 - Tampa BI 2013

Event Date: 11/09/2013 00:00:00

Event Location:

  • University of South Florida (USF), College of Business Bldg.
  • 4202 E Fowler Ave
  • Tampa, Florida

PDF of Schedule

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

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


Sessions

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


Title: Introducing Cube World To Users From Flat Table Land

Abstract: This session explores the tabular approach to building cubes in SQL Server Analysis Services 2012 for those DBAs and developers who are more comfortable working with relational databases than cubes. Starting with a ‘normal’ relational database, the attendee will learn how to build a basic model by loading data from several data sources, establish relations between these data sources, define measures and dimensions, build hierarchies, create KPIs and deploy functional cubes that can be used to answer management’s questions about what is really going on with their data. For users already familiar with PowerPivot, this session provides a good transition into the world of SSAS as both use essentially the same techniques.

Speaker(s):

  • Michael Antonovich

Track and Room: (2) Analysis - N/A


Title: Design and Implement BI like Edison!

Abstract: As the most prolific inventor in American history, Thomas Edison was a master of “Best Practices!” Edison’s creations were not just novel and commercially successful, but many launched entire new industries including electric light and power, sound recording, motion pictures and industrial cement and concrete manufacture. At the heart of Edison’s remarkable record of innovation was his categorization of the innovation process into “competencies,” or bundles of skills supporting the achievement of success in a particular area of endeavor. In this session, we will look at ways that we can use many of these broad success secrets to bring powerful tools and strategies to the recurring implementation of business intelligence.

Speaker(s):

  • William E Pearson III

Track and Room: (2) Analysis - N/A


Title: Forget “Big Data” ! How About “Smart Data” Instead?

Abstract: There’s no denying that Big Data is here to stay, and that society will ultimately be transformed in many ways as a result of its impact. But while Big Data might be ‘the next big thing’, most companies, no matter what size, would probably do better to focus first on fully utilizing non-big-data BI to address the core challenges of any company, which include: leadership, management, and motivation. In this presentation, I’ll be reviewing three uses of “traditional BI” that are often under-employed and which can be transformational for a business in their own right. For this, I’ll be sharing examples, practical tips, and stories from my own experiences at my organization, coupon-giant Valpak.

Speaker(s):

  • Thomas Spetnagel

Track and Room: (4) Big Data - N/A


Title: SSIS 2012

Abstract: Microsoft revamped SSIS with the 2012 release. Attend this session to learn about the new project deployment model, parameters, the SSIS catalog and more!

Speaker(s):

  • Kathi Kellenberger

Track and Room: (1) ETL - N/A


Title: Heterogeneous Data Environments

Abstract: Analyzing data across multiple sources for a 360 degree view of your business

Not only is the size of data growing, but so are the number of data sources and the number of requests from the business to analyze it. Today’s data professionals are now required to access a myriad of relational and non-relational sources, mash it up together and provide in-depth reports and visualizations, and usually without a lot of time. In this session, product evangelist Peter Evans will show you how Toad can dramatically reduce time spent on accessing relational and non-relational data, simplify data integration, and how to collaborate with other users for a 360 degree view of your business.

Speaker(s):

  • Peter Evans

Track and Room: (5) DBA/Misc - N/A


Title: Report With Power: New Data Tools, New Insights

Abstract: By now, we have heard a lot about the new Power* tools. PowerPivot, PowerView, PowerQuery and the tabular data model. But what does it all mean? How can you put these tools to work for you, where you live and work every day? This session provides examples of powerfully combining data from lots of different sources in creative ways that were simply not possible in the past. This session will walk you through real life scenarios, using these tools to fill in missing and move from “if only” to “what if”, and valuable insight…

Speaker(s):

  • James McAuliffe

Track and Room: (3) Presentation - N/A


Title: PCI For The SQLDBA

Abstract: Are you storing or planning to store credit card numbers? If so, you need to learn all you can about the requirements for PCI compliance. We’ll cover how PCI works from the requirements to the final audit, and eveything in between that you’ll need to know something about. We’ll talk about encryption, key management, logging, alerting, administration access, granular permissions, tokenization, and as much more as we can fit into an hour. It’s a complex topic, but that just makes it more interesting!

Speaker(s):

  • Andy Warren

Track and Room: (5) DBA/Misc - N/A


Title: Moving Big Data - SSIS, Pig, and Sqoop

Abstract: Wondering about Hadoop, and 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

Track and Room: (4) Big Data - N/A


Title: Tuning Analysis Services Processing Performance

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

Track and Room: (2) Analysis - N/A


Title: Getting Started with HDInsight

Abstract: Let’s get rid of the barriers to getting started with Hadoop. in this session we will walk through how to setup a HDInsight service cluster in the cloud and how to set up a HDP cluster in VMs.

Speaker(s):

  • Brian Mitchell

Track and Room: (4) Big Data - N/A


Title: SQL Server Performance Tuning

Abstract: In this session, we will explore the basic architecture of SQL Server including how data is stored and accessed within SQL Server. Next, we will dive into the practical by discussing how to identify performance bottlenecks at a system level and then again at the query level and we will wrap things up by walking through the tuning of a specific problematic query.

Speaker(s):

  • Steve Abraham

Track and Room: (5) DBA/Misc - N/A


Title: When Reporting is More than Reporting

Abstract: Is your day full of repetitive tasks that you would like to hand off? Maybe you can push them back to the source. SSRS can empower you to empower your users. By pass the UI team and do it yourself. We will discuss options and considerations you should know about to create a report process to populate data your users are asking you to populate with validation and defaults.

Speaker(s):

  • Pam Shaw

Track and Room: (3) Presentation - N/A


Title: Secrets of Enterprise Data Mining

Abstract: If you have a SQL Server license (Standard or higher) then you already have the ability to start data mining. In this new presentation, you will see how to scale up data mining from the free Excel 2013 add-in to production use. Aimed at beginning to intermediate data miners, this presentation will show how mining models move from development to production. We will use SQL Server 2012 tools including SSMS, SSIS, and SSDT.

Speaker(s):

  • Mark Tabladillo

Track and Room: (2) Analysis - N/A


Title: HDInsight: What’s all the Hadoopla about Big Data

Abstract: Are you keeping up with buzz around big data? Are you wondering what opportunities and changes big data may bring to your data warehouse architecture? In this session you will learn about HDinsight, Microsfot’s big data platform, capabilities and tool set. We will address common myths and develop recommendations to successfully bring big data capabilities to your data warehouse and business intelligence implementation. After this presentation you will better prepared to make architectural and functional design decisions when considering Microsoft HDInsight as part of your solution.

Speaker(s):

  • Jason Virtue

Track and Room: (4) Big Data - N/A


Title: Big Data Microsoft SQL Server in the Real World

Abstract: Let’s go beyond the hype of Big Data and the Microsoft story around Big Data and talk about a real-world actual implementations of Big Data Big Data Analytics solutions. In this session, I’ll talk about implementing SQL Server, Big Data Analytics engines, Hadoop and Big Data visualizations tools using specifics of a customer implementation which I was responsible for.

Speaker(s):

  • Mark Kromer

Track and Room: (4) Big Data - N/A


Title: Introduction to Business Intelligence

Abstract: In this session Mike shows how a complete BI solution is built from the transactional system to the finished Cube and reports. He will go over the steps involved in planning a BI solution and how to make your project successful. You will get an understanding of the roles SSIS, SSAS, and SSRS play in building a BI solution.

Speaker(s):

  • Mike Davis

Track and Room: (2) Analysis - N/A


Title: A Matter of Time… In SSAS

Abstract: Ever as yourself what time of day it is? Like what time of day does our support desk get the most cases? What are my average sales per hour? When do I need to add more staff, or even perhaps am I over staffed? There are many situations in which being able to slice your data by time of day would be valuable. In this session we will review how to setup a time key and time dimension, configure it in an OLAP cube, and discuss implementing in a tablular model.

Speaker(s):

  • Alexander Nykolaiszyn

Track and Room: (2) Analysis - N/A


Title: Virtualizing our Environment

Abstract: This session will describe our journey to convert our cluttered, underutilized, power draining physical hosts to a sleek virtualized environment. This session will also provide some VMware high level architecture, terms and concepts, and a look at vSphere (VMware admin console). I’ll discuss the differences between virtual and physical host metrics and issues surrounding them. We’ll discuss some virtualization shortcomings and then show a little about Confio’s Ignite and how it can help DBAs achieve virtualization and not lose visibility of their physical layer.

Speaker(s):

  • Rob Mandeville

Track and Room: (5) DBA/Misc - N/A


Title: Using Excel 2010 as Your Analysis Services Client

Abstract: Self service BI can be a snap even when you build your data models in SQL Server Analysis Services by using PowerPivot for Excel to compress, query and report on the data. This session will begin by showing how to create a cube in Analysis Services and then connect that cube to PowerPivot for Excel. Once in PowerPivot, we will see how to connect this data to other data sources and augment the cube data with calculated DAX expressions. We will close by showing from a user’s point-of-view how easy it is to manipulate the data to create a variety of different reports and charts with no code.

Speaker(s):

  • Michael Antonovich

Track and Room: (3) Presentation - N/A


Title: Introduction to PowerBI with Office365

Abstract: Want to take Self Service BI to the next level. Learn how the new Microsoft PowerBI works in the Cloud. You’ll see how to set up Gateways, Data Sources as well as connect using Excel Power Query.

Speaker(s):

  • Jon Bloom

Track and Room: (2) Analysis - N/A


Title: Make Your SSIS Packages Run Faster: 15 Quick Tips

Abstract: When reviewing your ETL processes, the No. 1 question is always, “Does it work as expected?” Closely following that question is the ubiquitous, “How fast does it run?” This session’s tips are targeted at improve the latter. In this session, we’ll focus on SSIS package performance, quickly reviewing 15 of the most common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.

Speaker(s):

  • Tim Mitchell

Track and Room: (1) ETL - N/A


Title: SQL Server 2012 Column Store Index

Abstract: Take your relational data warehouse query performance all the way to ELEVEN!! The Column Store Index is a new feature that allows for stunning performance. We will cover how it works, why it is so fast as well as the v1.0 limitations and gotchas.

Speaker(s):

  • Kevin Boles

Track and Room: (5) DBA/Misc - N/A


Title: Introduction To Reporting Services

Abstract: In this session we will do an introduction to SQL Server Reporting Services (SSRS). SQL Server Reporting Services provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization, as well as programming features that enable you to extend and customize your reporting functionality. You will walk away with basic skills to create SSRS reports along with some tips and tricks.

Speaker(s):

  • Wes Springob

Track and Room: (3) Presentation - N/A


Title: ETL Frameworks using SSIS

Abstract: On this session we are going to cover how to create ETL frameworks using Metadata using SSIS. The introduction would start from standard ETL File loading using BCP, Bulk Copy, File Delimited and Fixed Width. Finally we will create a single framework to track and deliver the File (s) to any destination within your organization while maintaining company standards and code consistency.

Speaker(s):

  • Jorge Novo

Track and Room: (1) ETL - N/A


Title: Analytics and Big Data at USF

Abstract: In this session we will go over some of the breakthroughs that USF has made in Analytics and Big Data.

Speaker(s):

  • Balaji Padmanabhan

Track and Room: (2) Analysis - N/A


Title: Best Practice Data Visualization

Abstract: This fun and informative session covers best practices for data visualization and even infographics using Microsoft BI: Excel, Power View, the Office 2013 Web Apps Framework, Reporting Services, Visio and other open source and third-party data visualizations.

Speaker(s):

  • Jen Underwood

Track and Room: (3) Presentation - N/A


Title: ETL Data Warehouse loading.

Abstract: On this session we are going to cover the Type I (Data Refresh) and Type II Slowly changing dimension processes to successfully load and track your historical changes on a SQL Server warehouse and how to keep track of the Raw data for data quality and auditing.

Speaker(s):

  • Jorge Novo

Track and Room: (1) ETL - N/A


Title: 5 TSQL Commands I’ve been missing

Abstract: Being a full-stack .NET developer, I have written my fair share of T-SQL, but not until I became an accidental DBA did I find a new world of T-SQL options available to me. In this session, I will go over a five T-SQL commands available since SQL Server 2005 and up that I have been completely missing. We will evaluate the usefulness of CTE, OUTPUT, MERGE, APPLY, and RANKING FUNCTIONS and how each of these can replace common cases you see everyday.

Speaker(s):

  • Jason Carter

Track and Room: (5) DBA/Misc - N/A


Title: Hadoop On-Premise

Abstract: Hadoop is becoming the industry standard for processing Big Data. Learn about Hadoop offerings from Hortonworks On-Premise. You’ll see both the Linux and Windows versions and get familiar with some of it’s functionality.

Speaker(s):

  • Jon Bloom

Track and Room: (4) Big Data - N/A


Title: Intro to MDX

Abstract: Come see how to write queries against a multidimensional database! We will be covering: How to Think About Writing an MDX Query, Basic Terminology, and Build From Simple to More Powerful Query Components. This will be a great launch into

Speaker(s):

  • Michael Simon

Track and Room: (5) DBA/Misc - N/A


Title: ETL not ELT! Common mistakes and misconceptions about SSIS

Abstract: Explore some of the mistakes and misconceptions DBAs tend to have about SSIS. Also look at the performance and scalability of ETL vs ELT with real world examples and sample code.

Speaker(s):

  • Paul Rizza

Track and Room: (1) ETL - N/A


Title: Handling Errors and Data Anomalies in SSIS

Abstract: Even in the most reliable ETL system, it’s eventually going to happen: A package will fail, an output row count won’t match what is expected, a data anomaly will force a forensic search of the package infrastructure… In this session, we’ll talk about some of the things that can go wrong during package execution - and some of the defenses that can be built into SSIS to help head off those errors (or at least make the errors easier to troubleshoot). From error handlers to package restartability, and from logging methods to row count validation and remediation, we’ll cover various ways to keep your ETL flowing when problems arise.

Speaker(s):

  • Tim Mitchell

Track and Room: (1) ETL - N/A


Title: Dealing With Errors in SSIS 2012

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

Track and Room: (1) ETL - N/A


Title: SELECT job FROM firm WHERE hired = ‘Yes’ 2.0

Abstract: Find out what hiring managers really want to see throughout the hiring process. This session will walk through the basics that every successful candidate should know: Resume tips, Job search and Interview tips. Yes, recruiters and hiring managers view your LinkedIn page; but, did you realize they also view your twitter account, your blog, your Facebook and that webpage you designed freshman year in college? If you are in a job search, considering one or just want to be prepared for one, then this session will be a great opportunity to find out what “they” are really looking for.

Speaker(s):

  • Todd Davis

Track and Room: (5) DBA/Misc - N/A


Title: SharePoint BI

Abstract: In this session we will go over the most important BI features available in SharePoint.

Speaker(s):

  • Clinton Daniel

Track and Room: (3) Presentation - N/A


Speakers

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

Michael Antonovich

Twitter: - @SharePointMikeA

LinkedIn: Michael Antonovich

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.

Steve Abraham

Contact: http://www.mb2x.com

With 16 years of experience, Microsoft Technology Expert, Steve Abraham, holds 9 Microsoft certifications and has contributed to the development of 11 Microsoft certifications covering various Microsoft technologies. Steve has lead teams for some of the biggest and best known companies and organizations many of them dealing with mission critical data and in crisis situations including the U.S. State Department, Eddie Bauer, 1-800-Flowers and Hasbro.Steve is co-founder and CTO of MB2x.

Paul Rizza

Twitter: - @PaulRizzaSQL

LinkedIn: Paul Rizza

Contact: http://blogs.msdn.com/b/paulrizza/

Paul Rizza is a Senior Consultant at Microsoft Consulting Services (MCS), Lead on the MCS SQL Hiring Team, and has over 25 years’ experience consulting, teaching and developing on SQL Server platforms. Paul’s expertise includes ETLs, Dimensional modeling, architecting highly available SQL environments and performance tuning. Paul has an Undergraduate degree from UMBC and a Master’s degree both in Computer Science with a concentration in Database Theory from Johns Hopkins University.

Jorge Novo

Contact: http://etldevelopernotes.blogspot.com/

Jorge Novo is a database developer with more than 10 years of experience in the design, implementation, and maintenance of OLAP, ROLAD database system for the enterprise. Jorge specialize himself on ETL processes using automation, and dynamic programming for SSIS. Currently Jorge is working in the programming and development of Data Master Service for the organization.

Alexander Nykolaiszyn

Contact: http://www.littlebigintel.com/

Alexander Nykolaiszyn is a Sr. Business Intelligence Developer for Citrix Systems. Specializing mostly in the BI Stack and Dashboard Design. In his spare time he thinks way too much about the consumption and perspective of business intelligence as well as putting his family to sleep with way too much enthusiasm about data.

Jason Carter

Twitter: - TampaDBA

Contact: http://jason-carter.net

Jason#39;s past has included being a developer, a development manager, accidental DBA, and now a full-time DBA. Having worked with VLDBs as a developer, he found great interest in tuning, tweaking, and making things run faster. With the support of his wife, he gave up his managerial duties and jumped the Development ship and dove head first into his new career as a Database Administrator

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.

Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

Brian Mitchell

Twitter: - @brianwmitchell

LinkedIn: Brian Mitchell

Contact: http://brianwmitchell.com

Brian Mitchell, an MCM - SQL 2008 with a MBA from the University of Florida, is a Senior Consultant in the Microsoft Big Data Center of Expertise, where he focuses on SQL Server Parallel Data Warehouse, HDInsight, and Microsoft Business Intelligence. Brian has spent countless hours onsite at customer sites delivering Microsoft database and BI solutions. He has extensive experience creating and delivering advanced training for the full range of the Microsoft BI stack, with a particular passion for Analysis Services and Reporting Services.

Brian has presented at TechEd, PASS Summit, SQLRally, and several SQLSaturdays and SQL Server user groups. You can read more about his deep involvement in Microsoft data technologies at http://brianwmitchell.com.

Jon Bloom

Contact: http://www.agilebay.com

Jon Bloom is a Business Intelligence Consultant for Agile Bay, Inc. working in the Microsoft BI stack. Jon has worked with Data professionally since 1996 in various roles such as: Report Writer; Programmer; Data Warehousing; ETL; and now Big Data. He is also a member of the Microsoft Tampa Bay BI User Group. Twitter: @SQLJon.

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

Rob Mandeville

Twitter: - https://twitter.com/rob_mandeville

LinkedIn: Rob Mandeville

Rob Mandeville is a Senior DBA with over 20 years of broad experience in database technologies.
He’s served in many roles including production DBA, development DBA, and architect/data modeler on a variety of platforms.
Before coming to Solarwinds, Rob worked in the aerospace, global technology, and geospatial industries.
Rob also had the honor of teaching database related master level courses at Regis University.

Peter Evans

Peter Evans is the Business Intelligence and Analytics Product Evangelist and Product Technologist Consultant for Dell and is a recognized expert in the design, implementation and delivery of bespoke Business Intelligence and Analytics systems utilizing various technologies to a large number of major international companies in over 16 years in the field. Holding memberships of the British Computer Society, Institute of Analysts and Programmers and certification from Microsoft, Novel and Targit.

Jorge Novo

Contact: http://etldevelopernotes.blogspot.com/

Jorge Novo is a database developer with more than 10 years of experience in the design, implementation, and maintenance of OLAP, ROLAD database system for the enterprise. Jorge specialize himself on ETL processes using automation, and dynamic programming for SSIS. Currently Jorge is working in the programming and development of Data Master Service for the organization.

Jason Virtue

Jason Virtue is a Business Intelligence professional with 15+ years of experience for management consulting firms and Fortune 500 IT departments. Jason is a BI TSP for the Florida region at Microsoft

Todd Davis

Todd Davis is a Manager at Convergence Consulting Group, an Analytics, BI and DW consultancy. He is responsible for recruiting and hiring some of the industry’s top tier BI Consultants. Todd is a 2003 graduate of the University of Florida where he studied Economics and Management and also began his career in recruiting and managing employees while attending UF. Todd has been instrumental in the placement of more than 1,000 professionals over a thirteen-year career.

Michael Antonovich

Twitter: - @SharePointMikeA

LinkedIn: Michael Antonovich

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.

Mike Davis

Twitter: - @mikedavisSQL

LinkedIn: Mike Davis

Contact: http://MikeDavisSQL.com

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

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.

Andy Warren

Twitter: - @sqlandy

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.

Thomas Spetnagel

Contact: http://www.valpak.com

Tom Spetnagel is currently the Director of Business Intelligence for Valpak, the 40-year-old nationally-recognized provider of coupons and savings to consumers via The Blue Envelope and various digital platforms such as Valpak.com. Tom has both a Master’s in Aerospace Engineering and an MBA from Georgia Tech, and is a former platinum consultant at global ERP giant SAP, where he helped companies like BMW, Hershey, Georgia-Pacific, Kimberly-Clark, and GE-Fanuc solve their reporting challenges.

John Welch

Twitter: - @john_welch

LinkedIn: John Welch

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.

Michael Simon

Contact: http://www.interlinebrands.com/

BI Developer trained while on staff at Pragmatic Works (under Brian Knight). Now developing for Interline Brands a $1.5 Billion distributor. Experienced in writing MDX for Performance Point 2010/2013,SSRS 2008R2 and SSAS 2008R2.

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.

Jen Underwood

Twitter: - @idigdata

LinkedIn: Jen Underwood

Contact: http://www.impactanalytix.com/

Jen Underwood, a Senior Director at DataRobot, has held worldwide analytics product management roles at Microsoft and served as a technical lead for system implementation firms. She has over 20 years of experience launching new products and turning around failed projects in enterprise data warehousing, reporting, and advanced analytics. Today she designs product and helps analytics professionals learn how to solve complex problems with machine learning in the emerging citizen data science segment.

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.

Jon Bloom

Contact: http://www.bloomconsultingbi.com/

Jon Bloom is a Business Intelligence Consultant working in the Microsoft BI stack. Jon has worked with Data professionally since 1996 in various roles such as: Report Writer; Programmer; Data Warehousing; ETL; and now Big Data. He is also a member of the Microsoft Tampa Bay BI User Group. Twitter: @SQLJon.

Mark Kromer

Contact: http://www.kromerbigdata.com

Mark Kromer is a Big Data Analytics product specialist who has been a product manager, delivery consultant and solution architect in the BI DW space for 20 years with Microsoft, Oracle, ATT and now Pentaho.

Wes Springob

Contact: http://www.SQLWes.com

Wes Springob is a Business Intelligence Consultant working for Agile Bay, Inc., a Tampa based consulting firm specializing in Data Warehouse, Business Intelligence and Big Data solutions. He has been involved in creating web based applications for over 15 years and has experience in a variety of industries for companies large and small.

James McAuliffe

LinkedIn: James McAuliffe

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!

** Balaji Padmanabhan**

Faculty at USF.

Pam Shaw

Pam Shaw has been in IT for almost 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005 and now 2008. Pam is currently an independent contractor. Pam is also the Chapter Leader of the Tampa Bay SQL Users Group - a local chapter of PASS and organizer of SQLSaturday Tampa.

Mark Tabladillo

Twitter: - https://twitter.com/MarkTabNet

LinkedIn: Mark Tabladillo

Contact: http://marktab.net

Mark Tabladillo Ph.D. works for Microsoft as a Cloud Solution Architect for the US CTO Customer Success Team. He has a science doctorate from Georgia Tech. Based in Atlanta, GA, Mark provides cloud enterprise solutions for companies in the US for Microsoft’s strategic clients. He is a chapter leader for the PASS Data Science virtual chapter.

David Dye

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

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

Contact: http://www.TimMitchell.net

Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions.

Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.

John Welch

Twitter: - @john_welch

LinkedIn: John Welch

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.

Clinton Daniel

Faculty at USF.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page