sqlsathistory

Nr: 864

Back to Main list

SQLSaturday #864 - South Florida 2019

Start Time (24h) Speaker Track Title
09:45:00 Mike Byrd Application Database Development Indexing Like a Rocket Scientist
09:45:00 Brent Ozar DBA Beginners What to Do When SQL Server is Unusually Slow
09:45:00 Leveat Ruse Professional Development Interviewing-Be So Good They Can’t Ignore You
09:45:00 Dustin Ryan Application Database Development Building a Data Warehouse from the Ground Up
09:45:00 Satya Jayanty Cloud Application Development Deployment Azure Cosmos DB - What you need to know to build globally distributed apps?
09:45:00 Cecilia Brusatori Analytics and Visualization Power BI: From Ground to the Cloud (Getting started)
09:45:00 Mike Burek Application Database Development Is Azure Data Studio Better Than SSMS?
09:45:00 Audrey Hammonds Data Science How AI Saved My Great-Grandma's Cookbook
09:45:00 Leila Etaati Artificial Intelligence AI Application for everyone: Microsoft Power Apps, Cognitive Service, and Flow
09:45:00 Dave Noderer IoT My IOT Journey
09:45:00 Ibis Fonte Analytics and Visualization eCommerce Strategies found through usage data
11:00:00 Brent Ozar Enterprise Database Administration Deployment What's New in SQL Server 2019: 100% Demos
11:00:00 Vishal Pawar Business Intelligence Learn Power BI Report Server Enterprise Architecture, Tools to publish reports and Best Practice
11:00:00 Vigi Kuruvilla Professional Development Vision, Mission, Goals Strategies
11:00:00 Joe Homnick Business Intelligence Artificial Intelligence (AI) Democratized with Power BI
11:00:00 Darius Liktorius Cloud Application Development Deployment SQL Server in the Cloud: Microsoft Azure vs Amazon Web Services (AWS)
11:00:00 Santosh Kanthety Analytics and Visualization Are you Running on Insights?
11:00:00 Eddy Djaja Enterprise Database Administration Deployment Tips of Running a Well-Oiled Database Team
11:00:00 Hiram Fleitas Cloud Application Development Deployment The Power Platform Game Changer
11:00:00 Pankaj Satyaketu Analytics and Visualization Say what now? SQL Server 2019 + Spark + HDFS???
11:00:00 Jay Rajendran Analytics and Visualization Run Like Google: Server-less Data warehousing and Analytics on Google Cloud Platform
11:00:00 Eumar Assis Azure Cloud Building AI-powered Solutions with Microsoft Azure
11:00:00 Diana Betancourt Azure Cloud Exploring Big data technologies and how unlock everything you thought you knew about your data!
12:30:00 Diane Schuster Business Intelligence CozyRoc: Dynamic Data Flows in SSIS Without Programming
12:30:00 SQL Saturday South Florida Cloud Application Development Deployment DELL Gold Sponsored Session
12:30:00 Tom Staab Cloud Application Development Deployment Best Practices for SQL Server on AWS
12:30:00 Janis Griffin Enterprise Database Administration Deployment Database Performance Monitoring
13:40:00 Andy Warren Application Database Development Constraints are the Key (to Data Integrity)
13:40:00 Dustin Ryan Business Intelligence Power BI Governance 101
13:40:00 Eddy Djaja Enterprise Database Administration Deployment What Is Clogging Your Database Performance?
13:40:00 Adriano da Silva Data Science An Introduction to Power BI for Data Science With Python
13:40:00 Patricia Monica Ojeda Professional Development Branding and Neuro-Marketing
13:40:00 Hiram Fleitas Application Database Development Real-time Sentiment Prediction in SQL Server
13:40:00 Satya Jayanty Enterprise Database Administration Deployment DevOPS for DBAs - Where is your magic wand?
13:40:00 Maximo Trinidad Application Database Development PowerShell Core - Fundamental on How-To Persist Data in a SQL Server Container
13:40:00 Ernest Libertucci Application Database Development Hadoop, Hive, and Big Data For MSSQL Professionals
13:40:00 oscar garcia Analytics and Visualization Build a Modern Data Warehouse from disparate sources and visualize the data with PowerBI
13:40:00 Audrey Hammonds Cloud Application Development Deployment Into the Deep End with Azure Data Lake Store Generation 2
13:40:00 Alex Funkhouser Professional Development For Love or Money, Your Tech Career
14:55:00 Mike Byrd Application Database Development Climbing the SQL Server Index B-Tree
14:55:00 Oscar Zamora Cloud Application Development Deployment Azure SQL DW. Redefining MPP, how it stacks against Snowflake and RedShift
14:55:00 Daniel Shrader Cloud Application Development Deployment Containerize your learning - a docker introduction
14:55:00 Dmitri Korotkevitch Enterprise Database Administration Deployment Intro Into Index Analysis
14:55:00 Travis Page Enterprise Database Administration Deployment Look, over there, your permissions are showing!
14:55:00 Hector Villafuerte Business Intelligence Artificial Intelligence (AI) for Business Intelligence
14:55:00 Alexander Fleming Application Database Development Why You Should Consider Implementing Indexed Views
14:55:00 William Wolf Application Database Development Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry
14:55:00 James McAuliffe Enterprise Database Administration Deployment Changing Data Is Easy, Managing Data Change is Hard!
14:55:00 Dale Sullenberger Application Database Development Temporal Tables: Creation, Use, and Optimizing
14:55:00 Mike Burek Application Database Development Basic Windowing Functions
14:55:00 Frank Quintana Professional Development “Past, Present, and Future of the Data Profession" Part 1- "Relational Databases Vs. NoSQL"
16:00:00 Dale Sullenberger Enterprise Database Administration Deployment Temporal Tables - Managing Large Data Sets and Their Effects on Performance
16:00:00 Hiram Fleitas Application Database Development Hack / Protect SQL Server - Come learn both.
16:00:00 Frank Quintana Professional Development “Past, Present, and Future of the Data Profession“ Part 2- "Data Profession in the 21st Century"
16:00:00 Dmitri Korotkevitch Enterprise Database Administration Deployment 5 Availability Groups Issues That May Ruin Your Day
16:00:00 SQL Saturday South Florida Analytics and Visualization PowerBI Challenge

SessionID: 89394

Indexing Like a Rocket Scientist

Back to calendar

Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: Indexing Like a Rocket Scientist

Abstract:

Performance is what your users care about, and indexes can both improve and decrease

performance. As a SQL Developer, do you understand the difference between a clustered and non-clustered index or what a covering index is? What is different between OLTP and data warehouse databases when it comes to indexing? This session is a deep dive into  Clustered indexes  Non-clustered indexes  B-Tree traversal  Primary Keys  Covering indexes

This session will feature live query demos illustrating index utilization and performance using statistics and query plans. Understand indexing like a rocket scientist by attending this session!

Some knowledge of T-SQL and Management Studio is recommended.

SessionID: 89420

What to Do When SQL Server is Unusually Slow

Back to calendar

Event Date: 08-06-2019 - Session time: 09:45:00 - Track: DBA Beginners

Speaker: Brent Ozar

Title: What to Do When SQL Server is Unusually Slow

Abstract:

“Is something going on with the SQL Server right now?” You hear those words, and your heart starts to race a little faster. You try to connect to the SQL Server, and it responds, but you can tell it’s a little slow. You open up Activity Monitor, look at recent expensive queries, and maybe open up the Windows event logs to see if anything’s happened recently.

There’s gotta be a better way, right?

Good news – there is, and you’re about to learn how the pros do it. In one all-demo session, you’ll watch Brent Ozar use sp_WhoIsActive, sp_BlitzFirst, and sp_BlitzCache to solve several common emergencies. You’ll walk away with a written checklist to solve typical performance emergencies.

SessionID: 89699

Interviewing-Be So Good They Can’t Ignore You

Back to calendar

Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Professional Development

Speaker: Leveat Ruse

Title: Interviewing-Be So Good They Can’t Ignore You

Abstract:

From the basics to the advanced, we will explore techniques that will ensure you leave a positive impression and help you land that role!

SessionID: 89732

Building a Data Warehouse from the Ground Up

Back to calendar

Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Dustin Ryan

Title: Building a Data Warehouse from the Ground Up

Abstract:

What if you could approach any business process in your organization and quickly design an effective and optimal dimensional model using a standardized step-by-step method? In this session we'll discuss the steps required to design a unified dimensional model that is optimized for reporting and follows widely accepted best practices. We'll also discuss how the design of our dimensional model affects a semantic modeling technologies like SQL Server Analysis Services or Power BI and how the choices we make during the data warehouse design phase can make or break our reports.

SessionID: 91615

Azure Cosmos DB - What you need to know to build globally distributed apps?

Back to calendar

Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: Satya Jayanty

Title: Azure Cosmos DB - What you need to know to build globally distributed apps?

Abstract:

In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB. There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.

SessionID: 92325

Power BI: From Ground to the Cloud (Getting started)

Back to calendar

Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Cecilia Brusatori

Title: Power BI: From Ground to the Cloud (Getting started)

Abstract:

Power BI is the Leading self-service analytics solution in the market. This session is for beginner users wishing to incorporate PBI to their skill-set and boost their Professional careers.

We will go on a quick tour of the different options offered by the tool, basic concepts, followed by demos and best practices that will let you to start your journey creating fantastic and interactive visualizations. Attendees will have the opportunity to learn how to get and shape data from different sources, create Reports, publish to the cloud and create dashboards.

SessionID: 93059

Is Azure Data Studio Better Than SSMS?

Back to calendar

Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Mike Burek

Title: Is Azure Data Studio Better Than SSMS?

Abstract:

Does SSMS sometimes bug you? Do you feel like Microsoft will never add new features to SSMS?

Despite the name, Azure Data Studio works for both on-prem and cloud versions of SQL Server. You might have heard its previous name, SQL Server Ops (Operations) Studio.

Updates are coming out every month, making it easier to use, fixing bugs, and adding exciting new features. Come see some if these new features deserve a spot in your daily toolbox to make your work day easier.

SessionID: 93184

How AI Saved My Great-Grandma's Cookbook

Back to calendar

Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Data Science

Speaker: Audrey Hammonds

Title: How AI Saved My Great-Grandma's Cookbook

Abstract:

True Story... My great-grandmother's cookbook from 1937 was crumbling. It had her hand-written adjustments to recipes, her own additions, and was a prized possession within our family. Come learn how I leveraged the open-source JFK Files Project on Microsoft's GitHub (with a few modifications) to turn 150 pages of ancient cookbook into a cool searchable website.

This session demonstrates how you can use both the built-in and custom AI in Cognitive Search. Cognitive Search ingests your data from almost any data source and enriches it using a set of cognitive skills that extracts knowledge and then lets you explore the data using Azure Search. I'll show you how to use this framework to index and search documents, photos, and hand-written text. The public GitHub repo is available at: https://github.com/Microsoft/AzureSearch_JFK_Files

SessionID: 93632

AI Application for everyone: Microsoft Power Apps, Cognitive Service, and Flow

Back to calendar

Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Artificial Intelligence

Speaker: Leila Etaati

Title: AI Application for everyone: Microsoft Power Apps, Cognitive Service, and Flow

Abstract:

These days, Using AI is not limited to writing R or Python codes. There are different API that allows developers, business intelligence consultant and others to create an AI application or report without writing any single code. Microsoft Cognitive service is a toolkit that allows this for all Microsoft users. In this session, an overview on cognitive service will be provided, and attendees will see how to create an OCR (image to text application) to take a photo from an image in Power Apps, then how to use a combination of Microsoft flow and Cognitive service to convert the taken image to text.

Moreover, the process of how to create a face recognition application (to detect the face,location in the picture, age, gender, emotion, hair color and so forth) using the Microsoft cognitive service, Power Apps and Microsoft Flow.

SessionID: 94578

My IOT Journey

Back to calendar

Event Date: 08-06-2019 - Session time: 09:45:00 - Track: IoT

Speaker: Dave Noderer

Title: My IOT Journey

Abstract:

I have been building an IOT device "AirMon" and will share what I've done, the tools I have used, how the decisions were made and what future refinements I want to make. It is still a work in progress but what I am learning should be helpful to others. Topics covered include devices, networks, Azure IOT Hub, Azure Functions, Azure WebApp and hardware design.

SessionID: 94581

eCommerce Strategies found through usage data

Back to calendar

Event Date: 08-06-2019 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Ibis Fonte

Title: eCommerce Strategies found through usage data

Abstract:

Usage data for eCommerce websites reveals not only secrets about your users, but also opportunities for new conversions. Find out how to best read what draws your eCommerce users, and how to use that data to make strategic business decisions, and user experience decisions that drive your users down the sales funnel and turns them into customers.

SessionID: 89418

What's New in SQL Server 2019: 100% Demos

Back to calendar

Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Brent Ozar

Title: What's New in SQL Server 2019: 100% Demos

Abstract:

You haven't installed SQL Server 2019 yet, and you don't want to sit through a bunch of slides. You want to see a series of real-world demos focusing on the features of SQL Server 2019 that will make your users happier with as little work as possible on your part. You don't have time to rewrite all your queries or learn new languages - you just want the database to go faster.

I'm Brent Ozar, and I'll give you the whirlwind tour. I'll focus on just the features that make the biggest bang for the buck, things you can implement right away and see a noticeable difference. I'll show you what kinds of code will benefit the most so you can go back to the office and have an honest discussion with management about what to expect.

No slides here - not even an about-me slide. Let's dive into some queries!

SessionID: 89612

Learn Power BI Report Server Enterprise Architecture, Tools to publish reports and Best Practice

Back to calendar

Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Business Intelligence

Speaker: Vishal Pawar

Title: Learn Power BI Report Server Enterprise Architecture, Tools to publish reports and Best Practice

Abstract:

To improve the performance, sustainability, security and scalability of enterprise-grade Power BI implementations with constant velocity, we need to adhere best practices

In this session Vishal will go over Power BI Ecosystem with Example, PBI RS evolution from its inception Architecture of Enterprise Power BI Report Server and usage through various tool available to publish -SSDT SSRS, Power BI Desktop(Optimized Version), Report Builder and mobile report builder and various Best Practices for PBI Report Server.

SessionID: 90664

Vision, Mission, Goals Strategies

Back to calendar

Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Professional Development

Speaker: Vigi Kuruvilla

Title: Vision, Mission, Goals Strategies

Abstract:

During my session I will talk about how to create a Vision, Mission, Goals Strategies for teams your personal career. I give example from big companies such Amazon also practical examples from the teams I manage. At the end of the session I hope to energize give you tools to create these elements for your teams yourself.

SessionID: 90877

Artificial Intelligence (AI) Democratized with Power BI

Back to calendar

Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Business Intelligence

Speaker: Joe Homnick

Title: Artificial Intelligence (AI) Democratized with Power BI

Abstract:

Power BI has new features that democratizes (makes accessible to all) AI capabilities. You don’t need to be a Data Scientist or write complicated Machine Learning scripts/routines to take advantage of AI with Power BI. Joe takes you on a demo rich learning experience of how all levels of users can implement AI capabilities in Power BI. These demos will include how to integrate both Amazon Web Services and Microsoft Azure Machine Learning packaged APIs into Power BI.

SessionID: 91099

SQL Server in the Cloud: Microsoft Azure vs Amazon Web Services (AWS)

Back to calendar

Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Cloud Application Development Deployment

Speaker: Darius Liktorius

Title: SQL Server in the Cloud: Microsoft Azure vs Amazon Web Services (AWS)

Abstract:

Migrating SQL Server to the Cloud or already there? Trying to decide which of the two leading Cloud Providers is best for your SQL Server solution? Using one, but always wondered about the other? What about using both for HA/DR? On the surface, the differences aren't immediately obvious, and several offerings parallel one another. We will review the various options for deploying SQL Server in both Azure and AWS, then dig under the covers on storage and performance to ensure the solution fits your needs. This session will benefit everyone from the beginner to the advanced professional.

SessionID: 91853

Are you Running on Insights?

Back to calendar

Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Santosh Kanthety

Title: Are you Running on Insights?

Abstract:

Ever wonder what insights you can gain from your own data? This presentation will take you through use cases like fitness data and web traffic monitoring from day to day life and explains how to turn data into powerful visuals and interactive analytics using Power BI. It's an interactive session that is best suited for beginners and intermediate users of Power BI Desktop and Cloud Service.

SessionID: 92323

Tips of Running a Well-Oiled Database Team

Back to calendar

Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Eddy Djaja

Title: Tips of Running a Well-Oiled Database Team

Abstract:

SessionID: 93019

The Power Platform Game Changer

Back to calendar

Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Cloud Application Development Deployment

Speaker: Hiram Fleitas

Title: The Power Platform Game Changer

Abstract:

This is a game changing session. Lets go 0 to 100 real quick by building a business app in minutes using PowerApps, Microsoft Flow and SQL Server. Then lets look at the enterprise-grade security to publish and share your app to iOS, Android, Web and Windows 10.

  1. T-SQL Stored Procedure on SQL Server database (on-prem or cloud).
  2. PowerApps (Inputs, Button, Outputs)
  3. Flow (Input, SQL Server, Variables, Respond, Tests)
  4. Gateway
  5. Publish Share with Enterprise Governance.

We'll have time for QA. Maybe we'll even ask Cortana a few questions. I look forward to seeing you there!

SessionID: 93106

Say what now? SQL Server 2019 + Spark + HDFS???

Back to calendar

Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Pankaj Satyaketu

Title: Say what now? SQL Server 2019 + Spark + HDFS???

Abstract:

Come learn about one of the ground breaking features being introduced in SQL Server 2019; SQL Server Big Data Clusters. With SQL Server 2019 Big Data clusters we can now create a highly scalable platform that can scale to petabytes of data and enable you to create data virtualization layer that connects to a variety of data sources such as your traditional Relation Databases, NoSQL and Big Data in one homogenized experience.

This is a completely different architecture that brings together a unified experience for SQL Server, Spark and HDFS.

Come join me for and overview and demonstration of the capabilities this platform can deliver.

SessionID: 93344

Run Like Google: Server-less Data warehousing and Analytics on Google Cloud Platform

Back to calendar

Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Jay Rajendran

Title: Run Like Google: Server-less Data warehousing and Analytics on Google Cloud Platform

Abstract:

If you are looking for a Data Engineering Platform to run your data warehousing and analytics workloads, look no further. Google Cloud Platform (GCP) offerings have been enabling Enterprises deploy, manage and scale their analytics workloads efficiently. Analyze all your batch and streaming data by creating a logical data warehouse over managed storage, as well as data from object storage and spreadsheets. Create blazing-fast dashboards and reports with the in-memory BI Engine. Build and operationalize machine learning solutions or carry out geospatial analysis using simple SQL. Securely share insights within your organization and beyond as datasets, queries, spreadsheets, and reports. Deliver a complete data platform without the burden of provisioning, scaling and upgrading infrastructure.

This session will provide a walk-through of Google's approach to Server-less Data warehousing, analytics and architectural patterns to address your needs.

SessionID: 93630

Building AI-powered Solutions with Microsoft Azure

Back to calendar

Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Azure Cloud

Speaker: Eumar Assis

Title: Building AI-powered Solutions with Microsoft Azure

Abstract:

Do you understand what does it take to build end-to-end Cloud solutions that leverage Artificial Intelligence (AI) and Machine Learning (ML) to empower users and customers to achieve more? Which AI technologies to choose and when? Which skills does a traditional DBA or developer need to learn in order to work with AI? Come and join this session to find the answer to these questions.

On this session, Eumar Assis, Microsoft Technology Strategist will review and demo the different technology options to create Intelligent applications that are powered by Microsoft Azure. Attendees will learn how to use state-of-the-art Azure services such as Power BI Embedded, Azure Cognitive Services, Azure Cognitive Search, and Azure Machine Learning Service that help augment human capabilities. At the end of this presentation, attendees will understand the Azure AI portfolio and what to use when. Attendees will also learn about some real-world applications that have been built using AI on Azure.

SessionID: 94926

Exploring Big data technologies and how unlock everything you thought you knew about your data!

Back to calendar

Event Date: 08-06-2019 - Session time: 11:00:00 - Track: Azure Cloud

Speaker: Diana Betancourt

Title: Exploring Big data technologies and how unlock everything you thought you knew about your data!

Abstract:

It could be overwhelming sometimes to learn and to choose among so many Big data tools available in the market. In this session we will help you understand what “Big data” really means and explore the Microsoft Big data landscape while learning about all of the different options, i.e. Data Lake Analytics, Azure Databricks, Azure SQL Data warehouse, Azure Analysis Services; And understand how Power Bi can help you tap into the power of your big data into one cohesive and easy to use tool, while comparing the pros and cons of the different Microsoft technologies.

SessionID: 93102

CozyRoc: Dynamic Data Flows in SSIS Without Programming

Back to calendar

Event Date: 08-06-2019 - Session time: 12:30:00 - Track: Business Intelligence

Speaker: Diane Schuster

Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming

Abstract:

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

SessionID: 94032

DELL Gold Sponsored Session

Back to calendar

Event Date: 08-06-2019 - Session time: 12:30:00 - Track: Cloud Application Development Deployment

Speaker: SQL Saturday South Florida

Title: DELL Gold Sponsored Session

Abstract:

DELL Gold Sponsored Session

SessionID: 94575

Best Practices for SQL Server on AWS

Back to calendar

Event Date: 08-06-2019 - Session time: 12:30:00 - Track: Cloud Application Development Deployment

Speaker: Tom Staab

Title: Best Practices for SQL Server on AWS

Abstract:

Learn how Amazon Relational Database Services (RDS) helps SQL Server DBAs focus their time where it matters most and why thousands of customers have chosen Amazon Web Services for their Microsoft Windows and SQL Server workloads. We will cover the benefits of running SQL Server on Amazon EC2 and Amazon RDS along with best practices for storage, monitoring, availability, security, backup, and recovery.

SessionID: 94673

Database Performance Monitoring

Back to calendar

Event Date: 08-06-2019 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Database Performance Monitoring

Abstract:

Are you struggling with performance issues and your current tools are not providing answers? This presentation will show several solutions from Quest Software that will give you real-time performance alerts and bring together all of your critical database metrics into a single dashboard, with color-coded alerts for problem severity which are clickable for rapid diagnostics. You’ll also learn how wait time and workload analysis can enable you to quickly focus on the worst queries causing the most issues currently and historically in your databases.

SessionID: 89718

Constraints are the Key (to Data Integrity)

Back to calendar

Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Application Database Development

Speaker: Andy Warren

Title: Constraints are the Key (to Data Integrity)

Abstract:

This session is designed to introduce you or to re-engage your interest in all the options we have for setting constraints in a database. From datatypes to nulls to checks, defaults, foreign keys, and triggers we have a LOT of options, so it's important to know the options and also have a bit of a professional philosophy on when to use each of them - we will do a brief look at each of them. We'll talk about why getting them right on day 1 is so important, how to add them to existing tables (the syntax is the least interesting part!), and some patterns and anti-patterns you can look for when you get to the office on Monday. Constraints aren't glamorous, but they matter, and they require an advocate - you! A good session for DBA's, developers, and yes, even managers.

SessionID: 89731

Power BI Governance 101

Back to calendar

Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Business Intelligence

Speaker: Dustin Ryan

Title: Power BI Governance 101

Abstract:

Deploying an enterprise business intelligence solution is no small task but one of the most important factors to consider in order to have a successful roll-out of a self-service analytics tool like Power BI is governance. In this session, we'll discuss why governance is so important for a successful Power BI deployment, what are the components of Power BI that require governance, and how to govern your Power BI environment. By the end of this session, the audience should have a clearer understanding of governance in the context of Power BI.

SessionID: 89974

What Is Clogging Your Database Performance?

Back to calendar

Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Eddy Djaja

Title: What Is Clogging Your Database Performance?

Abstract:

A concise and systematic approaches rather than guessing to analyze SQL Server performance will be presented. Through measuring the response time and wait time at the query level, the performance bottleneck is pinpointed and tuned. The presentation will look at the basic of gathering the stats from SQL Server DMVs.

SessionID: 90011

An Introduction to Power BI for Data Science With Python

Back to calendar

Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Data Science

Speaker: Adriano da Silva

Title: An Introduction to Power BI for Data Science With Python

Abstract:

This session provides an introduction to the use of Power BI for Data Science. It covers the use of Power BI as part of the Data Science process; including EDA (Exploratory Data Analysis), Data Visualization along with its integration with Python, Scikit-Learn and SQL Server Machine Learning Services.

This is an introductory session designed for those with basic Power BI skills; as well as, minimal or no Python and/or Data Science experience. This is an applied session focusing on the utilization of the tools, technologies and machine learning libraries; such as Pandas, Numpy, Scipy, etc. The demos are centered around Power BI and its integration with Python, ML engine and Data Science processes.

SessionID: 90831

Branding and Neuro-Marketing

Back to calendar

Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Professional Development

Speaker: Patricia Monica Ojeda

Title: Branding and Neuro-Marketing

Abstract:

Researchers are gaining amazing insights into positioning a brand by using the science of neuromarketing. Let's talk about What’s neuromarketing? and how this science will help us to light up people's brains and positioning our brands.

SessionID: 90914

Real-time Sentiment Prediction in SQL Server

Back to calendar

Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Application Database Development

Speaker: Hiram Fleitas

Title: Real-time Sentiment Prediction in SQL Server

Abstract:

- ABSTRACT:

In this session, I'll show you from start to finish how to use Machine Learning to predict a sentiment in real-time with Python and SQL Server (On-Premise).

  1. Add ML Features
  2. Grant Access
  3. Config
  4. Install Retrained Open-source ML Models
  5. Code in Python and T-SQL
  6. Real-time scoring
  7. Review Sentiment Results
  8. Resources

I look forward to seeing you guys there!

SessionID: 91618

DevOPS for DBAs - Where is your magic wand?

Back to calendar

Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Satya Jayanty

Title: DevOPS for DBAs - Where is your magic wand?

Abstract:

DBA is key when a database platform change occurs and necessary to support the application, release processes and there is a miracle waiting to happen!

Based on my experience DBA is left out in the key element of DEVOPS, this is unfortunate. DBAs have a lot to offer . In this session let us overview where exactly DBAs can make miracles with their magic wand, let's talk about process and procedures. To evaluate each change request to ensure that it is well thought out, is compliant with organizational best practices. Also review what Azure DevOps is offering to manage your cloud deployments.

Take away best practices associated in DEVOPS and DBA world.

SessionID: 92267

PowerShell Core - Fundamental on How-To Persist Data in a SQL Server Container

Back to calendar

Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Application Database Development

Speaker: Maximo Trinidad

Title: PowerShell Core - Fundamental on How-To Persist Data in a SQL Server Container

Abstract:

This session will give you the necesary knowledge on how to work with container(s) disk data. As a Database Developer and Admininstrator, it's important to protect that information stored on our Database Servers. I'll be showing how easy it is to start build a solution and how to make data persist in a container using Docker CLI only as a starting point.

SessionID: 92464

Hadoop, Hive, and Big Data For MSSQL Professionals

Back to calendar

Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Application Database Development

Speaker: Ernest Libertucci

Title: Hadoop, Hive, and Big Data For MSSQL Professionals

Abstract:

At times, we find ourselves learning new platforms and integrating them with our tried and true solutions. This session will be a primer for those that find themselves in a similar situation of going from MS SQL Server to the Big Data landscape. We will discuss an overview of Hadoop, including HDFS, Hive, and Spark along with a somewhat deeper description of Hive and how knowledge of TSQL and MS SQL Server can translate to HiveQL.

SessionID: 92773

Build a Modern Data Warehouse from disparate sources and visualize the data with PowerBI

Back to calendar

Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Analytics and Visualization

Speaker: oscar garcia

Title: Build a Modern Data Warehouse from disparate sources and visualize the data with PowerBI

Abstract:

A data warehouse (DW) is a core component of business intelligence and a central data repository for different sources. This poses many challenges as the schema definition for those sources may be completely different from one another. In this presentation, we discuss how to create a data warehouse model that can support data from multiple systems. Oscar Garcia shows how to build a dimensional model which can enable us to import the data with different shapes into a data warehouse. We then create processes to transform and load the data using Apache Spark. We finally use Power BI to visualize the data from our data warehouse and Spark.

Learning Objectives:

Challenges when using disparate data sources (different models)

Define a common model to support the different model shapes

Apache Spark Overview

Strategy for loading the different data-sets into the common model

Data analysis and visualization with Power BI

SessionID: 93185

Into the Deep End with Azure Data Lake Store Generation 2

Back to calendar

Event Date: 08-06-2019 - Session time: 13:40:00 - Track: Cloud Application Development Deployment

Speaker: Audrey Hammonds

Title: Into the Deep End with Azure Data Lake Store Generation 2

Abstract:

Azure Data Lake Store... The Next Generation. Gen2, that is. Come learn the what's and why's of data lakes, what Microsoft is bringing to the table with Azure Data Lake Store Gen2, and how to make it part of your modern data platform strategy. We'll discuss the basics of what a data lake is, to how to configure, secure, and manage your lake in Azure, how to leverage Polybase with your SQL Server platform to create external tables using ADLS, and why this data storage option is critical for any organization interested in advanced analytics.

SessionID: 94369

For Love or Money, Your Tech Career

Back to calendar

Event Date: 08-06-2019 - Session time: 13:40: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: 89393

Climbing the SQL Server Index B-Tree

Back to calendar

Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: Climbing the SQL Server Index B-Tree

Abstract:

You’ll find a lot of Word of Mouth (WOM) advice out there about SQL Server performance, especially

when it comes to indexes. Some of the things you have probably heard are:  keep clustered index width small  unique indexes perform better  keep non-clustered index width small  compressed indexes have fewer logical reads  add one index for each column

But how do you know if this advice is good or bad? Did you know that there is a way to look under the hood at the actual index pages to see how the data is stored, and how it’s stored differently when data is compressed? Using this information, you can prove or disprove the WOM advice. Attend this demo-heavy session to learn how the SQL Server optimizer uses indexes. It’s all about performance, and the right indexes will give your application a big performance advantage.

SessionID: 89475

Azure SQL DW. Redefining MPP, how it stacks against Snowflake and RedShift

Back to calendar

Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Cloud Application Development Deployment

Speaker: Oscar Zamora

Title: Azure SQL DW. Redefining MPP, how it stacks against Snowflake and RedShift

Abstract:

Data Warehousing has been traditionally deployed via on-prem MPP solutions, and due to cloud modernization, and datacenter reduction footprint initiatives, organizations are looking out to establish a relationship with a cloud solution that can help them get off the traditional storage and compute licensing scheme, to easily scale their workloads without spending millions in newly acquired hardware, and to reduce their database administration operational tasks.

Snowflake, RedShift and Teradata provide a path to migrate workloads into the cloud and allows a very reduced utilization expense for both compute and storage. That is at least, what the marketing says as it has a tacit disclaimer around it. Azure SQL Data Warehouse offers scalability, pay-as-you-go compute solutions, with data contained within the database boundaries. The presentation shows a side by side comparison, with pros and cons of each platform and debunks some of the myths that have surfaced.

SessionID: 90421

Containerize your learning - a docker introduction

Back to calendar

Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Cloud Application Development Deployment

Speaker: Daniel Shrader

Title: Containerize your learning - a docker introduction

Abstract:

You've heard about docker, but haven't found that use case for it yet or simply just don't have the time to learn it. This session will start off showing you what docker is at a high level, and its many simple use cases. You'll leave with enough knowledge to either use someone else's docker image or build your own. All if this without needing to install docker on your machine. We'll go into how to spin up an environment using a cloud resource in minutes. After that, we'll install a graphical interface for docker in a docker image to help speed up your learning. From there, we will even spin up an SQL Server in a container that can start and stop in little to no time.

SessionID: 90582

Intro Into Index Analysis

Back to calendar

Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Enterprise Database Administration Deployment

Speaker: Dmitri Korotkevitch

Title: Intro Into Index Analysis

Abstract:

Indexing in SQL Server is both - art and science. It is also never-ending process. Database schema, queries and workload change overtime, making old indexing strategy obsolete and leaving you with inefficient or unused indexes.

In this session, Dmitri demonstrates several techniques that help you to perform index analysis in the system. You would learn how to detect unused and inefficient indexes, identify incorrect clustered indexes and choose the right candidates for consolidation and further index refactoring.

SessionID: 90685

Look, over there, your permissions are showing!

Back to calendar

Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Enterprise Database Administration Deployment

Speaker: Travis Page

Title: Look, over there, your permissions are showing!

Abstract:

You just walked into that fancy new gig, and you're getting your first cup of coffee. Your boss walks up and asks, "Who has access to that prod server?", do you know how to get the answers in the next hour? More importantly, do you know what these permissions mean, what an attacker could do with these permissions? In this session we'll start from scratch assuming that you have no experience with an audit with this question in mind. We'll work back from here to develop a strategy of how to harden your server.

SessionID: 90886

Artificial Intelligence (AI) for Business Intelligence

Back to calendar

Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Business Intelligence

Speaker: Hector Villafuerte

Title: Artificial Intelligence (AI) for Business Intelligence

Abstract:

Cognitive Services provides intelligent algorithms to see, hear, speak, understand and interpret user needs. Azure Machine Learning performs highly specialized tasks such as feature selection, algorithm selection or hyper-parameter optimization. These two AI tools can now be integrated with Power BI. Hector will show and demo some original use cases with Cognitive Services, Azure Machine Learning and other new AI features recently available in PowerBI.

SessionID: 91649

Why You Should Consider Implementing Indexed Views

Back to calendar

Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Application Database Development

Speaker: Alexander Fleming

Title: Why You Should Consider Implementing Indexed Views

Abstract:

This session will include an explanation of what indexed views are, the types of problems that they solve, and their limitations. Additionally, I will provide a methodology for determining whether or not you should consider using indexed views to solve problems in your environment - including how to test and compare them to some alternatives. I will then go through some demonstrations in order to clarify my points further and provide more opportunities for the audience to ask questions.

SessionID: 91766

Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry

Back to calendar

Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Application Database Development

Speaker: William Wolf

Title: Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry

Abstract:

Like parents having to break up a fight between battling siblings, SQL Server must do the same for conflicting transactions. We call these Deadlocks and they can present a problem to many DBAs. Deadlocks can be minor fights or major issues making SQL Server continually choose a side like constantly quarreling siblings.

To understand how Deadlocking occurs, we must understand what caused the fight . Learning about basic locking and blocking of SQL Server is a great place to start.

By the end of this session you will walk away with the knowledge of how the locking/blocking mechanism works, the basics of deadlocking, and what Isolation Levels are . You will know how these can help or hurt your situation. Finally you will have the power to capture, report, and stop the family fighting.

SessionID: 91842

Changing Data Is Easy, Managing Data Change is Hard!

Back to calendar

Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Enterprise Database Administration Deployment

Speaker: James McAuliffe

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.

SessionID: 92970

Temporal Tables: Creation, Use, and Optimizing

Back to calendar

Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Application Database Development

Speaker: Dale Sullenberger

Title: Temporal Tables: Creation, Use, and Optimizing

Abstract:

With SQL 2016, Microsoft introduced Temporal tables. In this session we will learn what a Temporal table is, and discuss uses in current environments. We will learn how to create the tables, query the data from the tables for different scenarios, and optimize them for query performance allowing simplicity for the consumers of the data.

SessionID: 93055

Basic Windowing Functions

Back to calendar

Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Application Database Development

Speaker: Mike Burek

Title: Basic Windowing Functions

Abstract:

Windowing functions are when you add a "window" to which rows a function will look at using the OVER clause. We'll start by learning how to add the OVER clause to the commonplace COUNT, SUM, AVG, MIN, and MAX aggregate functions, since the OVER clause is optional. From there, we'll learn some ranking functions, which do require the OVER clause. You'll see examples that use the ROW_NUMBER function to identify and delete duplicate rows. Finally, we'll close with the RANK and DENSE_RANK functions that help you report on the grouping of your data.

SessionID: 93208

“Past, Present, and Future of the Data Profession" Part 1- "Relational Databases Vs. NoSQL"

Back to calendar

Event Date: 08-06-2019 - Session time: 14:55:00 - Track: Professional Development

Speaker: Frank Quintana

Title: “Past, Present, and Future of the Data Profession" Part 1- "Relational Databases Vs. NoSQL"

Abstract:

To understand the present and get a glance to the future you have to look at the past.

What are the differences between relational and NoSQL Databases? What is Data Science, Data Engineering and Data Analysis? What skills are necessary to keep been competent? How Universities and Business could reduce the deficit of talents in today market place? Part 1- "Relational Databases Vs. NoSQL" My objective of this session is to explain the evolution of the Data Profession from flat files, hierarchical, Network and Relational  Databases, DWH, SQL, NF, Business Intelligence, etc. to Hadoop, Big Data NoSQL, ML, AI I also would like to introduce my model of the Intelligence Life Cycle and use it to clarify the advantages and disadvantages of Schema on-read and schema on-write which are the main difference between RDBMS and Big Data ("NoSQL"). What are the advantages and disadvantages of Big Data Compare to RDBMS? Are Data warehouses obsolete? Are Big Data models real schemaless?

SessionID: 92971

Temporal Tables - Managing Large Data Sets and Their Effects on Performance

Back to calendar

Event Date: 08-06-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Dale Sullenberger

Title: Temporal Tables - Managing Large Data Sets and Their Effects on Performance

Abstract:

So, you installed SQL 2016 (or newer) and implemented Temporal Tables for some of your data. Everything is running well, but now what? In this session we will look at the effects of adding various indexes to both the main and the history table and discuss what that might mean to the front end performance. We will go into data management scenarios, for when you do not want to keep all the data in that table forever.

SessionID: 93016

Hack / Protect SQL Server - Come learn both.

Back to calendar

Event Date: 08-06-2019 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Hiram Fleitas

Title: Hack / Protect SQL Server - Come learn both.

Abstract:

If you're using Dynamic Data Masking, Row-Level-Security or just SQL Server and you don't know how to hack it, then come to this session. I have some demos may leave you in aah. I'll show you how to also protect yourself against these hacks, plus how to add your database to source control with Azure DevOps, TFS or GitHub to better manage your database changes/deployments.

  1. TDS
  2. DDM
  3. RLS
  4. Database Source Control

We'll have plenty of time for QA. I hope to see you there!

SessionID: 93209

“Past, Present, and Future of the Data Profession“ Part 2- "Data Profession in the 21st Century"

Back to calendar

Event Date: 08-06-2019 - Session time: 16:00:00 - Track: Professional Development

Speaker: Frank Quintana

Title: “Past, Present, and Future of the Data Profession“ Part 2- "Data Profession in the 21st Century"

Abstract:

I pretend to show how our profession has been changed in the last 50 years the impact of these new techniques, models, the raising of new job descriptions and the skills necessary to function in the data profession realm in the 21st Century.

Part 2- "Data Profession in the 21st Century" In Part 2 I will concentrate on the skills and composition of Data Drive enterprises and teams and the challenges they are facing My objective of this session is to explain how Hadoop, Big Data NoSQL, ML, AI, and the IoT have influenced and transformed the Data profession. What is a Data Scientist? What is a Data Engineer? What do they do? What is the composition of ML and AI Team? What skills are necessary to keep themselves competitive today and in the near future? How Universities and Business could reduce the deficit of talents in today market place? And what is the future of the data profession? These are some of the main topics at this presentation

SessionID: 93930

5 Availability Groups Issues That May Ruin Your Day

Back to calendar

Event Date: 08-06-2019 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Dmitri Korotkevitch

Title: 5 Availability Groups Issues That May Ruin Your Day

Abstract:

AlwaysOn Availability Groups have become the most common High Availability technology used with SQL Server. It provides protection at the database group level, and it stores a separate copy of each database on each node, eliminating storage from being a single point of failure.

While Availability Groups help to achieve required High Availability, they may also introduce issues in the system. In this session, Dmitri will discuss several less-known problems associated with them. You will learn how Availability Groups may impact transaction log truncation and contribute to the blocking in the system, how readable secondaries may increase CPU and I/O load on primaries among a few other things. Dmitri will also discuss how to properly setup monitoring for Availability Group infrastructure in your environment.

SessionID: 94036

PowerBI Challenge

Back to calendar

Event Date: 08-06-2019 - Session time: 16:00:00 - Track: Analytics and Visualization

Speaker: SQL Saturday South Florida

Title: PowerBI Challenge

Abstract:

PowerBI Challenge