sqlsathistory

Nr: 700

Back to Main list

SQLSaturday #700 - Colorado Springs 2018

Start Time (24h) Speaker Track Title
08:30:00 TJay Belt Enterprise Database Administration Deployment PowerBI, from a DBA
08:30:00 Rob Volk Application Database Development Tame Your Unruly Data With Constraints
08:30:00 Phillip Labry BI Information Delivery Why do I need Analysis Services?
08:30:00 Todd Kleinhans Strategy and Architecture The Life Cycle of a Query in Virtual Reality
08:30:00 Cyndi Johnson Application Database Development Killing Cursors
08:30:00 Glenn Berry Strategy and Architecture High Availability/Disaster Recovery 101
08:30:00 Marc Beacom BI Platform Architecture, Development Administration ETL Best Practices and Techniques
08:30:00 Scot Reagin Cloud Architecture, Development Deployment Data Positioning: Self-Defense or a Brilliant New Architecture
09:40:00 Steven Tidwell Application Database Development Dynamic SQL: Tables, Pivots, Parameters
09:40:00 Yuliya Quintela BI Platform Architecture, Development Administration Biml 101: Automation and Patterns
09:40:00 David Patrick Analytics and Visualization Microsoft and Big Data - An Overview of the Power Tools and more!
09:40:00 Leslie Weed Application Database Development Source Control and Database Projects - Just Do It
09:40:00 Matthew Smith BI Platform Architecture, Development Administration SQL Server Big Data Solution: SQL Server 2016, PolyBase and Dell EMC Isilon storage
09:40:00 Meagan Longoria Analytics and Visualization Challenges and Opportunities in Creating Accessible Power BI Reports
09:40:00 Sean McCown Enterprise Database Administration Deployment Beginning Powershell for DBAs 1.0
09:40:00 Marc Beacom BI Platform Architecture, Development Administration Implementing a Cloud Analytics Solution: Options, costs and more
09:40:00 Gabriel Villa Cloud Architecture, Development Deployment Know Your Options: Databases on Amazon Web Services
09:40:00 Carlos Bossy Advanced Analysis Techniques Operationalizing Data Science
10:50:00 Mike Byrd Application Database Development Climbing the SQL Server Index B-Tree (from a user perspective)
10:50:00 Eric Peterson Enterprise Database Administration Deployment Very Large Databases in your future
10:50:00 Steve Wake BI Platform Architecture, Development Administration Make Power BI Your Own with the Power BI APIs
10:50:00 Adam Durazo Information Delivery Harnessing D3.js to visualize geographical data
10:50:00 Jeff Renz Analytics and Visualization Introduction to R
10:50:00 Marsha Pierce Enterprise Database Administration Deployment How To Talk To Your Storage Admin
10:50:00 Mark Moore Cloud Architecture, Development Deployment Azure SQL and Azure Data Warehouse 101
11:50:00 Matthew Smith Strategy and Architecture #GetModern With Dell EMC
13:15:00 Christopher Wolff Cloud Architecture, Development Deployment Amazon Web Services RDS with SQL Server
13:15:00 Steve Jones Professional Development Branding Yourself for a Dream Job
13:15:00 Kellyn Pot'Vin-Gorman Enterprise Database Administration Deployment Essential Linux for the SQL Server DBA
13:15:00 Rajesh Chawla BI Information Delivery Power BI embedded into your application
13:15:00 Leslie Andrews BI Platform Architecture, Development Administration The Power of Data: The Complete Beginners Data Warehouse Kit
13:15:00 Brian Hansen Enterprise Database Administration Deployment Get Your Optimizer to Give up All Its Secrets
13:15:00 Jennifer McCown Application Database Development T-SQL's Hidden Support Feature
14:25:00 Tim Gorman Information Delivery Reducing The Surface Area Of Risk in Data Security
14:25:00 Dave Walden Enterprise Database Administration Deployment LIVE SQL Server 2017 LINUX Availability Group build-out!
14:25:00 Greg Moore Strategy and Architecture Whoa! Backup, what happened? The Basics of Backups
14:25:00 Kevin Kline Application Database Development Secrets of the Query Optimizer Revealed Using Trace Flag 86xx
14:25:00 Tim Weigel Enterprise Database Administration Deployment Ch-ch-ch-changes! How to keep track of what's happening to your data
14:25:00 William Barnes Professional Development Where Do I Start? A guide for the new SQL Techie.
14:25:00 Reeves Smith BI Platform Architecture, Development Administration Data Science for the SQL Server Professional

SessionID: 70195

PowerBI, from a DBA

Back to calendar

Event Date: 24-03-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: TJay Belt

Title: PowerBI, from a DBA

Abstract:

Microsoft’s PowerBI is the new hotness. In this session, you will get your hands dirty and dive into PowerBI and create an actual report, with actual data. You will get to learn from examples from what a DBA has done to implement PowerBI in his shop and make his data accessible.

As a DBA, we often need to collect and display data in a friendly and interactive fashion. We will play with some PowerShell to collect data from several systems, store this data in an Azure DB in the Cloud, then point PowerBI at this data to display and interact with said data. You will learn a little about PowerShell, Azure SQL DB, PowerBI, and how to make these work for you.

SessionID: 70204

Tame Your Unruly Data With Constraints

Back to calendar

Event Date: 24-03-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Rob Volk

Title: Tame Your Unruly Data With Constraints

Abstract:

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

SessionID: 70591

Why do I need Analysis Services?

Back to calendar

Event Date: 24-03-2018 - Session time: 08:30:00 - Track: BI Information Delivery

Speaker: Phillip Labry

Title: Why do I need Analysis Services?

Abstract:

Do you have or are you developing a BI roadmap without Analysis Services? Do you write a lot of SSRS reports with SQL queries, views or stored procedures? Have you heard about Analysis Services but don't know if it's a good fit for you? Are you trying to decide whether you should go with Tabular or OLAP? Are you thinking about using Power BI? Are your business users hungry for data? If you answered yes to any of these questions, you probably need Analysis Services.

In this session we will go over use cases for Analysis Services and highlight the differences and strengths of each flavor of SSAS. We will review typical BI architectures and show how adding Analysis Services can turn your report users into happy and self sufficient data analysts. If you have a data warehouse(or even if you don't) and aren't using SSAS, come learn how SSAS will make your users love you.

SessionID: 70798

The Life Cycle of a Query in Virtual Reality

Back to calendar

Event Date: 24-03-2018 - Session time: 08:30:00 - Track: Strategy and Architecture

Speaker: Todd Kleinhans

Title: The Life Cycle of a Query in Virtual Reality

Abstract:

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

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

SessionID: 71166

Killing Cursors

Back to calendar

Event Date: 24-03-2018 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Cyndi Johnson

Title: Killing Cursors

Abstract:

You’ve been around long enough to pick up on the disdain that the T-SQL community has for cursors, but how do you get away from them? We will take a common business problem and work our way through a few alternative approaches, discussing the strengths and weaknesses of the various approaches and evaluating the performance of each. CTEs, recursive CTEs, and the OVER AND PARTITION BY clause will be covered.

SessionID: 72556

High Availability/Disaster Recovery 101

Back to calendar

Event Date: 24-03-2018 - Session time: 08:30:00 - Track: Strategy and Architecture

Speaker: Glenn Berry

Title: High Availability/Disaster Recovery 101

Abstract:

How do you design a SQL Server 2017 infrastructure in order to meet specific Recovery Time Objective (RTO) and Recovery Point Objective (RPO) service levels? There are many aspects to consider, from technology choices and licensing, to policies and procedures. This session outlines and compares the various HA/DR technologies available in SQL Server 2017, showing how you can combine them to design and build a solution to help meet your HA/DR goals. This session also teaches you how to formulate policies that enable effective use of technology in your organization.

SessionID: 73585

ETL Best Practices and Techniques

Back to calendar

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

Speaker: Marc Beacom

Title: ETL Best Practices and Techniques

Abstract:

ETL (Extract, Transform and Load) is the backbone of any data project and can be upwards of 70% or more of the effort. The tools you have access to allow you to make progress in a hurry. However, are you implementing best practices and techniques that will scale to the demands you need? Or will you be refactoring far too quickly than you should to meet performance requirements?

Gain helpful insights from decades of lessons learned and walk away with best practices you can implement in your own ETL solution.

SessionID: 75798

Data Positioning: Self-Defense or a Brilliant New Architecture

Back to calendar

Event Date: 24-03-2018 - Session time: 08:30:00 - Track: Cloud Architecture, Development Deployment

Speaker: Scot Reagin

Title: Data Positioning: Self-Defense or a Brilliant New Architecture

Abstract:

The Cloud, streaming data, big data, self-service, machine learning, AI and the internet of things. Clearly we’re not in Data Management Kansas anymore. Data Modelers and Architects have been reacting to wave after wave of demands from these communities with new technologies and methodologies but too often remain grounded in outdated concepts of data management principles. Data Positioning is an evolution of this thinking, allowing Data Managers to deliver value today and in the future.

SessionID: 69576

Dynamic SQL: Tables, Pivots, Parameters

Back to calendar

Event Date: 24-03-2018 - Session time: 09:40:00 - Track: Application Database Development

Speaker: Steven Tidwell

Title: Dynamic SQL: Tables, Pivots, Parameters

Abstract:

Dynamic SQL is a scripting language that helps you design flexibility into your code. It allows you to design solutions, pass parameters and allows you build a single query on values passed. Dynamic SQL has both pros and cons to it's design, but can also be a helpful tool. This presentation will walk through the steps of building dynamic tables, aggregating data in a pivot format and give you the first steps of writing a Dynamic Query. There are hundreds of task that will benefit from the use of Dynamic SQL. From parameter based searches to building dynamic SELECT statements at run time.

SessionID: 70098

Biml 101: Automation and Patterns

Back to calendar

Event Date: 24-03-2018 - Session time: 09:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Yuliya Quintela

Title: Biml 101: Automation and Patterns

Abstract:

Biml (Business Intelligence Markup Language) is a programming language for creating business intelligence objects. It is a simple XML that can be extended with small nuggets of C# or VB code to automatically generate SQL scripts, SSIS packages and SSAS cubes. It will allow you to turn tedious repetitive tasks into reusable scripts - no more drag-and-dropping! Using Biml will significantly cut down development time, reduce errors and improve quality of your code. In this session, you'll find out everything you need to know to start with Biml development. Our focus will be on SSIS solutions.

SessionID: 70424

Microsoft and Big Data - An Overview of the Power Tools and more!

Back to calendar

Event Date: 24-03-2018 - Session time: 09:40:00 - Track: Analytics and Visualization

Speaker: David Patrick

Title: Microsoft and Big Data - An Overview of the Power Tools and more!

Abstract:

Come see Microsoft's Power tools demonstrated for advanced analytics and hear about Microsoft's embrace of Open Source and the Hadoop platform. We'll also present on Microsoft's tools for handling Big Data, such as the Parallel Data Warehouse and HDInsights.

SessionID: 70862

Source Control and Database Projects - Just Do It

Back to calendar

Event Date: 24-03-2018 - Session time: 09:40:00 - Track: Application Database Development

Speaker: Leslie Weed

Title: Source Control and Database Projects - Just Do It

Abstract:

If you aren't using database projects you should be and if you aren't using any source control well..... NOW IS THE TIME. We'll review basic functionality and purpose of both and walk through how they work together. Let's talk about the type of foundation pieces you need to pay attention to and how to organize this into team and agile work. Lots of tips and tricks to remove the often experienced headaches that developers have experienced with implementing both of these items.

SessionID: 72644

SQL Server Big Data Solution: SQL Server 2016, PolyBase and Dell EMC Isilon storage

Back to calendar

Event Date: 24-03-2018 - Session time: 09:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Matthew Smith

Title: SQL Server Big Data Solution: SQL Server 2016, PolyBase and Dell EMC Isilon storage

Abstract:

SQL Server 2016 and PolyBase can connect directly to HDFS on Isilon, eliminating the need for additional traditional big data infrastructure. This presentation will cover an overview of PolyBase, Isilon, a SQL Server/Isilon big data architecture and query performance test results comparing SQL Server PolyBase to Hortonworks.

SessionID: 72768

Challenges and Opportunities in Creating Accessible Power BI Reports

Back to calendar

Event Date: 24-03-2018 - Session time: 09:40:00 - Track: Analytics and Visualization

Speaker: Meagan Longoria

Title: Challenges and Opportunities in Creating Accessible Power BI Reports

Abstract:

Accessibility is catering for your whole audience, including those with disabilities. According to the US Census Bureau, 19 percent of the of the population had a disability in 2010. Do you know if your reports are designed in an inclusive way such that everyone can use them? This can be especially important if you are making reports for government entities, educational institutions, or the general public. In this session, we'll discuss accessibility standards and regulations of which you may want to be aware, how users with disabilities can consume Power BI reports, and guidance and pitfalls when designing inclusive reports.

SessionID: 73438

Beginning Powershell for DBAs 1.0

Back to calendar

Event Date: 24-03-2018 - Session time: 09:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Beginning Powershell for DBAs 1.0

Abstract:

The time has come where DBAs can no longer afford to ignore powershell. Not only has it become an integral part of SQL Server, but we’re being asked to do things on a much grander scale than ever before; things that can only be done with powershell. This session will take you from nothing and explain what powershell is all about. I’m going to show you how the more things change the more they stay the same and if you master the basics of powershell in this session, you’ll be able to work with powershell not only in SQL Server, but also at the file system level, in Exchange, IIS, Windows, and anything else. So in this session I’m going to show you the basics you need to get your powershell career started.

SessionID: 73587

Implementing a Cloud Analytics Solution: Options, costs and more

Back to calendar

Event Date: 24-03-2018 - Session time: 09:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Marc Beacom

Title: Implementing a Cloud Analytics Solution: Options, costs and more

Abstract:

If you’ve looked at the cloud, you’ve realized the large number of options you have to implement a complete cloud analytics solution. You have the ability to deploy dashboards, data ingestion and integration and advanced analytics to the cloud that will empower data-driven decisions for your organizations. This talk will discuss and review options you have to run Cloud Analytic Solutions from the three major cloud providers – AWS, Azure and Google Cloud Platform.

SessionID: 74438

Know Your Options: Databases on Amazon Web Services

Back to calendar

Event Date: 24-03-2018 - Session time: 09:40:00 - Track: Cloud Architecture, Development Deployment

Speaker: Gabriel Villa

Title: Know Your Options: Databases on Amazon Web Services

Abstract:

Are you considering to move your databases to Amazon Web Services but unsure of your options? Understand the possibilities to leverage Infrastructure as a Service and Platform as a Service and what is the best for cloud solution your situation. Gain insights from years of lessons learned to minimize your maintenance and costs. Discover scaling possibilities for relational and NoSQL databases to petabyte size demands. I will demonstrate how to get started with the basics of managed services and platforms for running databases on AWS. DBAs, hear how to use managed relational databases such as MS SQL Server with minimal administration. Architects, Developers, DBAs, Managers or IT Professionals, discover other cloud options such as managed NoSQL or scaling your own instances with resizable elastic compute cloud. Take home an introduction from in-memory cache to petabyte-scale data warehouse databases in the Amazon cloud.

SessionID: 78476

Operationalizing Data Science

Back to calendar

Event Date: 24-03-2018 - Session time: 09:40:00 - Track: Advanced Analysis Techniques

Speaker: Carlos Bossy

Title: Operationalizing Data Science

Abstract:

The challenge of developing a predictive model is the secret sauce that data science practitioners strive to achieve. While sophisticated predictive models can be game changers that give you a competitive edge, they must be nurtured and closely watched to ensure they perform as expected. This session shows attendees how to build a framework and develop a data model that handles prediction logging, prediction performance management, and analysis. A case study will show predictions can degrade and ultimately fail, further emphasizing the importance of tracking their performance.

SessionID: 69685

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

Back to calendar

Event Date: 24-03-2018 - Session time: 10:50:00 - Track: Application Database Development

Speaker: Mike Byrd

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

Abstract:

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

SessionID: 70396

Very Large Databases in your future

Back to calendar

Event Date: 24-03-2018 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Peterson

Title: Very Large Databases in your future

Abstract:

Your databases may not be terabyte-sized yet, but they're probably growing every day. We'll look at lessons learned

from working with multi-terabyte, very large databases (VLDBs) in the real world. Topics include storage layout decisions, unique tuning challenges, HA/DR implications, and database restores, along with shoehorning backups, re- indexing and DBCC checks into itty-bitty maintenance windows. As a bonus, many of the techniques also apply to smaller databases and consolidated servers that run hundreds of databases.

SessionID: 70558

Make Power BI Your Own with the Power BI APIs

Back to calendar

Event Date: 24-03-2018 - Session time: 10:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Steve Wake

Title: Make Power BI Your Own with the Power BI APIs

Abstract:

Power BI makes accessing data from various sources and building advanced visualizations for analytics easy to do. Behind the scenes Power BI is built on standard technologies and APIs that allow it to be customized in multiple ways to fit in with your environment the way you need it to. In this session we will walk though samples and demos that show how you can extend Power BI with custom visualizations, access custom data sources, embed various Power BI elements in your applications, and be able to push your data into a Power BI report/dashboard. Each of these items take advantage of the Power BI APIs in different ways and we will discuss each and provide the code samples for you to take back and get a head start. This session will be showing code to access the Power BI REST API using C# and NodeJS along with some M for accessing and manipulating custom data sources.

SessionID: 70997

Harnessing D3.js to visualize geographical data

Back to calendar

Event Date: 24-03-2018 - Session time: 10:50:00 - Track: Information Delivery

Speaker: Adam Durazo

Title: Harnessing D3.js to visualize geographical data

Abstract:

SessionID: 72723

Introduction to R

Back to calendar

Event Date: 24-03-2018 - Session time: 10:50:00 - Track: Analytics and Visualization

Speaker: Jeff Renz

Title: Introduction to R

Abstract:

You will learn R data structures such as vectors, matrices, lists and data frames; how to work with variables; common data transformations; and lastly how to leverage R's graphical capabilities.

SessionID: 72868

How To Talk To Your Storage Admin

Back to calendar

Event Date: 24-03-2018 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Marsha Pierce

Title: How To Talk To Your Storage Admin

Abstract:

A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.

SessionID: 75806

Azure SQL and Azure Data Warehouse 101

Back to calendar

Event Date: 24-03-2018 - Session time: 10:50:00 - Track: Cloud Architecture, Development Deployment

Speaker: Mark Moore

Title: Azure SQL and Azure Data Warehouse 101

Abstract:

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

SessionID: 78260

#GetModern With Dell EMC

Back to calendar

Event Date: 24-03-2018 - Session time: 11:50:00 - Track: Strategy and Architecture

Speaker: Matthew Smith

Title: #GetModern With Dell EMC

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

Amazon Web Services RDS with SQL Server

Back to calendar

Event Date: 24-03-2018 - Session time: 13:15:00 - Track: Cloud Architecture, Development Deployment

Speaker: Christopher Wolff

Title: Amazon Web Services RDS with SQL Server

Abstract:

Are you wanting to make more SQL Servers but don't want to invest in more hardware? Then Relational Database Service (RDS) in Amazon Web Services (AWS) maybe the right choice for you. We will begin with creating a server using the Amazon Web Console, explore how to automate installation through Cloud Formation, show how to administrate the service, and walk through advanced features. Whether you are familiar with AWS or are brand new to it, this presentation should at least give you a good overview to decide if RDS is the right service for you.

SessionID: 70205

Branding Yourself for a Dream Job

Back to calendar

Event Date: 24-03-2018 - Session time: 13:15:00 - Track: Professional Development

Speaker: Steve Jones

Title: Branding Yourself for a Dream Job

Abstract:

Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.

SessionID: 71335

Essential Linux for the SQL Server DBA

Back to calendar

Event Date: 24-03-2018 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Kellyn Pot'Vin-Gorman

Title: Essential Linux for the SQL Server DBA

Abstract:

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

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

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

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

SessionID: 72702

Power BI embedded into your application

Back to calendar

Event Date: 24-03-2018 - Session time: 13:15:00 - Track: BI Information Delivery

Speaker: Rajesh Chawla

Title: Power BI embedded into your application

Abstract:

Embedding analytics into your application can provide several benefits including improved customer engagement, additional data revenue, and product differentiation.

We'll take a look at how to embed analytics using Power BI and cover a step wise approach to embedding, expected costs, gotchas, alternatives and a demo.

SessionID: 73009

The Power of Data: The Complete Beginners Data Warehouse Kit

Back to calendar

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

Speaker: Leslie Andrews

Title: The Power of Data: The Complete Beginners Data Warehouse Kit

Abstract:

For many of us data is scattered in many different systems. We almost all have data that someone wants to compare or track but can't without a lot of manual manipulation. So, how do you tie disparate systems together? With a Data Warehouse! In this presentation you will get the skills you need to start building your own. We will discuss the basics of what a Data Warehouse is, the tools needed to create, deploy and manage the Data Warehouse process, and the benefits of using the data you collect to manage operational processes and create data visualizations. After attending this session you will be able to return to your job and amaze people with your ability to show them the power of the data!

SessionID: 73326

Get Your Optimizer to Give up All Its Secrets

Back to calendar

Event Date: 24-03-2018 - Session time: 13:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Hansen

Title: Get Your Optimizer to Give up All Its Secrets

Abstract:

You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated? In this session, we will examine details the query optimization process that are not very well known. We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient. Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos? We'll do just that, and then take it a step further with a unique visualization tool that I have created. With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.

SessionID: 73394

T-SQL's Hidden Support Feature

Back to calendar

Event Date: 24-03-2018 - Session time: 13:15:00 - Track: Application Database Development

Speaker: Jennifer McCown

Title: T-SQL's Hidden Support Feature

Abstract:

The most effective T-SQL support feature comes installed with every edition of SQL Server, is enabled by default, and costs no overhead. Yet, the vast majority of database administrator underutilize or completely neglect it. That feature's name is "comments".

In this session, Microsoft Certified Master Jennifer McCown will demonstrate the various commenting methods that make code supportable. Attendees will#160;learn what’s important in a header comment, use code blocking to edit code, build a comprehensive help system, and explore alternative comment methods in stored procedures, SSIS packages, SSRS reports, and beyond. These methods help prevent errors and reduce troubleshooting.

SessionID: 69515

Reducing The Surface Area Of Risk in Data Security

Back to calendar

Event Date: 24-03-2018 - Session time: 14:25:00 - Track: Information Delivery

Speaker: Tim Gorman

Title: Reducing The Surface Area Of Risk in Data Security

Abstract:

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

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

SessionID: 71863

LIVE SQL Server 2017 LINUX Availability Group build-out!

Back to calendar

Event Date: 24-03-2018 - Session time: 14:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Walden

Title: LIVE SQL Server 2017 LINUX Availability Group build-out!

Abstract:

Full LIVE build-out of a 3-node SQL Server 2017 Availability Group, on Linux, using native clustering tools! We'll have some things already prepped due to time constraints, but we'll cover general configuration of the operating system, installing SQL Server, and finish with an controlled failover of SQL Server using native Linux utilities. We'll talk about each step along the way.

SessionID: 72749

Whoa! Backup, what happened? The Basics of Backups

Back to calendar

Event Date: 24-03-2018 - Session time: 14:25:00 - Track: Strategy and Architecture

Speaker: Greg Moore

Title: Whoa! Backup, what happened? The Basics of Backups

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

Secrets of the Query Optimizer Revealed Using Trace Flag 86xx

Back to calendar

Event Date: 24-03-2018 - Session time: 14:25:00 - Track: Application Database Development

Speaker: Kevin Kline

Title: Secrets of the Query Optimizer Revealed Using Trace Flag 86xx

Abstract:

You already know a thing or two about tuning a SQL query on Microsoft SQL Server. You can read an execution plan and know the most significant red flags to look for. And you have also learned how to track the most important metrics revealed by features like the SET STATISTICS. But you want to take it up another level!

First, we will examine using undocumented trace flags to look at the steps of parsing, binding, and query optimization. Second, we will show how SQL Server builds internal memo structures and it interrogates the heuristics of the optimizer search space. Finally, we will discuss a secret trace flag that gives the optimizer more time to produce alternative execution plans for queries that push the boundaries of extreme database processing.

SessionID: 73216

Ch-ch-ch-changes! How to keep track of what's happening to your data

Back to calendar

Event Date: 24-03-2018 - Session time: 14:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Weigel

Title: Ch-ch-ch-changes! How to keep track of what's happening to your data

Abstract:

Join Tim Weigel for a discussion of four ways you can keep track of how your data is changing: Change Data Capture, Change Tracking, Temporal Tables, and good ol' fashioned triggers. Tim will present a quick overview of each method, including use cases and positives and negatives.

SessionID: 73336

Where Do I Start? A guide for the new SQL Techie.

Back to calendar

Event Date: 24-03-2018 - Session time: 14:25:00 - Track: Professional Development

Speaker: William Barnes

Title: Where Do I Start? A guide for the new SQL Techie.

Abstract:

How do you get what you need to be a DBA... or anything for that matter? Well, this session is built around giving you not only great resources to help bridge those knowledge gaps... but is a great place to have an open discussion regarding ideas around education, certification, and how to build your own testing environments. Expect me to try and pry a conversation out of this room.

SessionID: 73502

Data Science for the SQL Server Professional

Back to calendar

Event Date: 24-03-2018 - Session time: 14:25:00 - Track: BI Platform Architecture, Development Administration

Speaker: Reeves Smith

Title: Data Science for the SQL Server Professional

Abstract:

Data science is the new buzz word in the IT community. How many times have you heard the term in recent meetings with your management or development teams? Businesses are looking to data science and advanced analytics to increase their competitive advantage. What does this mean to a SQL Server professional?

Data professionals play a key role in the success of a data science project. With your overall knowledge of the data architecture within your enterprise, you are in an excellent position to help with the next advanced analytics project at your company. What are the additional skills needed to improve your role in the next data science project? Learn about the different parts of a data science project and how they relate to the skillset you already have.