SQLSaturday #379 - South Florida 2015

Event Date: 06/13/2015 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: Changing Data Is Easy, Managing Data Change is Hard!

Abstract: Databases are growing. The way we use data is changing and growing. When you have a lot of change, it has to be managed, or bad things happen to your data and your job! A common problem with database change management is… database change management. This session walks the user through the concepts of database change management, why it’s important, and how SQL Server Data Tools (SSDT) makes this process easy. There are a lot of great features in this frequently overlooked product, and if you are not using it, your job is a lot harder than it needs to be. Some things we will discuss: schema compare, database versions in source control, renaming objects, and how your job is pushing the button to deliver it the EASY way with SSDT.

Speaker(s):

James McAuliffe

Track and Room: DBA track - 3047

Title: Reporting on Your Cube with SSRS

Abstract: In this session Dustin will give you an introduction to reporting on a cube with SQL Server Reporting Services (SSRS). You’ll learn about some of the advantages of using your cube as a source for your SSRS reports, how to build reports based on your cube with minimal knowledge of MDX, as well as a few tricks you can use to increase the usability of your reports.

Speaker(s):

Dustin Ryan

Track and Room: BI track - 1049

Title: Creating an End to End Power View Reporting Solution

Abstract: Power View has the capability of creating eye-popping visualizations within SharePoint and Excel 2013. It provides intuitive ad-hoc reporting that can be used by a variety of business users to make critical decisions. Before you can begin building these incredible reports you must have your data properly prepared. This session will give you a beginning to end view of what is needed to create Power View reports from organizing a Power Pivot source to preparing the actual Power View report.

Speaker(s):

Devin Knight

Track and Room: BI track - 3048

Title: Once Upon a DateTime

Abstract: Creating calculated measures and columns in DAX is an essential part of any Tabular or PowerPivot model. Since most data represents events that occur over time, a time dimension is critical in those models to reveal data trends. However, perhaps even more important than just using time as a dimension is using DAX time functions to calculate aggregate measures grouped on discrete time periods such as months, quarters, and years, period to date aggregates, and the analysis of parallel periods to compare the past to the present. For most financial analysis of data, the ability to look at data grouped by different time periods is essential in making good business decisions. Come to our monthly meeting to learn how to use the DAX date functions to successfully analyze data over time.

Speaker(s):

Michael Antonovich

Track and Room: BI track - N/A

Title: Big Data Mining with SSAS, Azure Machine Learning Mahout

Abstract: Join this session to learn about traditional data mining with the power of Mahout in Hadoop and Azure Machine Learning. Mahout is a machine learning library, supported in HDinsight. HDInsight is the Microsoft service that brings Apache Hadoop to the cloud, and Mahout is a powerful tool for processing models within HDFS and MapReduce. This session will cover how data mining is implemented in the context of big data and the cloud. This session will cover the full data mining cycle: ETL,building, testing, and training data models to visualization, testing, and real-time querying. You will see how to discover patterns and make predictions, classifications, and recommendations to get all the insights from your structured and non-structured big data.

Speaker(s):

Paco Gonzalez

Track and Room: Azure - 1049

Title: The Quest to Find Bad Data With Data Profiling

Abstract: The legendary adventurer is on the quest of a lifetime. He’s found a database that holds the locations of the world’s greatest relics, but there’s a problem. No, it’s not snakes. The database was written using an ancient format and it may hold incorrect data. Our data archaeologist must find a way move the correct data into SQL Server or risk losing our most important treasures, forever. Luckily, he has an powerful tool, data profiling. #160; Data profiling is a way that you can identify bad data, measure inaccurate data, and know for sure that your queries are right. There are many different ways our adventurer can use data profiling. This session will show you what data profiling is and how it can help lead you to fortune and glory.

Speaker(s):

Richie Rump

Track and Room: DEV track - 3045

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: DEV track - 2082

Title: Taking the Scary out of Monster Reports

Abstract: So the big wigs have come up with a “master” report that shows everything you could ever want on a single report. It includes grids and charts of varying sizes and complexities. Did I mention they want it pretty as well? In this session we will discuss how to use SQL Reporting Services to bring it all together while avoiding the pit falls and mistakes. The demonstration will show how to build a multi-page, dashboard style report to manage your report server showing a multitude of grids and charts. We will discuss the challenges with data reuse and formatting while exploring techniques for getting them to work. To get the most out of this session, you should be able to build a report in SSRS.

Speaker(s):

Pam Shaw

Track and Room: BI track - 3047

Title: Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers

Abstract: Do you have applications in your environment that don’t use SQL written by a person but by the application itself? No, the system isn’t self-aware. Chances are the system is utilizing Microsoft’s Entity Framework.

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

Speaker(s):

Richie Rump

Track and Room: BI track - 3044

Title: Tone Analysis with HDInsight and Azure Machine Learning

Abstract: People’s sentiments and opinions are written in social networks. There are tweets, Facebook posts, book reviews, forum discussions, and more. These attitudes and feelings are communicated using text, with format depending on the social network. Twitter messages are limited to 140 characters and use hash-tags,; Facebook messages can be longer. This session reviews the different Natural Language Processing, text mining, and data mining techniques you can use for sentiment and tone analysis. Organizations can use the extracted knowledge for brand reputation, market predictions, and automatic learning. We’ll look at, Hadoop, data mining, Microsoft Big Data Hadoop distribution HDInsight and Azure Machine Learning

Speaker(s):

Paco Gonzalez

Track and Room: Azure - 3044

Title: Indexing for Join Optimization

Abstract: Everything you wanted to know about join optimization but were afraid to ask… Join types, indexing, and how the optimizer makes its selections.

Speaker(s):

Jeffrey Garbus

Track and Room: DBA track - 2078

Title: Turbocharge Your Career With a Learning Plan

Abstract: What will you learn next quarter and why? How will you learn it? How much time and money will it cost? What is the ROI on learning those skills? Those are the questions that you answer by building a learning plan and, if you do it well, you’ll find yourself steadily pulling away from your peers.

It starts with a learning list, a place to capture skills you think you need to learn. That’s where you score each topic by estimating the effort to learn it in time and money and the value it adds to your career now and later. It’s absolutely an analog process, but it gives you the framework for answering one question: what do I learn next and why?

Once you’ve picked a topic, how do you learn more about it? Do you read blogs, buy books, or attend a class? Or all of the above? How much time makes sense? Join this session and learn how to dig into the topic to answer the questions that lead to a learning plan. After that, it’s just a matter of executing the plan!

Speaker(s):

Andy Warren

Track and Room: Professional Development - 2081

Title: Welcome to SSAS Tabular Models

Abstract: Knowing how to build a Tabular model is one thing. Knowing how to build a Tabular model the right way is something completely different. In this session we’ll discuss how to decide if building a Tabular model is the right choice, how to build a Tabular model completely from scratch, best practices you should follow, and things to avoid. If you’re new to Tabular Modeling or wanting to learn best practices, this session is for you!

Speaker(s):

Dustin Ryan

Track and Room: BI track - 3047

Title: Encryption 101: A look at SQL Encryption Options

Abstract: Are your backups like a stack of cash free for the taking, or a hardened ATM? Are your database connections scrambled and safe or are you sending data over the party line? In this session we will walk through the many ways SQL Server allows us to protect our data using encryption. We will evaluate the various methods for protecting data at rest, in the database, and while in transport. Since nothing comes for free, we will look at how much all of this is going to cost us, in time, money, and failure to implement.

Speaker(s):

Jason Carter

Track and Room: DBA track - 2081

Title: An Entity Framework Crash Course for the Busy DBA.

Abstract: The Entity Framework enables developers to work with data in the form of domain-specific objects and properties, without having to concern themselves with the underlying database tables and columns where this data is stored. With such great power comes great frustration; Namely our Database Administrators’ as they trace through and attempt to optimize the Entity Framework auto-generated SQL statements hitting our databases.

This talk aims to empower the DBA with an understanding of the architecture behind the Entity Framework and the most common pitfalls programmers fall for when attempting to rapidly write data access layer code using the Entity Framework and what can be done to overcome them.

Speaker(s):

Sam Abraham

Track and Room: DBA track - 1048

Title: Partitioning and Partial Databases for HA for VLDB

Abstract: How partitioning + Partial databases on SQL server enterprise can help me to increase my HA environment.

Speaker(s):

Kenneth Urena

Track and Room: DBA track - 2082

Title: SQL Server 2014 In-Memory from evey angle

Abstract: we are going to start with the basics about how to create tables, Stored procedures and objects in general. also the new features of delay_durability in conjunction with Inmemory OLTP. From the point of view of the developer , which advantages and disadvantages it has , besides the different constraints presented . From the point of view of the DBA , which advantages and disadvantages it has, besides the changes necessary for the administration. From the point of view of Architect occasions where I can be helpful in improving my performance OLTP

Speaker(s):

Kenneth Urena

Track and Room: DBA track - 2077

Title: SQL Design and Retrieval for Analysts and Testers using SQL Server 2014

Abstract: This session will provide an introductory overview of the relational model for Business Analyst and Quality Assurance Analysts and other IT specialists who would like to become proficient. We will be using SQL Server 2014 and a sample database to understand how to create, design, query and modify data using SQL.

The session will cover:

Understanding the fundamentals of a relational database
Review of SQL Server and its components
An In-depth dive into Transact SQL -The Principles of database design.

Come have some fun and learn how to work with SQL Server and it’s relational data.

Speaker(s):

Alex Roque

Track and Room: DEV track - 2082

Title: Introducing the Reimagined Power BI Platform

Abstract: You have seen glimpses of the new Power BI offering at WPC and PASS in 2014. Microsoft has totally reimagined the Power BI platform, user experience, added developer APIs, custom apps, hybrid direct connectivity to on-premise data sources without data copying and other top secret enhancements that we can dive into by the time of this session. Join me to explore all these great changes for both BI professionals and Power BI users.

Speaker(s):

Jen Underwood

Track and Room: BI track - 2077

Title: Introduction to Hive with Microsoft Azure HDInsight

Abstract: This presentation introduces functional and technical professionals to the purpose, need and use of Apache Hive and HiveQL. The audience is exposed to the Apache Hive data warehouse software and the Hive QL Language which is a SQL-like language used in the management, query, summarization and analysis of large datasets residing in distributed storage; such as the Azure Blob Storage and Hadoop Distributed File System. The presentation includes principles, concepts and architecture of Hive; in addition to the syntax and use the HiveQL language illustrated in practical examples showing the use of HiveQL as it interfaces with data residing in an Azure Blob Storage.

Speaker(s):

Adriano da Silva

Track and Room: Azure - 3044

Title: Configuring AlwaysON availability groups with Readable Secundaries

Abstract: In this session we are going to see how to configure always on Availability groups with readable secondaries and the necessaries changes to make in the application side.

Speaker(s):

Kenneth Urena

Track and Room: DBA track - 3048

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: DBA track - 3045

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 track - N/A

Title: But I Want it in Excel…

Abstract: As IT professionals we can create reports from SQL using Business Objects, Crystal Reports or other popular tools. How many times have we created something fantastic only to hear the CEO or CFO say “That’s great… but I want it in Excel”. Ugh!

Don’t do the export-import thing! Learn some basic techniques to interact directly with SQL to create beautiful Pivot Tables and Graphs, right from Excel. You can even ensure the CxO will always have fresh data and eliminate sync issues with your other reports.

Speaker(s):

Perry Patterson

Track and Room: BI track - 2077

Title: Calculated Columns, Measures, and KPIs, Oh My!

Abstract: To do serious work in a Power Pivot table or even a SQL Analytics Cube, you must know the difference between calculated columns, measures, and KPIs, how to define them, use them, and display them. This session will take you step by step through the creation of each of these components of a typical pivot table or cube showing you how to define the necessary expressions and then how they are displayed in tables and charts that transform mere data into meaningful managerial information. To keep examples simple enough for all attendees to go back and try on their own, Excel Power Pivot Tables will be used, but the same techniques apply almost without change to SSAS cubes.

Speaker(s):

Michael Antonovich

Track and Room: BI track - 1048

Title: Easier schema migrations, data migrations more w/ Redgate tools

Abstract: Managing data models and data for existing applications can be cumbersome and fraught with pitfalls. Many developers and DBAs rely on “change” scripts they produce manually whenever they need to deploy changes or updates. Though this might work well for small and infrequent changes, it’s much harder to pull off with large teams, complex applications or applications that change all the time. In the world of software, we rely on source control and code-differencing tools. However, these tools are much less common when it comes to database schemas and data in databases. Enter RedGate tools: SQL Compare, SQL Data Compare and others. These tools allow the DBA to quickly “compare” databases (even data) and quickly generate “change scripts” that can be used to roll out changes and/or audit databases. In this session, we explore these tools and how I’ve integrated them in my workflow when supporting business applications. [Note I do not work for Redgate and this is not a vendor session.]

Speaker(s):

Eric Soto

Track and Room: DBA track - 3046

Title: Azure Data Services – Real-time Analytics

Abstract: Azure Data Services enables users to build data warehouse platforms in the cloud. This presentation will highlight the services in Azure that enable developers to build, load and query data from a cloud data source into Azure. We will discuss the cloud architecture and demonstrate how to load data from social feeds into Hadoop for reporting. This session will showcase the product and review the conceptual differences between on premise and cloud software.

Speaker(s):

Jason Virtue

Track and Room: Azure - 3047

Title: Do You Have A Case Of Mistaken IDENTITY?

Abstract: When creating a table most people use an identity value as the primary key without a second thought. We also take for granted than returning the identity value when a row is inserted “just works”…but it’s not as straightforward as it seems - you might have a case of mistaken identity! In this session we’ll look at several ways to return identity values, compare identity values with sequences, demonstrate how you can end up with unexpected identity values, and learn how to make sure you’ve got the right ones every time.

Speaker(s):

Kendal Van Dyke

Track and Room: DEV track - 3046

Title: SQL Server 2014 for the DBA

Abstract: SQL Server 2014 is the newest version of SQL Server available from Microsoft. This session is designed to introduce SQL Server DBA’s to some of the new and exciting features available in that version. Topics covered in this session include AlwaysOn enhancements, Clustered ColumnStore indexes, Memory-optimised tables (In-Memory OLTP, code-named Hekaton) and Extended Events enhancements. The target of this session is SQL Server DBA’s, developers, architects or IT professionals who are excited about the new SQL Server 2014 features and are looking to learn more about them. This class assumes that you have average to good T-SQL skills already and a good understanding of SQL Server fundamentals.

Speaker(s):

Gareth Swanepoel

Track and Room: DBA track - 3044

Title: Process SSAS Cubes with SSIS

Abstract: So you have used SSIS for years to do all your ETL and loading of your data warehouse, but did you know you could also handle all your cube processing inside of SSIS? In this session Mitchell will introduce you to four little know tasks in SSIS that will help to automate the processing of your cube.

Speaker(s):

Mitchell Pearson

Track and Room: BI track - 2081

Title: Transactional Replication: Architecture, Setup, and Monitoring

Abstract: At some point in every DBA’s career they’ll be probably be asked to work with transactional replication. While it may seem scary at first, it’s not that complicated once you understand how all the parts and pieces work together. In this session we’ll cover the fundamentals of how transactional replication works, walk through setting up a working replication topology, and learn how to keep an eye on things to make sure everything is working properly. You’ll return to work with the confidence and know-how that you need to set up and manage a transactional replication topology.

Speaker(s):

Kendal Van Dyke

Track and Room: DBA track - 3046

Title: PRECON - SQL Server High Availability

Abstract: You have many options when it comes to high availability and disaster recovery. Attend this session to learn the benefits of two of the most popular HA features, Clustering and Availability Groups. Learn how to plan, implement, and manage these technologies.

Speaker(s):

Kathi Kellenberger

Track and Room: DBA track - N/A

Title: Writing Better T-SQL Queries with Window Functions

Abstract: SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could.

This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You’ll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.

Speaker(s):

Kathi Kellenberger

Track and Room: DEV track - 1048

Title: Rolling Database Snapshots

Abstract: You want a recent version of your database to move reporting workload off production, using SQL 2005-2008R2 Enterprise but not yet using SQL 2012/2014? Consider rolling database snapshots. This approach works with or without database mirroring, to continuously provide a recent version of your database to support read-only and reporting workloads. This solution will be compared to other alternatives, a working demo presented, with shared source code.

Speaker(s):

David Cobb

Track and Room: DBA track - 3046

Title: Tips and 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: BI track - 3044

Title: SQL Server solutions in Azure

Abstract: In this session we will be looking at the continuum of SQL Server solutions running in Azure, Microsoft’s public cloud. We will take a look at running SQL Server on virtual machines in Azure via our Infrastructure as a Service solution and SQL Database our Platform as a Service solution. Come learn the differences between both and also gain some insight into some of the preview feature capabilities of SQL Database.

Speaker(s):

Pankaj Satyaketu

Track and Room: DBA track - 2078

Title: PowerShell and Python - The Clash - Part Deux

Abstract: Comparison of one application done with both technologies

Speaker(s):

Jorge Besada

Track and Room: DBA track - 3045

Title: What’s new in SQL 2016?

Abstract: Will cover the main new features (with as many demos as practical) including:

*ColumnStore improvements *In-Memory OLTP Improvements *Live Query Statistics *Query Store *Temporal Tables *Always Encrypted *Stretch Database *Row Level Security *Dynamic Data Masking

Speaker(s):

David Cobb

Track and Room: DBA track - 3048

Title: Building Solutions for Power BI QA

Abstract: QA is an amazing new feature of Power BI that allows you to ask you data question. No longer do you have to write complex SQL queries to get results. Simply type traditional English sentences to return interesting results about your data. This session will walk through how to get a Power Pivot data model ready to use and also the end user experience of QA from the Power BI site.

Speaker(s):

Devin Knight

Track and Room: BI track - N/A

Title: T-SQL Window Function Performance

Abstract: Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.

Speaker(s):

Kathi Kellenberger

Track and Room: DEV track - 1049

Title: Indexing for performance

Abstract: Learn all you wanted to know about index design but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session

Speaker(s):

Jeffrey Garbus

Track and Room: DBA track - N/A

Title: SSMS: The Untold Secrets

Abstract: You spend all day working with SQL Server Management Studio (SSMS) but are you deriving maximum value out of it? In this session we will review some of the more useful functionality of SSMS including Templates, Registered Servers, Regular Expressions and various other settings you didn’t know you want.

Speaker(s):

Jason Carter

Track and Room: DEV track - 2082

Title: Getting Started with Power Query

Abstract: Power Query is a free add-in for Excel 2010 and up that provide users an easy way to discover, combine and refine data all within the familiar Excel interface. With Power Query you can now combine and transform data from a variety of unusual data sources all within Excel, which would have previously required a complex ETL job. Join Devin and learn how you can use Power Query to take your Self-Service BI solutions to the next level.

Speaker(s):

Devin Knight

Track and Room: BI track - 2082

Title: R intro for the SQL Server Pro

Abstract: So you’ve heard all the buzz about R and you are ready to start the learning journey but where do you start? in this session, Luis will discuss some industry trends and provide an overview of what R is, how to acquire, manipulate and plot simple data sets, how you can leverage your existing data skills and a number of learning resources that will help you succeed in your jouRney.

Speaker(s):

Luis Figueroa

Track and Room: BI track - 3045

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: DEV track - 1049

Title: An Introduction to Big Data, Hadoop and Microsoft Azure HDInsight.

Abstract: This presentation provides a high level overview of basic Big Data and Hadoop fundamentals and concepts. It is an ideal opportunity for those considering or learning Hadoop to see Big Data in Action with examples using Microsoft Azure HDInsight, which is a 100% Apache Hadoop-based service in the cloud provided by Microsoft. We will also cover Big Data exploration and data visualization demonstrations using Microsoft products; such as PowerQuery for Excel.

Speaker(s):

Adriano da Silva

Track and Room: Azure - 1124

Title: Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Abstract: As SSRS report developers, we take for granted the security that is built in to Reporting Services. This Session explores the possibilities available to us by querying AD.

Speaker(s):

Wes Springob

Track and Room: BI track - 2078

Title: How to be a GREAT DBA

Abstract: This presentation describes the tasks a DBA needs to perform to do a great job. Formal training classes and certifications only take you so far; this session talks from experience about everything from preventive maintenance to planning to scaling to communication.

Great for beginner to intermediate DBAs, as well as Developers who think this is a direction in which they might want to move.

Speaker(s):

Jeffrey Garbus

Track and Room: DBA track - N/A

Title: SQL Server and Windows 10: Data Security and Compliance

Abstract: Join Joe as he leverages his 30 years as a CPA and Information Systems Architect to show how SQL Server 2014 delivers the most secure database among leading database vendors. SQL Server solutions provide everything you need to adhere to security and compliance policies—out of the box. This includes the most up to date encryption technologies built on Trustworthy Computing initiatives. Versions 2014, 2016 and Azure will be investigated along with the soon to be released Windows 10 as the most secure client for SQL Server.

Speaker(s):

Joe Homnick

Track and Room: SQL Security - 3044

Title: SQL Azure + Azure Machine Learning to predict Home Values - HOL

Abstract: During this hands on lab we will connect an Azure Machine Learning experiment to a SQL Azure instance, import the data, train two machine learning models, compare the two and publish a production model as a web service. There will also be an overview of how the data was obtained.

The data is data from Zillow using F# and Azure Cloud Services, we will be predicting the value of homes based on the data collected.

Speaker(s):

David Crook

Track and Room: Azure - 2077

Title: SQL Server and Microsoft Business Solutions - Tegile

Abstract: Tegile Intelligent Flash Storage Arrays simplify the storage and management of SQL Server Business Intelligence and OLTP information. Whether you need a hybrid or an all-flash storage array, Tegile offers a comprehensive portfolio of flash storage solutions that deliver sustained performance, resilience and economics to fit most budgets and requirements. Compromise nothing when it comes to storing, accessing and protecting your business critical information.

Speaker(s):

Brett Johnson

Track and Room: Lunch Session - 2078

Title: PowerShell with Visual Studio SQL Data Tools

Abstract: This session will show the integration and use of PowerShell Tools for Visual Studio with SQL Data tools. Also demostrate how the use of a PowerShell script in SSIS “Script Task” component as part on a ETL flow. Covering 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.

Speaker(s):

Maximo Trinidad

Track and Room: DEV track - 1048

Title: Learn about Governed Data Discovery 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 learn about “Governed Data Discovery” and what that really means. Additionally - attendees will see how to build a SQL Server TABULAR MODEL on the fly - using our Mashup technology! We will then take that tabular model, build some reports, and share with users!

Speaker(s):

Mark Scott

Track and Room: Lunch Session - 2077

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: Azure - N/A

Title: Database Virtualization and Drinking out of the Fire Hose

Abstract: A database by its very nature is one of the most resource intensive applications you will ever virtualize. This is even more difficult to do correctly in the context of a virtualized infrastructure that is a shared resource environment. We will look at every possible dynamic to virtualizing a database from Design, Storage, Memory and Network considerations. This presentation is based upon material given at VMworld from a presentation that was in the top 10 out of all presentation given.

Speaker(s):

Michael Corey

Track and Room: DBA track - 3045

Title: NO-SQL For the DBA

Abstract: In this session I will make a high level introduction of NO-SQL databases from the viewpoint of a Database Administrator. We will review some of the key benefits and challenges of the no-sql database concepts and understand how DBAs will become more involved in the day to day operations of such databases. While no-sql databases are designed for developers, important operations will fall in the hands of DBAs over time. We will look primarily at the Azure Table no-sql data store, and quickly tour other storage engines to understand how they differ such as DocumentDB, CoucheBase and more.

Speaker(s):

Herve Roggero

Track and Room: Big Data - 1048

Title: SELECT * FROM CorpDB1 WHERE (value_data lt;gt; 0)

Abstract: Data has value…BUT, what is the value of your data? Explore the value of data in varied Enterprise situations. Will demonstrate tool for single table restore without the need to restore entire DB, and tool for query within table/DB without any dependency on SQL. DOOR PRIZE - We’ll draw for 2TB Passport drive from session attendees.

Attendees will get free copy of Single Table Restore software and have opportunity to provide input into future product.

Speaker(s):

Russ Reinbold

Track and Room: Lunch Session - 1049

Title: Reusable ssis development using Parent - Child methodology

Abstract: On this session we are going to cover the creation of independent packages and how to create a package controller using package configuration features to create a parent - child work flow. what would be cover: Creation of ssis package controllers, How to used package configuration features Passing parameters from a parent package to a child package

Speaker(s):

Jorge Novo

Track and Room: BI track - 3048

Title: SQL Server 2014 In-Memory Programming

Abstract: SQL Server 2014 introduces a game changer technology; in-memory objects. This session is a hands-on demo based presentation that will introduce you to what the technology is and how to use it. You will come out of this session with the knowledge and scripts that you can take back to your shop and instantly be productive. You will gain an understanding of the architecture, how to get started, indexes, natively compiled stored procedures and the limitations.

Speaker(s):

miguel Cebollero

Track and Room: BI track - 3048

Title: Dynamic SSIS Frameworks for complex file Structures

Abstract: On this session we are going to deal with real work situations such as the loading and transformation of fixed width files in EBCDIC. Conversion of comp-2 and comp-3 fields using custom ssis components and the creation of metadata to dynamic generate ssis at run time

Speaker(s):

Jorge Novo

Track and Room: BI track - 3046

Speakers

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

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

Russ Reinbold

Twitter: - Twitter: @KrollOntrack

LinkedIn: Russ Reinbold

Contact: Blog URL: http://thedatarecoveryblog.com/

Software By DBAs, For DBAs. Working closely with PASS (as a Global Alliance Partner) Kroll gathers product input from real DBAs, focus groups amp; beta testing. Our goal is to deliver time/money-saving tools to DBAs globally.

With 20+ years IT Channel experience, my current focus is creating granular restore tools. I lead business development efforts to integrate Ontrack PowerControls for SQL (and also Exchange and SharePoint) into industry leading storage/backup solutions.

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

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.

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

Jen Underwood

Twitter: - @idigdata

LinkedIn: Jen Underwood

Contact: http://www.jenunderwood.com

Jen Underwood is a Senior Director at DataRobot. Over the past 20 years, Jen has held worldwide product management roles at Microsoft and served as a technical lead for system implementation firms. She has a unique blend of product management and “hands-on” experience in data warehousing, reporting, visualization, and advanced analytics. In addition to keeping a constant pulse on industry trends, she enjoys digging into oceans of data to solve complex problems with machine learning.

Jen has a Bachelor of Business Administration – Marketing, Cum Laude from the University of Wisconsin, Milwaukee and a post-graduate certificate in Computer Science – Data Mining from the University of California, San Diego.

Dustin Ryan

Twitter: - @SQLDusty

LinkedIn: Dustin Ryan

Contact: http://sqldusty.com

Dustin Ryan is a senior BI consultant and trainer with Pragmatic Works in Jacksonville, FL. Dustin specializes in delivering quality enterprise-level business intelligence solutions to clients using SSRS, SSIS, SSAS, SharePoint, and Power BI. Dustin has authored and contributed to SQL Server books. You can find Dustin speaking at events such as SQLSaturday, Code Camp, and online webinars.

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.

Richie Rump

Twitter: - @jorriss

LinkedIn: Richie Rump

Contact: http://jorriss.net

Dustin Ryan

Twitter: - @SQLDusty

LinkedIn: Dustin Ryan

Contact: http://sqldusty.com

Pam Shaw

Twitter: - @PamShaw

LinkedIn: Pam Shaw

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

Richie Rump

Twitter: - @jorriss

LinkedIn: Richie Rump

Contact: http://jorriss.net

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

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.

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.

Paco Gonzalez

Twitter: - @pacosql

LinkedIn: Paco Gonzalez

Paco Gonzalez is the CEO of SolidQ North America, and a Microsoft Data Platform MVP. Focused on Business Analytics and Artificial Intelligence, he specializes in helping organizations become data driven from a strategic and technical perspective. Paco is a speaker at small and large conferences such as PASS Summit, Ignite, and Business Applications Summit, and he has published several books and whitepapers. He is based in Atlanta, GA.

Eric Soto

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

LinkedIn: Eric Soto

Eric A. Soto is an Internet Technology Professional living in West Palm Beach, Florida. Eric provides services to a worldwide clientele via various brands and products. With over 24 years experience in technology and more than 15 of those years in the Internet space, he has an excellent track record of leveraging technology and achieving positive results on the web. These days Eric specializes in Web and Mobile projects including iOS, Android and more.

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.

Paco Gonzalez

Twitter: - @pacosql

LinkedIn: Paco Gonzalez

David Cobb

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

LinkedIn: David Cobb

Contact: http://daveslog.com

Michael Antonovich

Twitter: - @SharePointMikeA

LinkedIn: Michael Antonovich

Contact: http://sharepointmike.wordpress.com

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

Luis Figueroa

Twitter: - @luisefigueroa

LinkedIn: Luis Figueroa

Contact: http://blog.luisfigueroa.net

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

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!

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

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

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.

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.

Jason Carter

Twitter: - TampaDBA

Contact: http://jason-carter.net

Sam Abraham

Contact: http://www.samabraham.net

Sam Abraham is a senior software Developer in South Florida; A strong believer in learning through sharing and the value of community fellowship, Sam has been actively involved in the local community as leader of the WPB Users’ Group and former member of the board of directors at the South Florida Chapter of the Project Management Institute (PMI). Sam is a Project Management Professional (PMP), Certified Scrum Master (CSM) and is Microsoft-certified in Web Development and SQL Server.

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Herve Roggero

Twitter: - @hroggero

LinkedIn: Herve Roggero

Contact: http://www.herveroggero.com

Strategist. Catalyst. Storyteller. Herve Roggero is recognized for his thought leadership and passion for providing accessibility to data in the tech space. Herve’s knack for distilling complex real-time data consumption challenges and presenting digestible solutions make him the ideal speaker, teacher, and teammate.

His leadership skills and passion of Microsoft Azure are a testament to his commitment to ultimately increasing operational efficiency - so much so that Herve has been an Microsoft Azure MVP for over 7 years.

Herve is the Co-Author of PRO SQL Azure, PRO Windows Azure SQL Database and PRO SQL Server 2012 Practices (from APress), a PluralSight author, and runs the Azure Florida Association.

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.

Jorge Novo

Twitter: - @ETLDEVDBA

LinkedIn: Jorge Novo

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

Jorge Novo is a database developer with more than 10 years of experience in the design, implementation, and maintenance of OLAP, ROLAD database system for the enterprise. Jorge specialize himself on ETL processes, SQL tunning, and much more. Jorge is always eager to learn and shared his ideas and challenges with the SQL Community.

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.

Kathi Kellenberger

Twitter: - auntkathi

LinkedIn: Kathi Kellenberger

Contact: http://auntkathisql.com

Jorge Novo

Twitter: - @ETLDEVDBA

LinkedIn: Jorge Novo

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

David Cobb

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

LinkedIn: David Cobb

Contact: http://daveslog.com

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.

Adriano da Silva

Twitter: - AdasilvaTek

LinkedIn: Adriano da Silva

Adriano da Silva is a Lead Power BI Trainer at Intellinsight LLC and a Principal Consultant at Bright International Corporation a consulting company focused in addressing complex business problems with innovative, effective and robust Solutions in the BI, AI, Big Data, Machine Learning Power BI. He is has years of experience in partnering with businesses leaders to advise and implement technical and process oriented solutions. He is engaged in knowledge sharing initiatives by presenting on conferences, user groups and authoring articles. He is also a lead organizer at the South Florida Power BI (SFPBI) and the Microsoft Data and AI South Florida user groups..

Wes Springob

Twitter: - /SQLWes

LinkedIn: Wes Springob

Contact: http://SQLWes.com

Wes Springob is a Premier Field Engineer (PFE) at Microsoft and speaks regularly on Business Intelligence, Power BI, database and report development.

Adriano da Silva

Twitter: - AdasilvaTek

LinkedIn: Adriano da Silva

Michael Corey

Twitter: - Michael_corey

LinkedIn: Michael Corey

Contact: http://michaelcorey.com/

Michael is a Director Cloud Computing Evangelist for Spectrum Enterprise Navisite. In 2017, was recognized as #42 of the top 100 most influential people in the “cloud industry”. Michael’s a recognized Microsoft Data Platform MVP formerly (Microsoft SQL Server MVP), recognized Oracle ACE, a recognized VMware vExpert and has worked with relational databases for over 30 years starting with Oracle Version 3. Michael is a Past President of the Independent Oracle Users Group (IOUG), A Founder of the Professional Association of SQL Server and current President of the IOUG VMware Special Interest Group. Michael is the original Oracle Press author, frequent blogger http://michaelcorey.com/, a regular columnist for the Big Data Quarterly

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

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.

Alex Roque

LinkedIn: Alex Roque

Contact: http://users.cis.fiu.edu/~aleroque/

Software developer / Adjunct professor with a passion for software development and SQL. Looking to educate and empower enthusiasts to learn new technologies and methodologies.

Gareth Swanepoel

Twitter: - @GarethSwan

Contact: http://mygareth.com

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

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

Kendal is a database strategist, community advocate, public speaker, and blogger. A practiced IT professional with over 15 years of SQL Server experience, Kendal excels at disaster recovery, high availability planning/implementation, amp; debugging/troubleshooting mission critical SQL Server environments. Kendal is a Senior Consultant on the Microsoft Premier Developer Support team and President of MagicPASS (http://magicpass.sqlpass.org), the Orlando, FL based chapter of PASS. Before joining Microsoft, Kendal was a SQL Server/Data Platform MVP from 2011-2016.

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!

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.

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.

Devin Knight

Twitter: - @knight_devin

LinkedIn: Devin Knight

Contact: http://devinknightsql.com

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

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

Andy Warren

Twitter: - @sqlandy

Contact: https://sqlandy.com

miguel Cebollero

Twitter: - SQLMiguel

LinkedIn: miguel Cebollero

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

Devin Knight

Twitter: - @knight_devin

LinkedIn: Devin Knight

Contact: http://devinknightsql.com

Gareth Swanepoel

Twitter: - @GarethSwan

Contact: http://mygareth.com

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

Brett Johnson

Twitter: - @tegile

LinkedIn: Brett Johnson

15 years in IT Storage Database and virtualization focus Certifications: •VMware •Citrix •Cisco UCS •NetApp •EMC

Mitchell Pearson

Twitter: - @MitchellSQL

Contact: http://www.mitchellpearson.com

Mitchell is an experienced Business Intelligence Consultant and Trainer at Pragmatic Works and is currently the content training manager leading content development and delivery of training courses. Mitchell is experienced developing BI solutions using the full Microsoft BI Stack (SSRS, SSIS, and SSAS) as well as Microsoft Power BI. He is also very active in the community speaking at SQLSaturday events, local user groups, and online virtual events. Mitchell also blogs at mitchellpearson.com.

Maximo Trinidad

Twitter: - maxtrinidad

LinkedIn: Maximo Trinidad

Contact: http://www.maxtblog.com

Jorge Besada

Jorge Besada is a SQL Server DBA with more than 15 years experience as a DBA. An electronic engineer in a previous life with an MSEE degree, Jorge morphed into an Information Technology professional and is enjoying every minute of it. His main interest is in automation of all tasks using PowerShell and Python and switching between them as needed.

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.

Kendal Van Dyke

Twitter: - SQLDBA

LinkedIn: Kendal Van Dyke

Contact: http://www.kendalvandyke.com

SQLSaturday #379 - South Florida 2015

Sessions

Title: Changing Data Is Easy, Managing Data Change is Hard!

Title: Reporting on Your Cube with SSRS

Title: Creating an End to End Power View Reporting Solution

Title: Once Upon a DateTime

Title: Big Data Mining with SSAS, Azure Machine Learning Mahout

Title: The Quest to Find Bad Data With Data Profiling

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

Title: Taking the Scary out of Monster Reports

Title: Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers

Title: Tone Analysis with HDInsight and Azure Machine Learning

Title: Indexing for Join Optimization

Title: Turbocharge Your Career With a Learning Plan

Title: Welcome to SSAS Tabular Models

Title: Encryption 101: A look at SQL Encryption Options

Title: An Entity Framework Crash Course for the Busy DBA.

Title: Partitioning and Partial Databases for HA for VLDB

Title: SQL Server 2014 In-Memory from evey angle

Title: SQL Design and Retrieval for Analysts and Testers using SQL Server 2014

Title: Introducing the Reimagined Power BI Platform

Title: Introduction to Hive with Microsoft Azure HDInsight

Title: Configuring AlwaysON availability groups with Readable Secundaries

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

Title: Indexing strategies and good physical designs for performance tuning

Title: But I Want it in Excel…

Title: Calculated Columns, Measures, and KPIs, Oh My!

Title: Easier schema migrations, data migrations more w/ Redgate tools

Title: Azure Data Services – Real-time Analytics

Title: Do You Have A Case Of Mistaken IDENTITY?

Title: SQL Server 2014 for the DBA

Title: Process SSAS Cubes with SSIS

Title: Transactional Replication: Architecture, Setup, and Monitoring

Title: PRECON - SQL Server High Availability

Title: Writing Better T-SQL Queries with Window Functions

Title: Rolling Database Snapshots

Title: Tips and Tricks for Dynamic SSRS Reports

Title: SQL Server solutions in Azure

Title: PowerShell and Python - The Clash - Part Deux

Title: What’s new in SQL 2016?

Title: Building Solutions for Power BI QA

Title: T-SQL Window Function Performance

Title: Indexing for performance

Title: SSMS: The Untold Secrets

Title: Getting Started with Power Query

Title: R intro for the SQL Server Pro

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

Title: An Introduction to Big Data, Hadoop and Microsoft Azure HDInsight.

Title: Querying Active Directory From SSRS To Secure Reports And Enhance The User Experience

Title: How to be a GREAT DBA

Title: SQL Server and Windows 10: Data Security and Compliance

Title: SQL Azure + Azure Machine Learning to predict Home Values - HOL

Title: SQL Server and Microsoft Business Solutions - Tegile

Title: PowerShell with Visual Studio SQL Data Tools

Title: Learn about Governed Data Discovery with Pyramid Analytics

Title: Powershell Working with Windows Azure SQL Database Server

Title: Database Virtualization and Drinking out of the Fire Hose

Title: NO-SQL For the DBA

Title: SELECT * FROM CorpDB1 WHERE (value_data lt;gt; 0)

Title: Reusable ssis development using Parent - Child methodology

Title: SQL Server 2014 In-Memory Programming

Title: Dynamic SSIS Frameworks for complex file Structures

Speakers

Sponsors