sqlsathistory

Nr: 869

Back to Main list

SQLSaturday #869 - Phoenix 2019

Start Time (24h)	Speaker	Track	Title
08:00:00	Ginger Grant	Advanced Analytics	Outdoor Courtyard Welcome Message for SQL Saturday Phoenix
08:30:00	Leslie Andrews	BI ETL Architecture, Development Administration	A Perfect Ten: The Data Model
08:30:00	Suresh Datla	Data Visualization and Reporting	Power BI Security - End to End
08:30:00	John Morehouse	Cloud Application Development Deployment	Azure Basics for the DBA
08:30:00	Mark DeNeve	Enterprise Database Development, Administration Deployment	Containers: Crash course for SQL Server DBAs
08:30:00	Kevin Karns	Database Maintenance And Performance Tuning	Statewide Geography and Spatial Computing in SQL Server.
08:30:00	Adrian Mee	Introductory Data Topics Professional Development	SQL Server Management Studio - Beyond the basics
08:30:00	David Lundell	Database Maintenance And Performance Tuning	Open Source vs SQL Database Maintenance Plans
08:30:00	Steve Williams	Data Visualization and Reporting	Website Analysis Using PowerBI and App Insights: Easier than you think
08:30:00	Eddie Edgeworth	Advanced Analytics	Accelerating Insights with Azure Databricks
09:45:00	Monica Rathbun	Database Maintenance And Performance Tuning	Performance Tuning, Getting the Biggest Bang for Your Buck
09:45:00	Amie Mason	Advanced Analytics	Real-World AI in Azure
09:45:00	Jeff Iannucci	Database Maintenance And Performance Tuning	Faster Transactions: Query Tuning for Data Manipulation
09:45:00	Eric Peterson	Enterprise Database Development, Administration Deployment	SQL vs NoSQL: a Comparison of SQL vs MongoDB
09:45:00	Martin Schoombee	Data Visualization and Reporting	Advanced Power BI Modeling Techniques
09:45:00	Delora Bradish	Introductory Data Topics Professional Development	SSAS Tabular Models 101: Make a big difference in a small space
09:45:00	David Bess	Advanced Analytics	Devops for Data Science
11:00:00	Leslie Andrews	BI ETL Architecture, Development Administration	The Power of Data: The Complete Beginners Data Warehouse Kit
11:00:00	Meagan Longoria	Data Visualization and Reporting	Practical Power BI Report Design Tips for the Non-Artist
11:00:00	Joseph Barth	Cloud Application Development Deployment	Azure Data Factory Version 2 - Templates and new features
11:00:00	Kimberly StJacques	Enterprise Database Development, Administration Deployment	I have to support what!? SQL, Oracle, and Mongo - A side by side “how to”
11:00:00	Sean Brown	Enterprise Database Development, Administration Deployment	Introduction to Execution Plans
11:00:00	Mohamed Mawla	Cloud Application Development Deployment	From Zero to Hero: Start Machine Learning using Azure ML studio
11:00:00	Phil Guevara	Advanced Analytics	No Pane, No Gain: A Beginner's Guide to Window Functions
12:00:00	Kimberly StJacques	Introductory Data Topics Professional Development	Professional Development Lunch Session with Paychex
12:00:00	Ginger Grant	Advanced Analytics	Introduction to Snowflake, the data warehouse build for the cloud
13:00:00	Meagan Longoria	Data Visualization and Reporting	Do Your Data Visualizations Need A Makeover?
13:00:00	John Morehouse	Enterprise Database Development, Administration Deployment	Temporal Tables – The New Hotness in Data Auditing
13:00:00	Vern Rabe	Database Maintenance And Performance Tuning	T-SQL Habits and Practices That Can Kill Performance
13:00:00	Brian Hansen	Enterprise Database Development, Administration Deployment	Real-World PowerShell for SQL Administration
13:00:00	Andrea Letourneau	BI ETL Architecture, Development Administration	Azure Data Factory V2: SSIS in the Cloud or not?
13:00:00	Jeff Iannucci	Introductory Data Topics Professional Development	SELECT Start FROM Here: Querying for T-SQL Beginners
13:00:00	Cristian Vasconez	Advanced Analytics	Data Virtualization unlocking data and enabling analytics using Denodo, Azure and Microsoft BI Stack
14:15:00	Monica Rathbun	Introductory Data Topics Professional Development	I'm It - Survival Techniques for the Lone DBA
14:15:00	Russel Loski	BI ETL Architecture, Development Administration	Managing ETL Change using BIMLScript
14:15:00	Phil Robinson	Introductory Data Topics Professional Development	Power BI Desktop Tips and Best Practices for Projects and Data Preparation
14:15:00	Brian Hansen	Database Maintenance And Performance Tuning	Get Your Optimizer to Give up All Its Secrets
14:15:00	Paul Stanton	Cloud Application Development Deployment	SQL DevOps Simplified with Production Databases
14:15:00	Andrea Letourneau	Data Visualization and Reporting	Put More Power into Power BI
14:15:00	JT Moree	Enterprise Database Development, Administration Deployment	SQL Antipatterns
14:15:00	Alexander Brown	Introductory Data Topics Professional Development	Databricks and End-to-End Processes
15:30:00	Amie Mason	BI ETL Architecture, Development Administration	Keys to Successfully Governing Power BI for your Organization
15:30:00	Mohammad Darab	Introductory Data Topics Professional Development	3 Keys to Successful Consulting
15:30:00	Phil Robinson	Introductory Data Topics Professional Development	Data Wrangling for Reporting Analytics using Power BI
15:30:00	Deji Akomolafe	Enterprise Database Development, Administration Deployment	Successfully Virtualizing SQL Server on vSphere - Straight from the Source
15:30:00	Jeff Mlakar	Enterprise Database Development, Administration Deployment	Environmental SQL Server Troubleshooting
15:30:00	Yaseen Jamaludeen	Introductory Data Topics Professional Development	Creating Real Solutions with Power Tools Power BI, Apps and Flow
15:30:00	David Lundell	Cloud Application Development Deployment	Azure AD authentication methods for SQL Azure
15:30:00	Yueying Li	Advanced Analytics	Deploying ML Models w/ Tableau

SessionID: 93687

Outdoor Courtyard Welcome Message for SQL Saturday Phoenix

Back to calendar

Event Date: 04-05-2019 - Session time: 08:00:00 - Track: Advanced Analytics

Speaker: Ginger Grant

Title: Outdoor Courtyard Welcome Message for SQL Saturday Phoenix

Abstract:

We are going to review the Logisitics of SQL Saturday

SessionID: 89910

A Perfect Ten: The Data Model

Back to calendar

Event Date: 04-05-2019 - Session time: 08:30:00 - Track: BI ETL Architecture, Development Administration

Speaker: Leslie Andrews

Title: A Perfect Ten: The Data Model

Abstract:

Do you know what makes a great data model? What does it mean to be Third Normal Form or a Star Schema? When would you use one over the other and why? How can you identify bad designs? In this presentation you will be exposed to good and bad models and learn what you should do in order to create a perfect ten model of your own!

SessionID: 90003

Power BI Security - End to End

Back to calendar

Event Date: 04-05-2019 - Session time: 08:30:00 - Track: Data Visualization and Reporting

Speaker: Suresh Datla

Title: Power BI Security - End to End

Abstract:

Power BI security is probably one of the most critical aspects in Power BI implementations yet most often times it is overlooked. There are many aspects to consider when implementing security. We will be discussing many of these aspects as well diving into details of how data is stored within Power BI, where it is hosted and get into the details of governance and compliance aspects in the context of security.

SessionID: 90278

Azure Basics for the DBA

Back to calendar

Event Date: 04-05-2019 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: John Morehouse

Title: Azure Basics for the DBA

Abstract:

It's not a question of whether or not the landscape for the common DBA is changing. Without a doubt, it is. Azure offers up a new world of possibilities for DBA's and we should all strive to learn it. In this session, we'll cover some basic knowledge and terminology of Azure as well as how easy it is to incorporate Azure into your environment. We will stand up a new Azure virtual machine as well as a setup SQL DB. You will see how easy it is to accomplish this. This new-found knowledge will help propel your career into the new landscape.

SessionID: 90896

Containers: Crash course for SQL Server DBAs

Back to calendar

Event Date: 04-05-2019 - Session time: 08:30:00 - Track: Enterprise Database Development, Administration Deployment

Speaker: Mark DeNeve

Title: Containers: Crash course for SQL Server DBAs

Abstract:

Have you heard about these “Container” things? You may have questions like “What is a Container?”, Who is this “Docker?”, “Aren’t containers a Linux Thing?” and “As a DBA why do I care?” Sit back and listen as we cover these questions and many more. We will then take a closer look at leveraging Containers in a SQL world. We will review the published Microsoft SQL Server container images, what you can do with them and why you would want to use them. We will then show some examples of running MS SQL Server in a container on both a Windows host and a Linux host. This is a great introduction to Containers as well as what is possible with SQL Server in a container.

SessionID: 91428

Statewide Geography and Spatial Computing in SQL Server.

Back to calendar

Event Date: 04-05-2019 - Session time: 08:30:00 - Track: Database Maintenance And Performance Tuning

Speaker: Kevin Karns

Title: Statewide Geography and Spatial Computing in SQL Server.

Abstract:

The Geography datatype has been a part of SQL Server since 2008. This session will explore the use of this datatype with 73 million acres of Arizona land and drill into performance troubleshooting related to SQL Server Spatial data. We'll look at applications consuming the data, maintenance plans, Python scripts, traditional and spatial indexes.

SessionID: 91560

SQL Server Management Studio - Beyond the basics

Back to calendar

Event Date: 04-05-2019 - Session time: 08:30:00 - Track: Introductory Data Topics Professional Development

Speaker: Adrian Mee

Title: SQL Server Management Studio - Beyond the basics

Abstract:

Almost all of us use SQL Server Management Studio to interact with SQL Server. But did you know there are so many tricks and shortcuts that hide just under the surface that can make working with SSMS feel like second nature?

In this session, I will demonstrate these features and help you become more efficient at utilizing SSMS to it's fullest potential - a lot of the time without using the mouse. I will also show you how to customize SSMS to suit your needs, and even demonstrate some cool editing tricks that will take your SQL skills to a whole new level.

SessionID: 91651

Open Source vs SQL Database Maintenance Plans

Back to calendar

Event Date: 04-05-2019 - Session time: 08:30:00 - Track: Database Maintenance And Performance Tuning

Speaker: David Lundell

Title: Open Source vs SQL Database Maintenance Plans

Abstract:

The Database Maintenance plans used to be a one size fits all tool that did a lot of unnecessary work, especially, when it came to indexing. So I have been recommending that clients use other tools such as Ola Hallengren’s award winning free SQL Server Maintenance Solution. So let’s have a showdown at high noon in the Arizona desert and see if Database Maintenance Plans in SQL 2016 and 2017 are now good enough or if we still need to turn to other solutions like Ola’s.

SessionID: 92383

Website Analysis Using PowerBI and App Insights: Easier than you think

Back to calendar

Event Date: 04-05-2019 - Session time: 08:30:00 - Track: Data Visualization and Reporting

Speaker: Steve Williams

Title: Website Analysis Using PowerBI and App Insights: Easier than you think

Abstract:

Title: Website Analysis Using PowerBI and App Insights: Easier than you think

Description: Recently, my company decided to turn on application insights. I was tasked with learning the data model, extracting meaningful data, and providing marketing any information that could increase revenue. The query language used in App Insights is SQL-like, and analyzing large amounts of data was easier than I expected. So, if you have an Azure subscription, a web site, and executives telling you that they don't have enough visibility into web metrics, please attend. During this talk after a brief overview of what App Insights does, I will demo how to run basic to intermediate queries against application insights data, and how to include that in a PowerBI report. You will come away with ideas that can be quickly implemented that will make you immensely popular with the upper management. This talk will be appropriate for DBAs and BI Developers alike.

Level: 200 - 300

SessionID: 93406

Accelerating Insights with Azure Databricks

Back to calendar

Event Date: 04-05-2019 - Session time: 08:30:00 - Track: Advanced Analytics

Speaker: Eddie Edgeworth

Title: Accelerating Insights with Azure Databricks

Abstract:

In this session, we will review the Azure Databricks Unified Analytics Platform and introduce best practices for development. When used together they can significantly accelerate your time to Analytic Insights, facilitate collaboration among Data Engineers, Data Analysts, and Data Scientists, and permit everyone on your project to work with any Data, at any Volume, any Velocity. We will cover best practices for data ingestion and movement of data through the zones of the data lake and data warehouse. Then we will show how you can use this platform for Exploratory Data Analysis (EDA) and Advanced Analytics.

SessionID: 89913

Performance Tuning, Getting the Biggest Bang for Your Buck

Back to calendar

Event Date: 04-05-2019 - Session time: 09:45:00 - Track: Database Maintenance And Performance Tuning

Speaker: Monica Rathbun

Title: Performance Tuning, Getting the Biggest Bang for Your Buck

Abstract:

Everyone wants to know if there are magic buttons you can push to make SQL Server run faster, better and more efficiently. In this session we will go over some of my go-to performance tricks that you can implement to get the biggest improvement with the least amount of change. When it comes to performance tuning, every second counts. We will cover memory optimization, isolation levels, trace flags, statistics, configuration changes and more. I’ll go over real life scenarios we come across as consultants and the changes we made to fix them.

SessionID: 90022

Real-World AI in Azure

Back to calendar

Event Date: 04-05-2019 - Session time: 09:45:00 - Track: Advanced Analytics

Speaker: Amie Mason

Title: Real-World AI in Azure

Abstract:

Discover the ways Azure transforms AI and Predictive Analytics making it easier and more accessible through services like Azure Machine Learning and pre-built Cognitive Services, while also supporting custom development and deep-learning. Discussion of real-world scenarios and the tools used to solve them.

SessionID: 90274

Faster Transactions: Query Tuning for Data Manipulation

Back to calendar

Event Date: 04-05-2019 - Session time: 09:45:00 - Track: Database Maintenance And Performance Tuning

Speaker: Jeff Iannucci

Title: Faster Transactions: Query Tuning for Data Manipulation

Abstract:

Your server has dozens of CPUs, terabytes of RAM, and solid-state drives, and yet your UPDATE query still takes hours. Why? In this demo-filled session we will discuss common pitfalls for any SQL professional who is manipulating large sets of data with INSERT, UPDATE, and DELETE statements. Not only will you learn about potential issues involving data pages, locks, and the transaction log, but also what techniques you can use to improve performance.

SessionID: 91280

SQL vs NoSQL: a Comparison of SQL vs MongoDB

Back to calendar

Event Date: 04-05-2019 - Session time: 09:45:00 - Track: Enterprise Database Development, Administration Deployment

Speaker: Eric Peterson

Title: SQL vs NoSQL: a Comparison of SQL vs MongoDB

Abstract:

Have you heard of NoSQL, but aren't really sure what it is? Are you wondering if you're missing out on something that could satisfy that complex data model problem you haven't found a good solution for?

We'll learn about the flavors of NoSql and then dig down into MongoDB, the NoSQL database that drives many websites. Then we'll get an overview of JavaScript Object Notation (JSON) along with how and why it's used in NoSQL, focusing on its advantages and disadvantages.

You'll see how the SQL table structure compares to the NoSQL data structure. After that, we'll look at examples of storing the same data in both systems and how that data flows to the web page.

We'll discuss the factors that drive your choice of database along with the trade-offs involved. Then we'll wrap up by taking a look at Microsoft's on-premises and cloud efforts in the MongoDB NoSQL space.

SessionID: 91470

Advanced Power BI Modeling Techniques

Back to calendar

Event Date: 04-05-2019 - Session time: 09:45:00 - Track: Data Visualization and Reporting

Speaker: Martin Schoombee

Title: Advanced Power BI Modeling Techniques

Abstract:

Creating a Power BI data model is pretty easy, but sometimes we have to deal with more complex scenarios the require us to dig a little deeper.

In this session we'll take your modeling skills to the next level as we explore a few advanced techniques that deal with displaying measures in the rows of a table (as opposed to the columns), dynamic currency conversions and an alternate approach to role-playing dimensions.

SessionID: 93332

SSAS Tabular Models 101: Make a big difference in a small space

Back to calendar

Event Date: 04-05-2019 - Session time: 09:45:00 - Track: Introductory Data Topics Professional Development

Speaker: Delora Bradish

Title: SSAS Tabular Models 101: Make a big difference in a small space

Abstract:

Learn about key tabular model features: date calculations options, many to many relationships, nested grouping, role playing, conditional formatting, granularity differences, direct query, and DAX functions. We'll be looking at the role of Microsoft's semantic layer in Azure Data Architectures, and how to make a big impact on reporting and analytics. If you are transitioning from multiD, I'll join you in a moment of silence, but then let's conquer this tabular model concept and make it work for your business.

SessionID: 93464

Devops for Data Science

Back to calendar

Event Date: 04-05-2019 - Session time: 09:45:00 - Track: Advanced Analytics

Speaker: David Bess

Title: Devops for Data Science

Abstract:

In this presentation we will examine practices that combine and automate the processes between data science and IT teams, in order that they can build, test, and release models faster and more reliably. We will examine the Data Science Devops technology landscape, and demonstrate how Kubeflow can be used to achieve end to end Devops for Data Science.

SessionID: 89909

The Power of Data: The Complete Beginners Data Warehouse Kit

Back to calendar

Event Date: 04-05-2019 - Session time: 11:00:00 - Track: BI ETL 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: 90260

Practical Power BI Report Design Tips for the Non-Artist

Back to calendar

Event Date: 04-05-2019 - Session time: 11:00:00 - Track: Data Visualization and Reporting

Speaker: Meagan Longoria

Title: Practical Power BI Report Design Tips for the Non-Artist

Abstract:

You don't have to be super artistic to make professional looking Power BI reports. We'll walk through several design concepts borrowed from web design and cognitive psychology and then apply them to a Power BI report. You'll learn practical steps to enhance your reports that you can do today, even if you don't consider yourself artistic.

SessionID: 90619

Azure Data Factory Version 2 - Templates and new features

Back to calendar

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

Speaker: Joseph Barth

Title: Azure Data Factory Version 2 - Templates and new features

Abstract:

Azure Data Factory version 2 continues to grow and have new features. Today we will walk through Templates , a new feature that focuses on re usability of your pipelines,data sets and other ADF objects. Focus on the new Template Gallery has a lot of good examples. We will focus on showing why we would use each example and what else we have found in the use of ADF, whether it be pulling your data from on premise to the cloud or from cloud to cloud. Today's session will help you understand what you can and can't do for your next Cloud Data implementation.

SessionID: 90663

I have to support what!? SQL, Oracle, and Mongo - A side by side “how to”

Back to calendar

Event Date: 04-05-2019 - Session time: 11:00:00 - Track: Enterprise Database Development, Administration Deployment

Speaker: Kimberly StJacques

Title: I have to support what!? SQL, Oracle, and Mongo - A side by side “how to”

Abstract:

More and more companies are starting to invest in multiple database platforms and DBAs are needing to develop a skillset to support a mixed-database environment. Database concepts are often the same between platforms, however, the “how” can be very different (and sometimes not different at all!). Starting with the basics and gradually moving into the more advanced; this session will show you how to perform the same task in SQL Server, Oracle, and Mongo. Take a leap and start your journey in to the multi-platform world!

SessionID: 90785

Introduction to Execution Plans

Back to calendar

Event Date: 04-05-2019 - Session time: 11:00:00 - Track: Enterprise Database Development, Administration Deployment

Speaker: Sean Brown

Title: Introduction to Execution Plans

Abstract:

This session will cover the following topics:

1. Walk through the steps SQL Server takes when executing a query
2. How to generate and read an execution plan
3. How to troubleshoot a query using the execution plan

Session content assumes an ability to do basic queries against a database.

SessionID: 91566

From Zero to Hero: Start Machine Learning using Azure ML studio

Back to calendar

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

Speaker: Mohamed Mawla

Title: From Zero to Hero: Start Machine Learning using Azure ML studio

Abstract:

The session aim is to get people excited and curious more about ML without digging in coding or deep concepts.

We will explore ML Azure offering, Some ML concepts, ML Studio, create an experiment from Scratch and show how ML can target common business challenges like demand projection or price targeting

Lots of hands-on

SessionID: 91648

No Pane, No Gain: A Beginner's Guide to Window Functions

Back to calendar

Event Date: 04-05-2019 - Session time: 11:00:00 - Track: Advanced Analytics

Speaker: Phil Guevara

Title: No Pane, No Gain: A Beginner's Guide to Window Functions

Abstract:

Increase your T-SQL skills by familiarizing yourself with Window Functions. Learn to write these functions from the ground up and recognize common analytical scenarios where these functions come in handy.

SessionID: 93731

Professional Development Lunch Session with Paychex

Back to calendar

Event Date: 04-05-2019 - Session time: 12:00:00 - Track: Introductory Data Topics Professional Development

Speaker: Kimberly StJacques

Title: Professional Development Lunch Session with Paychex

Abstract:

Please come join Paychex for an overview of Paychex, our history, stats, culture and values. We will also be providing some information on our total rewards and career opportunities. There will also be a couple of Amazon gifts cards raffled during this lunch session (Must be present to win). We look forward to connecting with you!”

SessionID: 93774

Introduction to Snowflake, the data warehouse build for the cloud

Back to calendar

Event Date: 04-05-2019 - Session time: 12:00:00 - Track: Advanced Analytics

Speaker: Ginger Grant

Title: Introduction to Snowflake, the data warehouse build for the cloud

Abstract:

This lunch session will introduce you to a very fast way to manage and infinitely scale your data in the cloud

SessionID: 90258

Do Your Data Visualizations Need A Makeover?

Back to calendar

Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Data Visualization and Reporting

Speaker: Meagan Longoria

Title: Do Your Data Visualizations Need A Makeover?

Abstract:

Do you ever look at your data visualizations and feel that they are lackluster? Have you made a report using the latest chart types, but you still can’t gain adoption from your target audience? Lots of people feel this way, but they can’t quite identify what should be changed or how to change it. This session will help you identify signs that it’s time to give your data visualizations a makeover and provide practical tips for improving your reports and dashboards. We’ll discuss how simple changes in design choices related to color, chart types, chart formatting, and report layout can make a big difference in creating clear and engaging visualizations with common analysis tools like Power BI and Excel.

SessionID: 90277

Temporal Tables – The New Hotness in Data Auditing

Back to calendar

Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Enterprise Database Development, Administration Deployment

Speaker: John Morehouse

Title: Temporal Tables – The New Hotness in Data Auditing

Abstract:

A common issue database administrators face is data auditing. Many use triggers, CDC, third-party tools, or roll their own type of auditing tool. In SQL Server 2016, a new feature called Temporal Tables was introduced and helps to simplify this common need. In this session, we will take a look at what temporal tables are, how they work and how you can implement them into your environment.

SessionID: 90327

T-SQL Habits and Practices That Can Kill Performance

Back to calendar

Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Database Maintenance And Performance Tuning

Speaker: Vern Rabe

Title: T-SQL Habits and Practices That Can Kill Performance

Abstract:

All too often we are on a project or given a task where the time or financial constraints require us to develop T-SQL “quick-and-dirty”. Or maybe we have been tasked with quickly improving the performance of some existing T-SQL. These situations often lead to code that later needs to be tuned for better performance. Wouldn’t it be nice if we could satisfy those tight time constraints while also avoiding many of the pitfalls that later plague performance?

In this session we will see ten common T-SQL writing habits that contribute to poor performance. We’ll see WHY each of these patterns can have such negative impact on performance, including examples, and we’ll see one or more alternatives for each that don’t have the same negative impact. Armed with this knowledge, you will definitely impress your boss with your ability to create fast T-SQL within tight time constraints, and also quickly fix existing T-SQL code. Enjoy the merit raise you’ll get due to your new tuning talents.

SessionID: 90713

Real-World PowerShell for SQL Administration

Back to calendar

Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Enterprise Database Development, Administration Deployment

Speaker: Brian Hansen

Title: Real-World PowerShell for SQL Administration

Abstract:

If you're like me, you've attended PowerShell sessions before. However, much of the practical usage of PS comes with rolling back your sleeves and digging into the nuances of syntax and how to get things done.

In this session, I'm assuming that you know the basics of PowerShell. What we're going to cover are some of the "gotchas" and nuances that I've run into when I've been working with the language, and particularly with SQL's flavor of PowerShell.

And then we'll spend the bulk of our time looking at real-world, practical scripts that I use pretty much every day. PowerShell is an awesome way to automate so many processes and relieve some of the everyday monotony of SQL administration.

SessionID: 91331

Azure Data Factory V2: SSIS in the Cloud or not?

Back to calendar

Event Date: 04-05-2019 - Session time: 13:00:00 - Track: BI ETL Architecture, Development Administration

Speaker: Andrea Letourneau

Title: Azure Data Factory V2: SSIS in the Cloud or not?

Abstract:

Azure Data Factory V2 is an Azure a Platform-as-a-Service with many SSIS-like features, but is it good enough to replace SSIS? In this session we will review some of the ETL and ELT features in Azure Data Factory, discuss design patterns for ADF pipelines, review useful activities in ADF and see how closely it compares to SSIS.

SessionID: 93307

SELECT Start FROM Here: Querying for T-SQL Beginners

Back to calendar

Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Introductory Data Topics Professional Development

Speaker: Jeff Iannucci

Title: SELECT Start FROM Here: Querying for T-SQL Beginners

Abstract:

Have you been asked to begin querying data in SQL Server databases? Or are you just curious to try T-SQL? Great – let’s get started! In this session we’ll cover the basics of the SELECT statement, your T-SQL tool for getting that data. We’ll also show the individual parts of a query, discuss basic aggregation, and demonstrate common filtering options like parameters and functions. You’ll walk away with a solid foundation, ready to start your journey to become a T-SQL expert.

SessionID: 93407

Data Virtualization unlocking data and enabling analytics using Denodo, Azure and Microsoft BI Stack

Back to calendar

Event Date: 04-05-2019 - Session time: 13:00:00 - Track: Advanced Analytics

Speaker: Cristian Vasconez

Title: Data Virtualization unlocking data and enabling analytics using Denodo, Azure and Microsoft BI Stack

Abstract:

Data Virtualization is becoming a key part of any data platform architecture that is built to enable users to unlock data insights. With so many tools available in the market it is important to understand the main goal of Data Virtualization. In this session, we will use one of the leading tools in the market (Denodo) to showcase how data virtualization empowers users to build Power-BI dashboards combining multiple on premise and cloud sources.

SessionID: 89914

I'm It - Survival Techniques for the Lone DBA

Back to calendar

Event Date: 04-05-2019 - Session time: 14:15:00 - Track: Introductory Data Topics Professional Development

Speaker: Monica Rathbun

Title: I'm It - Survival Techniques for the Lone DBA

Abstract:

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We'll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you'll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.

SessionID: 90013

Managing ETL Change using BIMLScript

Back to calendar

Event Date: 04-05-2019 - Session time: 14:15:00 - Track: BI ETL Architecture, Development Administration

Speaker: Russel Loski

Title: Managing ETL Change using BIMLScript

Abstract:

You develop an SSIS package to load a flat file. You meticulously identify each of the columns and map the columns to the target table. Your package runs fine for months. Then the file format changes. It is back to the drawing board, selecting each column, setting the data types (type, length, etc.). In many cases, you actually have the file structure in an electronic form. Wouldn't it be nice to simply regenerate your SSIS package using that metadata?

In this session I will demonstrate how to automate the generation of SSIS packages using the open source BIML and BIMLScript.

I will then demonstrate how to use this technique to handle changes in file structure. I will generate an SSIS package from a simple Excel workbook I will represent the structure of a flat file and its relationship to a staging table.

Finally, I will use BIMLScript to handle changes from one version of SSIS to the next and from SSIS to Azure data factory.

SessionID: 90648

Power BI Desktop Tips and Best Practices for Projects and Data Preparation

Back to calendar

Event Date: 04-05-2019 - Session time: 14:15:00 - Track: Introductory Data Topics Professional Development

Speaker: Phil Robinson

Title: Power BI Desktop Tips and Best Practices for Projects and Data Preparation

Abstract:

In this session we will explore Power BI Desktop configuration settings, Cross-industry process for data mining (CRISP-DM) based project strategies and related community resources. Simple team sharing ideas and tips for data exploration/cleanup will also be covered.

SessionID: 90707

Get Your Optimizer to Give up All Its Secrets

Back to calendar

Event Date: 04-05-2019 - Session time: 14:15:00 - Track: Database Maintenance And Performance Tuning

Speaker: Brian Hansen

Title: Get Your Optimizer to Give up All Its Secrets

Abstract:

You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated? In this session, we will examine details the query optimization process that are not very well known. We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient. Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos? We'll do just that, and then take it a step further with a unique visualization tool that I have created. With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.

SessionID: 90930

SQL DevOps Simplified with Production Databases

Back to calendar

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

Speaker: Paul Stanton

Title: SQL DevOps Simplified with Production Databases

Abstract:

DevOps is based on building an application binary (immutable artifact) that supports a highly reliable, repeatable engineering process. In the case of SQL Server, however, a database is already in production, and isn’t simply replaced (as an app binary), but is upgraded. Current SQL Server DevOps methods use source control to build a “development” database, with schema and objects and static data needed for functional testing. "Near production data" is used in Staging, and finally production is upgraded. This approach involves complexity, and breaks the principle of working with immutable artifacts throughout the process. Our session introduces a new approach to SQL Server DevOps, with production databases used in all stages. Production database clones are delivered more quickly than "built" databases, are more easily integrated with source control, and produces higher fidelity outcomes. Learn how leading enterprises are simplifying SQL DevOps.

SessionID: 91332

Put More Power into Power BI

Back to calendar

Event Date: 04-05-2019 - Session time: 14:15:00 - Track: Data Visualization and Reporting

Speaker: Andrea Letourneau

Title: Put More Power into Power BI

Abstract:

Power BI is constantly evolving - every month new features are added which can enhance your report user experience. Be the first to learn the secrets to leveraging newer features like bookmarks and object selection to transform your Power BI Report from an ordinary report to an extraordinary application.

SessionID: 93322

SQL Antipatterns

Back to calendar

Event Date: 04-05-2019 - Session time: 14:15:00 - Track: Enterprise Database Development, Administration Deployment

Speaker: JT Moree

Title: SQL Antipatterns

Abstract:

In his book "SQL Antipatterns", Bill Karwin says, "An antipattern is a technique that is intended to solve a problem but that often leads to other problems." JT will explore a few of the SQL pitfalls detailed in Karwin's excellent book. Attendees will see how to identify the patterns, refactor them away, or learn to live with them.

Speaker: JT Moree, System Architect, DBA, PMP

SessionID: 93417

Databricks and End-to-End Processes

Back to calendar

Event Date: 04-05-2019 - Session time: 14:15:00 - Track: Introductory Data Topics Professional Development

Speaker: Alexander Brown

Title: Databricks and End-to-End Processes

Abstract:

Using Databricks to develop and streamline an end-to-end process. Taking data from a raw discovery level, transforming and exploring the data to a dashboard to deliver clean and clear insights across all areas of data exploration and configuration.

SessionID: 90021

Keys to Successfully Governing Power BI for your Organization

Back to calendar

Event Date: 04-05-2019 - Session time: 15:30:00 - Track: BI ETL Architecture, Development Administration

Speaker: Amie Mason

Title: Keys to Successfully Governing Power BI for your Organization

Abstract:

Discussion of the best practices and considerations for security, governance, and administration of Power BI. Not only of the available options, but tips and tricks for how to navigate those options and set yourself and your organization up for success down the road.

SessionID: 90568

3 Keys to Successful Consulting

Back to calendar

Event Date: 04-05-2019 - Session time: 15:30:00 - Track: Introductory Data Topics Professional Development

Speaker: Mohammad Darab

Title: 3 Keys to Successful Consulting

Abstract:

Interested in becoming a consultant? Think it's too overwhelming? Want to be your own boss? Wish to expand your clientele? 

The hardest thing about being your own boss is getting in the right mindset and to truly understand that your past doesn’t equal your future.

In this 60 minute session, I cover 3 keys to being a successful consultant. I share techniques used to help others get in the right mindset and tackle the mental blocks to achieving success in their entrepreneurial pursuits.

Whether you are interested in starting your own business, or a consultant wanting to expand your clientele, this session will position you for future success as an entrepreneur.

SessionID: 90647

Data Wrangling for Reporting Analytics using Power BI

Back to calendar

Event Date: 04-05-2019 - Session time: 15:30:00 - Track: Introductory Data Topics Professional Development

Speaker: Phil Robinson

Title: Data Wrangling for Reporting Analytics using Power BI

Abstract:

In today’s world reporting and analytics are no longer focused exclusively on internal data from transactional systems and the data warehouse.

Mashups using data from partners, commercial and public sources are fast becoming the new normal. Do you have a csv file too big to open, is a non-windows format or generates errors on import or opening? Need to determine the quality of a file downloaded from the internet or supplied by another party? In this presentation we will review tools to examine/repair schema issues and explore Power BI Desktop features that provide insights into your datasets along with the M language for building mashups and data models.

SessionID: 90680

Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Back to calendar

Event Date: 04-05-2019 - Session time: 15:30:00 - Track: Enterprise Database Development, Administration Deployment

Speaker: Deji Akomolafe

Title: Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Abstract:

Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. quot;Virtualize Firstquot; is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too quot;criticalquot; to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring i

SessionID: 91157

Environmental SQL Server Troubleshooting

Back to calendar

Event Date: 04-05-2019 - Session time: 15:30:00 - Track: Enterprise Database Development, Administration Deployment

Speaker: Jeff Mlakar

Title: Environmental SQL Server Troubleshooting

Abstract:

When called in to diagnose a performance issue what are the 1st things you review? Many DBAs and developers make the mistake of diving straight into the code looking for an answer. However, often times the solution is not in the code but rather in the overall environment. Environmental troubleshooting is often a quick and overlooked method for discovering and configuring SQL Server to perform at a higher level without the need for application change controls.

In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!

SessionID: 91507

Creating Real Solutions with Power Tools Power BI, Apps and Flow

Back to calendar

Event Date: 04-05-2019 - Session time: 15:30:00 - Track: Introductory Data Topics Professional Development

Speaker: Yaseen Jamaludeen

Title: Creating Real Solutions with Power Tools Power BI, Apps and Flow

Abstract:

At one of the non-profits (PCs for Refugees) I volunteer, we provide refugees with computers to help them learn English and other school subjects like Math, Science, etc. along with typical usage like ticket booking, navigation, communication, entertainment, etc.

In this session, I'll try to explain the benefits of Microsoft for Nonprofits sponsorship and how any cost-effective organization can use MS Forms (or such), Power BI, PowerApps and MS Flow to not only build a full-fledged solution but also how easy and cost-efficient it is to implement, maintain and expand it as necessary.

We will go over the implementation of a typical case management system which receives requests; visualize and plan logistics; take it through stages using mobile/web platforms; and keep everyone involved to be fully integrated and informed throughout the life-cycle of the request. We'll also touch upon the insights we used to shape up and optimize the delivery and effectiveness of the empowerment effo

SessionID: 91654

Azure AD authentication methods for SQL Azure

Back to calendar

Event Date: 04-05-2019 - Session time: 15:30:00 - Track: Cloud Application Development Deployment

Speaker: David Lundell

Title: Azure AD authentication methods for SQL Azure

Abstract:

Deploying to SQL Azure? What are the best ways to login/authenticate to SQL Azure? Learn about Azure AD Authentication methods: Integrated Windows authentication, Azure AD principal name and a password, Application token authentication, and additional Azure Active Directory methods Integrated, Universal with MFA, and Interactive

SessionID: 93408

Deploying ML Models w/ Tableau

Back to calendar

Event Date: 04-05-2019 - Session time: 15:30:00 - Track: Advanced Analytics

Speaker: Yueying Li

Title: Deploying ML Models w/ Tableau

Abstract:

In this session, I will take a use case to walk you through the process of training machine learning models in R and deploying the R models using Tableau, not as a traditional dashboard, but as an application that takes users’ input, calls R engine, and returns model predictions back to users.

This site is open source. Improve this page.