sqlsathistory

Nr: 1017

Back to Main list

SQLSaturday #1017 – Minnesota – Virtual 2020

Start Time (24h) Speaker Track Title
09:15:00 Mohammad Darab Cloud Application Development Deployment Big Data Clusters for the Absolute Beginner
09:15:00 Kathi Kellenberger Application Database Development Modern T-SQL for Better Performance
09:15:00 Dave Bland Enterprise Database Administration Deployment How to do a Complete SQL Server Assessment
09:15:00 David Patrick BI Information Delivery Intro to Power BI
09:15:00 Dave Mattingly Professional Development Achievement Unlocked: How to Get Promoted
09:15:00 Gilda Alvarez Professional Development Surviving the work from home burnout
09:15:00 Bo Ros Other Quest Gold Sponsor
11:00:00 Mark Runyon Professional Development Getting Started as a Conference Speaker
11:00:00 Deepthi Goguri Enterprise Database Administration Deployment Life Cycle of a Query in SQL Server
11:00:00 Edward Pollack Application Database Development Dynamic SQL: Writing Efficient Queries on the Fly
11:00:00 Kevin Feasel Analytics and Visualization Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques
11:00:00 Belinda Allen BI Information Delivery Power BI Desktop and AI or “There's AI in in the Power BI Desktop?”
13:00:00 Nikola Ilic Analytics and Visualization Magnificent 7 - Simple tricks to boost your Power BI development
13:00:00 Christopher Wolff Enterprise Database Administration Deployment SQL Server on Containers
13:00:00 Ray Kim Professional Development I lost my job! Now what?!? A survival guide for the unemployed
13:00:00 Damian Widera Information Delivery Quantum computing explained with demos!
13:00:00 Chris Hyde BI Platform Architecture, Development Administration Data Engineering Brick-by-Brick: An Introduction To Azure Databricks
13:00:00 Drew Skwiers-Koballa Application Database Development SQL Development in a Developer's World
14:15:00 Tracy Boggiano Enterprise Database Administration Deployment SQL Server Configuration with dbatools and dbachecks
14:15:00 Frank Gill Enterprise Database Administration Deployment Performance Improvements in SQL Server 2019
14:15:00 Joshua Higginbotham BI Information Delivery Functional ETL using Python
14:15:00 Andrew Brobston Professional Development Launch a Cost-Effective Mentoring Program
14:15:00 Edwin M Sarmiento Cloud Application Development Deployment What SQL Server DBAs Need to Know About Docker Containers
14:15:00 John Miner Application Database Development Effective Data Warehouse Storage Patterns
15:30:00 Andy Yun Application Database Development How Intelligent Query Processing Improves T-SQL Performance
15:30:00 Dennes Torres BI Information Delivery Optimizing Model and Dashboards using DAX Studio
15:30:00 Denny Cherry Enterprise Database Administration Deployment SQL Server Database Administration for the non-DBA
15:30:00 James Serra Professional Development How to build your career
15:30:00 Sam Nasr Application Database Development SQL Server Security Features
15:30:00 Ed Leighton-Dick Enterprise Database Administration Deployment Building a Security Dashboard for SQL Server

SessionID: 108680

Big Data Clusters for the Absolute Beginner

Back to calendar

Event Date: 12-12-2020 - Session time: 09:15:00 - Track: Cloud Application Development Deployment

Speaker: Mohammad Darab

Title: Big Data Clusters for the Absolute Beginner

Abstract:

Are you a DBA or data professional working with out-dated technology or feel your skills are quickly becoming irrelevant? Stay ahead in today's ever changing tech space and take your career to the next level.

Join Mohammad Darab this session to explore the cutting-edge technology that SQL Server 2019 has to offer: Big Data Clusters.

Topics include: -Big Data Cluster architecture and its components such as: Containers, Kubernetes and the newly enhanced Polybase -Unique advantage of SQL Server Big Data Clusters -Data Virtualization, Scale-out Data Marts, and Data Hub concepts

SessionID: 108695

Modern T-SQL for Better Performance

Back to calendar

Event Date: 12-12-2020 - Session time: 09:15:00 - Track: Application Database Development

Speaker: Kathi Kellenberger

Title: Modern T-SQL for Better Performance

Abstract:

Once you learn how to write queries, it’s easy to fall back on the same old patterns. You need to get the job done, and using old techniques is often quicker than learning something new. Over the past decade, Microsoft has released several versions of SQL Server with T-SQL enhancements, and many of these enhancements not only let you write queries easier, the queries also run faster.

Join this session to learn how this “new” T-SQL functionality can save you time when writing queries that also perform great.

SessionID: 108748

How to do a Complete SQL Server Assessment

Back to calendar

Event Date: 12-12-2020 - Session time: 09:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

Title: How to do a Complete SQL Server Assessment

Abstract:

Completing a full assessment on a SQL Server is essential to learning about not only the current state of the server, but also any areas that may be impacting performance or security. During this session we will discuss when assessments are useful, what should be included in the assessment as well as how to interpret the results. We will use a SQL script that will capture all the data needed. This script will more than 88 data points, including fragmentation of indexes, performance counter values, server and database security information, queries that consume the most CPU time including execution plans as well as many other data points. During this session we will cover a number of additional tools that can be used, include the Vulnerability Assessment Tool and a suite of 125 SSRS reports the return key data needed in a manner easier to read and export.

SessionID: 108773

Intro to Power BI

Back to calendar

Event Date: 12-12-2020 - Session time: 09:15:00 - Track: BI Information Delivery

Speaker: David Patrick

Title: Intro to Power BI

Abstract:

For anyone new to Power BI, we'll cover all the main features and walk through getting data into the tool (using both the desktop and online versions), creating visualizations, turning them into reports and adding them to dashboards. When we're through we'll have several BI components available to share via the Cloud!

SessionID: 108782

Achievement Unlocked: How to Get Promoted

Back to calendar

Event Date: 12-12-2020 - Session time: 09:15:00 - Track: Professional Development

Speaker: Dave Mattingly

Title: Achievement Unlocked: How to Get Promoted

Abstract:

Have you ever felt like an extra in Office Space? You've got the skills. You've got the big brain. You feel like you have a higher calling, but those other guys get picked instead. What's the deal?

In this session, you'll learn how to promote yourself, how to speak confidently, how to build your personal brand, how to demonstrate value, and how to interview.

SessionID: 108994

Surviving the work from home burnout

Back to calendar

Event Date: 12-12-2020 - Session time: 09:15:00 - Track: Professional Development

Speaker: Gilda Alvarez

Title: Surviving the work from home burnout

Abstract:

After the tragic terrorist attacks of September 11, 2001 I began the work from home experience. It was a time of uncertainty in the world and I became the lab rat of working from home. It was the beginning of a trend that will eventually culminate in the norm during this 2020 pandemic. I had to reinvent myself without a guide and eventually burned-out. My physical and mental health slowly deteriorated until I decided to learn more about the human body and the way energy is processed. I want to share my experience with others and help them reduce burnout and become highly productive.

SessionID: 110419

Quest Gold Sponsor

Back to calendar

Event Date: 12-12-2020 - Session time: 09:15:00 - Track: Other

Speaker: Bo Ros

Title: Quest Gold Sponsor

Abstract:

An open room for people to jump on and ask Bo from Quest Software Questions.

SessionID: 108662

Getting Started as a Conference Speaker

Back to calendar

Event Date: 12-12-2020 - Session time: 11:00:00 - Track: Professional Development

Speaker: Mark Runyon

Title: Getting Started as a Conference Speaker

Abstract:

Conference speaking is a very rewarding way to give back to the community. Just getting on stage is often the most challenging part. We dig into questions that people struggle with.

How do you decide on a topic? How do you get past a phobia in public speaking? What if someone asks a question you don't know? How do you connect with your audience and get them to engage with you?

I'll teach you how to construct a successful talk and point out things you need to be aware of each step of the way. You will walk away with the tools to help you squash the butterflies and make your experience a success.

SessionID: 108676

Life Cycle of a Query in SQL Server

Back to calendar

Event Date: 12-12-2020 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Deepthi Goguri

Title: Life Cycle of a Query in SQL Server

Abstract:

Many DBA's and Developers work with SQL Server but don’t fully understand how it really works behind the scenes. Join Deepthi on her dive into the internals of SQL Server to explain why knowing what goes on under the covers will help you make better decisions quickly when solving performance problems in SQL Server. This session will cover ACID properties, key components of the Relational Engine, Storage engine, Cache and the Transaction manager. We will also cover what happens under the covers during read and write operations within SQL Server.

Deepthi will show you how the SQL engine thinks – enabling you to think like it!

SessionID: 108787

Dynamic SQL: Writing Efficient Queries on the Fly

Back to calendar

Event Date: 12-12-2020 - Session time: 11:00:00 - Track: Application Database Development

Speaker: Edward Pollack

Title: Dynamic SQL: Writing Efficient Queries on the Fly

Abstract:

Dynamic SQL is a powerful tool that allows for the creation of fast and efficient queries when the specifics may not be known until run-time. This tool can be used to automate complex processes, facilitate reporting on an unknown number of targets, or perform tasks that would otherwise be time-consuming to develop.

This is an often misunderstood tool that is underused in areas where it can provide immense value or abused by applications that it was never intended for. Well-written dynamic SQL can solve seemingly impossible problems while being easy to read and understand.

Applications that will be demonstrated include: mapping database relationships, schema searching, generating large volumes of TSQL, and much more. Explore the many uses for dynamic SQL as well as best practices for writing, testing, debugging, and maintaining it!

SessionID: 108810

Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques

Back to calendar

Event Date: 12-12-2020 - Session time: 11:00:00 - Track: Analytics and Visualization

Speaker: Kevin Feasel

Title: Eyes on the Prize: Simple and Effective Dashboard Visualization Techniques

Abstract:

When done right, data visualization informs users quickly and efficiently with a minimum of distraction. When done wrong, we end up with spinning 3D pie charts. In this talk, we will look at techniques for effective dashboard design, minimizing noise and clutter (like spinning 3D pie charts) while providing relevant information to the intended audience. We will see how different types of charts work, build out rules of thumb around which charts to use, and integrate visuals to create a coherent dashboard image. When it comes to dashboards, we will compare and contrast dashboards based on their intended uses, such as interactive dashboards versus TV dashboards. Finally, we will take an awful dashboard and turn it into something which end users will appreciate.

SessionID: 108875

Power BI Desktop and AI or “There's AI in in the Power BI Desktop?”

Back to calendar

Event Date: 12-12-2020 - Session time: 11:00:00 - Track: BI Information Delivery

Speaker: Belinda Allen

Title: Power BI Desktop and AI or “There's AI in in the Power BI Desktop?”

Abstract:

Yes, there is AI built right into the Microsoft Power BI Desktop. This session will guide you through adding more Intelligence to your BI reports!

Power BI is masterful at helping designers create storytelling reports that provide answers to the questions of “What has happened?” and “What is happing right now?” We can even get some insight as to “What will happen?” BUT what if you want to know “Why something happened? Or “How can we alter what will happen?” With the built in AI tools, we can start the journey getting answers to our “Why” and “How” questions answered.

In this session we will review the following Power BI Desktop tools:

QA Tooling

Explain the Increase / Decrease (Insights)

Key Influencers Visual

Decomposition Tree Visual

SessionID: 108682

Magnificent 7 - Simple tricks to boost your Power BI development

Back to calendar

Event Date: 12-12-2020 - Session time: 13:00:00 - Track: Analytics and Visualization

Speaker: Nikola Ilic

Title: Magnificent 7 - Simple tricks to boost your Power BI development

Abstract:

Simple tricks are almost always the most efective. Impress your users with some cool visualizations, using these 7 neat techniques: from taking buttons to the next level, through creating animated tooltips or using basic DAX calculations to enhance regular Power BI experience, this session full of demos will walk you through solutions to different use-case scenarios which can be applied in your day-to-day Power BI development.

SessionID: 108697

SQL Server on Containers

Back to calendar

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

Speaker: Christopher Wolff

Title: SQL Server on Containers

Abstract:

Do you have a great CI/CD setup on the web side but wish you could do the same on the data side? Installing SQL Server on containers may be the key technology you need to make this wish a reality. In this quick summary we will go over what containers are, differences from VM’s, gotcha’s and things to keep in mind, and talk a bit about newer orchestrators like Kubernetes.

SessionID: 108722

I lost my job! Now what?!? A survival guide for the unemployed

Back to calendar

Event Date: 12-12-2020 - Session time: 13:00:00 - Track: Professional Development

Speaker: Ray Kim

Title: I lost my job! Now what?!? A survival guide for the unemployed

Abstract:

You've just been told by HR that you are no longer a part of their organization. You've been kicked to the curb. You are now living in the no-man's land called unemployment.

Unemployment is a scary situation. You're dealing with emotions and uncertainty. You don't know if you'll be out of work for days, weeks, or months.

Fortunately, unemployment is survivable. In this session, I'll share my own experiences (and perhaps we'll talk about some of yours) with unemployment, and how I managed to get through the tough times. We'll discuss emotional impact, the job hunt, and things you can do to get yourself through this tough time. Hopefully, you'll land on your feet once again before long!

SessionID: 108824

Quantum computing explained with demos!

Back to calendar

Event Date: 12-12-2020 - Session time: 13:00:00 - Track: Information Delivery

Speaker: Damian Widera

Title: Quantum computing explained with demos!

Abstract:

This talk is inspired by the quantum revolution we will see in a moment.

I would like to introduce the topics:

If time permits - quantum entanglement

I will do demos implemented in Q# with the Microsoft Quantum Development Kit.

I do not assume any special knowledge, but if you know basic linear algebra (matrices, vectors, matrix multiplication) than the topic will be more easily understand!

SessionID: 109099

Data Engineering Brick-by-Brick: An Introduction To Azure Databricks

Back to calendar

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

Speaker: Chris Hyde

Title: Data Engineering Brick-by-Brick: An Introduction To Azure Databricks

Abstract:

Do you want to be a Data Engineer in the next step on your career path? Maybe you're just getting started in the rapidly-growing Data Science and Analytics space? Or perhaps you're already doing on-premises analytics and want to take things to the cloud? Then come to this introductory session and see what Azure Databricks can do for you!

Azure Databricks provides a cloud-based Apache Spark environment that can be scaled up and out to tackle your big data analytics needs. We'll look at how to set up your first Azure Databricks cluster, how to use shared notebooks in a collaborative environment, and how to leverage the integrated Azure Machine Learning capabilities. We'll also discuss where Azure Databricks fits in the modern cloud data warehouse.

SessionID: 109105

SQL Development in a Developer's World

Back to calendar

Event Date: 12-12-2020 - Session time: 13:00:00 - Track: Application Database Development

Speaker: Drew Skwiers-Koballa

Title: SQL Development in a Developer's World

Abstract:

Database development tooling is evolving to meet the demands of modern application development methods, including automated pipelines, cross-platform environments, and multi-dimensional architectures. Whether you are familiar with SQL Server Data Tools (SSDT) or new to SQL projects, the SQL Database Projects extension is worth a look because it combines the Azure Data Studio interface with declarative database development capabilities. Beyond Azure Data Studio, the command line application SqlPackage.exe is a powerful tool for extracting and publishing database schemas. Add in a little magic* and let your imagination run wild with the opportunities to create efficiencies in your development workflow.

*= not actual magic

SessionID: 108688

SQL Server Configuration with dbatools and dbachecks

Back to calendar

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

Speaker: Tracy Boggiano

Title: SQL Server Configuration with dbatools and dbachecks

Abstract:

Automating the configuration of SQL Server instances and being able to check the configuration for standard configuration is an important role for any DBA when you have lots of instances. But how can we automate the configuration easily? How can we check to make sure the proper configuration is in place and hasn’t changed?

In this session, we will look at how to configure your SQL Server Instances using PowerShell and the dbatools module. Then we will look at how to use dbachecks to confirm the configuration of our instances and how to check for changes in the future of the configuration.

Attendees will see how easy it is to use PowerShell via dbatools to configure their SQL Server instances. Attendees will see how easy it is to use PowerShell via dbachecks and PowerBI to see if their servers are configured properly. Attendees will be given a set of scripts that take back to use to configure and test the configuration of their SQL Server instances.

SessionID: 108691

Performance Improvements in SQL Server 2019

Back to calendar

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

Speaker: Frank Gill

Title: Performance Improvements in SQL Server 2019

Abstract:

Microsoft released SQL Server 2019 in November. The latest version contains several improvements and new features that improve reliability and performance. First, Accelerated Database Recovery (ADR) completely redesigns the SQL Server database engine recovery process. This allows the time spent recovering from a crash or rolling back a transaction to be greatly reduced. ADR also prevents the transaction log from growing during a long-running transaction. Second, metadata for temporary tables can be stored in in-memory tables. For tempdb-heavy workloads, this removes a bottleneck and provides an improvement to performance. Finally, SQL Server 2019 supports the use of persistent-memory (PMEM) devices. PMEM can be used to persist the transaction log buffer, effectively removing LOGWRITE waits. Join me for this session to learn about these new features in SQL Server 2019 and how they can make your workload run faster.

SessionID: 108715

Functional ETL using Python

Back to calendar

Event Date: 12-12-2020 - Session time: 14:15:00 - Track: BI Information Delivery

Speaker: Joshua Higginbotham

Title: Functional ETL using Python

Abstract:

As a Data Engineer, you're continually tasked with building pipelines to facilitate data movement, imports, and extracts. Each time, the request is different but the operation is similar, but takes you countless hours to build, test, and deploy. By utilizing commonly used modules from the Python ecosystem, we can buildout reusable and scalable code, that will support your Data pipelines On-Premises and in the Cloud.

SessionID: 108800

Launch a Cost-Effective Mentoring Program

Back to calendar

Event Date: 12-12-2020 - Session time: 14:15:00 - Track: Professional Development

Speaker: Andrew Brobston

Title: Launch a Cost-Effective Mentoring Program

Abstract:

Your technology organization needs a mentoring program!

The key is to keep the business goals for the program at the forefront. When mentoring and learning become vital, expected parts of work, and when you measure results, you're headed for success.

I'll show you how I started and nurtured a mentoring program at SJV Data Solutions. Participants included software developers, managers, and product professionals. In under a year, this program improved products and advanced careers. The positive effect on the bottom line was unmistakable. The program's benefits far exceeded expectations. Plus, a well-designed mentoring program scales; most weeks, I spent under two hours running the program.

Conducting this mentoring program is the most rewarding thing I have done in my tech career. I can't wait to share these ideas with you!

SessionID: 108847

What SQL Server DBAs Need to Know About Docker Containers

Back to calendar

Event Date: 12-12-2020 - Session time: 14:15:00 - Track: Cloud Application Development Deployment

Speaker: Edwin M Sarmiento

Title: What SQL Server DBAs Need to Know About Docker Containers

Abstract:

You have been given new responsibilities to automate deployment, scaling and management of containerized applications – not just SQL Server databases. But you feel stuck and overwhelmed because you have so much to figure out. The available information on the internet isn't helping and you're wasting so much time trying to learn things on your own. Even worse, you end up being a stressed, overworked DBA who wished you could focus on the “cool stuff”, but are instead stuck in firefighting mode while juggling the additional workload.

In this session, get introduced to SQL Server on containers and what you need to know to start deploying and managing them. You'll learn the different components that make up the container ecosystem and how to leverage containers for faster SQL Server deployments.

SessionID: 108910

Effective Data Warehouse Storage Patterns

Back to calendar

Event Date: 12-12-2020 - Session time: 14:15:00 - Track: Application Database Development

Speaker: John Miner

Title: Effective Data Warehouse Storage Patterns

Abstract:

Many companies start off with a simple data mart for reporting. As the company grows, users become dependent on the data mart for monitoring and making decisions on Key Performance Indicators (KPI).

Unexpected information growth in your data mart may lead to a performance impacted reporting system. In short, your users will be lining up at your cube for their daily reports.

How do you reduce the size of your data mart and speed up data retrieval? This presentation will review the following techniques to fix your woes.

Techniques: 1 – What is horizontal partitioning? 2 – Database sharding for daily information. 3 – Working with files and file groups. 3 – Partitioned views for performance. 4 – Table and Index partitions. 5 – Row Data Compression. 6 – Page Data Compression. 7 – Programming a sliding window. 8 – What is different in Azure SQL database?

SessionID: 108673

How Intelligent Query Processing Improves T-SQL Performance

Back to calendar

Event Date: 12-12-2020 - Session time: 15:30:00 - Track: Application 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: 108709

Optimizing Model and Dashboards using DAX Studio

Back to calendar

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

Speaker: Dennes Torres

Title: Optimizing Model and Dashboards using DAX Studio

Abstract:

Power BI is able to deal with huge amounts of data, but we need to take care with performance. Small differences in the way we build a dashboard can have huge impact on the solution performance.

Power BI has some tools to help us analyse the performance of the solution and when we need to go deeper, DAX Studio can point where the problem is

SessionID: 108732

SQL Server Database Administration for the non-DBA

Back to calendar

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

Speaker: Denny Cherry

Title: SQL Server Database Administration for the non-DBA

Abstract:

Are you a developer or a systems admin and you've just been handed a SQL Server database and you've got no idea what to do with it? I've got some of the answers here in this session for you. During this session, we will cover a variety of topics including backup and restore, recovery models, database maintenance, compression, data corruption, database compatibility levels, and indexing.

While this session won't teach you everything you need to know, it will give you some insights into the SQL Server database engine and give you the ability to know better what to look for.

SessionID: 108741

How to build your career

Back to calendar

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

Speaker: James Serra

Title: How to build your career

Abstract:

I'll cover tips I learned over my career on everything from interviewing to building your personal brand. I'll discuss perm positions, consulting, contracting, working for Microsoft or partners, hot fields, in-demand skills, social media, networking, presenting, blogging, salary negotiating, dealing with recruiters, certifications, speaking at major conferences, resume tips, and keys to a high-paying career.

Your first step to enhancing your career will be to attend this session! Let me be your career coach!

SessionID: 108767

SQL Server Security Features

Back to calendar

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

Speaker: Sam Nasr

Title: SQL Server Security Features

Abstract:

SQL Server provides several several security features for developers and architects. Features such as Dynamic Data Masking (DDM), "Always Encrypted", and Row-Level Security provide an additional level of security natively through the database server. We'll explore the implementation of these features on the client/server for data in transmission or at rest. In addition, we'll examine built-in features and custom implementations.

SessionID: 109113

Building a Security Dashboard for SQL Server

Back to calendar

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

Speaker: Ed Leighton-Dick

Title: Building a Security Dashboard for SQL Server

Abstract:

If you have a SQL Server, you need to secure it. However, even the most robust security is useless if you're not monitoring it. How else would you know whether something has changed? Or whether something isn't working as expected? And frankly, for monitoring, you need a quick view of the data you've collected. Enter dashboards.

In this session, we'll discuss what information you need to collect from your SQL Servers to effectively monitor security. You'll also see how to build a simple security dashboard for your own use using Power BI.

This site is open source. Improve this page.