SQLSaturday #524 - South Florida 2016

Event Date: 06/18/2016 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: Architecting virtual SQL server for performance

Abstract: Today, many enterprise organizations have already virtualized most of their non critical applications, these organizations are now employing a “Virtual First” policy, harnessing the efficiency and cost savings of virtualization for their most critical applications. Still, many IT architects and DBA’s are hesitant of virtualizing their SQL workloads, they are worried about performance, scale, availability and support for what is usually considered their most critical applications. In this session we will review the guidance for successfully virtualizing critical SQL databases, we will cover the best practices, real world customer experience and what to watch out for when virtualizing the most critical SQL databases. The session is delivered by the author of the official SQL server on VMware best practices guide.

Speaker(s):

Niran Even-Chen

Track and Room: Enterprise Database Administration Deployment - DBA (Rm 2071)

Title: Scaling for best performance: Partitioned views.

Abstract: Partitioning has long been one of the key feature sets utilized to improve performance or reduce contention within our large tables in SQL Server. However, table partitioning has been solely the prerogative of SQL Server Enterprise edition. Even though that is correct, there are techniques available to us in Standard edition which would accomplish the same result as table partitioning.

In this session we will go through the steps needed to configure and use the partitioned views to achieve the same result as table partitioning. We will also configure the maintenance jobs to imitate the sliding window functionality, and for those of us who are lucky to have Enterprise edition, we will see how to be able to take advantage of combining both partitioned views and table partitioning as well as inMemory tables to give us an ability to use double partition elimination based on two different keys as well as the ability to move hot spots data into inMemory OLTP.

Speaker(s):

Konstantin Melamud

Track and Room: Enterprise Database Administration Deployment - Performance Tuning (Rm 2072)

Title: How SQL is helping to connect Cuba to the Web for free

Abstract: Salvi works on a non-profit that connects thousands of Cubans to the web, via email. In Cuba, 25% of the population can access to email only, while 5% access to the Web without restrictions. After three years of work, his non-profit organization has collected several gigs of data that can re-shape our understanding about Cuba.

Salvi will show data collected by this great technology, and how fascinating can be interpreting row information from a country that has been censored internally and externally for generations . The audience will have a unique opportunity to learn this technology, access this data and to use their skills to make a worldwide impact.

Speaker(s):

Salvi Pascual

Track and Room: Analytics and Visualization - Professional Developement (Rm 3044)

Title: The Phenomenal IT Consultant

Abstract: Whether you are just starting out or have been in business as an IT consultant for a while, if you desire more clients or wonder how to finally achieve success online, you are not alone. In this session we’ll cover how to identify your target market and your niche. You will learn why a strong brand is vital to your success. You will discover how to make your ideal client want to work with you and pay you what you are worth, even if you hate the selling part. This session is for you…

if you are struggling to find enough new clients,
if you feel like you are the best-kept secret in your field or if prospects love you but don’t buy from you,
if you feel like you are treading water when it comes to marketing. Join this session and get started on your way to becoming a Phenomenal IT Consultant.

Speaker(s):

Sebastian Meine

Track and Room: Professional Development - Professional Developement (Rm 3044)

Title: Seamlessly Scaling Azure SQL DB with Elastic Database Tools

Abstract: Elastic Database Tools for Azure SQL DB offers a set of features that make it easier to build and manage a scaled-out data tier for cloud applications. With elastic database tools, applications can easily access data spanning multiple DBs, coordinate management tasks and manage how data is distributed among them. As part of the session, we explore workloads that are a natural fit for Azure SQL DB’s elastic database tools. Patterns discussed in depth include multi-tenant applications created by cloud ISVs and SaaS vendors, and applications relying on temporal data distribution. The session will illustrate how easy it is now to build, scale and manage cloud applications in SQL DB when using elastic tools capabilities such as the elastic database client library for .NET.

Speaker(s):

Silvia Doomra

Track and Room: Cloud Application Development Deployment - Azure /Big Data (Rm 2066)

Title: Advance Analytics with SQL Server R Services

Abstract: SQL Server R Services provides a platform for developing intelligent applications that uncover new insights. In this session we will show how to get started with SQL Server R Services to operationalize R solutions or to create powerful data exploration and predictive modeling solutions.

Speaker(s):

Jose L. Rivera

Track and Room: Advanced Analysis Techniques - BI/SSAS (Rm 2065)

Title: Turbo Boost Performance: In Memory Tables index optimizations

Abstract: With the introduction of in-memory based tables in SQL Server 2014, it’s natural to expect significant increases in query performance. But what do we do when queries which utilize in-memory tables actually start to perform same or, in some cases, even worse than their equivalent disk based table predecessors? In this session, we are going to take a look at the changes to the indexing design for in-memory based objects and how it differs from existing disk based table indexing. Also, we are going to cover how to choose the appropriate indexes for your in-memory object to give you the performance boost that you have been expecting.

Speaker(s):

Konstantin Melamud

Track and Room: Enterprise Database Administration Deployment - Performance Tuning (Rm 2072)

Title: Build ETL efficiently (10x) with Minimal Logging

Abstract: This session is designed to teach DBAs and developers the best strategy to transfer large data.

We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode.

Speaker(s):

Simon Cho

Track and Room: BI Platform Architecture, Development Administration - BI/SSIS (Rm 2074)

Title: Query Data Store

Abstract: Analyzing query performance can be tricky. It involves knowing several dynamic management views (DMVs) and accessing query plans that are still in the query cache. If you need to get performance metrics for a query which is no longer in the cache, or if your server is restarted it will be an impossible task. Query Data Store is a new feature that comes to help DBAs. By persisting query execution data over time, it allows reviewing of statements / plans / properties / statistics. This session will show you how to enable and use QDS features, like: obtaining queries with plan changes over time; analyze queries by CPU / Memory / other counters; forcing a plan; and other gems.

Speaker(s):

Sam Mesel

Track and Room: Application Database Development - SQL 2016 Discovery Day (Rm 3045)

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 - DBA (Rm 2071)

Title: Developing an End to End Power BI Solution

Abstract: Power BI has a many moving parts that can make it difficult to know when and where each part of the tool is necessary. In this half day session get a clear end to end journey through creating a Power BI solution. Start with the data discovery phase by importing and applying business rules to your data. Then load that data into a data model where you can apply hierarchies and calculations. Finally using that data model design reports to visualize the results. Once complete learn how the results can be shared with others by creating dashboards on the Power BI service. Taking this end to end trip through the tool will allow you to fully understand how each piece fits together.

Speaker(s):

Devin Knight

Track and Room: BI Information Delivery - Power BI/more (Rm 2073)

Title: What’s new in SQL Server 2016

Abstract: In this session we will be reviewing the highlights of what’s new with SQL Server 2016. I will also be demonstrating several of the hero features in SQL Server 2016 such as Always Encrypted, Operational Insights, Polybase, Hybrid Cloud and much, much more.

Speaker(s):

Pankaj Satyaketu

Track and Room: Enterprise Database Administration Deployment - SQL 2016 Discovery Day (Rm 3045)

Title: MongoDB for SQL Developers and Accessing MongoDB with SSIS

Abstract: Just because NoSQL is taking off doesn’t mean that SQL developers are left behind. We’ll begin with an overview of what MongoDB and NoSQL is and how it relates to our existing world of SQL. Then, we’ll go over some of terminology in MongoDB and how these terms map to the SQL world. Lastly, we’ll demonstrate how we can work with MongoDB from SSIS.

Speaker(s):

Ben Galluzzo

Track and Room: BI Information Delivery - Developers (Rm 2067)

Title: A SQL Developer’s Guide to MDX Basics

Abstract: You already know how to write SQL queries against a data warehouse but your new job responsibilities require you to write MDX queries against Analysis Services (SSAS). MDX is the query language of SSAS in multidimensional mode. While SQL and MDX share some common keywords, they have very different syntax and concepts. In fact, the common keywords can be confusing if you are used to thinking in SQL.

In this session you will explore how data is organized in SSAS in a data structure called a cube. Next, we will write MDX queries while comparing them with SQL queries that return similar results. You will see how certain queries are much easier to write in MDX, especially when it comes to querying data that contains hierarchies such as a date rollup. Finally, you will learn how to capture MDX queries generated by Excel, SQL Server Management Studio and other third party tools, to use as practical examples of how to write MDX queries.

Speaker(s):

Shabnam Watson

Track and Room: BI Platform Architecture, Development Administration - BI/SSAS (Rm 2065)

Title: Becoming Certified in SQL Server 2012/2014

Abstract: Becoming certified in SQL Server is a great career move and can be very rewarding for a new or seasoned database professional. This session will provide you with an overview of the SQL Server Certification program, including the changes made to the program for certification on SQL Server 2012 and 2014. You’ll also discover the benefits of becoming certified, and some of the best ways in which to do so. You’ll leave the session armed with great tips and tricks to pass the exams on the first try. If you are thinking about getting certified in SQL Server in the near future, then this session is definitely for you.

Speaker(s):

Marilyn Rousseau

Track and Room: Professional Development - Professional Developement (Rm 3044)

Title: Who’s Afraid of Entity Framework?

Abstract: Do any applications in your environment use SQL written not by a person but by the application itself? No, the system isn’t self-aware. Chances are it is using the Microsoft Entity Framework (EF).

EF and other object relational mapping technologies have been a boon for developers. But is EF a technology that developers should even be using? This session reviews what EF is and how it’s changed over time. We’ll also dive into how it works and what to look for when inspecting a database generated by EF Finally, we’ll review EF-generated T-SQL and give some tips on how to improve performance. If you’re a data professional who manages databases that are accessed through EF or want a basic knowledge of how EF works, this session is for you.

Speaker(s):

Richie Rump

Track and Room: Application Database Development - Developers (Rm 2067)

Title: SSIS Factory (Dobler Consulting)

Abstract: Assume that you want to create packages to load 100’s files (text or Excel) that you receive from vendors and structure of data in the files are different. How long it can take? How about creating a simple tool for your manager who doesn’t know anything about SSIS to create packages for transferring data between servers? You want to find out which package, among 100’s of them already running, update/insert a particular table . How long it will take to open each package and get the answer?

We can automate all these process using C# (or Visual Basic) and SSIS SDK. 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 can be automated too? If you are an SSIS expert with some knowledge of programming and like automation, you will have fun in this session.

Speaker(s):

Jemini Joseph

Track and Room: BI Platform Architecture, Development Administration - Power BI/more (Rm 2073)

Title: Advancements in Azure SQL Database

Abstract: In this session we will review our database as a service offering, Azure SQL Database. We will also recap and demo the recent advancements such as Threat Detection, Query Performance Insight, Query Store, Database Index Advisor and more.

Speaker(s):

Pankaj Satyaketu

Track and Room: Cloud Application Development Deployment - Azure /Big Data (Rm 2066)

Title: Using Common Table Expressions (CTE)

Abstract: Common Table Expressions (CTE) are a temporary result set used within an SQL statement, such as SELECT, INSERT, UPDATE, or DELETE, that can be used in place of a subquery and can help simplify more complex queries such as when joining to the same result set multiple times.

We’ll begin with an overview of how a Common Table Expression is constructed. Then we’ll build some queries using derived tables, and as the queries we build get more unwieldy, demonstrate how the query can be simplified by the use of a CTE.

Speaker(s):

Ben Galluzzo

Track and Room: Application Database Development - Developers (Rm 2067)

Title: Query Zip Documents, CSV Files, and Azure Tables with T-SQL directly.

Abstract: In this session I will show you how to access multiple data sources (including databases, flat files on FTP sites, Azure Tables and even MySQL) in parallel, all at the same time, using a single T-SQL command, and return data from these data sources into a single output. This allows you to remove complex intermediate processing steps, query multiple data sources without moving data, and get to your information faster. This session introduces you to a project that has been in development for a few years, and is meant to open new doors to data acquisition and analytics. If you deal with importing data in SQL Server from multiple sources, this session is for you.

Speaker(s):

Herve Roggero

Track and Room: BI Information Delivery - Azure /Big Data (Rm 2066)

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 - DBA (Rm 2071)

Title: SQL Speaker Idol

Abstract: If you’ve ever enjoyed or admired the knowledge and know-how of a speaker at an event like this, remember that they started where you are, with an interest in SQL and I.T. topics, a passion to learn more, but also with the desire to share what they know with their peers. If you have an interest in SQL or any of the Data platform technologies, and have learned something useful in your I.T. career, consider giving back to the community by sharing what you know. While it may seem intimidating to give an hour long talk at an event like this, remember that every great speaker had to start somewhere. And for you, maybe that start is Speaker idol. Speaker Idol is a friendly competition for anyone, even first time speakers, to share for 5 - 10 minutes on a technical topic, SQL or otherwise, that is informative, useful and engaging. This is a great way to get experience presenting a technical topic to the community, and a great way to find and develop the next generation of speakers!

Speaker(s):

Diana Betancourt

Track and Room: Professional Development - Auditorium

Title: Traveling through the 4th Dimension with T-SQL and PowerBI

Abstract: Time. We are all cursed and blessed with it. We run out of it, often need more of it, sometimes forget it but are always keeping track of it. In this session, we will delve into the functions provided in T-SQL and PowerBI to demonstrate how to solve both simple and complex problems with time and dates for your reports and dashboards. Ever wondered what is so special about 01/01/1900 and what will happen on January 1, 10,000? Do you want to know how to find gaps in time between systems or forecast the future? Are you interested to know how to accurately tally hours from minutes (it may not be as easy as you thought), then this session will not be a waste of your time.

Speaker(s):

Rodney Landrum

Track and Room: Advanced Analysis Techniques - SQL 2016 Discovery Day (Rm 3045)

Title: Introduction to Unit-Testing in SQL Server

Abstract: It’s bad enough to spend hours finding and fixing database defects, explaining to the rest of the team what went wrong and trying to clean up the mess. It’s even worse when a defect causes the end-user to make a bad decision. Database defects are far too costly and most testing practices do not adequately detect or prevent them.

In this session you’ll learn techniques to write SQL code that is resilient to defects and is easier to change and maintain. We will cover writing simple unit tests and look into more advanced topics such as faking tables and spying procedures. We will also look at how unit testing improves code quality and maintainability.

You will leave this session ready to write unit tests for your own environment to get started on the way to a defect-free and maintainable SQL Server code base.

Speaker(s):

Sebastian Meine

Track and Room: Application Database Development - Performance Tuning (Rm 2072)

Title: Business Intelligence - Current State of the Art

Abstract: Join Joe on a fun and informative session on the current state of Microsoft Business Intelligence (BI) offerings. We will look at the array of tooling around BI in SQL Server 2016, Power BI and Cortana Intelligence. There have been major changes in reporting and cognitive data source capabilities the last few months. This session will get you caught up on your current BI possibilities with many dazzling demos.

Speaker(s):

Joe Homnick

Track and Room: BI Information Delivery - BI/SSAS (Rm 2065)

Title: Mastering Plan Guides: Tell The Query Optimizer You’re The Boss

Abstract: It’s Monday morning and everyone is complaining that the database is slow. You see the problem - even though indexes aren’t fragmented and statistics are up to date the query optimizer is choosing a bad plan. Users want it fixed (now!) and you know a way to get things working again but you’re not allowed to change code because…it’s production. What’s a good DBA going to do? Show the query optimizer that you’re the boss with plan guides! In this session you’ll learn what plan guide are, how they work, and when to (and not to) use them to make under-performing queries behave.

Speaker(s):

Kendal Van Dyke

Track and Room: Enterprise Database Administration Deployment - Performance Tuning (Rm 2072)

Title: Bad, less Bad, not Bad; rewriting bad SQL Code

Abstract: This session provides case studies in rewriting bad SQL, with a lot of discussion on what makes sql code “bad”

Speaker(s):

Jeffrey Garbus

Track and Room: Application Database Development - Developers (Rm 2067)

Title: TSQL Coding Techniques - Are You Playing with Fire?

Abstract: The good news? T-SQL is one of the easiest coding languages to learn. The bad news? Writing scalable T-SQL that performs optimally is an art that takes years to master. In this session, learn about some common T-SQL Troublemakers - Looping, Scalar Functions, Implicit Conversions, Non-Parameterized SQL, Parameter Sniffing and Value List Handling. Through examples and demos in this session you will witness the situational pitfalls of the techniques above. With each demo, you will be given an alternate T-SQL solution that solves the same problem in an efficient and scalable manner. Let’s get things moving!

Speaker(s):

Mindy Curnutt

Track and Room: Application Database Development - Developers (Rm 2067)

Title: The Ins and Outs of SQL Indexes

Abstract: This course will focus on the fundamentals of strategic SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is a beginning level course for those who have always found indexes confusing and somewhat elusive. Lots of valuable information will be provided in a short amount of time.

Speaker(s):

Mindy Curnutt

Track and Room: Application Database Development - DBA (Rm 2071)

Title: For Love or Money, Your I.T. Career

Abstract: • Contracting at the cutting edge of technology is exciting and produces great rates. But what happens when the contract ends and the mortgage payments must continue? • Maintaining a steady job with a direct deposit salary is comforting. But do you ever feel technologically “stuck” at your job when so many other I.T. professionals are using the latest, most marketable technologies?
In this seminar session, you will learn multiple I.T. career strategies for maximizing both the Love and the Money of your multidimensional I.T. career.

Speaker(s):

Alex Funkhouser

Track and Room: Other - Professional Developement (Rm 3044)

Title: Transform SQL Server (by Pureshare)

Abstract: Please join the local Pure Storage account team for an eye-opening session on how the innovative, industry-disruptive tech in the Pure Storage FlashArray helps your business do everything faster, easier. Faster transactional workloads, analytics, backups and maintenance, all without the pain of having to tweak a thousand knobs to get things to work. Finally a storage array you can love to use, and be proud to own! Come see what the fuss is all about.

Speaker(s):

Robert Torres

Track and Room: Strategy and Architecture - Azure /Big Data (Rm 2066)

Title: Analytical Computing Device to Cloud and Back Again

Abstract: Today we live in a world where quad core cell phones is becoming a common theme. Cloud computing is cheap and the services are advanced. The sheer quantity of services can blow your mind. This talk goes through how to deliver product where intelligence is at the core of the product. We will cover building intelligence into the device, retrieving data from the device, analyzing it in the cloud and then surfacing important insights back into the device.

Speaker(s):

David Crook

Track and Room: Analytics and Visualization - BI/SSIS (Rm 2074)

Title: Building a Better Mousetrap: Using Cisco UCS for SQL Server Deployments

Abstract: Learn how Cisco and Microsoft’s strategic partnership has led to the creation of a powerful joint solution-MSFT SQL Server on Cisco UCS-to help companies migrate their SQL Server workloads to 2014/2016 versions.

Speaker(s):

Ed Cho

Track and Room: Application Database Development - Developers (Rm 2067)

Title: Easily optimize and tune SQL Server performance anywhere on any device!

Abstract: Come see Dell Software’s premier SQL Server diagnostics solutions Spotlight. Spotlight can ensure peak performance around the clock with unmatched monitoring, diagnosis and optimization of SQL Server environments. Come learn how Spotlight can provide intuitive overviews of performance health, automated alerts with actions, and mobile device support. Everyone who attends will also receive a free 3 month license of the solution!

Speaker(s):

Gordon Cornelius

Track and Room: Enterprise Database Administration Deployment - Performance Tuning (Rm 2072)

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 - Professional Developement (Rm 3044)

Title: SQL Server 2014 Column Store Index vNEXT

Abstract: The Column Store Index functionality released in SQL 2012 did allow for stunning performance gains for OLAP-style queries, but as a v1.0 release it suffered from a number of caveats, limitations, provisos, etc. The one BIGGIE was that it made it’s underlying table NON-UPDATABLE. Well, that often implementation-killing restriction has been addressed, along with a huge number of other fixes and enhancements. We will cover what those are and also see actual usage with some nice demos.

Speaker(s):

Kevin Boles

Track and Room: Application Database Development - SQL 2016 Discovery Day (Rm 3045)

Title: SSIS - Integrating PowerShell in a ScriptTask component

Abstract: This session will demostrate how you can reuse a PowerShell script in SSIS “Script Task” component as part on a ETL flow. I’ll be showing some basic .NET Script code in both C# and VB. I’ll be adding some useful tips when re-using existing Powershell code. Integrating different .NET technologies in a SSIS package: C#, VB.NET, XML, and PowerShell. Everyone is welcome to attend.

Speaker(s):

Maximo Trinidad

Track and Room: Application Database Development - BI/SSIS (Rm 2074)

Title: SSAS The Primer… Or How I Learned to Love the Cube!

Abstract: A Primer for SSAS for those who know of SSAS but not what SSAS is and why we use it. In this session we will answer: What are Cubes? Why do we Use Them? Is it the Right Tool For the Job? What Makes a Cube a Cube? How do they work? and any general questions or perspectives around SSAS.

Speaker(s):

Alexander Nykolaiszyn

Track and Room: BI Platform Architecture, Development Administration - BI/SSAS (Rm 2065)

Title: New Capabilities on top of Microsoft SQL SSAS (Necto)

Abstract: We will speak about the current BI Market, current BI trends and we will explain how the capabilities of Necto on top of the Microsoft SQL SSAS are a game changer for the BI market and specially for the Microsoft segment.

Speaker(s):

Yoav Yetinson

Track and Room: BI Information Delivery - BI/SSAS (Rm 2065)

Title: SQL Injection

Abstract: Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!

Speaker(s):

Kevin Boles

Track and Room: Application Database Development - DBA (Rm 2071)

Title: Myths and Truths about SQL Server Transaction

Abstract: This session is well suited for DBAs and Developers who are constantly exposed to production environment because the session covers the common issues many neglect without recognizing.

We demonstrate examples of incorrect development methodologies and analyze internal transaction logs in multi-transaction cases. After identifying the common mistakes, we will cover the best practice to avoid nested transactions in a stored procedure for smart error handling. We will also learn the basics of minimally logged operations.

Speaker(s):

Simon Cho

Track and Room: Application Database Development - BI/SSIS (Rm 2074)

Title: Database Use Cases: When to utilize an All Flash Array (Kaminario

Abstract: You’ve used every database trick you know and the latencies and user experience are still unacceptable. Now what?

Join Kaminario as we discuss a number of Use Cases where helped clients database challenges by deploying a cost effective All Flash Array (AFA).

Speaker(s):

Olivier Renard

Track and Room: Strategy and Architecture - DBA (Rm 2071)

Title: Power BI – Exploring New Frontiers

Abstract: Everyone is eager to get started with Microsoft’s new offering: Power BI. It promises to be a great delivery system of information and analytics. This session will show some tips and tricks to getting started fast and deliver some real WOW factor to your users. We will explore bringing in data, enhancing it, and then displaying it. We will look at how to work with the standard visualizations as well as a few custom visualizations. We will discuss publishing options to allow us to show off our work. Come join the fun and see why there is so much ado about Power BI.

Speaker(s):

Pam Shaw

Track and Room: Analytics and Visualization - Power BI/more (Rm 2073)

Speakers

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

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.

Simon Cho

LinkedIn: Simon Cho

Contact: http://simonsql.com

Simon Cho is one of the founders of SQLAngeles.com, which is a Los Angeles Korean Tech PASS community group.

As a Local Group leader, he is a Microsoft SQL community speaker. He has presented many times at SQLSaturdays and to PASS Local Groups.

He moved his passion to VISA Inc, the largest credit card provider in the world, where he used database technology to build a strong solution and a secure environment, with new strategies and features to maintain thousands of SQL Servers.

He has now joined the Nowcom Corp, as a Director of DevOps, where he leads the DevOps team and DBA team.

He is pretty much working on SQL server running on kubernetes.

Alex Funkhouser

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

LinkedIn: Alex Funkhouser

Contact: http://www.SherlockTech.com

Alex Funkhouser wrote his first lines of code in 1980 on a TRS80. He is an avid supporter of the technology community, earned a Bachelor of Science from Washington University and an International MBA from The Netherlands. Alex#39;s recruiting philosophy: “Know who is best at what, and know who needs the best!quot;

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.

Ben Galluzzo

Twitter: - BenGalluzzo

LinkedIn: Ben Galluzzo

Contact: http://www.bengalluzzo.com/

I#39;m a software developer with a passion for anything that beeps and blinks. I first delved into databases on an Atari 800XL, and I never stopped looking forward since. I often have my hands in everything from databases and software to circuits and embedded systems. When I#39;m not beeping or blinking, I#39;m often spending time with my family, woodworking, building things, or outdoors.

Daniel Janik

Twitter: - @SQLSME

LinkedIn: Daniel Janik

Contact: http://www.sqltechblog.com

Daniel Janik has been supporting SQL Server for 18 years. Six of those years were at Microsoft Corporation supporting SQL Server as a Senior Premier Field Engineer (PFE) where he supported over 287 different clients with both reactive and proactive database needs. Daniel has presented at many community events and SQLSaturdays.

Pankaj Satyaketu

Twitter: - @SQLPS

Contact: http://www.sqltwist.com

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

Ben Galluzzo

Twitter: - BenGalluzzo

LinkedIn: Ben Galluzzo

Contact: http://www.bengalluzzo.com/

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.

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.

Silvia Doomra

LinkedIn: Silvia Doomra

Silvia is a Program Manager in Azure SQL Database Team. She has experience of over 8 years in Microsoft working on different technologies like Windows Server, Visual Studio, Mobile Operators. Currently she is working in Azure SQL Database team building scale-out database technologies.

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

Salvi Pascual

Twitter: - @salvipascual

LinkedIn: Salvi Pascual

Contact: https://apretaste.com

Salvi Pascual is a university professor, an experienced software developer, a systems architect, and a technology trailblazer for social good through his open source project, Apretaste. His work has an immediate and positive affect on thousands of people internationally, and he has been nationally recognized by the press and media as a technology innovator. He earned his master degree in Computer Science from Florida International University and continues to teach and inspire future technology creators. Salvi loves traveling and strives to not be the worst pool player in the world.

Marilyn Rousseau

Twitter: - @sqldudette

LinkedIn: Marilyn Rousseau

Marilyn Rousseau is a DBA Manager, Consultant, and Coach with over 25 years of technology experience. She specializes in Health IT with an emphasis on data management. Marilyn currently serves as Vice President of the South Florida BI User Group. Prior to that, she served on the board of the South Florida SQL Server User Group for 3 years. She#39;s been an active PASS volunteer since 1999 and is a frequent volunteer of SQLSaturdays in Florida. She holds a Bachelor in Computer Science, an MBA, and is currently working on a doctorate in Adult Education and HR Management at FIU. Marilyn is passionate about all things SQL Server and enjoys helping IT professionals reach their personal and professional goals.

David Crook

Twitter: - DavidCrook1988

Contact: http://www.indiedevspot.com

David is a Technical Evangelist at Microsoft focused on Analytics and Innovation. He has past experience at Microsoft Consulting Services as a development engineer working on projects for some of Microsoft#39;s largest customers across multiple verticals.

Niran Even-Chen

Twitter: - @niranec

Contact: http://cloud-abstract.com

Niran Even-Chen (@niranec) is a Staff Solution architect at VMware Inc. In his role as a Microsoft enterprise applications architecture specialist Niran is responsible for developing solutions for SQL Server with VMware solutions, writing white papers and is also a frequent speaker in different venues such as VMUG conferences, SQLSaturday user groups, VMworld conferences and more. Niran is certified as VMware certified design expert (VCDX) #142 for datacenter virtualization and Cloud with 15 years of experience in the industry designing and architecting enterprise level solutions.

Konstantin Melamud

Twitter: - @kmelamud

Konstantin has over 15 years of SQL Server experience and demonstrates his expertise and commitment to helping SQL Server DBAs succeed through his position as Director of Service Delivery at RDX. In his role, Konstantin is responsible for designing and implementing RDX’s service delivery strategies, including those for SQL Server. Since joining RDX in 2009, Konstantin has proven to be a strong leader and expert in SQL Server database administration, architecture, performance tuning, and business intelligence. He is also a very active member of the SQL Server community and frequently presents at SQLSaturdays and user groups throughout the year. In addition, Konstantin presented during 24 Hours of PASS and at the PASS Summits.

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.

Ben Galluzzo

Twitter: - BenGalluzzo

LinkedIn: Ben Galluzzo

Contact: http://www.bengalluzzo.com/

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.

Sebastian Meine

Twitter: - @sqlity

LinkedIn: Sebastian Meine

Contact: http://sqlity.net/en/blog/

Sebastian Meine, Ph.D. is the SQL Stylist behind sqlity.net llc. In 2010 he founded sqlity.net to fully engage in his passion for SQL Server. Armed with a Ph.D. in Computer Science and years of experience in architecting DBs for a global Fortune 50 company, Sebastian now provides training and consulting services for his clients, specializing in SQL Server Security, Test Driven Development and Performance. Sebastian is an experienced public speaker, published author, president of the Philly PASS Chapter, PASS Regional Mentor and coauthor lead developer of tSQLt.

Simon Cho

LinkedIn: Simon Cho

Contact: http://simonsql.com

Simon Cho is one of the founders of SQLAngeles.com, which is a Los Angeles Korean Tech PASS community group.

As a Local Group leader, he is a Microsoft SQL community speaker. He has presented many times at SQLSaturdays and to PASS Local Groups.

He has now joined the Nowcom Corp, as a Director of DevOps, where he leads the DevOps team and DBA team.

He is pretty much working on SQL server running on kubernetes.

Konstantin Melamud

Twitter: - @kmelamud

Sebastian Meine

Twitter: - @sqlity

LinkedIn: Sebastian Meine

Contact: http://sqlity.net/en/blog/

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

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

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

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

Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses.

In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.

His latest book is “Transact SQL the Definitive Guide.”

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.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Devin Knight

Twitter: - @knight_devin

LinkedIn: Devin Knight

Contact: http://devinknightsql.com

Devin Knight a Microsoft Data Platform MVP and the Training Director at Pragmatic Works. He is an author of seven SQL Server and Business Intelligence books and speaks at conferences like PASS Summit, PASS Business Analytics Conference, SQLSaturdays and Code Camps. He is also a contributing member to several PASS Virtual Chapters. Making his home in Jacksonville, FL, Devin is the Vice President of the local Power BI User Group and SQL Server User Group (JSSUG).

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

Diana Betancourt

Twitter: - dianabeta

LinkedIn: Diana Betancourt

Former graduate of the quot;Universidad Santa Maria La Antiguaquot; School of Computer Science. I have been involved in the IT world since 1992, since then I have been working with many OS platforms, development languages and databases, among them Unix, Oracle, SUN, Informix, FoxPro, Microsoft SQL Server, just to mention a few. Diana enjoys solving complex performance tuning issues, examining your data using Databricks, designing in Azure SQL Datawarehouse, developing cool visuals using Power Bi, or evangelizing about Microsoft Data technologies at community events like SQLSaturday and local user group meetings.

Konstantin Melamud

Twitter: - @kmelamud

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

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.

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

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

In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.

His latest book is “Transact SQL the Definitive Guide.”

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.

Ben Galluzzo

Twitter: - BenGalluzzo

LinkedIn: Ben Galluzzo

Contact: http://www.bengalluzzo.com/

Shabnam Watson

Twitter: - ShbWatson

LinkedIn: Shabnam Watson

Contact: https://shabnamwatson.wordpress.com/

Shabnam Watson is a Business Intelligence architect with 20 years of experience developing data warehouse and business intelligence solutions. Her work focus within the Microsoft BI Stack has been on Analysis Services and Power BI.

She is an active member of PASS community and has spoken at PASS Summit, SQLSaturdays, PASS Business Analytics and Women in Technology virtual chapters, and many other local user groups and conferences. She is one of the organizers of SQLSaturday Atlanta BI Edition.

She holds a master’s degree in computer science, a bachelor’s degree in Computer Engineering, and a Certified Business Intelligence Professional (CBIP) certification by The Data Warehouse Institute (TDWI).

Devin Knight

Twitter: - @knight_devin

LinkedIn: Devin Knight

Contact: http://devinknightsql.com

Olivier Renard

LinkedIn: Olivier Renard

Twenty-five year IT Professional in both Sales and Sales Management. 15-years in the data storage space with younger technology companies like Network Appliance (pre-IPO), 3PAR/HP, and Kaminario. Focused on evangelizing the benefits of ALL Flash Arrays for today#39;s toughest data use cases.

Gordon Cornelius

I am the Database Solutions Account Manager for the Southeast. Happy to discuss all things SQL Server and Quest Software’s future investment in SQL Server technologies.

Devin Knight

Twitter: - @knight_devin

LinkedIn: Devin Knight

Contact: http://devinknightsql.com

Robert Torres

LinkedIn: Robert Torres

Robert Torres has been the south Florida systems engineer at Pure Storage, Inc. since November, 2015. Robert has been in the enterprise IT industry for over 20 years and today serves as the Pure Storage south Florida technical lead in helping customers transform into the next generation data center. He has held technical leadership positions during his tenures at CDW and Carnival Cruise Lines ranging from enterprise data center architect, vendor management and enterprise storage administration.

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

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

In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.

His latest book is “Transact SQL the Definitive Guide.”

Mindy Curnutt

Twitter: - @sqlgirl

LinkedIn: Mindy Curnutt

Contact: http://www.mindycurnutt.com

Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.

Rodney Landrum

Twitter: - @SQLBeat

Contact: https://www.simple-talk.com/blogs/author/2133-rodney-landrum/

Rodney Landrum has been architecting solutions for SQL Server for over 12 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has co-authored 4 books on Reporting Services. He is been a regular contributor to SQL Server magazine, sqlservercentral.com and Simple-talk.com. Rodney is also SQL Server MVP

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

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

In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.

His latest book is “Transact SQL the Definitive Guide.”

Mindy Curnutt

Twitter: - @sqlgirl

LinkedIn: Mindy Curnutt

Contact: http://www.mindycurnutt.com

Mindy Curnutt

Twitter: - @sqlgirl

LinkedIn: Mindy Curnutt

Contact: http://www.mindycurnutt.com

Ed Cho

LinkedIn: Ed Cho

Strategic Partner Marketing Manager who oversees Cisco#39;s partnership with Microsoft.

Sam Mesel

will be provided later on

Kevin Boles

Twitter: - @TheSQLGuru

LinkedIn: Kevin Boles

Alexander Nykolaiszyn

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

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

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.

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.

Yoav Yetinson

LinkedIn: Yoav Yetinson

I believe success on a global level requires leadership, a strong work ethic, innovation, but most importantly – working well as part of a team. I possess strong interpersonal communication skills, which were acquired in my jobs as a real estate agent, property manager, and enterprise software sales. My service in the Army helped shape my leadership skills.

Through my education I attained business and technical skills including the ability to create databases, design systems and write basic codes in C++ and SQL.

I have a very deep interest in BI and the financial sector. I acquire my financial knowledge through trading stocks, reading financial articles, and discussing recent events with friends who work in the industry.

SQLSaturday #524 - South Florida 2016

Sessions

Title: Architecting virtual SQL server for performance

Title: Scaling for best performance: Partitioned views.

Title: How SQL is helping to connect Cuba to the Web for free

Title: The Phenomenal IT Consultant

Title: Seamlessly Scaling Azure SQL DB with Elastic Database Tools

Title: Advance Analytics with SQL Server R Services

Title: Turbo Boost Performance: In Memory Tables index optimizations

Title: Build ETL efficiently (10x) with Minimal Logging

Title: Query Data Store

Title: SQL Server Disaster Recovery and High Availability Overview

Title: Developing an End to End Power BI Solution

Title: What’s new in SQL Server 2016

Title: MongoDB for SQL Developers and Accessing MongoDB with SSIS

Title: A SQL Developer’s Guide to MDX Basics

Title: Becoming Certified in SQL Server 2012/2014

Title: Who’s Afraid of Entity Framework?

Title: SSIS Factory (Dobler Consulting)

Title: Advancements in Azure SQL Database

Title: Using Common Table Expressions (CTE)

Title: Query Zip Documents, CSV Files, and Azure Tables with T-SQL directly.

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

Title: SQL Speaker Idol

Title: Traveling through the 4th Dimension with T-SQL and PowerBI

Title: Introduction to Unit-Testing in SQL Server

Title: Business Intelligence - Current State of the Art

Title: Mastering Plan Guides: Tell The Query Optimizer You’re The Boss

Title: Bad, less Bad, not Bad; rewriting bad SQL Code

Title: TSQL Coding Techniques - Are You Playing with Fire?

Title: The Ins and Outs of SQL Indexes

Title: For Love or Money, Your I.T. Career

Title: Transform SQL Server (by Pureshare)

Title: Analytical Computing Device to Cloud and Back Again

Title: Building a Better Mousetrap: Using Cisco UCS for SQL Server Deployments

Title: Easily optimize and tune SQL Server performance anywhere on any device!

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

Title: SQL Server 2014 Column Store Index vNEXT

Title: SSIS - Integrating PowerShell in a ScriptTask component

Title: SSAS The Primer… Or How I Learned to Love the Cube!

Title: New Capabilities on top of Microsoft SQL SSAS (Necto)

Title: SQL Injection

Title: Myths and Truths about SQL Server Transaction

Title: Database Use Cases: When to utilize an All Flash Array (Kaminario

Title: Power BI – Exploring New Frontiers

Speakers

Sponsors