sqlsathistory

Nr: 961

Back to Main list

SQLSaturday #961 - Albany 2020 – Virtual 2020

Start Time (24h) Speaker Track Title
08:15:00 Thomas Grohser Cloud Application Development Deployment Datacenter and/or Cloud - When to Use One, the Other, or Both
08:15:00 Dave Bland Enterprise Database Administration Deployment Is my Server having Memory Pressure and how do I find the source
08:15:00 Brian Hansen Database Development Window Functions in SQL
09:30:00 Matt Slocum Enterprise Database Administration Deployment Hardware Hints For The SQL DBA - Don't Let Your IT Department Hand You A Big Bag Of Hurt
09:30:00 Greg Moore Professional/Personal Development So you want to Present: Tips and Tricks of the trade
09:30:00 Paresh Motiwala Enterprise Database Administration Deployment Lightning Talks
10:45:00 Paresh Motiwala Enterprise Database Administration Deployment Azure Vs. AWS: And the winner is!!!
10:45:00 John Miner Data Architecture Design How to audit and prevent unwanted user actions.
10:45:00 Sunil Kadimdiwan Business Intelligence Power BI: Advanced development techniques
10:45:00 Javier Villegas Enterprise Database Administration Deployment New Features in SQL Server 2019
12:00:00 Amit Banerjee Cloud Application Development Deployment SQL Server: From the Edge to the Cloud
13:00:00 James Serra Business Intelligence Data Lake Overview
13:00:00 Taiob Ali Enterprise Database Administration Deployment Need to Monitor Any Azure Resource? Must Learn Kusto Query Language
13:00:00 Kevin Mackey Database Development Graph Databases–How and Why
13:00:00 Deborah Melkin Database Development A Practical Starter Guide to SQL Notebooks
14:15:00 Ray Kim Professional/Personal Development Networking 101: Building professional relationships
14:15:00 Andy Yun Database Development How Intelligent Query Processing improves T-SQL performance
14:15:00 David Patrick Data Science Microsoft and Big Data - An Overview of the Power Tools and more!
14:15:00 David Klee Enterprise Database Administration Deployment Modern SQL Server CPU Architectures for Performance
15:30:00 Andy Levy Database Development Keys to a Healthy Relationship with SQL Server
15:30:00 Rie Irish Enterprise Database Administration Deployment 10 DBA Tasks for Azure SQL: Whats Different from On-Prem
15:30:00 Sarah Patrick Cloud Application Development Deployment Case Study: How I used SharePoint, Power Automate, Power Apps, and Forms to build a Speaker Database
15:30:00 Belinda Allen Business Intelligence Step by Step – Building (a Real Use Case for the) Power Platform Solution

SessionID: 104317

Datacenter and/or Cloud - When to Use One, the Other, or Both

Back to calendar

Event Date: 25-07-2020 - Session time: 08:15:00 - Track: Cloud Application Development Deployment

Speaker: Thomas Grohser

Title: Datacenter and/or Cloud - When to Use One, the Other, or Both

Abstract:

As with all other items in your toolbox the datacenter (local or in the cloud) needs to be used correctly.

This session will show the various types and sizes of workloads, show you how to categorize them, look at the requirements of your SLA (Service Level Agreement), and find the right location (cloud, datacenter, hybrid) for the data. To wrap things up, we look at ways to validate that the SLA can be fulfilled and how to estimate and compare the costs.

SessionID: 104618

Is my Server having Memory Pressure and how do I find the source

Back to calendar

Event Date: 25-07-2020 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

Title: Is my Server having Memory Pressure and how do I find the source

Abstract:

As we all know, SQL Server loves memory and will use as much as it can get. However, when there is memory pressure we need to use our DBA skills to identify what is causing the pressure. During this session we will explore how SQL Server uses memory and how to properly configure memory settings. We will discuss the use of DMVs and other tools to help us find what is consuming the most memory and some potential solutions.

SessionID: 105325

Window Functions in SQL

Back to calendar

Event Date: 25-07-2020 - Session time: 08:15:00 - Track: Database Development

Speaker: Brian Hansen

Title: Window Functions in SQL

Abstract:

No, they don't have anything to do with the operating by the same name. Instead, window functions allow us to calculate a single value based on a set of rows, and we have extraordinary control over which rows get used as the inputs. We'll start by covering what a window function is and will discuss the syntax and usage of the OVER clause in detail. We will also cover the three classes of window functions (ranking, aggregate and analytic) with focus on some commonly used functions as well some "gotchas" with some of these functions. You will learn how this class of functions can help you write more performant code.

SessionID: 104118

Hardware Hints For The SQL DBA - Don't Let Your IT Department Hand You A Big Bag Of Hurt

Back to calendar

Event Date: 25-07-2020 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Slocum

Title: Hardware Hints For The SQL DBA - Don't Let Your IT Department Hand You A Big Bag Of Hurt

Abstract:

Most IT departments are stretched thin and do not usually have the opportunity to fully investigate the true needs of the database infrastructure. In this session, we will cover a number of aspects that will help the SQL DBA have informed conversations with IT in order to ensure that better decisions are made when it comes to compute and storage hardware in order to deliver improved performance and reduced licensing cost.

This session will also cover some options that the DBA can investigate if they have been handed hardware that is not quite up to par.

SessionID: 105110

So you want to Present: Tips and Tricks of the trade

Back to calendar

Event Date: 25-07-2020 - Session time: 09:30:00 - Track: Professional/Personal Development

Speaker: Greg Moore

Title: So you want to Present: Tips and Tricks of the trade

Abstract:

So you've decided to take the leap into presenting. Maybe it's at your local user group, maybe it's at SQL Saturday. This talk will guide you through the process of selecting a topic, preparing for it and actually giving it. We'll talk about what can go wrong and how to handle that. We'll also talk about what can be done to prevent something from going wrong in the first place. What are some good guidelines to follow and when can, or even should, you break them. This will be partly interactive so come with questions and be prepared to be asked some.

SessionID: 107100

Lightning Talks

Back to calendar

Event Date: 25-07-2020 - Session time: 09:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Paresh Motiwala

Title: Lightning Talks

Abstract:

Five fast-paced 10-minutes-or-less sessions on a variety of topics:

Paresh Motiwala: Exploring Azure Data Studio Thomas Grohser: New in SQL Server 2019: Persistent Memory John Miner: Don't Lose Your Integrity - Talking about Constraints Sunil Kadimdiwan: Plotting Graph DB in Power BI Andy Yun: How to Utilize Index Tipping Point Data in Plan Explorer

SessionID: 101179

Azure Vs. AWS: And the winner is!!!

Back to calendar

Event Date: 25-07-2020 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Paresh Motiwala

Title: Azure Vs. AWS: And the winner is!!!

Abstract:

You've been given an awful task of comparing two of the most prominent cloud vendors. What would you do?

Amazon Web Services (AWS) and Microsoft Azure are two of the biggest names in public cloud computing. Which one is right for you? To help you make that decision, let’s talk about what each provider brings to the public cloud table, and key differences between them. We will look into the following aspects and more:

SessionID: 101488

How to audit and prevent unwanted user actions.

Back to calendar

Event Date: 25-07-2020 - Session time: 10:45:00 - Track: Data Architecture Design

Speaker: John Miner

Title: How to audit and prevent unwanted user actions.

Abstract:

Abstract:

Many corporations are composed of small divisions located in countries throughout the world. While you might be the lead DBA for your corporation, there are several other employees who have the keys to the kingdom. This presentation will review techniques on how to prevent and/or audit data and schema changes.

Coverage:

1 – Granting correct user access is vital. 2 – DML triggers to keep a DATA audit trail. 3 – DDL triggers to keep a SCHEMA audit trail. 4 – Preventing unwanted DATA modifications. 5 – Preventing unwanted SCHEMA changes. 6 – Preventing table TRUNCATIONS. 7 – LOGIN triggers to control who, what, and when. 8 – Change data capture (CDC) an alternative to triggers. 9 - Which of these techniques apply to an Azure SQL database?

SessionID: 105144

Power BI: Advanced development techniques

Back to calendar

Event Date: 25-07-2020 - Session time: 10:45:00 - Track: Business Intelligence

Speaker: Sunil Kadimdiwan

Title: Power BI: Advanced development techniques

Abstract:

Power BI usage and report development is quite simple to get started. You can produce fantastic reports in a relatively short amount of time.

How about extending the available functionality? How to achieve consistent look and feel? These are important topics, as we get deeper into creating more than couple of views and PBIX files.

In this session, I will show you how you can database queries, custom theme files, custom visuals, parameters and other techniques to make your development efforts easier and keep your users happier.

SessionID: 105190

New Features in SQL Server 2019

Back to calendar

Event Date: 25-07-2020 - Session time: 10:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Javier Villegas

Title: New Features in SQL Server 2019

Abstract:

SessionID: 107143

SQL Server: From the Edge to the Cloud

Back to calendar

Event Date: 25-07-2020 - Session time: 12:00:00 - Track: Cloud Application Development Deployment

Speaker: Amit Banerjee

Title: SQL Server: From the Edge to the Cloud

Abstract:

SQL Server is the world’s leading operational database. Today 98 of the Fortune 100 companies use it to power their mission critical applications across all verticals. In this session, we start by showing the latest features in SQL Server 2019 including an introduction to the analytics features in SQL Server big data clusters. Then we will talk about how Azure SQL offers limitless database using hyperscale, industry leading TCO and how customers can run our data services within their own datacenter using Azure Arc. We also show how SQL running on edge devices is enabling new types of IoT applications by moving 70% of computation to the edge.

SessionID: 100855

Data Lake Overview

Back to calendar

Event Date: 25-07-2020 - Session time: 13:00:00 - Track: Business Intelligence

Speaker: James Serra

Title: Data Lake Overview

Abstract:

SessionID: 101281

Need to Monitor Any Azure Resource? Must Learn Kusto Query Language

Back to calendar

Event Date: 25-07-2020 - Session time: 13:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Taiob Ali

Title: Need to Monitor Any Azure Resource? Must Learn Kusto Query Language

Abstract:

Kusto is a service for storing and running interactive analytics over Big Data, easy to query using Kusto Query Language (KQL). As we make progress in our migration to the cloud, we are learning new ways to monitor and alert on resources and services. Microsoft has consolidated many services under the umbrella of ‘Azure Monitor.’ Whether you are ‘detecting and diagnose issues across applications,’ ‘correlate infrastructure issues for VMs,’ ‘drill into your SQL database monitoring data with Log Analytics,’ you will be using ‘Azure Monitor.’ Azure Monitor uses a version of the KQL that is suitable for simple log queries but also includes advanced functionality such as aggregations, joins, and smart analytics. Going forward, KQL must be your primary resource for querying the Azure Monitor log.

In this 95% demo session, I will show you some ‘getting started’ tips and a few sophisticated queries using KQL. Come and learn about the future of monitoring and investigations of Azure services.

SessionID: 101661

Graph Databases–How and Why

Back to calendar

Event Date: 25-07-2020 - Session time: 13:00:00 - Track: Database Development

Speaker: Kevin Mackey

Title: Graph Databases–How and Why

Abstract:

We, as data professionals, are dealing with increasingly large amounts of data. And, increasingly, we're asked to generate insights from this data. For that, the relationships between data points matter more than simple aggregations of individual data points. In our interconnected world, interconnected businesses, interconnected applications, graph databases lend themselves to answering relationship questions far more easily than...relational databases.

In this session we'll look at graph databases for how to model graph databases how to easily express relationships between interconnected data how to efficiently retrieve interrelated data

We'll look at the MATCH predicate in T-SQL and the MATCH statement in Cypher, the query language for Neo4j.

SessionID: 105219

A Practical Starter Guide to SQL Notebooks

Back to calendar

Event Date: 25-07-2020 - Session time: 13:00:00 - Track: Database Development

Speaker: Deborah Melkin

Title: A Practical Starter Guide to SQL Notebooks

Abstract:

Have you been hearing about SQL Notebooks in Azure Data Studio but haven't worked with them yet? Or have you played around with notebooks but not been able to figure out how to make them work for you?

Let's jump into SQL Notebooks together as we figure out how we can use them in our day-to-day work! We will start by looking at the different options that are available to us in SQL Notebooks. Then we will examine real world scenarios and create notebooks for them. Finally, we will learn how we can share the notebooks with our coworkers.

When you leave, you will have the practical knowledge and comfort level to use SQL Notebooks in your day-to-day work.

SessionID: 100782

Networking 101: Building professional relationships

Back to calendar

Event Date: 25-07-2020 - Session time: 14:15:00 - Track: Professional/Personal Development

Speaker: Ray Kim

Title: Networking 101: Building professional relationships

Abstract:

Networking. You keep hearing that word throughout your career development, but you don’t know much about it, much less, how to do it. You want to connect with technical and data professionals, so you attend events such as SQL Saturday and your local user group. But what about your book club, your gym, your church group, or your kid’s soccer game? Those are prime — and overlooked — opportunities to network!

In this interactive session, we will discuss networking — what it is, why it’s important, and where opportunities exist. You will even have an opportunity to practice networking within the confines of our room. You might even leave this session with new networking contacts that you didn’t previously have! Bring business cards if you have them!

SessionID: 100795

How Intelligent Query Processing improves T-SQL performance

Back to calendar

Event Date: 25-07-2020 - Session time: 14:15:00 - Track: Database Development

Speaker: Andy Yun

Title: How Intelligent Query Processing improves T-SQL performance

Abstract:

Do you write T-SQL for a living and want to improve its performance? Do you wish your 3rd party vendor code would magically go faster? Then you need to learn about Intelligent Query Processing in SQL Server 2019. This collection of new features is a game changer that will improve performance across the board. Come to this overview session to learn more about how these capabilities will benefit you.

SessionID: 105002

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

Back to calendar

Event Date: 25-07-2020 - Session time: 14:15:00 - Track: Data Science

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

Modern SQL Server CPU Architectures for Performance

Back to calendar

Event Date: 25-07-2020 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Modern SQL Server CPU Architectures for Performance

Abstract:

Modern CPU architectures are complex and misunderstood, especially as they relate to SQL Server instance configuration and database usage patterns. Default values in virtualization and the SQL Server instance can cause misalignments and improper balance in the way the SQL Server lines up with the CPUs and memory, which results in an immediate (and silent) performance penalty. Come learn as we discuss topics such as physical and virtual NUMA, hyperthreading, query parallelism, public cloud CPU selection, and SQL Server instance settings, and show you how to validate your SQL Server architecture and improve the performance of your critical SQL Servers for both on-prem and cloud-based SQL Servers.

SessionID: 100792

Keys to a Healthy Relationship with SQL Server

Back to calendar

Event Date: 25-07-2020 - Session time: 15:30:00 - Track: Database Development

Speaker: Andy Levy

Title: Keys to a Healthy Relationship with SQL Server

Abstract:

Developers and DBAs have had a long, sometimes strained relationship. Some developers see DBAs as roadblocks standing in the way of getting their work shipped; some DBAs see developers as agents of chaos bent on ruining their perfect database environments.

In this talk designed for application and database developers, we’ll talk about why SQL Server behaves the way it does, common database and query design pain points, and how we look for them. With real-world examples and tales of troublesome T-SQL, past and present, you’ll start to get a picture of what to do and not to do in your applications. Along the way, you’ll learn how to build a better relationship with both SQL Server and the DBAs responsible for it.

SessionID: 105149

10 DBA Tasks for Azure SQL: Whats Different from On-Prem

Back to calendar

Event Date: 25-07-2020 - Session time: 15:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Rie Irish

Title: 10 DBA Tasks for Azure SQL: Whats Different from On-Prem

Abstract:

Adoption of Cloud is at an all time high, with no end in sight. Managing a small fleet of databases on-premises was something you used to understand. In this session, we'll cover the 10 most common tasks a DBA needs to learn to manage in Azure SQL as well as they currently manage their On Prem installs. One of the great things about Azure SQL is that the skill set your team has developed over the years translates well. The tools and technologies you're familiar with are all there. So much is the same but some of the tasks that DBAs do are different.

SessionID: 105226

Case Study: How I used SharePoint, Power Automate, Power Apps, and Forms to build a Speaker Database

Back to calendar

Event Date: 25-07-2020 - Session time: 15:30:00 - Track: Cloud Application Development Deployment

Speaker: Sarah Patrick

Title: Case Study: How I used SharePoint, Power Automate, Power Apps, and Forms to build a Speaker Database

Abstract:

In this case study, I detail how I went about designing and implementing a Speaker Database for the Project Management Institute using SharePoint, Power Automate, Power Apps, and Microsoft Forms. We will do a brief intro of what each technology is and it's pros and cons, and then dive into what I learned about each, each strengths and weaknesses, and how I was able to build a functional Speaker Database.

SessionID: 105312

Step by Step – Building (a Real Use Case for the) Power Platform Solution

Back to calendar

Event Date: 25-07-2020 - Session time: 15:30:00 - Track: Business Intelligence

Speaker: Belinda Allen

Title: Step by Step – Building (a Real Use Case for the) Power Platform Solution

Abstract:

In this session, Belinda will build a Power Automate flow. She’ll then build a Power App that uses that flow. Finally, she’ll add the Power App to a Power BI Report. This is a real use case. See the whole enchilada being built, in less than 1 hour.

Who should attend this session?
• If you have never built a Power Automate flow, this session is for you. • If you have never built a Power App, this session is for you. • If you are struggling with use cases for these cool products, this session is for you.

This site is open source. Improve this page.