SQLSaturday #489 - Tampa 2016

Event Date: 02/27/2016 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: SSIS 2012/2014: The Quiet Revolution

Abstract: The SQL Server 2012 release of SSIS was a complete game changer. Using sample packages, we’ll show you how to deploy projects to the new SSIS catalog. You will see how project level parameters and connection managers can make your life easier. You will learn how to configure packages using the new configuration editor in SSMS. We’ll show you how to define a collection of configuration settings called an Environment which can automatically configure packages deployed to a server. Find out why SQL Agent no longer captures SSIS errors in the log and how you can get information about failed packages. Get up to speed on using the latest features of SSIS to make you job easier.

Speaker(s):

  • Bryan Cafferky

Track and Room: Application Database Development - BI1


Title: Mastering and Enhancing Company Data

Abstract: Getting a good 360 degree view of organizations (customers or vendors) or doing customer centric analysis is often complicated as a result of bad data/ duplicate data / inconsistent data coming from multiple systems. In addition, there are external factors like mergers and acquisitions, inter-company relationships and other nuances that may not be captured in source systems. Getting a clear picture of customer and vendor data can not only provide a clear picture for analysis of information, but also aid in critical risk management functions. In this session, you will learn about some techniques and data services from DB that you can use to clean and enhance your data.

Speaker(s):

  • Rushabh Mehta

Track and Room: BI Platform Architecture, Development Administration - BI1


Title: So What is Power BI?

Abstract: This session will provide the attendee with an introduction to Power BI Desktop and how to use it with external data sources (sources may vary but could include Web Sites, SharePoint, SQL Server, Excel, Text, or Access). It will compare and contrast it with the features of Power Pivot and Power Chart. Along with way, it will cover some basic table editing techniques, working with data from multiple data sources, and creating multiple visualizations on the same desktop that will interact with each other during the data analysis. This session might be of special interest to anyone currently using Power Pivot, Power Chart, or Power View to see how this tool can be integrated into their toolbox of Business Intelligence skills.

Speaker(s):

  • Michael Antonovich

Track and Room: BI Information Delivery - BI2


Title: Building Defense in Depth Using the Full Spectrum of SQL Server Encryption

Abstract: As the threat of Cybercrime and data breaches increases, it is important to know and understand the variety of options available to protect Personally Identifying Information and other business sensitive data. You need to be prepared to defend yourself from the threat of data theft by learning about and combining methods of encrypting data at rest and in transit. In this presentation, you will learn about encrypting data at rest, data in transit, securing the channels through which data is transported and other topics related to cryptography in SQL Server including details about validating certificates and preventing man in the middle attacks against your server. Other topics include an overview of replicating encrypted data and designing systems so that the DBA can’t decrypt the data. By the end of the session, you will understand how and when to use and combine every available encryption feature to design a defense in depth strategy for protecting data from escaping your network.

Speaker(s):

  • Michael Keleher

Track and Room: Enterprise Database Administration Deployment - Dev1


Title: Database Design Fundamentals

Abstract: Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years, but are often thought of as old-fashioned. Many common T-SQL programming “difficulties” are the result of struggling against these standards and can be avoided by understanding the requirements, applying normalization, as well as a healthy dose of simple common sense. In this session I will give an overview of how to design a relational database, allowing you to work with the data structures instead of against them. This will let you use SQL naturally, enabling the query engine internals to optimize your output needs without you needing to spend a lot of time thinking about it. This will mean less time trying to figure out why SUBSTRING(column,3,1) = ‘A’ is killing your performance, and more time for solving the next customer problem.

Speaker(s):

  • Louis Davidson

Track and Room: Application Database Development - Dev2


Title: Automating Database Restores

Abstract: Beginning DBA’s think of a RESTORE as something that gets done when something goes wrong. In practice we restore all the time, perhaps most often to refresh our QA and Development environments. Doing one restore isn’t hard, but what about when you get five or ten requests a day? It’s not just the restore either, you have to alter permissions, change the recovery model, set the database owner, perhaps update synonyms or mask out sensitive data. Restores are a pattern and if we see the pattern, we can do things to make it faster and repeatable.

This presentation will show you the latest version of the system I use, one consisting of a couple of tables and a couple of Powershell scripts. I’ll start with my design goals, show you some of the compromises I made to get to a solution that handles 90% or so of the requests, and some of the options I thought about but decided against. I used Powershell, but it’s a pattern you could solve using another language, even perhaps TSQL!

Speaker(s):

  • Andy Warren

Track and Room: Enterprise Database Administration Deployment - DBA1


Title: Automating Your Database Deployments

Abstract: Deploying your database changes to production can be nerve-wracking as you introduce changes while attempting to protect your data. In order to take the stress out of these deployments, you must ensure that you practice your deployments before you ever get near production. This session shows how automating the deployment and testing processes through your various development and pre-production environments can make the whole experience of production deployments more repeatable, more reliable and more robust.

In this session, we’ll explore the concepts of continuous integration and continuous delivery for databases – what to consider, the challenges, the benefits, the testing, and the crucial approval gates necessary for a reliable production deployment. We’ll discuss these and other release strategies as you think about how to evolve your deployment pipeline towards a more automated approach, starting with continuous integration and ending at your production systems.

Speaker(s):

  • Grant Fritchey

Track and Room: Application Database Development - Dev2


Title: SQL Server Lockdown in Six Steps

Abstract: I will review the fundamentals needed to define a configurable permission model that allows database administrators to do routine work without having unfettered access to business data.

I will demonstrate that many DBA tasks can be done without sysadmin access and explain what permissions are required for the most common tasks. Attendees will learn how to deploy a permission model that allows DBAs to do routine work and how to elevate permissions quickly to respond to emergencies.

I will demonstrate T-SQL and PowerShell scripts that secure the database server, undo the permission model in case of unforeseen circumstances, and discover which servers are non-compliant.

Attendees will leave this session with the realization that DBAs don’t need to be sysadmin as often as typically believed, that most administration tasks can be done without elevated permissions, and with the means to deploy this model in their own environment.

Speaker(s):

  • Ronald Dameron

Track and Room: Enterprise Database Administration Deployment - Overflow


Title: Fast Track that Cube Please

Abstract: Have you ever been thrown into a position where upper management wants to analyze and report off their data and your in charge? Are you writing complex T-SQL scripts and know there is a better way to achieve your goal? Maybe a multi-dimensional cube is just the answer your looking for. But do you know how to build it? In this session we will look at a data warehouse and build a small cube from the ground up. We will define a basic star schema and how to use it within a SSAS solution. We will look at the frame work around the cube such as the fact table, dimensions, attribute relationships, dimension usage, measures, and partitions. You will also learn a few tricks along the way to optimize for performance.

Speaker(s):

  • Dan King

Track and Room: BI Platform Architecture, Development Administration - BI1


Title: SQL Server Disaster Recovery and High Availability Overview

Abstract: When it comes to disaster recovery and high availability with SQL Server, there are a lot of options. Most business owners (and many DBAs) lump disaster recovery (DR) and high availability (HA) together. And while they do share some pieces, they also call for different strategies. Should you use one or more of these options? And what criteria should you use to make the choice? It’s important that you understand the decision tree that can guide you to select the right option(s) for your organization and that you can clearly explain those choices to the stakeholders. It’s not as complicated as it sounds, but it is complicated. This session will give you a high-level understanding of the options, their costs and complexities, and reasons for using each of them.

Speaker(s):

  • Kendal Van Dyke

Track and Room: Enterprise Database Administration Deployment - DBA1


Title: Monster Text Manipulation: Regular Expressions for the DBA

Abstract: Regular expressions can help you perform incredible tasks with very little effort. Need to create 1700 logins from an email request? Developers give you a single script with 300 stored procedures, filled with table variables, instead of temp tables? Need to move 500 databases to a different drive? Any of these tasks can take a long time to code, but regular expressions cut that work from hours or days to minutes or even seconds. Stop writing code manually and let regular expressions do it for you. Learn: • The most useful regular expression commands • The appropriate times to use regular expressions • How to use regular expressions to write code for you • How to incorporate regular expressions into large tasks and combine them with other methods

Speaker(s):

  • Sean McCown

Track and Room: Enterprise Database Administration Deployment - Dev1


Title: The Business Intelligence Side of SQL Server

Abstract: This session focuses on Microsoft’s BI capabilities within SQL Server and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. Through several releases, Microsoft dramatically enhanced the Microsoft BI platform. During this session Plus Consulting, one of Microsoft’s top global BI partners, will explore the improvements to SQL Server self-service reporting and talk about creating blended value from your BI platform. We’ll show you why the combination of Microsoft Office, PowerBI and SQL Server are an excellent solution for creating self-service dashboards, scorecards, KPIs, pivots, data exploration and discovery.

Speaker(s):

  • Sayed Saeed

Track and Room: BI Platform Architecture, Development Administration - DBA2


Title: Windowed Functions - Harness the Power to Forecast with Ease!

Abstract: In this session, we will do a brief walk through of what windowed functions are, how they execute, and the power that can be realized with them to do advanced computations such as moving averages, running totals, and forecasting. Once we get into the forecasting piece, we will walk through a forecasting model and show how we can leverage windowed functions to take complex calculations and make them easy to interpret. We will also illustrate why windowed functions are much more efficient than the typical update/inner join aggregate for running totals. At the end of this session, the goal is to empower you to go back to your organization and be able to build a forecasting model in just T-SQL.

Speaker(s):

  • Matt Martin

Track and Room: Advanced Analysis Techniques - BI2


Title: Beginning Powershell for DBAs 1.0

Abstract: The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.

Speaker(s):

  • Sean McCown

Track and Room: Enterprise Database Administration Deployment - Dev1


Title: Data Migration Using BIML

Abstract: Many companies scale out their databases horizontally, partitioning data by customer (or some other identifier) into separate databases or instances. Sometimes, it becomes important to move that data from one database to another. SQL Server Integration Services is a fantastic tool for ETL, but creating and maintaining dozens or hundreds of data flows by hand is exhaustingly tedious. Instead of doing it the hard way, use the BI Markup Language (BIML) to automate package development. This talk will show how we can use metadata tables and BIML to auto-create SSIS packages to migrate data from one database to another, handling foreign key constraints along the way.

Speaker(s):

  • Kevin Feasel

Track and Room: BI Platform Architecture, Development Administration - BI2


Title: NoSQL Solutions in the Cloud with Microsoft Azure

Abstract: In this session, I will walk through 3 different Cloud-based NoSQL database options available in Azure that will enable your next-generation Internet applications: Cassandra, MongoDB and Graph. I’ll talk about some benefits and gotchas with those platforms as well as building data analytics on top of those database apps.

Speaker(s):

  • Mark Kromer

Track and Room: Cloud Application Development Deployment - DBA1


Title: Designing Stored Procedure Solutions

Abstract: With a little T-SQL experience, you can create a stored procedure that completes a task. But it’s harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about:

Asking the right questions to set yourself up for success Making the case for stored procedures over ad hoc code and other objects Pro tips for standardization and cross-version compliance Reevaluating and expanding on your solution Limiting inputs to reduce unexpected behaviors and errors Choosing between alternate solutions Evaluating for performance

This session is for data professionals who can write T-SQL, but haven’t spent a lot of time in SQL development.

Speaker(s):

  • Jennifer McCown

Track and Room: Application Database Development - Dev2


Title: Introduction to Fog Analytics

Abstract: This session will provide an overview of Fog Analytics and their frameworks: Azure IoT Suite and ConnectTheDots.io. Fog Analytics is applying analytics to the data generated by Internet of Things (IoT) devices in real-time.

Speaker(s):

  • John Wang

Track and Room: Analytics and Visualization - Overflow


Title: Planning and Executing a Successful SQL Server Database Migration

Abstract: Migrating an existing database to SQL Server requires much more than just moving the schema and data. They key to a successful database migration effort includes designing the target system, identifying all components from the existing system that will need to be migrated, and allowing adequate time for changes and testing.

In this session we will discuss all the different database components and configuration items that will need to be considered during the migration effort, how to utilize the SQL Server Migration Assistant as a planning and implementation tool, what components cannot be migrated (and what can be done about it), and pitfalls to avoid during the development, testing, and final implementation.

Speaker(s):

  • Carlos Colon

Track and Room: Enterprise Database Administration Deployment - DBA2


Title: Managing Multiple SQL Servers Using SSMS

Abstract: Do you want to be able to monitor multiple database servers using SSMS, and execute commands such as checking which servers have a specific login, run a DBCC command on 50 servers at the same time, select records from multiple servers as a single output, identify blocking commands on your SQL Server farm, or even check the error log of multiple servers using a single SQL command? What about sending a SMS when the ‘sa’ user is currently connected? Now you can do this and more with Enzo Unified, the data server platform that unleashes the power of SQL Server.

Speaker(s):

  • Herve Roggero

Track and Room: Enterprise Database Administration Deployment - Overflow


Title: Execution Plans: What Can You Do With Them?

Abstract: People are aware that you can use an execution plan to tune a query, but do they have other uses? This session will drill down on all the hidden information within execution plans. The structures and information with an execution plan shows many of the inner workings of SQL Server. From calculated columns to referential integrity, these, and many other functions, are exposed through execution plans. From this session you’ll be able to better understand the inner workings of SQL Server as well as your own databases and queries.

Speaker(s):

  • Grant Fritchey

Track and Room: Application Database Development - DBA2


Title: Monitoring and Alerting for an Azure PaaS Application

Abstract: I’ll present the fundamentals needed to setup monitoring and alerting for an Azure PaaS application. Coverage will included how to monitor and alert on individual components and setting up alerts in Application Insights.

Speaker(s):

  • Ronald Dameron

Track and Room: Cloud Application Development Deployment - DBA2


Title: Data Partitioning for Database Architects and Mere Mortals

Abstract: Data partitioning is a valuable technique that simplifies database administration tasks and helps meet availability and performance SLAs. In this session, Dmitri will cover several techniques and architectural approaches you can use to partition data in the different versions and editions of SQL Server. You will learn about partitioned tables, partitioned views and stretch databases introduced in SQL Server 2016. Finally, Dmitri will discuss the practical questions, such as how to move data between filegroups and disk arrays keeping tables online and how to address some of performance issues caused by data partitioning.

Speaker(s):

  • Dmitri Korotkevitch

Track and Room: Strategy and Architecture - Dev2


Title: A closer look to Azure Data Factory

Abstract: Azure Data Factory is a modern data orchestration platform design to help you manage any data of any size from any source. It also makes a number of technologies available to you such as Azure Machine learning so that you can integrate predictive machine learning models in your data pipelines. This platform enables you to create intelligent applications that not only provide insights but can also recommend actions upon specific events. Join me in this session as take a closer look at many of the capabilities built in the platform.

Speaker(s):

  • Luis Figueroa

Track and Room: Information Delivery - BI1


Title: Transform SQL Server Agility with XtremIO

Abstract: All-Flash Arrays deliver IOPS in abundance. XtremIO goes further to provide predictable, consistent sub-millisecond latency and unleash agility for your SQL Server databases. Our unique XtremIO Virtual Copies (XVC) capabilities allow for fully writable copies for production, test/dev, reporting/analytics workloads on our market leading consolidation platform. This allows for consolidation of your SQL Server based environments onto a single array to maximize efficiency.

Speaker(s):

  • Bryan Walsh

Track and Room: Enterprise Database Administration Deployment - DBA1


Title: Registration

Abstract: Turn in admission ticket from Speed Pass packet and visit our sponsors.

Speaker(s):

  • Pam Shaw

Track and Room: Other - DBA1


Title: Whip Away Stress at Home Work to Create a Better You

Abstract: If you are a working professional there is a chance that stress has interrupted your life and you’ve forgotten about you and/or your family. How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a better you.

Speaker(s):

  • Karlyn LeBlanc

Track and Room: Professional Development - Overflow


Title: Raffle

Abstract: Raffle drawings from sponsor to event give aways - MUST BE PRESENT TO WIN.

Speaker(s):

  • Pam Shaw

Track and Room: Other - DBA1


Title: Peanut Butter Chocolate: Integrating Hadoop with SQL Server

Abstract: So you jumped on the bandwagon and set up a Hadoop cluster…but now what? Your database developers and app developers know how to integrate with and develop against SQL Server, but the Hadoop world is a completely different experience. This talk will help bridge the gap between SQL Server and Hadoop, using tools such as SQL Server Integration Services and Sqoop to migrate data between a Hadoop cluster and a SQL Server instance, as well as PolyBase to integrate the two like never before.

Speaker(s):

  • Kevin Feasel

Track and Room: Application Database Development - Overflow


Title: Top 10 Wait Types Everyone Should Know

Abstract: There are over 800 wait types in SQL Server 2014, but there are only 10 (in my experience) that are seen very often. If you can learn these 10 wait types, what causes them and their solutions, you will be ahead of the performance analysis game. The list of 10 wait types to be discussed came from over 100 consulting engagements with customers, so come find out what they are and improve your performance troubleshooting skills.

Speaker(s):

  • Janis Griffin

Track and Room: Enterprise Database Administration Deployment - DBA2


Title: Datawarehouse Development in an Agile World

Abstract: In today’s world of Agile, Scrum, Iterative, WiziWigFlimFlam… The data warehouse architect or developer can feel like their development doesn’t really fit. Without knowing all of the requirements upfront, how could you possibly successfully design your datawarehouse? How about all of the documentation you would always leave as artifacts? This session will take you through a handful of tools to help through the iterative development cycles and changes in requirements as the project evolves. You will walk away with several document templates, scripts and the knowledge to help you along your next Agile datawarehouse project.

Speaker(s):

  • miguel Cebollero

Track and Room: Strategy and Architecture - Dev2


Title: XML in SQL

Abstract: Will cover uses of XML in SQL databases, including dynamic data definition needs, XQuery, and complex data-stream applications. Built on real-world needs for real businesses. This is not theoretical, it is practical and has real-world application.

Speaker(s):

  • Gus Gwynne

Track and Room: Application Database Development - Dev1


Title: Break

Abstract: Time between classes

Speaker(s):

  • Pam Shaw

Track and Room: Other - DBA1


Title: Indexing your Data Warehouse

Abstract: One of the primary skill sets most database professionals are initially required to “master” is the art of proper indexing in our databases. We learn early on that an effective indexing configuration will go further in making our databases perform efficiently than probably any other single tuning technique. What’s not so commonly discussed though are the varying approaches one may wish to utilize when indexing your SQL Server enterprise data warehouse. This session will hopefully cause you to take a good look at your current indexing to see if indeed it could be operating even more efficiently.

Speaker(s):

  • Troy Gallant

Track and Room: Enterprise Database Administration Deployment - DBA2


Title: Back Up and Restore? Piece of Cake!

Abstract: Backup and Restore? Piece of Cake!? Right? Backing up our databases is key to protecting our environment. Do you know your backup schedules, backup location and what is required from the business if a recovery is required? Essentially your RTO and RPO? It is too late to late to identify these items when you receive the call to start a database recovery. During this webinar I am going to share my thoughts, what I document, and concepts around backup and recovery procedures for you databases. So when you receive that call to recover a database you can say “Piece of Cake”.

Speaker(s):

  • Daniel Taylor

Track and Room: Enterprise Database Administration Deployment - DBA1


Title: Indexes: Help or Hinder!

Abstract: Indexes can be a boon or decrement for query performance. This session will concentrate with a deep dive into clustered indexes and non-clustered indexes, their syntax and utilization, and their effect on performance in transaction and data warehouse databases. This presentation will be about one-fourth lecture and three-fourths demos. All materials will be available for download.

Speaker(s):

  • Mike Byrd

Track and Room: Application Database Development - Dev1


Title: Inside the Query Optimizer

Abstract: When it comes to SQL Server one of the biggest request you hear is “How can I make my Query Run FASTER!?”. The answer understanding the first step in that process Is understanding the Query Optimizer. Understanding the Optimizer beings with knowing the Rules. The way our queries are written reflect directly on the output that we get. In this session we will look at the rules in SQL Server, write queries to show those rules in action, and walk out with a better understanding of how the Optimizer works.

Speaker(s):

  • Bradley Ball

Track and Room: Enterprise Database Administration Deployment - Dev1


Title: Welcome

Abstract: Welcome to SQLSaturday - What you need to know

Speaker(s):

  • Pam Shaw

Track and Room: Other - DBA1


Title: What’s New in SQL Server 2016 ?

Abstract: SQL Server 2016 is the newest version of SQL Server available from Microsoft. This session is designed to introduce SQL Server DBA’s and architects to some of the exciting features available in that version. Topics covered in this session include Query Store, Polybase, Stretch Database, JSON Support, Row Level Security, Always Encrypted, Enhancements to In-Memory OLTP tables and enhancements to AlwaysOn. If you are a SQL Server DBA or developer, an architect, or an IT professional who is excited about the new SQL Server 2016 features and are looking forward to learn more about them, this session is for you.

Speaker(s):

  • Gareth Swanepoel

Track and Room: Enterprise Database Administration Deployment - DBA1


Title: Data Quality Services - Integrating your Data Steward

Abstract: This session will take you through some of the basics of setting up DQS and how to get started. Beyond the technical work required to setup DQS, there is the Data Steward and their role in the day to day interactions with DQS. This session will explain how to integrated the Data Steward into the process to approve and correct data, in addition to how to integrated those corrections back into your data warehouse loads.

Speaker(s):

  • miguel Cebollero

Track and Room: BI Platform Architecture, Development Administration - BI1


Title: SSIS Factory

Abstract: Assume you have 100’s of packages already developed and running in production. How long it will take to find the package that affect a particular table? Want to automate the search through all packages instead of opening each of them manually and checking them? Can it be more interesting if the conversion of those 2008 packages to 2012/2014 and deploy it to the new SSISDB using project deployment model? You can do it through C# (or VB) code using SSIS SDK with your C# scripting skills that you use in SSIS packages. You can also create new SSIS packages to load text/excel files that receive from a vendor even if you don’t know the file structure. Let’s have some fun..

Speaker(s):

  • Jemini Joseph

Track and Room: BI Platform Architecture, Development Administration - BI1


Title: Parent, Child development Using SSIS Framework

Abstract: Learn how to extend and reuse SSIS development using package controllers and drivers. Extend parallel process and view the different options for SSIS package configurations and become the GURU on ETL development for your organization

Speaker(s):

  • Jorge Novo

Track and Room: BI Information Delivery - BI2


Title: Lunch Break

Abstract: Grab a lunch and join one of our sponsors for a lunch session.

Speaker(s):

  • Pam Shaw

Track and Room: Advanced Analysis Techniques - Dev1


Abstract: It’s no surprise that embarking upon a job search can be a high-anxiety time. However, following an effective job search process and applying best practices when it comes to your resume and professional online marketing channels, working with Recruiters, leveraging alerts and other strategies, etc. can help reduce frustrations and make it better. In this session, we’ll highlight what you should consider prior to starting your search, a 9-step plan to conduct an effective job search, how to work effectively with Recruiters, consideration criteria for evaluating your options, and how to part ways professionally if you’ll be resigning.

Speaker(s):

  • Erica Woods

Track and Room: Professional Development - Overflow


Title: What’S New In SQL Server 2012/2014/2016 For The Developer

Abstract: This session covers the new functionality directly related to SQL Server developers in the last several releases of SQL server.

Speaker(s):

  • Jeff Taylor

Track and Room: Application Database Development - DBA1


Title: Availability Groups: Monitoring and Alerting

Abstract: So you have your availability groups configured and everything reports green. How do you measure SLA compliance? Do you know when replication is delayed? Did you know it failed over last night? This session will answer all these questions and more, and will show you what should you be looking at to ensure no surprises… We will look at the DMVs, extended event sessions, perfmon counters, SQL agent jobs and policies to show what to monitor in your AG and how to setup alerts so you know when to take action

Speaker(s):

  • Shawn Meyers

Track and Room: Enterprise Database Administration Deployment - DBA2


Title: What’s New in SSRS 2016

Abstract: It’s been 10 years SQL Server Reporting Services has been updated. Hey Microsoft, what’s the hold up? Well the wait is over. Join me in this demo-heavy session where I will discuss and demonstrate all the new features of SSRS, from custom parameter layouts to pinning reports to Power BI.

Speaker(s):

  • Patrick LeBlanc

Track and Room: BI Information Delivery - BI2


Title: Intelligent Indexing

Abstract: Using indexing to improve performance

Speaker(s):

  • Arvin Meyer

Track and Room: Professional Development - DBA1


Title: Solving Real Business Problems Step by Step

Abstract: When you’re first starting out, queries can be daunting. The experts on your team seem to do it instinctively. But the flexibility of T-SQL makes it seem near impossible to translate a business problem into an executed query.

Luckily, we’ve developed a set of rough guidelines to do just that. In this session, we deconstruct the ad-hoc query in the context of real business problems. We will explore and test our step-by-step approach using the AdventureWorks database as our sandbox, as if you are an employee for Adventure Works and you’ve just been handed a problem to solve.

Speaker(s):

  • Neil Pepi

Track and Room: Application Database Development - Dev2


Speakers

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

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.

Mike Byrd

Twitter: - ByrdNest_TX

LinkedIn: Mike Byrd

Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com

Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.

Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.

Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).

Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd

Jorge Novo

Twitter: - @ETLDEVDBA

LinkedIn: 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, SQL tuning, and much more. Jorge is always eager to learn and shared his ideas and challenges with the SQL Community.

Matt Martin

Twitter: - @sqletl_matt

LinkedIn: Matt Martin

Contact: http://mddatatech.wordpress.com

Matt Martin is a SQL Server professional that loves data integration and data warehousing. He has over 9 years of experience specializing in ETL automation, and working with big data. In 2015, Matt co-founded a new software company called MD Data Technologies, which simplifies SQL Server ETL by using a T-SQL parameterized wrapper to automate the building and execution of SSIS packages.

Erica Woods

Twitter: - ericawoodsgo

LinkedIn: Erica Woods

Contact: https://www.mssqltips.com/sqlserverauthor/128/erica-woods/

Erica Woods is the Manager of Contractor and Community Relations at Apex Systems, a national IT Staffing and Services firm. Her focus is on program management, training and development, customer relations, community evangelism and corporate social responsibility, communications, marketing and social media. She has 10 years of IT staffing, an MBA from Loyola University, is an Author at MSSQLTips, and runs a group called Techies for Good.

Rushabh Mehta

Twitter: - @rushabhmehta

LinkedIn: Rushabh Mehta

Contact: http://blogs.solidq.com/RushabhMehta

Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.

Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data

Louis Davidson

Twitter: - drsql

LinkedIn: Louis Davidson

Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/

Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

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

Michael Keleher

Twitter: - @makeleher

LinkedIn: Michael Keleher

Michael Keleher is a Microsoft Certified Professional and is currently the Database Administrator at Bisk Education, Inc in Tampa, Florida. He has over twenty years of experience working in all areas of the Software Development Life Cycle plus another three as a Database Administrator. He enjoys getting involved in security and performance tuning projects.

Pam Shaw

Twitter: - @PamShaw

LinkedIn: Pam Shaw

Contact: http://sqlpam.wordpress.com/

Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.

Bryan Cafferky

LinkedIn: Bryan Cafferky

Contact: https://www.youtube.com/user/Bryancutube256123

Bryan Cafferky is a Big Data and AI consultant. Bryan was previously a Senior Data Science Training Content Developer for Microsoft Worldwide Learning. Prior to this he was a Microsoft Data and AI Enabler for healthcare customers. He is a Microsoft 2017 Data Platform MVP and a 2016 Cloud and Data Center Management MVP. Bryan is the author of Pro PowerShell for Database Developers by Apress, available on Amazon. He leads The RI Microsoft BI User Group, and The Greater Boston Area Data Science Group. He has been working with the SQL Server stack since 1997 and implemented projects in the banking, insurance, e-commerce, utility, and health care industries. He holds a bachelor of science in computer information systems and an MBA.

Jeff Taylor

Twitter: - reviewmydb

LinkedIn: Jeff Taylor

Contact: https://blog.reviewmydb.com

Jeff Taylor is a Senior Software Data Architect. His work with databases began with SQL Server 6.5 over 22 years ago. He specializes in performance tuning and critical operational database issues. Currently he is serving as the President of the Jacksonville SQL Server Users Group and is an active board member of the Jacksonville Development Users Group.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Jemini Joseph

LinkedIn: Jemini Joseph

I#39;ve been working in Microsoft BI field since 2003 and worked in SSIS/SSAS/SSRS since 2005. Working as an independent consultant in BI field since 2007 for different clients across the country (US). Most of my experience is in SSIS and worked different versions of SSIS from 2005 to 2014.

John Wang

John Wang is a Back-end .NET Developer. Currently, his interests are IoT, big compute, services, cloud computing, Powershell and SQL topics. He is an frequent speaker at the various Code Camp, Meetup, IT Pro Camp and SQLSaturday.

Carlos Colon

Twitter: - @CaColon

LinkedIn: Carlos Colon

Carlos is a certified SQL Server professional and a senior software developer. As a 20 year veteran, Carlos leads Dobler Consulting’s database managed services practice. He’s also a certified PMP and holds a B.S. in Management of Information Systems.

Mark Kromer

Twitter: - @kromerbigdata

LinkedIn: Mark Kromer

Contact: http://www.kromerbigdata.com

Mark Kromer is a Microsoft Cloud Data Solution Architect with 20 years of experience in database applications, data warehouses, big data and business intelligence.

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

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.

Luis Figueroa

Twitter: - @luisefigueroa

LinkedIn: Luis Figueroa

Contact: http://blog.luisfigueroa.net

Luis Figueroa is a data professional with more than 15 years of experience in Information Technologies across many industry verticals. Luis has held a variety of positions in IT such as Network Administrator, Systems Engineer, Database Administrator and EDW / BI Architect. In the most recent years Luis found his passion in architecting and developing open source data centric solutions that help businesses manage their data and gain a competitive advantage through analytics. Luis currently holds a position as Solutions Engineer for Hortonworks, Inc. where he works with many clients including Fortune 500 companies. Luis’ main focus areas are in Data Warehousing, Business Intelligence, Advanced Analytics, Big Data, IoT and Cloud Computing.

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.

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.

Daniel Taylor

Twitter: - @DBABulldog

LinkedIn: Daniel Taylor

Contact: http://dbabulldog.wordpress.com/

Daniel Taylor started his DBA life at Nielsen Media Research Company working with Sybase ASE 11 thru 12.5, Sybase IQ, eventually moving to SQL server. Post Nielsen Media Research Daniel worked for Publix Supermarket a Forbes recognized industry leader, Forbes top 100 best places to work, and tops in customer service and satisfaction. Following Publix Daniel worked at New York Like which is recognized as a Fortune 500 company, Fortune 500 Global company, and recognized as top 50 company for diversity. Currently Daniel h is a Consultant with Pragmatic Works. You can find him on Twitter as @DBABullDog. Daniel has worked with SQL Server version from 7.0 to 2014. You can find him on Twitter as @DBABullDog.

Bryan Walsh

Twitter: - @BryanJWalsh

20 years into a career focused on Microsoft technologies and the impact of they make for companies across all industries and verticals. Started at EMC in 2006 and have held numerous leadership roles that champion Microsoft to our field, partners and customers. In my current role at XtremIO, my primary focus is SQL Server and how to unlock agility and end storage inefficiency.

Sayed Saeed

LinkedIn: Sayed Saeed

Contact: http://www.plusconsulting.com/blog/

Sayed Saeed is the Business Intelligence Practice Director at Plus Consulting. He is highly proficient in developing targeted BI solutions for clients and offers solid knowledge and experience in BI products that help organizations better leverage information to effectively manage business. He is a Microsoft Certified Solutions Expert in Business Intelligence as well as Oracle Certified Professional.

miguel Cebollero

Twitter: - SQLMiguel

LinkedIn: miguel Cebollero

Miguel is a father, husband and database professional with more than 18 years of experience. He has held positions in management, database administration, development, architect and BI development. Miguel is a regular speaker at local user groups, regional SQLSaturday and the national PASS Summit conference on various database topics. He has been an avid volunteer, chapter leader, contributor for PASS and published author of Pro TSQL Programmers Guide; ApressMedia, Published 2/27/2015

Gus Gwynne

LinkedIn: Gus Gwynne

Married (25 years), no children. Have lived in 6 different US states including west-coast, Rocky Mountains, east-coast, Gulf-coast, and in-between.

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.

Gareth Swanepoel

Twitter: - @GarethSwan

Contact: http://mygareth.com

Gareth Swanepoel is a sysadmin-turned-SQL Server DBA. He has been working in the IT industry doing support and administration for over 25 years. He enjoys solving the complex problems that customers encounter when performance tuning SQL Server or when deploying SQL Server in large data warehouse environments. He is originally from South Africa and is currently a Dedicated Support Engineer (PFE) with Microsoft. He is a passionate member of the SQL Server community and is an accomplished author and speaker having presented at various user groups, SQLSaturdays, the PASS Summit and other technical conferences.

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.

Sean McCown

Twitter: - @KenpoDBA

Contact: http://www.midnightdba.com/dbarant

Sean McCown is a Certified Master with 23 years of experience in databases. He is also founder and co-owner of the MidnightDBA.com website, where he records free SQL Server training videos. He also writes the popular Minion Maintenance suite, the most configurable maintenance solution on the planet.

Patrick LeBlanc

Twitter: - patrickdba

LinkedIn: Patrick LeBlanc

Contact: http://patrickdleblanc.com

Patrick LeBlanc is a currently a Principal Program Manager at Microsoft and a contributing partner to Guy in a Cube. Along with his 15+ years’ experience in IT he holds a Masters of Science degree from Louisiana State University. He is the author and co-author of five SQL Server books. Prior to joining Microsoft he was awarded Microsoft MVP award for his contributions to the community. Patrick is a regular speaker at many SQL Server Conferences and Community events.

Herve Roggero

Twitter: - @hroggero

Contact: http://geekswithblogs.net/hroggero

Herve Roggero, Microsoft Azure MVP, is the founder of Enzo Unified (www.enzounified.com). Herve’s experience includes software development, architecture, database administration and senior management with both global corporations and startup companies. He holds multiple certifications, including an MCDBA, MCSE, MCSD. He is a Pluralsight author, runs the Azure Florida Association, and co-authored two Azure book with Apress.

Karlyn LeBlanc

Karlyn LeBlanc is a native of Chicago, Illinois. She currently resides in the Atlanta, Georgia area. Karlyn obtained her Bachelors degree from Louisiana State University in Baton Rouge and her Masters from Tulane University in New Orleans. Her career began as licensed master social worker where she spent twelve years counseling patients, supervising master level social workers, and facilitating support groups. In addition, she’s a bestselling author of two books and motivational speaker.

miguel Cebollero

Twitter: - SQLMiguel

LinkedIn: miguel Cebollero

Miguel is a father, husband and database professional with more than 18 years of experience. He has held positions in management, database administration, development, architect and BI development. Miguel is a regular speaker at local user groups, regional SQLSaturday and the national PASS Summit conference on various database topics. He has been an avid volunteer, chapter leader, contributor for PASS and published author of Pro TSQL Programmers Guide; ApressMedia, Published 2/27/2015

Dan King

Contact: http://www.rdx.com/Blog/dba_tips/2014/04/the-merge-join-transformation-and-an-ssis-sorting-tip/

My name is Dan King. Believe it or not I am a huge computer geek. I have worked in the System Admin role and for the past 9 years I have worked with RDX holding many positions. My current role is Sr. Manager of Data Analytics. I am a father of one. I love sports and I am a huge outdoors man. I have a few blogs published by my company that can be found on there website.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Pam Shaw

Twitter: - @PamShaw

LinkedIn: Pam Shaw

Contact: http://sqlpam.wordpress.com/

Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.

Shawn Meyers

Twitter: - 1dizzygoose

LinkedIn: Shawn Meyers

Shawn Meyers is a Field CTO working at Tintri. Shawn has worked in IT for 25+ years and specifically with SQL Server for 20+ years, beginning with version 6.5. A frequent speaker at many events including PASS Summit, VMworld, VMUGs, Virtual Chapter sessions, and many SQLSaturday events. Current focus is on improving DBAs lives with better infrastructure.

Kevin Feasel

Twitter: - feaselkl

LinkedIn: Kevin Feasel

Contact: http://www.catallaxyservices.com

Kevin Feasel is a Microsoft Data Platform MVP and CTO at Envizage, where he specializes in data analytics with T-SQL and R, forcing Spark clusters to do his bidding, fighting with Kafka, and pulling rabbits out of hats on demand. He is the lead contributor to Curated SQL (https://curatedsql.com), president of the Triangle Area SQL Server Users Group (https://www.meetup.com/tripass), and author of PolyBase Revealed (https://www.apress.com/us/book/9781484254608). A resident of Durham, North Carolina, he can be found cycling the trails along the triangle whenever the weather’s nice enough.

Pam Shaw

Twitter: - @PamShaw

LinkedIn: Pam Shaw

Contact: http://sqlpam.wordpress.com/

Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.

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.

Troy Gallant

Contact: http://www.troygallant.com

Troy has been a SQL Server professional for over 18 years, filling various roles as analyst, developer, and for the last decade, DBA. As a regular speaker at SQLSaturdays up and down the east coast, he’s taught on a multitude of topics from disaster recovery to performance tuning to professional development. Currently residing in Jacksonville once again, he just got back from two years as Sr. DBA for the EDW of a major international insurance company in New York City.

Pam Shaw

Twitter: - @PamShaw

LinkedIn: Pam Shaw

Contact: http://sqlpam.wordpress.com/

Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.

Arvin Meyer

LinkedIn: Arvin Meyer

Having 16 consecutive MVP awards, Arvin maintains the Access Web http://www.mvps.org/access, an Access download site on his domain (http://www.datastrat.com), owns and is webmaster of http://www.accessmvp.com, and several client websites. A Microsoft Certified Professional and Microsoft MVP, Arvin writes freelance technology articles, is an author of a book on Access, leads the Access, Office, and Security Special Interest Groups at the Central Florida Computer Society.

Pam Shaw

Twitter: - @PamShaw

LinkedIn: Pam Shaw

Contact: http://sqlpam.wordpress.com/

Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.

Neil Pepi

LinkedIn: Neil Pepi

Contact: http://www.realsqlqueries.com/

Neil Pepi is currently a Sr. Database Marketing Analyst for Bisk Education. He also co-authored the book Real SQL Queries: 50 Challenges with Brian Cohen.

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.

Mike Byrd

Twitter: - ByrdNest_TX

LinkedIn: Mike Byrd

Contact: http://logicalread.solarwinds.com/?s=byrd, www.TSQLMentoring.com and SQLServerCentral.com

Former rocket scientist and USAF Fighter Pilot – now a SQL Server geek (24 years)! Past opportunities include free-lance technical writer for PC Magazine, Senior Software Manager for government sponsored munitions effectiveness committee, and insurance company CTO. Currently senior database engineer consultant for several Austin companies.

Presenter at many SQLSaturdays over last 6 years in United States, Europe, and Australia.

Specialize in SQL Server performance tuning; database (OLTP OLAP) architecture; trouble-shooting; teaching TSQL (Basic through Advanced).

Video presentations (for local SQL Server user groups or SQLSaturdays) can be found at http://usergroup.tv/videos/category/speaker/mike-byrd

Bryan Cafferky

LinkedIn: Bryan Cafferky

Contact: https://www.youtube.com/user/Bryancutube256123

Bryan Cafferky is a Big Data and AI consultant. Bryan was previously a Senior Data Science Training Content Developer for Microsoft Worldwide Learning. Prior to this he was a Microsoft Data and AI Enabler for healthcare customers. He is a Microsoft 2017 Data Platform MVP and a 2016 Cloud and Data Center Management MVP. Bryan is the author of Pro PowerShell for Database Developers by Apress, available on Amazon. He leads The RI Microsoft BI User Group, and The Greater Boston Area Data Science Group. He has been working with the SQL Server stack since 1997 and implemented projects in the banking, insurance, e-commerce, utility, and health care industries. He holds a bachelor of science in computer information systems and an MBA.

Jennifer McCown

Twitter: - http://www.Twitter.com/MidnightDBA

LinkedIn: Jennifer McCown

Contact: http://www.MidnightDBA.com/Jen

Jen McCown is CEO of MinionWare, LLC; a Microsoft Certified Master for SQL Server; and an independent consultant. She is Senior Editor at MidnightDBA.com, where she creates training videos, the DBAs at Midnight webshow, blogs, reviews, and podcasts. Jen is a member, volunteer, and speaker in PASS, and the PASS Women in Technology Virtual Group.

Sponsors

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

Back to the SQLSaturday Event List

Back to the home page