sqlsathistory

Nr: 801

Back to Main list

SQLSaturday #801 - Orlando 2018

Start Time (24h)	Speaker	Track	Title
09:45:00	Jeff Taylor	Other	How To Setup Continuous Integration Continuous Delivery Step By Step For Your Website Database
09:45:00	Jennifer Brocato	Strategy and Architecture	HA/DR Solutions Using Distributed Availability Groups
09:45:00	Thomas LeBlanc	Analytics and Visualization	Python and R Integration with SQL Server 2017
09:45:00	Janis Griffin	Enterprise Database Administration Deployment	Everything You Need to Know About SQL Server Indexes
09:45:00	Ned Otter	Strategy and Architecture	Will my workload run faster with In-Memory OLTP?
09:45:00	Shawn Meyers	Enterprise Database Administration Deployment	Encryption, Encryption, Encryption! Protect your data at the right level
09:45:00	Jonathon Moorman	Cloud Application Development Deployment	Azure Data Store Options
11:00:00	Dmitri Korotkevitch	Enterprise Database Administration Deployment	Intro Into Index Analysis
11:00:00	Adriano da Silva	Analytics and Visualization	Applied Machine Learning with Python
11:00:00	Rob Volk	Application Database Development	Tame Your Unruly Data With Constraints
11:00:00	Hiram Fleitas	Application Database Development	Hack / Protect / Predict SQL Server - Come learn them.
11:00:00	Ronald Dameron	Cloud Application Development Deployment	Azure Resource Management with PowerShell
11:00:00	Trey Johnson	BI Platform Architecture, Development Administration	Deciding to keep your BI Data Platform On-Premises
11:00:00	Sarju Patel	BI Platform Architecture, Development Administration	ETL automation using BIML
12:30:00	Janis Griffin	Enterprise Database Administration Deployment	What’s New in the 2017 Query Store
12:30:00	Chris Lumnah	Strategy and Architecture	Rubrik-Simplifying SQL Data Protection
12:30:00	Dominick DeQuarto	Strategy and Architecture	Dell: #GetModern with Dell EMC
12:30:00	Herve Roggero	Cloud Application Development Deployment	Introduction to Azure Functions using Azure SQL Databases
12:30:00	Herve Roggero	BI Information Delivery	Exporting and Synchronizing Data From SharePoint, Twitter and SalesForce into Azure SQL Database
12:30:00	Greg Smith	Other	Information Governance: Understanding the Risks and Developing Solutions around Unstructured data
12:30:00	franklin yamamoto	Enterprise Database Administration Deployment	Performance tuning with SQLGrease
12:30:00	Kendra Little	Strategy and Architecture	The Changing Role of CIOs and the Value of DevOps
13:45:00	Luigi Delfin	Analytics and Visualization	Azure Analytics In the Cloud
13:45:00	Aaron Cutshall	Application Database Development	Tally Ho! -- Explore the Varied Uses of Tally Tables
13:45:00	Jose Chinchilla	BI Platform Architecture, Development Administration	Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.
13:45:00	John Wang	Strategy and Architecture	Introduction to IoT using Azure
13:45:00	Eric Berkowitz	Enterprise Database Administration Deployment	I know what you did last transaction: Auditing using CDC, Temporal Tables and Triggers
13:45:00	Andrew Bozek	BI Information Delivery	Solution development for a query tool for a large Dataset
13:45:00	Bradley Ball	Analytics and Visualization	Twitter Data Sentiment Analysis: Staring Logic Apps, Azure ML, Twitter Data, Power BI, and Python
15:00:00	Dale Sullenberger	Application Database Development	Temporal Tables: Creation, Use, and Optimizing
15:00:00	Troy Gallant	Enterprise Database Administration Deployment	Supercharge Your Maintenance Plans..the Ola Way!!
15:00:00	Michael Antonovich	BI Information Delivery	Creating Reports and Dashboards with Power BI
15:00:00	Robert Hatton	Application Database Development	Thinking in SQL
15:00:00	Valentin Iamandi	Enterprise Database Administration Deployment	Performance Tuning Magic
15:00:00	Kendal Van Dyke	Application Database Development	SQL Server Development on Your Platform Of Choice with Containers
15:00:00	Ernest Libertucci	Application Database Development	SQL Execution Plans Demystified

SessionID: 83261

How To Setup Continuous Integration Continuous Delivery Step By Step For Your Website Database

Back to calendar

Event Date: 06-10-2018 - Session time: 09:45:00 - Track: Other

Speaker: Jeff Taylor

Title: How To Setup Continuous Integration Continuous Delivery Step By Step For Your Website Database

Abstract:

This session will cover how to setup your database source code in a source code repository, configure your website application, configure continuous integration and continuous deployments of your database alongside your application using Visual Studio Online, Red Gate DLM SQL CI, and Octopus Deploy.

SessionID: 83380

HA/DR Solutions Using Distributed Availability Groups

Back to calendar

Event Date: 06-10-2018 - Session time: 09:45:00 - Track: Strategy and Architecture

Speaker: Jennifer Brocato

Title: HA/DR Solutions Using Distributed Availability Groups

Abstract:

When designing your HA/DR solution, you need to consider all the possible options SQL Server has to offer to implement what is right for you. You will see how to use Failover Cluster Instances, Standalone Instances, Clusters, Availability Groups and Distributed Availability Groups.

We will walk through how to set up and configure an HA/DR solution from beginning to end, review possible alerts, and how to monitor. We will take a look at the new SQL2017 Read-scale Availability Groups and why to use them. We will architect one of many possible VM solutions to host your HA/DR implementation.

Finally, we will see Automatic Failover and see how to perform a Manual Failover.

SessionID: 84038

Python and R Integration with SQL Server 2017

Back to calendar

Event Date: 06-10-2018 - Session time: 09:45:00 - Track: Analytics and Visualization

Speaker: Thomas LeBlanc

Title: Python and R Integration with SQL Server 2017

Abstract:

If you are looking to expand your DBA or developer skills, statistics with Python or R integrated with SQL Server 2017 might be a path worth examining. This session will go through the installation of these options with SQL Server 2017. Then, we will configure the scripting Stored Procedures. Finally, the session will conclude with statistical graphs and analysis with both R and Python.

The role as a DBA is expanding, and even though you might not be a Data Scientist, you can still use the new features of SQL Server 2017 to do an analysis of performance monitoring data to enhance the predictability of proactive analysis on your current systems.

SessionID: 84385

Everything You Need to Know About SQL Server Indexes

Back to calendar

Event Date: 06-10-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Everything You Need to Know About SQL Server Indexes

Abstract:

You probably already know that indexes make your queries go faster. But do you know all the different types of indexes in SQL Server and when to use them? Also with each new release of SQL Server, there are new features that can impact how indexes function and are maintained. Finally, knowing how the different types of indexes work can help you make better indexing choices when tuning your queries.

This presentation will review current SQL Server index structures and options, discuss how they work, when they should be used and how to maintain them. Examples of all the index types such as hash, in-memory, columnstore, filtered, etc… will be shown. This presentation is a must see for DBAs, Developers, Application Architects and anyone else who is interesting in maintaining high performance SQL Server applications.

SessionID: 84493

Will my workload run faster with In-Memory OLTP?

Back to calendar

Event Date: 06-10-2018 - Session time: 09:45:00 - Track: Strategy and Architecture

Speaker: Ned Otter

Title: Will my workload run faster with In-Memory OLTP?

Abstract:

There are compelling reasons to consider deploying In-Memory OLTP, vastly improved in SQL 2016 and SQL 2017, and now running on all editions.

What are the use cases?

What are the tradeoffs?

We will lift the veil of confusion that surrounds this blazingly fast feature. By the end of the session, you will understand how In-Memory OLTP works and whether your workload is likely to see an increase in performance.

SessionID: 85475

Encryption, Encryption, Encryption! Protect your data at the right level

Back to calendar

Event Date: 06-10-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Shawn Meyers

Title: Encryption, Encryption, Encryption! Protect your data at the right level

Abstract:

More and more regulatory requirements are coming out around having your data encrypted. Many DBAs are struggling to know where to encrypt and the impact to performance encryption causes at each level. We will walk through the basics of all encryption options for SQL Server workloads including TDE, Always Encrypted, database and column level encryption, encrypted connections, storage encryption, certificates, key management and much, much, much more!!!

SessionID: 86239

Azure Data Store Options

Back to calendar

Event Date: 06-10-2018 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: Jonathon Moorman

Title: Azure Data Store Options

Abstract:

In this session we will investigate the various data storage options that are presented for developers in the Microsoft Azure Cloud. We will look at the various storage options for both strongly and loosely bound schema. Topics will include table storage, Azure Search, CosmosDb, Azure Sql Database, and Azure Data Lake Analytics. We will also cover data movement options and security before doing a deeper dive into Azure Sql Database.

SessionID: 83243

Intro Into Index Analysis

Back to calendar

Event Date: 06-10-2018 - Session time: 11:00: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: 83278

Applied Machine Learning with Python

Back to calendar

Event Date: 06-10-2018 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Adriano da Silva

Title: Applied Machine Learning with Python

Abstract:

The Applied Machine Learning with Python session covers some basic concepts, tools and a workflow used to explore, visualize, develop a model to attain answers from data.

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 use SQL Server 2017 Machine Learning Services (In-Database) integration with T-SQL, Python, Numpy, Scipy, Pandas, MatplotLib, Scikit-Learn (Machine Learning Library), MicrosoftML, Revoscalepy..

Most importantly, those examples are designed in a manner that are easy for you to understand and to spur your future exploration, by making it possible for you to replicate and use it to expand your knowledge.

SessionID: 83490

Tame Your Unruly Data With Constraints

Back to calendar

Event Date: 06-10-2018 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Rob Volk

Title: Tame Your Unruly Data With Constraints

Abstract:

Bad data comes in many forms: duplicate rows, wrong data type, invalid values, and orphaned or missing foreign keys. Time is wasted cleansing, reviewing and correcting data, not to mention the potential hazards bad data can cause. This introductory presentation will explain the data types and constraints available in SQL Server, and how they can replace or augment business rules that would otherwise be written in application or procedure code. Performance benefits provided by constraints will be demonstrated. We will examine the various system views and procedures that describe constraints and how to use them to document your databases. You will be able to apply this knowledge to your database environments and see significant improvements in data quality, performance, and reliability.

SessionID: 83672

Hack / Protect / Predict SQL Server - Come learn them.

Back to calendar

Event Date: 06-10-2018 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Hiram Fleitas

Title: Hack / Protect / Predict SQL Server - Come learn them.

Abstract:

In this session, I'll show you how to hack SQL Server using a simple C# console application and other tools. Most importantly, I'll show you how to protect vectors that perhaps you're trying to use to safeguard sensitive data for GDPR compliance.

1. Tabular Data Stream (TDS) Protocol
2. Dynamic Data Masking
3. Row Level Security (Yep...)
4. 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.

5. SQL ML / AI - A deep dive to predict the sentiment

Looking forward to meeting you all.

SessionID: 83811

Azure Resource Management with PowerShell

Back to calendar

Event Date: 06-10-2018 - Session time: 11:00:00 - Track: Cloud Application Development Deployment

Speaker: Ronald Dameron

Title: Azure Resource Management with PowerShell

Abstract:

You’re company is transitioning to the Cloud. Initially, your Azure deployment was small and could be managed primarily via the Azure portal but now it spans the globe with implementations in several countries. You have too many resources to manage with the Azure portal alone. You can automate these tasks with PowerShell without being a PowerShell expert. I’m Ronald Dameron. I’m responsible for managing the resources of twelve Azure subscriptions containing hundreds of resources. I can show you how. I’ve done it.

SessionID: 84588

Deciding to keep your BI Data Platform On-Premises

Back to calendar

Event Date: 06-10-2018 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Trey Johnson

Title: Deciding to keep your BI Data Platform On-Premises

Abstract:

The world is going to the cloud and there is plenty of good reason for it, but NOT every IT workload should go to the cloud and your BI is no different. Maybe you aren’t ready, maybe your organization feels fully invested in your current On-Prem infrastructure. Maybe there is some fear of the unknown.

The speaker will tackle these challenges and help you, the attendee, understand how and when to decide to stay On-Premises or move to a Cloud or a Hybrid solution. As an attendee, you should have the information to comfortably determine what is right for your organization today, and have a plan for the future.

Attendees will understand what On-Premises benefits are available exclusively to them Attendees will understand where Cloud and Hybrid solutions complement their existing deployments Attendees will be in a better position to explore moving beyond their On-Premises deployment

SessionID: 84681

ETL automation using BIML

Back to calendar

Event Date: 06-10-2018 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sarju Patel

Title: ETL automation using BIML

Abstract:

in this session, We will go over different design patterns to perform ETL using ssis and biml.

SessionID: 84383

What’s New in the 2017 Query Store

Back to calendar

Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: What’s New in the 2017 Query Store

Abstract:

The Query Store houses valuable information on performance of your queries as well as gives you great insights into your query workload and plan changes. This presentation will take a look at what’s new in the 2017 Query Store, the new adaptive query processing features and how to incorporate Query Store queries into the new SQL Operation Studio (SQLOps) for monitoring slow running queries and analyzing waits. You will learn how to use the Query Store to quickly find plan changes, analyze performance issues and find the waits which caused them. Both DBAs and developers can increase their performance tuning skills by attending this session.

SessionID: 85684

Rubrik-Simplifying SQL Data Protection

Back to calendar

Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Strategy and Architecture

Speaker: Chris Lumnah

Title: Rubrik-Simplifying SQL Data Protection

Abstract:

When you think about backups in your environment, how many servers scripts do you have to manage? Or have you ever needed to get a table back from a large database and didn't want to argue with the storage admins about space for the restore? With Rubrik, we empower you to backup and restore your databases quickly and with ease. Come see how you can quickly protect hundreds of databases with just a few clicks or bring back a database in minutes to satisfy your most demanding executives. With Rubrik, it's not about backing up, it's about going forward!

SessionID: 85695

Dell: #GetModern with Dell EMC

Back to calendar

Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Strategy and Architecture

Speaker: Dominick DeQuarto

Title: Dell: #GetModern with Dell EMC

Abstract:

Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged… we have you covered.

SessionID: 85813

Introduction to Azure Functions using Azure SQL Databases

Back to calendar

Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Cloud Application Development Deployment

Speaker: Herve Roggero

Title: Introduction to Azure Functions using Azure SQL Databases

Abstract:

In this session you will learn about Azure Functions and how to build a simple HTTP proxy that returns data from an Azure SQL Database, built entirely in the cloud. We will review configuration settings, how to securely store your connection strings, how to implement logging, how to implement retry logic and how to troubleshoot your Azure Functions. The demos will be done entirely in the cloud, without using Visual Studio.

SessionID: 85814

Exporting and Synchronizing Data From SharePoint, Twitter and SalesForce into Azure SQL Database

Back to calendar

Event Date: 06-10-2018 - Session time: 12:30:00 - Track: BI Information Delivery

Speaker: Herve Roggero

Title: Exporting and Synchronizing Data From SharePoint, Twitter and SalesForce into Azure SQL Database

Abstract:

In this session we will review how to leverage Enzo Data Pipelines to export and synchronize data from hosted data sources (SharePoint Online, Twitter and SalesForce) into a relational database in the cloud for software integration and reporting. As part of this presentation you will see how you can implement a Change Data Capture (CDC) architecture on top of SharePoint Online, Twitter and SalesForce, allowing you to trigger actions when source data changes in those systems.

SessionID: 85999

Information Governance: Understanding the Risks and Developing Solutions around Unstructured data

Back to calendar

Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Other

Speaker: Greg Smith

Title: Information Governance: Understanding the Risks and Developing Solutions around Unstructured data

Abstract:

Organizations are faces with information overload from employee generated unstructured data in the form of emails and electronic documents. With no idea of the content that exists within these documents or the locations with more and more options being provided for storage of documents, Organizations are having to come to terms with the liabilities, overhead and management of these resources. This session looks at the issues of dark data within an organization and methods to understand and combat it.

SessionID: 86018

Performance tuning with SQLGrease

Back to calendar

Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: franklin yamamoto

Title: Performance tuning with SQLGrease

Abstract:

Performance tuning a production system can be a difficult process when only relying on out of the box tools. This is even more difficult if you aren’t on the most recent release of SQL Server. In this presentation I will show you some common performance problems and how SQLGrease can help tune these. Along the way I will provide details on how SQLGrease collects its data in order to give some clarity on how we monitor as well as provide some useful queries you can use even if you aren’t a SQLGrease user.

SessionID: 86301

The Changing Role of CIOs and the Value of DevOps

Back to calendar

Event Date: 06-10-2018 - Session time: 12:30:00 - Track: Strategy and Architecture

Speaker: Kendra Little

Title: The Changing Role of CIOs and the Value of DevOps

Abstract:

DevOps practices are a powerful tools to build productive, engaged teams who constantly learn and regularly deliver value to their customers. High DevOps performers report greater workplace satisfaction than their peers. But implementing DevOps isn’t a matter of being great at writing code, or choosing the right technologies: to become a high DevOps performer, you need the powerful catalyst of executive support. In this talk, we will discuss the value of DevOps from the perspectives of CEOs, CIOs/CTOs, and Managers. We will explore how the role of CIOs and CTOs are undergoing a major transformation, and how DevOps aligns with that transformation. You will leave the session with a fresh take on how to discuss DevOps with company leaders, and an understanding of how to explain the value of DevOps to people in these roles.

SessionID: 83245

Azure Analytics In the Cloud

Back to calendar

Event Date: 06-10-2018 - Session time: 13:45:00 - Track: Analytics and Visualization

Speaker: Luigi Delfin

Title: Azure Analytics In the Cloud

Abstract:

WIll present a sample business intelligence/analytics application using cloud technologies such as Azure Sql Server Analysis Services, Power BI and Azure Machine Learning and how it all works together.

SessionID: 83314

Tally Ho! -- Explore the Varied Uses of Tally Tables

Back to calendar

Event Date: 06-10-2018 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Aaron Cutshall

Title: Tally Ho! -- Explore the Varied Uses of Tally Tables

Abstract:

Because SQL Server is designed to efficiently operate with set-based queries it does not perform as well with loops and cursors. However there are situations where you really need some type of a loop. Tally tables give you the best of both worlds by allowing you to effectively "loop" through records in a set-based manner. We'll explore what tally tables are, how they work, and more importantly review some of the many ways you can use them to turn your loops and cursors into efficient set-based operations.

SessionID: 83537

Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.

Back to calendar

Event Date: 06-10-2018 - Session time: 13:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jose Chinchilla

Title: Azure Data Factory + SSIS: Migrating your ETLs to the Cloud.

Abstract:

Thinking about migrating your data warehouse to the cloud? What about all those SSIS packages executing ETLs against your on-prem data sources? In this presentation we will discuss how to successfully "lift and shift" your ETL workloads to the Azure cloud. You will l learn how to configure and deploy an Integration Runtime, deploy and execute SSIS packages in an Azure Data Factory pipeline, and how to monitor and troubleshoot your ETL executions in the cloud. Attendees will walk-away with an understanding of the features, capabilities and limitations of Azure Data Factory and the Integration Runtime and a strategy to leverage your existing SSIS package development efforts to the cloud.

SessionID: 83560

Introduction to IoT using Azure

Back to calendar

Event Date: 06-10-2018 - Session time: 13:45:00 - Track: Strategy and Architecture

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: 83901

I know what you did last transaction: Auditing using CDC, Temporal Tables and Triggers

Back to calendar

Event Date: 06-10-2018 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Berkowitz

Title: I know what you did last transaction: Auditing using CDC, Temporal Tables and Triggers

Abstract:

Attendees of this session at SQL Saturday South Florida 2018 voted to recommend it for SQL Saturday Orlando! 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: 84650

Solution development for a query tool for a large Dataset

Back to calendar

Event Date: 06-10-2018 - Session time: 13:45:00 - Track: BI Information Delivery

Speaker: Andrew Bozek

Title: Solution development for a query tool for a large Dataset

Abstract:

Research and discussion regarding multiple attempts to devise a solution to provide a parameterized query tool that pulls against a 14MM record externally managed database. This session will delve into the trails and tribulations experienced while attempting to resolve real world problems in order to provide a business solution. Experience the thrills of each different solution attempt and the difficulties presented in a real business environment.

SessionID: 85546

Twitter Data Sentiment Analysis: Staring Logic Apps, Azure ML, Twitter Data, Power BI, and Python

Back to calendar

Event Date: 06-10-2018 - Session time: 13:45:00 - Track: Analytics and Visualization

Speaker: Bradley Ball

Title: Twitter Data Sentiment Analysis: Staring Logic Apps, Azure ML, Twitter Data, Power BI, and Python

Abstract:

A year ago we went to Spider-man: Homecoming. On the way home I thought “I wonder what the rest of the world thinks of this movie? I wonder what people on Twitter are saying? I wonder if this is that tied to box office performance?” Over the last six months we’ve been building data sets on movies and collecting sentiment analysis of Twitter data. This lead to a journey of data discovery. First to figure out how to capture and analyze social media data from Twitter. Next we needed box office information. After that we wanted to capture sentiment. Then we wanted stock market data. Then we wanted movie information, runtime, rating, Metacritic score, IMDB score, and then how do we get historical data if we want to increase our data set? Once you collect the data how do you store it? How do you display it? All this and more….. but probably just this….because that’s a lot.

SessionID: 83338

Temporal Tables: Creation, Use, and Optimizing

Back to calendar

Event Date: 06-10-2018 - Session time: 15:00: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: 83346

Supercharge Your Maintenance Plans..the Ola Way!!

Back to calendar

Event Date: 06-10-2018 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Troy Gallant

Title: Supercharge Your Maintenance Plans..the Ola Way!!

Abstract:

Today’s SQL Server DBA has a myriad of options when it comes to implementing their backup and maintenance strategies. From internal maintenance plans to all-encompassing third-party solutions, the options are practically endless. One very popular solution revolves around a set of free scripts provided by Swedish data scientist, Ola Hallengren. These well admired scripts are used by corporations large and small worldwide in order to facilitate backups, integrity checks, and index maintenance operations.

In this session, not only will we introduce these scripts to those unfamiliar with them, but just as importantly, we’ll take a detailed look into just how these scripts can be extended and customized even further. You’ll be amazed at the flexibility offered by the optional parameters. We’ll also take a gander into the remarkably detailed logging tables in order to inspect the raw data and possibly turn it into a valuable reporting data source.

SessionID: 83606

Creating Reports and Dashboards with Power BI

Back to calendar

Event Date: 06-10-2018 - Session time: 15:00:00 - Track: BI Information Delivery

Speaker: Michael Antonovich

Title: Creating Reports and Dashboards with Power BI

Abstract:

This session looks at both Power BI Desktop and Power BI.com to compare the advantages and capabilities of both platforms for creating and distributing data analysis within your organization. It will also touch a little on why you might choose Power BI over Power Pivot and why you might not. It will also look at how to create drill down detail screens to expose the details behind your visualizations. Finally, we will touch on how to publish your Power BI results for others in your organization to share. A basic understanding of database structures and referential integrity is an advantage to gain the most from this session, but as will be shown, not always necessary depending on the source of the data to be analyzed.

SessionID: 84119

Thinking in SQL

Back to calendar

Event Date: 06-10-2018 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Robert Hatton

Title: Thinking in SQL

Abstract:

SQL is conceptually different than most programming languages. Join us for a conversation about SQL, why it's different from traditional procedural languages, and how to effectively use this truly elegant programming language. Rather than focus on the kinds of information easily located on the Web, we'll concentrate on how to use SQL for the tasks that it's really good at. Beginners will get a great introduction to the style of thought that gets the most out of SQL. Experienced developers will find a good refresher and an opportunity to share their experiences with others.

SessionID: 85520

Performance Tuning Magic

Back to calendar

Event Date: 06-10-2018 - Session time: 15:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Valentin Iamandi

Title: Performance Tuning Magic

Abstract:

When your server becomes unresponsive, the performance goes down the drain and the CPUs are at 100%. You asks yourself: I wish I knew what and how to do it.

-- How to configure your Sql Server for maximum performance -- Big databases issues and solutions -- Indexes or Statistics updates, what and where: Rebuild or Reorg -- Sql code tricks to increase code performance -- What to do when in maximum performance pain

SessionID: 86333

SQL Server Development on Your Platform Of Choice with Containers

Back to calendar

Event Date: 06-10-2018 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Kendal Van Dyke

Title: SQL Server Development on Your Platform Of Choice with Containers

Abstract:

SQL 2017's built in support for Docker containers enables new development capabilities without requiring a Windows OS. In this session you'll learn about why you should care about containers (even if you are running Windows), what you can - and can't - do with containers, the basics of how to work with Docker to create and manage your own containers, and how Microsoft's new cross platform tools enable you to work with SQL Server on Windows, macOS, and Linux. After this session you'll have all the information you need to start using Docker on your platform of choice!

SessionID: 86351

SQL Execution Plans Demystified

Back to calendar

Event Date: 06-10-2018 - Session time: 15:00:00 - Track: Application Database Development

Speaker: Ernest Libertucci

Title: SQL Execution Plans Demystified

Abstract:

Discussion on how SQL Server performs the tasks asked of it by the user. Topics will include statistics, indexes, and the Query Optimizer, including operators detailed in the execution plan and what they mean.

We will also go over some demonstrations as well as commonly seen performance killers and how to quickly and easily identify them.

This site is open source. Improve this page.