sqlsathistory

Nr: 830

SQLSaturday #830 - Colorado Springs 2019

Start Time (24h)	Speaker	Track	Title
08:30:00	Suresh Datla	BI Information Delivery	Power BI Security - End to End
09:00:00	Leslie Andrews	BI Platform Architecture, Development Administration	The Power of Data: The Complete Beginners Data Warehouse Kit
09:00:00	Daniel Maenle	Application Database Development	Dump the Trace: Extending your Events
09:00:00	Jeff Moden	Enterprise Database Administration Deployment	“Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance
09:00:00	Manguirish Sardessai	Cloud Application Development Deployment	Accelerate SQL Server Migration to the AWS Cloud: Approach and Methodology
09:00:00	Scot Reagin	Professional Development	Hyphenated Data Roles in Today's Information Environment
09:00:00	Carlos Robles	Cloud Application Development Deployment	Exploring SQL Server containers on Docker Kubernetes
10:15:00	Alex Grinberg	Advanced Analysis Techniques	CONVERT_IMPLICIT is a hidden danger
10:15:00	Michelle Haarhues	Enterprise Database Administration Deployment	Keeping up with SSMS
10:15:00	Jeff Moden	Enterprise Database Administration Deployment	“Black Arts” Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks.
10:15:00	Jeff Renz	Analytics and Visualization	Introduction to the R Programming Language for BI Professionals
10:15:00	Yuliya Quintela	Cloud Application Development Deployment	Say Anything: Using knowledge base, NLP and AI to enable customer
10:15:00	Isak Sky	Application Database Development	Building Composable Query Abstractions in TSQL
11:00:00	César Oviedo	BI Platform Architecture, Development Administration	The next generation of Business Intelligence is done with DevOps
11:30:00	Steve Wake	BI Information Delivery	Power BI Premium: Is it for your Company (and Worth it)?
11:30:00	Kalen Delaney	Application Database Development	Everlasting Issues with Temporary Tables and tempdb
11:30:00	Eric Peterson	Professional Development	So you want to be a consultant?
11:30:00	TJay Belt	Enterprise Database Administration Deployment	Power BI, from a DBA's Perspective
11:30:00	Marc Beacom	Cloud Application Development Deployment	Implementing a Cloud Analytics Solution: Options, Costs and More
11:30:00	Todd Kleinhans	Application Database Development	Storing Images in a Database - Tips and Techniques
14:00:00	Mitchell Bottel	Professional Development	Effective Communication and Self Promotion for the IT Introvert (YOU!)
14:00:00	Mark Moore	Enterprise Database Administration Deployment	Understanding Azure SQL Managed Instances
14:00:00	Greg Moore	Strategy and Architecture	The very Model of a Modern Day Database
14:00:00	Leslie Weed	BI Platform Architecture, Development Administration	Innovative Data Modeling: Make Data Warehousing Cool Again
14:00:00	Paul Nielsen	Application Database Development	Professional SQL Server Development
14:00:00	Christopher Wolff	Cloud Application Development Deployment	SQL Server using Amazon Web Services EC2 Instances
14:45:00	Pini Krisher	Cloud Application Development Deployment	Azure SQL DB and PowerBI the Best friends
15:15:00	Meagan Longoria	BI Information Delivery	Creating Accessible Power BI Reports: Challenges Opportunities
15:15:00	Mike Byrd	Application Database Development	Indexing Like a Rocket Scientist
15:15:00	Jason Horner	BI Platform Architecture, Development Administration	Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2
15:15:00	Elizabeth Noble	Enterprise Database Administration Deployment	Migrate Your Database with Distributed AGs
15:15:00	Carlos Bossy	Advanced Analysis Techniques	Data Science Tips and Tricks using Python and SQL
15:15:00	Sean McCown	Enterprise Database Administration Deployment	Loading SQL Server Data with Powershell

SessionID: 86687

Power BI Security - End to End

Back to calendar

Event Date: 06-04-2019 - Session time: 08:30:00 - Track: BI Information Delivery

Speaker: Suresh Datla

Title: Power BI Security - End to End

Abstract:

Their many aspects to consider when securing Power BI applications. Starting with authentication all the way to Row Level Security and everything in between. We will discuss the different elements as well as best practices.

SessionID: 87091

The Power of Data: The Complete Beginners Data Warehouse Kit

Back to calendar

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

Speaker: Leslie Andrews

Title: The Power of Data: The Complete Beginners Data Warehouse Kit

Abstract:

For many of us data is scattered in many different systems. We almost all have data that someone wants to compare or track but can't without a lot of manual manipulation. So, how do you tie disparate systems together? With a Data Warehouse! In this presentation you will get the skills you need to start building your own. We will discuss the basics of what a Data Warehouse is, the tools needed to create, deploy and manage the Data Warehouse process, and the benefits of using the data you collect to manage operational processes and create data visualizations. After attending this session you will be able to return to your job and amaze people with your ability to show them the power of the data!

SessionID: 87289

Dump the Trace: Extending your Events

Back to calendar

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

Speaker: Daniel Maenle

Title: Dump the Trace: Extending your Events

Abstract:

This will be an introduction into using Extended Events and why to drop using SQL Trace. As well as some basic scripts with tools for parsing XQuery, and some good basic XE use cases. This session will help become more comfortable with Extended Events.

SessionID: 88238

“Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance

Back to calendar

Event Date: 06-04-2019 - Session time: 09:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jeff Moden

Title: “Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance

Abstract:

Most people don’t realize it but the current “Best Practice” Methods are actually a leading cause of perpetual logical and physical fragmentation, totally unnecessary wasted memory, costly and continuous “Bad” page splits, unexplainable blocking, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, a major part of why we have to do so much index maintenance.

This isn’t your typical presentation on Index Maintenance.

In this first of two back-to-back sessions on the subject, we’ll explore what happens to an index in the first year of its life for four different common Fill Factors along with how “Best Practice” methods executed once per week and once per day have their way with you, your indexes, your log files, wasted memory, and the performance of your code even if it’s perfect code.

SessionID: 88369

Accelerate SQL Server Migration to the AWS Cloud: Approach and Methodology

Back to calendar

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

Speaker: Manguirish Sardessai

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

Abstract:

In today’s marketplace, moving to the public Cloud(AWS) is a familiar and consistent trend within the SQL Server community. After all there are so many offering choices between AWS EC2 and RDS, 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.

In this presentation, we will discuss various methods and explain the advantages and disadvantages of using each method along with best practises. 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, and see how the DBA role and their responsibilities are undergoing changes to fit into the new profile necessary in managing the cloud framework.

SessionID: 89763

Hyphenated Data Roles in Today's Information Environment

Back to calendar

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

Speaker: Scot Reagin

Title: Hyphenated Data Roles in Today's Information Environment

Abstract:

A modern Information Environment requires a wide and growing variety of disciplines, each with discrete skills that should compliment but often overlap others. By understanding disciplines like Data Management, Acquisition, Modeling, Engineering, Science and BI Developer, Analyst, and Architect you will better understand how to work with others and how you might grow or transition into other roles.

SessionID: 92113

Exploring SQL Server containers on Docker Kubernetes

Back to calendar

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

Speaker: Carlos Robles

Title: Exploring SQL Server containers on Docker Kubernetes

Abstract:

In this session, we will explore the options we have when working with SQL Server running on Docker containers or Kubernetes. Also, will take a look at some real-world scenarios of backing up \ restoring databases in containers, high availability, version upgrades, and the most important portability. Join me to discuss further about this interesting topic that is called by some experts as “The Future of Database Infrastructure”.

SessionID: 86811

CONVERT_IMPLICIT is a hidden danger

Back to calendar

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

Speaker: Alex Grinberg

Title: CONVERT_IMPLICIT is a hidden danger

Abstract:

Abstract: The CONVERT_IMPLICIT operator is part of an execution plan. When an execution plan has a CONVERT_IMPLICIT operator, this is a signal that “your statement has a problem”. This presentation will show you how to detect the Execution Plans with CONVERT_IMPLICIT operator; how to find the statement that causes conversion, and what DMVs can help to solve the problem. It will also show you the solution to collect the Execution Plans with CONVERT_IMPLICIT operator across the servers.

SessionID: 87036

Keeping up with SSMS

Back to calendar

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

Speaker: Michelle Haarhues

Title: Keeping up with SSMS

Abstract:

Starting with SQL Server 2016, SSMS became a stand-alone product. Updates are sent out a lot more frequently than in the past and it can sometimes be difficult to keep up with all of the changes and new features. There were 7 new version releases in 2017 and 8 new version releases in 2018. With all of the new releases, are you using SQL Server Management Studio to its fullest? We will discuss some of the features available in the SSMS v17 and v18.

On top of the new versions, there is a lot of cool stuff available in SSMS that you may not be aware is there. We will discuss and demonstrate some features offered in SSMS that will help make Developers and Database Administrators more productive (and everyone wants to be more productive). Whether a DBA or a Developer, you will take away knowledge about the new SSMS versions along with some useful SSMS tips/tricks to use in SSMS that you can apply in your day to day activities.

SessionID: 88239

“Black Arts” Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks.

Back to calendar

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

Speaker: Jeff Moden

Title: “Black Arts” Index Maintenance #2: Better Methods that Can Actually Prevent Fragmentation for Weeks.

Abstract:

Most people don’t realize it but the current “Best Practice” Methods are actually a leading cause of perpetual logical and physical fragmentation, totally unnecessary wasted memory, costly and continuous “Bad” page splits, unexplainable blocking, comparatively insane amounts of log file generation and, in an interesting “Catch 22”, a major part of why we have to do so much index maintenance.

This isn’t your typical presentation on Index Maintenance.

In this second of two back-to-back sessions, we’ll learn of several incredibly easy modifications to your Index Maintenance routines to actually prevent fragmentation for weeks rather than perpetuating it, virtually eliminate “Bad” page splits, reduce wasted memory, make your log file log file backups a whole lot more happy and increase the overall performance of even perfect code.

We’ll also learn that no simple method is a panacea, what to do about the horror of "expAnsive" updates, and how to make even GUID-keyed indexes work well.

SessionID: 88561

Introduction to the R Programming Language for BI Professionals

Back to calendar

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

Speaker: Jeff Renz

Title: Introduction to the R Programming Language for BI Professionals

Abstract:

The modern BI professional is taking on the challenge of operationalizing data science. Most BI developers are very strong in TSQL but their exposer to advanced statistics and visualizations were limited by what is available in the TSQL language. The R programming language allows us to clean, visualize, and apply advanced statistical methods to data.

In this session I will demonstrate how to use R Studio to generate and test R scripts; generate R visuals in PowerBI; call R code in machine learning workflows; and execute R code in SQL Server. Additionally, I will cover these R programming fundamentals: creating and assigning variables; performing simple calculations; understanding R data types; vectors; matrices; factors; lists; data frames; and ggplot2 graphics.

SessionID: 89807

Say Anything: Using knowledge base, NLP and AI to enable customer

Back to calendar

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

Speaker: Yuliya Quintela

Title: Say Anything: Using knowledge base, NLP and AI to enable customer

Abstract:

Today companies have an abundance of unstructured data. It exists in emails, text files and documents. It is not easily searchable and usable without a lot of prep work. But this data contains valuable information!

Companies can use this new information in many different ways, for example to enable customers for a self-service support. Customers might be looking for the same answer, but they will likely ask their questions in different ways. Customers really want to be able to ... say anything. Come and learn how to use Azure technologies to build a Chat Bot to answer questions based on FAQ URLs, structured documents or product manuals.

SessionID: 89809

Building Composable Query Abstractions in TSQL

Back to calendar

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

Speaker: Isak Sky

Title: Building Composable Query Abstractions in TSQL

Abstract:

A common critique of SQL is that it can be hard to write queries with reusable parts, something which is trivial in many programming languages. For example, even something simple, like running a query with different set of selections can be tricky to express.

This presentation will show how this problem can be avoided by taking a data-first approach and using some advanced TSQL constructs. Along the way, we will also go over how to do GraphQL-like queries in TSQL.

SessionID: 87000

The next generation of Business Intelligence is done with DevOps

Back to calendar

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

Speaker: César Oviedo

Title: The next generation of Business Intelligence is done with DevOps

Abstract:

The next generation of Business Intelligence practices is about improving effectiveness and accuracy. The simplest, most efficient way to do that is through DevOps. DevOps for BI is no longer just getting your schemas into version control. DevOps can bring the entire agile lifecycle to the BI world. Agile development and continuous integration will improve the customer experience. Advancements gained from using DevOps in BI are improved accuracy, consistency, and faster delivery. DevOps for BI is a methodology of development, testing, QA, and Implementation that will increase the success of your projects and enhancements. This session explains with real-world examples the issues and solutions we have seen that will convince you to adopt this methodology. We will walk through the steps to expand on what you do now and the efficiencies you will gain by starting or expanding your use of DevOps in your BI environment.

SessionID: 86690

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

Back to calendar

Event Date: 06-04-2019 - Session time: 11:30: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 or not. At the end of this session you will be armed with all of the knowledge you will need to make the right decision.

SessionID: 89352

Everlasting Issues with Temporary Tables and tempdb

Back to calendar

Event Date: 06-04-2019 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Kalen Delaney

Title: Everlasting Issues with Temporary Tables and tempdb

Abstract:

Tempdb has been a source of configuration confusion since the very first version of SQL Server. Each SQL Server instance only has one tempdb database used by all users in all databases. In this session, we’ll look at all the different uses of tempdb and how to configure your tempdb to support them. We’ll look at all the different kinds of temporary tables and see when you should use each type. We’ll talk about the difference between global and local temp tables, table variables and work tables. We’ll explore the various tools available that let you monitor the use (and abuse) of your tempdb database and we look at some best practice guidelines for how to keep your tempdb as healthy as possible.

SessionID: 89735

So you want to be a consultant?

Back to calendar

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

Speaker: Eric Peterson

Title: So you want to be a consultant?

Abstract:

Have you been looking for new opportunities and thought about consulting, but aren't sure if it's for you? We'll compare the different types of consulting options and the pros and cons of each. We'll look at the risks involved – from finance to lack of stability – and how to mitigate them.

Ever wondered what the advantages of being a Full Time Employee (FTE) vs a consultant are? We'll look at ways to get the most interesting projects as a consultant, the perception of consultants in the workplace, keeping your skills up and more.

We'll explore the expectations for consultants and how you can overcome the imposter complex. We'll also look at the logistics for payroll, retirement and taxes so you can stay on the right side of the IRS without driving yourself crazy.

Then we'll review the various ways you can find new projects because waiting for someone to call you out of the blue just isn't enough.

SessionID: 89801

Power BI, from a DBA's Perspective

Back to calendar

Event Date: 06-04-2019 - Session time: 11:30: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: 89837

Implementing a Cloud Analytics Solution: Options, Costs and More

Back to calendar

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

Speaker: Marc Beacom

Title: Implementing a Cloud Analytics Solution: Options, Costs and More

Abstract:

If you’ve looked at the cloud, you’ve realized the large number of options you have, to implement a complete cloud analytics solution. You can deploy dashboards, data ingestion and integration and advanced analytics to the cloud that will empower data-driven decisions for your organizations. This talk will discuss and review options you have, to run Cloud Analytic Solutions on Azure.

SessionID: 89839

Storing Images in a Database - Tips and Techniques

Back to calendar

Event Date: 06-04-2019 - Session time: 11:30:00 - Track: Application Database Development

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

Effective Communication and Self Promotion for the IT Introvert (YOU!)

Back to calendar

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

Speaker: Mitchell Bottel

Title: Effective Communication and Self Promotion for the IT Introvert (YOU!)

Abstract:

SessionID: 88037

Understanding Azure SQL Managed Instances

Back to calendar

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

Speaker: Mark Moore

Title: Understanding Azure SQL Managed Instances

Abstract:

Have you heard about Azure SQL Managed Instances and want to know more. This session will discuss what SQL managed instances are and are not, we will cover the different families of Managed Instances and we will cover networking requirements for Managed Instances.

SessionID: 88299

The very Model of a Modern Day Database

Back to calendar

Event Date: 06-04-2019 - Session time: 14:00:00 - Track: Strategy and Architecture

Speaker: Greg Moore

Title: The very Model of a Modern Day Database

Abstract:

Gilbert and Sullivan never had to create a database. But you do. This session will delve into details of the system databases.

These are created when the system is installed and then DBAs pretty much forget about them. If you ask, they might have an idea of what their use is, but the truth is, they're sort of a black box to many.

This session will cover how and when to back them up, how to move them if necessary and how to take advantage of that "model" database that seems to just sort of sit there.

SessionID: 89846

Innovative Data Modeling: Make Data Warehousing Cool Again

Back to calendar

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

Speaker: Leslie Weed

Title: Innovative Data Modeling: Make Data Warehousing Cool Again

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

Professional SQL Server Development

Back to calendar

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

Speaker: Paul Nielsen

Title: Professional SQL Server Development

Abstract:

You’ve seen numerous presentations with demos of code snippets and techniques but how do you wrap all those ideas into a comprehensive set of guidelines to ensure that your code is enterprise grade? In this session we’ll look at several examples of complex production grade code and offer guidelines to take your SQL Server code to the next level.

SessionID: 92652

SQL Server using Amazon Web Services EC2 Instances

Back to calendar

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

Speaker: Christopher Wolff

Title: SQL Server using Amazon Web Services EC2 Instances

Abstract:

You have just been informed that you are moving to AWS. Now what? In this presentation, we’ll cover the ups and downs of using AWS Elastic Cloud Computing (EC2) instances for your SQL Server. We will show you how to make an EC2 instance and install SQL Server on it; go over networking, security and routing services; and demonstrate how to make a simple, highly available, two-node availability group. By the end of the session, you should be on the right track to start using AWS in your environment.

SessionID: 86691

Azure SQL DB and PowerBI the Best friends

Back to calendar

Event Date: 06-04-2019 - Session time: 14:45:00 - Track: Cloud Application Development Deployment

Speaker: Pini Krisher

Title: Azure SQL DB and PowerBI the Best friends

Abstract:

Since PowerBI is a great tool for telling us Data stories, and Azure SQL DB is the easiest place to hold DATA, Both are very good friends....

SessionID: 87133

Creating Accessible Power BI Reports: Challenges Opportunities

Back to calendar

Event Date: 06-04-2019 - Session time: 15:15:00 - Track: BI Information Delivery

Speaker: Meagan Longoria

Title: Creating Accessible Power BI Reports: Challenges Opportunities

Abstract:

Accessibility is catering for your whole audience, including those with disabilities. According to the US Census Bureau, 19 percent of the of the population had a disability in 2010. Do you know if your reports are designed in an inclusive way such that everyone can use them? This can be especially important if you are making reports for government entities, educational institutions, or the general public. In this session, we'll discuss accessibility standards and regulations of which you may want to be aware, how users with disabilities can consume Power BI reports, and guidance and pitfalls when designing inclusive reports.

SessionID: 87800

Indexing Like a Rocket Scientist

Back to calendar

Event Date: 06-04-2019 - Session time: 15:15: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: 89326

Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2

Back to calendar

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

Speaker: Jason Horner

Title: Real-World Data Movement and Orchestration Patterns using Azure Data Factory V2

Abstract:

In this session, we will start with an overview of Azure Data Factory V2 concepts, then show you how you can use metadata to quickly build scalable serverless pipelines to move data from disparate data sources including On-Premises and Platform As A Service. Next, we will look at how to integrate the solution using continuous integration and deployment techniques. Finally, we will look at how to schedule, monitor and log our solution.

Whether you are just getting started with Azure Data Factory or looking to make your current data factory robust and enterprise-ready this session will take you to the next level.

SessionID: 89591

Migrate Your Database with Distributed AGs

Back to calendar

Event Date: 06-04-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Elizabeth Noble

Title: Migrate Your Database with Distributed AGs

Abstract:

You find yourself needing to migrate to new hardware or new operating system. If you're running SQL Server 2016+, you're in luck! Distributed Availability Groups (AGs) may just be the solution you want.

In this session I will explain the purpose and usages of Distributed AGs, create a Distributed AG and the associated AGs, and perform a mock data center migration.

NOTE: This session expects that attendees are already familiar with Availability Groups.

SessionID: 89842

Data Science Tips and Tricks using Python and SQL

Back to calendar

Event Date: 06-04-2019 - Session time: 15:15:00 - Track: Advanced Analysis Techniques

Speaker: Carlos Bossy

Title: Data Science Tips and Tricks using Python and SQL

Abstract:

The practice of Data Science has arrived and as data professionals we're on the forefront of this change. The data we collect can now be used in new and exciting ways, providing more value than ever before.

To get started in this field, a number of tools and methodologies must be employed to help you achieve predictive analytics success with your data. In this session, we will start by providing an introduction to Python, quickly becoming the defacto programming language for data scientists who want to create enterprise-ready solutions.

Carlos will then cover predictive analytics using T-SQL and Python, providing a practical understanding of what it takes to develop your own predictive models making the most of the expertise you already have. The session includes an overview of definitions, concepts and terminology, successful applications of predictive analytics, and how predictive analytics fits into an analytics environment.

SessionID: 92923

Loading SQL Server Data with Powershell

Back to calendar

Event Date: 06-04-2019 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Loading SQL Server Data with Powershell

Abstract:

Powershell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop.

This site is open source. Improve this page.