sqlsathistory

Nr: 918

Back to Main list

SQLSaturday #918 - Charlotte 2019

Start Time (24h)	Speaker	Track	Title
08:30:00	Bill Anton	BI Platform Architecture, Development Administration	What You Need To Know About Processing Tabular Models and Power BI Datasets
08:30:00	Prabhaker Potharaju	Enterprise Database Administration Deployment	SQL Server on Linux and containers
08:30:00	Lucas Feiock	Analytics and Visualization	Intro to SQL Spatial Data: Location Analytics
08:30:00	Anders Pedersen	Application Database Development	Why I use cursors in SQL for performance
08:30:00	John Morehouse	Enterprise Database Administration Deployment	What You'll Love in SQL Server 2019
08:30:00	Leslie Andrews	Application Database Development	The Power of Data: The Complete Beginners Data Warehouse Kit
09:30:00	Shabnam Watson	Advanced Analysis Techniques	Aggregations in Power BI: How to unlock the power of big datasets
09:30:00	Johnathan Sluder	Application Database Development	The Key. The Whole Key. And Nothing but the Key! So help me Codd!
09:30:00	Simon Kingaby	Cloud Application Development Deployment	Moving Data to the Cloud (with Azure Data Factory)
09:30:00	Sandra Peele	Application Database Development	Working with Multiple DBMS Platforms: You're Not in Kansas Anymore
09:30:00	Michael Wharton	Professional Development	Deep dive into disk drives, partitions, controllers and hardware to improve SQL server performance.
09:30:00	Melissa Coates	BI Platform Architecture, Development Administration	Power BI Architecture End-to-End
09:30:00	Erika Haase Nalley	BI Information Delivery	PR for PR! Get the word out on Paginated Reports.
10:30:00	Peter Doyle	Application Database Development	Become a T-SQL Pivoting Ninja in 60 Minutes Or Less
10:30:00	Monica Rathbun	Enterprise Database Administration Deployment	Performance Tuning, Getting the Biggest Bang for Your Buck
10:30:00	Matt Gordon	Analytics and Visualization	Feelings Quantified: Scoring, Storing, and Exploring Social Media Sentiment
10:30:00	Ramu Pulipati	Application Database Development	Migrating to PostgreSQL
10:30:00	Hiram Fleitas	Cloud Application Development Deployment	The Power Platform Game Changer
10:30:00	Leveat Ruse	Professional Development	Tips for Creating Growing a Successful Professional Network
10:30:00	Adrian Mee	Application Database Development	SQL Server Management Studio - Beyond the basics
11:30:00	Julie Smith	Analytics and Visualization	Using Python In Power BI
11:30:00	Ed Watson	BI Platform Architecture, Development Administration	The Psychology of Better Power BI Reporting
11:30:00	Ganesh Lohani	Professional Development	Building your Microsoft Business Intelligence (MSBI) Career
11:30:00	Thomas Norman	Application Database Development	Encrypting Data within SQL Server
11:30:00	Justin Dearing	Application Database Development	Version control with GIT for the DBA
11:30:00	Stephen Muliokela	Enterprise Database Administration Deployment	Database Corruption
11:30:00	Andrew Pruski	Cloud Application Development Deployment	Azure SQL Containers
12:30:00	Ivan Peev	BI Platform Architecture, Development Administration	SQL Server REST Integration the Easy Way
12:30:00	Kevin Kline	Enterprise Database Administration Deployment	Fix Queries Fast with SentryOne Plan Explorer
13:30:00	oscar garcia	Application Database Development	Improve distributed system and web app performance by using in-memory cache system
13:30:00	Bhakthi Liyanage	Cloud Application Development Deployment	Building End-to-End ML Pipeline with Azure Machine Learning Services
13:30:00	Meagan Longoria	BI Platform Architecture, Development Administration	Creating Accessible Power BI Reports
13:30:00	Kevin Feasel	Enterprise Database Administration Deployment	Optimizing Backup Performance Using Data Science Techniques
13:30:00	Jared Poché	Advanced Analysis Techniques	Using DMVs for Performance Root Cause
13:30:00	Marc Bushong	Application Database Development	A Beginner's Guide to Using GIT
13:30:00	Anthony Mendoza	Application Database Development	Test Driven Development (TDD) for T-SQL Database Development
14:30:00	Solomon Rutzky	Strategy and Architecture	Module Signing: Use Certificates to Replace TRUSTWORTHY, EXECUTE AS, and Cross-DB Pwnership Chaining
14:30:00	Art Cardenas	Enterprise Database Administration Deployment	NoSQL vs. SQL, Real life database platform compare
14:30:00	Chris Skorlinski	Information Delivery	911 What's your emergency?
14:30:00	Kevin Kline	Application Database Development	Intro to SQL Server Internals and Architecture
14:30:00	Andrew Kelly	Enterprise Database Administration Deployment	CCI - Implementation Lessons Learned
14:30:00	Tracy Boggiano	Other	More Common Than You Think: Mental Illness in Tech
15:30:00	Ashwini Jain	BI Platform Architecture, Development Administration	How to automate row level security in Power BI using DAX and SSAS
15:30:00	Chris Pollock	BI Platform Architecture, Development Administration	Dynamic Data Delivery Solution with Azure Data Factory
15:30:00	Slava Murygin	Enterprise Database Administration Deployment	SQL Server on your fingertips
15:30:00	Priscilla Camp	BI Information Delivery	How UCF IT uses Power BI to monitor our IT Services
15:30:00	Rob Volk	Application Database Development	That's So Metadata: Discover Your Database From The Inside
15:30:00	Donna Ellis Wilson	Professional Development	Failure needs to be an option.
15:30:00	Chris Voss	Application Database Development	A Moment in Time: About Temporal Tables

SessionID: 95943

What You Need To Know About Processing Tabular Models and Power BI Datasets

Back to calendar

Event Date: 07-12-2019 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Bill Anton

Title: What You Need To Know About Processing Tabular Models and Power BI Datasets

Abstract:

Ever wondered what's happening under the covers when processing a tabular model or a Power BI dataset? Why is it taking so much memory? How can I make it run faster? Am I running into a resource bottleneck?

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

In this session, you'll learn what actually happens and in what order during model processing, the difference between the various processing types, performance considerations and most common resource bottlenecks. We'll also cover the most common processing patterns and the associated trade-offs.

Keywords: Analysis Services, SSAS, Power BI

SessionID: 96928

SQL Server on Linux and containers

Back to calendar

Event Date: 07-12-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Prabhaker Potharaju

Title: SQL Server on Linux and containers

Abstract:

Overview of What is SQL Server on Linux. The Platform Abstraction Layer (SQLPAL), SQL Server on Linux feature compatibility, Implementing SQL Server on Linux. Performance and Security of SQL Server on Linux, HA/DR with SQL server on Linux.

What’s next for SQL Server in containers, Container orchestration using Kubernetes and SQL Server HA on Kubernetes.

SessionID: 97970

Intro to SQL Spatial Data: Location Analytics

Back to calendar

Event Date: 07-12-2019 - Session time: 08:30:00 - Track: Analytics and Visualization

Speaker: Lucas Feiock

Title: Intro to SQL Spatial Data: Location Analytics

Abstract:

In this session we will cover Spatial Data Types available in SQL Server. Then we will review the basics of spatial queries and the different methods to create points, lines, and polygons. Finally we will demo a few examples of location analytics and how to integrate into other data sets.

SessionID: 97992

Why I use cursors in SQL for performance

Back to calendar

Event Date: 07-12-2019 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Anders Pedersen

Title: Why I use cursors in SQL for performance

Abstract:

"Cursors are bad, never use them!" How many times have you been told this by your senior DBAs or developers?

In this session I will explore why I use cursors to solve certain problems. Discuss when they are appropriate, and when they are not, as well as a performance comparison to non-cursor based solutions.

SessionID: 98465

What You'll Love in SQL Server 2019

Back to calendar

Event Date: 07-12-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: John Morehouse

Title: What You'll Love in SQL Server 2019

Abstract:

Technology moves at a blinding pace and the SQL Server platform is no exception. With the release of SQL Server 2019, you will see some great improvement in the database engine of the platform. In this session, you will examine some of the new features of SQL Server 2019 such as Accelerated Database Recovery (ADR), resumable index creation, UTF-8 support, online columnstore rebuilds, an improved data truncation message, among other features. After this session you will have a better understanding how you can leverage SQL Server 2019 to enhance your database environment.

SessionID: 99046

The Power of Data: The Complete Beginners Data Warehouse Kit

Back to calendar

Event Date: 07-12-2019 - Session time: 08:30:00 - Track: Application Database Development

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

Aggregations in Power BI: How to unlock the power of big datasets

Back to calendar

Event Date: 07-12-2019 - Session time: 09:30:00 - Track: Advanced Analysis Techniques

Speaker: Shabnam Watson

Title: Aggregations in Power BI: How to unlock the power of big datasets

Abstract:

Aggregations are one of the most important optimization methods for managing big datasets in Power

BI. Combined with Direct Query storage mode, they allow big datasets to be analyzed efficiently by answering high level analytical queries quickly from memory while sending more detailed queries back to the source database. In this session, you will learn about the concept of aggregations, different table storage modes in Power BI, how to set up aggregation tables and configure them to improve query performance. You will also learn how to use DAX Studio to determine if the aggregations are being used. Prerequisite: Basic knowledge of data modeling in Power BI Desktop.

SessionID: 96094

The Key. The Whole Key. And Nothing but the Key! So help me Codd!

Back to calendar

Event Date: 07-12-2019 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Johnathan Sluder

Title: The Key. The Whole Key. And Nothing but the Key! So help me Codd!

Abstract:

In this demo-heavy session, we will discuss best practices when it comes to data normalization, why it's important to normalize your data, and to go about getting started. We will take a look at a set of data and discuss the best way to bring it into Third Normal Form. We will focus on The Key (1NF), The Whole Key (2NF), and Nothing but The Key (3NF)!

SessionID: 96413

Moving Data to the Cloud (with Azure Data Factory)

Back to calendar

Event Date: 07-12-2019 - Session time: 09:30:00 - Track: Cloud Application Development Deployment

Speaker: Simon Kingaby

Title: Moving Data to the Cloud (with Azure Data Factory)

Abstract:

You need to move data. A lot of data. To the cloud. You’ve got data in a variety of on- and off-site data sources. There are several ways to do it. Some of them can be quite easily implemented using Azure Data Factory. Learn how to use variables and looping in your Data Factory pipelines. Use the Integration Runtime to pull directly from on-site sources. See how to upload files to blob storage and import them. Learn how to trigger Data Factory activities. And, learn how to keep all those connection strings and passwords secret in Azure Vault. After this session, you will have tools that you can readily implement in your own data migrations.

SessionID: 98229

Working with Multiple DBMS Platforms: You're Not in Kansas Anymore

Back to calendar

Event Date: 07-12-2019 - Session time: 09:30:00 - Track: Application Database Development

Speaker: Sandra Peele

Title: Working with Multiple DBMS Platforms: You're Not in Kansas Anymore

Abstract:

Imagine you have a new employee with valuable SQL experience, but from a different DBMS platform.  Or imagine you’ve been assigned to a project that involves a DBMS other than SQL Server.  What do you need to know?  In this high-level presentation, Sandra will highlight differences between default Windows installations of Oracle, Postgres, DB2, SQLite, MySQL, and SQL Server.  She’ll share her experience moving from one platform to another and what she has found to be the most important thing to keep in mind when working with a new DBMS or working with a new employee who comes from another DBMS environment.

This presentation is for anyone with a basic knowledge of SQL.  It was co-produced with Stéphane Faroult, author of The Art of SQL, SQL Success and other technical books.  The presentation uses techniques found in his latest book, Getting the Message Across: Using Slideware Effectively for Technical Presentations.

SessionID: 98896

Deep dive into disk drives, partitions, controllers and hardware to improve SQL server performance.

Back to calendar

Event Date: 07-12-2019 - Session time: 09:30:00 - Track: Professional Development

Speaker: Michael Wharton

Title: Deep dive into disk drives, partitions, controllers and hardware to improve SQL server performance.

Abstract:

All kind of things can be done for improving query performance and IOPS (IO operations), however what if your hardware and disk drives were not properly configure to give SQL the best performance. This session review the basics of disk drives, partitions, controllers and storage hardware and then looks into ways to improve SQL performance with correct disk drive architecture.

SessionID: 99000

Power BI Architecture End-to-End

Back to calendar

Event Date: 07-12-2019 - Session time: 09:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Melissa Coates

Title: Power BI Architecture End-to-End

Abstract:

This session is a technical overview of Power BI architecture options. Power BI terminology and its most prominent features and functionality will also be reviewed to help attendees gain an understanding of the broad collection of tools, services, and features which represent the Power BI ecosystem.

SessionID: 99162

PR for PR! Get the word out on Paginated Reports.

Back to calendar

Event Date: 07-12-2019 - Session time: 09:30:00 - Track: BI Information Delivery

Speaker: Erika Haase Nalley

Title: PR for PR! Get the word out on Paginated Reports.

Abstract:

Take your company’s BI reporting to the next level with the Power BI Report Builder.

We will cover: • How Report Builder differs/complements Power BI • Importing your Power BI dataset • Building a Paginated Report • Best Practices for Business Reports for max ROI

The Report Builder is to Power BI as the Lasagna Pasta Accessory is to the Kitchen Aid. It works with the same data set and transforms sections of your report into perfect sheets! (and did I mention there is no export row limit?!?!?)

SessionID: 95927

Become a T-SQL Pivoting Ninja in 60 Minutes Or Less

Back to calendar

Event Date: 07-12-2019 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Peter Doyle

Title: Become a T-SQL Pivoting Ninja in 60 Minutes Or Less

Abstract:

Stop wasting time using Excel Pivot Tables. Create Pivot Tables in SQL with ease.

Become a query writing ninja who uses the Pivot operator to move unique column values into multiple column names for better data insight. In this demo-heavy presentation, you will learn how to create pivot tables enhanced with multiple aggregate columns and column totals using Rollup and Cube operators, and the grouping function. Attendees will also learn to use the Unpivot Operator.

Come join me, and by the end of this session, you will have the knowledge to level up your pivoting skills to that of a ninja or maybe even *Chuck Norris. *Not Possible

SessionID: 95957

Performance Tuning, Getting the Biggest Bang for Your Buck

Back to calendar

Event Date: 07-12-2019 - Session time: 10:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Monica Rathbun

Title: Performance Tuning, Getting the Biggest Bang for Your Buck

Abstract:

Everyone wants to know if there are magic buttons you can push to make SQL Server run faster, better and more efficiently. In this session we will go over some of my go-to performance tricks that you can implement to get the biggest improvement with the least amount of change. When it comes to performance tuning, every second counts. We will cover memory optimization, isolation levels, trace flags, statistics, configuration changes and more. I’ll go over real life scenarios we come across as consultants and the changes we made to fix them.

SessionID: 96008

Feelings Quantified: Scoring, Storing, and Exploring Social Media Sentiment

Back to calendar

Event Date: 07-12-2019 - Session time: 10:30:00 - Track: Analytics and Visualization

Speaker: Matt Gordon

Title: Feelings Quantified: Scoring, Storing, and Exploring Social Media Sentiment

Abstract:

The job of a data professional is evolving rapidly, driving many of us to platforms and technologies that were not on our radar screen a few months ago. I am certainly no exception to that trend. Most of us aren't just monitoring backups and tuning queries - we are collaborating with teams throughout the company to provide them data and insights that drive decisions. Cloud providers are democratizing technologies and techniques that were complicated and proprietary just a few months ago. This presentation walks you through how a silly idea from a football podcast got me thinking about how Azure Logic Apps, the Cognitive Services API, Azure SQL DB, and Power BI combine to provide potentially powerful insights to any company with a social media and sales presence. Join me as I walk you through building a solution that can impact your company's bottom line - and potentially yours too!

SessionID: 98467

Migrating to PostgreSQL

Back to calendar

Event Date: 07-12-2019 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Ramu Pulipati

Title: Migrating to 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 migrate, deploy and scale for on-premise and cloud deployments.

SessionID: 98487

The Power Platform Game Changer

Back to calendar

Event Date: 07-12-2019 - Session time: 10:30:00 - Track: Cloud Application Development Deployment

Speaker: Hiram Fleitas

Title: The Power Platform Game Changer

Abstract:

This is a game changing session. Lets go 0 to 100 real quick by building a business app in minutes using PowerApps, Microsoft Flow and SQL Server. Then lets look at the enterprise-grade security to publish and share your app to iOS, Android, Web and Windows 10.

• AGENDA:

1. T-SQL Stored Procedure on SQL Server database (on-prem or cloud).
2. PowerApps (Inputs, Button, Outputs)
3. Flow (Input, SQL Server, Variables, Respond, Tests)
4. Gateway
5. Publish Share with Enterprise Governance.

We'll have time for QA. Maybe we'll even ask Cortana a few questions. I look forward to seeing you there!

SessionID: 98890

Tips for Creating Growing a Successful Professional Network

Back to calendar

Event Date: 07-12-2019 - Session time: 10:30:00 - Track: Professional Development

Speaker: Leveat Ruse

Title: Tips for Creating Growing a Successful Professional Network

Abstract:

Building a network is much more than LinkedIn and is crucial in career success. In this session, we will explore ideas and tips for building growing a successful network. Everything from "ice breakers" to cultivating your current network.

SessionID: 99885

SQL Server Management Studio - Beyond the basics

Back to calendar

Event Date: 07-12-2019 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Adrian Mee

Title: SQL Server Management Studio - Beyond the basics

Abstract:

Almost all of us use SQL Server Management Studio to interact with SQL Server, and thankfully it works right out of the box. But did you know there are so many tricks and shortcuts that hide just under the surface that can make working with SSMS feel like second nature?

In this session, I will take a fresh install of SSMS and step through customizing it. I will demonstrate features and help you become more efficient at utilizing SSMS to it's fullest potential - a lot of the time without using the mouse. Finally, I’ll show you some cool text editing tricks that will take your SQL skills to a whole new level.

SessionID: 95954

Using Python In Power BI

Back to calendar

Event Date: 07-12-2019 - Session time: 11:30:00 - Track: Analytics and Visualization

Speaker: Julie Smith

Title: Using Python In Power BI

Abstract:

Python is a powerful general purpose programming language that has emerged as one of the main tools of data scientists. Python was added to Power BI in June of 2018. This session will demonstrate the two areas python can be used inside the Power BI desktop-- how to leverage python scripts inside the Power BI query editor and how to use python visuals in Power BI reports.

SessionID: 96040

The Psychology of Better Power BI Reporting

Back to calendar

Event Date: 07-12-2019 - Session time: 11:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ed Watson

Title: The Psychology of Better Power BI Reporting

Abstract:

In this course we identify some common mistakes that we see in the business world using Power BI. We will identify the psychology behind the reporting techniques needed to create powerful and effective reports. The attendee will leave the class ready to write better reports using Power BI in the real world.

SessionID: 96095

Building your Microsoft Business Intelligence (MSBI) Career

Back to calendar

Event Date: 07-12-2019 - Session time: 11:30:00 - Track: Professional Development

Speaker: Ganesh Lohani

Title: Building your Microsoft Business Intelligence (MSBI) Career

Abstract:

Are you excited to know about the MSBI tools and work as a Business Intelligence Professional, a dynamic and rewarding career in Information Technology? If yes, this is the right time and place for you. In this session, I will give you the overview of the MSBI tools (SSIS, SSRS, SSAS, Power BI, Azure Analytics). I will also provide you some insights to build the MSBI career and to leverage the learning curve in Microsoft Data Platform, based on my knowledge and experience, the proven strategies and techniques.

SessionID: 96160

Encrypting Data within SQL Server

Back to calendar

Event Date: 07-12-2019 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Thomas Norman

Title: Encrypting Data within SQL Server

Abstract:

Data breaches abound! Do you want to keep your company out of the headlines? What are some of the data privacy laws affecting you? How will encrypting data affect your database performance? What data fields should you encrypt? What else can you do to protect your sensitive data?

In this session, we will review each option to encrypt data within SQL Server, Transparent Data Encryption, Cell Level Encryption and Always Encrypted. While we look at the encryption options, we will review both on-premise and cloud offerings. This session will deep dive into setting up Always Encrypted encryption and share experiences implementing the encryption.

You will leave this session with a deeper understanding about SQL Server encryption options and how encryption can affect your performance. Also, you will gather information on how to fully protect and review your sensitive data usage.

SessionID: 96441

Version control with GIT for the DBA

Back to calendar

Event Date: 07-12-2019 - Session time: 11:30:00 - Track: Application Database Development

Speaker: Justin Dearing

Title: Version control with GIT for the DBA

Abstract:

In 2005, Linus Torvalds developed the version control system (VCS) git. Since then, it has become as platform agnostic and ubiquitous as the internet. Microsoft has fully embraced Git. It powers modern on premise and cloud versions of TFS (now know as Azure Devops) as well GitHub, which Microsoft recently acquired.

What does this mean to a DBA? Whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in version control.

In my session. We'll cover:

How do I use SSDT to help prevent developers from using code first ORMs? What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? We will be covering using git from both the command line and Visual Studio.

SessionID: 98453

Database Corruption

Back to calendar

Event Date: 07-12-2019 - Session time: 11:30:00 - Track: Enterprise Database Administration Deployment

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

1. Why corruption occurs?
2. Detecting corruption – how SQL Servers detects corruption at the page level.
3. Different types of corruption- e.g. False alarms, memory corruption etc.
4. Limitation of DBCC how to speed the DBCC process.
5. Undocumented DBCC commands.
6. Monitoring I/O errors.
7. Verifying backup for corruption.

SessionID: 98550

Azure SQL Containers

Back to calendar

Event Date: 07-12-2019 - Session time: 11:30:00 - Track: Cloud Application Development Deployment

Speaker: Andrew Pruski

Title: Azure SQL Containers

Abstract:

As containers are becoming more and more prevalent, this session provides an introduction to the different options of running containers in Azure.

I'll cover the following different options for running Docker containers in Azure: - Azure Container Registry Azure Container Instances Azure Kubernetes Services

This session is aimed at SQL Server DBAs and Developers who have some experience with Docker and want to know the different options that are available in Azure.

Each topic will be backed up with demos which will show how simple it is to get up and running with these technologies.

SessionID: 100145

SQL Server REST Integration the Easy Way

Back to calendar

Event Date: 07-12-2019 - Session time: 12:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ivan Peev

Title: SQL Server REST Integration the Easy Way

Abstract:

REST has become the dominant technology for providing programmatic access to various cloud applications. We will show an easier way to interact with REST APIs with support for any authentication mechanism, support for complex, composite structures and unlimited flexibility. If you are a SQL Server user, you definitely must attend this session and get all your questions answered.

SessionID: 100282

Fix Queries Fast with SentryOne Plan Explorer

Back to calendar

Event Date: 07-12-2019 - Session time: 12:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Kline

Title: Fix Queries Fast with SentryOne Plan Explorer

Abstract:

Using SentryOne Plan Explorer, a 100% free product, DBAs and Devs write better performing SQL code in a fraction of the time otherwise possible. Plus, troubleshooting existing SQL code becomes a fast, easy, and visually vibrant experience. Learn all the ways SentryOne Plan Explorer helps in this demo-packed session!

SessionID: 96177

Improve distributed system and web app performance by using in-memory cache system

Back to calendar

Event Date: 07-12-2019 - Session time: 13:30:00 - Track: Application Database Development

Speaker: oscar garcia

Title: Improve distributed system and web app performance by using in-memory cache system

Abstract:

Applications often integrate with APIs for the purpose of retrieving data from a disk-based storage system like SQL Server. This poses challenges due slow queries and amount of data sent down the wire. In this presentation, we discuss the performance concerns with this type of architecture especially for big data scenarios. Oscar Garcia shows how to address those concerns by following a series of steps in which an application is refactored with minimum changes to support an in-memory data store and data streaming. We start by discussing the challenges when using data queries. We structure the data for in in-memory storage. We replace the API requests with real-time data streaming.

Learning Objectives:

SQL Server Query Challenges

Redis Cache Basic Operations and Structure

Angular App with Socket.io integration

Node.js Backend with Socket.io and Redis support

Real-time data integration

SessionID: 96179

Building End-to-End ML Pipeline with Azure Machine Learning Services

Back to calendar

Event Date: 07-12-2019 - Session time: 13:30:00 - Track: Cloud Application Development Deployment

Speaker: Bhakthi Liyanage

Title: Building End-to-End ML Pipeline with Azure Machine Learning Services

Abstract:

Azure Machine Learning services is an integrated, end-to-end data science and advanced analytics solution that provides professional data scientists and data engineers with tools not only to develop ML models, but also tools for data preparation and wrangling, data visualization, model deployment, and model management at cloud scale. This session will teach the attendees how to get their hands on each tool in the stack.

SessionID: 96403

Creating Accessible Power BI Reports

Back to calendar

Event Date: 07-12-2019 - Session time: 13:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Meagan Longoria

Title: 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? 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: 96437

Optimizing Backup Performance Using Data Science Techniques

Back to calendar

Event Date: 07-12-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Feasel

Title: Optimizing Backup Performance Using Data Science Techniques

Abstract:

One of the most important tasks for a database administrator is taking (and testing!) backups. As databases get larger and larger, the amount of time it takes to perform a backup can grow as well, to the point where your backups take longer than your available backup window. There are several settings we can use to optimize backup performance, such as buffer counts, maximum transfer size, and the number of files, but trying every combination of settings on a single production-sized database could take weeks or even months. In this talk, we will apply data science techniques to the problem of backup settings optimization and look at different models for approaching the problem and analyzing data. Some statistics background would be helpful, but is not required; the big requirement is a desire to speed up backups.

SessionID: 97981

Using DMVs for Performance Root Cause

Back to calendar

Event Date: 07-12-2019 - Session time: 13:30:00 - Track: Advanced Analysis Techniques

Speaker: Jared Poché

Title: Using DMVs for Performance Root Cause

Abstract:

What are your first steps when you hear one of your SQL Servers is having a performance problem? In this demo-driven session, we will discuss key DMVs that can provide us data quickly. We will examine a number of example queries that can lead us to a quick root cause analysis in a number of different situations. This session will be kept at a very functional level, and should be accessible for anyone interested in SQL Server performance.

SessionID: 98343

A Beginner's Guide to Using GIT

Back to calendar

Event Date: 07-12-2019 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Marc Bushong

Title: A Beginner's Guide to Using GIT

Abstract:

Source Control is a wonderful resource to improve team collaboration, reduce the risk of problems from lone wolf development and track change efficiently. Developers are already familiar with source control, but ANY Analysts or Operations teams can benefit! If you are struggling to use source control, are frustrated with not understanding the what, why, and how, or want to start using source control then look no further! We will cover using source control for code in stored procedures and queries for SSMS, SSIS packages, SSAS models and cubes, and SSRS reports.

With this session, you will learn the foundational knowledge to not only to apply to your workplace right away but to lay the groundwork to continue building your skills in Git. We will cover basic terms/concepts of how Git works, understanding the process flow, executing some basic commands in Git, understanding why a merge conflict happens and how to solve it, and using different GUIs if the command line isn't your thing.

SessionID: 99009

Test Driven Development (TDD) for T-SQL Database Development

Back to calendar

Event Date: 07-12-2019 - Session time: 13:30:00 - Track: Application Database Development

Speaker: Anthony Mendoza

Title: Test Driven Development (TDD) for T-SQL Database Development

Abstract:

This session will cover the incorporation of Agile's Test Driven Development (TDD) into traditional T-SQL Database Development. The session will show the benefits of integrating this methodology into your database development processes. These benefits would include proper unit testing as well as the prevention of introducing performance issues into production.

SessionID: 96704

Module Signing: Use Certificates to Replace TRUSTWORTHY, EXECUTE AS, and Cross-DB Pwnership Chaining

Back to calendar

Event Date: 07-12-2019 - Session time: 14:30:00 - Track: Strategy and Architecture

Speaker: Solomon Rutzky

Title: Module Signing: Use Certificates to Replace TRUSTWORTHY, EXECUTE AS, and Cross-DB Pwnership Chaining

Abstract:

We often need to grant a higher-than-ideal level of permissions to a Login or Role so that someone can: start a SQL Agent job (but you don't want them to edit anything), get data from a DMV that requires "VIEW SERVER STATE" permission (but that permission gives access to too much data), query across databases, TRUNCATE a table, etc. These problems are usually solved with some combination of: EXECUTE AS (i.e. Impersonation), cross-DB ownership chaining, or TRUSTWORTHY ON. Unfortunately, those options are all security risks.

Module Signing — https://ModuleSigning.info/ — is more flexible and secure, but requires a Certificate or Asymmetric Key. Those can be confusing to work with, and the security mechanism isn't intuitive. However, that confusion ends here.

Come learn how to have more secure, granular permissions that handle cross-DB tasks, Dynamic SQL, and SQLCLR. See what module signing can do, how certificates and asymmetric keys work, and realize it's not as hard as you thought.

SessionID: 98164

NoSQL vs. SQL, Real life database platform compare

Back to calendar

Event Date: 07-12-2019 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Art Cardenas

Title: NoSQL vs. SQL, Real life database platform compare

Abstract:

NoSQL is here, along with traditional SQL. In this session I will guide you to compare 3 different database technologies: Microsoft SQL Server, Mongo DB (Document) and Neo4J (Graph) databases. We will go from basic concepts, language syntax, Local Cloud installation and operation, will focus on Azure. Depending on your needs, the 3 of them have great use for different use cases.

SessionID: 98878

911 What's your emergency?

Back to calendar

Event Date: 07-12-2019 - Session time: 14:30:00 - Track: Information Delivery

Speaker: Chris Skorlinski

Title: 911 What's your emergency?

Abstract:

Come hear these "emergency" stories called into Microsoft's SQL Server Product Support team. I'll cover common backup\restore problems, SQL Server not starting, lost data, crash dumps, and infectious SQL found on Web just to name a few. Learn background to the problem and what was done to correct in hope of avoiding your own SQL Server emergency.

SessionID: 99146

Intro to SQL Server Internals and Architecture

Back to calendar

Event Date: 07-12-2019 - Session time: 14:30:00 - Track: Application Database Development

Speaker: Kevin Kline

Title: Intro to SQL Server Internals and Architecture

Abstract:

Let’s face it. You can effectively do many IT jobs related to SQL Server without knowing the internals of how SQL Server works. Many great developers, DBAs, and designers get their day-to-day work completed on time and with reasonable quality while never really knowing what’s happening behind the scenes. But if you want to take your skills to the next level, it’s critical to know SQL Server’s internal processes and architecture. This session will answer questions like:

•   What are the various areas of memory inside of SQL Server?
  

•   How are queries handled behind the scenes?
  

•   What does SQL Server do with procedural code, like functions, procedures, and triggers?
  

•   What happens during checkpoints?  Lazywrites?
  

•   How are IOs handled with regards to transaction logs and database?
  

•   What happens when transaction logs and databases grow or shrinks?
  

SessionID: 99150

CCI - Implementation Lessons Learned

Back to calendar

Event Date: 07-12-2019 - Session time: 14:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrew Kelly

Title: CCI - Implementation Lessons Learned

Abstract:

Are you thinking of converting your large databases from traditional row store tables to Column Store? If so then you will want to attend this session. We will discuss some important lessons learned from actual deployments of CCI into production and highlight some key areas you want to focus on ahead of time. There are often many ways you can do things but getting it right the first time is crucial with CCI conversions on large scale databases. Come see what these are before it's too late.

SessionID: 99160

More Common Than You Think: Mental Illness in Tech

Back to calendar

Event Date: 07-12-2019 - Session time: 14:30:00 - Track: Other

Speaker: Tracy Boggiano

Title: More Common Than You Think: Mental Illness in Tech

Abstract:

Mental illness is more common than you think. One in four Americans suffers from a mental illness each year. In the tech community, this is often not talked about. Many times, people feel alone and isolated in the tech community with us mostly being introverted people. It is time to start talking about mental illness out in the open and honestly about how it affects us and those around us.

In this session, we will talk about what mental illness is and what it is not. How my mental illness has affected me. How it effects the tech industry. How mental illness can affect you and how you can tell if you are starting to have issues. What to say and what not to say to people you know that are affected by mental illness. Finally, how to get help and where reach out for help.

SessionID: 95971

How to automate row level security in Power BI using DAX and SSAS

Back to calendar

Event Date: 07-12-2019 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ashwini Jain

Title: How to automate row level security in Power BI using DAX and SSAS

Abstract:

Power BI is a business analytics solution that lets you visualize your data and share insights across your organization or embed them in your app or website. This session is for users are who want to automate Power BI row-level security by replicating the security of another data source such as corporate ERP. Many organizations maintain tight data security within their organization. Row-level security needs to be defined within Power BI. This can be difficult if you have many users and security changes happen quite often. If you are using a corporate ERP system that has security built into it, you would end up doing redundant work of managing security at two places, in ERP as well as in Power BI. DAX query can be used to filter out rows based on user ID/user name. We will go over the demo of the entire process starting from bringing data into SSAS, creating data model, applying row level security publish the report. Never again you will have to manually manage roles within Power BI.

SessionID: 96106

Dynamic Data Delivery Solution with Azure Data Factory

Back to calendar

Event Date: 07-12-2019 - Session time: 15:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Chris Pollock

Title: Dynamic Data Delivery Solution with Azure Data Factory

Abstract:

This session will show attendees a way to dynamically ingest data into a centralized data store (i.e. SQL Server or Data Lake) using Azure Data Factory from multiple sources. If going into SQL Server the processes will automatically create all needed tables and stored procedures for the process.

SessionID: 98673

SQL Server on your fingertips

Back to calendar

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

Speaker: Slava Murygin

Title: SQL Server on your fingertips

Abstract:

You are a DBA, you are the Elite of Database World. Your time is valuable and you should not make a typing mistake.

In the first hour we'll go through the most common SSMS keyboard shortcuts and I'll show you how to setup your own shortcuts with your own queries. In the second hour I'll show you how to set the best SQL queries developed by the best brains in the industry in your own SSMS and apply it to your environment.

SessionID: 99014

How UCF IT uses Power BI to monitor our IT Services

Back to calendar

Event Date: 07-12-2019 - Session time: 15:30:00 - Track: BI Information Delivery

Speaker: Priscilla Camp

Title: How UCF IT uses Power BI to monitor our IT Services

Abstract:

Curious how to monitor your IT Services using Power BI? Come see how UCF tracks our IT services to ensure our staff, students, and faculty are meeting their teaching, learning, research, and service objectives. Utilizing ITIL (Information Technology Infrastructure Library) practices, ServiceNow data, and Power BI we are able to take quantitative information and turn it into graphical visualizations to aid leadership and our customers in making informed decisions.

SessionID: 99055

That's So Metadata: Discover Your Database From The Inside

Back to calendar

Event Date: 07-12-2019 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Rob Volk

Title: That's So Metadata: Discover Your Database From The Inside

Abstract:

Have you ever needed to learn a new database design and don't know where to begin? Or are trying to find out why a query doesn't perform well? Or need to provide security information to auditors or your security team?

SQL Server has numerous metadata facilities available to help you with these tasks and more. Functions, dynamic management views, and system stored procedures can illuminate details from a single column up through an entire SQL Server instance. We will demonstrate metadata techniques to help you:

• Document your database schema objects such as procedures, functions, tables, columns and indexes
• Investigate performance and look for bottlenecks and tuning opportunities
• Discover metadata to administer your databases backups, index maintenance, and security
• Apply your own metadata using extended properties

We will also cover the official Microsoft documentation on these features and other resources on how to use them.

SessionID: 99114

Failure needs to be an option.

Back to calendar

Event Date: 07-12-2019 - Session time: 15:30:00 - Track: Professional Development

Speaker: Donna Ellis Wilson

Title: Failure needs to be an option.

Abstract:

Turbo charge your career, your projects, and your team by changing the way you approach failure, learning, practice, and praise. This session will cover research in cognitive psychology and neuroscience in an actionable path forward to eliminate perfectionism and other career-stifling behaviors and thoughts, which those of us in the tech industry are particularly susceptible to.

SessionID: 99137

A Moment in Time: About Temporal Tables

Back to calendar

Event Date: 07-12-2019 - Session time: 15:30:00 - Track: Application Database Development

Speaker: Chris Voss

Title: A Moment in Time: About Temporal Tables

Abstract:

Are you a developer or analyst who has been asked what changed for a particular record, and thus need to get the record at a given time? Well, in 2016, we were introduced to system-versioned temporal tables in SQL Server, which can tell you the full history of what the data looked like if you ever need to fend off questions. You will get to know the business uses for temporal tables, how they are built, the ways to query temporal table records, converting your current in-memory tables, and other elements to consider.

This site is open source. Improve this page.