SQLSaturday #1003 – Memphis - Virtual 2020
Getting Started as a Conference Speaker
Event Date: 03-10-2020 - Session time: 08:30:00 - Track: Professional Development
Speaker: Mark Runyon
Title: Getting Started as a Conference Speaker
Conference speaking is a very rewarding way to give back to the community. Just getting on stage is often the most challenging part. We will look at all the things I wish I had known going into my first conference talk to help you squash the butterflies and make your experience a success.
The Psychology of Better Power BI Reporting
Event Date: 03-10-2020 - Session time: 08:30:00 - Track: BI Information Delivery
Speaker: Ed Watson
Title: The Psychology of Better Power BI Reporting
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.
Modern SQL Server CPU Architectures for Performance
Event Date: 03-10-2020 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Speaker: David Klee
Title: Modern SQL Server CPU Architectures for Performance
Introduction to GitHub for Data Professionals
Event Date: 03-10-2020 - Session time: 09:40:00 - Track: Application Database Development
Speaker: Joshua Higginbotham
Title: Introduction to GitHub for Data Professionals
Getting started with GitHub can at times be overwhelming. Especially when you've been working with other source control and project management systems your whole career. In this session, we will overview the below tasks to ensure your success with GitHub.
- Initial setup of a Repository in GitHub.
- Build Issue templates for new features, bugs, or custom tasks.
- Securing the check-in/merge process to your root branch.
- Integrating GitHub with other productivity tools to keep on top of changes.
Certification Exams Inside Out
Event Date: 03-10-2020 - Session time: 09:40:00 - Track: Professional Development
Speaker: William Assaf
Title: Certification Exams Inside Out
Preparing for Microsoft certification? Do you want insight into how certification exams are written, how questions are designed, and how to follow a logical process of elimination? We'll go through the process of item creation from an item writer's viewpoint, what rules item writers must follow, and why questions sometimes have strange phrasing. For any technical skillset pursuing certification, we'll review non-technical sample questions and walk through the process of using information at your disposal. You'll better understand how to deconstruct the problem statement. We'll leave time for QA with a veteran of the Microsoft certification exam writing process.
Become a Power BI Magician using Bookmarks and Drill Through Page
Event Date: 03-10-2020 - Session time: 09:40:00 - Track: Analytics and Visualization
Speaker: DeNisha Malone
Title: Become a Power BI Magician using Bookmarks and Drill Through Page
Power BI has made its mark as the leading business intelligence application for any industry! Developers have come up with fancy ways to drag and drop data elements on pages; some of those fancy things including bookmarks and drill-through pages! These features add a more interactive application experience for the end user. In this session, I will show you how to create pop up windows, add reset/clear all filters buttons, design drill-through detail pages, and more! You'll feel like a BI visual magician in no time!
Turn Runbooks into Notebooks: Handling Maintenance and Emergencies with Azure Data Studio
Event Date: 03-10-2020 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment
Speaker: Matt Gordon
Title: Turn Runbooks into Notebooks: Handling Maintenance and Emergencies with Azure Data Studio
On-call DBAs have all had that phone call in the middle of the night: "the database is down, fix it now!" We start scrambling to piece together various scripts to analyze the emergency, mitigate the issues, and kick off a failover or similar fix to make the database happy and healthy once again. Even scheduled maintenance likely requires us to download scripts from a ticket, run the scripts, and screenshot the results for documentation. What if I told you that Azure Data Studio's notebooks allow you to execute T-SQL and PowerShell together to handle these processes from a single document that documents its own results and can be stored directly in source control? Join me in this demo-heavy session to see how we can handle real-world on-call situations using Azure Data Studio notebooks.
How to Budget for a Azure Migration
Event Date: 03-10-2020 - Session time: 10:50:00 - Track: Cloud Application Development Deployment
Speaker: Dustin Dorsey
Title: How to Budget for a Azure Migration
You have heard all about the awesome opportunities that utilizing cloud technology provides and you are sold! Technically, everyone agrees it's the right answer and are ready to get started. However, there is one problem. Your organization needs to understand what its going to cost before approving the project. Understanding the cost to move to Azure and its run rate are questions several companies struggle with and can present a major roadblock for moving forward. Oftentimes it's not because the cost is too high, its simply because they do not know what to expect and budget for. In this session, we will walk through the process of building estimates, creating a Azure budget and discuss the several unique considerations you need to be mindful of such as networking, storage, service dependencies, workload considerations and more. As you explore opportunities to migrate to the cloud, don't let cost be a deterring factor.
Organizational Trauma: Supporting Mental Health During a Crisis
Event Date: 03-10-2020 - Session time: 10:50:00 - Track: Professional Development
Speaker: Christine Assaf
Title: Organizational Trauma: Supporting Mental Health During a Crisis
As leaders we are concerned with the health and well-being of our teams and organization. In this session we will discuss the latest mental health trends facing today's workforce. We will learn about Organizational Trauma, "negative emotions" (anxiety, loneliness, anger, etc.) and how they are frequently displayed at work. Lastly, we'll discuss some methods with you (and your team!) can use for better mental health.
Checking in on Tabular Models: Making Them Work Better
Event Date: 03-10-2020 - Session time: 12:50:00 - Track: BI Platform Architecture, Development Administration
Speaker: Kevin Wilkie
Title: Checking in on Tabular Models: Making Them Work Better
We've all seen, and probably created, a few tabular models that are just dog-slow. For the people just starting with tabular models to those who've been around the block a few times with them, we'll go over some ways in which I've sped up tabular models to be leaner and faster. So join me and learn (or remember) several different things to do with tabular models to make them just plain better.
Advanced Plan Explorer Usage for Tuning Execution Plans
Event Date: 03-10-2020 - Session time: 12:50:00 - Track: Application Database Development
Speaker: Andy Yun
Title: Advanced Plan Explorer Usage for Tuning Execution Plans
In 2010, SentryOne gave the community a completely free execution plan analysis tool: Plan Explorer, that is widely used today. But many users only utilize basic features and only scratch the surface of its capabilities.
Join me to learn how you can go beyond the basics. This demo-heavy (and marketing free) session will teach you advanced use of Plan Explorer by exploring practical T-SQL anti-patterns.
I lost my job! Now what?!? A survival guide for the unemployed
Event Date: 03-10-2020 - Session time: 12:50:00 - Track: Professional Development
Speaker: Ray Kim
Title: I lost my job! Now what?!? A survival guide for the unemployed
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!
Intelligent Insights with Power BI
Event Date: 03-10-2020 - Session time: 14:00:00 - Track: BI Information Delivery
Speaker: Dan Evans
Title: Intelligent Insights with Power BI
Learn how to use Power BI self-service data preparation capabilities to build upon your existing Power BI content with Artificial Intelligence (AI) capabilities. Learn what AI can do and how it integrates into Power BI using dataflows and Automated Machine Learning (AutoML). Also see some of the enhanced AI visualizations in Power BI like QA, Key Influencers and Decomposition Trees to gain further insights into your data.
SELECT Questions FROM Diversity.Inclusion WHERE AfraidToAsk = 1
Event Date: 03-10-2020 - Session time: 14:00:00 - Track: Professional Development
Speaker: Andrea Mascher
Title: SELECT Questions FROM Diversity.Inclusion WHERE AfraidToAsk = 1
In the past several years Diversity, Equity, Inclusion (DEI) have become more important and visible in the workplace. Studies have shown that organizations are often more successful when they are more diverse, yet the tech sector is moving slowly to improve representation and inclusion. Many IT professionals want to improve but don't know where to start.
This session will cover key concepts in DEI and how they apply to data practitioners.
From adaptive to intelligent: query processing in SQL 2019
Event Date: 03-10-2020 - Session time: 14:00:00 - Track: Application Database Development
Speaker: Hugo Kornelis
Title: From adaptive to intelligent: query processing in SQL 2019
As announced in September 2018, SQL Server 2019 expands the "adaptive query processing" features of SQL 2017 and relabels them as "intelligent query processing". This name now covers many features, such as batch mode on rowstore, memory grant feedback, interleaved execution, adaptive joins, deferred compilation, and approximate query processing.
In this high-paced session, we will look at all these features and cover some use cases where they might help - or hurt! - you.