sqlsathistory

Nr: 698

SQLSaturday #698 - Nashville 2018

Start Time (24h)	Speaker	Track	Title
08:30:00	Anthony Nocentino	Database Administration	Networking Internals for the SQL Server Professional
08:30:00	Daniel Glenn	BI Architecture Management	Using Your On-prem Data in a Cloud World
08:30:00	Arthur Daniels III	Database Application Development	Reading Execution Plans Successfully
08:30:00	Aaron Nelson	BI Analytics and Visualization	PowerShell for BI Professionals: Automating SSIS, SSRS SSAS
08:30:00	Phil Ekins	Database Administration	SQL Sprawl - How to get a handle on your Infrastructure
08:30:00	Geoff Hiten	Cloud Database/Application Development Deployment	ARMed for Azure
08:30:00	Je'Anna Lanza-Abbott	Professional Development	Performance Tuning for Salary Negotiations
08:30:00	Rie Irish	Database Administration	How to Build Your Disaster Recovery Plan
08:30:00	Luke Campbell	PowerShell	Automate your SQL Server installs and configurations using Powershell Desired State Configuration
08:30:00	SQLSaturday Nashville	Other	On-Site Registration non-printed SPEEDPASS
08:30:00	John Deardurff	Cloud Database/Application Development Deployment	Cloudy with a Chance of Data
08:30:00	Kathi Kellenberger	BI Analytics and Visualization	Azure Machine Learning 101
09:45:00	Jamey Johnston	BI Analytics and Visualization	Code Like a Snake Charmer - Intro to Python!
09:45:00	Matt Gordon	Cloud Database/Application Development Deployment	Where Should My Data Live (and Why)?
09:45:00	Kellyn Pot'Vin-Gorman	Database Administration	DevOps for the DBA
09:45:00	John Sterrett	Database Administration	Successfully Migrating Existing Databases to Azure SQL Database
09:45:00	Janis Griffin	Database Administration	HiHo! HiHo! SQL Server on Linux, We Go!
09:45:00	Jon Boulineau	BI Architecture Management	ETL Architecture for Real-Time BI
09:45:00	Jason Horner	BI Architecture Management	Dimensional Modeling Design Patterns: Beyond the Basics
09:45:00	Mike Lawell	Cloud Database/Application Development Deployment	Cosmos DB: Planet Earth Scale
09:45:00	Andy Yun	Professional Development	Everyone Has a Story to Tell: Developing Your First Presentation
09:45:00	Rowland Gosling	Cloud Database/Application Development Deployment	SQL Server Meets Big Data in the Cloud: Weather Edition
09:45:00	John Morehouse	Database Administration	Only You Can Prevent Database Fires!
11:00:00	Louis Davidson	Database Application Development	How to Implement a Hierarchy in SQL Server
11:00:00	Karen Nelson	Professional Development	Why am I able to master several technology languages but I struggle in my own business language?
11:00:00	Mike Robbins	PowerShell	Writing award winning PowerShell functions and script modules
11:00:00	Jim Donahoe	Cloud Database/Application Development Deployment	Getting started with SQL Azure Database: What you need to know
11:00:00	Chris Hyde	BI Analytics and Visualization	Python in SQL Server 2017
11:00:00	Kevin Kline	Database Administration	End-to-End Troubleshooting Checklist for SQL Server
11:00:00	Tim Gorman	Cloud Database/Application Development Deployment	Reducing The Surface Area Of Risk in Data Security
11:00:00	Lance Tidwell	Database Administration	Parameter Sniffing the Good, the Bad and the Ugly
11:00:00	Dan Evans	BI Architecture Management	Power BI administration made easy(ier)
11:00:00	Ben Miller	Database Administration	SQL Server Encryption
11:00:00	Gareth Swanepoel	Cloud Database/Application Development Deployment	Azure SQL DW Performance Common Issues
12:20:00	Dave Mattingly	Cloud Database/Application Development Deployment	Alexa, Talk to Me
12:20:00	Josh Luedeman	Cloud Database/Application Development Deployment	Cloud Panel
12:20:00	Rodrigo Medeiros	Database Administration	Optimizing SQL Server Instances You Don't Control
12:20:00	SQLSaturday Nashville	Database Administration	SQL Server Remote Management Best Practices
12:20:00	Kevin Kline	Database Application Development	Top Tools for Tuning SQL: Focus on Plan Explorer
13:30:00	Kevin Feasel	BI Analytics and Visualization	Data Cleansing With SQL And R
13:30:00	David Maxwell	Database Application Development	Working with Temporal Data in SQL Server
13:30:00	Tim Warner	Database Administration	SaaS/IaaS Compromise - Learning Azure SQL Database Managed Instance
13:30:00	Tracy Boggiano	Database Administration	Query Store Primer
13:30:00	Wendy Pastrick	Database Application Development	Why NULL is not a value (and other SQL gotchas)
13:30:00	Amy Herold	PowerShell	Hi, my name is Powershell, let's be friends! An Intro to PoSH
13:30:00	Angela Tidwell	Professional Development	Becoming the MVP: Soft Skills for the Hard Market
13:30:00	Rob Volk	Database Application Development	Tame Your Unruly Data With Constraints
13:30:00	Henry Treftz	Database Administration	Why Third Party Vendors Do The Things They Do
13:30:00	Josh Luedeman	Cloud Database/Application Development Deployment	Migrating your BI Platform to Azure
13:30:00	Jonathan Stewart	BI Analytics and Visualization	Data Visualization: How to truly tell a great story!
14:50:00	Kevin Wilkie	BI Analytics and Visualization	What could be better than football and R!
14:50:00	Spencer Swindell	BI Architecture Management	Applying Data Warehousing Principles: Going from Descriptive to Predictive
14:50:00	Ed Watson	BI Analytics and Visualization	A Beginner's Guide to Power BI
14:50:00	Elizabeth Noble	Database Application Development	Making Your List and Checking It Twice: Introduction to unit testing with tSQLt
14:50:00	Pat Phelan	Professional Development	Ethics, Morals, and Laws for the DBA 101
14:50:00	Bob Pusateri	Database Administration	Minimizing User Impact with Advanced Restore Methods
14:50:00	Lowry Kozlowski	Database Administration	SQL Server Take Over: Establishing a Baseline
14:50:00	Hope Foley	Cloud Database/Application Development Deployment	AI to the Masses! But How? Pixie Dust?
14:50:00	Cathrine Wilhelmsen	BI Architecture Management	Biml for Beginners: Speed Up Your SSIS Development
14:50:00	Michael Fal	PowerShell	Exploring the new SqlServer PowerShell module
14:50:00	Bradley Ball	Cloud Database/Application Development Deployment	Twitter Data Sentiment Analysis: Staring Logic Apps, Azure ML, Twitter Data, Power BI, and Python

SessionID: 69379

Networking Internals for the SQL Server Professional

Back to calendar

Event Date: 13-01-2018 - Session time: 08:30:00 - Track: Database Administration

Speaker: Anthony Nocentino

Title: Networking Internals for the SQL Server Professional

Abstract:

Once data leaves your SQL Server do you know what happens or is the world of networking a black box to you? Would you like to know how data is packaged up and transmitted to other systems and what to do when things go wrong? Are you tired of being frustrated with the network team? In this session we introduce how data moves between systems on networks and TCP/IP internals. We’ll discuss real world scenarios showing you how your network’s performance impacts the performance of your SQL Server and even your recovery objectives.

SessionID: 69976

Using Your On-prem Data in a Cloud World

Back to calendar

Event Date: 13-01-2018 - Session time: 08:30:00 - Track: BI Architecture Management

Speaker: Daniel Glenn

Title: Using Your On-prem Data in a Cloud World

Abstract:

Microsoft Power BI, Flow, and PowerApps are powerful cloud tools that can take your on-premises data to new heights. Using your data where it is now gives you the ability to invest in improving processes, instead of focusing on a data migration strategy.

In this session, we will discover the benefits of using the cloud tools, how those benefits translate to being on-prem, and how we can use the data in Office 365 as well. We will setup a data gateway, connect to on-prem data sources, and use that data in Office 365 and SharePoint Server 2016.

SessionID: 70107

Reading Execution Plans Successfully

Back to calendar

Event Date: 13-01-2018 - Session time: 08:30:00 - Track: Database Application Development

Speaker: Arthur Daniels III

Title: Reading Execution Plans Successfully

Abstract:

If you've seen an execution plan but didn't know how to read it, this session is for you.

The goal of this session to learn how SQL Server is interpreting your query into an execution plan. We'll discuss execution plan internals, how SQL Server estimates the cost of your query, and what a graphical execution plan is displaying through its operators.

Learning to read an execution plan is a great way to begin troubleshooting performance. At the end, we will take a look at how SQL Server 2016 provides more tools for exploring execution plans.

SessionID: 70196

PowerShell for BI Professionals: Automating SSIS, SSRS SSAS

Back to calendar

Event Date: 13-01-2018 - Session time: 08:30:00 - Track: BI Analytics and Visualization

Speaker: Aaron Nelson

Title: PowerShell for BI Professionals: Automating SSIS, SSRS SSAS

Abstract:

PowerShell has allowed DBAs to manage huge numbers of SQL servers, all automatically. Now BI practitioners can reap the same benefits of scale and automation. Scenarios that are normally extremely time consuming can be done quickly, all with a few lines of PowerShell.

This session will be filled with demos based on real-life scenarios and use-cases. We will demonstrate how to scale and automate your BI solutions, with a minimum of effort. In particular, we will be covering PowerShell cmdlets their integrations with SSRS, SSIS, SSAS.

By the end of the session, you'll be able to accomplish in minutes what would normally take hours or days. You’ll know ways to quickly deploy hundreds of SSRS objects to multiple servers; or instantly identify and process stale SSAS dimensions. Additionally, you will also be able to take care of some pesky ETL tasks, some by automating SSIS, and others using just plain old PowerShell.

SessionID: 70487

SQL Sprawl - How to get a handle on your Infrastructure

Back to calendar

Event Date: 13-01-2018 - Session time: 08:30:00 - Track: Database Administration

Speaker: Phil Ekins

Title: SQL Sprawl - How to get a handle on your Infrastructure

Abstract:

This Session will give you the tools to assess your existing SQL Deployments, physical or virtual.

Determine what’s being installed without (or without) your knowledge.
How are they being utilized resource wise and how are they licensed. Then determine what can be combined, right sized or retired and does your existing licensing make sense. This will provide a road-map to make a case for virtualization (if you’re not there yet) or just to get a handle on your SQL Sprawl.

SessionID: 70604

ARMed for Azure

Back to calendar

Event Date: 13-01-2018 - Session time: 08:30:00 - Track: Cloud Database/Application Development Deployment

Speaker: Geoff Hiten

Title: ARMed for Azure

Abstract:

The Azure Resource Model (ARM) enables Azure infrastructure automation for both IaaS and PaaS deployments. Using Visual Studio as a management tool enables repeatable, automated, source controlled deployments for test and development environments, enabling true DevOps practices for all aspects of pre-production systems. In this session, I will demonstrate, explain, and deploy a IaaS/PaaS hybrid environment (SQL and BI stack elements) using ARM templates, Visual Studio, source control integration, and PowerShell scripts.

SessionID: 70654

Performance Tuning for Salary Negotiations

Back to calendar

Event Date: 13-01-2018 - Session time: 08:30:00 - Track: Professional Development

Speaker: Je'Anna Lanza-Abbott

Title: Performance Tuning for Salary Negotiations

Abstract:

Because little in business or life gets done without negotiation, this session has the potential to deliver significant upside in your professional and personal outcomes. In this session, you will be introduced to basic negotiation concepts and tactics, followed by a focus on important aspects of the negotiation process—obstacles to effective communication at the bargaining table, the maximization of multiple interests, and preparation tactics for your next negotiation. We will put it all together by examining a special type of negotiation: YOUR SALARY!

Participants will:

• Learn strategies for negotiation analysis and preparation • Understand different strategic choices and interpersonal skills necessary for success • Know what information is needed to negotiate effective outcomes • Experiment with new techniques and test their effectiveness in a safe environment

SessionID: 70656

How to Build Your Disaster Recovery Plan

Back to calendar

Event Date: 13-01-2018 - Session time: 08:30:00 - Track: Database Administration

Speaker: Rie Irish

Title: How to Build Your Disaster Recovery Plan

Abstract:

So your boss asked for a copy of your DR plan. Once you've wiped that deer-in-the-headlights look off your face, you realize "We've got database backups," isn't exactly a plan. You need to come up with a plan to recover your business when disaster strikes. This session will help you build this plan by defining what a disaster could be, documenting the business impact, and identifying your limitations. We will show how to use this information to establish metrics (such as RTO and RPO), document current recovery configurations, and design an effective recovery strategy that meets the needs and budget of your business. Attending this session will give you the knowledge and tools to create an effective disaster recovery plan that will make your boss happy and ensure the continuity of your business.

SessionID: 70672

Automate your SQL Server installs and configurations using Powershell Desired State Configuration

Back to calendar

Event Date: 13-01-2018 - Session time: 08:30:00 - Track: PowerShell

Speaker: Luke Campbell

Title: Automate your SQL Server installs and configurations using Powershell Desired State Configuration

Abstract:

Database administrators are being tasked with managing a large number of SQL Server instances. These instances can be built on premise, virtualized, physical, or in the cloud. With Powershell Desired State Configuration, DBAs can not only automate the installation of SQL Server, but also any specific configurations needing to be applied to each new instance. Powershell DSC provides a repeatable process to ensure all builds are done in the exact same way. We'll cover what is Powershell Desired State Configuration and how a DBA can take advantage of it. Next, we'll dive straight into a demo of the installation and configuration of two SQL Server instances from scratch.

Some powershell experience is recommended.

SessionID: 71795

On-Site Registration non-printed SPEEDPASS

Back to calendar

Event Date: 13-01-2018 - Session time: 08:30:00 - Track: Other

Speaker: SQLSaturday Nashville

Title: On-Site Registration non-printed SPEEDPASS

Abstract:

This room will be used for printing SPEEDPASS, cutting SPEEDPASSES and any other registration issues. This room will be ready when registration opens at 8 am.

SessionID: 71796

Cloudy with a Chance of Data

Back to calendar

Event Date: 13-01-2018 - Session time: 08:30:00 - Track: Cloud Database/Application Development Deployment

Speaker: John Deardurff

Title: Cloudy with a Chance of Data

Abstract:

This course is intended as an Introductory look at the Cloud and Azure Data Services. We begin our session explaining what the cloud is and the differences between Infrastructure as a Service (IaaS), Platform as a Service (PaaS), and Software as a Service (SaaS). Then we turn our attention to Azure and the Microsoft Cloud Data Platform to see what solutions are available for Data Archtitects, Developers, and Administrators. Finally, we close the session with a tour of SQL Server in an Azure Virtual Machine as well as an Azure SQL Database.

SessionID: 72038

Azure Machine Learning 101

Back to calendar

Event Date: 13-01-2018 - Session time: 08:30:00 - Track: BI Analytics and Visualization

Speaker: Kathi Kellenberger

Title: Azure Machine Learning 101

Abstract:

You have probably heard the buzz about Azure Machine Learning, aka Azure ML, over the past few years. It is a surprisingly easy to use predictive analytic tool that you can learn for free. Attend this session to learn how to get started with Azure ML.

SessionID: 69357

Code Like a Snake Charmer - Intro to Python!

Back to calendar

Event Date: 13-01-2018 - Session time: 09:45:00 - Track: BI Analytics and Visualization

Speaker: Jamey Johnston

Title: Code Like a Snake Charmer - Intro to Python!

Abstract:

Python is the one of the most popular programming languages used today and one of the most useful tools in the data scientist's tool belt especially for machine learning. Python is integrated into the Microsoft stack in tools like Azure ML and now SQL Server 2017.

The session will be an introduction to the Python language including:

1.) Installing and Configuring Python 2.) Access and Manipulate Data 3.) Install and Manage Packages 4.) Create and Use Objects/Variables 5.) Control Flows and Functions 6.) Managing the Python installation in MSSQL

Attend this session to learn how to use Python to take your data analytics to the next level. We will use Python, SQL Server and the Anaconda distribution of Python to learn the basics of Python and how it is integrated in the Microsoft stack! We will walk through a simple deployment of a machine learning model to see how it all works together and learns some basic data science fundamentals.

No prior statistics knowledge needed.

SessionID: 69360

Where Should My Data Live (and Why)?

Back to calendar

Event Date: 13-01-2018 - Session time: 09:45:00 - Track: Cloud Database/Application Development Deployment

Speaker: Matt Gordon

Title: Where Should My Data Live (and Why)?

Abstract:

Long gone are the days where the only architecture decision you had to make when scaling an environment was deciding which part of the datacenter would store your new server. There is a dizzying array of options available in the SQL Server and Azure ecosystems and those are evolving by the day. Is “the cloud” a fad? Are private datacenters a thing of the past? Could both questions have a kernel of truth in them? In this session I will go over real world scenarios and walk you through real world solutions that utilize your datacenter, cloud providers, and everything in between to keep your data highly available and your customers happy.

SessionID: 69386

DevOps for the DBA

Back to calendar

Event Date: 13-01-2018 - Session time: 09:45:00 - Track: Database Administration

Speaker: Kellyn Pot'Vin-Gorman

Title: DevOps for the DBA

Abstract:

DevOps came out of the Agile movement and the idea that operations needed to be part of the solution for agile development to be successful. The DBA was often the most resilient and robust member of the operations team and most resistant to change. This mentality was essential to the protection of company’s critical production data.

This session discusses common database challenges and how they can be minimized or solved with newer DevOps practices without impacting the DBAs “safe zone”. We’ll discuss how to use these vital skills and motivate everyone towards solutions for more success in agile development environments. Development, testing, provisioning, patching, upgrading and managing will become easier with agile tools, virtualization and collaboration.
The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as: • Develop, Rinse, Repeat • Test Until Your Five Year Old Can Do It • Human Intervention Creates Human Error- Automate EVERYTHING.

SessionID: 69881

Successfully Migrating Existing Databases to Azure SQL Database

Back to calendar

Event Date: 13-01-2018 - Session time: 09:45:00 - Track: Database Administration

Speaker: John Sterrett

Title: Successfully Migrating Existing Databases to Azure SQL Database

Abstract:

First impressions have long-lasting effects. When dealing with an architecture change like migrating to Azure SQL Database the last thing you want to do is leave a bad first impression by having an unsuccessful migration. In this session, you will learn why Azure SQL Database might be for you. Next, you will learn how to test migrations for compatibility issues before you start the migration process. You will learn how to successfully migrate your database schema and data. Finally, you will learn how to determine which performance tier is a good starting point for your existing workload and how to monitor your workload over time to make sure your users have a great experience while you save as much money as possible.

SessionID: 69909

HiHo! HiHo! SQL Server on Linux, We Go!

Back to calendar

Event Date: 13-01-2018 - Session time: 09:45:00 - Track: Database Administration

Speaker: Janis Griffin

Title: HiHo! HiHo! SQL Server on Linux, We Go!

Abstract:

SQL Server has been running on Windows for years. Now Microsoft is making it available on Linux in order to provide a consistent database platform across Window and Linux servers, as well as on-premises and in the cloud. In this presentation, Janis Griffin, database performance evangelist at SolarWinds, will discuss the advantages of using SQL Server on Linux, comparing architecture, cost and performance. Several demonstrations on installing and maintaining SQL Server on Linux will be shown along with an introduction of several useful Linux commands.

The participant will learn:

The advantages of using SQL Server on Linux, comparing architecture, cost and performance to Window servers.
How to install, maintain and backup SQL Server on Ubuntu Linux systems
Several useful Linux commands to monitor/manage SQL Server

SessionID: 70240

ETL Architecture for Real-Time BI

Back to calendar

Event Date: 13-01-2018 - Session time: 09:45:00 - Track: BI Architecture Management

Speaker: Jon Boulineau

Title: ETL Architecture for Real-Time BI

Abstract:

For decades batch processing has been the defacto standard for Extract Transform and Load. For most of that time 24 hour data refresh cycles were accepted as part of Business Intelligence solutions and developer skill sets have long depended upon the reliable patterns of batch. In recent years, however, demands have begun to shift. New use cases in every industry are now causing leading edge BI solutions to demand much shorter time to realizing value. The old architecture, skills, and tools are proving insufficient to meet this demand. In this session we will look at the fundamentals of architecting real-time BI solutions, including the new categories of problems for which we will now have to solve. Upon completing the session attendees will have a clear picture of the new skills and patterns that must be learned in order to excel in the next phase of Business Intelligence evolution.

SessionID: 70755

Dimensional Modeling Design Patterns: Beyond the Basics

Back to calendar

Event Date: 13-01-2018 - Session time: 09:45:00 - Track: BI Architecture Management

Speaker: Jason Horner

Title: Dimensional Modeling Design Patterns: Beyond the Basics

Abstract:

Dimensional modeling is one of cornerstones of successful Business Intelligence initiatives. Even with new technologies like PowerPivot and Analysis Services Tabular models, you need to represent your organization’s data in a way that is accessible for end users and IT staff alike. An effective dimensional model will also ensure that your data warehouse or data mart will be responsive and capable of accommodating emerging requirements.

In this session, we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.

SessionID: 70758

Cosmos DB: Planet Earth Scale

Back to calendar

Event Date: 13-01-2018 - Session time: 09:45:00 - Track: Cloud Database/Application Development Deployment

Speaker: Mike Lawell

Title: Cosmos DB: Planet Earth Scale

Abstract:

In this session you will be learn what Cosmos DB is and why it is the hottest thing in Azure.

What does massively scalable, mullti-model, globally distributed, well-defined consistency models look like?

Most important, who is going to be using it and why?

SessionID: 71794

Everyone Has a Story to Tell: Developing Your First Presentation

Back to calendar

Event Date: 13-01-2018 - Session time: 09:45:00 - Track: Professional Development

Speaker: Andy Yun

Title: Everyone Has a Story to Tell: Developing Your First Presentation

Abstract:

Ever considered giving a presentation of your own? Pondered how your favorite speakers got their start? Contemplated whether you could ever do that too, but were not sure where to begin?

Well I say you can and will show you how to get started! In this session, I will teach you how to develop your idea and create session content, and share tips tricks that I have learned along the way.

You will leave armed with a wealth of resources (and hopefully some inspiration) to venture forth and develop your first presentation.

SessionID: 71921

SQL Server Meets Big Data in the Cloud: Weather Edition

Back to calendar

Event Date: 13-01-2018 - Session time: 09:45:00 - Track: Cloud Database/Application Development Deployment

Speaker: Rowland Gosling

Title: SQL Server Meets Big Data in the Cloud: Weather Edition

Abstract:

From government agencies and private networks, weather data moves through data platforms and becomes observations and forecasts. We’ll take a look at gathering, transforming and storing weather data using Microsoft Azure, SQL Server, Hadoop and a variety of other technologies (Kafka, Spark, Python, Postgres).

SessionID: 72651

Only You Can Prevent Database Fires!

Back to calendar

Event Date: 13-01-2018 - Session time: 09:45:00 - Track: Database Administration

Speaker: John Morehouse

Title: Only You Can Prevent Database Fires!

Abstract:

Do you find yourself constantly putting out "fires"? Can't take anymore heat in the data center? We as DBAs can easily become burnt out with dealing with these daily blazes. Wouldn’t it be grand to learn how to prevent these fires from scorching us to begin with? In this session, we will jump into things you can start implementing as "fire prevention" to stop the "fire fighting". We will talk about several things that you can take back to your shop and put into action easily ranging from code tuning, backup maintenance, monitoring and performance tuning!

SessionID: 69678

How to Implement a Hierarchy in SQL Server

Back to calendar

Event Date: 13-01-2018 - Session time: 11:00:00 - Track: Database Application Development

Speaker: Louis Davidson

Title: How to Implement a Hierarchy in SQL Server

Abstract:

One of the most common structures you will come across in the real world is a hierarchy (either a single parent "tree" or a multi-parent "graph"). Many systems will implement the obvious examples, such as a corporate managerial structure or a bill of materials. It turns out that almost any many-to-many relationship can be used as a hierarchy to find the relationship of parent rows to child rows (for example, the relationship of actors to movies they’ve been in). In this session, we’ll discuss several different implementations of hierarchies that you can use to optimize your hierarchy implementations, including SQL Server 2017's graph tables, and put into practice immediately, with ready-made T-SQL examples.

SessionID: 69960

Why am I able to master several technology languages but I struggle in my own business language?

Back to calendar

Event Date: 13-01-2018 - Session time: 11:00:00 - Track: Professional Development

Speaker: Karen Nelson

Title: Why am I able to master several technology languages but I struggle in my own business language?

Abstract:

Technology people are well known to be focused, results motivated, introvert, etc. 95% of your time is spent “communicating” successfully with computers: programming, building databases, analizing, etc. If something is wrong an alert window will pop up. The problem is that human interaction doesn’t have any warning sound to do it all over again or make some changes. Most of the time we only have one chance to do it right.

The struggles shows in a workplace filled with employees of different backgrounds or cultures, with different native languages that convey to speak English as the business language. Plus the fact that we don’t have the right skills to communicate appropriately. The problems will inevitably arise during human interaction; what we can do is try to minimize the frustration that it takes to communicate efficiently. In this session we will be able to learn that communication is not just a given fact, is something that needs to be learnt and taught.

SessionID: 70102

Writing award winning PowerShell functions and script modules

Back to calendar

Event Date: 13-01-2018 - Session time: 11:00:00 - Track: PowerShell

Speaker: Mike Robbins

Title: Writing award winning PowerShell functions and script modules

Abstract:

Transitioning from writing PowerShell one-liners and basic scripts to creating reusable PowerShell tools with advanced functions and script modules can be a daunting task and with all the different ways that you’ll find on the Internet to accomplish the same task, it can definitely seem overwhelming. During this session, we’ll demystify many of the intricacies of toolmaking while demonstrating the best practices for using parameters, parameter validation, cmdlet binding, supports should process, pipeline input, error handling, module manifests, and custom formatting.

SessionID: 70175

Getting started with SQL Azure Database: What you need to know

Back to calendar

Event Date: 13-01-2018 - Session time: 11:00:00 - Track: Cloud Database/Application Development Deployment

Speaker: Jim Donahoe

Title: Getting started with SQL Azure Database: What you need to know

Abstract:

Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore.

In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.

SessionID: 70220

Python in SQL Server 2017

Back to calendar

Event Date: 13-01-2018 - Session time: 11:00:00 - Track: BI Analytics and Visualization

Speaker: Chris Hyde

Title: Python in SQL Server 2017

Abstract:

SQL Server 2017 has finally arrived, bringing with it a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started!

In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!

SessionID: 70429

End-to-End Troubleshooting Checklist for SQL Server

Back to calendar

Event Date: 13-01-2018 - Session time: 11:00:00 - Track: Database Administration

Speaker: Kevin Kline

Title: End-to-End Troubleshooting Checklist for SQL Server

Abstract:

Learning how to detect, diagnose and resolve performance problems in SQL Server is tough. Often, years are spent learning how to use the tools and techniques that help you detect when a problem is occurring, diagnose the root-cause of the problem, and then resolve the problem.

In this session, attendees will see demonstrations of the tools and techniques which make difficult troubleshooting scenarios much faster and easier, including:

• XEvents, Profiler/Traces, and PerfMon • Using Dynamic Management Views (DMVs) • Advanced Diagnostics Using Wait Stats • Reading SQL Server execution plan

Every DBA needs to know how to keep their SQL Server in tip-top condition, and you’ll need skills the covered in this session to do it.

SessionID: 70689

Reducing The Surface Area Of Risk in Data Security

Back to calendar

Event Date: 13-01-2018 - Session time: 11:00:00 - Track: Cloud Database/Application Development Deployment

Speaker: Tim Gorman

Title: Reducing The Surface Area Of Risk in Data Security

Abstract:

Data obfuscation, also known as data masking, is soon a new legal requirement. Masking is the solution for non-production systems (i.e. DEV, TEST, etc) to greatly reduce the surface area of risk for data breach in your organization. Masking should not be confused with encryption, which is an appropriate solution for production applications. Those who believe that encryption solves all security problems are misled.

When done properly, masked data is not noticeable unless you look closely. Masking data well might still be usable for analytic reporting and aggregation, yet utterly useless for revealing confidential data. Masking is important enough that sophisticated software packages have become available.

Come learn about the right way to mask non-production data in order to allow the organization to limit possible exposure only to production. Learn what techniques can be used, why, and what factors should be considered when deciding to secure confidential data.

SessionID: 70732

Parameter Sniffing the Good, the Bad and the Ugly

Back to calendar

Event Date: 13-01-2018 - Session time: 11:00:00 - Track: Database Administration

Speaker: Lance Tidwell

Title: Parameter Sniffing the Good, the Bad and the Ugly

Abstract:

Parameter sniffing is something that more than often helps performance on your servers; however, there are times when it can hinder performance as well. In this session we will define exactly what parameter sniffing is, and examine when it is good and when it is bad. Lastly, we will explore the different options available to fix bad parameter sniffing. After this session, you will be able to locate and fix bad parameter sniffing when it occurs on your servers.

SessionID: 71512

Power BI administration made easy(ier)

Back to calendar

Event Date: 13-01-2018 - Session time: 11:00:00 - Track: BI Architecture Management

Speaker: Dan Evans

Title: Power BI administration made easy(ier)

Abstract:

Now that you have Power BI in your organization the fun has just started! Making sure users get the best experience requires some thought and planning though. Come learn the fundamentals of the Power BI architecture and hear about best practices with assigning licenses, delegating roles, audit log analysis, gateway management and overall Power BI administration based on real-world experiences.

SessionID: 71791

SQL Server Encryption

Back to calendar

Event Date: 13-01-2018 - Session time: 11:00:00 - Track: Database Administration

Speaker: Ben Miller

Title: SQL Server Encryption

Abstract:

Have you ever wanted to know how Transparent Database Encryption (TDE) works or how you set it up? What about encrypting your backups? This session will go over all the steps and caveats that go with this technology. TDE allows you to have your database encrypted on disk and the same Encryption Hierarchy allows you to back up your database and have it encrypt the contents in the backup file. We will discuss the Encryption Hierarchy which is used for encryption in SQL Server and take you through keeping your secrets safe. We will also go over how Always Encrypted works as well. Master the concepts of SQL Server Encryption when you are done with this session.

SessionID: 71892

Azure SQL DW Performance Common Issues

Back to calendar

Event Date: 13-01-2018 - Session time: 11:00:00 - Track: Cloud Database/Application Development Deployment

Speaker: Gareth Swanepoel

Title: Azure SQL DW Performance Common Issues

Abstract:

Azure SQL Data Warehouse and APS are based on the MPP architecture. Analyzing the workload can be very different than SQL Server and SQL DB. In this session, we will show you what an MPP execution plan is, what to look for, and how to compare them to DMV output to pinpoint performance problems. We will use real customer scenarios to show you the most common causes of slowness and how we improved the performance. Please note: This session is intended for individuals with a 200 level understanding of MPP architecture with some understanding of data movement. There will be a short review of core components, but the discussion will quickly move to more advanced topics.

SessionID: 69707

Alexa, Talk to Me

Back to calendar

Event Date: 13-01-2018 - Session time: 12:20:00 - Track: Cloud Database/Application Development Deployment

Speaker: Dave Mattingly

Title: Alexa, Talk to Me

Abstract:

Learn how to create your own skill (app) for Amazon's Echo / Dot service known as Alexa.

In this session, we'll create a simple skill from scratch, and show how to get into some of the more advanced options.

SessionID: 71885

Cloud Panel

Back to calendar

Event Date: 13-01-2018 - Session time: 12:20:00 - Track: Cloud Database/Application Development Deployment

Speaker: Josh Luedeman

Title: Cloud Panel

Abstract:

Panel of Consultants for Attendees to ask cloud questions

SessionID: 72655

Optimizing SQL Server Instances You Don't Control

Back to calendar

Event Date: 13-01-2018 - Session time: 12:20:00 - Track: Database Administration

Speaker: Rodrigo Medeiros

Title: Optimizing SQL Server Instances You Don't Control

Abstract:

When you’re responsible for the care and feeding of packaged business apps and the underlying database is struggling to keep up, it can be quite challenging if not impossible to make code adjustments or configuration changes that improve responsiveness.

Learn what could well be the root cause for the problems you are experiencing, ways to identify it and simple solutions you can implement without anyone else’s help.

SessionID: 72783

SQL Server Remote Management Best Practices

Back to calendar

Event Date: 13-01-2018 - Session time: 12:20:00 - Track: Database Administration

Speaker: SQLSaturday Nashville

Title: SQL Server Remote Management Best Practices

Abstract:

Panel discussion on remote management, PowerShell and access control best practices for SQL Server. Attendee questions welcome.

Jay Adams Tracy Boggiano Kellyn Pot'Vin-Gorman Rob Volk Anthony Nocentino Mike F Robbins

Brought to you by System Frontier

SessionID: 72864

Top Tools for Tuning SQL: Focus on Plan Explorer

Back to calendar

Event Date: 13-01-2018 - Session time: 12:20:00 - Track: Database Application Development

Speaker: Kevin Kline

Title: Top Tools for Tuning SQL: Focus on Plan Explorer

Abstract:

In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning to help you with some of the most problematic and troublesome SQL coding issues which you can take home and immediately apply to your SQL code. You’ll learn things like:

What are the most popular free tools and scripts for performance tuning in the SQL Server community.
A little-known technique to create a tiny version of large production databases, yet deliver query execution behaviors as you would see in production along with a sneaky DBCC commands that helps replicate a full production server on your workstation.
Best practices in reading execution plans using the free tool, Plan Explorer.
A variety of T-SQL techniques, including the best way to write a cursor, a quick trick that can save you 20-30% processing times on your big stored procedures, and some weird situations where SQL Server doesn’t use cached plans when it should.

SessionID: 69432

Data Cleansing With SQL And R

Back to calendar

Event Date: 13-01-2018 - Session time: 13:30:00 - Track: BI Analytics and Visualization

Speaker: Kevin Feasel

Title: Data Cleansing With SQL And R

Abstract:

On a given project, data scientists can spend upwards of 80% of their time preparing, cleaning, and correcting data. In this session, we will look at different data cleansing and preparation techniques using both SQL Server and R. We will investigate the concept of tidy data and see how we can use tools in both languages to simplify research and analysis of a small but realistic data set.

SessionID: 69580

Working with Temporal Data in SQL Server

Back to calendar

Event Date: 13-01-2018 - Session time: 13:30:00 - Track: Database Application Development

Speaker: David Maxwell

Title: Working with Temporal Data in SQL Server

Abstract:

In many industries, it is necessary for data professionals to be able to show what a data set looked like at a previous point in time. Whether it's calculating tax or insurance rates based on a contract date, quickly comparing data changes over time for trend analysis or just recovering from an accidental data change, it's useful to be able to look back in time through our data. SQL Server has long offered solutions like Change Data Capture or trigger-based audit tables, though those aren’t always the best solutions for each situation. SQL Server 2016 introduces system-versioned tables, which track data through time with far less overhead than other solutions. In this session, you'll learn how to work with tables for each kind of solution, how SQL Server manages data within those tables, and how to query data at a specific point in time using several real-world examples. Attendees will leave with a fundamental understanding of practical use cases for different types of temporal tables.

SessionID: 70058

SaaS/IaaS Compromise - Learning Azure SQL Database Managed Instance

Back to calendar

Event Date: 13-01-2018 - Session time: 13:30:00 - Track: Database Administration

Speaker: Tim Warner

Title: SaaS/IaaS Compromise - Learning Azure SQL Database Managed Instance

Abstract:

Azure SQL Database Managed Instance offers you the best of both worlds: deeper access to the underlying virtual database server (infrastructure-as-a-service, or IaaS), with the high agility of software-as-a-service (SaaS). In this session you'll learn the Managed Instance use case and be equipped to make an informed decision on how you host your SQL Server databases in the Microsoft Azure public cloud.

SessionID: 70499

Query Store Primer

Back to calendar

Event Date: 13-01-2018 - Session time: 13:30:00 - Track: Database Administration

Speaker: Tracy Boggiano

Title: Query Store Primer

Abstract:

This session will take a look at the new Query Store feature in SQL Server 2016. Query Store tracks changes in execution plans, allowing you to easily view performance differences and revert to older plans with a few clicks of the mouse. We will take a hands on look at how to use Query Store to troubleshoot problems new features in 2017.

SessionID: 70524

Why NULL is not a value (and other SQL gotchas)

Back to calendar

Event Date: 13-01-2018 - Session time: 13:30:00 - Track: Database Application Development

Speaker: Wendy Pastrick

Title: Why NULL is not a value (and other SQL gotchas)

Abstract:

SessionID: 70711

Hi, my name is Powershell, let's be friends! An Intro to PoSH

Back to calendar

Event Date: 13-01-2018 - Session time: 13:30:00 - Track: PowerShell

Speaker: Amy Herold

Title: Hi, my name is Powershell, let's be friends! An Intro to PoSH

Abstract:

Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.

SessionID: 70729

Becoming the MVP: Soft Skills for the Hard Market

Back to calendar

Event Date: 13-01-2018 - Session time: 13:30:00 - Track: Professional Development

Speaker: Angela Tidwell

Title: Becoming the MVP: Soft Skills for the Hard Market

Abstract:

Whether you are just starting a career, advancing into senior leadership, or trying to woo a potential client, soft skills can be your ticket to success. Often times we focus on showing how smart we are instead of showing what a good team member we can be. We will discuss the role and types of soft skills needed to showcase your X-factor. Need to hone your skills? We will explore innovative and fun ways in which to do just that!

SessionID: 70743

Tame Your Unruly Data With Constraints

Back to calendar

Event Date: 13-01-2018 - Session time: 13:30:00 - Track: Database Application Development

Speaker: Rob Volk

Title: Tame Your Unruly Data With Constraints

Abstract:

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

SessionID: 70751

Why Third Party Vendors Do The Things They Do

Back to calendar

Event Date: 13-01-2018 - Session time: 13:30:00 - Track: Database Administration

Speaker: Henry Treftz

Title: Why Third Party Vendors Do The Things They Do

Abstract:

Have you ever installed a third-party application that uses SQL Server, started to use it, and then wondered why does this feature behave this way or what the heck were they thinking when they did it this way.

I at one point was one of those people who designed, developed, and maintained databases for an ISV. This is my chance to explain and atone for my database sins and explain why some decisions seem like good ideas at the time and why some are forced upon an ISV.

This presentation has three main objectives:

Explain why vendors make the design, coding, and implementation decisions that they do;
Discuss how to make third-party applications run better in your environment;
Teach you how to work around those limitations and work with those vendors and get better support.

SessionID: 71886

Migrating your BI Platform to Azure

Back to calendar

Event Date: 13-01-2018 - Session time: 13:30:00 - Track: Cloud Database/Application Development Deployment

Speaker: Josh Luedeman

Title: Migrating your BI Platform to Azure

Abstract:

Talk through moving your BI infrastructure to Azure

SessionID: 72597

Data Visualization: How to truly tell a great story!

Back to calendar

Event Date: 13-01-2018 - Session time: 13:30:00 - Track: BI Analytics and Visualization

Speaker: Jonathan Stewart

Title: Data Visualization: How to truly tell a great story!

Abstract:

We have more information available to us today than ever before. So much so that we run the risk of not being able to tell concise stories. There's a lot more to creating that story than just getting the correct information. Come learn not just the do's and don'ts, but the whys…

SessionID: 69539

What could be better than football and R!

Back to calendar

Event Date: 13-01-2018 - Session time: 14:50:00 - Track: BI Analytics and Visualization

Speaker: Kevin Wilkie

Title: What could be better than football and R!

Abstract:

R -- it's included in SQL Server 2016. What can I do with it? Why do I need to know yet another software language? How can I use it to figure out important things -- like who is the best qb in the league right now, statistically?

We'll go over the basics of R and how to do things with it, plus items such as:

Installing and managing packages
Accessing data in various formats
Basic data visualization functions

SessionID: 70193

Applying Data Warehousing Principles: Going from Descriptive to Predictive

Back to calendar

Event Date: 13-01-2018 - Session time: 14:50:00 - Track: BI Architecture Management

Speaker: Spencer Swindell

Title: Applying Data Warehousing Principles: Going from Descriptive to Predictive

Abstract:

Have you ever had difficulty working with large data sets, or integrating multiple disparate data sources? Would you like present this data in a dashboard and effectively use your data to make more informed decisions? By understanding an applying data warehousing concepts and principles you can take advantage of the value of your data, and lay a foundation for future integrations. During this session we will cover data warehousing concepts with examples and demos to showcase the techniques. After this session you will understand key data warehouse concepts and techniques, as well as how data can be presented in a dashboard and used in an analytical application.

SessionID: 70480

A Beginner's Guide to Power BI

Back to calendar

Event Date: 13-01-2018 - Session time: 14:50:00 - Track: BI Analytics and Visualization

Speaker: Ed Watson

Title: A Beginner's Guide to Power BI

Abstract:

Are you new to Power BI Server? Do you want to learn what all the buzz is about and how to use it from a purely novice standpoint? Do you need to ramp up quickly to be able to build some great visualizations? This session is the session that you need! We will walk you through the basic architecture and nuances of Power BI all the while taking a fun adventure to building your first Power BI report. The attendee will leave the class ready to start using Power BI in the real world.

SessionID: 70593

Making Your List and Checking It Twice: Introduction to unit testing with tSQLt

Back to calendar

Event Date: 13-01-2018 - Session time: 14:50:00 - Track: Database Application Development

Speaker: Elizabeth Noble

Title: Making Your List and Checking It Twice: Introduction to unit testing with tSQLt

Abstract:

Unit testing allows database code to be consistently tested during the development process, but it can be challenging to get unit testing setup for database development. This session will give an overview on the purpose of unit testing, the installation of the tSQLt framework, and the design of unit tests. I will use general concepts of test driven design to create and run unit tests to confirm that objects exist and to test single and multiple test cases. Learn how to implement unit testing in a development environment and create and run your own units tests.

SessionID: 70601

Ethics, Morals, and Laws for the DBA 101

Back to calendar

Event Date: 13-01-2018 - Session time: 14:50:00 - Track: Professional Development

Speaker: Pat Phelan

Title: Ethics, Morals, and Laws for the DBA 101

Abstract:

Ethics, Morals, and Laws each govern one aspect of our behavior as people and DBAs. They govern which actions we take and which actions we avoid.

Understanding the basics of these guides and how they coordinate (and sometimes conflict) with each other helps you to make choices you can live with from both a personal and professional perspective.

This session presents basic definitions, ideas, and discussion points. It is intended to be an interactive presentation where the audience contributes to the discussion, so no two presentations are exactly the same!

SessionID: 70698

Minimizing User Impact with Advanced Restore Methods

Back to calendar

Event Date: 13-01-2018 - Session time: 14:50:00 - Track: Database Administration

Speaker: Bob Pusateri

Title: Minimizing User Impact with Advanced Restore Methods

Abstract:

We all know that backups are only half the battle - restores are what really matter when disaster strikes. Standard restores, while effective, may require additional downtime and further affect the business. This session will demonstrate three advanced restore methods you should know: point-in-time restores, piecemeal restores, and page restores, and will discuss when each method is appropriate. Attend this session to learn how to be a better DBA by minimizing downtime and user impact after disaster has struck!

SessionID: 70706

SQL Server Take Over: Establishing a Baseline

Back to calendar

Event Date: 13-01-2018 - Session time: 14:50:00 - Track: Database Administration

Speaker: Lowry Kozlowski

Title: SQL Server Take Over: Establishing a Baseline

Abstract:

SQL Server Take Over: Establishing a Baseline

Performance assessment and tuning for the beginner DBA Have you ever inherited a group of servers with not a lot of documentation to accompany them? Do you have a lot of undocumented or new servers in your environment and you want to establish some baseline configuration setting prior to making changes? You need up to date information on the system very quickly. The server is running slowly... or is it? Slow compared to what? Before you being digging into performance issues, there are some baseline metrics you should have established. Only after the information has been gathered, can a plan of attack be developed to help resolve issues with performance. Attendees in this session will learn how to quickly gather information, review the results and get an action plan on the next step in performance tuning.

SessionID: 70707

AI to the Masses! But How? Pixie Dust?

Back to calendar

Event Date: 13-01-2018 - Session time: 14:50:00 - Track: Cloud Database/Application Development Deployment

Speaker: Hope Foley

Title: AI to the Masses! But How? Pixie Dust?

Abstract:

The way you hear about artificial intelligence, it seems like you throw some big data in the cloud and wave a magical AI wand over it and you can predict the future…right? Not exactly. Azure does have some great options to bring data science to your data but you need to weigh the options. In this session we'll discuss those options and some questions to answer if you're being tasked with making magical things happen with your data.

SessionID: 70721

Biml for Beginners: Speed Up Your SSIS Development

Back to calendar

Event Date: 13-01-2018 - Session time: 14:50:00 - Track: BI Architecture Management

Speaker: Cathrine Wilhelmsen

Title: Biml for Beginners: Speed Up Your SSIS Development

Abstract:

Are you tired of creating and updating the same SSIS packages again and again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and really speed up your SSIS development?

Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.

In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.

Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!

SessionID: 70727

Exploring the new SqlServer PowerShell module

Back to calendar

Event Date: 13-01-2018 - Session time: 14:50:00 - Track: PowerShell

Speaker: Michael Fal

Title: Exploring the new SqlServer PowerShell module

Abstract:

If you’ve dabbled in PowerShell, you probably know that there are many ways to use it in conjunction with SQL Server. While using the provided tool set has been a challenge for many data professionals, recent upgrades and improvements to the PowerShell module for SQL server provide a solid tool set for new and experienced users. This session will cover the SqlServer module in detail, exploring the various commands and demonstrating various use cases for the tool set. Attendees will get a solid overview of the module and real world examples of how users can get the most out of their code.

SessionID: 72367

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

Back to calendar

Event Date: 13-01-2018 - Session time: 14:50:00 - Track: Cloud Database/Application Development Deployment

Speaker: Bradley Ball

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

Abstract:

This site is open source. Improve this page.