sqlsathistory

Nr: 734

SQLSaturday #734 - Dallas 2018

Start Time (24h)	Speaker	Track	Title
08:30:00	Chris Hyde	Analytics and Visualization, BI Delivery	Python in SQL Server 2017
08:30:00	John Sterrett	Enterprise Database Administration Deployment	DIY: SQL Server Monitoring for your Enterprise
08:30:00	Mike Byrd	Application Database Development	Climbing the SQL Server Index B-Tree (from a user perspective)
08:30:00	Thomas Norman	Enterprise Database Administration Deployment	Database Project Makes Deployment Consistent
08:30:00	William Assaf	Enterprise Database Administration Deployment	What's New In SQL Server 2017
08:30:00	Juan Soto	Professional Development	Wish you could live the glamorous consulting life?
08:30:00	Rick Lowe	Enterprise Database Administration Deployment	Why Should I Care About ... Partitioned Views?
08:30:00	Ryan Adams	Application Database Development	History Tracking with Temporal Tables
08:30:00	Tim Mitchell	BI Platform Architecture, Development Administration	Are There Time Bombs in your SSIS Packages?
09:45:00	Peter Schott	Application Database Development	Getting your DB schema under control with SSDT
09:45:00	Bob Ward	Enterprise Database Administration Deployment	Experience SQL Server 2017: The Modern Database Platform
09:45:00	Dave Bland	Enterprise Database Administration Deployment	Extended Events: What are they and How do I use them
09:45:00	Kenneth Fisher	Enterprise Database Administration Deployment	SQL Server Security from the ground up
09:45:00	Tim Costello	BI Platform Architecture, Development Administration	Windowing Functions
09:45:00	Mark Moore	Other	Azure SQL and Azure Data Warehouse 101
09:45:00	Abdullah Mamun	Enterprise Database Administration Deployment	Deploying SQL Server on Azure VM (IaaS)
09:45:00	Russel Loski	Cloud Application Development Deployment	Managing Azure Data Lake with PowerShell
11:00:00	Kevin Hill	Enterprise Database Administration Deployment	Disaster recovery is everyone's job!
11:00:00	Shawn Weisfeld	Cloud Application Development Deployment	Get insights from data with Cognitive Services
11:00:00	Kellyn Pot'Vin-Gorman	Enterprise Database Administration Deployment	Essential Linux for the SQL Server DBA
11:00:00	Garry Bargsley	Enterprise Database Administration Deployment	Use PowerShell and dbatools to Manage your SQL Server Environment
11:00:00	William Assaf	Professional Development	Think Like a Certification Exam
11:00:00	Henry Weng	Enterprise Database Administration Deployment	Transactional Replication New Features for AlwaysOn AG in SQL 2017
11:00:00	Tim Mitchell	BI Platform Architecture, Development Administration	Introduction to Biml
11:00:00	Lance Tidwell	Application Database Development	New Features in SQL That Will Change the Way You Tune
11:00:00	Tejpal Thatte	Analytics and Visualization, BI Delivery	QuickStart on embedding PowerBI reports in your line of business applications
13:15:00	Steven Tidwell	Application Database Development	Dynamic SQL: Tables, Pivots, Parameters More
13:15:00	Dainius Sutkevicius	Enterprise Database Administration Deployment	How to transition from Profiler to Extended Events and why you should consider.
13:15:00	Jamey Johnston	Analytics and Visualization, BI Delivery	Code Like a Snake Charmer - Intro to Python!
13:15:00	Angela Tidwell	Professional Development	Becoming the MVP: Soft Skills for the Hard Market
13:15:00	Brian Guarnieri	Enterprise Database Administration Deployment	Security, Hypocrisy, and Standards, "OH MY" or How to hack your data center in three easy steps.
13:15:00	Eric Blinn	Enterprise Database Administration Deployment	Encryption: Not just for the NSA anymore
13:15:00	Sean McCown	Enterprise Database Administration Deployment	Loading SQL Server Data with Powershell
13:15:00	Greg Galloway	BI Platform Architecture, Development Administration	Automating Azure Analysis Services
13:15:00	Chris Voss	BI Platform Architecture, Development Administration	Should This Be Normalized? When Database Normalization Seems Abnormal
14:30:00	Stacy Gray	Enterprise Database Administration Deployment	Troubleshooting SQL Server Performance
14:30:00	Tracy Boggiano	Enterprise Database Administration Deployment	Intro to Query Store
14:30:00	Bob Ward	Enterprise Database Administration Deployment	Experience SQL Server on Linux and Containers
14:30:00	Jennifer McCown	Enterprise Database Administration Deployment	Beginning Admin: The Care and Feeding of SQL Server
14:30:00	Je'Anna Lanza-Abbott	Professional Development	Performance Tuning for Salary Negotiations
14:30:00	Steve Hughes	BI Platform Architecture, Development Administration	Data Security in Power BI
14:30:00	Jayaprakash Jothiraman	Application Database Development	Whats New in SQL Server 2017
14:30:00	Michael Bourgon	Cloud Application Development Deployment	AWS Aurora from a SQL Server DBA's perspective
14:30:00	David Stein	BI Platform Architecture, Development Administration	Azure Data Factory V2 and SSIS Automation With Biml
15:45:00	Thomas LeBlanc	BI Platform Architecture, Development Administration	Getting started with Tabular Analysis Services
15:45:00	Kevin Trojanowski	Application Database Development	SQL Unit Testing with T-SQLt
15:45:00	Suresh Kandoth	Enterprise Database Administration Deployment	SQL Server on Linux : Troubleshooting tips and tricks
15:45:00	Kris Hokanson	Application Database Development	That's bad mkay!
15:45:00	Reinaldo Kibel	Enterprise Database Administration Deployment	AlwaysOn on 2012/2014/2016/2017 Notes from the field and Best Practice
15:45:00	Mohammad Darab	Professional Development	3 Lessons Learned in Successful Consulting
15:45:00	John Wells	Application Database Development	Fundamentals That Will Improve Your Query Performance!
15:45:00	Todd Kleinhans	Enterprise Database Administration Deployment	The Life Cycle of a Query in Virtual Reality
15:45:00	Ryan Casey	BI Platform Architecture, Development Administration	"Real World" examples on loading a data warehouse using SSIS

SessionID: 71611

Python in SQL Server 2017

Back to calendar

Event Date: 19-05-2018 - Session time: 08:30:00 - Track: Analytics and Visualization, BI Delivery

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

DIY: SQL Server Monitoring for your Enterprise

Back to calendar

Event Date: 19-05-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: John Sterrett

Title: DIY: SQL Server Monitoring for your Enterprise

Abstract:

Have you wanted monitoring tools but know it's not feasible to procure them for your SQL Server enterprise? In this session, you will learn how to implement multiple solutions to help you be a Proactive DBA instead of retroactive DBA. You will understand which checks should be mandatory for every SQL Server environment. You will also learn common pitfalls with implementing your own monitoring solutions and how to customize them to work for you.

SessionID: 74324

Climbing the SQL Server Index B-Tree (from a user perspective)

Back to calendar

Event Date: 19-05-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Mike Byrd

Title: Climbing the SQL Server Index B-Tree (from a user perspective)

Abstract:

This session dives down and looks at the important items on data pages of clustered, non-clustered, and unique non-clustered indexes using the DBCC Page command. It will also look at the effect of row data compression on clustered and non-clustered indexes. In all demos we will try to ascertain how the SQL Server® optimizer might use them and also strive to gain some insight from a performance advantage. Its purpose is mainly to try and understand how SQL Server implements indexes, their underlying structure, and where performance benefits might lie from a layman’s viewpoint. Session is 80% demos.

SessionID: 75782

Database Project Makes Deployment Consistent

Back to calendar

Event Date: 19-05-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Norman

Title: Database Project Makes Deployment Consistent

Abstract:

SessionID: 77161

What's New In SQL Server 2017

Back to calendar

Event Date: 19-05-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: William Assaf

Title: What's New In SQL Server 2017

Abstract:

From the lead author of SQL Server 2017 Administration Inside Out by Microsoft Press, come learn in technical detail what’s new for developers, admins, and users of Microsoft SQL Server 2017, including labs and demos. We'll discuss the new features for the platform, high availability, maintenance, and TSQL syntax.

SessionID: 77379

Wish you could live the glamorous consulting life?

Back to calendar

Event Date: 19-05-2018 - Session time: 08:30:00 - Track: Professional Development

Speaker: Juan Soto

Title: Wish you could live the glamorous consulting life?

Abstract:

Learn how to launch your career as a consultant, from how to get leads to call you, how to close the sale and what to charge for your services. A must see session if you’re ready to make the plunge!

Consulting is a great career choice, from the increased pay, (sometimes less), to the flexible hours, (working nights and weekends), you will work with a wide range of customers, (if you can find them), that will lead you to wonder why you didn't start earlier? (and walk away from a cushy job). I would not trade my consulting career for any other choice, I love the rewards and the freedom it provides me, but I've learned the hard way. I will share how I close $25,000 deals over the phone, how to get your lead to say yes and how to overcome price objections. In this session you will learn sales, marketing and management strategies to get your practice off the ground, sand traps to avoid along the way and a honest, down to earth assessment of the consulting life.

SessionID: 77815

Why Should I Care About ... Partitioned Views?

Back to calendar

Event Date: 19-05-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Rick Lowe

Title: Why Should I Care About ... Partitioned Views?

Abstract:

Partitioned tables are awesome and partitioned views are dead, right? Well, sure partitioned views are not sexy but there are still plenty of applications where they are critical. And not necessarily just for standard edition who aren't on the new service pack yet. If your data is time stamped, do you see different queries run against older data than new data? Do you with you could segment your data across multiple columns? Do you have data you need to partition horizontally? It's possible partitioned views may still be for you. Come hear why this is still an important topic long after cargo pants and trucker hats went away ... and possibly even after 2016 SP1.

SessionID: 77936

History Tracking with Temporal Tables

Back to calendar

Event Date: 19-05-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Ryan Adams

Title: History Tracking with Temporal Tables

Abstract:

If you are looking for an easy way to track data history changes or create a slowly changing dimension in your data warehouse then Temporal tables are a great solution! You will learn what a Temporal Table is, how you can use it, and set one up. We will also discuss the new TSQL syntax to query these tables and how you can use this features on existing tables.

SessionID: 77986

Are There Time Bombs in your SSIS Packages?

Back to calendar

Event Date: 19-05-2018 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Tim Mitchell

Title: Are There Time Bombs in your SSIS Packages?

Abstract:

Could your seemingly-normal SSIS package be hiding a disaster, waiting to detonate at the most inconvenient time? Integration Services is an incredibly flexible product, and that flexibility can lead to good - and occasionally bad - design patterns. Small and seemingly trivial design decisions can lead to big issues down the road, including leaky data flows, data quality issues, paralyzing performance issues, and other explosive behaviors.

In this session, we will explore some of the most common SSIS design patterns that are potentially more harmful than they first appear. From package configuration to control flow constraints, and data flow transformations to logging, we'll demonstrate what can go wrong and show some alternative designs to prevent these types of problems from developing into bigger issues.

SessionID: 71620

Getting your DB schema under control with SSDT

Back to calendar

Event Date: 19-05-2018 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Peter Schott

Title: Getting your DB schema under control with SSDT

Abstract:

Have you struggled with keeping track of all of the scripts needed to release the next version of your database? Have you ever had to scramble at the last minute due to bad database scripts? This session might help you get control of your database schema by using SQL Server Data Tools.

We'll cover:

What exactly is SSDT?
Getting your database into an SSDT project
Putting that project into source control
Making changes to the project through schema compares or direct changes
Pushing those changes out to your servers

This session assumes basic knowledge of TSQL to create and manipulate database objects. Some understanding of Visual Studio, version control, and SQLCMD will help, but is not essential.

SessionID: 73044

Experience SQL Server 2017: The Modern Database Platform

Back to calendar

Event Date: 19-05-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Bob Ward

Title: Experience SQL Server 2017: The Modern Database Platform

Abstract:

SQL Server is no longer just a relational database management system. It has become a platform for data, both in your cloud and ours. This session will discuss all the new features and capabilities of SQL Server 2017 including SQL Server on Linux, Docker Containers, Graph Database, Python, Adaptive Query Processing, Automatic Tuning, and new HADR capabilities. We will even talk a few hidden gems included in the release. This session will contain demos that showcase these capabilities and we will close the session with a discussion of SQL Server Futures and Roadmap.

SessionID: 74059

Extended Events: What are they and How do I use them

Back to calendar

Event Date: 19-05-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

Title: Extended Events: What are they and How do I use them

Abstract:

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will give someone who has never used Extended events before the skills to start using them!

SessionID: 74260

SQL Server Security from the ground up

Back to calendar

Event Date: 19-05-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Kenneth Fisher

Title: SQL Server Security from the ground up

Abstract:

In the modern age, data is a company's most valuable resource and, unfortunately, data crimes are common and laws to protect data are becoming more common and can have harsh punishments. Because of this, everyone that works with SQL Server should have a basic understanding of database security. Attend this session to learn the what, how, and why of database security. Learn what permissions, securables, and principals are. Learn how to manage database security. Most importantly, learn what the best practices are and why they are important. Your company's data is your responsibility, and after attending this session you can step up and keep it safe.

SessionID: 74547

Windowing Functions

Back to calendar

Event Date: 19-05-2018 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Tim Costello

Title: Windowing Functions

Abstract:

Window functions are one of the coolest new things in SQL Server 2012, but they can be tricky to figure out. In this session we'll talk about how windows functions work and why you should start using them. This is going to be a demo heavy session with code samples you can take back to work and start using Monday morning!

SessionID: 75850

Azure SQL and Azure Data Warehouse 101

Back to calendar

Event Date: 19-05-2018 - Session time: 09:45:00 - Track: Other

Speaker: Mark Moore

Title: Azure SQL and Azure Data Warehouse 101

Abstract:

Need more SQL but you have run out of hardware on premises? How about SQL in the cloud? In this session we will discover what Azure is with a high level overview of Azure and we will dive into two of Azure’s Data offerings, Azure SQL Database (SQL Server) and Azure SQL Datawarehouse (PDW). We will walk through setting up an Azure environment for the first time and how to deploy and use Azure SQL Database and Azure SQL Datawarehouse. The discussion will also include defining IaaS, PaaS and SaaS

SessionID: 77849

Deploying SQL Server on Azure VM (IaaS)

Back to calendar

Event Date: 19-05-2018 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Abdullah Mamun

Title: Deploying SQL Server on Azure VM (IaaS)

Abstract:

SQL Server on Azure virtual machines enables you to use full versions of SQL Server in the Cloud without having to manage any on-premises hardware. The session covers options, features and best practices on SQL Server on Azure VM. We will highlight frequently asked questions, common issues with SQL server on Azure VM and how to avoid them.

SessionID: 78073

Managing Azure Data Lake with PowerShell

Back to calendar

Event Date: 19-05-2018 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: Russel Loski

Title: Managing Azure Data Lake with PowerShell

Abstract:

PowerShell can perform common tasks in Azure Data Lake. Learn how to authenticate and then upload files, run jobs and inventory your site.

In this session, we will look at how to authenticate in Azure Data Lake using PowerShell. From there, I will demonstrate how to upload a set of files and how to get information about the files. In addition, we will submit U-SQL jobs to Azure Data Lake Analytics.

SessionID: 71613

Disaster recovery is everyone's job!

Back to calendar

Event Date: 19-05-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Hill

Title: Disaster recovery is everyone's job!

Abstract:

Targeted at the non-DBA such as BI/DW folks, Application Developers, Managers, and System Admins, this session will go over the reasons we back up our databases, our systems, etc. Considerations such as Single points of failure, High Availability/Disaster recovery, Business Continuity and others will be discussed in this interactive conversation. It will be conversation heavy, with supporting slides to download, and one Database backup demo at the end if time permits.

Everyone involved in a technical role needs to at least know that the things they have created will be recoverable in the event of a disaster, or even just an "oops" moment. The CIO/CTO should know how long critical systems will be down when bad things happen. Backups are everyone's responsibility...whether asking the right questions or implementing the process.

SessionID: 72061

Get insights from data with Cognitive Services

Back to calendar

Event Date: 19-05-2018 - Session time: 11:00:00 - Track: Cloud Application Development Deployment

Speaker: Shawn Weisfeld

Title: Get insights from data with Cognitive Services

Abstract:

How can you take advantage of Artificial Intelligence without being a data scientist? Cognitive Services allow you use Artificial Intelligence to enrich your data through simple API calls. In this session, we will demonstrate the Cognitive Services and brainstorm how we can apply these to our applications.

SessionID: 73226

Essential Linux for the SQL Server DBA

Back to calendar

Event Date: 19-05-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Kellyn Pot'Vin-Gorman

Title: Essential Linux for the SQL Server DBA

Abstract:

Linux has come to Microsoft! Do you want to gain the knowledge that Oracle DBAs have been using for years to manage their databases on this valuable OS?

This session is taught by a multi-platform DBA who specializes in Oracle and SQL Server with almost two decades on Unix/Linux experience. The goal is to give you the most valuable fundamentals and commands that are important to the DBA when managing a database in a Non-Windows environment. We’ll learn:

Linux history and concepts.
Important differences between systems
Crucial commands to get around a. Navigating, searching and managing b. Monitoring, tracing and updating c. Editing and scripting

You’ll leave feeling more at ease with Linux and have plenty of content and links to continue the learning after the session!

SessionID: 74443

Use PowerShell and dbatools to Manage your SQL Server Environment

Back to calendar

Event Date: 19-05-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Garry Bargsley

Title: Use PowerShell and dbatools to Manage your SQL Server Environment

Abstract:

Did you know there is an amazing open source community driven to make your SQL DBA life easier? The PowerShell dbatools suite not only save you time, but will provide you a better understanding of how your environment is configured.

In this session, you will learn how to standardize, monitor and alert on your environment when SQL Server settings fall out of best practices, using tools provided in the dbatools suite.

SessionID: 77160

Think Like a Certification Exam

Back to calendar

Event Date: 19-05-2018 - Session time: 11:00:00 - Track: Professional Development

Speaker: William Assaf

Title: Think Like a Certification Exam

Abstract:

Do you want insight into how certification exams are written, how questions are designed, and how to follow a logical process of elimination? We'll go through the process of item creation, what rules writers must follow, and review some sample questions together. We'll leave time for QA with a veteran of the Microsoft certification exam writing process.

SessionID: 77976

Transactional Replication New Features for AlwaysOn AG in SQL 2017

Back to calendar

Event Date: 19-05-2018 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Henry Weng

Title: Transactional Replication New Features for AlwaysOn AG in SQL 2017

Abstract:

SQL Server Transactional Replication is one of the most "mature" technology that is widely used to replicate data with a high degree of flexibility, which other solutions don't offer. By design it is not a HA/DR solution like SQL Server AlwaysOn FCI or AG. In this session we will include:

Overview of HA/DR solution for databases with Transactional Replication configured
How Transactional Replication works with AlwaysOn AG, including options and supported scenarios
Demonstrate Transactional Replication new features in SQL 2017 - Deploy distributor in AlwaysOn AG

SessionID: 77985

Introduction to Biml

Back to calendar

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

Speaker: Tim Mitchell

Title: Introduction to Biml

Abstract:

Have you ever needed to generate dozens (or even hundreds) of similar SSIS packages? Do you ever find yourself needing to regenerate a lot of packages when some piece of the upstream data format changes? Using native SSIS, this can be a tedious and error prone exercise. However, using Biml (Business Intelligence Markup Language) can greatly increase your productivity as an ETL developer.

In this session, we'll cover the essentials of Biml. I'll discuss what it is and what it can do for SSIS, demonstrating how it can easily generate dozens or even hundreds of packages in just a few minutes. I'll also demonstrate some realistic examples and discuss how Biml fits into the enterprise ETL picture.

SessionID: 78044

New Features in SQL That Will Change the Way You Tune

Back to calendar

Event Date: 19-05-2018 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Lance Tidwell

Title: New Features in SQL That Will Change the Way You Tune

Abstract:

Since the new cardinality estimator was released in SQL Server 2014, every version on SQL has introduced new great features design to help your queries run at max performance. In 2016, it was Query Store; in 2017, Adaptive Query Processing and Automatic Tuning have been introduced.

In this session we will explore these new features and how they can make your life easier. We will also look at some of the pitfalls and potential issues that can arise from these new features.

SessionID: 78145

QuickStart on embedding PowerBI reports in your line of business applications

Back to calendar

Event Date: 19-05-2018 - Session time: 11:00:00 - Track: Analytics and Visualization, BI Delivery

Speaker: Tejpal Thatte

Title: QuickStart on embedding PowerBI reports in your line of business applications

Abstract:

In this session, we’ll explore the need that organizations have to be able to embed PowerBI reports and dashboards into their existing LOB applications and how PowerBI reports and dashboards can be embedded in the same, may it be internal applications or external customer facing applications.

SessionID: 71851

Dynamic SQL: Tables, Pivots, Parameters More

Back to calendar

Event Date: 19-05-2018 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Steven Tidwell

Title: Dynamic SQL: Tables, Pivots, Parameters More

Abstract:

Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you to design solutions, pass parameters and allows you build a single query on values passed. Dynamic SQL has both pros and cons to it's design, but can also be a helpful tool. This presentation will walk through the steps of building dynamic tables, aggregating data in a pivot format and give you the first steps of writing a Dynamic Query. We will also see how to use Dynamic SQL to build multiple databases across servers, alter a single table in multiple servers and add columns to a table, all through the magic of Dynamic SQL.

SessionID: 72972

How to transition from Profiler to Extended Events and why you should consider.

Back to calendar

Event Date: 19-05-2018 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Dainius Sutkevicius

Title: How to transition from Profiler to Extended Events and why you should consider.

Abstract:

Let me ask you, what comes to your mind when you hear / read phrase SQL Server Extended Events? You may be thinking: "What is it, what does it do?", "I don’t have time to learn this", "I already have the tool that does all I need", "It’ll require too much coding", "There is no way Extended Events can do what SQL Profiler does."

Why don’t we take a closer look using straightforward examples in order to figure out what it’s all about, because learning Extended Events is fun and easy.

In this session we will cover the following: -- How to create an extended event session using an existing trace. -- How to create XE (Extended Events) in UI (User interface) from the ground up. -- How to analyze the data. -- What to watch out for in terms of performance.

SessionID: 73010

Code Like a Snake Charmer - Intro to Python!

Back to calendar

Event Date: 19-05-2018 - Session time: 13:15:00 - Track: Analytics and Visualization, BI Delivery

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

Becoming the MVP: Soft Skills for the Hard Market

Back to calendar

Event Date: 19-05-2018 - Session time: 13:15: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: 73927

Security, Hypocrisy, and Standards, "OH MY" or How to hack your data center in three easy steps.

Back to calendar

Event Date: 19-05-2018 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Guarnieri

Title: Security, Hypocrisy, and Standards, "OH MY" or How to hack your data center in three easy steps.

Abstract:

SessionID: 74516

Encryption: Not just for the NSA anymore

Back to calendar

Event Date: 19-05-2018 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Blinn

Title: Encryption: Not just for the NSA anymore

Abstract:

SessionID: 77117

Loading SQL Server Data with Powershell

Back to calendar

Event Date: 19-05-2018 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Loading SQL Server Data with Powershell

Abstract:

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

SessionID: 77768

Automating Azure Analysis Services

Back to calendar

Event Date: 19-05-2018 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Greg Galloway

Title: Automating Azure Analysis Services

Abstract:

The elasticity of the cloud lets you provide a better user experience instead of breaking the bank running your solution at the highest scale 24 hours a day. This demo-heavy session will show how to automate Azure Analysis Services. We will look at solutions to the following questions: How do you schedule a refresh of the data in your Azure Analysis Services model? How do you pause the server on the weekends? Better yet, how can you pause it when the last user disconnects and start it automatically when the first user connects in the morning? How do you scale to meet peak demand each day? How can Azure Analysis Services load balance across servers in multiple countries so that the user connects to the geographically closest server? How do you extend your on-premises SSAS solution into Azure Analysis Services?

SessionID: 78000

Should This Be Normalized? When Database Normalization Seems Abnormal

Back to calendar

Event Date: 19-05-2018 - Session time: 13:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Chris Voss

Title: Should This Be Normalized? When Database Normalization Seems Abnormal

Abstract:

Ever since database normalization was introduced as a concept by Edgar Codd, there has been continuous debate on how far we should go to eliminate data redundancy. A new developer may be asking why there is a need to create multiple tables, and a DBA may be concerned that performance is being sacrificed. In this semi-interactive talk, we’ll discuss 1st, 2nd, 3rd, and Boyce-Codd Normal Forms, evaluate the pros and cons of normalization and denormalization for integrity and performance, and run through some demos involving scenarios of various data model formats. All to answer the question, "should...this...be...normalized?"

SessionID: 71610

Troubleshooting SQL Server Performance

Back to calendar

Event Date: 19-05-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Stacy Gray

Title: Troubleshooting SQL Server Performance

Abstract:

Microsoft SQL Support Engineers troubleshoot performance issues all day, every day. They use a set of tools that not only gather all the data necessary to troubleshoot any performance issue, but the tools also analyze the data and generate visually attractive reports. These tools have been available to the public for free for years. This presentation explains the tools, how to run them and how to interpret the results, including how to determine disk latency root cause, top reasons for high cpu, and what to do when you have excessive waits.

SessionID: 71673

Intro to Query Store

Back to calendar

Event Date: 19-05-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Intro to Query Store

Abstract:

In this session, we will look at the new Query Store feature in SQL Server 2016 and 2017. 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 in 2016.

Then in 2017, Microsoft added wait stats per query plan and Automatic Tuning capabilities. Allowing DBAs more tools to troubleshoot fires with and a way to automatically resolve issues.

In this session we will walk through the features of Query Store, so you can understand how to use them in SQL Server 2016 and 2017.

SessionID: 73045

Experience SQL Server on Linux and Containers

Back to calendar

Event Date: 19-05-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Bob Ward

Title: Experience SQL Server on Linux and Containers

Abstract:

SQL Server 2017 is all about choice. It now runs on the most popular platforms in the world: Windows, Linux, and Docker Containers. In this session we will focus on the specific features, architecture, and guidance for running SQL Server on Linux and Docker Containers. You will walk away with an understanding of how we built SQL Server on Linux and how it runs in a unique way that allows developers to focus on their applications vs the specifics of the design. We will also look at how Docker Containers work so you can see the unique value proposition this provides to developers using SQL Server.

SessionID: 74144

Beginning Admin: The Care and Feeding of SQL Server

Back to calendar

Event Date: 19-05-2018 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Jennifer McCown

Title: Beginning Admin: The Care and Feeding of SQL Server

Abstract:

Design and development may be exciting, but database administration is absolutely critical (and, reasonably well-paying!) The care and feeding of a server tends to get short-changed or neglected. In this class, we'll cover the basics of the big five administrator tasks:

Backups – You must set up regular backups, to keep copies of your databases...just in case something breaks, or someone makes a bad, bad mistake.
Integrity checks – Regularly and automatically check databases for corruption, which is when bits get scrambled, lost, and ruined.
Index maintenance – Databases need regular upkeep so they'll continue to run well.
Disk management – It's actually your job to find out about full disks before they happen. After all, databases grow!
Alerting – Alerts tell you what's wrong, so you don't have to go looking for problems.

Being a database administrator is a big job, but we can cover the basics in one session!

SessionID: 77082

Performance Tuning for Salary Negotiations

Back to calendar

Event Date: 19-05-2018 - Session time: 14: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: 77561

Data Security in Power BI

Back to calendar

Event Date: 19-05-2018 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Steve Hughes

Title: Data Security in Power BI

Abstract:

As more enterprises adopt Power BI into their BI environment, questions still remain about data security when working with the Power BI Service. During this webinar, we will handle a number of these concerns and point out shortcomings that still exist. How does Power BI Premium impact security? (Hint: It’ not just about licensing). We will also take a closer look at auditing, App Workspaces, and Power BI Apps during this session.

Due to the frequent changes to Power BI, improvements to data security are common within the platform as it matures. We will discuss data security and compliance within the platform including data classification, privacy levels, and other settings which help to manage your data security.

SessionID: 77770

Whats New in SQL Server 2017

Back to calendar

Event Date: 19-05-2018 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Jayaprakash Jothiraman

Title: Whats New in SQL Server 2017

Abstract:

In this talk I will give an overview of newest features as well as updated features now available in SQL Server 2017 including following topic.

Adaptive Query Processing:  
Dynamic memory Grant  
Interleaved Execution 
AlwaysOn enhancements in SQL Server 2017
Select Into 
In Memory improvements

SessionID: 78047

AWS Aurora from a SQL Server DBA's perspective

Back to calendar

Event Date: 19-05-2018 - Session time: 14:30:00 - Track: Cloud Application Development Deployment

Speaker: Michael Bourgon

Title: AWS Aurora from a SQL Server DBA's perspective

Abstract:

AWS Aurora sounds perfect - a magical in-the-cloud relational database where everything Just Works. And while that's true to an extent, it's still MySQL behind the scenes, and there's some things to keep in mind. Join us as we discuss the advantages, disadvantages, promises, realities. We'll also look at ways to monitor performance, track code changes, and investigate what's going on behind the scenes. There will be demos, SQL code, Powershell and more.

SessionID: 78089

Azure Data Factory V2 and SSIS Automation With Biml

Back to calendar

Event Date: 19-05-2018 - Session time: 14:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Stein

Title: Azure Data Factory V2 and SSIS Automation With Biml

Abstract:

SSIS was originally designed to work in a world where all data was structured and on premise. As modern enterprise data projects increasingly move online, tools like Azure Data Factory (ADF) can extend SSIS capabilities to the cloud. Azure Data Factory is a flexible and powerful cloud based ETL service, but it doesn't replace the functionality of SSIS.

In this session you will learn the advantages and disadvantages of both ETL platforms; how to use both in tandem to maximize productivity; and how both ETL platforms, as well as any supporting structures, can be be automatically generated with Biml Script.

All of the code used in this presentation can be downloaded by attendees, customized, and used in their production environments.

SessionID: 71887

Getting started with Tabular Analysis Services

Back to calendar

Event Date: 19-05-2018 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Thomas LeBlanc

Title: Getting started with Tabular Analysis Services

Abstract:

This session will give the basics of starting a tabular model with Analysis Services 2016/2017 and PivotTables from Excel. We will start by opening the Visual Studio environment to create a Solution/Project. The Fact and Dimension tables will be imported and Filtered. Basic attribute and hierarchies will be created along with some calculations on the fact data. The Deployed project will be previewed in Excel and Power BI.

SessionID: 72016

SQL Unit Testing with T-SQLt

Back to calendar

Event Date: 19-05-2018 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Kevin Trojanowski

Title: SQL Unit Testing with T-SQLt

Abstract:

Unit testing is an important part of application development and maintenance. Knowing that your latest change is not only providing the desired results but also is free from side-effects is critical to the rapid pace expected by your customers. This session will provide an introduction in to how you can easily create a library of unit tests around your database and its programmable objects.

SessionID: 72036

SQL Server on Linux : Troubleshooting tips and tricks

Back to calendar

Event Date: 19-05-2018 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Suresh Kandoth

Title: SQL Server on Linux : Troubleshooting tips and tricks

Abstract:

Starting with SQL Server 2017, you can deploy the software on Windows, Linux and Mac. In this session, you will learn about the different troubleshooting approaches for SQL Server on Linux. These include a walkthrough of tools and commands available in the OS and SQL Server that is appropriate for each scenario. We will take a look at couple of common scenarios/issues that we expect you to encounter in SQL Server on Linux the best approach to troubleshoot and resolve them. We will briefly touch on best practices and frequently asked questions.

SessionID: 72613

That's bad mkay!

Back to calendar

Event Date: 19-05-2018 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Kris Hokanson

Title: That's bad mkay!

Abstract:

We've all heard that things like nested views, cursors, and under/over-indexed tables are bad...but why? What is the real cost of the badness that abounds in the database world? What's really going on when you run that query against a view of a view of a view. How can you quantify what happens when that cursor ends up running the same simple query thousands of times. And how can indexes really impact the way SQL Server decides to solve your queries. In this session we'll talk about the basics of how to read query plans and use extended events to understand why all these things can be big resource drains on a SQL Server. Good times should be had by all.

SessionID: 72616

AlwaysOn on 2012/2014/2016/2017 Notes from the field and Best Practice

Back to calendar

Event Date: 19-05-2018 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Reinaldo Kibel

Title: AlwaysOn on 2012/2014/2016/2017 Notes from the field and Best Practice

Abstract:

CIOs and VPs everywhere are asking me, how do we achieve HA with SQL Server? Having architected and implemented over 100 architectures, see how to architect, design, setup, deploy, tons of gotchas and best practices from real production deployments With the introduction of AlwaysOn and the deprecation of Database Mirroring, Windows Clustering Services is now more critical than ever. If you have moved away from clustering or implemented database mirroring as an alternative to clustering and found it lacking AlwaysOn is the way forward for you. This talk will demonstrate a complete end-to-end solution using Windows Server Failover Clustering, AlwaysOn, SQL Server 2017 Enterprise edition, and Active Directory.

SessionID: 73212

3 Lessons Learned in Successful Consulting

Back to calendar

Event Date: 19-05-2018 - Session time: 15:45:00 - Track: Professional Development

Speaker: Mohammad Darab

Title: 3 Lessons Learned in Successful Consulting

Abstract:

SessionID: 75758

Fundamentals That Will Improve Your Query Performance!

Back to calendar

Event Date: 19-05-2018 - Session time: 15:45:00 - Track: Application Database Development

Speaker: John Wells

Title: Fundamentals That Will Improve Your Query Performance!

Abstract:

Time and time again the same misunderstandings by developers and query writers appear when query performance issues arise. In this demo heavy presentation, we will review these specific topics such as data types, implicit conversions, sargability, and some others that all have an impact on query performance. Come join me and by the end of this session you will have the knowledge to boost your query performance!

SessionID: 78076

The Life Cycle of a Query in Virtual Reality

Back to calendar

Event Date: 19-05-2018 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Todd Kleinhans

Title: The Life Cycle of a Query in Virtual Reality

Abstract:

How would you like to learn about using Virtual Reality (VR) to present information? The ability to become immersed and walk around inside of a VR environment is a new and unique way to present and look at information. As data professionals we need to be open to novel displays of data and explore what VR can do that for us that we have not been able to do in the past. VR can provide a way for people to see relationships and interact among data sets which can be difficult for computers to display visually on a flat screen.

The Life Cycle of a Query in Virtual Reality is built using Epic Games video game engine called Unreal Engine 4 (UE4). With native support for VR, UE4 has been used for applications beyond just video games. With the commercial availability of affordable VR headsets, data professionals can now create visually compelling environments that were almost impossible or extremely expensive just a few years ago on both PC and mobile devices.

SessionID: 80605

"Real World" examples on loading a data warehouse using SSIS

Back to calendar

Event Date: 19-05-2018 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ryan Casey

Title: "Real World" examples on loading a data warehouse using SSIS

Abstract:

In this demo-heavy session we will discuss the value of a SSIS Framework, explore forward engineering benefits, and demonstrate SSIS design patterns on loading SQL structures when developing Data Warehouses, SSAS Cubes, and Power BI Analytics.

An outline of the subject matter to be covered is below:

Live Demo SSIS Framework ● Load Error Meta Data ● Restart ability, Rollback, Reload Count ● Master Load ID, LoadID, ExecutionID (SSISDB), Refresh ● Package Sequencing and Signatures ● Connections, Expressions, Parameters, Event Handlers ● Alerting (SMTP), Error Flows (XML Destination Script)

Forward Engineering SQL Structures (Examples from Most Popular Modeling Tools) ● Relationships, Primary Foreign Keys ● Data Types, Nullability, Indexes

Fully Functional Demos for Multiple Design Patterns ● Dimensions ● Slowly Changing ● Facts ● Inserts, Updates, Deletes ● Bridges / Snowflakes

This site is open source. Improve this page.