sqlsathistory

Nr: 733

SQLSaturday #733 - Atlanta 2018

Start Time (24h)	Speaker	Track	Title
08:00:00	John Deardurff	101: Beginner Level Sessions	The Vocabulary of Performance Tuning
08:00:00	Andrew Kelly	Enterprise Database Administration Deployment	A Day in the Life of the Query Store
08:00:00	Angela Henry	Application Database Development	Data Types Do Matter
08:00:00	David Bermingham	Enterprise Database Administration Deployment	SQL Server in "The Cloud": High Availability and Disaster Recovery in Azure, AWS and Google
08:00:00	Patrick LeBlanc	BI Platform Architecture, Development Administration	Introduction to Azure Analysis Services
08:00:00	Jeffrey Garbus	Enterprise Database Administration Deployment	Indexing for performance
08:00:00	Alex Grinberg	Application Database Development	XML and JSON, does the DBA need it?
08:00:00	Hilary Wilkie	Professional Development	Becoming Moused - How you can apply Disney Leadership to your Data Teams
08:00:00	Neal Waterstreet	BI Platform Architecture, Development Administration	Master Data Management with SQL Server 2016 MDS
08:00:00	Frank Gill	Cloud Application Development Deployment	Azure Managed Instance: Reducing Maintenance Costs While Making Migration Simple
09:15:00	Karlyn LeBlanc	Professional Development	Creating your Vision
09:15:00	David Maxwell	Application Database Development	Targeting Wait Statistics with Extended Events and DMVs
09:15:00	Monica Rathbun	Enterprise Database Administration Deployment	You're Stuck with Crappy Hardware, Now What?
09:15:00	Marsha Pierce	Enterprise Database Administration Deployment	Mom Rules for Managing Enterprise Database Environments
09:15:00	Dan Evans	BI Platform Architecture, Development Administration	Power BI administration made easy(ier)
09:15:00	Azhagappan Arunachalam	Enterprise Database Administration Deployment	SQL Server and Docker
09:15:00	Robert Cain	Cloud Application Development Deployment	Powering Azure SQL From PowerShell
09:15:00	Ravi Lobo	Application Database Development	A Sense of Automation
09:15:00	Marco Russo	BI Platform Architecture, Development Administration	DAX Optimization Examples
09:15:00	Michael Fal	101: Beginner Level Sessions	SQL Server Recovery Fundamentals
10:30:00	Karen Nelson	Professional Development	Why am I able to master several technology languages but I struggle in my own business language?
10:30:00	Bill Anton	BI Platform Architecture, Development Administration	What You Need To Know About Processing Tabular Models
10:30:00	Ed Watson	BI Platform Architecture, Development Administration	A Beginner's Guide to Power BI
10:30:00	Maxwell Myrick	Enterprise Database Administration Deployment	The Art and Science of Designing a Mission Critical SQL Server
10:30:00	Joseph D'Antoni	Cloud Application Development Deployment	Containers, Pods, and Databases--Learning About the Future of Infrastructure
10:30:00	Jonathan Stewart	BI Platform Architecture, Development Administration	Performance Tuning for the BI Professional
10:30:00	Louis Davidson	Application Database Development	How to Implement a Hierarchy in SQL Server
10:30:00	Carl Roepe	101: Beginner Level Sessions	How to perform a health check
10:30:00	Kevin Kline	Enterprise Database Administration Deployment	Exploring SQL Server's Plan Cache
10:30:00	Rodney Landrum	Enterprise Database Administration Deployment	The DBA Script Thumb (10 year anniversary)
11:45:00	Rie Irish	Professional Development	Well, actually... How to not be THAT guy in IT
11:45:00	Diane Schuster	BI Platform Architecture, Development Administration	Dynamic Data Flows in SSIS without Programming
11:45:00	Marsha Pierce	Enterprise Database Administration Deployment	Virtualizing SQL Server
11:45:00	Michael Fal	Enterprise Database Administration Deployment	Simplifying SQL Data Protection
11:45:00	SQL Saturday Atlanta	Other	#GetModern With Dell EMC Dominick Dequarto
11:45:00	SQL Saturday Atlanta	Other	How to Use Encryptionizer to Provide Transparent Encryption to Al
11:45:00	SQL Saturday Atlanta	Other	Using RDS SQL Server on Amazon Web Services - Richard Waymire
11:45:00	David Bermingham	Other	SANLess clustering for physical, virtual and cloud environments-
13:00:00	George Walkey	Enterprise Database Administration Deployment	Using Powershell to Document SQL Server
13:00:00	Jeff Reinhard	Enterprise Database Administration Deployment	Agile Database Development and Zero Downtime Deployments
13:00:00	Ryan Wade	BI Analysis, Visualization, and Delivery	Should You Use M or R for Data Wrangling in Power BI? It Depends.
13:00:00	Stuart Ainsworth	Professional Development	All (Data) Things Considered: The Lean Coffee Workshop
13:00:00	Eric Flamm	Enterprise Database Administration Deployment	Intro to SQL Operations Studio
13:00:00	Samir Behara	Application Database Development	DevOps, Continuous Integration Database Lifecycle Management: Rule them all
13:00:00	Michael French	BI Platform Architecture, Development Administration	Consumption Based Architecture
13:00:00	Mike Walsh	101: Beginner Level Sessions	High Availability and Disaster Recovery: Too Many Choices!
13:00:00	Kerry Tyler	Application Database Development	Managing Your Schema with Database Projects in Visual Studio
13:00:00	Eric Peterson	Enterprise Database Administration Deployment	SQL Performance and Tuning in the Amazon Cloud
14:15:00	Greg Moore	101: Beginner Level Sessions	Whoa! Backup, what happened?
14:15:00	Tim Radney	Enterprise Database Administration Deployment	Azure SQL Database for the Production DBA
14:15:00	Jana Sattainathan	Enterprise Database Administration Deployment	Monitoring with sp_WhoIsActive, PowerShell and PowerBI
14:15:00	Kathi Kellenberger	Application Database Development	T-SQL Window Function Performance
14:15:00	Shannon Lowder	BI Platform Architecture, Development Administration	Build Your Extract Packages Automatically!
14:15:00	Teo Lachev	BI Platform Architecture, Development Administration	10 Ways to Empower Your BI Strategy with Power BI
14:15:00	Mike Lawell	Cloud Application Development Deployment	Cosmos DB: Planet Earth Scale
14:15:00	Robert Verell	Enterprise Database Administration Deployment	Right-Size Your Data Files
14:15:00	Elizabeth Noble	Professional Development	How to win Dev and influence QA
14:15:00	Kevin Wilkie	Application Database Development	Even VIEWs can be sexy
15:30:00	Pritesh Ostwal	BI Platform Architecture, Development Administration	Power BI Analytics On Prem integration within your Apps
15:30:00	Anthony Nocentino	Enterprise Database Administration Deployment	Monitoring Linux Performance for the SQL Server Admin
15:30:00	Samara Soucy	101: Beginner Level Sessions	Azure Data Lake for First Time Swimmers
15:30:00	Aaron Cutshall	Application Database Development	"There Be Whales Here!" -- Big Data in SQL Server
15:30:00	Theresa Eller	BI Analysis, Visualization, and Delivery	Manipulating SharePoint Data in Power BI
15:30:00	Michael Wharton	Cloud Application Development Deployment	Create SQL Server Test Premise Environment in Azure Cloud
15:30:00	Paul Waters	Application Database Development	Getting Git
15:30:00	Shabnam Watson	BI Platform Architecture, Development Administration	SQL Server Analysis Services for the DBA
15:30:00	Joseph D'Antoni	Enterprise Database Administration Deployment	SQL Server 2017 - It Just Gets Faster
15:30:00	Paco Gonzalez	101: Beginner Level Sessions	Artificial Intelligence, Cognitive Services, and Power BI

SessionID: 71587

The Vocabulary of Performance Tuning

Back to calendar

Event Date: 19-05-2018 - Session time: 08:00:00 - Track: 101: Beginner Level Sessions

Speaker: John Deardurff

Title: The Vocabulary of Performance Tuning

Abstract:

This session is for the absolute beginner to learn the terminology of performance tuning and how queries are processed. This includes how queries are Parsed, Resolved, Optimized, Compiled and Executed. We will see how this affects Batches, Transactions, and Errors. We will also briefly discuss table structures and the differences between Heaps and Clustered Indexes. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses.

SessionID: 71842

A Day in the Life of the Query Store

Back to calendar

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

Speaker: Andrew Kelly

Title: A Day in the Life of the Query Store

Abstract:

The Query Store has now been around for a little while but there are still lots of people questioning what to do with it. We will walk thru some of the common real life scenarios in which the Query Store can help you to find and fix everyday performance problems. We will also cover the necessary TSQL along with the built in tools and reports that you should be familiar with on a day to day basis. See how the Query Store can be an effective tool in your arsenal when it comes to poor query performance.

SessionID: 72594

Data Types Do Matter

Back to calendar

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

Speaker: Angela Henry

Title: Data Types Do Matter

Abstract:

They're just numbers, right? A date's a date. It's just string data, who cares? I can't tell you how many times I've heard these phrases. This session will help you understand why choosing the correct data type for your data is so important. It affects data quality, storage and performance. It can even produce incorrect query results.

SessionID: 73006

SQL Server in "The Cloud": High Availability and Disaster Recovery in Azure, AWS and Google

Back to calendar

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

Speaker: David Bermingham

Title: SQL Server in "The Cloud": High Availability and Disaster Recovery in Azure, AWS and Google

Abstract:

If you are considering moving your SQL Server instances to "The Cloud" you will need to have a plan in place for both high availability and disaster recovery. In this session we will examine the three top public cloud providers and what they have to offer in terms of both high availability and disaster recovery. We will discuss where the providers are the same and where the differ. Some real life customer configurations will be presented. Cloud and Datacenter Management MVP Dave Bermingham will lead this session and encourages you to bring your questions specific to your environment.

SessionID: 73039

Introduction to Azure Analysis Services

Back to calendar

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

Speaker: Patrick LeBlanc

Title: Introduction to Azure Analysis Services

Abstract:

You have been wanting to using SQL Server Analysis Services, but just don't have the physical resources on-premises to set one up. Analysis Services has typically shipped with SQL Server on premises, but now it has been implemented as a fully managed service in Azure. Join this session to learn how to create a and deploy a model, load and refresh data using Azure functions, secure the model, view the model and a little about pricing.

SessionID: 73769

Indexing for performance

Back to calendar

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

Speaker: Jeffrey Garbus

Title: Indexing for performance

Abstract:

Learn all you wanted to know about index design, but were afraid to ask. This session focuses on physical index structures as well as how the server chooses indexes. Note: Join optimization is a separate session

SessionID: 74590

XML and JSON, does the DBA need it?

Back to calendar

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

Speaker: Alex Grinberg

Title: XML and JSON, does the DBA need it?

Abstract:

This session explains internal SQL Server XML processes and demonstrates how XML shredding could help to solve issues, speed up daily performance monitoring and detect problems. The difference between XML and JSON will be demonstrated, with an in-depth look at the SQL Server - JSON integration. During the session, the audience will be provided with plenty of code examples. As a bonus, a lucky winner will receive my most recent book, "XML and JSON Recipes for SQL Server".

SessionID: 77054

Becoming Moused - How you can apply Disney Leadership to your Data Teams

Back to calendar

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

Speaker: Hilary Wilkie

Title: Becoming Moused - How you can apply Disney Leadership to your Data Teams

Abstract:

Write me a query where a SQL Position/Job does not ultimately affect an end customer. The reality is that even the most isolated IT teams have multiple customers - internal and external. Disney is a world class leader in Customer Experience. In this session we will explore how Disney's approach can help us build better platforms! Learn how to define your customers and their needs, differentiate your service, envision the future, and influence change. Come be Moused - Mickey Ears Optional!

SessionID: 77776

Master Data Management with SQL Server 2016 MDS

Back to calendar

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

Speaker: Neal Waterstreet

Title: Master Data Management with SQL Server 2016 MDS

Abstract:

Want to know the position Master Data Management and MDS play in an organization's overall data strategy? We'll review the key concepts and the different roles and responsibilities to help you get your organization moving forward with MDM. We'll then take a look at the features of SQL Server 2016 MDS that make it an excellent tool for MDM. This demo-packed presentation will cover architecture and installation, different ways of processing data, hierarchies, security and many other features that will get you up and running with MDS.

SessionID: 77805

Azure Managed Instance: Reducing Maintenance Costs While Making Migration Simple

Back to calendar

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

Speaker: Frank Gill

Title: Azure Managed Instance: Reducing Maintenance Costs While Making Migration Simple

Abstract:

While Azure SQL Database provides the full feature of the SQL Server database engine, it is designed primarily for newly developed, cloud-based applications. For existing applications running on traditional SQL Server instances, the cost and complexity of migration can be prohibitive. With the release of Azure Managed Instances, much of the cost and complexity have been removed. Join me for this session to learn about the differences between Azure SQL Database and Azure Managed Instances. Additionally, discover methods for migrating existing instances to Azure.

SessionID: 71680

Creating your Vision

Back to calendar

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

Speaker: Karlyn LeBlanc

Title: Creating your Vision

Abstract:

Dreams become reality and it's time for you to create the life you want. What's your vision? Where do you see yourself in 5 years? What's the next step in your professional career? Are you living life to the fullest and doing what really makes you happy? Discover a new you and learn to succeed and live without regrets in this very interactive seminar.

SessionID: 71984

Targeting Wait Statistics with Extended Events and DMVs

Back to calendar

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

Speaker: David Maxwell

Title: Targeting Wait Statistics with Extended Events and DMVs

Abstract:

When troubleshooting overall server performance, wait statistics are a great place to start. But when your SQL Server hosts a complex set of workloads, it can be difficult to narrow down which queries are causing the most wait, and what types of wait they are causing. Fortunately, SQL Server provides easy ways for targeting which queries are causing you the most wait time. In this session, we’ll learn how to use both Extended Events, and Dynamic Management Views new to SQL Server 2016 for examining wait statistics at a query level, rather than at the server level. We’ll analyze poorly performing queries using a combination of methods and show how to quickly narrow down what SQL Server is waiting for, and why.

SessionID: 72409

You're Stuck with Crappy Hardware, Now What?

Back to calendar

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

Speaker: Monica Rathbun

Title: You're Stuck with Crappy Hardware, Now What?

Abstract:

Many of us have to deal with hardware that doesn’t meet our standards or contributes to performance problems. This session will cover how to work around hardware issues when it isn’t in the budget for newer, faster, stronger, better hardware. It’s time to make that existing hardware work for us. Learn tips and tricks on how to reduce IO, relieve memory pressure, and reduce blocking. Let’s see how compression, statistics, and indexes bring new life into your existing hardware.

SessionID: 72877

Mom Rules for Managing Enterprise Database Environments

Back to calendar

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

Speaker: Marsha Pierce

Title: Mom Rules for Managing Enterprise Database Environments

Abstract:

Have you ever looked at an environment and wondered how the heck they ever got anything done because it is so disorganized? The first thing I do for newly inherited environments is implement some organization and do some database clean up. Not only does organization make the environment easier to maintain, it can help speed up trouble shooting. Good organization can even help with some performance issues.

SessionID: 73316

Power BI administration made easy(ier)

Back to calendar

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

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

SQL Server and Docker

Back to calendar

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

Speaker: Azhagappan Arunachalam

Title: SQL Server and Docker

Abstract:

Containers are everywhere. If server virtualization dominated the past decade, then this decade belongs to the containers. Name any product, and the chances are there is a container image of that product ready to be deployed at a moment's notice. Containers can be used for hosting any type of application, and in this session, we'll take a look at what you need to know to get started with containers with respect to SQL Server, and address some of the common questions that come up during this setup.

SessionID: 73647

Powering Azure SQL From PowerShell

Back to calendar

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

Speaker: Robert Cain

Title: Powering Azure SQL From PowerShell

Abstract:

Azure is seeing phenomenal growth. More and more companies, from large enterprises to small start ups, are taking advantage of Azure to host their IT operations. As an IT Pro, you will be asked to migrate your local SQL Server Databases into SQL Azure.

In this session you'll be introduced to the PowerShell cmdlets for migrating to the Azure SQL infrastructure. You'll see how to:

Create resource groups Create Azure storage containers Create your Azure SQL Server and database Connect to the Azure SQL DB from SSMS Package your on premesis SQL Database Upload your SQL Database to Azure Import your SQL Database into Azure SQL

By the end of this demo packed session you'll understand how to use PowerShell to migrate your SQL Databases to Azure SQL.

SessionID: 74345

A Sense of Automation

Back to calendar

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

Speaker: Ravi Lobo

Title: A Sense of Automation

Abstract:

A sense of automation is about developing awareness for patterns in our day-to-day repeatable tasks and processes, and creating solutions to automate them.

SessionID: 77620

DAX Optimization Examples

Back to calendar

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

Speaker: Marco Russo

Title: DAX Optimization Examples

Abstract:

How do you optimize a DAX expression? In this session, we analyze some DAX expressions and Tabular models. Through the usage of DAX Studio and some understanding of the VertiPaq model, we will look at how to optimize them.

As you will see, most optimizations are the direct application of best practices. Moreover, the session has the additional takeaway of understanding what kind of performance you should expect from your formulas, and what improvements you might expect from learning how to optimize the model and the code.

SessionID: 77684

SQL Server Recovery Fundamentals

Back to calendar

Event Date: 19-05-2018 - Session time: 09:15:00 - Track: 101: Beginner Level Sessions

Speaker: Michael Fal

Title: SQL Server Recovery Fundamentals

Abstract:

Ever wonder what really breaks a log backup chain? Or are you intimidated by the idea of having to perform a page level restore? Backups and restores are the cornerstone of our work, but many data professionals do not fully understand them. Whether you are supporting transactional apps or building a data warehouse, mastering SQL Server recovery is a vital skill for our success. This session will take you behind the scenes of backups and restores, covering both the basics and some of the more nuanced details of SQL Server data protection. After this session, you will have a solid understanding of SQL Server recovery, allowing you to better configure, manage, and execute your own strategies.

SessionID: 71943

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

Back to calendar

Event Date: 19-05-2018 - Session time: 10:30: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: 72341

What You Need To Know About Processing Tabular Models

Back to calendar

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

Speaker: Bill Anton

Title: What You Need To Know About Processing Tabular Models

Abstract:

Ever wondered what's happening under the covers when processing a tabular model? Why is it such a resource intensive process? How can I make it run faster? Am I running into a resource bottleneck?

Processing an Analysis Services tabular model can be a very resource-intensive workload and depending on your specific goals (e.g. speed, availability, etc) it may not always be feasible to process the entire model.

In this session, you'll learn what actually happens and in what order during model processing, the difference between the various processing types, performance considerations and most common resource bottlenecks. We'll also cover the most common SSAS processing patterns and the tradeoffs of picking one over the other.

SessionID: 73342

A Beginner's Guide to Power BI

Back to calendar

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

Speaker: Ed Watson

Title: A Beginner's Guide to Power BI

Abstract:

Are you new to Power BI? 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: 74235

The Art and Science of Designing a Mission Critical SQL Server

Back to calendar

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

Speaker: Maxwell Myrick

Title: The Art and Science of Designing a Mission Critical SQL Server

Abstract:

When asked to design a critical database system, too many people pick an HA feature and then design the solution around it. This usually results in a costly and disappointing design.

This session will show you the five basic archetypes for mission critical database systems and how to select the right features from SQL Server to implement each design. Along the way you’ll hear some best practices, tips, and real world advice for choosing between features like Availability Groups and clustered instances of SQL Server, as well as the history of some of the more interesting and less often used availability features. You will also get a glimpse of how some of the largest mission critical systems running on the Microsoft platform are created using a distributed model where redundancy replaces failover. While you may not be able to revisit your current designs right away, what you learn will improve how you approach thinking about making a system as fail-proof as it can be.

SessionID: 77226

Containers, Pods, and Databases--Learning About the Future of Infrastructure

Back to calendar

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

Speaker: Joseph D'Antoni

Title: Containers, Pods, and Databases--Learning About the Future of Infrastructure

Abstract:

Containers have quietly been taking over the world of infrastructure, especially amongst developers and CI/CD practitioners. However, in the database space, container adoption has been lower. SQL Server 2017 introduced the concept of deploying databases into Docker containers. In this session, you will learn the fundamentals of creating containers, learning about Kubernetes for management, and how to further your learning in this new and emerging space.

SessionID: 77415

Performance Tuning for the BI Professional

Back to calendar

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

Speaker: Jonathan Stewart

Title: Performance Tuning for the BI Professional

Abstract:

Being a BI Professional, you need all the performance tuning the DB folks get and more. In this hour, we will go over important performance tuning tips that you can use to help make your deliverables faster and more effective. We will touch on the MSBI tools of SSIS, SSAS, SSRS and PowerBI.

SessionID: 77418

How to Implement a Hierarchy in SQL Server

Back to calendar

Event Date: 19-05-2018 - Session time: 10:30:00 - Track: Application Database 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: 77783

How to perform a health check

Back to calendar

Event Date: 19-05-2018 - Session time: 10:30:00 - Track: 101: Beginner Level Sessions

Speaker: Carl Roepe

Title: How to perform a health check

Abstract:

Are you uncertain about the health and capacity of your SQL Server? Are you taking over a new server and need to get a better understanding of the health of the server? Are you uncertain if your servers are following industry best practices?

In this session we will start by discussing the importance of performing a Health Check. We will then show how to run the popular Blitz script by Brent Ozar. After that we will review the other key areas to check like the VM configuration, Windows Configuration, SQL Configuration, Security configuration, and Database configuration. Finally, we’ll show how to save the results for capacity and trending analysis

At the end of the session you will be able to: (1) Perform a Health Check on a server; (2) List the key areas for improvement; (3) Save the results for capacity and trending analysis.

SessionID: 78761

Exploring SQL Server's Plan Cache

Back to calendar

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

Speaker: Kevin Kline

Title: Exploring SQL Server's Plan Cache

Abstract:

SQL Server’s plan cache is one of the largest regions of memory and is used to store SQL and

T-SQL code for quick execution. It is largely self-maintaining and self-tuning. However, the kind of code you write and the way you invoke that code can have an enormous impact on how the plan cache is maintained, tuned, and optimized. If you don’t do things right, you could end up shooting yourself in the foot and making performance much worse. Attend this demo-loaded session to learn about 4 harmful anti-patterns that developers frequently use without knowing their drawbacks. This session will answer questions like:

What’s currently in the plan cache?
How often is the code in my plan cache being reused?
Where are the big opportunities to save space in the plan cache?
What coding techniques are most likely to make my object recompile unnecessarily? There are a short list of mistakes that, if you know of them in advance, will make your life much easier. Learn to avoid the fo

SessionID: 80421

The DBA Script Thumb (10 year anniversary)

Back to calendar

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

Speaker: Rodney Landrum

Title: The DBA Script Thumb (10 year anniversary)

Abstract:

https://www.red-gate.com/simple-talk/sql/database-administration/the-dba-script-thumb/

SessionID: 71580

Well, actually... How to not be THAT guy in IT

Back to calendar

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

Speaker: Rie Irish

Title: Well, actually... How to not be THAT guy in IT

Abstract:

Unless you've been in a cave, you've seen articles lately on what it's like to be a woman in tech. In 2017, waves of blogs and news articles tell us about those extreme examples of misogyny. Only they aren't fringe, one-off stories. It's happening to women you know.

IT can be an inhospitable place for women. Some call it a "bro-grammer" culture. Compared to men, women are leaving IT at 2.5x and are interrupted 3x as often. Our credentials are called into question. We're called emotional or aggressive. We have our own job explained to us. Sometimes its subtle. Other times it's overt. There's always that one guy who ruins it for the rest of you. It doesn't have to be that way. Most of the guys we work with are stand-up, respectable WIT allies. The problem is, you don't always notice when it happens. Learn what those subtle forms of sexism look like at work. Learn how you can stop that guy in his tracks. Learn how to not BE that guy, even when you're just trying to help.

SessionID: 75802

Dynamic Data Flows in SSIS without Programming

Back to calendar

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

Speaker: Diane Schuster

Title: Dynamic Data Flows in SSIS without Programming

Abstract:

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at runtime without the need to change and redeploy the package. Columns and fields are mapped automatically at runtime. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

SessionID: 77711

Virtualizing SQL Server

Back to calendar

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

Speaker: Marsha Pierce

Title: Virtualizing SQL Server

Abstract:

An overview of what you need to do to virtualize SQL Server

SessionID: 82093

Simplifying SQL Data Protection

Back to calendar

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

Speaker: Michael Fal

Title: Simplifying SQL Data Protection

Abstract:

When you think about backups in your environment, how many servers scripts do you have to manage? Or have you ever needed to get a table back from a large database and didn't want to argue with the storage admins about space for the restore? With Rubrik, we empower you to backup and restore your databases quickly and with ease. Come see how you can quickly protect hundreds of databases with just a few clicks or bring back a database in minutes to satisfy your most demanding executives. With Rubrik, it's not about backing up, it's about going forward!

SessionID: 82199

#GetModern With Dell EMC Dominick Dequarto

Back to calendar

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

Speaker: SQL Saturday Atlanta

Title: #GetModern With Dell EMC Dominick Dequarto

Abstract:

Consistent and predictable performance is critical for any successful deployment of Microsoft SQL Server. All-Flash arrays have been available for years and sub-millisecond response times should be the expectation. Maximize the performance and agility of your environment and learn how to automate and leverage self-service for snapshots of your databases for protection and re-purposing. Test/dev infrastructures can be refreshed from production DBs in minutes rather than hours or days. Stop working harder and slower than you need to be, learn how you can leverage Dell EMC. Whether storage, servers, networking, data protection, converged or hyper-converged… we have you covered.

SessionID: 82200

How to Use Encryptionizer to Provide Transparent Encryption to Al

Back to calendar

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

Speaker: SQL Saturday Atlanta

Title: How to Use Encryptionizer to Provide Transparent Encryption to Al

Abstract:

Abstract: Encryptionizer provides transparent data encryption with no programming to all versions and editions of SQL Server from Enterprise down to SQL Express and even LocalDB. It also gives you many pluses such as the ability to encrypt system databases, backups, log files, filestreams. log shipping files and even external blobs such as documents and PDFs. This session will show how to deploy Encryptionizer in two different ways: with a simple point-and-click interface, and alternatively with a script based installer for wider deployment and even OEM.

SessionID: 82498

Using RDS SQL Server on Amazon Web Services - Richard Waymire

Back to calendar

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

Speaker: SQL Saturday Atlanta

Title: Using RDS SQL Server on Amazon Web Services - Richard Waymire

Abstract:

This session will examine how RDS SQL Server is used to host SQL Server as a managed service offering on Amazon Web Services. We will discuss the capabilities of the service offering, considerations for migration and how to manage SQL Server databases hosted in the AWS cloud.

SessionID: 82710

SANLess clustering for physical, virtual and cloud environments-

Back to calendar

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

Speaker: David Bermingham

Title: SANLess clustering for physical, virtual and cloud environments-

Abstract:

Join this session to learn how to create #SANLess clusters in environments where traditional shared storage clusters are impractical or impossible. We will discuss high performance clusters leveraging SSD and Flash-based PCIe storage for faster SQL application response times - no SAN (or SAN Admin required). We will also touch on methods for providing HA protection and native Windows Failover Clustering in Windows Azure or the Amazon Cloud. -- Topics covered -- High performance storage and accelerating SQL Server without sacrificing availability; AlwaysOn Failover Clustering vs. AlwaysOn Availability Groups; HA and DR strategy for SQL Server in Amazon EC2 and Azure instances; Fast, cost-effective strategies to get HA and DR protection without a SAN.

SessionID: 71596

Using Powershell to Document SQL Server

Back to calendar

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

Speaker: George Walkey

Title: Using Powershell to Document SQL Server

Abstract:

Most DBAs use multiple native and third party tools to fully document SQL Server instances yet still dont get all the objects. Even using Visual Studio and Database Projects, not all objects are exported because they live at the server level, above the database. Using Powershell, we will script out an organized set of files that can be checked into any Source Control system and or used for Disaster Recovery purposes. Objects exported include: SQL Agent Jobs/Alerts/Schedules, NT Service Credentials, SSIS-MSDB, SSIS-Catalog, SSAS Cubes, SSRS Reports, Logins, Server Configs, Linked Servers, DB Mail Operators/Accounts, Server Triggers and much more

SessionID: 71785

Agile Database Development and Zero Downtime Deployments

Back to calendar

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

Speaker: Jeff Reinhard

Title: Agile Database Development and Zero Downtime Deployments

Abstract:

Does your database development process match your agile frontend counterparts?

Is SQLServer Data Tools the right tool for an agile deployment methodology?

Join me in a fresh approach that will build deployments designed to be agile from the beginning, and also support the capability for zero down time deployments by supporting multiple states of the application, so database deployments can be made in advance, without breaking the application or requiring an outage.

Going zero will make you a hero!

SessionID: 71989

Should You Use M or R for Data Wrangling in Power BI? It Depends.

Back to calendar

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

Speaker: Ryan Wade

Title: Should You Use M or R for Data Wrangling in Power BI? It Depends.

Abstract:

Since the inception of Power BI, Power Query and the M programming language have been the main option that Power BI developers had to get data into the Power BI data model. In 2016 Microsoft gave us another option. They added the the ability to use the R programming language as a data source.

R is a very popular statistical programming language that has some powerful “data wrangling” capabilities. In this session Patrick Leblanc and Ryan Wade will explore several data wrangling task in Power BI using both M and R. We will compare the two and show when it is best to use one over the other.

SessionID: 72022

All (Data) Things Considered: The Lean Coffee Workshop

Back to calendar

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

Speaker: Stuart Ainsworth

Title: All (Data) Things Considered: The Lean Coffee Workshop

Abstract:

Collaboration is the heart of SQLSaturday's, but too often attendees move from session to session in a passive learning mode. This session is based on the Lean Coffee model, and is a structured workshop with no pre-planned agenda. The goal is to involve YOU in the conversation; bring your questions, your answers, your business cards, and your desire to learn. YOU set the agenda, YOU decide when to move on, and YOU engage and learn.

SessionID: 72031

Intro to SQL Operations Studio

Back to calendar

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

Speaker: Eric Flamm

Title: Intro to SQL Operations Studio

Abstract:

"SQL Operations Studio (preview) offers a modern, keyboard-focused T-SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich T-SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand T-SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience."

And, it runs on a Mac (and Linux, and Windows, too). Similar to Visual Studio Code, SQL Operations Studio (still in pre-release form) lets you connect to and manipulate your databases without spinning up Visual Studio (or SSMS). We'll walk through how to get the bits and install them, then connect to and query a database (in Azure) - we might not even use a mouse! If time permits, we'll take a look at Code Snippets - a built-in capability to make your T-SQL coding super-productive!

SessionID: 77736

DevOps, Continuous Integration Database Lifecycle Management: Rule them all

Back to calendar

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

Speaker: Samir Behara

Title: DevOps, Continuous Integration Database Lifecycle Management: Rule them all

Abstract:

Do you want to make your deployments risk free? Do you want to deliver business values to your customers faster? Do you want to increase the efficiency of your Team? Are your application and database deployment separate processes? Do you encounter issues while deploying your database changes? Is your database slowing you down?

If the answer to any of the above questions is a Yes, then this presentation is for YOU.

Come join me in this 60 min session to understand the problems with traditional database development, why organizations are moving towards achieving Continuous Integration and Database DevOps, the problems it tries to solve and learn about the toolsets which will assist you in this journey towards painless database deployments.

SessionID: 77761

Consumption Based Architecture

Back to calendar

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

Speaker: Michael French

Title: Consumption Based Architecture

Abstract:

Is this a replacement for architectures out there today like Kimball, Inmon, Federated, etc?

NO! It’s more about creating patterns and designs that focus on putting the data in the hands of the users by leveraging existing architectures.

All data assets, we really want to give our users a single source of the truth. We want them to go to one place to get all their data, that’s the common goal in enterprise data solutions. The problem is not all the data resides in one place, especially with big data, more tech savvy users, the vast amount of data resources available… you can really get data from anywhere.

Promotes self-service by leveraging data assets you already have increasing your business’ consumable data based on both need and data readiness.

This is not a data dump but more about getting good data to the right business people at the right time.

SessionID: 77799

High Availability and Disaster Recovery: Too Many Choices!

Back to calendar

Event Date: 19-05-2018 - Session time: 13:00:00 - Track: 101: Beginner Level Sessions

Speaker: Mike Walsh

Title: High Availability and Disaster Recovery: Too Many Choices!

Abstract:

Failover Clusters? Availability Groups? On-Prem or In The Cloud? Do it all with VMWare HA? Site to Site? Is log shipping even still an option? What about if we want to stay on Standard Edition?

So many questions revolve around High Availability and Disaster Recovery. They aren't just the "which way?" questions, though. In fact, those questions are the easy ones at the end of a process in sorting out which way to go.

Let's spend an hour talking about RPOs, RTOs, SLAs and the businesses needs. Let's dissect why DR and HA are not the same and how to figure out how many 9s and how much horsepower or money you really need to throw at this problem.

We'll keep it good for beginners and intermediates. Come with questions about that HA/DR project on your desk. Leave with a better understanding of which options are ruled in or out, and why. We'll walk through a couple options in my lab, too. We'll even talk about the cloud components available on this journey to availability.

SessionID: 78850

Managing Your Schema with Database Projects in Visual Studio

Back to calendar

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

Speaker: Kerry Tyler

Title: Managing Your Schema with Database Projects in Visual Studio

Abstract:

Integrating databases schema changes into a Software Development Lifecycle Management (SDLC) process can be a daunting and often tedious proposition. Adding the complexity of version control to the mix complicates this scenario. Fortunately, beginning with Visual Studio 2012, Database Projects add an "easy" button to this process. In this session, you will learn about the features and capabilities of VS Database Projects and how to use them to improve the lifecycle of your database structures, even if your organization does no code management.

SessionID: 80102

SQL Performance and Tuning in the Amazon Cloud

Back to calendar

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

Speaker: Eric Peterson

Title: SQL Performance and Tuning in the Amazon Cloud

Abstract:

It is easy to migrate to the cloud, but to get the performance you expect from a system without breaking your budget can be a challenge. This presentation will walk thru the differences between Amazon RDS and SQL Server installed in the Amazon EC2 environment. Topics will include a deep dive into installation, setup and the tuning of your SQL Server and Amazon Cloud Instance. The presentation will conclude with specific Amazon tips and techniques that are needed for meeting the goals of top performance from your SQL Server

SessionID: 71650

Whoa! Backup, what happened?

Back to calendar

Event Date: 19-05-2018 - Session time: 14:15:00 - Track: 101: Beginner Level Sessions

Speaker: Greg Moore

Title: Whoa! Backup, what happened?

Abstract:

This session will start with performing a basic backup and restore of a database and then discuss the difference between FULL, Differential and Transaction backups. From there I will discuss many of the available options for backups, including backups of specific database files, to multiple files and different restore options.

Many DBAs still setup their backups via a GUI and “fire and forget” and don’t think about backups and restores until too late. This session will show you while that works in many cases, for larger or more complex databases, or databases with specialized HA requirements, the out of the box solution may be far from optimal.

SessionID: 72562

Azure SQL Database for the Production DBA

Back to calendar

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

Speaker: Tim Radney

Title: Azure SQL Database for the Production DBA

Abstract:

Have you been wondering what Azure SQL Database is and what it means for you as a production DBA? Azure SQL Database has become an Enterprise-worthy database platform that provides relational database-as-a-service. In this session you’ll get a grounding in the fundamentals of Azure SQL Database from a DBA perspective. First we’ll cover how to create an Azure SQL Database using the Azure Portal and an approach for sizing a new Azure SQL Database. Then we’ll cover some of the similarities and differences between on premises SQL Server and Azure SQL Database. Finally we will cover how monitoring and performance tuning Azure SQL Database differs from on premises SQL Server. If you’ve been considering Azure SQL Database for your organization, this session is for you!

SessionID: 73659

Monitoring with sp_WhoIsActive, PowerShell and PowerBI

Back to calendar

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

Speaker: Jana Sattainathan

Title: Monitoring with sp_WhoIsActive, PowerShell and PowerBI

Abstract:

Everyone knows sp_WhoIsActive by Adam Machanic! In this session, we will see how its output captured periodically to a central database using PowerShell can be used as an effective monitoring tool with the analytics provided by Power BI. sp_WhoIsActive puts out the best output. PowerShell is the best at collecting data centrally from multiple servers and Power BI is the best at presenting and analyzing the results. The session will bring together features of sp_WhoIsActive, PowerShell and PowerBI to get an effective solution.

SessionID: 73742

T-SQL Window Function Performance

Back to calendar

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

Speaker: Kathi Kellenberger

Title: T-SQL Window Function Performance

Abstract:

Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.

SessionID: 74116

Build Your Extract Packages Automatically!

Back to calendar

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

Speaker: Shannon Lowder

Title: Build Your Extract Packages Automatically!

Abstract:

Automating extract packages is trivial., you simply use INFORMATION_SCHEMA. The problem is not all your data sources have easy to read metadata like SQL Server. How do you create usable metadata from these sources? In this hour, I’ll show you how easy it is to make an educated guess on the schema of flat files and other “semi-structured” data sources.

With that schema, automatically generating your extract package is a matter of seconds! Join me while I share my interrogator project with you and start saving hours at work today!

SessionID: 74483

10 Ways to Empower Your BI Strategy with Power BI

Back to calendar

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

Speaker: Teo Lachev

Title: 10 Ways to Empower Your BI Strategy with Power BI

Abstract:

Not sure what value Power BI brings to your BI projects? Join me to discuss 10 ways Power BI can help augment your existing or envisioned Power BI strategy. If you're interested in the Power BI but you're not sure how it fits within your organizational BI strategy, this event is for you. Discussion points include:

• Organizational BI • Self-service BI • Cloud vs. on-premises deployments • Predictive analytics • External reporting • Power BI-centric integrated solutions

Get your Power BI questions answered and see demos along the way.

SessionID: 77272

Cosmos DB: Planet Earth Scale

Back to calendar

Event Date: 19-05-2018 - Session time: 14:15:00 - Track: Cloud 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: 77567

Right-Size Your Data Files

Back to calendar

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

Speaker: Robert Verell

Title: Right-Size Your Data Files

Abstract:

Best practices for SQL Server indicate that when configuring tempdb, we should create multiple files for better performance. So why is it this is often ignored for user databases, where our data is actually stored?

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

How to win Dev and influence QA

Back to calendar

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

Speaker: Elizabeth Noble

Title: How to win Dev and influence QA

Abstract:

Are you having a hard time enforcing or updating processes? Are you having trouble getting the business to see your vision of the future? Do you want to improvement process or tasks as your office? Your answer to these challenges may be to improve relationships with key departments like Development and Quality Assurance.

In this session, I will go over steps I took to improve relationships with other members of the IT department. I will also discuss how improving my relationships helped me accomplish my long-term goals.

SessionID: 77980

Even VIEWs can be sexy

Back to calendar

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

Speaker: Kevin Wilkie

Title: Even VIEWs can be sexy

Abstract:

What really is a view? Do I use them the way they're supposed to be used? Can we make them faster? At what point have we gone overboard with views? Just some of the questions that will be asked and answered...

SessionID: 71651

Power BI Analytics On Prem integration within your Apps

Back to calendar

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

Speaker: Pritesh Ostwal

Title: Power BI Analytics On Prem integration within your Apps

Abstract:

Demonstrate Power BI On Prem deployment

Subtleties of hosting and using PBI reports within OnPREM hosted Web application Possibly SAP integration On prem

SessionID: 71960

Monitoring Linux Performance for the SQL Server Admin

Back to calendar

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

Speaker: Anthony Nocentino

Title: Monitoring Linux Performance for the SQL Server Admin

Abstract:

So you’re a SQL Server administrator and you just installed SQL Server on Linux. It’s a whole new world. Don’t fear, it’s just an operating system. It has all the same components Windows has and in this session we’ll show you that. We will look at the Linux operating system architecture and show you where to look for the performance data you’re used to! Further we'll dive into SQLPAL and how it architecture and internals enables high performance for your SQL Server. By the end of this session you’ll be ready to go back to the office and have a solid understanding of performance monitoring Linux systems and SQL on Linux. We’ll look at the core system components of CPU, Disk, Memory and Networking monitoring techniques for each and look some of the new tools available including new DMVs and DBFS.

SessionID: 73067

Azure Data Lake for First Time Swimmers

Back to calendar

Event Date: 19-05-2018 - Session time: 15:30:00 - Track: 101: Beginner Level Sessions

Speaker: Samara Soucy

Title: Azure Data Lake for First Time Swimmers

Abstract:

Data Lake may be the hot new way to store data for reporting, but few people have actually worked with it. If you have no idea what a data lake is, have no fear! You will get an intro to the concept of data lake and what scenarios you should be considering it as your platform. From there you’ll get to see how Azure Data Lake Analytics and USQL allow developers and data professionals to create compelling analytics with data that previously was hard to work with.

SessionID: 73373

"There Be Whales Here!" -- Big Data in SQL Server

Back to calendar

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

Speaker: Aaron Cutshall

Title: "There Be Whales Here!" -- Big Data in SQL Server

Abstract:

Due to varying definitions of Big Data which confuse data volume and data organization, the common perception is that Big Data requires the use of Hadoop, MongoDB, or another NoSQL database. SQL Server can easily store and manipulate very large volumes of data and perform quite well provided the database is properly set up and tuned. In this session we'll cover some of the definitions and misconceptions of Big Data, look at some Big Data solutions that went horribly wrong and review a case where Big Data was successfully implemented in SQL Server. Finally, we'll take a peek under the covers to see how SQL Server best handles Big Data through proper data models, table designs, performance tuning, and T-SQL techniques.

SessionID: 73929

Manipulating SharePoint Data in Power BI

Back to calendar

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

Speaker: Theresa Eller

Title: Manipulating SharePoint Data in Power BI

Abstract:

As Office 365 becomes more widely adopted, the chances of having to integrate SharePoint data as a source in Power BI becomes more of a reality. While importing the data is easy, making it useful and meaningful in Power BI can be convoluted. In this session, we will use the Power BI Desktop Application to explore how to manipulate common SharePoint data types, such multi-value columns, the person field, and date hierarchies. Demos will use SharePoint Online but can also be applied to SharePoint on-premises environments.

SessionID: 74296

Create SQL Server Test Premise Environment in Azure Cloud

Back to calendar

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

Speaker: Michael Wharton

Title: Create SQL Server Test Premise Environment in Azure Cloud

Abstract:

Why create a SQL Server Test premise environment in Azure cloud? One of the first steps into moving to Azure cloud, is building an environment that looks a feels like premise but only in the cloud. This session is an overview of getting started with basics of Azure environment, such as Accounts, virtual networks, Storage and creating virtual machines.. Once we fly by reviewing several building blocks, we then build Active Directory VM, SQL Server VM and App Server Tier VM using Azure portal and PowerShell.

SessionID: 77762

Getting Git

Back to calendar

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

Speaker: Paul Waters

Title: Getting Git

Abstract:

Source control has been an integral part of the software development process for years. For database development and administration many organizations still don’t use it, or struggle to integrate it into their process. If have familiarity with source control systems if is most likely of the centralize variety such as Subversion or TFVC. Git was first release in 2005 and has become the de facto standard for source control. Unlike Subversion and TFVC it is a decentralized source control system and requires a different way to think about branching and how to integrate it into your development process.

This session will cover: • Overview of Git • How it different from centralized source control systems • How to think in terms of Git • How to get started using Git with VSTS, SSMS and Visual Studio • Branching basics and pull requests • Tips, Tricks and Gotchas • Resources for learning Git and integrating it into your processes

SessionID: 78922

SQL Server Analysis Services for the DBA

Back to calendar

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

Speaker: Shabnam Watson

Title: SQL Server Analysis Services for the DBA

Abstract:

This session is for SQL Server DBAs who support BI developers with SQL Server Analysis Services (SSAS) projects. Join this session to learn what SSAS is, how it stores data, and how/when it queries data from SQL Server. During a demo you will see examples of these queries and learn the extent of the control that BI developers have over the design of such queries. This gives you an overview of both Multidimensional and Tabular modes of SSAS as it relates to interacting with SQL Server.

SessionID: 82055

SQL Server 2017 - It Just Gets Faster

Back to calendar

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

Speaker: Joseph D'Antoni

Title: SQL Server 2017 - It Just Gets Faster

Abstract:

SQL Server 2017 introduces many new features, and a new operating system, Linux. In this overview session you will learn about some of the important new features like:

Graph Database Automatic Query Tuning Adaptive Query Processing

You will learn about some of the other new features like string manipulation and enhancements to temporal tables. This demo heavy session will introduce you to the latest version of SQL Server.

SessionID: 82765

Artificial Intelligence, Cognitive Services, and Power BI

Back to calendar

Event Date: 19-05-2018 - Session time: 15:30:00 - Track: 101: Beginner Level Sessions

Speaker: Paco Gonzalez

Title: Artificial Intelligence, Cognitive Services, and Power BI

Abstract:

Microsoft Cognitive services is a series of services based on Microsoft Research using Deep Learning techniques, ready for you to enrich your unstructured data. Microsoft Services includes: Vision (Computer Vision, Emotion, Face, Video), Speech/Language (Speaker Recognition, Spell, Sentiment, Language, Key Phrases, Topic detection, Linguistic Analysis), Knowledge, and Search. These services are consumed by using the Cognitive Services APIs. Power BI enables you to consume the APIs to enrich your unstructured data inside your Power BI solutions. During this session, we will cover how to consume the API using Power Query to then visualize the results with Power BI visuals. We will also consume the Cognitive services API by using a R script inside Power BI. This session is structured with a B2C Survey case study solution with a real time Dashboard using a streaming dataset.

This site is open source. Improve this page.