Nr: 629
SQLSaturday #629 - Indianapolis 2017
| Start Time (24h) |
Speaker |
Track |
Title |
| 08:00:00 |
Vladimir Oselsky |
Application Database Development |
Crash Course on Better SQL Development |
| 08:00:00 |
Sean Werick |
Application Database Development |
SQL Server 2016: Data Masking and Encryption |
| 08:00:00 |
Kevin Feasel |
Enterprise Database Administration Deployment |
Securing SQL Server |
| 08:00:00 |
Drew Furgiuele |
Application Database Development |
SQL Server and PowerShell: Let's Get Serious |
| 08:00:00 |
Dave Mattingly |
Cloud Application Development Deployment |
Alexa, Talk to Me |
| 08:00:00 |
Dave Bland |
Enterprise Database Administration Deployment |
Extended Events: What are they and How do I use them |
| 08:00:00 |
Britton Gray |
BI Platform Architecture, Development Administration |
MPP – Master Parallel Productivity in Azure SQL DW |
| 08:00:00 |
Martin Madsen |
Analytics and Visualization |
An Adventure Works IoT Demo: moving beyond sales data |
| 08:00:00 |
Stan Siranovich |
Analytics and Visualization |
SQL into R: an Absolute Beginners' Guide to R for the SQL User |
| 08:00:00 |
Warren Sifre |
SQL Starter Track |
Introduction to Big Data |
| 09:15:00 |
Ross LoForte |
Enterprise Database Administration Deployment |
Find out why SQL Server 2016 Service Pack 1 is an Industry Game changer |
| 09:15:00 |
Frank Gill |
Strategy and Architecture |
Anatomy of a Transaction |
| 09:15:00 |
Warren Sifre |
Cloud Application Development Deployment |
Introduction to Azure Streaming Analytics |
| 09:15:00 |
Ben Miller |
Enterprise Database Administration Deployment |
Managing Availability Groups with PowerShell |
| 09:15:00 |
David Mellinger |
BI Platform Architecture, Development Administration |
SQL Server 2017 New BI Features |
| 09:15:00 |
Brandon Lukes |
Enterprise Database Administration Deployment |
SSMS Tips and Tricks |
| 09:15:00 |
Alan Dykes |
Analytics and Visualization |
Getting Started with R and R Services |
| 09:15:00 |
Pat Phelan |
Professional Development |
Ethics, Morals, and Laws for the DBA 101 |
| 09:15:00 |
David Maxwell |
SQL Starter Track |
Introduction to Database Administration |
| 10:30:00 |
Ed Watson |
BI Platform Architecture, Development Administration |
Introduction to SQL Server Integration Services |
| 10:30:00 |
Wylie Blanchard |
BI Information Delivery |
MS SSAS Business Value: Should I choose Tabular or Multidimensional? |
| 10:30:00 |
Aaron Cutshall |
Strategy and Architecture |
Introduction to Relational Database Design Patterns |
| 10:30:00 |
Samir Behara |
Application Database Development |
Increase Your Coding Speed in SQL Server Management Studio |
| 10:30:00 |
Peter Shore |
Cloud Application Development Deployment |
SELECT Provider FROM Cloud |
| 10:30:00 |
Ben Miller |
Enterprise Database Administration Deployment |
SQL Server Encryption |
| 10:30:00 |
David Maxwell |
Application Database Development |
Handling Temporal Data in SQL Server 2016 |
| 10:30:00 |
Tamera Clark |
Enterprise Database Administration Deployment |
Reduce your DBA ( DEV) task list by using Microsoft BI tools |
| 10:30:00 |
Robert Verell |
Strategy and Architecture |
Right-Size Your Data Files |
| 10:30:00 |
Stan Siranovich |
SQL Starter Track |
Introduction to Data Science |
| 10:30:00 |
Sean Werick |
SQL Starter Track |
Introduction to Data Science |
| 11:45:00 |
Matt Henderson |
Other |
Architecting for Performance |
| 13:00:00 |
Jonathan Stewart |
Analytics and Visualization |
Data Visualization: How to truly tell a great story! |
| 13:00:00 |
Armando Lacerda |
Enterprise Database Administration Deployment |
Unleashing Stretched Databases |
| 13:00:00 |
Amber Goins |
Professional Development |
Using SQL as the Key to Robust Automation |
| 13:00:00 |
Wendy Pastrick |
Application Database Development |
Read Dirty to Me - Isolation Levels/User Impact |
| 13:00:00 |
Stacy Hein |
Strategy and Architecture |
Installing SQL Server on Linux in AWS |
| 13:00:00 |
Robert Verell |
Application Database Development |
SQL Election: Which Tech is Faster? |
| 13:00:00 |
Kerry Tyler |
BI Platform Architecture, Development Administration |
45 Minutes to Your First SSAS Tabular Model |
| 13:00:00 |
Ed Leighton-Dick |
Enterprise Database Administration Deployment |
How to Keep Your Databases Secure in Just Minutes a Day |
| 13:00:00 |
Aaron King |
SQL Starter Track |
Introduction to Database Development |
| 13:00:00 |
Peter Shore |
Enterprise Database Administration Deployment |
The Data-Professional’s Junk Drawer |
| 13:00:00 |
Alan Dykes |
Other |
Game of Thrones Discussion |
| 14:15:00 |
Denis McDowell |
Application Database Development |
Stop Ignoring the SQL Server Resource Governor |
| 14:15:00 |
Greg Deckler |
Advanced Analysis Techniques |
It's a Machine World - Predictive Analytics with Azure Machine Learning |
| 14:15:00 |
Shannon Lowder |
BI Platform Architecture, Development Administration |
Advanced Biml Concepts |
| 14:15:00 |
Tracy Boggiano |
Enterprise Database Administration Deployment |
Query Store Primer |
| 14:15:00 |
Stacia Varga |
Analytics and Visualization |
Getting Your Story Straight with Data Visualizations |
| 14:15:00 |
Andrew Loree |
Enterprise Database Administration Deployment |
SQL Server 2017 (Linux and Beyond) |
| 14:15:00 |
Dan (Annie) Xu |
BI Information Delivery |
From SQL to DAX – another way of extract data |
| 14:15:00 |
Jay Robinson |
Application Database Development |
Partitioned Tables and Query Performance |
| 14:15:00 |
Kerry Tyler |
SQL Starter Track |
Introduction to Business Intelligence |
| 14:15:00 |
Eddie Wuerch |
Enterprise Database Administration Deployment |
Never Lose Data! Digging Out From Corruption |
| 15:30:00 |
Brian Beswick |
BI Platform Architecture, Development Administration |
SSAS 2016 Tabular - Diving into the new features |
| 15:30:00 |
Ryan Wade |
Advanced Analysis Techniques |
Leveraging SQL Server R Services to Perform Advanced Analytics |
| 15:30:00 |
Stacia Varga |
Analytics and Visualization |
Where Does R Fit Into Your SQL Server Stack? |
| 15:30:00 |
Rob Volk |
Application Database Development |
Tame Your Unruly Data With Constraints |
| 15:30:00 |
Chris Koester |
BI Platform Architecture, Development Administration |
Working with JSON in SQL Server 2016 |
| 15:30:00 |
Joe McTaggart |
Strategy and Architecture |
Availablity Groups in SQL 2016 and beyond: Faster, Higher, Stronger |
| 15:30:00 |
Gareth Swanepoel |
BI Platform Architecture, Development Administration |
SQL Server ColumnStore Indexes |
| 15:30:00 |
Armando Lacerda |
Enterprise Database Administration Deployment |
SQL Server Tricks for Storage and I/O Performance in the cloud |
| 15:30:00 |
John Deardurff |
SQL Starter Track |
How to get Microsoft Certified |
SessionID: 61091
Crash Course on Better SQL Development
Event Date: 12-08-2017 - Session time: 08:00:00 - Track: Application Database Development
Speaker: Vladimir Oselsky
Title: Crash Course on Better SQL Development
Abstract:
SessionID: 61095
SQL Server 2016: Data Masking and Encryption
Event Date: 12-08-2017 - Session time: 08:00:00 - Track: Application Database Development
Speaker: Sean Werick
Title: SQL Server 2016: Data Masking and Encryption
Abstract:
Learn about data masking and encryption, the pros and cons of each, as well as when to use which.
SessionID: 61244
Securing SQL Server
Event Date: 12-08-2017 - Session time: 08:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Kevin Feasel
Title: Securing SQL Server
Abstract:
SessionID: 61272
SQL Server and PowerShell: Let's Get Serious
Event Date: 12-08-2017 - Session time: 08:00:00 - Track: Application Database Development
Speaker: Drew Furgiuele
Title: SQL Server and PowerShell: Let's Get Serious
Abstract:
Whether you've dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell is something worth learning to make your life as a SQL Server professional easier. Whether you're a DBA, a SSIS developer, or security professional, In this session you'll see practical, real world examples of how you can blend SQL Server and PowerShell together, and not just a bunch of regular T-SQL tasks that have been made more complicated.
SessionID: 63151
Alexa, Talk to Me
Event Date: 12-08-2017 - Session time: 08:00:00 - Track: Cloud 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: 63332
Extended Events: What are they and How do I use them
Event Date: 12-08-2017 - Session time: 08:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Dave Bland
Title: Extended Events: What are they and How do I use them
Abstract:
Since Extended Events are replacing Profiler, 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: 63688
MPP – Master Parallel Productivity in Azure SQL DW
Event Date: 12-08-2017 - Session time: 08:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Britton Gray
Title: MPP – Master Parallel Productivity in Azure SQL DW
Abstract:
We will discuss and demonstrate the MPP (massively parallel processing) architecture of Azure SQL DW and how to make best use of this exciting technology, including:
• Getting up and running
• Loading and migrating data
• Dynamically scaling performance
• Designing tables and optimizing queries to extract maximum performance
• Integrating with big data
SessionID: 65806
An Adventure Works IoT Demo: moving beyond sales data
Event Date: 12-08-2017 - Session time: 08:00:00 - Track: Analytics and Visualization
Speaker: Martin Madsen
Title: An Adventure Works IoT Demo: moving beyond sales data
Abstract:
This session will cover a potential IoT use case demonstration. I describe how to simulate IoT data and then utilize that simulated data to tell business use stories. I use the classic Adventure Works SQL database as the launch point that is then enriched with the simulated IoT data.
SessionID: 66527
SQL into R: an Absolute Beginners' Guide to R for the SQL User
Event Date: 12-08-2017 - Session time: 08:00:00 - Track: Analytics and Visualization
Speaker: Stan Siranovich
Title: SQL into R: an Absolute Beginners' Guide to R for the SQL User
Abstract:
SQL data can be exported to any number of data manipulation, visualization, and reporting packages, including R. But what, exactly, is R and why would anyone consider it when there are already so many other choices available? We will answer those questions by considering: (1) what is R? (2) how does it work? (3) why is it so popular (4) what is so special about it?
We will do this using side-by-side examples of R and SQL code, and by using the "pipe" operator in R to connect several operations to analyze a publicly-available data set. By the end of this session, the attendees will have the previous questions answered and be able to decide whether to consider R, or to stay with their current solution.
SessionID: 66987
Introduction to Big Data
Event Date: 12-08-2017 - Session time: 08:00:00 - Track: SQL Starter Track
Speaker: Warren Sifre
Title: Introduction to Big Data
Abstract:
This session is part of the SQL Starter track that will present an Introduction to Big Data.
SessionID: 61116
Find out why SQL Server 2016 Service Pack 1 is an Industry Game changer
Event Date: 12-08-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Ross LoForte
Title: Find out why SQL Server 2016 Service Pack 1 is an Industry Game changer
Abstract:
Key Learning:
Learn the new features made available with SQL Server 2016 SP1 Standard Edition
Develop more powerful application that were not possible before with Standard Edition
Learn how to upgrade to SQL Server 2016 Service Pack 1
SessionID: 61616
Anatomy of a Transaction
Event Date: 12-08-2017 - Session time: 09:15:00 - Track: Strategy and Architecture
Speaker: Frank Gill
Title: Anatomy of a Transaction
Abstract:
In SQL Server, the transaction log is the most important file in any database. All changes to the data and schema are tracked in the transaction log. Join me to learn how to read the transaction log, how to follow a transaction as is processes, and how SQL Server handles a transaction rollback. You will also learn how to identify the resources and objects SQL Server accesses during the course of the transaction. Finally, you will see how SQL Server processes transactions for In-Memory tables.
SessionID: 62934
Introduction to Azure Streaming Analytics
Event Date: 12-08-2017 - Session time: 09:15:00 - Track: Cloud Application Development Deployment
Speaker: Warren Sifre
Title: Introduction to Azure Streaming Analytics
Abstract:
This session will cover what is Streaming Analytics and the various use cases. We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review. The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.
SessionID: 64099
Managing Availability Groups with PowerShell
Event Date: 12-08-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Ben Miller
Title: Managing Availability Groups with PowerShell
Abstract:
SQL Server Always On Availability Groups are all the craze. When you have a need to failover or modify a configuration there are some things that you can only do with PowerShell. Aside from these items, PowerShell can completely manage an AG. Join me for a demo filled session where we will create an Always On Availability Group from scratch to management with PowerShell, including the Windows Server Failover Cluster. From changing parameters to failover, we will have a blast using PowerShell with ease of use to make your life better. Let’s work smarter and not harder when managing this great feature of SQL Server.
SessionID: 65313
SQL Server 2017 New BI Features
Event Date: 12-08-2017 - Session time: 09:15:00 - Track: BI Platform Architecture, Development Administration
Speaker: David Mellinger
Title: SQL Server 2017 New BI Features
Abstract:
SessionID: 66713
SSMS Tips and Tricks
Event Date: 12-08-2017 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Brandon Lukes
Title: SSMS Tips and Tricks
Abstract:
SessionID: 66758
Getting Started with R and R Services
Event Date: 12-08-2017 - Session time: 09:15:00 - Track: Analytics and Visualization
Speaker: Alan Dykes
Title: Getting Started with R and R Services
Abstract:
SessionID: 66762
Ethics, Morals, and Laws for the DBA 101
Event Date: 12-08-2017 - Session time: 09:15: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: 66989
Introduction to Database Administration
Event Date: 12-08-2017 - Session time: 09:15:00 - Track: SQL Starter Track
Speaker: David Maxwell
Title: Introduction to Database Administration
Abstract:
This session is part of the SQL Starter track and will present and Introduction to Database Administration.
SessionID: 61145
Introduction to SQL Server Integration Services
Event Date: 12-08-2017 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Ed Watson
Title: Introduction to SQL Server Integration Services
Abstract:
Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!
SessionID: 61163
MS SSAS Business Value: Should I choose Tabular or Multidimensional?
Event Date: 12-08-2017 - Session time: 10:30:00 - Track: BI Information Delivery
Speaker: Wylie Blanchard
Title: MS SSAS Business Value: Should I choose Tabular or Multidimensional?
Abstract:
Determine which model presents the right business value for your company's analytical needs. In this session we'll discuss the difference between SSAS Tabular and SSAS Multidimensional modes, feature differences as well as the benefits and cons to utilizing both modes in MS SQL Server 2016.
SessionID: 61520
Introduction to Relational Database Design Patterns
Event Date: 12-08-2017 - Session time: 10:30:00 - Track: Strategy and Architecture
Speaker: Aaron Cutshall
Title: Introduction to Relational Database Design Patterns
Abstract:
The use of design patterns has been quite popular in object-oriented development to help identify best practices for various situations. Unfortunately, this practice has not really reached the world of relational database architecture where they are just as applicable. In this session, we'll discuss some techniques and best practices that help make database design more effective and efficient not only in operation but also in design and administration. With the use of some example scenarios, you'll walk away with a better understanding of design patterns that you can apply right away!
SessionID: 61543
Increase Your Coding Speed in SQL Server Management Studio
Event Date: 12-08-2017 - Session time: 10:30:00 - Track: Application Database Development
Speaker: Samir Behara
Title: Increase Your Coding Speed in SQL Server Management Studio
Abstract:
Every developer wants to be productive and get more things accomplished during their day to day work. Given a choice between working harder and working smarter, you will most likely choose the latter. But the big question is – How do you boost your productivity? How do you reduce your development time? How do you increase your coding speed?
Be it a T-SQL developer or DBA, we spend most of our time working in SQL Server Management Studio. In this session, we will learn a number of tips and tricks to increase productivity and efficiency in SSMS IDE. We will also look at the new and improved features of SSMS 2016. We will learn how adding few free third party tools to the SSMS IDE will enhance your coding speed. This will be a content rich session with plenty of live demonstrations.
By the end of this session, you will learn some useful techniques to take back with you and apply in your day to day work.
SessionID: 62850
SELECT Provider FROM Cloud
Event Date: 12-08-2017 - Session time: 10:30:00 - Track: Cloud Application Development Deployment
Speaker: Peter Shore
Title: SELECT Provider FROM Cloud
Abstract:
SessionID: 64100
SQL Server Encryption
Event Date: 12-08-2017 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
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: 64290
Handling Temporal Data in SQL Server 2016
Event Date: 12-08-2017 - Session time: 10:30:00 - Track: Application Database Development
Speaker: David Maxwell
Title: Handling Temporal Data in SQL Server 2016
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. Solutions like Change Data Capture or trigger-based audit tables can be slow, or require a lot of extra code to be effective. Fortunately, SQL Server 2016 introduces system-versioned tables, also known as Temporal Tables, which track data through time with far less overhead than other solutions. In this session, you'll learn how to create temporal tables, how SQL Server manages data within those tables, and how to query data at a specific point in time using several real-world examples.
SessionID: 66146
Event Date: 12-08-2017 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Tamera Clark
Abstract:
Are you working without fancy monitoring and reporting tools? Do you dream of having time to pull data into Excel ans show you management staff what is going on? Do you run queries to answer questions for projects or at the department's request on a regular basis? Wanna know what is going on with your report server?
Come to this "BI for the Engine Guy" session and let me help you make visualizations for all your engine's health care needs and your user's (customer) data demands.
SessionID: 66771
Right-Size Your Data Files
Event Date: 12-08-2017 - Session time: 10:30:00 - Track: Strategy and Architecture
Speaker: Robert Verell
Title: Right-Size Your Data Files
Abstract:
In this session we'll look into why having multiple files for databases and filegroups is important, even on solid state drives. Then we'll look into some scripts and tools that will assist us in transforming our databases to be right-sized for performance considerations.
SessionID: 66988
Introduction to Data Science
Event Date: 12-08-2017 - Session time: 10:30:00 - Track: SQL Starter Track
Speaker: Stan Siranovich
Title: Introduction to Data Science
Abstract:
This presentation is part of the SQL Starter Track an will give an Introduction to Data Science.
SessionID: 68730
Introduction to Data Science
Event Date: 12-08-2017 - Session time: 10:30:00 - Track: SQL Starter Track
Speaker: Sean Werick
Title: Introduction to Data Science
Abstract:
This presentation is part of the SQL Starter Track an will give an Introduction to Data Science.
SessionID: 68617
Event Date: 12-08-2017 - Session time: 11:45:00 - Track: Other
Speaker: Matt Henderson
Abstract:
SessionID: 61125
Data Visualization: How to truly tell a great story!
Event Date: 12-08-2017 - Session time: 13:00:00 - Track: 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: 63873
Unleashing Stretched Databases
Event Date: 12-08-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Armando Lacerda
Title: Unleashing Stretched Databases
Abstract:
This is a deep dive session full of demos about SQL 2016 stretched databases feature. It will go from pre-reqs and blocking factor through deployment and disaster recovery. Everything you need to know and when to use this new cloud-based exciting capability.
SessionID: 63917
Using SQL as the Key to Robust Automation
Event Date: 12-08-2017 - Session time: 13:00:00 - Track: Professional Development
Speaker: Amber Goins
Title: Using SQL as the Key to Robust Automation
Abstract:
Kelverion Best Practices; Using a Persistent Data Store
It is Kelverion’s recommendation that in nearly every case runbook automations be implemented utilizing a small backend SQL database table or set of tables. This document explains why we make this recommendation.
Persistence
The ORCHESTRATOR data bus is extremely powerful but it is not persistent. This means that if the ORCHESTRATOR runbook server were to reboot or the services were to crash all data about executing runbooks would be lost. So a complicated multistep workflow that is counting on the data bus for its current state would need to be restarted manually by an administrator. That administrator would potentially need to take significant time to understand what parts of the workflow had run successfully and what parts were still needed. If a persistent data store is used at the backend, the last successful step in the process has been recorded in the database with all necessary information to continue the next step.
SessionID: 64081
Read Dirty to Me - Isolation Levels/User Impact
Event Date: 12-08-2017 - Session time: 13:00:00 - Track: Application Database Development
Speaker: Wendy Pastrick
Title: Read Dirty to Me - Isolation Levels/User Impact
Abstract:
Issue a "SELECT {data} FROM {myTable}" statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.
SessionID: 64094
Installing SQL Server on Linux in AWS
Event Date: 12-08-2017 - Session time: 13:00:00 - Track: Strategy and Architecture
Speaker: Stacy Hein
Title: Installing SQL Server on Linux in AWS
Abstract:
This session will discussion the strategies, pitfalls, and configuration items needed to successfully install SQL Server 2016 on Ubuntu Linux in AWS.
The session will end with a demonstration of an install of SQL Server 2016 on Linux and the tools for SQL Server.
SessionID: 66770
SQL Election: Which Tech is Faster?
Event Date: 12-08-2017 - Session time: 13:00:00 - Track: Application Database Development
Speaker: Robert Verell
Title: SQL Election: Which Tech is Faster?
Abstract:
Ever wondered what's faster between a bulk insert and BCP? What about index seek vs index scan? This session will review multiple topics of SQL Server that include development, ETL, and administration. In the spirit of our recent election, this session will feature having the ability to debate and vote on which of each technology you think we will be best, and if your "candidate" wins, your votes will be entered into a drawing; so the more votes you win the more chances you get!
SessionID: 66782
45 Minutes to Your First SSAS Tabular Model
Event Date: 12-08-2017 - Session time: 13:00:00 - Track: BI Platform Architecture, Development Administration
Speaker: Kerry Tyler
Title: 45 Minutes to Your First SSAS Tabular Model
Abstract:
SSAS Tabular is a new-ish form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, in addition to the various options for deployment, before exploring the development process of creating a tabular model ready for ad-hoc querying through Excel or Power BI.
SessionID: 66784
How to Keep Your Databases Secure in Just Minutes a Day
Event Date: 12-08-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Ed Leighton-Dick
Title: How to Keep Your Databases Secure in Just Minutes a Day
Abstract:
You’re busy. You don’t have time to check the security of your systems all the time, right? It’s not like anyone has added a user that you don’t know about. And no one would create a database and add all logins to the db_owner role. And of course, no one would ever think of setting the TRUSTWORTHY property on a database... right?
Things like that happen on a daily basis, poking holes in even the most well-secured database. Those holes are just waiting for someone to find them. That someone could be you, or it could be an attacker probing for a way to get data from your company.
In this session, we will explore how to create reports that are quick to review so you can find the holes before someone else does - without interfering with the rest of your day. Along the way, you'll also learn where to find security-related information in SQL Server's metadata and logs to allow you to customize and extend the reports to meet your company's unique needs.
SessionID: 66990
Introduction to Database Development
Event Date: 12-08-2017 - Session time: 13:00:00 - Track: SQL Starter Track
Speaker: Aaron King
Title: Introduction to Database Development
Abstract:
This session is part of the SQL Starter track and will present an Introduction to Database Development.
SessionID: 68850
The Data-Professional’s Junk Drawer
Event Date: 12-08-2017 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment
Speaker: Peter Shore
Title: The Data-Professional’s Junk Drawer
Abstract:
SessionID: 68857
Game of Thrones Discussion
Event Date: 12-08-2017 - Session time: 13:00:00 - Track: Other
Speaker: Alan Dykes
Title: Game of Thrones Discussion
Abstract:
Winter is coming! Last minute replacement session...just a fun discussion of Game of Thrones. Spoilers will be abundant so come at your own risk.
SessionID: 61199
Stop Ignoring the SQL Server Resource Governor
Event Date: 12-08-2017 - Session time: 14:15:00 - Track: Application Database Development
Speaker: Denis McDowell
Title: Stop Ignoring the SQL Server Resource Governor
Abstract:
SQL Professionals are looking for ways to increase density without increasing resource contention between workloads. The SQL Server Resource Governor is a valuable tool which is often overlooked by Developers and Database Administrators. Resource Governor feature enhancements have made it an indispensable tool for developers and architects. This session will utilize case-studies and demos to illustrate why the Resource Governor should be part of your deployment strategy.
SessionID: 62928
It's a Machine World - Predictive Analytics with Azure Machine Learning
Event Date: 12-08-2017 - Session time: 14:15:00 - Track: Advanced Analysis Techniques
Speaker: Greg Deckler
Title: It's a Machine World - Predictive Analytics with Azure Machine Learning
Abstract:
Introduces Microsoft Azure Machine Learning, explaining what Azure Machine Learning is and how it functions. Attendees are walked through a real world scenario of building and using a predictive analytics model with Azure Machine Learning. At the end of this session, attendees will understand fundamental Azure Machine Learning terminology, how to build, train and use a predictive analytics model and the key concepts around the various components used within predictive models.
SessionID: 63492
Advanced Biml Concepts
Event Date: 12-08-2017 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration
Speaker: Shannon Lowder
Title: Advanced Biml Concepts
Abstract:
After you get started with Biml you quickly find yourself getting more and more complex with your solutions. In this session, we walk through the end game of Biml. What would it take to get to full automation in your BI solutions? At the end of this session, you'll have a game plan to get to that point.
At the end we discuss the implications of automating your solutions: what do we do when we no longer need a SSIS developer?
SessionID: 63944
Query Store Primer
Event Date: 12-08-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Tracy Boggiano
Title: Query Store Primer
Abstract:
SessionID: 64281
Getting Your Story Straight with Data Visualizations
Event Date: 12-08-2017 - Session time: 14:15:00 - Track: Analytics and Visualization
Speaker: Stacia Varga
Title: Getting Your Story Straight with Data Visualizations
Abstract:
Having multiple data visualizations doesn't make it easier to choose the right one to reveal the story. Choosing the wrong visualization can obscure the story - or worse yet, distort it! In this session, learn the vocabulary of data visualization and how to apply grammar (visualization design principles) to your data. Along the way, you will also learn how to evaluate the goal of your data story and how to choose the correct visualizations that communicate this story accurately and effectively.
SessionID: 64421
SQL Server 2017 (Linux and Beyond)
Event Date: 12-08-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Andrew Loree
Title: SQL Server 2017 (Linux and Beyond)
Abstract:
Microsoft has leveled the RDBMS playing field, with SQL Server vNext (aka SQL Server 2017), allowing you to deploy and run SQL Server on a variety of operating systems and container solutions.
In this session, we will look at the background of SQL Server’s move to non-Windows platforms, cover how to install using package deployment on Linux and image-containers with Docker. Focus will cover administration and tools that you can leverage while running SQL Server on non-Windows platforms, including migration and current feature function limitations.
SessionID: 66015
Event Date: 12-08-2017 - Session time: 14:15:00 - Track: BI Information Delivery
Speaker: Dan (Annie) Xu
Abstract:
Summary: This presentation is to provide BI consultants and SQL developers with different DAX and tabular modeling solutions which can be replacements of SQL querying and high resource consuming ETL processes.
Abstract:
Many of us are coming from knowing SQL before they have been introduced with DAX or many of us know how to use tabular model through reporting tool but do not know they can use DAX as query language against a tabular model.
Thus, I am glad to provide this presentation focusing on three areas:
- How to use DAX as a query language to select columns (columns from multiple tables and from value); Group Data; Filter Data; Join Tables; Build customized calculations/measures
- How to use tracing tools to monitor the performance difference between SQL solution and DAX solution;
- Use a real life example to demonstrate how to DAX and tabular modeling (Row Contexts vs. Filter Contexts+Bridge Table+Inactive relationship+extended table) to replace high resource ETL Processes
SessionID: 66773
Event Date: 12-08-2017 - Session time: 14:15:00 - Track: Application Database Development
Speaker: Jay Robinson
Abstract:
SessionID: 66991
Introduction to Business Intelligence
Event Date: 12-08-2017 - Session time: 14:15:00 - Track: SQL Starter Track
Speaker: Kerry Tyler
Title: Introduction to Business Intelligence
Abstract:
This session is part of the SQL Starter Track and will present and Introduction to Business Intelligence.
SessionID: 68794
Never Lose Data! Digging Out From Corruption
Event Date: 12-08-2017 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment
Speaker: Eddie Wuerch
Title: Never Lose Data! Digging Out From Corruption
Abstract:
SessionID: 62871
SSAS 2016 Tabular - Diving into the new features
Event Date: 12-08-2017 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Brian Beswick
Title: SSAS 2016 Tabular - Diving into the new features
Abstract:
Taking a looking at all the new features of SSAS 2016 Tabular, how to use them effectively and avoid pitfalls. Features include Bi-Directional Cross Filtering, Parallel Partition Processing, Calculated Tables, etc.
SessionID: 63669
Event Date: 12-08-2017 - Session time: 15:30:00 - Track: Advanced Analysis Techniques
Speaker: Ryan Wade
Abstract:
In this session I will demonstrate how to productionize models developed by your data scientist via SQL Server R Services. I will demonstrate how to manage the whole process using an IDE that many of us have grown to love, Visual Studio.
SessionID: 64280
Where Does R Fit Into Your SQL Server Stack?
Event Date: 12-08-2017 - Session time: 15:30:00 - Track: Analytics and Visualization
Speaker: Stacia Varga
Title: Where Does R Fit Into Your SQL Server Stack?
Abstract:
Now that SQL Server 2016 includes support for R in the database, how does this change your BI implementation options?
In this session, we start with a brief introduction to R and explain why it’s increasingly popular, the typical development workflow, which tools you can use, common use cases, and where it fits into the latest Microsoft stack at a high level.
Then we’ll review how to implement R Services so that you can use R with SQL Server data, including how to install R packages on SQL Server, how to use rx functions, and how to operationalize R in SQL Server.
Then we explore options for using R to prepare data for analytics using SSIS or Power BI and how to report and visualize data using SSRS or Power BI.
SessionID: 64405
Tame Your Unruly Data With Constraints
Event Date: 12-08-2017 - Session time: 15:30:00 - Track: Application Database Development
Speaker: Rob Volk
Title: Tame Your Unruly Data With Constraints
Abstract:
SessionID: 66651
Working with JSON in SQL Server 2016
Event Date: 12-08-2017 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Chris Koester
Title: Working with JSON in SQL Server 2016
Abstract:
One of the many exciting new features in SQL Server 2016 is the suite of JSON functions, which allow for querying JSON text and generating JSON text from tabular data. This session will explore these new capabilities from a BI perspective. You'll learn how to load JSON text into SQL Server with SSIS, and how the new JSON functions facilitate the ELT (Extract, Load, Transform) or schema on read pattern.
SessionID: 66777
Availablity Groups in SQL 2016 and beyond: Faster, Higher, Stronger
Event Date: 12-08-2017 - Session time: 15:30:00 - Track: Strategy and Architecture
Speaker: Joe McTaggart
Title: Availablity Groups in SQL 2016 and beyond: Faster, Higher, Stronger
Abstract:
Always On Availability Groups have become the preferred HA/DR solution within SQL Server. Starting with SQL Server 2016, a number of enhancements have been made to make AGs faster, have better up time, and be more resilient. We will cover all the recent changes in Availability Groups (direct seeding, multiple automatic failover replicas, distributed AGs, load balanced secondaries, etc) and look at how they can be leveraged to create more robust HA/DR solutions.
SessionID: 67070
SQL Server ColumnStore Indexes
Event Date: 12-08-2017 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration
Speaker: Gareth Swanepoel
Title: SQL Server ColumnStore Indexes
Abstract:
Come and learn how the SQL Server 2012 feature, ColumnStore Indexes, can parallelize your Data Warehouse aggregations. I will be doing a deep dive into the inner workings of ColumnStore indexes; how they work, key characteristics, dos and don'ts, restrictions, and more. I will have some insight into how CSI's have been updated in SQL Server 2014 2016, as well.
If you are a production DBA who needs to find out more about some of the additional hot features that have been included with CSI's, like batch mode processing and data segments, then this session is for you. If you are a BI DBA or developer who needs to find out how CSI's can increase the performance of your aggregations and star-joins by up to 40 times, then this session is also for you.
SessionID: 67691
Event Date: 12-08-2017 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment
Speaker: Armando Lacerda
Abstract:
SessionID: 67694
How to get Microsoft Certified
Event Date: 12-08-2017 - Session time: 15:30:00 - Track: SQL Starter Track
Speaker: John Deardurff
Title: How to get Microsoft Certified
Abstract:
Microsoft has recently streamlined the certification process and this session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for success.