SQLSaturday #288 - South Florida 2014

Event Date: 06/14/2014 00:00:00

Event Location:

Nova Southeastern University
3301 College Ave
Davie, 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: Creating Access 2013 Web Apps in SQL Azure using SharePoint

Abstract: Access 2013 web apps feature a new, full integration with SQL Azure. When you create a web app on SharePoint, Access Services will create SQL Azure database that houses all of your Access objects. This new architecture increases performance scalability; it also opens up new opportunities for SQL developers to extend and work with the data in Access apps. In this session you will… • Learn to easily create an Access Web App in 60 seconds • Understand automatic views • See how Access Web Apps help knowledge experts (no coding required) • View the online development environment • See a production release of a real-world web app in action • See different interfaces for within the company with clients/vendors • Learn about integrating Office web apps • Understand the use of hybrid applications • Learn about app distribution, deployment and upgrades • See the pros/cons of Access Web Apps in a corporate environment

Speaker(s):

Andy Tabisz

Track and Room: SQL Azure (3046) - N/A

Title: REAL WORLD REPORT SERVER PERFORMANCE SOLUTIONS AND STRATEGIES

Abstract: In this session we will cover the best strategies to track SQL Server Reporting Services performance and the methods to improve report performance. We will cover methods of tracking report performance through sys.dm_exec_procedure_stats and other DMVs, leveraging the ReportServer catalog ExecutionLog3 view, and monitoring Reporting Services using performance monitor (perfmon). We will analyze this information through T-SQL queries in SSMS and PowerView analysis. We will also cover methods of rolling these solutions into a warehouse report using SSRS / SSIS to monitor report performance over time. We will discuss when to scale out the Report Server and when to focus on the SQL Server queries driven through SSRS report execution.

We will cover methods of isolating Report Server performance and we will cover how to create your own SSMS Dashboard Report with KPIs on SSRS and SQL Server Performance.

This session is a must for both DBAs and report developers.

Speaker(s):

David Pless

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

Title: The DW and Big Data Architecture

Abstract: The problem with the old way of organizing and analyzing data in RDBMS is that it is painfully slow, incomplete and costly. We are obligated to be selective and work with data in small chunks. In the best case scenario we have been partitioning our data and archiving it with the hope to eventually use it. The fact is that when data is being archived, usually, it is never being used again. We didn’t even bother with collecting all the data due to economics and technical limitations. The same that in the dawn of the relational revolution, the RDBMS created a new way of handling data that allowed doing it in better ways. The new breed of Big Data Management Systems BDMS, such as Cloudera and Hortonworks, are opening new possibilities to handle the renegaded and invisible data of the enterprise making possible to think about a new world, the “internet of everything” In my presentation I will explain advantages and disadvantages of OLTP, OLAP and Big Data and the Big Data impact in the D

Speaker(s):

Frank Quintana

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

Title: Performance dreams wait for you at SQL Server 2014

Abstract: Performance dreams wait for you at SQL Server 2014 , it is just like this because you will that unbelievable performance reads and substantial improvement that you will not give up at all those new SQL Server 2014 features , come in here to my session and you will know more about many new features and rich powers of SQL Server 2014 regarding performance particularly like Microsoft project “Hekaton” for In-memory built for OLTP , In-Memory columnstore index ,Resource Governor for IO consumption,lock management and also Single partition online index rebuild technologies ,you will get much hands-on experience for all definitions , architecture design , values and benefits ,caveats and recommendations related to each one of them and in addition I will add a practical flavor for this session by conducting multiple stress tests on most of these technologies to be more close to these performance dreams and explorer concretely these outstanding performance improvements of SQL Server 2014

Speaker(s):

Shehab El-Najjar

Track and Room: DBA - Performance (1052) - N/A

Title: Change Data Capture a developer’s unknown best friend

Abstract: Wish there was a way to identify data that has been inserted, deleted and updated with minimal overhead and without he use of triggers? Looking for a way to validate the impact on the data by the new code you are about to deploy in Production? Wish there was a way to quickly recover and revert changes made to the data already committed when not using explicit transactions? Want to speed up your incremental ETLs? Join Jose to learn more about Change Data Capture (CDC) in SQL Server and understand how developers can utilize this tool to debug code, document code impact on the data, identify data that has been inserted, updated or deleted data and how it can be used to restore changed data in seconds to its original state without the use of backups or snapshots.

Speaker(s):

Jose Chinchilla

Track and Room: Development (3044) - N/A

Title: T-SQL Performance Guidelines for better DB stress powers

Abstract: To reach your desired business functionalities, it can be easy using some common T-SQL practices like MTVF , scalar functions , Temp tables, Union…etc and they might perform pretty well on development server coz neither adequate stress of users or adequate volume of data is exists there but actually they seem totally strange once going to live and they become performing badly ending up with standstill cases sometimes , this is due to lack of stress powers of T-SQL codes which should be considered largely for critical mission DBs so I am going to talk to you about How to capture expensive queries using different techniques ..?and How to optimize them in the shortest time using scientific ways ..? (10 different T-SQL Practices will be analyzed within this session)

Speaker(s):

Shehab El-Najjar

Track and Room: Development (3044) - N/A

Title: Business Intelligence Features in SQL Server 2014

Abstract: Joe dives into the new business intelligence features of SQL Server 2014. There are new features in Rapid data exploration in Excel and Managed self-service BI which includes Governance and compliance, insight, and oversight for IT with self-service content creation that is balanced with IT management and ease of administration through SharePoint. He will investigate credible, consistent data with BI Semantic Model along with features for Enterprise information management (EIM) encompassing Data Quality Services, Master Data Services; SQL Server Integration Services. Finally, he delves into Big Data analytics and data warehousing with support for Massive data warehousing and amazing performance with xVelocity in-memory technology.

Speaker(s):

Joe Homnick

Track and Room: BI (3045) - N/A

Title: Mission Possible: Interactive Performance Troubleshooting - Indexes

Abstract: Performance troubleshooting is detective work. We’ll have a lab system being assaulted by PowerShell scripts (to simulate live users), and simulated performance problems like those that can make your on-call cell phone ring too much! Do you think you have what it takes to find these “needle in the haystack” issues and resolve them quickly? This will be a highly interactive session where we will locate the rogue queries together, work through solutions, implement them and measure the results. In this episode we’ll focus primarily on improper indexing as a common underlying problem and all will walk away with much better troubleshooting skills and an upgraded knowledge of performance tuning!

Speaker(s):

Jim Murphy

Track and Room: DBA - Performance (1048) - N/A

Title: How To Build A SQL Server Virtual Lab On Your Own Machine

Abstract: As the number of SQL Server versions and features grow over time so does the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn’t enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up an AlwaysOn Availability Group? Or maybe you want to try out the latest features in SQL 2014…virtualization offers a convenient way to do any and all of these. In this session we’ll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual lab on your own machine.

Speaker(s):

Kendal Van Dyke

Track and Room: DBA - What’s New? (1047) - N/A

Title: SQL Server Internals and Architecture

Abstract: Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:

What are the various areas of memory inside of SQL Server?
How are queries handled behind the scenes?
What does SQL Server do with procedural code, like functions, procedures, and triggers?
What happens during checkpoints? Lazywrites?
How are IOs handled with regards to transaction logs and database?
What happens when transaction logs and databases grow or shrinks?

Speaker(s):

Kevin Kline

Track and Room: Auditorium (1124) - N/A

Title: Introducing Cube World To Users From Flat Table Land

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

Speaker(s):

Michael Antonovich

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

Title: From Query to Disk: Managing your queries, data distribution, and environment for best performance

Abstract: The ‘out of the box’ SQL Server installation and configuration is generally useless in an enterprise of any size and will lead to unbelievably poor query performance. In this hour we will discuss the basics of SQL Server deployment and configuration, the tools at your disposal to optimize query execution, and some tricks to make your queries perform at their best…all from the ‘magic wand’ approach where we start with ‘most optimal’ then adjust as necessary to suit the circumstances. Expect to learn a little bit of everything…from SQL Server deployment and configuration to indexing and statistics to stored procedures and functions to query design to database architecture.

Speaker(s):

Michael Reed

Track and Room: DBA - Performance (1048) - N/A

Title: We Don’t Need Roads:A Look Into SQL Server Indexes

Abstract: Have you ever ran a SQL against SQL Server and it was so slow that you wondered if the database was from 1955? You could use a Delorean or you can create indexes in your database. This session will introduce you to SQL Server indexes. Indexes are a powerful tool to improve the performance of our queries. We’ll discuss how indexes are structured and why they speed up queries, how INSERT, UPDATE, and DELETE queries are affected by indexes and how to identify if an index is necessary. Then, we’ll take a look at an Entity Framework application and see how EF reacts to our fresh new indexes. If you want to make bad query performance a thing of the past this session is for you.

Speaker(s):

Richie Rump

Track and Room: Development (3044) - N/A

Title: Detección de cambios para el desarrollo de Warehouses

Abstract: Observaremos las diferentes técnicas disponibles para realizar detección de cambios para el desarrollo de Warehouses, punto crítico dentro del proceso de desarrollo de ETL en un proyectos de BI a gran escala

Speaker(s):

Freddy Angarita

Track and Room: SQL en Espanol (3048) - N/A

Title: SQL Server 2014 in-memory OLTP Deep Dive

Abstract: SQL Server’s new In-Memory OLTP technology (codenamed ‘Hekaton’) promises to be one of the most exciting new features to be released when SQL Server 2014 ships. As a DBA you will have a number of questions surrounds it’s internals, how it should be administered and how it will impact you high-availability design. In this session In this demo-filled session we will discuss Hekaton from a DBA perspective. We will look at Hekaton’s architecture and internals, capacity planning considerations, administration considerations and how it impacts your high-availability design. He will also present some use cases and examples of where Hekaton can be used.

Speaker(s):

Scott Klein

Track and Room: Auditorium (1124) - N/A

Title: Performance Benefits of Data Compression

Abstract: Objective of session is to show with examples when and what and how and if to implement table compression. Session will review table compression as implemented for SQL Server and then dive into many examples including benchmarking. Come to the session to see the results – they were surprising to me!

Speaker(s):

Mike Byrd

Track and Room: DBA - Performance (1052) - N/A

Title: SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive

Abstract: Windows Azure gives you a choice in where to host your SQL data, with both SQL Server running in a VM and Windows Azure SQL database. Ongoing innovations in SQL/VM and SQL DB enable both low overall TCO for management of existing applications/services and an efficient platform for the new breed of cloud applications/services. Additionally the ability to mix and match existing and new applications in the same hosted service, and to integrate with on-premises applications and networks in hybrid models provides tremendous flexibility. This session will take a deep look at the best practices when provisioning and deploying a SQL Server in a Windows Azure Virtual Machine.

Speaker(s):

Scott Klein

Track and Room: SQL Azure (3046) - N/A

Title: SQL Server Foreign Keys – De-mystifying the Rest of the Story

Abstract: Foreign Keys have a bad rap – they cause performance issues, they inhibit some inserts, deletes and updates, etc. This may be true, but let’s further explore why we even have them and how they can benefit and maybe even improve performance. This session will concentrate on many demos including the attributes associated with foreign keys. The attendee will walk away from this session with a better understanding of Foreign Key utility and their maintenance.

Speaker(s):

Mike Byrd

Track and Room: DBA - Internals (1049) - N/A

Title: Desarrollo de modelos de minería de datos

Abstract: Desarrollo de un modelo para el mundo real de un modelo de minería de datos, técnicas estadísticas y consideraciones para el modelado

Speaker(s):

Freddy Angarita

Track and Room: SQL en Espanol (3048) - N/A

Title: Understanding Locking, blocking and deadlocks in SQL Server

Abstract: In this session, we will go through the SQL Server’s multigranular locking mechanism that allows different types of resources to be locked during a transaction, its impact on concurrency and what leads to blocks and deadlocks.

Speaker(s):

Sujai Karnam

Track and Room: DBA - Auditing Maint. (1053) - N/A

Title: What are you Waiting For?

Abstract: Using Wait Types and Response Time Analysis techniques is a often underutilized method for tuning SQL Server instances and applications. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the response time data is analyzed at the wrong level and is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server wait type data coupled with response time based performance analysis to solve the most difficult performance related issues.

Speaker(s):

Dean Richards

Track and Room: DBA - Performance (1052) - N/A

Title: Best Practices to Awesome Performance on VMware

Abstract: SQL Server on VMware??? Most of our customers have virtualized their application tier, and now are either virtualizing databases or planning to do so soon. Some companies have tried to virtualize databases on VMware, but went back to physical hardware because of performance issues. There are many reasons this may have happened, but quite often the decision to go back to physical was not based on hard facts. This presentation will explore the fundamentals of monitoring databases running in a VMware environment. If you are using classic O/S monitoring tools using standard Perfmon counters, you are getting misleading information. Understand which metrics are important and how to get the data.

Speaker(s):

Dean Richards

Track and Room: DBA - Performance (1048) - N/A

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

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

Speaker(s):

James McAuliffe

Track and Room: Development (3044) - N/A

Title: Change Tracking: A Near Bullet-Proof ETL Synchronization Control

Abstract: Change Tracking came out with SQL Server 2008, but SS2012 almost eclipsed it with Change Data Capture. Change Tracking is now the red-headed step child, but in most cases may be a better solution for data ETL movement from a SQL Server OLTP database to a data warehouse database. This session will provide a review of change tracking syntax and implementation with detailed demos. It will then dive into an actual ETL subset implementation from the AdventureWorks database to a data warehouse solution (modified AdventureWorksDW) with detailed code discussion and demos. Most of presentation is demos.

Speaker(s):

Mike Byrd

Track and Room: BI (3045) - N/A

Title: SQL Server 2014 Top 5 - Hybrid Features

Abstract: Microsoft SQL Server 2014 brings to market new capabilities to simplify cloud adoption and help you unlock new hybrid scenarios. This demo-filled session will highlight these top features and show how you can use these features to lower your TCO and help manage your mission-critical applications by leveraging the cloud by providing new disaster recovery and backup solutions.

Speaker(s):

Scott Klein

Track and Room: Auditorium (1124) - N/A

Title: Building the modern architecture of hybrid data for Big Data with Microsoft and Apache Hadoop

Abstract: The age of knowledge: Building the modern architecture of hybrid data for Big Data with Microsoft and Apache Hadoop Considering that knowledge is a value added for businesses today, in this exhibition show in a simple way as Microsoft and Hortonworks unite its efforts, in order to combine their data platforms (“Hortonworks Data Platform” and Microsoft: Windows, Office, SQL Server, Parallel Data Warehouse and Azure), to build with this, the modern architecture of data hybrid for Big Data. (Spanish session)

Speaker(s):

Jose Redondo

Track and Room: SQL en Espanol (3048) - N/A

Title: Indexing strategies and good physical designs for performance tuning

Abstract: Multiple index strategies to help improve database performance, Part of the topics covered in this session are:

Noncluster Coverage
Page Split
Heaps
Filtered Indexes
Clustered Indexes

Speaker(s):

Kenneth Urena

Track and Room: DBA - Performance (1052) - N/A

Title: Big Data: How To.. and Now What?

Abstract: In this session we will discuss what big data is, the options for where to deploy a Hadoop cluster, how to get and manipulate data, and basic analytics in the Hadoop environment, along with moving data in and out of a SQL Server environment.

Speaker(s):

Michael Reed

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

Title: Power BI for the masses

Abstract: Power BI enables business users across the enterprise to gain access to the data. They can use agile development tools to extract, store and visualize data. During this session, we will demonstrate the new BI development tools in Excel; Power Query, Power Pivot, Power VIew and Power Map. These reports will be published into Office365 Power BI site. This session will showcase these tools and talk about the infrastructure behind it.

Speaker(s):

Jason Virtue

Track and Room: BI (3045) - N/A

Title: Geospatial Data Types in SQL Server 2012

Abstract: The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, Lenni shows you how to integrate location-awareness into your own applications with the geometry and geography data types. We’ll explore the planar and geodetic spatial models, spatial markup languages such as WKT and GML, and then put these concepts to use as we build several useful demos, (e.g., Bing Maps integration). Demos show how to use the geospatial methods to easily calculate area, length, and distance, and project new shapes based on intersection and overlap. Attend this session and embrace spatial programming today!

Speaker(s):

Leonard Lobel

Track and Room: DBA - What’s New? (1047) - N/A

Title: Credit Card Security for the SQL DBA

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

Speaker(s):

Andy Warren

Track and Room: DBA - Auditing Maint. (1053) - N/A

Title: Inspector Insert And The Case Of The Mistaken IDENTITY

Abstract: Think you know everything about working with identity values? Think again - they’re not as straightforward as they seem! Follow along as Inspector Insert discovers the many ways to end up with a case of mistaken identity and learn how to make sure you’re working with the right identity values every time. Attendees will: - Understand how identity columns work - Understand all the ways to return identity values and what factors influence their accuracy. - Learn how to always be sure they’re working with the right identity values in TSQL.

Speaker(s):

Kendal Van Dyke

Track and Room: DBA - Auditing Maint. (1053) - N/A

Title: AlwaysOn - Finally, A usable ‘mirror’!

Abstract: In the past, High Availability and Disaster Recovery (HADR) had many limitations. Clustering and Mirroring are great, but the mirror/secondary database is not very usable since it is not online. Finally, AlwaysOn solves this limitation by merging both multi-node Clustering and mirroring. AlwaysOn also allows the secondary database to remain ONLINE, so we can use it for reporting purposes without resorting to a Snapshot! Come see this lively session with extensive demos of setting up, configuring and testing AlwaysOn. We’ll also test automatic fail-over using a real web app to see how well this feature works.

Speaker(s):

Jim Murphy

Track and Room: DBA - Internals (1049) - N/A

Title: Team Leadership Fundamentals

Abstract: Considering a promotion into management? This session will teach you the fundamental skills needed to effectively lead an IT team. Topics include motivational skills, communication skills and project/job tracking skills. Attendees will learn:

What are the fundamental ways that a new leader can build credibility and trust with their team?
What are the unique ways in which IT people are motivated?
How can a leader effectively communicate with their IT team using a variety of communication channels?
How steps can a leader take to ensure that their IT team is achieving optimum effectiveness?

Speaker(s):

Kevin Kline

Track and Room: Professional Dev (1054) - N/A

Title: Supercharge Microsoft BI with Pyramid Analytics

Abstract: Mark will show you how you can Supercharge your Microsoft BI with Pyramid Analytics “BI Office”. See how BI Office gives you the “freedom to” Scale, Maximize, Visualize, and Mobilize your business users with the new Version 5. Attendees will see how easy it is to go from Analytics to Dashboards and reports in just 45 minutes. Additionally Mark will show you the mobile dashboard offering on the new iPad Air.

Speaker(s):

Mark Scott

Track and Room: Auditorium (1124) - N/A

Title: Tips Tricks for dynamic SSRS Reports

Abstract: In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.

Speaker(s):

Pam Shaw

Track and Room: DBA - Performance (1052) - N/A

Title: Building an MDM Center of Excellence with MDS and Maestro

Abstract: Learn how to build an MDM Center of Excellence with Best Practices using extensive demo. The session will including building a complete sample customer domain including data quality, merge, match and deduplication, and business workflow.

Speaker(s):

Gene Webb

Track and Room: DBA - What’s New? (1047) - N/A

Title: TempDB Internals – part II

Abstract: This session, a continuation of part I - dives into Internal Objects, i.e., objects created implicitly by SQL Server engine to address SQL processing (worktable for aggregates, hashes; cursors; sorting; aggregations; common-table-expressions; etc.). Filled with demos this session will show these internal objects, and a myriad of tools including performance counters and DMVs to help you build your TempDB monitoring arsenal. A discussion on TempDB data files and their placement will complete this session

Speaker(s):

Sam Mesel

Track and Room: DBA - Internals (1049) - N/A

Title: Check Engine Lights

Abstract: Problem with Windows server, IO storage or SQL Server stopped your business dead in its tracks? Together we’ll explore “check engine lights” for your SQL Server warning you of pending doom. I’ll cover Performance Monitor, IO STACK, Dashboards, ErrorLogs, and DMVs to keep your server and SQL Server running smooth.

Speaker(s):

Chris Skorlinski

Track and Room: DBA - Performance (1048) - N/A

Title: TempDB Internals – part I

Abstract: TempDB is a central resource for all systems and for SQL Server engine itself. A non-optimally designed system can make heavy use of TempDB, which will become the bottleneck of SQL Server This session will discuss TempDB properties and characteristics, we will cover SQL Server startup process and its dependencies on TempDB, options and settings that can be configured, and trace flags that can be used. The session will then put focus into User Objects, i.e., objects created explicitly by T-SQL code (temporary tables, table variables, temporary stored procedures, and so forth.. ). Tools and code Techniques will be shown to monitor and minimize impact on TempDB. This session is heavily based on demos

Speaker(s):

Sam Mesel

Track and Room: DBA - Internals (1049) - N/A

Title: Powershell Working with Windows Azure SQL Database Server

Abstract: In this presentation I will be covering how to subscribe to Azure, setup PowerShell to connect your subscription, use scripting to create a SQL Database Server and then use SMO with PowerShell push data to your SQL Azure tables. All this using PowerShell scripting plus showing some editor, scripting techniques, and tips to avoid issues when working and setting Azure with PowerShell. (Live demo with Windows Azure)

Speaker(s):

Maximo Trinidad

Track and Room: SQL Azure (3046) - N/A

Title: Your Best Interview Ever

Abstract: Presented by Chris Skorlinski with a collection of tips from 20 years of interviewing new hire candidates at Microsoft. He’ll cover techniques for building your résumé and key strategies during interviews, whether via phone, Skype, or in-person, to increase your chances for a new job and a new adventure.

Speaker(s):

Chris Skorlinski

Track and Room: Professional Dev (1054) - N/A

Title: Database Tuning Advisor - When to use it - When not to trust it.

Abstract: How and when to use Database Tuning Advisor. The goal is improved database performance. This session focuses on demos of DTA: how to use it, how to interpret and implement results, and advice on making the best use of DTA. It also covers when to use DTA as well as the pitfalls of DTA and when to avoid it. There will be real-world result statistics of performance improvement, and lots of demos.

Speaker(s):

Ernest Ostrander

Track and Room: DBA - Internals (1049) - N/A

Title: Exam Prep 70-461: Querying with SQL Server 2012

Abstract: Attendees will be guided through the content they need to master to pass exam 70-461, be exposed to the new types of questions to expect in the exam, and learn tips and tricks from exam addict Telmo Sampaio.

Speaker(s):

Telmo Sampaio

Track and Room: Professional Dev (1054) - N/A

Title: Native File Streaming with SQL Server 2012

Abstract: In this dynamic session, Lenni will teach you the ins-and-outs of unstructured data storage and native file streaming with FILESTREAM (introduced in SQL Server 2008) and FileTable (new in SQL Server 2012). Learn how to program FILESTREAM using T-SQL and, for maximum performance, using the OpenSqlFileStream API in C#. We’ll also cover the hierarchyid data type, which casts a hierarchical structure over every FileTable, and wrap up with the full-text search improvements and new Statistical Semantic Search in SQL Server 2012 that you can leverage to get the most out of unstructured documents contained in your databases.

Speaker(s):

Leonard Lobel

Track and Room: DBA - What’s New? (1047) - N/A

Title: 5 Common SQL Server Performance Issues

Abstract: I spend a large portion of each day looking through performance reports and dashboards from various organizations around the world. I’ve identified some very common performance problems and/or misunderstandings that tend to have easy, though not always obvious, solutions.

I intend to share the whys and hows of these issues with anyone who would like to attend during a SQLSaturday session.

Speaker(s):

Jason Hall

Track and Room: DBA - Performance (1048) - N/A

Title: Maintenance and Backups: Intro to Ola Hallengren

Abstract: This session will provide an overview of the critically acclaimed SQL Server Maintenance Solution written and maintained by Ola Hallengren. If you’re using Maintenance plans, you’re started in the right direction, but Ola’s solution is the Gold Standard for Maintenance scripts. We will review the options and show you how these scripts can leave you more at ease with your backup, database and index maintenance duties.

Speaker(s):

Jason Carter

Track and Room: DBA - Auditing Maint. (1053) - N/A

Title: Introduction to SSIS with BIML

Abstract: Do you ever find yourself repeating the same steps over and over while developing ETL packages? BIML is an XML markup language that automates your BI patterns and reduces the manual repetition that consumes most of your development time. In this session we will learn the basics of BIMLScript and show you the benefits of creating and automating an SSIS framework.

Speaker(s):

Guillermo Caicedo Santiago

Track and Room: BI (3045) - N/A

Title: 5 TSQL Commands I’ve Been Missing

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

Speaker(s):

Jason Carter

Track and Room: Development (3044) - 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 develo9pment 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.

Speaker(s):

Michael Antonovich

Track and Room: BI (3045) - N/A

Title: Choose your own adventure, be a SQL consultant

Abstract: This non-technical talk will explore how you can create new options for your career as a DBA, SQL developer or any other I.T. profession. Drawing from the speaker’s own story of experiences and observations in the field, we will discuss what makes a good consultant, how to get started working for yourself, and how to grow your technical skills, your business skills, and your own potential.

Speaker(s):

David Cobb

Track and Room: Professional Dev (1054) - N/A

Title: HDInsight utilizando Hadoop + SQL con análisis en Excel

Abstract: En esta sesión veremos los aspectos básicos de Hadoop y su instalación en Windows, además se explora la integración entre Hadoop y SQL Server mediante SSIS y cómo se pueden consultar los datos analizados desde Excel, esto con el fin de realizar cuadros de análisis de Big Data.

Speaker(s):

Eduardo Castro

Track and Room: SQL en Espanol (3048) - N/A

Title: Exam Prep 70-462: Administering Microsoft SQL Server 2012 Databases

Abstract: Attendees will be guided through the content they need to master to pass exam 70-462, be exposed to the new types of questions to expect in the exam, and learn tips and tricks from exam addict Telmo Sampaio.

Speaker(s):

Telmo Sampaio

Track and Room: Professional Dev (1054) - N/A

Title: Show me whatcha workin’ with: Big Data Edition

Abstract: Congratulations. You’ve setup your Big Data environment with all the fun toys. You have Pig, Sqoop, and Hive all on your Hadoop cluster. You even got your data flowing in there properly. Now what? In this session we’re gonna go over Data Mining tools to help you gain some insight from your data. Then, to bring it all together, we’ll go over some easy ways to use common tools to show off all of this Big Data of yours, using tools that most have access to.

Speaker(s):

Josh Luedeman

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

Title: Excel in SQL Reporting

Abstract: Did you watch Seinfeld and dream of being an IMPORTER / EXPORTER? Do your accountants, managers an other end users need their reports in excel? You don’t need Vandelay Industries! Learn how to extract data directing into excel from SQL and other databases. Get out of the importing and exporting of data, and create useful SQL reports right from Excel that users can update and even modify themselves!

Speaker(s):

Perry Patterson

Track and Room: SQL Azure (3046) - N/A

Title: Breakthrough Data Platform Performance with SQL Server 2014

Abstract: This session covers the following topics: evolution of the data platform, mission critical performance, faster insights from any data, platform for hybrid cloud and complete data platform. SQL Server 2014 will go GA and be the first ones to see the new release.

Speaker(s):

Jason Virtue

Track and Room: DBA - What’s New? (1047) - N/A

Title: Azure Table vs. Azure SQL Database

Abstract: Let’s take a deep dive into both storage options: no-sql Azure Table, and SQL Azure. We will review many aspects of both storage models, including performance, security, programming surface and more.

Speaker(s):

Herve Roggero

Track and Room: SQL Azure (3046) - N/A

Title: Tablas Particionadas: De la A a la Z

Abstract: En esta sesión discutiremos las estrategias de uso para las tablas particionadas, su impacto y cómo implementarlas, ventajas y desventajas, y como se trabaja con el mantenimiento de las ventanas corredizas. Además, compararemos las mejoras que ha tenido esta funcionalidad desde SQL Server 2008 hasta SQL Server 2014. Al final de esta sesión, tendrás toda la información necesaria para poder tomar ventaja de esta funcionalidad en tu ambiente de trabajo.

Speaker(s):

Jose L. Rivera

Track and Room: SQL en Espanol (3048) - N/A

Title: Keep your sanity by using Policy Based Management to implement standards

Abstract: In this session we will review the basics of Policy Based Management, what you get out of the box and how you can build policies that extend beyond the built in facets. We will take a look at some advanced policies using WMI to get OS configuration information such as Power Configuration and TSQL to read configuration information such as the last time CheckDB was run for a database.

Speaker(s):

Pankaj Satyaketu

Track and Room: DBA - Auditing Maint. (1053) - 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.

Jim Murphy

Twitter: - http://www.twitter.com/sqlmurph

LinkedIn: Jim Murphy

Contact: http://sqlwatchmen.com/blogs/jim/

Jim Murphy has been using Microsoft SQL Server since version 6.0 back in the 90#39;s. He is the CEO of SQLWatchmen, LLC., a managed DBA service provider. He runs the Austin SQL Server User Group: CACTUSS Central. He has been a professional DBA and developer for over 25 years and has run a consulting company full time since 2001.

Freddy Angarita

Twitter: - @flacMVP

Contact: http://geeks.ms/blogs/fangarita

Ingeniero de Sistemas de la Universidad Industrial de Santander. Experto certificado en tecnolog#237;as .Net (Windows, Web, M#243;viles), Implementaciones Orientadas a Servicios, Bases de datos SQLServer e Inteligencia de Negocios. Dise#241;ador, Desarrollador y Consultor para creaci#243;n, actualizaci#243;n, integraci#243;n, an#225;lisis o intervenci#243;n de aplicativos para el #225;mbito p#250;blico y privado. Speaker de Eventos Microsoft desde 2006. Director y editor del cap#237;tulo Sql Pass de Medell#237;n.

Sujai Karnam

Sujai Karnam is a Data Architect at Campus Management. He has over 13 years of experience in the software product development community, developing CRM and SIS products with the underlying MS SQL Server database.

Jim Murphy

Twitter: - http://www.twitter.com/sqlmurph

LinkedIn: Jim Murphy

Contact: http://sqlwatchmen.com/blogs/jim/

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!

Dean Richards

Dean Richards is a Manager of Sales Engineering and has helped hundreds of companies solve database and virtualization performance issues. Dean has over 20 years of experience in both development and database administration and has focused his entire career on performance tuning of Oracle and SQL Server environments. Most recently Dean has focused on the trend to virtualize databases while still achieving high performance.

Mark Scott

Twitter: - @usamjscott

LinkedIn: Mark Scott

Contact: http://www.pyramidanalytics.com/Pages/blog/Authors/mark-scott.aspx

Mark has over 20 years of consulting, managing, delivering, and selling in both private and public companies all over the US. Prior to joining Pyramid, he held consulting and sales leadership positions at Microsoft delivering and selling BI and Data Warehousing solutions to large enterprise accounts. In his spare time - Mark enjoys traveling and spending time with his wife, and two sons age 4 and 6!

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.

Jason Carter

Twitter: - TampaDBA

Contact: http://jason-carter.net

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

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.

Joe Homnick

Twitter: - @SmokingJoe

LinkedIn: Joe Homnick

Contact: http://joeblog.homnick.com/

Joe Homnick is a Microsoft Regional Director since the start of the program over 20 years ago and is a principal owner of Homnick Systems (HSI), a Microsoft Gold Certified Partner located in Boca Raton, Florida. HSI is one of the most established Microsoft Certified Partners in the world, dating back to the beginning of the program in 1993. HSI delivers Microsoft services in the areas of system development and implementation through software consulting, development, training and mentoring.

Dean Richards

Eduardo Castro

Twitter: - edocastro

LinkedIn: Eduardo Castro

Contact: http://ecastrom.blogspot.com

Eduardo Castro, Microsoft Data Platform MVP and PASS Board of Advisor for LATAM, is well known LATAM SQL Server Expert and focuses on architecture, Business Intelligence and Data Analytics, Eduardo has an specialization and master degree in Data Analysis and Big Data. I have been speaker at PASS Summit delivering session about R and Data Science.

Eduardo Castro has presented in United States, Costa Rica, Colombia, Guatemala, Mexico, Panama, El Salvador and South Korea.

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.

Jason Hall

Twitter: - @SQLSaurus

LinkedIn: Jason Hall

Contact: http://blogs.sqlsentry.com/jasonhall

Jason Hall (@SQLSaurus) leads SentryOne’s Product Management team, which is responsible for managing product design, development and delivery.

Jason has worked in varied technology roles for over 20 years and holds industry certifications including MCSE (legacy), MCSD, MCTS, MCPD, and PMC-III.

Freddy Angarita

Twitter: - @flacMVP

Contact: http://geeks.ms/blogs/fangarita

Jose Redondo

Jose Redondo, SQL Server MVP and MCITP SQL Server, is an Information Technology System Business Consultant, who also designs and develops Database Data Warehouse. He has worked as a consultant for more than 20 years. He enjoys solving business problems for customers in different areas.

He has worked with MS SQL Server from version 4.2, both OLTP and OLAP. He has been involved with technology communities, and especially with SQL Server since 2007 when it was called to create the SQL PASS Community Venezuela - Caracas Chapter in 2009. He has also participated in the SQLSaturday as volunteers and speaker.

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

Kenneth Urena

Twitter: - @sqlcr

LinkedIn: Kenneth Urena

Contact: http://www.sqlcr.com

Kenneth Ureña is an experienced technologist with 17 years of experience, including 14 years of experience in SQL server. He has worked on versions from SQL Server 7.0 to SQL server 2016.

Kenneth has performed the role of Database Developer, Database Architect and Database Administrator, always relying on his disaster recovery and performance tuning skills.

He co-leads the Global Spanish Virtual chapter of PASS. PASS LatAm Regional Mentor, he speaks at multiple SQL Server events in both Spanish and English. Kenneth holds multiple SQL server certifications.

Perry Patterson

LinkedIn: Perry Patterson

Contact: http://www.facebook.com/3Deers

3Deers.com, LLC is an independent consulting firm based on Coral Springs, FL. We work with and teach organizations how they can better manage their business through expertise in SQL Business Intelligence Reporting, Web Site Development and Project Management.

After 30 years of Information Technology Management for corporations in a variety of fields, Perry T Patterson formed 3Deers to help growing business and charitable organizations improve their efficiency, professionalism and visibility.

David Pless

Twitter: - @dpless

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

For the past nine years, I have been a Technical Solution Professional with Microsoft. As a TSP I conduct full training workshops, conduct demo sessions, and perform architectural reviews on all supported builds of SQL Server. I mainly support the Southeast focusing on Florida, but I can be anywhere in the world.

My core areas are Performance Tuning and Optimization, Azure, AlwaysOn, Reporting Services (SSRS), custom monitoring, building custom dashboards, and more.

Jason Virtue

Jason Virtue, BI Technology Solution Specialist for Microsoft who covers the Greater Southeast District region. Jason has worked in the BI industry for 20 years for management consulting firms and Fortune 500 companies. He has worked as a BI architect and delivered multiple BI platforms across various businesses. His technology and real-world experience helps him advise client on best practices in the data warehouse industry

David Cobb

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

LinkedIn: David Cobb

Contact: http://daveslog.com

David Cobb is a Systems Architect for CheckAlt Payment Solutions, providers of automated and electronic check transaction processing since 2005. He is a Microsoft Certified Trainer, with MCSE Data Platform certification for SQL 2012, training people on SQL Server since 2002. David is also the principal consultant for Cobb Information Technologies, Inc, founded in 1996, providing technology consulting with a focus on SQL Server.

Leonard Lobel

Twitter: - @lennilobel

LinkedIn: Leonard Lobel

Contact: http://lennilobel.wordpress.com

Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner.

Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences.

Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.

Leonard Lobel

Twitter: - @lennilobel

LinkedIn: Leonard Lobel

Contact: http://lennilobel.wordpress.com

Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.

Andy Tabisz

Twitter: - @AccessWisdom

LinkedIn: Andy Tabisz

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

Andy Tabisz is a Microsoft MVP and owner of WorkSmart Database Masters based in Grand Rapids, MI. WorkSmart provides custom database and mobile solutions for small to mid-sized corporations using Access, SQL/Azure, ASP.NET, SharePoint, Power BI, Excel and integration with many technologies. Through rapid application development, WorkSmart empowers organizations to work smarter and make better decisions by automating workflow, alerts and reporting capabilities.

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.

Telmo Sampaio

Telmo Sampaio is an MCT, MCSE, MCSD, and an MCT Regional Lead. He is the “Chief Geek” for MCTrainer.NET and TechKnowLogical. Telmo specializes in the System Center, Microsoft SharePoint®, Microsoft SQL Server®, and .NET, and has worked for IBM, Microsoft, and several start-ups during the past 20 years. He is very active in the MCT community, and travels the world providing consulting services and attending training engagements.

Kevin Kline

Twitter: - kekline

LinkedIn: Kevin Kline

Contact: http://blogs.sentryone.com/author/kevinkline

Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.

Telmo Sampaio

Kevin Kline

Twitter: - kekline

LinkedIn: Kevin Kline

Contact: http://blogs.sentryone.com/author/kevinkline

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.

Chris Skorlinski

Chris Skorlinski has been with Microsoft for 17 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting Replication. His is a contributor to SQLShare.com training as well as his own BLOGs on Replication Performance at http://blogs.msdn.com/ReplTalk/. #160;

Michael Reed

LinkedIn: Michael Reed

I have been working with SQL Server for 14 years, have a background in business, worked in the Microsoft Online Services Division, Behavioral Targeting group, am employed by Pragmatic Works as a Senior BI Consultant. I am studying Data Science through online certificate programs and bring this experience to my presentations. I am particularly interested in how to apply Big Data to solve business problems.

Scott Klein

Twitter: - SQLScott

Contact: http://aka.ms/sqlscott

Chris Skorlinski

Michael Reed

LinkedIn: Michael Reed

Shehab El-Najjar

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

LinkedIn: Shehab El-Najjar

Contact: http://sqlserver-performance-tuning.net/

Shehab El-Najjar was the ONLY Microsoft SQL Server MVP in Gulf for the past 6 years and the 2nd one all over the Middle East , he is the founder of SQL Gulf events series (SQL Gulf #1 , #2 and #3 ) where he spent so much time and efforts to broadcast Microsoft SQL Server technologies all over the Gulf such as KSA and Emirates and other Gulf cities ahead ..)

 He is now Professional Services Manager at Saudi Emircom

 He was previously COO and business leader in KSA market through his startup WAJA IT for 3 years

 He is an influencing Database community leader all over the region  A senior Database Consultant (SQL Server MVP for 6 years in row) -The 2nd MVP awardee SQL Server all over Middle East and Arabic region

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.

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.

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.

Sam Mesel

will be provided later on

Mike Byrd

Twitter: - ByrdNest_TX

LinkedIn: Mike Byrd

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

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

Jason Carter

Twitter: - TampaDBA

Contact: http://jason-carter.net

Scott Klein

Twitter: - SQLScott

Contact: http://aka.ms/sqlscott

Gene Webb

Gene Webb is a Regional Sales Executive with The Profisee Group based in Alpharetta Georgia. Profisee is the successor to Stratature the company that built Master Data Services (MDS) and sold the product to Microsoft in 2007. Profisee focuses around Master Data Management (MDM) and as a Gold ISV provides solution sets built on MDS and the Microsoft Stack. Gene spent 7 years working at Microsoft as a SQL Server and Developer Tools solution specialist and an ISV Developer Evangelist

Shehab El-Najjar

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

LinkedIn: Shehab El-Najjar

Contact: http://sqlserver-performance-tuning.net/

 He is now Professional Services Manager at Saudi Emircom

 He was previously COO and business leader in KSA market through his startup WAJA IT for 3 years

Guillermo Caicedo Santiago

Twitter: - @sqltitan

LinkedIn: Guillermo Caicedo Santiago

Contact: http://www.sqltitan.com

Guillermo Caicedo es un profesional de bases de datos y tecnolog#237;a trabajando como Consultor en Nagnoi, LLC. Ha ayudado a numerosas empresas a obtener conocimiento sobre sus datos por desarrollar e implementar soluciones de inteligencia empresarial en sus organizaciones. El Sr. Caicedo tambi#233;n tiene una amplia experiencia desarrollando aplicaciones web y m#243;viles. Guillermo es un Data Platform MVP y l#237;der del Cap#237;tulo PASS para Puerto Rico (PRPASS).

Sam Mesel

will be provided later on

Ernest Ostrander

Contact: http://eostrander.wordpress.com/

Ernest Ostrander lives in Bogota, Colombia, and is Manager of Business Analytics at MasTec. His career started at FedEx, and continued with 14 years of consulting with a Microsoft Solution Provider. First certified in SQL 7, he has worked with the full Microsoft BI stack and a variety of other technologies.

Frank Quintana

Twitter: - Frankqr2

LinkedIn: Frank Quintana

Contact: http://www.businessintelligencematters.us

Doctor Quintana has been involved in optimization and math modeling since the ’80s. He is an IT University professor of Data Science, Databases, Data Mining, and Knowledge Discovery. He is a former head of an RD department. He worked as a research engineer at the Memorial University of Newfoundland. He also worked as a consultant in the role of a technical team leader and software architect for EDS responsible for critical parts of the SDLC for multi-million dollar projects. He is one of the Software Architects that designed and built the “Health and Benefits System for the of the Veteran Affairs of Canada” He is a regular speaker at national and international events In 2004 he started his consulting practice in South and Central Flori

Mike Byrd

Twitter: - ByrdNest_TX

LinkedIn: Mike Byrd

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

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

Pankaj Satyaketu

Twitter: - @SQLPS

Contact: http://www.sqltwist.com

Pankaj Satyaketu is a Solutions Sales Manager based out of South Florida focused on driving Data Workloads to Azure. Pankaj has also held several positions within Microsoft focused on Microsoft’s Flagship Database Engine, SQL Server.

Prior to joining Microsoft Pankaj was the Lead DBA for a major retailer out of South Florida responsible for managing and maintaining their database systems globally. Pankaj has 13+ years of experience with SQL Server in the areas of High Availability and Disaster Recovery, performance tuning, hybrid cloud migrations along with overall administration and automation.

Pankaj is an active supporter of local user groups and SQLSaturday events in Florida. He is also a graduate of Florida Atlantic University.

Jason Virtue

Jose L. Rivera

Twitter: - SQLConqueror

LinkedIn: Jose L. Rivera

Contact: http://sqlconqueror.com

Jose L. Rivera is a seasoned data professional, speaker, homebrewer, trainer (former MCT), Data Platform MVP and community leader based in Puerto Rico working as Senior Financial Analyst for MCS. He shares his knowledge and experiences throughout his community work as Chapter Leader for the PASS Global Spanish VC (facebook.com/SpanishPASSVC), Vice-President of the Puerto Rico PASS (prpass.org), Mentor of GDG Puerto Rico (facebook.com/gdgpuertorico) and LATAM Regional Mentor at PASS. Jose L is a frequent speaker in SQLSaturday events throughout US and Latin America. He loves data, analytics, teaching, learning, having fun with his family, craft beer (a lot) and everything in between.

Michael Antonovich

Twitter: - @SharePointMikeA

LinkedIn: Michael Antonovich

Contact: http://sharepointmike.wordpress.com

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.

Josh Luedeman

Twitter: - http://www.twitter.com/joshluedeman

LinkedIn: Josh Luedeman

Contact: http://www.joshluedeman.com

Josh is a Sr FastTrack Engineer with the FastTrack team in the Azure Engineering Group at Microsoft. Josh focuses on Microsoft’s Cloud Scale Analytics Solutions in Azure using products like HDInsight, Data Lake, Data Factory, and DataBricks. He has worked in IT for over 10 years holding positions in Application Support, Database Administration, and Business Intelligence, in industries like Higher Education, Consulting, Manufacturing, and Software Development.

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

SQLSaturday #288 - South Florida 2014

Sessions

Title: Creating Access 2013 Web Apps in SQL Azure using SharePoint

Title: REAL WORLD REPORT SERVER PERFORMANCE SOLUTIONS AND STRATEGIES

Title: The DW and Big Data Architecture

Title: Performance dreams wait for you at SQL Server 2014

Title: Change Data Capture a developer’s unknown best friend

Title: T-SQL Performance Guidelines for better DB stress powers

Title: Business Intelligence Features in SQL Server 2014

Title: Mission Possible: Interactive Performance Troubleshooting - Indexes

Title: How To Build A SQL Server Virtual Lab On Your Own Machine

Title: SQL Server Internals and Architecture

Title: Introducing Cube World To Users From Flat Table Land

Title: From Query to Disk: Managing your queries, data distribution, and environment for best performance

Title: We Don’t Need Roads:A Look Into SQL Server Indexes

Title: Detección de cambios para el desarrollo de Warehouses

Title: SQL Server 2014 in-memory OLTP Deep Dive

Title: Performance Benefits of Data Compression

Title: SQL Server HA and DR in a Windows Azure Virtual Machine – Deep Dive

Title: SQL Server Foreign Keys – De-mystifying the Rest of the Story

Title: Desarrollo de modelos de minería de datos

Title: Understanding Locking, blocking and deadlocks in SQL Server

Title: What are you Waiting For?

Title: Best Practices to Awesome Performance on VMware

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

Title: Change Tracking: A Near Bullet-Proof ETL Synchronization Control

Title: SQL Server 2014 Top 5 - Hybrid Features

Title: Building the modern architecture of hybrid data for Big Data with Microsoft and Apache Hadoop

Title: Indexing strategies and good physical designs for performance tuning

Title: Big Data: How To.. and Now What?

Title: Power BI for the masses

Title: Geospatial Data Types in SQL Server 2012

Title: Credit Card Security for the SQL DBA

Title: Inspector Insert And The Case Of The Mistaken IDENTITY

Title: AlwaysOn - Finally, A usable ‘mirror’!

Title: Team Leadership Fundamentals

Title: Supercharge Microsoft BI with Pyramid Analytics

Title: Tips Tricks for dynamic SSRS Reports

Title: Building an MDM Center of Excellence with MDS and Maestro

Title: TempDB Internals – part II

Title: Check Engine Lights

Title: TempDB Internals – part I

Title: Powershell Working with Windows Azure SQL Database Server

Title: Your Best Interview Ever

Title: Database Tuning Advisor - When to use it - When not to trust it.

Title: Exam Prep 70-461: Querying with SQL Server 2012

Title: Native File Streaming with SQL Server 2012

Title: 5 Common SQL Server Performance Issues

Title: Maintenance and Backups: Intro to Ola Hallengren

Title: Introduction to SSIS with BIML

Title: 5 TSQL Commands I’ve Been Missing

Title: Hello, My Name Is DAX

Title: Choose your own adventure, be a SQL consultant

Title: HDInsight utilizando Hadoop + SQL con análisis en Excel

Title: Exam Prep 70-462: Administering Microsoft SQL Server 2012 Databases

Title: Show me whatcha workin’ with: Big Data Edition

Title: Excel in SQL Reporting

Title: Breakthrough Data Platform Performance with SQL Server 2014

Title: Azure Table vs. Azure SQL Database

Title: Tablas Particionadas: De la A a la Z

Title: Keep your sanity by using Policy Based Management to implement standards

Speakers

Sponsors