Nr: 755
SQLSaturday #755 - South Florida 2018
SessionID: 80044
Patterns for Managing Your Career Learning Needs
Event Date: 09-06-2018 - Session time: 09:45:00 - Track: Professional Development
Speaker: Andy Warren
Title: Patterns for Managing Your Career Learning Needs
Abstract:
Most of us want to "keep up" with changes in the technologies we use and most of us feel like we're failing to do so. Can that be right? Is it possible to learn what what we need to learn in order to stay current and still have time for a life outside of work? It is!
This presentation is about patterns you can apply to how and when you learn. My goal is to give you the ideas and techniques that will help you learn effectively and do so for your entire career - something you can use for 40 years!
Attendees - bring your lists. Bring the list of stuff of you want to learn or think you should learn. Take a few minutes to write down the challenges you've had in 'keeping up'. We'll discuss some during the session and I'll be available afterward for one on one conversations for the rest!
SessionID: 80388
Populating a Data Warehouse with SSIS and Biml Patterns
Event Date: 09-06-2018 - Session time: 09:45:00 - Track: Business Intelligence
Speaker: Jim Miller
Title: Populating a Data Warehouse with SSIS and Biml Patterns
Abstract:
Attend to see how Biml can revolutionize your SSIS development!
SessionID: 82157
Data Science: Supervised and Unsupervised machine learning
Event Date: 09-06-2018 - Session time: 09:45:00 - Track: Data Science
Speaker: Josh Kodi
Title: Data Science: Supervised and Unsupervised machine learning
Abstract:
Continuation of previous year track from basic concepts of Conditional Probability Regression to supervised and unsupervised machine learning techniques.
In this session, we will look at various supervised ML techniques including Decision Trees, Random Forest as well as unsupervised techniques such as Clustering. and Principle Component Analysis.
The session includes theory around each of the technique as well as a demo using a sample data set.
SessionID: 82253
I know what you did last transaction: Auditing using CDC, Temporal Tables and Triggers
Event Date: 09-06-2018 - Session time: 09:45:00 - Track: DevOps
Speaker: Eric Berkowitz
Title: I know what you did last transaction: Auditing using CDC, Temporal Tables and Triggers
Abstract:
There have been more advancements in the topic of auditing SQL inserts, updates and deletes during the past few years than in the nearly 30-year history of SQL Server. Eric Berkowitz presents a fast-paced, live demonstration and comparison of Change Data Capture, the new SQL Temporal Tables and conventional trigger-based methods. Gain the ability to audit, research and report on data changes, without recoding existing applications and proactively plan for auditing in new systems. Understand the overhead and performance implications and storage and retention options for each approach. See how querying, DDL changes and compatibility considerations vary among the methods so you can make informed decisions about implementing auditing in your system.
SessionID: 82334
Intro into SQL Server High Availability Technologies
Event Date: 09-06-2018 - Session time: 09:45:00 - Track: DBA Beginners
Speaker: Harold Velazquez
Title: Intro into SQL Server High Availability Technologies
Abstract:
In this session, Harold will provide the overview of SQL Server HA/DR Technologies such as AlwaysOn Failover Clustering, AlwaysOn Availability Groups, Log Shipping, and Replication. You will learn how those technologies are implemented, their benefits, downsides, best use-cases, and choose the propper technology to meet business requirements.
SessionID: 82335
Cautionary Tale of Recompilations, Excessive CPU Load and Plan Caching
Event Date: 09-06-2018 - Session time: 09:45:00 - Track: DBA Advanced
Speaker: Dmitri Korotkevitch
Title: Cautionary Tale of Recompilations, Excessive CPU Load and Plan Caching
Abstract:
In this session, Dmitri will explain how plan caching works internally and demonstrate how to address several common issues related to the plan caching. He will talk about parameter sniffing, simple and forced parameterization, OPTIMIZE FOR UNKNOWN strategy, and several other related topics. Finally, Dmitri will provide the guidelines how to reduce CPU load and recompilation overhead in the systems with heavy ad-hoc workload and non-parameterized queries.
SessionID: 82371
Advancements in Azure Database
Event Date: 09-06-2018 - Session time: 09:45:00 - Track: Azure Cloud
Speaker: Pankaj Satyaketu
Title: Advancements in Azure Database
Abstract:
This will be the third time delivering this session in South Florida and much has changed in the past year. In this session I will be covering the new enhancements added to the service in the past year including Managed Instance, automatic tuning capabilities and support for Open Source databases.
I will wrap up the session with an overview of the shifting responsibilities of the DBA as cloud becomes more mainstream.
SessionID: 82428
Making Sense of the Power BI Ecosystem
Event Date: 09-06-2018 - Session time: 09:45:00 - Track: Analytics and Visualization
Speaker: Dustin Ryan
Title: Making Sense of the Power BI Ecosystem
Abstract:
Power BI has taken the world by storm since it's release in mid-2015. Since then, Microsoft's cloud analytics offering has matured and grown in scope and complexity. In this session, we'll seek to understand the moving parts of the Power BI ecosystem including Power BI Pro, Premium, Report Server, Embedded, the Common Data Service, and more. By the end of this session the audience should have a firm grasp on the ecosystem and when to use what.
SessionID: 74492
Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques
Event Date: 09-06-2018 - Session time: 11:00:00 - Track: Analytics and Visualization
Speaker: Kevin Feasel
Title: Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques
Abstract:
SessionID: 77085
Blockchain - A Database Architecture Paradigm Shift
Event Date: 09-06-2018 - Session time: 11:00:00 - Track: DBA Beginners
Speaker: Joe Homnick
Title: Blockchain - A Database Architecture Paradigm Shift
Abstract:
Joe takes you on an easy to understand journey of Blockchain technology. Blockchain is the basis of Cryptocurrencies such as Ethereum, Bitcoin etc., however, extends way beyond these as a framework for Smart Contracts.
To better understand developer Blockchain opportunities, Joe deploys an Ethereum simulated multi-member network in Azure, consisting of a set of load-balanced transaction nodes with which an application or user can interact to submit transactions and a set of mining nodes to record transactions.
Joe will also investigate new toolsets coming out to assist in Blockchain Development including CoCo Framework, App Builder and Enterprise Smart Contracts.
SessionID: 80883
Event Date: 09-06-2018 - Session time: 11:00:00 - Track: DBA Advanced
Speaker: Jeffrey Garbus
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
SessionID: 81988
Event Date: 09-06-2018 - Session time: 11:00:00 - Track: Business Intelligence
Speaker: Jonathan Stewart
Abstract:
SessionID: 82016
Event Date: 09-06-2018 - Session time: 11:00:00 - Track: DevOps
Speaker: John Wells
Abstract:
SessionID: 82296
Migrate your On-Prem Database to Azure SQL Database
Event Date: 09-06-2018 - Session time: 11:00:00 - Track: Azure Cloud
Speaker: Joe Abbott
Title: Migrate your On-Prem Database to Azure SQL Database
Abstract:
Do I want to migrate my on-prem database to Azure? If yes, then how? Excellent questions! We will briefly discuss why you want to migrate to Azure, and then I will show you how to do it! Join me in this demo driven session where we will walk through the options and migration of an on-prem SQL Server database to an Azure SQL Database.
SessionID: 82472
Applied Machine Learning with Python
Event Date: 09-06-2018 - Session time: 11:00:00 - Track: Data Science
Speaker: Adriano da Silva
Title: Applied Machine Learning with Python
Abstract:
This is an introduction designed for those with minimal or no Machine Learning experience. It is also an applied session focused on getting answers from data, and it does not emphasize the Math behind the ML model. The examples leverage the Python programming language integration with SQL Server 2017 Machine Learning Services (In-Database).
Most importantly, those examples are designed in a manner that are easy to understand and to spur your future exploration, by making it possible for you to replicate and use it to expand your knowledge.
SessionID: 82544
Career Panel - What You Need To Know
Event Date: 09-06-2018 - Session time: 11:00:00 - Track: Professional Development
Speaker: Adam Weiss
Title: Career Panel - What You Need To Know
Abstract:
We all know how important tech is right now - but what happens when hiring managers don't know how to find the candidates they need, and they candidates don't know what the managers are truly looking for?
In this career panel we will dig into the manager / candidate gap that is prominent in the marketplace, and how to progress your career by being able to establish yourself as a leader in your field. Whether you are someone involved in the hiring process, or someone looking to move your career forward, this panel is for you!
SessionID: 83049
Event Date: 09-06-2018 - Session time: 11:00:00 - Track: DevOps
Speaker: Maxim Sobolevskiy
Abstract:
Now IDEs on IntelliJ-platform are one of the most popular tools for developers. More than two million people use IntelliJ IDEA, PyCharm and other IDEs. At the same time, they use various SQL clients for writing and executing statements. But working with SQL is possible just from these IDEs. There is also a stand-alone IDE for SQL called DataGrip which was created based on a huge expertise in code-insight which JetBrains, IntelliJ creators, have. In this session, I will briefly show main tips and tricks of using database support inside IDE's based on IntelliJ platform.
— Tips for writing and executing statements
— Editing data from UI
— Using code completion and code inspections
— Comparing result-sets
— Searching through database objects
— Navigating through data
— and other features.
SessionID: 83515
Using PowerBi to troubleshoot SQL Server instances
Event Date: 09-06-2018 - Session time: 11:00:00 - Track: DBA Advanced
Speaker: Sam Mesel
Title: Using PowerBi to troubleshoot SQL Server instances
Abstract:
Participants will learn how to configure a performance collection, how to collect and analyze performance data and use Power BI to review SQL Server bottleneck that are exposed by the interactive visual experience Power BI offers.
Disclaimer: Demo filled session, few slides
SessionID: 77077
For Love or Money, Your Tech Career
Event Date: 09-06-2018 - Session time: 12:30:00 - Track: Professional Development
Speaker: Alex Funkhouser
Title: For Love or Money, Your Tech 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 biweekly direct deposit salary is comforting. But do you ever feel technologically “stuck” at your job when so many other technology professionals are using the latest, most marketable technologies?
In this highly interactive group session, you will learn multiple career strategies for maximizing both the Love and the Money of your multidimensional technology career.
SessionID: 82169
Dell: #GetModern with Dell EMC
Event Date: 09-06-2018 - Session time: 12:30:00 - Track: DevOps
Speaker: Dominick DeQuarto
Title: Dell: #GetModern with Dell EMC
Abstract:
SessionID: 83381
Database Backup and Restore Best Practices
Event Date: 09-06-2018 - Session time: 12:30:00 - Track: DBA Beginners
Speaker: Michael Fal
Title: Database Backup and Restore Best Practices
Abstract:
Backups are a vital part of any DBA's job. Acting as the "last line of defense", we rely on backups to safeguard the company's most important asset: the data. But how do we know we're managing our backups appropriately? This session will cover the fundamental principles of building out our backup (and restore strategy), covering the "why" of backups and best practices for our data protection.
SessionID: 74493
Much Ado About Hadoop
Event Date: 09-06-2018 - Session time: 13:30:00 - Track: Business Intelligence
Speaker: Kevin Feasel
Title: Much Ado About Hadoop
Abstract:
SessionID: 74503
Brand yourself like a pro 2.0 "How to tell the story"
Event Date: 09-06-2018 - Session time: 13:30:00 - Track: Professional Development
Speaker: Patricia Monica Ojeda
Title: Brand yourself like a pro 2.0 "How to tell the story"
Abstract:
Building a brand has to be intentional. You cannot just be you. Discovering the things that make you unique is not enough. You have to package these things in a way that highlights and perhaps even over exaggerates them.
In this interactive session, you will learn how to use Social Media to create your personal brand to positioning yourself as a pro, telling the story in the way that the people want to hear at the same time that you increase your self-confidence.
SessionID: 74598
Hack / Protect / Predict SQL Server - Come learn them.
Event Date: 09-06-2018 - Session time: 13:30:00 - Track: DBA Advanced
Speaker: Hiram Fleitas
Title: Hack / Protect / Predict SQL Server - Come learn them.
Abstract:
- Tabular Data Stream (TDS) Protocol
- Dynamic Data Masking
- Row Level Security (Yep...)
- Database Source Control
Perhaps, you've seen these exploits before but do you really know how to reproduce them? Or, how to even protect yourself against them? No worries, I'll show you the way along with a load test.
Finally, I am very excited to share with you how to analyze text using pre-trained Machine Learning models to predict a sentiment, on-prem with SQL Server 2017.
- SQL ML / AI - A deep dive to predict the sentiment
Looking forward to meeting you all.
SessionID: 74633
Getting started with SQL Azure Database: What you need to know
Event Date: 09-06-2018 - Session time: 13:30:00 - Track: Cloud Application Development Deployment
Speaker: Jim Donahoe
Title: Getting started with SQL Azure Database: What you need to know
Abstract:
Azure SQL Database offers a way to quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore.
In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible.
By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
SessionID: 80493
Improve Your Knowledge of the Optimizer and Statistics!
Event Date: 09-06-2018 - Session time: 13:30:00 - Track: DBA Beginners
Speaker: Julie McLain-Harper
Title: Improve Your Knowledge of the Optimizer and Statistics!
Abstract:
SessionID: 82236
Quick and Dirty Push Datasets with Power BI
Event Date: 09-06-2018 - Session time: 13:30:00 - Track: Analytics and Visualization
Speaker: Gary Lock
Title: Quick and Dirty Push Datasets with Power BI
Abstract:
Using Power BI, you can connect to hundreds of different data sources. Once you have published your data to the Power BI service, you can use an on-premises gateway to refresh your datasets up to every 15 minutes. Power BI can also connect live to large cubes that are a result of very complex ETL and calculations. Some of these cubes may only be refreshed daily or weekly. For real-time streaming of data, you can use Azure Stream Analytics or the Power BI REST API.
Have you heard of Power BI push datasets? With push datasets, data is pushed into the Power BI service. Since it is stored there, you can use all of Power BI's report building features with it.
In this session, I walk through the different options for real-time streaming in Power BI. I will demonstrate setting up a push dataset and show you a very easy way to push data to Power BI using PowerShell. I will also demonstrate a Power BI push dataset connected to a Microsoft Cognitive Services Computer Vision app.
SessionID: 82290
Adaptive Query Processing in SQL 2017 and Azure SQL Database
Event Date: 09-06-2018 - Session time: 13:30:00 - Track: DBA Advanced
Speaker: Sherwin Anderson
Title: Adaptive Query Processing in SQL 2017 and Azure SQL Database
Abstract:
Come see how you can benefit from a self-learning artificial intelligent database.
SessionID: 82556
The building blocks of Azure Databricks
Event Date: 09-06-2018 - Session time: 13:30:00 - Track: Cloud Application Development Deployment
Speaker: Diana Betancourt
Title: The building blocks of Azure Databricks
Abstract:
SessionID: 74488
Are They Hearing What You Said - or Something Completely Different?!
Event Date: 09-06-2018 - Session time: 14:45:00 - Track: Professional Development
Speaker: Brad Raney
Title: Are They Hearing What You Said - or Something Completely Different?!
Abstract:
• How to control their voice tone and inflection to improve their message delivery;
• How to develop and improve their active listening skills;
• How to use non-verbal cues to their advantage; more
SessionID: 74490
APPLY Yourself
Event Date: 09-06-2018 - Session time: 14:45:00 - Track: DevOps
Speaker: Kevin Feasel
Title: APPLY Yourself
Abstract:
SessionID: 78565
Temporal Tables: Creation, Use, and Optimizing
Event Date: 09-06-2018 - Session time: 14:45:00 - Track: DBA Beginners
Speaker: Dale Sullenberger
Title: Temporal Tables: Creation, Use, and Optimizing
Abstract:
SessionID: 80079
Introduction to IoT using Azure
Event Date: 09-06-2018 - Session time: 14:45:00 - Track: Azure Cloud
Speaker: John Wang
Title: Introduction to IoT using Azure
Abstract:
Ever wondered on what is the buzz about Internet of Things (IoT)? and interested in making your own?
We will take an look on what is Internet of Things (IoT), the impact of IoT to the world, industries that IoT can disrupt and then, we will provide an overview of building an IoT solutions using various technologies in Azure such as IoT Hub, Functions, Stream Analytics, Power BI, and more.
SessionID: 80932
Modis and R
Event Date: 09-06-2018 - Session time: 14:45:00 - Track: Data Science
Speaker: Stephen Ippolito
Title: Modis and R
Abstract:
SessionID: 81990
Data Visualization: How to truly tell a great story!
Event Date: 09-06-2018 - Session time: 14:45:00 - Track: Analytics and Visualization
Speaker: Jonathan Stewart
Title: Data Visualization: How to truly tell a great story!
Abstract:
We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…
SessionID: 82017
“The Modern Data Architecture: Business Intelligence (BI) and Big Data Management Systems (BDMS)”
Event Date: 09-06-2018 - Session time: 14:45:00 - Track: Business Intelligence
Speaker: Frank Quintana
Title: “The Modern Data Architecture: Business Intelligence (BI) and Big Data Management Systems (BDMS)”
Abstract:
The arrival of the Big Data movement (Hadoop and NoSQL) is changing the enterprise data architecture.
In this presentation, I will describe the advantages and disadvantages of OLTP, OLAP and Big Data, and the increase of BDMS (BIG DATA MANAGEMENT SYSTEMS). I will show how the Modern Database Architecture landscape is changing.
I also intend to present a general description of the techniques and tools used in The Modern Data Architecture
SessionID: 82460
SQL Server Query Plans - Journeyman and Beyond
Event Date: 09-06-2018 - Session time: 14:45:00 - Track: DBA Advanced
Speaker: Ernest Libertucci
Title: SQL Server Query Plans - Journeyman and Beyond
Abstract:
SessionID: 83520
Artificial Intelligence, Cognitive Services, and Power BI
Event Date: 09-06-2018 - Session time: 14:45:00 - Track: Data Science
Speaker: Paco Gonzalez
Title: Artificial Intelligence, Cognitive Services, and Power BI
Abstract:
Microsoft Cognitive services is a series of services based on Microsoft Research using Deep Learning techniques, ready for you to enrich your unstructured data. Microsoft Services includes: Vision (Computer Vision, Emotion, Face, Video), Speech/Language (Speaker Recognition, Spell, Sentiment, Language, Key Phrases, Topic detection, Linguistic Analysis), Knowledge, and Search. These services are consumed by using the Cognitive Services APIs. Power BI enables you to consume the APIs to enrich your unstructured data inside your Power BI solutions. During this session, we will cover how to consume the API using Power Query to then visualize the results with Power BI visuals. We will also consume the Cognitive services API by using a R script inside Power BI. This session is structured with a B2C Survey case study solution with a real time Dashboard using a streaming dataset.
SessionID: 74634
New Instance, Now what?
Event Date: 09-06-2018 - Session time: 16:00:00 - Track: DBA Beginners
Speaker: Jim Donahoe
Title: New Instance, Now what?
Abstract:
Congratulations, you’re now our DBA! A new SQL instance is like a blank canvas, you stare at it and wonder where to start. As an accidental dba, this session will help you learn how to survive in your new role.
In this session, you will be supplied with the beginning brush strokes to make your server a master piece. To do so, we will review best practices for standard configurations, backups, maintenance, and disaster recovery.
By the end of this session, you will have developed a pallet of tools to help you create your SQL Server Masterpiece and be able to use it as a print for others.
SessionID: 78667
Power BI for large databases
Event Date: 09-06-2018 - Session time: 16:00:00 - Track: Analytics and Visualization
Speaker: Hector Villafuerte
Title: Power BI for large databases
Abstract:
Today's enterprise business analytics requires run complex analytic queries against large datasets stored in different sources like Azure SQL Database, Azure SQL Data Warehouse or Amazon Redshift data warehouse.
In this session, BI Architect and Microsoft Certified Professional, Hector Villafuerte focuses upon the design, architecture and best practices that allows Power BI to offer the best functionality and performance combination. Throughout the session, we explore various large datasets and witness how to implement Power BI in different modes to achieve high performance and capabilities.
SessionID: 82018
Event Date: 09-06-2018 - Session time: 16:00:00 - Track: Professional Development
Speaker: Frank Quintana
Abstract:
Data Science techniques are becoming popular and because statistics usually teaches at the Math Department people think of it as an exact science but Statistic is the science of prediction and expectations. In the excitement of the possibilities that Big Data technology and Data Science techniques are opening, we are forgetting that correlation is not equal than causation and that any design model has intrinsic limitations.
Dr. Deming said "In God we trust, all others must bring data." but what he really wanted to reach was Wisdom! Data is just the raw material the real goal is Wisdom I have been thinking about the chain toward Wisdom (Data-Information-Knowledge-Wisdom) and wonder how many organizations have reached, at least, the level of Knowledge and if any at all have reached the pinnacle of Wisdom.
We are drowning in a sea of data and we are starving for wisdom.
How is Data Science and Big Data changing our profession? What is a Data Scientist? Which skills do we need?
SessionID: 82555
So You think You can Speak?
Event Date: 09-06-2018 - Session time: 16:00:00 - Track: Professional Development
Speaker: Diana Betancourt
Title: So You think You can Speak?
Abstract:
If you've ever enjoyed or admired the knowledge and know-how of a speaker at a SQL Saturday or a Summit , 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 Microsoft 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 here!
"Do You Think You can Speak" is a friendly competition for anyone, even first time speakers, to share for 5 - 10 minutes on a technical topic, SQL, Business Intelligence, Power BI, or otherwise, that is informative, useful, and entertaining.