sqlsathistory

Nr: 650

SQLSaturday #650 - Sacramento 2017

Start Time (24h)	Speaker	Track	Title
08:30:00	Joseph Barth	Cloud Application Development Deployment	Hybrid Data and Analytics via a SQL Server 2017 Azure Drone
08:30:00	Anthony Nocentino	Enterprise Database Administration Deployment	Designing High Availability Database Systems using AlwaysOn Availability Groups
08:30:00	Janis Griffin	Enterprise Database Administration Deployment	Welcome To the 2016 Query Store!
08:30:00	Elizabeth Block	Enterprise Database Administration Deployment	DBA Cheat Sheet
08:30:00	Mitchell Bottel	Professional Development	Effective Communication and Self Promotion for the IT Introvert (YOU!)
09:45:00	Ike Ellis	Cloud Application Development Deployment	A Survey of the Azure Data Platform
09:45:00	Ben Miller	Application Database Development	Inside the SQLPS PowerShell Module
09:45:00	Harry Chandra	Enterprise Database Administration Deployment	Intro to Availability Group
09:45:00	Rick Lowe	Application Database Development	Weird Stuff I Saw While ... Working With Heaps
09:45:00	Brandon Leach	Enterprise Database Administration Deployment	Treating Tables Like Legos: Table Partitioning Basics
09:45:00	Prakash Heda	Enterprise Database Administration Deployment	SQL Server on Containers – Part 1
11:00:00	Ben Miller	Enterprise Database Administration Deployment	Managing Availability Groups with PowerShell
11:00:00	Ami Levin	Application Database Development	Where did I put my (primary) keys?
11:00:00	Brandon Leach	Enterprise Database Administration Deployment	A DBAs guide to the proper handling of corruption
11:00:00	Jason Brimhall	Enterprise Database Administration Deployment	Bare Naked Skinny on SQL Server
11:00:00	Prakash Heda	Enterprise Database Administration Deployment	SQL Server on Containers – Part 2
12:15:00	SQLSAT650 Sponsor	Enterprise Database Administration Deployment	VMware Lunch and Learn Series: Microsoft SQL Server on vSphere
12:15:00	SQLSAT650 Sponsor	Enterprise Database Administration Deployment	Zerto: Keeping the Enterprise Always On with IT Resilience
13:30:00	Anthony Nocentino	Enterprise Database Administration Deployment	Linux OS Fundamentals for the SQL Admin
13:30:00	Deji Akomolafe	Enterprise Database Administration Deployment	Successfully Virtualizing SQL Server on vSphere - Straight from the Source
13:30:00	Paul Stanton	Enterprise Database Administration Deployment	SQL Server Containers and Clones
13:30:00	Christopher Anderson	BI Information Delivery	Build your Key Performance Indicator data warehouse
13:30:00	Dan Hess	Enterprise Database Administration Deployment	Intro to Azure from a DBA's Perspective: How to Cover Your a.a.s.
14:45:00	Phil Robinson	BI Information Delivery	Data Wrangling for Reporting Analytics
14:45:00	Rick Lowe	Application Database Development	Why Should I Care About ... Partitioned Views?
14:45:00	Eric Courville	Enterprise Database Administration Deployment	Intro to the DBATools PowerShell module
14:45:00	Jason Brimhall	Enterprise Database Administration Deployment	A Masters Passport to Extended Events
14:45:00	Ike Ellis	Analytics and Visualization	Dive into Azure Data Lake
16:00:00	Sayed Saeed	BI Information Delivery	Enabling Familiar, Powerful Business Intelligence
16:00:00	Armando Lacerda	Enterprise Database Administration Deployment	Unleashing Stretched Databases
16:00:00	Eric Freeman	BI Platform Architecture, Development Administration	SSIS Process Automation Design for the T-SQL Developer
16:00:00	Benjamin Nevarez	Application Database Development	Dive into the Query Optimizer - Undocumented Insight
16:00:00	Glenn Burnett	Enterprise Database Administration Deployment	Lightning Talks

SessionID: 63264

Hybrid Data and Analytics via a SQL Server 2017 Azure Drone

Back to calendar

Event Date: 15-07-2017 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Joseph Barth

Title: Hybrid Data and Analytics via a SQL Server 2017 Azure Drone

Abstract:

Hybrid Data and Analytics via a SQL Server 2017 Azure-Controlled Drone

Using SQL Server 2017, we will control a drone via NodeJS. With the help of Python and ML we will then make the drone fly in the "Safe Zone".

Join me in a presentation on how to create your Azure environment for data and analytics using the first ever drone controlled by SQL Server 2017.

creating a template to make proofs of concept possible
real world situations and lessons learned in Azure
consumption of that data through Power BI

This presentation will include creation of a hybrid solution for operational analytics both on-prem and cloud using Azure SQL Database in-memory and temporal tables to create the ultimate data and analytics experience.

SessionID: 63279

Designing High Availability Database Systems using AlwaysOn Availability Groups

Back to calendar

Event Date: 15-07-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Anthony Nocentino

Title: Designing High Availability Database Systems using AlwaysOn Availability Groups

Abstract:

Are you looking for a high availability solution for your business critical application? You're heard about AlwaysOn Availability Groups and they seem like a good solution, but you don't know where to start. It all starts with a solid design. In this session we introduce the core concepts needed to design a Availability Group based system. Covering topics such as recovery objectives, replica placement, failover requirements, synchronization models, quorum, backup and recovery and monitoring. This session is modeled after real world client engagements conducted by Centino Systems that have lead to many successful Availability Groups based systems supporting tier 1 business critical applications.

SessionID: 63597

Welcome To the 2016 Query Store!

Back to calendar

Event Date: 15-07-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Welcome To the 2016 Query Store!

Abstract:

One of my favorite new features in SQL Server 2016 is the Query Store. The Query Store houses valuable information on performance of your queries as well as gives you great insights into your query workload. This presentation will take a look at the Query Store, how it works and the type of information it holds. You will learn how to use the Query Store to quickly find plan changes and analyze performance issues caused by them. New DMVs will be introduced and the performance impact of enabling the Query Store will be discussed. Both DBAs and developers can increase their performance tuning skills by attending this session.

SessionID: 63962

DBA Cheat Sheet

Back to calendar

Event Date: 15-07-2017 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Elizabeth Block

Title: DBA Cheat Sheet

Abstract:

Do you have trouble remembering common administrative T-SQL commands? Remember when you created a cheat sheet in school to help you study for an exam? Use that same principle with the DBA Cheat Sheet! The DBA Cheat Sheet is a document filled with some basic administrative TSQL commands you’ll need in your daily work. During the session I’ll show you a few SSMS tricks and review some of the topics in the DBA Cheat Sheet document. You’ll leave the session with a document that you can use as a reference every day. This is geared for developers or Junior DBAs.

SessionID: 64969

Effective Communication and Self Promotion for the IT Introvert (YOU!)

Back to calendar

Event Date: 15-07-2017 - Session time: 08:30:00 - Track: Professional Development

Speaker: Mitchell Bottel

Title: Effective Communication and Self Promotion for the IT Introvert (YOU!)

Abstract:

SessionID: 63372

A Survey of the Azure Data Platform

Back to calendar

Event Date: 15-07-2017 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: Ike Ellis

Title: A Survey of the Azure Data Platform

Abstract:

Choosing where to store your data is far more difficult than ever. We can be paralyzed with choice! This session seeks to ease that anxiety and provide direction for application developers and DBAs. You'll learn the differences between DocumentDB, Azure Table Storage, Azure Blob Storage, Azure SQL Database, Azure SQL in a VM, Azure SQL Data Warehouse, Azure Data Lake Analytics, Azure Data Lake Store, and more. See demos and review case studies so you'll have a complete view of how data is stored in Azure and how to choose between these great tools.

SessionID: 64095

Inside the SQLPS PowerShell Module

Back to calendar

Event Date: 15-07-2017 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Ben Miller

Title: Inside the SQLPS PowerShell Module

Abstract:

SQLPS has been evolving since 2012 and the SQL Provider/cmdlets have been around since 2008. Have you taken advantage of the PowerShell infrastructure that is on your servers? This session takes you behind the scenes of the SQLPS and the new SqlServer module that is installed with the tools. We will cover how to get it without the tools, how to use it once you have it and why you will want to use it for simple tasks or complex ones. When you learn how to navigate SQL Server and all its services using Paths, you won't go back. Join me for a fun filled hour and learn how to keep SQLPS from becoming frustrating and a black box. You will be glad you did. Let's continue the journey to becoming a PowerShell DBA.

SessionID: 64432

Intro to Availability Group

Back to calendar

Event Date: 15-07-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Harry Chandra

Title: Intro to Availability Group

Abstract:

In this session, I will walk you through every steps to set up SQL Server Availability Group. After a brief introduction to the basic components of Availability Group (AG), We will set up a primary AG with 2 secondary. This session will be mostly demo with opportunity to ask questions. Come and learn how to set up AG.

SessionID: 65261

Weird Stuff I Saw While ... Working With Heaps

Back to calendar

Event Date: 15-07-2017 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Rick Lowe

Title: Weird Stuff I Saw While ... Working With Heaps

Abstract:

We've all been told at some point that heaps are usually bad for select, update, and delete performance. But how bad are they really? Can they also be problematic for inserts? Are they ever a good idea? For this installment of Rick's "Weird Stuff" series we will take a closer look at why heaps can cause issues and maybe see a deadlock or two.

SessionID: 66065

Treating Tables Like Legos: Table Partitioning Basics

Back to calendar

Event Date: 15-07-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Brandon Leach

Title: Treating Tables Like Legos: Table Partitioning Basics

Abstract:

Have your tables and indexes that have grown rather large? Are they taking longer to query? Are your windows for maintenance getting tighter? If you answered yes to any of these questions, table partitioning may be for you!

With table partitioning, you can break a table or index down into smaller more manageable chunks. It can help you perform maintenance on just part of a table or index. You can even move data in and out of tables with quick and easy metadata only operations. We’ll go over basic partitioning concepts such as horizontal vs. vertical partitioning, and techniques like partitioned views and sliding windows. You'll see how we can make our index and statistics maintenance easier. At the end of this session you’ll have a firm understanding of how partitioning works and be able to make decisions on how and when to implement.

SessionID: 66486

SQL Server on Containers – Part 1

Back to calendar

Event Date: 15-07-2017 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Prakash Heda

Title: SQL Server on Containers – Part 1

Abstract:

Windows 16 introduced containers which has started a new era which will help with VM consolidation big time, the future of SQL Implementations is about installing SQL Server on Windows 16 NANO Server running as containers. It provides an isolated, resource controlled, predictable and portable operating environment inside a VM.

SQL server 2017 with complete support for creating containers using Dockers, a defacto industry standard API for container packaging is to allow running SQL Server as micro-services. Docker has industry-wide support with hosted services on Azure/AWS, monitoring, logging, orchestration. No matter you want to deploy SQL server on Linux or windows containers are the way…

This introductory session will help seasoned SQL Server DBA/Developers understand the basics of containers and windows 16 NANO servers running SQL Server 2016 17. in subsequent session Prakash will cover several demos and share scripts to start with containers

SessionID: 64097

Managing Availability Groups with PowerShell

Back to calendar

Event Date: 15-07-2017 - Session time: 11:00: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: 65779

Where did I put my (primary) keys?

Back to calendar

Event Date: 15-07-2017 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Ami Levin

Title: Where did I put my (primary) keys?

Abstract:

In this session we will revisit some of the fundamental design principals of relational databases: normalization rules, key selection, and the controversies associated with these issues from a practical perspective.

We will consider the benefits and challenges of using different types of keys - natural, surrogates, artificial (and others?) from multiple aspects: data consistency, application development, maintenance, portability and performance.

SessionID: 66063

A DBAs guide to the proper handling of corruption

Back to calendar

Event Date: 15-07-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Brandon Leach

Title: A DBAs guide to the proper handling of corruption

Abstract:

Corruption can strike at any time. As DBAs how we alert, investigate, and respond can have profound impact on our company. In this session we will learn how to detect and respond to various types of corruption.

First we will be focus on ways to detect corruption early. This will include understanding tools available to us like DBCC CheckDB as well as the importance of testing your backups. We’ll look at some sample scripts to automate corruption checks and common alerts we should have set up on our instances.

Then we will move onto how to respond to some common example of corruption through live demos. We’ll look at how we can analyze the situation safely as well as point out various pitfalls that trip people up. We’ll also discuss when and how we may be able to fix corruption vs restoring the database.

SessionID: 66214

Bare Naked Skinny on SQL Server

Back to calendar

Event Date: 15-07-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Brimhall

Title: Bare Naked Skinny on SQL Server

Abstract:

Ever feel like there are just too many layers with SQL Server? You peel off a layer and behold there is yet another layer. SQL Server is rather complex. The complexities can be rather frustrating from time to time.

Join this NSFW (not safe for whining) session as we strip SQL down to the bare bones. I will help you undress the complexities of a few of the basic SQL Server concepts. These concepts will include locks, principals, query directives and deadlocks.

In this session I will disrobe misunderstandings related to the aforementioned topics. I will show the different types of principals in SQL Server. I will also show various scenarios involving locks and deadlocks along with some of their effects with and without query directives. The goal is to better understand these topics and to hopefully stop using and perpetuating common mis-uses of terminology and common misconceptions about the technology.

SessionID: 66487

SQL Server on Containers – Part 2

Back to calendar

Event Date: 15-07-2017 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Prakash Heda

Title: SQL Server on Containers – Part 2

Abstract:

Please attend Part 1 before to get full usage of this session

Those of you remember physical server consolidation phase started with VM, and struggle to run SQL server on VM with predictable performance…. Since than this is biggest change in the way SQL will be installed. Windows 16 introduced containers support, headless NANO servers and SQL server 2017 with complete support for creating containers using Dockers, a defacto industry standard API for container packaging is to allow running SQL Server as micro-services. No matter you want to deploy SQL server on Linux or windows containers are the way…

Will show you how can you install 5 SQL server implementations in 5 minute with each dedicated SQL implementation taking 15 GB of space. Will show you how containerization solves the “dependency hell” problem by incorporating software dependencies into a container image and provide smooth application deployment…

This session is designed for seasoned SQL Server DBA Developers

SessionID: 66530

VMware Lunch and Learn Series: Microsoft SQL Server on vSphere

Back to calendar

Event Date: 15-07-2017 - Session time: 12:15:00 - Track: Enterprise Database Administration Deployment

Title: VMware Lunch and Learn Series: Microsoft SQL Server on vSphere

Abstract:

Grab your lunch and join Deji Akomolafe of VMware in the VMware (Placer) room for an informative presentation while you eat!

VMware Lunch and Learn Series: Microsoft SQL Server on vSphere

SessionID: 66606

Zerto: Keeping the Enterprise Always On with IT Resilience

Back to calendar

Event Date: 15-07-2017 - Session time: 12:15:00 - Track: Enterprise Database Administration Deployment

Title: Zerto: Keeping the Enterprise Always On with IT Resilience

Abstract:

Grab your lunch and join the Zerto experts in the Zerto (San Francisco) room for an informative presentation while you eat!

Your organization is always running and can't afford downtime during a disaster or the traditional time it takes to recover from one. Backup solutions don't solve these problems as they are not true disaster recovery for the business. What types of disasters will impact the business? Learn about disaster recovery scenarios, and also the questions to ask and answer when planning your disaster recovery solution to drive true IT resilience. Learn about which decisions impact the business in which ways, and how to avoid making sacrifices for your always-on organization.

SessionID: 63281

Linux OS Fundamentals for the SQL Admin

Back to calendar

Event Date: 15-07-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Anthony Nocentino

Title: Linux OS Fundamentals for the SQL Admin

Abstract:

SQL Server and PowerShell are now available on Linux and management wants you to leverage this shift in technology to more effectively manage your systems, but you’re a Windows admin! 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 how to interact with and manage Linux system. By the end of this session you’ll be ready to go back to the office and get started working with Linux with a fundamental understanding of how it works.

SessionID: 63376

Successfully Virtualizing SQL Server on vSphere - Straight from the Source

Back to calendar

Event Date: 15-07-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Deji Akomolafe

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

Abstract:

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

SessionID: 65876

SQL Server Containers and Clones

Back to calendar

Event Date: 15-07-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Paul Stanton

Title: SQL Server Containers and Clones

Abstract:

“Containers and Clones for SQL Server Development and Test”

Microsoft is emphasizing the use of containers for development and test on SQL Server 2017, and new solutions from Red Gate and Windocks add support for containers and SQL Server database fast cloning, for the full range of the SQL Server family. We’ll explore use of Docker based tooling for delivery of container environments, and their pros and cons. We’ll also look at SQL Server cloning, and how clones enable Dev and Test teams to work on large database environments for containers as well as existing SQL Server instances.

SessionID: 66417

Build your Key Performance Indicator data warehouse

Back to calendar

Event Date: 15-07-2017 - Session time: 13:30:00 - Track: BI Information Delivery

Speaker: Christopher Anderson

Title: Build your Key Performance Indicator data warehouse

Abstract:

Your business or organization likely has Key Performance Indicators (KPIs) to measure business performance, A KPI data warehouse solution can help you collect KPI data, store it over time, and support analytics. You executives and management will appreciate Analytics and Reports that rollup and present KPIs. During this session, you will see an overview of a Key Performance Indicator data warehouse architecture successfully deployed at a large California state agency. You will learns some ways to bring parts, or all, of it into your organization to expand your Business Intelligence and Analytics offerings.

SessionID: 66605

Intro to Azure from a DBA's Perspective: How to Cover Your a.a.s.

Back to calendar

Event Date: 15-07-2017 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Dan Hess

Title: Intro to Azure from a DBA's Perspective: How to Cover Your a.a.s.

Abstract:

Head in the "cloud"? Looking for a "cloud" with a silver lining? There are many clichés that can be used when talking about "cloud" technology but really, how does Microsoft's "cloud" offering, called Azure, actually work? Let's take a look at some basics and maybe even take a dive into the deep end. We'll look at terminology ("subscriptions", "Infrastructure as a service", "resource manager" etc.), how to create various resources (virtual machines, databases, virtual networks etc.) and maybe even log into a "cloud" database. I'll present a solid foundation that will enable you to get comfortable with the technology and allow you to expand your "cloud" skills.

SessionID: 63284

Data Wrangling for Reporting Analytics

Back to calendar

Event Date: 15-07-2017 - Session time: 14:45:00 - Track: BI Information Delivery

Speaker: Phil Robinson

Title: Data Wrangling for Reporting Analytics

Abstract:

This session will review common challenges encountered when preparing new data sets for use in analytics and reporting. We will look at tools for exploring and modifying large CSV/TXT files and discuss design patterns for cleaning and repair.

SessionID: 65260

Why Should I Care About ... Partitioned Views?

Back to calendar

Event Date: 15-07-2017 - Session time: 14:45:00 - Track: Application Database Development

Speaker: Rick Lowe

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

Abstract:

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

SessionID: 66182

Intro to the DBATools PowerShell module

Back to calendar

Event Date: 15-07-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Courville

Title: Intro to the DBATools PowerShell module

Abstract:

The DBATools PowerShell module is the premiere open source PowerShell project designed to automate, and encourage best practices. In this talk we will walk through setting up the module and review examples from the 180 commandlets available.

SessionID: 66213

A Masters Passport to Extended Events

Back to calendar

Event Date: 15-07-2017 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Brimhall

Title: A Masters Passport to Extended Events

Abstract:

"As is commonly the case, all good things come to an end. And now is as good a time as any for the use of SQL Trace and Profiler to come to an end. Let’s face it, Trace was a good tool and had some wonderful uses. Profiler for that matter was a good tool and was useful at times.

It is time to let those old tools retire gracefully and move into the world of XE. This full day workshop will provide you the means to let Profiler and Trace be retired from your toolset as you discover all that XE has to offer.

This full day session on Extended Events will help prepare you to put this tool to immediate use as you walk back to your daily duties. This workshop will teach you about Extended Events starting with the basics and moving through how to create XE sessions that will get the right data for you, while doing so with minimal impact.

You will be exposed to advanced troubleshooting techniques as we work through complex issues that are made easier through the use of XE. Take advantage

SessionID: 66423

Dive into Azure Data Lake

Back to calendar

Event Date: 15-07-2017 - Session time: 14:45:00 - Track: Analytics and Visualization

Speaker: Ike Ellis

Title: Dive into Azure Data Lake

Abstract:

In this session, we'll show the power of this Azure MPP solution. T-SQL is a great data language that makes parallelism easy. C# is a fantastic statically typed language that taps into the power of the .NET framework, but parallelism has a big barrier to entry. Learn how U-SQL combines the best of both worlds to clean and analyze data at incredible levels. Azure Data Lake Analytics makes Hadoop affordable and easy by leveraging your existing knowledge of T-SQL and C#.

SessionID: 63265

Enabling Familiar, Powerful Business Intelligence

Back to calendar

Event Date: 15-07-2017 - Session time: 16:00:00 - Track: BI Information Delivery

Speaker: Sayed Saeed

Title: Enabling Familiar, Powerful Business Intelligence

Abstract:

This session focuses on Microsoft’s BI technologies and its abilities to make advanced easy to use, accessible, insightful, and actionable decisions, all while helping clients increase organizational performance. With the recent release of SQL Server, Microsoft dramatically enhanced the Microsoft BI platform. During this session you will explore the improvements to SQL Server reporting services and Power BI to show you how to create a blended value from your BI platform.

SessionID: 64077

Unleashing Stretched Databases

Back to calendar

Event Date: 15-07-2017 - Session time: 16: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: 64850

SSIS Process Automation Design for the T-SQL Developer

Back to calendar

Event Date: 15-07-2017 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Eric Freeman

Title: SSIS Process Automation Design for the T-SQL Developer

Abstract:

This session is geared towards T-SQL developers who are interested in ETL framework or process automation. In this session we will go over how to create a single SSIS package that can be used for process flow automation without the need to constantly update the SSIS package whenever there is a change. When something happens, something or multiple things need to happen. The architecture that will be presented is powered by tables, stored procedures and recursive CTEs.

SessionID: 66433

Dive into the Query Optimizer - Undocumented Insight

Back to calendar

Event Date: 15-07-2017 - Session time: 16:00:00 - Track: Application Database Development

Speaker: Benjamin Nevarez

Title: Dive into the Query Optimizer - Undocumented Insight

Abstract:

This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization. I will use these undocumented features to explain what the query optimizer does from the moment a query is submitted to SQL Server until an execution plan is generated including operations like parsing, binding, simplification, trivial plan, and full optimization. Concepts like transformation rules, the memo structure, how the query optimizer generates possible alternative execution plans, and how the best alternative is chosen based on those costs will be explained as well.

SessionID: 66604

Lightning Talks

Back to calendar

Event Date: 15-07-2017 - Session time: 16:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Glenn Burnett

Title: Lightning Talks

Abstract:

Glenn Burnett: Destroyer of Databases. How I accidentally overwrote multiple production databases, and how you can avoid doing the same.

Caroline Ward: It's amazing how a Massive Open Online Course (MOOC) can jumpstart your learning! MOOC tips and recommendations, and the best learning advice I have picked up from a MOOC!

Dilip Nayak: Lessons learned in hiring short-term DBA contractors. Do your expectations match the services you're purchasing?

Robert Muir: How your database design can impact performance, what to watch out for when using Entity Framework queries, and tips for sharing this information with application and database developers.

This site is open source. Improve this page.