SQLSaturday #192 - Tampa 2013

Event Date: 03/02/2013 00:00:00

Event Location:

2112 N. 15th St
Tampa, Florida

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

Sessions
Speakers
Sponsors

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: Pivoting Performance Data Pinpointing Problems

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

Track and Room: Track 2 - N/A

Title: Reporting Services Deep Dive

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

Track and Room: Track 1 - N/A

Title: SQL Internals , Recovery Models, and Backups! OH M

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

Track and Room: Track 8 - N/A

Title: PowerShell for Data Professionals

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

Track and Room: Track 2 - N/A

Title: Successfully Virtualizing SQL Server in Production

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

Track and Room: Track 5 - N/A

Title: Join Us - Getting Started as a Technical Speaker

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

Track and Room: Track 7 - 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: Track 2 - N/A

Title: Partitioning for Perf and Management

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

Track and Room: Track 6 - N/A

Title: Extend your T-SQL scripting with PowerShell

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

Track and Room: Track 4 - N/A

Title: Building a Windows 8 app from scratch

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

Track and Room: Track 8 - N/A

Title: “It’s MINE” - Intro into locking in SQL Server

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

Track and Room: Track 5 - N/A

Title: Becoming a Data Professional – taking it to the ne

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

Track and Room: Track 5 - N/A

Title: PowerPivot+Powerview=Self-service BI Revolution

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

Track and Room: Track 1 - 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: Track 3 - N/A

Title: Hello, My Name is DAX

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

Track and Room: Track 2 - N/A

Title: Indexing for Join Optimization

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

Track and Room: Track 6 - N/A

Title: Revenge: The SQL Part 2: The Sequel!

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

Track and Room: Track 7 - N/A

Title: Report Builder: reports made easy

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

Track and Room: Track 2 - N/A

Title: Process Automation with SSIS

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

Track and Room: Track 3 - N/A

Title: Extend Your Knowledge with Extended Events!

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

Track and Room: Track 4 - N/A

Title: Using PowerShell To Document Your SQL Envronment

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

Track and Room: Track 6 - N/A

Title: Building a SSIS Business Rules Engine

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

Track and Room: Track 3 - N/A

Title: “It’s THEIRS” - Locking - a step further

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

Track and Room: Track 5 - N/A

Title: The Database Creation Process

Abstract: What happens before the flowchart

Speaker(s):

Arvin Meyer

Track and Room: Track 7 - N/A

Title: Database Projects: A Walk Around SQL Server Databa

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

Track and Room: Track 4 - N/A

Title: SQL 2012 – All About HA and DR

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

Track and Room: Track 6 - N/A

Title: (Way Too Much) Fun with Reporting Services

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

Track and Room: Track 1 - N/A

Title: Indexing for performance

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

Track and Room: Track 5 - N/A

Title: A Big Data Primer

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

Track and Room: Track 1 - N/A

Title: Power View Reporting Enhancements in SQL Server

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

Track and Room: Track 4 - N/A

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

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

Track and Room: Track 3 - N/A

Title: Building Your Professional Development Plan

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

Track and Room: Track 8 - N/A

Title: Kung Fu Migration to Windows Azure SQL Database

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

Track and Room: Track 8 - N/A

Title: Predictive Analytics at your fingertips

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

Track and Room: Track 4 - N/A

Title: Top Query Optimizer Topics for Better Performance

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

Track and Room: Track 6 - N/A

Title: Sysadmin not always required…

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

Track and Room: Track 8 - N/A

Title: Free Tools for the DBA

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

Track and Room: Track 5 - N/A

Title: What is a BI DBA?

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

Track and Room: Track 1 - N/A

Title: Exploring your Data with Power View

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

Track and Room: Track 1 - N/A

Title: SSIS Programming Using .NET

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

Track and Room: Track 7 - N/A

Title: Building your first SSIS package made easy

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

Track and Room: Track 3 - N/A

Title: New T-SQL features in SQL Server 2012

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

Track and Room: Track 8 - N/A

Title: MDXplosion! Intro To MDX

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

Track and Room: Track 3 - N/A

Title: Backups: Getting the Most Out of Your Storage

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

Track and Room: Track 7 - N/A

Title: Performance Tuning by Digging into the Plan Cache

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

Track and Room: Track 6 - N/A

Title: Reporting 101

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

Track and Room: Track 2 - 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.

Scott Klein

Twitter: - SQLScott

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.

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.

Jonathan Kehayias

Twitter: - @SQLPoolBoy

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.

Brook Ranne

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.

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.

Brian Flynn

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.

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

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.”

Richie Rump

Twitter: - @jorriss

LinkedIn: Richie Rump

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.

Jose Chinchilla

Twitter: - SQLJoe

LinkedIn: Jose Chinchilla

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.

Bradley Ball

Twitter: - @SQLBalls

LinkedIn: Bradley Ball

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

Eddie Wuerch

Twitter: - @EddieW

LinkedIn: Eddie Wuerch

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.

John Welch

Twitter: - @john_welch

LinkedIn: John Welch

Contact: http://agilebi.com/jwelch

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

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.

Jose L. Rivera

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.

Dmitri Korotkevitch

Twitter: - aboutsqlserver

LinkedIn: Dmitri Korotkevitch

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.

Jonathan Kehayias

Twitter: - @SQLPoolBoy

Contact: https://www.sqlskills.com/blogs/jonathan

Benjamin Nevarez

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.

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

Contact: http://mssqlperformance.blogspot.com/

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

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.

Yelena Pavlyuk

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.

Robert Biddle

Twitter: - @robert_biddle

LinkedIn: Robert Biddle

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.

Mitchell Pearson

Twitter: - @MitchellSQL

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.

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!

Dustin Ryan

Twitter: - @SQLDusty

LinkedIn: Dustin Ryan

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.

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

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.

Jonathan Kehayias

Twitter: - @SQLPoolBoy

Contact: https://www.sqlskills.com/blogs/jonathan

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

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”.

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.

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

Russell Fustino

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’!

Jorge Segarra

Twitter: - @sqlchicken

LinkedIn: Jorge Segarra

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” .

Aaron Nelson

Twitter: - SQLvariant

LinkedIn: Aaron Nelson

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.

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

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.

Guillermo Caicedo

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

Jessica Moss

Twitter: - @jessicammoss

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.

Arvin Meyer

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.

Michael Antonovich

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.

Buck Woody

Twitter: - BuckWoodyMSFT

LinkedIn: Buck Woody

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.

Ronald Dameron

Twitter: - @RonDBA

LinkedIn: Ronald Dameron

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.

Eddie Wuerch

Twitter: - @EddieW

LinkedIn: Eddie Wuerch

Contact: http://www.indydba.com

Maximo Trinidad

Twitter: - maxtrinidad

LinkedIn: Maximo Trinidad

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.

Dmitri Korotkevitch

Twitter: - aboutsqlserver

LinkedIn: Dmitri Korotkevitch

Contact: http://aboutsqlserver.com

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

Contact: http://blog.datainspirations.com

Rob Volk

Twitter: - sql_r

LinkedIn: Rob Volk

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.

Christopher Price

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.

Ed Watson

Twitter: - http://twitter.com/SQLGator

LinkedIn: Ed Watson

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.

SQLSaturday #192 - Tampa 2013

Sessions

Title: Pivoting Performance Data Pinpointing Problems

Title: Reporting Services Deep Dive

Title: SQL Internals , Recovery Models, and Backups! OH M

Title: PowerShell for Data Professionals

Title: Successfully Virtualizing SQL Server in Production

Title: Join Us - Getting Started as a Technical Speaker

Title: Tuning Analysis Services Processing Performance

Title: Partitioning for Perf and Management

Title: Extend your T-SQL scripting with PowerShell

Title: Building a Windows 8 app from scratch

Title: “It’s MINE” - Intro into locking in SQL Server

Title: Becoming a Data Professional – taking it to the ne

Title: PowerPivot+Powerview=Self-service BI Revolution

Title: Dealing With Errors in SSIS 2012

Title: Hello, My Name is DAX

Title: Indexing for Join Optimization

Title: Revenge: The SQL Part 2: The Sequel!

Title: Report Builder: reports made easy

Title: Process Automation with SSIS

Title: Extend Your Knowledge with Extended Events!

Title: Using PowerShell To Document Your SQL Envronment

Title: Building a SSIS Business Rules Engine

Title: “It’s THEIRS” - Locking - a step further

Title: The Database Creation Process

Title: Database Projects: A Walk Around SQL Server Databa

Title: SQL 2012 – All About HA and DR

Title: (Way Too Much) Fun with Reporting Services

Title: Indexing for performance

Title: A Big Data Primer

Title: Power View Reporting Enhancements in SQL Server

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

Title: Building Your Professional Development Plan

Title: Kung Fu Migration to Windows Azure SQL Database

Title: Predictive Analytics at your fingertips

Title: Top Query Optimizer Topics for Better Performance

Title: Sysadmin not always required…

Title: Free Tools for the DBA

Title: What is a BI DBA?

Title: Exploring your Data with Power View

Title: SSIS Programming Using .NET

Title: Building your first SSIS package made easy

Title: New T-SQL features in SQL Server 2012

Title: MDXplosion! Intro To MDX

Title: Backups: Getting the Most Out of Your Storage

Title: Performance Tuning by Digging into the Plan Cache

Title: Reporting 101

Speakers

Sponsors