sqlsathistory

Nr: 908

Back to Main list

SQLSaturday #908 - Denver 2019

Start Time (24h) Speaker Track Title
09:00:00 Anthony Nocentino Application Database Development Kubernetes Zero to Hero - Installation, Configuration, and Applic
09:00:00 Kendra Little Enterprise Database Administration Deployment How to Architect Successful Database Changes: Source Control and
09:00:00 Ginger Grant Analytics and Visualization Getting Started with Data Science and Databricks
09:00:00 Ganesh Lohani Analytics and Visualization Data Science 101: An Introduction to Data Science Using Python
09:00:00 Kellyn Pot'Vin-Gorman Enterprise Database Administration Deployment Empowering the SQL Server Professional with Linux Scripting- 60 min.
09:00:00 Steve Wake BI Information Delivery Power BI Premium: Is it for Your Company (and Worth It)?
09:00:00 Paul Paiva Professional Development Consulting/contracting - is it right for me?
09:00:00 Eric Peterson Strategy and Architecture SQL and MongoDB: When Two Worlds Collide
09:00:00 Gabriel Villa Analytics and Visualization Analytics on AWS
09:00:00 Jason Brimhall Advanced Analysis Techniques Anatomy of Select
09:00:00 Marc Beacom BI Platform Architecture, Development Administration ETL Best Practices and Techniques
10:15:00 Carlos Robles Cloud Application Development Deployment Working with SQL Server containers to build database solutions
10:15:00 Glenn Berry Enterprise Database Administration Deployment Dr. DMV's Troubleshooting Toolkit
10:15:00 Ted Stathakis BI Platform Architecture, Development Administration Reporting Services: A Smart Migration Strategy
10:15:00 Yuliya Quintela Cloud Application Development Deployment Building Big Data Analytics solutions with Azure Databricks
10:15:00 Kendra Little Enterprise Database Administration Deployment An Introduction to Versioning and Branching Database Code in Git
10:15:00 Phillip Labry Application Database Development Assimilating Microsoft Access -- Upsizing to SQL Server
10:15:00 Richard Waymire Cloud Application Development Deployment Running SQL Server on AWS
10:15:00 Ginger Grant Advanced Analysis Techniques Revealing the Differences in Azure Machine Learning Products
12:45:00 Mark Moore Information Delivery Demystifying SQL in Azure
12:45:00 Kara Annanie Analytics and Visualization Machine Learning in Azure Databricks
12:45:00 Steve Jones Application Database Development The Future of Database Development with Containers
12:45:00 Meagan Longoria BI Platform Architecture, Development Administration Moving and Transforming Your Data with Azure Data Factory V2
12:45:00 Manguirish Sardessai Cloud Application Development Deployment SQL Server Migration to the AWS: Approach and Methodology
12:45:00 Scot Reagin BI Platform Architecture, Development Administration Azure Analysis Services – Multidimensional solutions in the cloud
12:45:00 TJay Belt Enterprise Database Administration Deployment Power BI, from a DBA's Perspective
12:45:00 Todd Kleinhans Enterprise Database Administration Deployment Storing Images in a Database - Tips and Techniques
14:00:00 Aaron Cutshall Application Database Development Tally Ho! -- Explore the Varied Uses of Tally Tables
14:00:00 Steve Wake BI Information Delivery Data Modeling and Prototyping in Power BI Desktop
14:00:00 Glenn Berry Enterprise Database Administration Deployment High Availability/Disaster Recovery 101
14:00:00 Susantha Bathige Cloud Application Development Deployment SQL Server on Kubernetes
14:00:00 Marc Beacom Analytics and Visualization Translating your Excel Skills to Power BI
14:00:00 Leslie Weed BI Platform Architecture, Development Administration Innovative Data Modeling: Make Data Warehousing Cool Again Part 1
14:00:00 Carlos Bossy Information Delivery Operationalize Data Science for Advanced Decision Support
14:00:00 Angela Tidwell Enterprise Database Administration Deployment Data Collection and Usage: Illegal or Unethical?
14:00:00 Rick Lowe Application Database Development Weird Stuff I Saw While … Supporting a Java Team
15:15:00 John Byrnes Analytics and Visualization Predicting the NFL with SQL Server 2017 ML Services
15:15:00 Christopher Wolff Enterprise Database Administration Deployment SQL Servers on Containers
15:15:00 Amie Mason Strategy and Architecture Preparing your Business for Data Science
15:15:00 Jeff Renz BI Platform Architecture, Development Administration Innovative Data Modeling: Make Data Warehousing Cool Again Part 2
15:15:00 Daniel Janik Enterprise Database Administration Deployment Migrating your SQL Server to the cloud: Tips and Best Practices
15:15:00 Anthony Nocentino Application Database Development Practical Container Scenarios in Azure
15:15:00 Jason Horner Cloud Application Development Deployment Azure Analytics Platform Quickstart
15:15:00 Kellyn Pot'Vin-Gorman Advanced Analysis Techniques DevOps or Decoys

SessionID: 97978

Kubernetes Zero to Hero - Installation, Configuration, and Applic

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Application Database Development

Speaker: Anthony Nocentino

Title: Kubernetes Zero to Hero - Installation, Configuration, and Applic

Abstract:

Modern application deployment needs to be fast and consistent to keep up with business objectives and Kubernetes is quickly becoming the standard for deploying container-based applications, fast. In this day-long session, we will start with an architectural overview of a Kubernetes cluster and how it manages application state. Then we will learn how to build a production-ready cluster. With our cluster up and running, we will learn how to interact with our cluster, common administrative tasks, then wrap up with how to deploy applications and SQL Server. At the end of the session, you will know how to set up a Kubernetes cluster, manage a cluster, deploy applications and databases, and how to keep everything up and running.

Session Objectives • Introduce Kubernetes Cluster Components • Introduce Kubernetes API Objects and Controllers • Installing Kubernetes • Interacting with your cluster • Storing persistent data in Kubernetes • Deploying Applications in Kubernetes

SessionID: 97979

How to Architect Successful Database Changes: Source Control and

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Kendra Little

Title: How to Architect Successful Database Changes: Source Control and

Abstract:

You want to frequently release quality database changes while maintaining high performance and availability standards, but how do you do it? While the term ‘DevOps’ has just turned 10 years old, database architects and DBAs have been developing patterns and practices to standardize and automate delivery of database code quickly and reliably for far longer.

In this session, you will learn how to choose between state and migrations-based approaches to database code management in source control on a per-project basis, and what this choice means for your release practices. You’ll learn what release automation means for ‘rollbacks’ with database code and get to join the debate on the pros and cons of different approaches to handling post-release disasters in production. We’ll discuss release patterns and how to measure success, including the blue/green deployment model when applied to databases, the expand/contract pattern, feature flags, and special cases for releases including repli

SessionID: 98238

Getting Started with Data Science and Databricks

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Analytics and Visualization

Speaker: Ginger Grant

Title: Getting Started with Data Science and Databricks

Abstract:

Today, more and more development is performed on very large datasets. Attendees will learn how to use Apache Spark, which is part of Databricks, to rapidly analyze lots of data. Learn how to use Databricks to reduces operational complexity to create solutions which can be scaled up or down depending on the amount of data needed to process without having to change the underlying code. Python, Jupyter Notebooks, and Apache Spark are the technologies used to create solutions within this session. No experience is required. Agenda

SessionID: 95360

Data Science 101: An Introduction to Data Science Using Python

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Analytics and Visualization

Speaker: Ganesh Lohani

Title: Data Science 101: An Introduction to Data Science Using Python

Abstract:

SessionID: 95490

Empowering the SQL Server Professional with Linux Scripting- 60 min.

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Kellyn Pot'Vin-Gorman

Title: Empowering the SQL Server Professional with Linux Scripting- 60 min.

Abstract:

A DBA's suite of scripts is worth its weight in gold. As Azure moves the SQL DBA to a more Linux focused environment, the opportunity to learn Linux scripting and to add these valuable skills to your pre-existing Powershell skills is a great goal. This session will teach you how to build out proper shell scripts, tips and tricks, along with how to learn faster.

This session is the second session in the Linux for SQL Server Professionals Learning Pathway. For more information please visit our Learning Pathways page.

SessionID: 95967

Power BI Premium: Is it for Your Company (and Worth It)?

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: BI Information Delivery

Speaker: Steve Wake

Title: Power BI Premium: Is it for Your Company (and Worth It)?

Abstract:

Power BI Premium is the top level of Power BI that your company can pay to get dedicated capacity for your Power BI reports and models. But at a starting price of $5000/month is it something your company needs and is it worth that price?

In this session, we will go over all of the current features offered with Power BI Premium and the features that we know are coming in the future, so that you can help make that decision for your company. With multiple demos in this session, you can see these features for yourself to help determine the worth. Come to this session if your company has been thinking about Power BI Premium, but you have been unable to determine if it is right for your company. At the end of this session, you will be armed with all of the knowledge you will need to make the right decision.

SessionID: 96350

Consulting/contracting - is it right for me?

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Professional Development

Speaker: Paul Paiva

Title: Consulting/contracting - is it right for me?

Abstract:

You have probably worked as a direct hire for a company. You get medical benefits, vacation, and possibly a good 401k. On occasion you might have accepted a contract. The pay might be nicer, but you are concerned because you have less job security, no vacation, and no benefits. Yet, there are some who prefer contracts. We will cover how to negotiate a wage, appear professional, a look at finances, contractual gottchas, taxes and paperwork. Since most are experienced at being a direct hire with a company, this presentation will show the benefits of consulting/contracting, so that you can decide what is right for you and your career path. Presenter has been contracting for 18 of the last 20 years and will share many of his experiences - the successes and the falls along the way.

SessionID: 96805

SQL and MongoDB: When Two Worlds Collide

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Strategy and Architecture

Speaker: Eric Peterson

Title: SQL and MongoDB: When Two Worlds Collide

Abstract:

Are you aware of the SQL and NoSQL worlds, but don't know why you would use both in the same sentence, let alone implement a hybrid solution? And then if you did want to set up such a system, where would you start?

After a quick overview of the SQL and NoSQL differences, we'll look at some scenarios where it makes sense to set up a hybrid environment to take advantage of the strengths of each database. Then we'll look specifically at accessing MongoDB from SQL Server.

Microsoft offers native integration with MongoDB in SQL 2019. We'll look at the mechanics of how to leverage that integration to archive data, feed a web farm, and provide more data to BI reporting.

We'll dig into querying normalized SQL and denormalized document db data structures simultaneously, and what that means for both data consistency and performance. Of course, this discussion wouldn't be complete without also knowing how to write to the document world from the relational world, so we'll cover that as well.

SessionID: 96821

Analytics on AWS

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Analytics and Visualization

Speaker: Gabriel Villa

Title: Analytics on AWS

Abstract:

If you heard of some of the data analytics products on AWS but unsure where to start, this session may help. Amazon Web Services offers analytics tools to enable data ingestion, storage, analysis, and visualization. From this session, take home an introduction to services such as AWS Data Migration Services, S3, Amazon Athena and take an introductory look into Amazon QuickSight, visualization on AWS. Learn how to leverage Amazon’s cloud infrastructure, platform and software as a service to build an analytics and insights solution on the cloud.

SessionID: 99061

Anatomy of Select

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: Advanced Analysis Techniques

Speaker: Jason Brimhall

Title: Anatomy of Select

Abstract:

TSQL is one of the most valuable tools any SQL Server professional can add to their tool-set. More aptly, TSQL is a whole chest of tools for the SQL Server professional. One of the most important tools in that TSQL chest is a good understanding of the SELECT statement.

When was the last time you sat down to evaluate a SELECT statement? What actually goes into the processing of that teeny little word? There might be a fair bit more to this simple term than just fetching data from the database. This session covers the simplicity of the select. Then we take it a step further to dive into some of the complexities tied directly to this particular statement.

This session will help the attendee better understand the Select statement. With a more solid understanding of this statement, the attendee can return and implement some of this new knowledge to help improve processing and query response times in their own environments.

SessionID: 99151

ETL Best Practices and Techniques

Back to calendar

Event Date: 12-10-2019 - Session time: 09:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Marc Beacom

Title: ETL Best Practices and Techniques

Abstract:

ETL (Extract, Transform and Load) is the backbone of any data project and can be upwards of 70% or more of the effort. The tools you have access to allow you to make progress in a hurry. However, are you implementing best practices and techniques that will scale to the demands you need? Or will you be refactoring far too quickly than you should to meet performance requirements?

Gian helpful insights from decades of lessons learned and walk away with best practices you can implement in your own ETL solution.

SessionID: 95498

Working with SQL Server containers to build database solutions

Back to calendar

Event Date: 12-10-2019 - Session time: 10:15:00 - Track: Cloud Application Development Deployment

Speaker: Carlos Robles

Title: Working with SQL Server containers to build database solutions

Abstract:

Containers are no longer the future, they are a the present and are here to change the way DBA's used to think about building SQL Server solutions.

Spending long periods of time installing, configuring and preparing databases and SQL Server instances is no longer the case with containers.

In this session you will learn the basic and advanced methods to deploy a SQL Server solution using containers in minutes.

We will explore the options and tools (open source) we have available when working with SQL Server running on Docker containers through real world scenarios, like backing up \ restoring databases, high availability, version upgrades and the most important portability between cross platforms.

SessionID: 96059

Dr. DMV's Troubleshooting Toolkit

Back to calendar

Event Date: 12-10-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Glenn Berry

Title: Dr. DMV's Troubleshooting Toolkit

Abstract:

Dynamic Management views and functions allow you to easily see exactly what is happening inside your SQL Server instances and databases with a high level of detail. You can discover your top wait types, most CPU intensive stored procedures, find missing indexes, and identify unused indexes, to name just a few examples. This session presents, demonstrates, and explains a complete set of diagnostic DMV queries that you can easily use to detect and diagnose configuration and performance issues in your SQL Server instances and databases.

This session goes into exhaustive detail on how to interpret the results of each of the diagnostic queries, including relevant background information on how to properly configure your hardware, storage subsystem, operating system, SQL Server instance, and databases in order to avoid performance and scalability issues.

SessionID: 96101

Reporting Services: A Smart Migration Strategy

Back to calendar

Event Date: 12-10-2019 - Session time: 10:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ted Stathakis

Title: Reporting Services: A Smart Migration Strategy

Abstract:

With Power BI Report Server, you can host traditional paginated reports alongside Power BI analytical reports, KPIs, and mobile reports.

This session will show how to use the data in the ReportServer database to determine a smart migration strategy for upgrading to a new SSRS or Power BI Report Server. Starting with the new features of Report Manager, Mobile Reports, KPIs, and the Mobile Report Publisher app. The session will then focus on how to utilize the report meta data in the ReportServer database, combined with the transaction log table, to show how to determine which reports, data sets, and data sources are being used and determine what objects to migrate.

Learn how to use PowerShell to extract the reports and data sets from the database, instead of downloading them, to facilitate an easy migration to a new implementation. Also, discover a way of determining all TSQL used by the reports. This session is particularly useful for migrating from 2008, but applicable to any migra

SessionID: 96878

Building Big Data Analytics solutions with Azure Databricks

Back to calendar

Event Date: 12-10-2019 - Session time: 10:15:00 - Track: Cloud Application Development Deployment

Speaker: Yuliya Quintela

Title: Building Big Data Analytics solutions with Azure Databricks

Abstract:

Interested in working with large and varied data sets but don't know where to start? Wondering if your team knows enough to apply advanced analytic techniques? Not sure if you can use your SQL skills in Big Data world?

Come and learn about Azure Databricks. This service combines power of Apache Spark large scale workloads with fully managed Azure cloud services to build data engineering pipelines, interactively run analytical tasks and implement machine learning algorithms. But what really sets it apart from other cloud analytical services, is that it is a truly collaborative environment that allows you to take advantage of diverse skills in your organization and let everyone work with data. By the end of this session you will know how to easily connect to various data sources in data lake, quickly spin up Spark clusters, use notebooks to share your code and mix languages like SQL, R, Python, and build visualizations to drive business insights.

SessionID: 97973

An Introduction to Versioning and Branching Database Code in Git

Back to calendar

Event Date: 12-10-2019 - Session time: 10:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Kendra Little

Title: An Introduction to Versioning and Branching Database Code in Git

Abstract:

SessionID: 97988

Assimilating Microsoft Access -- Upsizing to SQL Server

Back to calendar

Event Date: 12-10-2019 - Session time: 10:15:00 - Track: Application Database Development

Speaker: Phillip Labry

Title: Assimilating Microsoft Access -- Upsizing to SQL Server

Abstract:

DBAs agree, Access databases should be converted to SQL Server, but that sounds a lot easier than it turns out to be in most cases. In this session we will discuss when it is appropriate to migrate to SQL Server, migration strategies, how to manage the transition, whether to move to on premises or Azure and finally how to accomplish the task.

SessionID: 98983

Running SQL Server on AWS

Back to calendar

Event Date: 12-10-2019 - Session time: 10:15:00 - Track: Cloud Application Development Deployment

Speaker: Richard Waymire

Title: Running SQL Server on AWS

Abstract:

Learn how Amazon Relational Database Services (RDS) helps SQL Server DBAs focus their time where it matters most. We will cover Amazon RDS for SQL Server features and the key differences between running deployments on Amazon Elastic Cloud Compute (EC2) and Amazon RDS. This will include HA/DR and performance monitoring.

SessionID: 99119

Revealing the Differences in Azure Machine Learning Products

Back to calendar

Event Date: 12-10-2019 - Session time: 10:15:00 - Track: Advanced Analysis Techniques

Speaker: Ginger Grant

Title: Revealing the Differences in Azure Machine Learning Products

Abstract:

Azure Machine Learning Studio, Workspace, Pipeline and Service are different products which you can

use to create or deploy a solution and they are all called Azure Machine Learning[ AML]. Understanding the differences between the products provides the information needed to be able to architect the appropriate solution in your environment. The session demos show how to create an end-to-end AML workflow to prepare data, create ML models, deploy models, and use data contained within SQL Server by integrating a number of tools including Databricks, Python and Jupyter notebooks. Learn why you want to use AML Workspace for ML development collaboration, scaling, and management. Understand how to monitor ML models in production with AML Pipeline to organize releases and generate execution metrics. Key Takeaways Understand how to use AML products to work in collaborative environments, use ML created from a number of different tools and languages, implement version controls, and moni

SessionID: 95594

Demystifying SQL in Azure

Back to calendar

Event Date: 12-10-2019 - Session time: 12:45:00 - Track: Information Delivery

Speaker: Mark Moore

Title: Demystifying SQL in Azure

Abstract:

Are you thinking about runing Azure in SQL but don't understand all your options. Do you find the terms DTU and Elastic Pools confusing. Want to understand the difference between Azure SQL, Azure SQL Data Warehouse and Azure SQL Managed Instances. If you answered yes to any of these questions, this session is for you.

In this session I will cover all of the SQL options you have available, the pros and cons of each and how to create and use each of these options.

SessionID: 95646

Machine Learning in Azure Databricks

Back to calendar

Event Date: 12-10-2019 - Session time: 12:45:00 - Track: Analytics and Visualization

Speaker: Kara Annanie

Title: Machine Learning in Azure Databricks

Abstract:

Newly available in Azure, Databricks is a managed service that makes it easy to run computations across a cluster of computers. This session will focus on what you need to know about Databricks to get started with coding out your own ETL or data science solution. The session will showcase a machine learning algorithm coded in Python that's been parallelized using the Databricks platform.

SessionID: 95989

The Future of Database Development with Containers

Back to calendar

Event Date: 12-10-2019 - Session time: 12:45:00 - Track: Application Database Development

Speaker: Steve Jones

Title: The Future of Database Development with Containers

Abstract:

Containers are dramatically changing the way that application developers design and build their systems. Databases will need to be a part of this revolution as every application needs a data store. Come see a future vision of how full stack application development might look in the next few years.

SessionID: 96406

Moving and Transforming Your Data with Azure Data Factory V2

Back to calendar

Event Date: 12-10-2019 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Meagan Longoria

Title: Moving and Transforming Your Data with Azure Data Factory V2

Abstract:

Azure Data Factory (ADF) is a cloud-based data integration service that automates data movement and data transformation using both cloud and on-premises data sources and destinations. This introductory session will cover basic components of an ADF solution including integration runtimes, linked services, datasets, pipelines, activities, and triggers. We'll also discuss the development environment and integration with source control as well as monitoring. This session will include demos to show you how to build, execute, and monitor a pipeline. And since Data Factory is frequently updated with new features, we'll look at some of the latest releases. If you have been waiting to dip your toe in the ADF waters, this is your chance to learn the basics and ask questions.

SessionID: 96410

SQL Server Migration to the AWS: Approach and Methodology

Back to calendar

Event Date: 12-10-2019 - Session time: 12:45:00 - Track: Cloud Application Development Deployment

Speaker: Manguirish Sardessai

Title: SQL Server Migration to the AWS: Approach and Methodology

Abstract:

In today’s marketplace, moving to the public Cloud is a familiar and consistent trend within the SQL Server community. But which cloud provider do you choose? After all there are so many offering choices between AWS Cloud and Microsoft Azure, each with their own distinctive features. Migrations to the cloud are only going to gain greater momentum as organizations grapple with their on-premises alternatives.

Planning plays a critical role in moving to the cloud. Preparing a check-list and asking the right questions to stakeholders lays the groundwork in this planning. There are different methods to migrate databases from on-premises to the AWS cloud. In this presentation, we will discuss various methods and explain the advantages and disadvantages of using each method. We’ll also showcase the surprises and pitfalls to avoid as we venture into the process. Learn more on what trends you can expect to see, what the future holds for public clouds.

SessionID: 96526

Azure Analysis Services – Multidimensional solutions in the cloud

Back to calendar

Event Date: 12-10-2019 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Scot Reagin

Title: Azure Analysis Services – Multidimensional solutions in the cloud

Abstract:

Virtually all of today’s data solutions are hybrid solutions – partially in the cloud, partially on premises – as organizations attempt to fulfill an ‘all in the cloud’ mandate. The reality is that cloud platforms like Azure do many things very well, but not all things, and functional gaps remain which complicate and sometimes prevent a full migration away from on premises environments.

Azure Analysis Services (AAS) is a good example of this reality – it works very well for many applications but is limited to Tabular Models and cost can explode if those models are not created thoughtfully. And, what is the path to Azure for my multidimensional cubes? Do I care about Azure Analysis Services if I use Power BI? As always the answer to these questions is a clear and absolute ‘it depends’.

In this session we’ll explore Azure Analysis Services functionality, fit in various solutions, and gaps and techniques that are important to consider when implementing AAS.

SessionID: 96625

Power BI, from a DBA's Perspective

Back to calendar

Event Date: 12-10-2019 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: TJay Belt

Title: Power BI, from a DBA's Perspective

Abstract:

Microsoft’s Power BI is the new hotness. In this session, you will get your hands dirty and dive into PowerBI and create an actual report, with actual data. You will get to learn from examples from what a DBA has done to implement Power BI in his shop and make his data accessible.

As a DBA, we often need to collect and display data in a friendly and interactive fashion. We will play with some PowerShell to collect data from several systems, store this data in an Azure DB in the Cloud, then point Power BI at this data to display and interact with said data. You will learn a little about PowerShell, Azure SQL DB, Power BI, and how to make these work for you.

SessionID: 98042

Storing Images in a Database - Tips and Techniques

Back to calendar

Event Date: 12-10-2019 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Todd Kleinhans

Title: Storing Images in a Database - Tips and Techniques

Abstract:

How many of you have digital pictures? We are drowning in them by their sheer numbers and storage space. We take so many we often don't even have time to look at them! Have you ever thought of storing them in a database? You will learn the pro's and con's about storing images in a database using varbinary(max), FileTable and by individual pixels. Technologies covered include Columnstore, In-Memory OLTP, Python, T-SQL, and of course Unreal Engine to display them in VR using the AdventureWorks database. Come and learn how to get a handle on storing and backing up your pictures!

SessionID: 95643

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

Back to calendar

Event Date: 12-10-2019 - Session time: 14:00: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: 95966

Data Modeling and Prototyping in Power BI Desktop

Back to calendar

Event Date: 12-10-2019 - Session time: 14:00:00 - Track: BI Information Delivery

Speaker: Steve Wake

Title: Data Modeling and Prototyping in Power BI Desktop

Abstract:

Power BI Desktop is often shown as a self-service reporting and analytics tool, but it can also be used earlier in the development cycle for prototyping and data modeling, doing it quicker and easier than other tools made for this purpose.

In this session, we will go through multiple examples showing how Power BI Desktop is the perfect tool to quickly model data from multiple data sources (including web sites, databases, cubes, online services, and even flat files), and perform quick actions to cleanse and connect these various sources to each other using M and DAX functions built-in to Power BI Desktop. Once this model has been built, it can be used to create some quick reports to show how this will be used to help get a project approved/funded. Best of all, using Power BI Desktop to do all of this is completely free, no licensing or Power BI login required!

SessionID: 96061

High Availability/Disaster Recovery 101

Back to calendar

Event Date: 12-10-2019 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Glenn Berry

Title: High Availability/Disaster Recovery 101

Abstract:

How do you design a SQL Server 2019 infrastructure in order to meet specific Recovery Time Objective (RTO) and Recovery Point Objective (RPO) service levels? There are many aspects to consider, from technology choices and licensing, to policies and procedures. This session outlines and compares the various HA/DR technologies available in SQL Server 2019, showing how you can combine them to design and build a solution to help meet your HA/DR goals. This session also teaches you how to formulate policies that enable effective use of technology in your organization.

SessionID: 96305

SQL Server on Kubernetes

Back to calendar

Event Date: 12-10-2019 - Session time: 14:00:00 - Track: Cloud Application Development Deployment

Speaker: Susantha Bathige

Title: SQL Server on Kubernetes

Abstract:

SessionID: 96677

Translating your Excel Skills to Power BI

Back to calendar

Event Date: 12-10-2019 - Session time: 14:00:00 - Track: Analytics and Visualization

Speaker: Marc Beacom

Title: Translating your Excel Skills to Power BI

Abstract:

The corporate world has depended on Excel to massage and built reports for years. With the accelerated growth of Power BI, professionals are now looking to expand upon their knowledge of Microsoft Excel and enable themselves to start building interactive visuals.

Power BI is a business intelligence tool developed by Microsoft designed for business users who are already familiar with Excel. It’s specifically designed to create interactive dashboards and reports using data from a variety of sources to be published and shared across organizations.

Benefits of Power BI over Excel: • Easily share visualizations with your department and/or organization • Mobile friendly visualizations • Improved visualizations • Accelerated development cycle with monthly updates • Combine and work with data in multiple sources or workbooks

SessionID: 96774

Innovative Data Modeling: Make Data Warehousing Cool Again Part 1

Back to calendar

Event Date: 12-10-2019 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Leslie Weed

Title: Innovative Data Modeling: Make Data Warehousing Cool Again Part 1

Abstract:

There is much more to life than 3rd normal form and dimensional modeling. Come explore how you can build a data warehouse solution or hybrid solution that is agile in nature with Data Vault. Discover this highly audit-able modeling technique used in international banking, manufacturing, insurance and many more industries. Made a mistake? No worries, own your model. Design changes happen and it can be addressed quickly avoiding pain and project delays and ultimately keeping your business happy. Let us bust the myth that data warehouses take too long to build and are too hard to modify by adding value to your environment and decreasing delivery time.

SessionID: 96907

Operationalize Data Science for Advanced Decision Support

Back to calendar

Event Date: 12-10-2019 - Session time: 14:00:00 - Track: Information Delivery

Speaker: Carlos Bossy

Title: Operationalize Data Science for Advanced Decision Support

Abstract:

Modern-day computing power makes it possible to create sophisticated predictive models that classify data, perform anomaly detection, and predict behaviors and tendencies.

Using data engineering principles and the latest tools released by Microsoft in Azure Machine Learning service to create a data science framework, you’ll see how to develop predictive models through the entire life cycle and incorporate them into your applications in a way that impacts the decision-making ability of everyone in your organization.

Through a case study, you’ll learn how to choose a meaningful project with a high likelihood for success, including setting a prediction target and how to use data appropriately and adapt it to the model for maximum results. Best practices will be presented for developing, monitoring, and maintaining predictive models. Integrating predictive models into your architecture will allow you to take a step toward making predictive analytics pervasive in your organization.

SessionID: 98046

Data Collection and Usage: Illegal or Unethical?

Back to calendar

Event Date: 12-10-2019 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Angela Tidwell

Title: Data Collection and Usage: Illegal or Unethical?

Abstract:

Data collection and usage is all around us, it is what we do. But is what we do with the data ethical? Are we collecting and processing biased data? We will take a look at ethical data collection and usage, what it means to your models and forecasts, and how being aware of possible biases can impact your bottom line. You might be training on extremely biased data and not know it, skewing your forecasts in the wrong direction.

SessionID: 98959

Weird Stuff I Saw While … Supporting a Java Team

Back to calendar

Event Date: 12-10-2019 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Rick Lowe

Title: Weird Stuff I Saw While … Supporting a Java Team

Abstract:

After spending more than a decade completely devoted to the Microsoft stack, I did some time supporting a Java team. Yes, sure, Java is just another language so there aren't really and issues that are absolutely unique to the Java world. But it is a different stack, different culture, and different group of folks giving bad advice to developers ... just enough different to keep life interesting. Come hear about my misadventures with server side cursors, output parameters, integrated authentication, and NOCOUNT settings.

SessionID: 95744

Predicting the NFL with SQL Server 2017 ML Services

Back to calendar

Event Date: 12-10-2019 - Session time: 15:15:00 - Track: Analytics and Visualization

Speaker: John Byrnes

Title: Predicting the NFL with SQL Server 2017 ML Services

Abstract:

Every wonder if you could predict the outcome of the Superbowl? Or know the score of any game? The NFL is perfect for predictive analytics: it has a fixed time frame, a set playing field, and rigorous rules.  These are characteristics we can only envy in the business world. With the integration of ML Services in SQL Server 2017, we have the strength of statistical languages like R and Python right within the database engine. In this session, John will demonstrate the steps for successfully preparing the data, then run a regression model to predict the scores for the current week’s scheduled NFL game.  Want to know if your team is likely to win against the spread?  Wanna bet?

SessionID: 95950

SQL Servers on Containers

Back to calendar

Event Date: 12-10-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Christopher Wolff

Title: SQL Servers on Containers

Abstract:

Do you have a great CI/CD setup on the web side but wish you could do the same on the data side? Installing SQL Server on containers may be the key technology you need to make this wish a reality. In this quick summary we will go over what containers are, differences from VM’s, gotcha’s and things to keep in mind, and talk a bit about newer orchestrators like Kubernetes.

SessionID: 96138

Preparing your Business for Data Science

Back to calendar

Event Date: 12-10-2019 - Session time: 15:15:00 - Track: Strategy and Architecture

Speaker: Amie Mason

Title: Preparing your Business for Data Science

Abstract:

Wanting to take advantage of all that predictive analytics and machine learning have to offer, but unsure how to get started? This session will help you understand the types of business problems data science can impact and how to frame your scenarios for success. Understand the data science life cycle, what a successful team looks like, and the tools available to help you get started.

SessionID: 96785

Innovative Data Modeling: Make Data Warehousing Cool Again Part 2

Back to calendar

Event Date: 12-10-2019 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jeff Renz

Title: Innovative Data Modeling: Make Data Warehousing Cool Again Part 2

Abstract:

This is the advanced part 2 of Innovative Data Modeling. Learn how to leverage Master Data Management and Azure Technologies to extend your model for performance, history and reference unstructured data. We will explore how you can use continuous integration and delivery to further maximize value. Let's look at platform specific techniques and also explore design options for Azure SQL Data Warehouse.

SessionID: 96929

Migrating your SQL Server to the cloud: Tips and Best Practices

Back to calendar

Event Date: 12-10-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Daniel Janik

Title: Migrating your SQL Server to the cloud: Tips and Best Practices

Abstract:

Have you been asked to assist in a migration to the cloud? Where do you start? What are the potential pitfalls? How do you know which path to take to lead you to success? In this session you'll learn about the challenges of migrating from on-prem to the cloud and how to overcome them to ensure success for you and your organization.

SessionID: 98157

Practical Container Scenarios in Azure

Back to calendar

Event Date: 12-10-2019 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Anthony Nocentino

Title: Practical Container Scenarios in Azure

Abstract:

You’ve heard the buzz about containers and Kubernetes, now let’s start your journey towards rapidly deploying and scaling your container-based applications in Azure. In this session, we will introduce containers and the container orchestrator Kubernetes. Then we’ll dive into how to build a container image, push it into our Azure Container Registry and deploy it our Azure Kubernetes Services cluster. Once deployed, we’ll learn how to keep our applications available and how to scale them using Kubernetes.

SessionID: 98960

Azure Analytics Platform Quickstart

Back to calendar

Event Date: 12-10-2019 - Session time: 15:15:00 - Track: Cloud Application Development Deployment

Speaker: Jason Horner

Title: Azure Analytics Platform Quickstart

Abstract:

Are you struggling to get you analytics and data projects started on Azure? Overwhelmed by where to start or which services to choose? or perhaps just interested in learning more about the options to move your current BI platform to the cloud. This hands-on session is for you. We will start with a brief overview of the Azure platform then we will guide you through getting an environment setup. Along the way will answer any questions and talk about specific pitfalls and decision that need to be made to ensure you are able to continue to build on this newly acquired knowledge.

SessionID: 99174

DevOps or Decoys

Back to calendar

Event Date: 12-10-2019 - Session time: 15:15:00 - Track: Advanced Analysis Techniques

Speaker: Kellyn Pot'Vin-Gorman

Title: DevOps or Decoys

Abstract:

DevOps automation can be intriguing to learn and overwhelming to implement. This session will take a real life use case of a multi-tier and complex environments, with various stake holders to a successful conclusion. Unlike a session on concepts, this session surrounds itself with a real-life situation and how automation was used with DevOps practices to build a solution. The session will demonstrate the reasons to automate, along with the steps required to make it possible, offering insight into concepts that are often too vague to employ. The attendee will see multi-platform and cloud tool demonstrations on how to take the DevOps methodology and continuous delivery to actuality in their own projects, no matter if small or large.