Nr: 806
SQLSaturday #806 - Charlotte 2018
SessionID: 83559
Applying Data Warehousing Principles
Event Date: 20-10-2018 - Session time: 08:45:00 - Track: Design
Speaker: Spencer Swindell
Title: Applying Data Warehousing Principles
Abstract:
Many data analysts typically begin to work with data as a single flat table. While this works for small datasets, as the size of the data grows these naive methods do not scale. Processing records takes longer, queries become more complex, and introducing new datasets is inconsistent at best. In order to solve these problems, we must take into account the underlying architecture of our data and how it should be modeled. During this talk we will discuss key concepts, patterns, and techniques for designing a data model that is simple to query, scales with your data, and is extendable to new datasets.
SessionID: 83998
Getting started with Postgresql
Event Date: 20-10-2018 - Session time: 08:45:00 - Track: Evolve
Speaker: Ramu Pulipati
Title: Getting started with Postgresql
Abstract:
Postgresql is an Open Source, Free, and a Popular alternative database for building software applications. In this session, we will look into Getting started with Postgresql, Review unique features that make it exciting to work with and wrap up the presentation with strategies to deploy and scale for on-premise and cloud deployments.
SessionID: 84028
Administrating and Managing SQL Server on Linux
Event Date: 20-10-2018 - Session time: 08:45:00 - Track: Support
Speaker: Prabhaker Potharaju
Title: Administrating and Managing SQL Server on Linux
Abstract:
SessionID: 84545
Moving Data with Azure Data Factory
Event Date: 20-10-2018 - Session time: 08:45:00 - Track: Innovate
Speaker: Andy Leonard
Title: Moving Data with Azure Data Factory
Abstract:
Azure Data Factory - ADF - is a cloud data engineering solution. ADF version 2 sports a snappy web GUI (graphical user interface) and supports the SSIS Integration Runtime (IR) - or "SSIS in the Cloud."
Attend this session to learn:
- How to build a "native ADF" pipeline;
- How to lift and shift SSIS to the Azure Data Factory integration Runtime; and
- ADF Design Patterns to execute and monitor pipelines and packages.
SessionID: 84783
Automating the Data-Centric Deployment Pipeline
Event Date: 20-10-2018 - Session time: 08:45:00 - Track: Build
Speaker: John Welch
Title: Automating the Data-Centric Deployment Pipeline
Abstract:
SessionID: 85672
Digital Storytelling with Power BI
Event Date: 20-10-2018 - Session time: 08:45:00 - Track: Analyze
Speaker: Devin Knight
Title: Digital Storytelling with Power BI
Abstract:
Power BI has many amazing features built in to help guide a user through understanding their data better. Some of the most recently added features like Drillthrough, Bookmarks, Spotlight and the Selection Pane have made digital storytelling even more exciting.
In this session, you will learn how to leverage these features to tell a story with your own data.
SessionID: 85685
Introduction to DAX
Event Date: 20-10-2018 - Session time: 08:45:00 - Track: Build
Speaker: Mitchell Pearson
Title: Introduction to DAX
Abstract:
Data Analysis Expressions were specifically designed by Microsoft to be easy to learn and powerful, with just the basics of DAX you can significantly improve the analytical value of your data model. In this introductory to DAX session, you will learn the basics of using the DAX language to create calculated columns and calculated measures. In addition to the basics, this session will introduce you to creating aggregates, conditional functions, and time intelligence calculations.
SessionID: 86634
Encrypting Data within SQL Server
Event Date: 20-10-2018 - Session time: 08:45:00 - Track: Design
Speaker: Thomas Norman
Title: Encrypting Data within SQL Server
Abstract:
Data breaches abound! SQL Server has several options to encrypt the data, Transparent Data Encryption, Cell Level Encryption and SQL Server 2016 Always Encrypted. Let’s review each option to hide the encrypt the data and learn about my experiences implementing Always Encrypted.
SessionID: 83938
Getting Started with PowerShell Basics for SQL Server Administration
Event Date: 20-10-2018 - Session time: 10:00:00 - Track: Support
Speaker: Michael Wharton
Title: Getting Started with PowerShell Basics for SQL Server Administration
Abstract:
Overview of PowerShell Basics and how to manage SQL server using PowerShell scripts. In this session you will learn the basics on building scripts using PowerShell and then learn the basics of using PowerShell for SQL server administration.
SessionID: 84040
Successfully Running SQL Server in AWS
Event Date: 20-10-2018 - Session time: 10:00:00 - Track: Design
Speaker: Brian Carrig
Title: Successfully Running SQL Server in AWS
Abstract:
Amazon Web Services (AWS) is the world's largest public cloud hosting provider, with many companies successfully running SQL server on AWS infrastructure, but trying to make sense of the available options can be daunting. In this session, we will explore the options available for running SQL server in AWS, either as a managed service or using dedicated EC2 instances. We will document the different storage options, High Availability strategies, as well as important security and maintenance caveats. We will also cover various licensing approaches available when running SQL server in AWS.
SessionID: 84096
Getting your Database off to a Right Start
Event Date: 20-10-2018 - Session time: 10:00:00 - Track: Scale
Speaker: Andrew Kelly
Title: Getting your Database off to a Right Start
Abstract:
SessionID: 84678
Database Corruption! Preventing Disaster to your Database.
Event Date: 20-10-2018 - Session time: 10:00:00 - Track: Support
Speaker: Jeff Mlakar
Title: Database Corruption! Preventing Disaster to your Database.
Abstract:
Every DBA should know about database corruption because it can be a resume generating event. A corrupt database can ruin your day, affect system stability, lead to unnecessary downtime, and possibly data loss.
In this presentation we will explore database corruption, learn how to diagnose, and see what we can do to fix it. We will discuss the causes, dispel some myths, and learn what questions to ask. After this, we dive into discovering the root cause and putting a plan in place to stop it in the future. Demos will illustrate diagnosing, troubleshooting, and fixing database corruption. Prepare to break a database and go through the steps to return it back to a usable state.
Beginners will benefit along with others who may one day find themselves with a corrupt database. By the end of the session, you will have the tools and understanding necessary to take corrective action and prevent your databases from corruption!
SessionID: 85336
Database Corruption
Event Date: 20-10-2018 - Session time: 10:00:00 - Track: Perform
Speaker: Stephen Muliokela
Title: Database Corruption
Abstract:
Database corruption could happen to you. When it happens to you, do you know what to do? Will you realize quick enough that you have corruption?
The presentation begins by talking about how to detect the corruption and the different strategies for handling unique corruption issues.
Highlight of topics
- Why corruption occurs?
- Detecting corruption – how SQL Servers detects corruption at the page level.
- Different types of corruption- e.g. False alarms, memory corruption etc.
- Limitation of DBCC how to speed the DBCC process.
- Undocumented DBCC commands.
- Monitoring I/O errors.
- Verifying backup for corruption.
SessionID: 85579
Managing SQL Server on Windows Server Core
Event Date: 20-10-2018 - Session time: 10:00:00 - Track: Support
Speaker: Frank Henninger
Title: Managing SQL Server on Windows Server Core
Abstract:
Lately it seems more sysadmins are embracing Windows Server Core as the OS of choice for virtualized servers. SQL Server is (almost) perfectly happy to run in this environment but how do you manage on an OS without a full desktop.
We'll cover what versions and features are supported, how to install sql server via a configuration file, and what common activities are changed when you move into a Core environment.
SessionID: 85607
Event Date: 20-10-2018 - Session time: 10:00:00 - Track: Perform
Speaker: Justin Randall
Abstract:
Your databases are growing and consuming ever-increasing amounts of storage. This rapid unceasing growth creates difficult challenges managing query response times, backups, recovery time, data transfer and essential maintenance. What's a DBA to do? SQL Server data compression is a proven option for saving storage space and improving performance.
In this presentation you will learn how data compression works, how to determine when data compression is the right option, and other planning and implementation considerations.
SessionID: 83824
DevOps: Consistent Deployments / Team Development
Event Date: 20-10-2018 - Session time: 11:15:00 - Track: Build
Speaker: Thomas Norman
Title: DevOps: Consistent Deployments / Team Development
Abstract:
Unless you are developing code by yourself, you face challenges of working with several team members. Different people are changing code which affects the code someone else is working on. In addition, there will be teams working on different projects at the same time. In the middle of the projects, an emergency fix needs to be deployed to Production. So where is the code, when do you shared it with others, when do you get the code that has been shared, where is the production code branch located. How do I branch and when do merge? How do I get a release branch? Let me share with you how we are handling this area of DevOps.
SessionID: 84054
Power BI Models, Productivity, and NODE.JS
Event Date: 20-10-2018 - Session time: 11:15:00 - Track: Design
Speaker: Michael Moen
Title: Power BI Models, Productivity, and NODE.JS
Abstract:
After those demos, use NODE.JS to bring all sorts of data into Power BI. This will conclude with QA on PBI and NODE>
SessionID: 84100
Grokking the Grammar of Graphics
Event Date: 20-10-2018 - Session time: 11:15:00 - Track: Analyze
Speaker: Kevin Feasel
Title: Grokking the Grammar of Graphics
Abstract:
SessionID: 85523
Introduction to the R Programming Language for BI Professionals
Event Date: 20-10-2018 - Session time: 11:15:00 - Track: Analyze
Speaker: Jeff Renz
Title: Introduction to the R Programming Language for BI Professionals
Abstract:
The modern BI professional is taking on the challenge of operationalizing data science. Most BI developers are very strong in TSQL but their exposer to advanced statistics and visualizations were limited by what is available in the TSQL language. The R programming language allows us to clean, visualize, and apply advanced statistical methods to data.
In this session I will demonstrate how to use R Studio to generate and test R scripts; generate R visuals in PowerBI; call R code in machine learning workflows; and execute R code in SQL Server. Additionally, I will cover these R programming fundamentals: creating and assigning variables; performing simple calculations; understanding R data types; vectors; matrices; factors; lists; data frames; and ggplot2 graphics.
SessionID: 85625
New T-SQL capabilities in SQL Server 2016, 2017, and beyond
Event Date: 20-10-2018 - Session time: 11:15:00 - Track: Evolve
Speaker: Aaron Bertrand
Title: New T-SQL capabilities in SQL Server 2016, 2017, and beyond
Abstract:
Discover the ins and outs of some of the newest capabilities of our favorite data language. From SESSION_CONTEXT() to DROP IF EXISTS to CREATE OR ALTER to new query-level hints, you’ll walk away with a long list of reasons to consider upgrading to the latest version or moving to Azure SQL Database.
SessionID: 85627
Social Intelligence at Work: What it is, Why it Matters, and How to Improve it
Event Date: 20-10-2018 - Session time: 11:15:00 - Track: Evolve
Speaker: Linda Groszyk
Title: Social Intelligence at Work: What it is, Why it Matters, and How to Improve it
Abstract:
SessionID: 85871
Data Architectures in Azure for Analytics Big Data
Event Date: 20-10-2018 - Session time: 11:15:00 - Track: Design
Speaker: Melissa Coates
Title: Data Architectures in Azure for Analytics Big Data
Abstract:
SessionID: 85874
SentryOne Tools for Productivity and Performance
Event Date: 20-10-2018 - Session time: 12:30:00 - Track: Perform
Speaker: Kevin Kline
Title: SentryOne Tools for Productivity and Performance
Abstract:
Whether you are hosting in your office, in a data center, or in the cloud, SentryOne covers monitoring, alerting, and tuning to help you get the most out of your servers – including servers that aren’t running SQL Server. In this session, your hosts will guide you through time saving strategies for managing performance across hybrid environments - whether you are running physical or virtual servers, SQL Server, Azure SQL Database, APS, or Azure SQL Data Warehouse. You will see demonstrations of SentryOne software highlighting configuration and performance pitfalls and leave with a better understanding of performance problems you may be currently missing. SentryOne provides a unified management experience; it’s your ONE platform for physical, virtual, and cloud performance.
SessionID: 86725
How to Get Management Buy-In for Compliant Provisioning Software
Event Date: 20-10-2018 - Session time: 12:30:00 - Track: Analyze
Speaker: Andy Leonard
Title: How to Get Management Buy-In for Compliant Provisioning Software
Abstract:
How to Get Management Buy-In for Compliant Provisioning Software
SessionID: 83983
Event Date: 20-10-2018 - Session time: 13:45:00 - Track: Perform
Speaker: Tracy Boggiano
Abstract:
In this session, we will be combining three open source tools - Telegraf, InfluxDB, and Grafana - into an inexpensive system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances. We will learn what metrics to collect, how to use the tools to collect performance metrics and then we'll put it all together in an interactive dashboard for easy visualization.
SessionID: 84016
Getting started with SQL Azure Database: What you need to know
Event Date: 20-10-2018 - Session time: 13:45:00 - Track: Build
Speaker: Jim Donahoe
Title: Getting started with SQL Azure Database: What you need to know
Abstract:
Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore.
In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible.
By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.
SessionID: 84409
Keeping Data Science Simple in Azure Machine Learning Studio
Event Date: 20-10-2018 - Session time: 13:45:00 - Track: Analyze
Speaker: Zach Maddigan
Title: Keeping Data Science Simple in Azure Machine Learning Studio
Abstract:
- Addressing a business problem
- Understanding the data
- Conducting and executing a “science” experiment.
In this session we will walk through how to approach a data science problem in various phases using predictive analytics in Azure Machine Learning Studio.
SessionID: 84474
SQL Server Then and Now: Changing the State of Long-held Beliefs
Event Date: 20-10-2018 - Session time: 13:45:00 - Track: Evolve
Speaker: Maxwell Myrick
Title: SQL Server Then and Now: Changing the State of Long-held Beliefs
Abstract:
We’ve all heard the rules for SQL Server like separate your data from your log, watch for a disk queue length over 2, and a low Page Life Expectancy always means memory pressure. All of these used to be true, but on today’s hardware and SQL Server versions – they are dangerously outdated. In this session, we will take on a bunch of these old “givens” of SQL Server that everybody has heard and followed, the underlying technological reasons they were true then, how today’s technology has rendered them obsolete, and what the new rules are that you need to know. So whether you are one of the old guard looking to refresh your set of working SQL Server rules or a member of the up-and-comers looking for the facts to win over the old guard, this session is for you.
SessionID: 84598
Your BI Workloads and How They Change in the Cloud (Azure)
Event Date: 20-10-2018 - Session time: 13:45:00 - Track: Design
Speaker: Trey Johnson
Title: Your BI Workloads and How They Change in the Cloud (Azure)
Abstract:
Your organization has made a conscious choice that everything should move to the cloud! You own the current BI workloads for your business and you are not sure what that means?
If so, this session is for you where we explore in depth the workloads around ETL/ELT, Data Management, Analysis Services to support BI for your users. We’ll also talk data security, governance managing your data outside of your 4 walls.
With plenty of ground to cover and an expected level of participation from the audience, this will be a fast paced session with insights into how you can retain aspects of what you have while pursuing the greater opportunities delivering BI on the Cloud affords you.
Attendees will understand what workloads are similar as they move to the cloud
Attendees will develop an appreciation for the benefits the cloud can offer to their BI deployment
Attendees should have the confidence to map out their own plans for making the most of the workloads they’ll change when they move.
SessionID: 85034
Master Data Management with SQL Server 2016 MDS
Event Date: 20-10-2018 - Session time: 13:45:00 - Track: Design
Speaker: Neal Waterstreet
Title: Master Data Management with SQL Server 2016 MDS
Abstract:
SessionID: 85645
Index Trek
Event Date: 20-10-2018 - Session time: 13:45:00 - Track: Perform
Speaker: Sandra Peele
Title: Index Trek
Abstract:
When learning something new, it’s helpful to have a foundation. Yet, indexes are often taught with only one or two sentences of explanation before CREATE INDEX. I recall a student, exasperated by the textbook definition saying, “Will someone just SHOW ME an index!” The goal of this high level presentation is to do just that. In this 50 minute mission, we’ll explore nonclustered and clustered indexes as well as the strange new world of columnstore indexes. Rather than focus on space and time requirements of indexes and index maintenance, we’ll seek out new understanding:
• Why well-designed indexes speed up queries.
• Why queries must be engineered carefully to use indexes.
• Why indexes have both benefits and drawbacks.
After the mission, you’ll be prepared to further explore the galaxy of indexes.
This presentation was co-produced with Stéphane Faroult, author of Getting the Message Across: Using Slideware Effectively for Technical Presentations and The Art of SQL.
SessionID: 85688
Use Python to Make Better Email Reports With Graphs
Event Date: 20-10-2018 - Session time: 13:45:00 - Track: Build
Speaker: Mike Burek
Title: Use Python to Make Better Email Reports With Graphs
Abstract:
Email reports are common and useful for reporting when a process succeeded or failed. You might have also figured out how to make it easier to read with HTML content, and even HTML tables. Sometimes, it still needs more, and needs to be easier.
Come see how to use Python to add graphs of your data to emails as a picture. Plus, you'll see some easier ways to create HTML content for emails using Python.
You'll be surprised how little code is needed for this. It's simpler than you think!
SessionID: 83996
Azure Machine Learning: Four Tips from the Pros
Event Date: 20-10-2018 - Session time: 15:00:00 - Track: Analyze
Speaker: Brad Llewellyn
Title: Azure Machine Learning: Four Tips from the Pros
Abstract:
SessionID: 84208
Resume Tips-Go Beyond the Print Out
Event Date: 20-10-2018 - Session time: 15:00:00 - Track: Evolve
Speaker: Leveat Ruse
Title: Resume Tips-Go Beyond the Print Out
Abstract:
From the basics to the advanced. From paper, to LinkedIn, to what happens when the hiring manager "googles" you. We will explore what makes a GREAT online presence!
SessionID: 84525
The Ultimate Maintenance Plan
Event Date: 20-10-2018 - Session time: 15:00:00 - Track: Support
Speaker: Edward Roepe
Title: The Ultimate Maintenance Plan
Abstract:
Is your SQL Server running slower and slower? Do you prefer a proactive rather than a reactive approach to managing SQL Server? Do you worry about being able to recover in an emergency? If you answer yes to any of the above this session is for you.
We will start by exploring some of the maintenance options that are available. We will then explore the popular utility program by Ola Hallengren and how to implement. Next, we will explore the other areas of SQL Server that need to be maintained like history tables in MSDB. Finally, we will explore the different options when maintenance windows are tight.
At the end of this session you will be able to: (1) Choose a maintenance program for your SQL Servers; (2) Program and schedule the maintenance programs; (3) Ensure that the SQL Server is running at optimum performance each day.
SessionID: 84794
Event Date: 20-10-2018 - Session time: 15:00:00 - Track: Perform
Speaker: Jared Poché
Abstract:
SessionID: 85315
Avoid Shiny Object Syndrome and Create Visualizations That Last
Event Date: 20-10-2018 - Session time: 15:00:00 - Track: Design
Speaker: Jeff Burns
Title: Avoid Shiny Object Syndrome and Create Visualizations That Last
Abstract:
You’ve spent days (or even weeks) getting the data perfect. After a few days, you've put together a dashboard that is so flashy it could be on display in Times Square. You check in with the stakeholders a month later only to learn they no longer use it. :(
Your diagnosis: Shiny Object Syndrome. It’s real. It’s prevalent. And almost completely preventable.
In this session you will leave with 5 field-tested rules to follow when creating visualizations that will make your users return to your dashboard over and over…and compel them to share it with others!
SessionID: 85503
SQL Restore: Optimizing Your Data Recovery
Event Date: 20-10-2018 - Session time: 15:00:00 - Track: Support
Speaker: Jamie Wick
Title: SQL Restore: Optimizing Your Data Recovery
Abstract:
How long will the restoration process take?
Can it run faster?
In this session, we'll answer these questions by looking at how to establish and maintain a Restoration Baseline and the options available for performance tuning database restores.
SessionID: 85534
Custom Auditing in SSIS
Event Date: 20-10-2018 - Session time: 15:00:00 - Track: Design
Speaker: Meghana Vasavada
Title: Custom Auditing in SSIS
Abstract:
However, what if you encountered an error, or a package failure? Suppose, a Data warehouse developer is performing an ETL to load a Dimension of a Data mart and would like to track the Data being processed. Audit Transformation Component cannot perform the job effectively.
So lets have an insight of how Auditing can be done by designing an SSIS package that captures the Error information, DML operation on the table (Inserts/Updates/Deletes) along with the package metadata.
We'll create a package with an event handler that loads Data from a Staging to Dimension and creates an Audit table to track information on Data processing.