sqlsathistory

Nr: 960

Back to Main list

SQLSaturday #960 – Chattanooga – Virtual 2020

Start Time (24h) Speaker Track Title
08:30:00 Brian Hansen Enterprise Database Administration Deployment Real-World PowerShell for SQL Administration
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 Sekou Tyler Analytics and Visualization Data Visualization Tools For Entrepreneurs
08:30:00 Nathan Boster Application Database Development Turbo-charging SSMS for Beginners
09:40:00 Simon Kingaby BI Platform Architecture, Development Administration Why Learn Python? A Microsoft DB/ETL/BI Developer's Answer
09:40:00 Daniel Glenn BI Information Delivery Give Power [BI] to the people - securely share your insights
09:40:00 Dave Bland Enterprise Database Administration Deployment How to do a Complete SQL Server Assessment
09:40:00 Deborah Melkin Application Database Development Looking "Normal" and Seeing "Stars": Table Designs Working Together
10:50:00 Matt Gordon Professional Development From Stutterer to Speaker: Overcoming Your Fears
10:50:00 Thomas Norman Enterprise Database Administration Deployment The Art of Data Classification and Protection
10:50:00 Ed Watson BI Information Delivery The Psychology of Better Power BI Reporting
10:50:00 Kevin Kline Enterprise Database Administration Deployment Achieve Enterprise Scale with Advanced SQL Server Features
13:00:00 Mark Runyon Professional Development The Countless Benefits of Mentoring
13:00:00 Kevin Wilkie Application Database Development The function of Windowing Functions
13:00:00 Kevin Feasel Advanced Analysis Techniques Applying Forensic Accounting Techniques Using SQL and R
13:00:00 Kevin Kline Enterprise Database Administration Deployment 5 Surprising Lessons Every SQL Server Generalists Has to Learn
14:10:00 Matt Gordon Enterprise Database Administration Deployment Azure-d Availability: SQL Server HA In and To the Cloud
14:10:00 Eric Flamm Application Database Development SQL Notebooks In-Depth
14:10:00 Ed Pearson BI Platform Architecture, Development Administration Enabling Real Time Analytics through Azure
14:10:00 Dan Evans BI Information Delivery Intelligent Insights with Power BI
15:20:00 Peter Shore Enterprise Database Administration Deployment Infrastructure for the Data Professional: An Introduction
15:20:00 Peter Doyle Application Database Development Learn How to Master DATETIME Functions Like a Boss in 59.5 Minutes or Less
15:20:00 Michael McKinley BI Platform Architecture, Development Administration Basic Data Modeling for BI Reporting
15:20:00 Andy Yun Enterprise Database Administration Deployment A Beginner's Guide to Becoming a Performance Tuner

SessionID: 101124

Real-World PowerShell for SQL Administration

Back to calendar

Event Date: 27-06-2020 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Hansen

Title: Real-World PowerShell for SQL Administration

Abstract:

If you're like me, you've attended PowerShell sessions before. However, much of the practical usage of PS comes with rolling back your sleeves and digging into the nuances of syntax and how to get things done. We are going to focus specifically on using PowerShell within the SQL Server Agent to build out everyday jobs.

In this session, I'm assuming that you know the basics of PowerShell. What we're going to cover are some of the "gotchas" and nuances that I've run into when I've been working with the language, and particularly with the SQL Agent's flavor of PowerShell.

And then we'll spend the balance of our time looking at real-world, practical scripts that I use pretty much every day. PowerShell is an awesome way to automate so many processes and relieve some of the everyday monotony of SQL administration.

SessionID: 101218

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

Back to calendar

Event Date: 27-06-2020 - 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: 102261

Data Visualization Tools For Entrepreneurs

Back to calendar

Event Date: 27-06-2020 - Session time: 08:30:00 - Track: Analytics and Visualization

Speaker: Sekou Tyler

Title: Data Visualization Tools For Entrepreneurs

Abstract:

Are you an aspiring entrepreneur who wants to do more with your data? Have you ever wondered what are some of the key differences between different data visualization tools? In this session I will provide a high level overview of different data visualization tools and discuss pros and cons of each. The goal of this session is to provide you with information that will help you determine which tool is best for you!

SessionID: 103916

Turbo-charging SSMS for Beginners

Back to calendar

Event Date: 27-06-2020 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Nathan Boster

Title: Turbo-charging SSMS for Beginners

Abstract:

This session is for SQL Server Management Studio (SSMS) rookies who want to work like veterans. Nathan will share lots of "tips and tricks" he's learned in his 15 years of SQL Server administration and development.

SessionID: 101184

Why Learn Python? A Microsoft DB/ETL/BI Developer's Answer

Back to calendar

Event Date: 27-06-2020 - Session time: 09:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Simon Kingaby

Title: Why Learn Python? A Microsoft DB/ETL/BI Developer's Answer

Abstract:

You're a Microsoft Developer. C#, MSSQL, SSIS/SSRS, SSMS, and Azure are your tools of choice. Why would you want to learn Python? In this session, I will show you several take-home utilities that use Python. The first hunts through a folder structure full of SSIS packages looking for the one(s) that load(s) a specified table. The second executes the data sources in an SSRS report to identify performance problems and document them in Excel. The third GeoCodes the City/Country names from a SQL table, getting the Lat/Lng so you can use the data in maps. Familiarity with Python is not necessary to use the utilities, but we're not going to do Hello World either. This is real Python for Microsoft Database, ETL and BI Developers. This all-demo session shows you how to use Python with the .Net CLR, XML, ODBC, Excel, SQL Server, and Web API calls.

SessionID: 102288

Give Power [BI] to the people - securely share your insights

Back to calendar

Event Date: 27-06-2020 - Session time: 09:40:00 - Track: BI Information Delivery

Speaker: Daniel Glenn

Title: Give Power [BI] to the people - securely share your insights

Abstract:

Every organization is a data organization and you must collaborate on data to stay on track. Sharing insights from within Power BI will give you an advantage and help steer your organization in the right direction.

However there are some pitfalls with sharing - if you don’t know your options and set proper governance, you could be on your way to leaking data to outside your company.

In this session, you will get a short introduction to Power BI and understand where data resides, why and how you should share with your colleagues and outside partners, and a strategy for setting governance on sharing your data. You will walk away with the outline of a governance plan, an understanding of your sharing options, and the sharing settings you should immediately turn off.

SessionID: 102543

How to do a Complete SQL Server Assessment

Back to calendar

Event Date: 27-06-2020 - Session time: 09:40: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 area that may be impacting performance or security. If you have more than one DBA, it is also important to have all the DBA team members review the same areas when completing an assessment. 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. This session will also cover how to document your findings and recommendations.

SessionID: 105140

Looking "Normal" and Seeing "Stars": Table Designs Working Together

Back to calendar

Event Date: 27-06-2020 - Session time: 09:40:00 - Track: Application Database Development

Speaker: Deborah Melkin

Title: Looking "Normal" and Seeing "Stars": Table Designs Working Together

Abstract:

Most database professionals know there are two different database design patterns - normal forms for OLTP databases and star schemas for data warehouses. We tend to discuss these separately. But these two designs actually work together when we create our table schemas.

In this session, we will review the basics of both normal forms and star schemas. We'll compare and contrast the two designs. We will then discuss how a normalized database design influences a star schema design and vice versa.

By the end of the session, you will better understand how using the two designs together gives you a greater insight to how you use your data throughout its lifecycle.

SessionID: 101170

From Stutterer to Speaker: Overcoming Your Fears

Back to calendar

Event Date: 27-06-2020 - Session time: 10:50:00 - Track: Professional Development

Speaker: Matt Gordon

Title: From Stutterer to Speaker: Overcoming Your Fears

Abstract:

Are you terrified of public speaking? For 37 years of my life, I was too! That paralyzing fear of public communication held me back and kept me taking from taking advantage of career and community opportunities that came my way - and I've heard this story from many. Now, when I speak at community events, I'm often asked how I got into speaking and how I got over my fears of public speaking. In this free-wheeling session I'll tell you the tips and tricks that I took to heart to go from a kid in speech therapy to somebody that volunteers to speak in front of people and actually enjoys it. Most importantly, I'll talk about how improved personal and public communication can give your career a massive boost in this time of rapid growth in the data professional realm. I sincerely hope this session helps encourage people to overcome their fears of public and small group speaking - or that you at least enjoy making fun of pictures of 6-year-old me in speech therapy headphones!

SessionID: 101200

The Art of Data Classification and Protection

Back to calendar

Event Date: 27-06-2020 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Norman

Title: The Art of Data Classification and Protection

Abstract:

Government regulations are increasing! Data breaches are being reported almost daily. Do you know what type of data is in the database and what data should be classified?

In this session, we will learn why and how to classify the data in our databases. SQL Server Management Studio (SSMS) has options to help us classify data. Let’s go into depth and see how to use the Data Discovery and Classification tool along with the Information Protection Policy tool found inside SSMS. Once the data is classified, let’s report on the data we classified. Lastly, let’s set up auditing and find out who is accessing the classified data. You will leave the session with a clear understanding of how to properly classify, report and audit the newly classified data, allowing us to better adhere to compliance regulations. Prerequisites: Having an understanding of data privacy regulation is recommended and a desire to learn how to protect data with which you have been entrusted.

SessionID: 104815

The Psychology of Better Power BI Reporting

Back to calendar

Event Date: 27-06-2020 - Session time: 10:50:00 - Track: BI Information Delivery

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

Achieve Enterprise Scale with Advanced SQL Server Features

Back to calendar

Event Date: 27-06-2020 - Session time: 10:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Kline

Title: Achieve Enterprise Scale with Advanced SQL Server Features

Abstract:

You have an OLTP database application which sustains a heavy mixed workload with lots of read and write transactions at the same time that it reports data base to a client application. Performance was fine for a long time, but it is not meeting your needs now that it must scale to much higher workloads. What should you do? In this real-world case study, you’ll learn about a series of technologies that provide unprecedented scalability, including data compression, In-Memory OLTP, and clustered-partitioned columnstore indexes. We will walk you through a chronology of the application and database architecture, its changes over time, and the degree of performance improvement achieved with each new SQL Server feature applied. This session will teach you all about planning and implementing advanced SQL Server performance features and how each one impacts your system performance for applications with 100’s or 1000’s of concurrent users.

SessionID: 101164

The Countless Benefits of Mentoring

Back to calendar

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

Speaker: Mark Runyon

Title: The Countless Benefits of Mentoring

Abstract:

Mentoring offers countless benefits to the mentee, mentor and the organization as a whole. In this session, we will map out the benefits to each participant as well as talk about how to find a mentor or how to start a mentorship program in your organization.

SessionID: 101302

The function of Windowing Functions

Back to calendar

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

Speaker: Kevin Wilkie

Title: The function of Windowing Functions

Abstract:

In the past, we have all had the need to return a result set and provide information on this with regard to a persons previous or future records. Or, alternatively, you have needed to get a single record for an individual - maybe the first, maybe the last. Doing this without windowing functions is possible but why punish yourself?! Come to learn about general windowing functions that we should all know, as well as some that you may not be aware of! Did you know you can use count(*) as a windowed function in addition to general aggregate?

SessionID: 102393

Applying Forensic Accounting Techniques Using SQL and R

Back to calendar

Event Date: 27-06-2020 - Session time: 13:00:00 - Track: Advanced Analysis Techniques

Speaker: Kevin Feasel

Title: Applying Forensic Accounting Techniques Using SQL and R

Abstract:

Forensic accountants and fraud examiners use a range of techniques to uncover fraudulent journal entries and illegal activities. As data professionals, most of us will never unravel a Bernie Madoff scheme, but we can apply these same techniques in our own environments to uncover dirty data. This session will use a combination of SQL Server and R to apply these fraud detection techniques, which include Benford's Law, outlier analysis, time series analysis, and cohort analysis.

SessionID: 105136

5 Surprising Lessons Every SQL Server Generalists Has to Learn

Back to calendar

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

Speaker: Kevin Kline

Title: 5 Surprising Lessons Every SQL Server Generalists Has to Learn

Abstract:

Maybe you are an accidental DBA who has recently been assigned responsible for the SQL Server, on-premises or in the Azure cloud. Maybe you are a generalist who can keep the SQL Server up and running, but don’t know much about how it works. Or maybe you are just starting in your career and want to learn more. Whatever situation applies to you, there are handful of very important lessons you will have to learn if you administrate a SQL Server. Whether you learn them the easy way, by study or by attending this session, or the hard way, by experiencing these problems first hand, is your choice.

In the session, your speaker takes you through five surprising situations where what you don’t know WILL hurt you. Learn them in advance so you are not surprised by them and remain in control when the eventually occur. You also see demos and overviews of native features within SQL Server that explain these concepts, as well as free community tools that can make your job easy and your life better.

SessionID: 101169

Azure-d Availability: SQL Server HA In and To the Cloud

Back to calendar

Event Date: 27-06-2020 - Session time: 14:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Matt Gordon

Title: Azure-d Availability: SQL Server HA In and To the Cloud

Abstract:

Has your manager come to you and said "I expect the SQL Server machines to have zero downtime?" Have you been told to make your environment "Always On" without any guidance (or budget) as to how to do that or what that means? Are you facing pressure to have data in Azure as well? Help is here! This session will walk you through the high availability options in on-premises SQL Server, the high availability options in Azure SQL Database and Managed Instances, and how some or all of those can be combined to enable you to achieve the ambitious goals of your management. Beyond the academic knowledge, we'll discuss frequently seen scenarios from the field covering exactly how your on-premises environments and Azure services can work together to keep your phone quiet at night.

SessionID: 101813

SQL Notebooks In-Depth

Back to calendar

Event Date: 27-06-2020 - Session time: 14:10:00 - Track: Application Database Development

Speaker: Eric Flamm

Title: SQL Notebooks In-Depth

Abstract:

We're taking a deep dive into SQL Notebooks in Azure Data Studio and their close relations, including PowerShell notebooks and Jupyter Notebooks. Going beyond the basics, we'll see how to use notebooks for demonstrations, standardized data gathering, and data exploration. We'll also use PowerShell notebooks to manage Azure resources in a predictable and well-documented manner. If time permits, we'll take a look at Azure notebooks, a cloud-first variant for data exploration and management.

SessionID: 102155

Enabling Real Time Analytics through Azure

Back to calendar

Event Date: 27-06-2020 - Session time: 14:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Ed Pearson

Title: Enabling Real Time Analytics through Azure

Abstract:

How do we deliver more business value to data hungry customers who constantly want more and faster? How do we enable automation to deliver complex solutions that provide consistent data to empower a self-service BI environment?

I will demonstrate how our analytics team is leveraging Azure and cloud-native technologies to ensure we can meet the demands of our customer base, and in turn, deliver faster and higher volume results.

My presentation will walk through an end-to-end solution – from data acquisition using Azure Logic Apps; data transformation via Azure Data Factory; and ending with reporting in PowerBI.

SessionID: 105118

Intelligent Insights with Power BI

Back to calendar

Event Date: 27-06-2020 - Session time: 14:10:00 - Track: BI Information Delivery

Speaker: Dan Evans

Title: Intelligent Insights with Power BI

Abstract:

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.

SessionID: 101329

Infrastructure for the Data Professional: An Introduction

Back to calendar

Event Date: 27-06-2020 - Session time: 15:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Peter Shore

Title: Infrastructure for the Data Professional: An Introduction

Abstract:

It doesn’t matter if you are a Junior DBA, an accidental DBA or all the way up to a Senior DBA, the infrastructure your SQL Server environment runs on is important. Many among the DBA community came in as developers or perhaps directly into database administration roles it is equally possible that you have been out of the operations world long enough to have fallen out of the loop with what is happening. This session is intended to provide a full stack infrastructure overview so that you can talk shop with your cohorts in operations to resolve issues and maybe even be proactive. We will discuss, in an introductory fashion, hardware, network, storage, virtualization and operating system layers. Additionally, some suggestions as to where to find more information will be provided.

SessionID: 102010

Learn How to Master DATETIME Functions Like a Boss in 59.5 Minutes or Less

Back to calendar

Event Date: 27-06-2020 - Session time: 15:20:00 - Track: Application Database Development

Speaker: Peter Doyle

Title: Learn How to Master DATETIME Functions Like a Boss in 59.5 Minutes or Less

Abstract:

- Do you know the dates of the 1st Monday, 2nd Tuesday, 3rd Wednesday, and 4th Thursday of any month between the 22 weeks and 47 weeks of any given year?

Those two questions may have been a trivial but there is nothing trivial about working within the complexity of dates and times. Trains, Planes, and sometimes at automobile races depend on precise and accurate date-time recordings.

In this demo-heavy presentation, we will answer the following questions and more:

So stop wasting time and get on board because it's about time for the plane to depart.

SessionID: 104153

Basic Data Modeling for BI Reporting

Back to calendar

Event Date: 27-06-2020 - Session time: 15:20:00 - Track: BI Platform Architecture, Development Administration

Speaker: Michael McKinley

Title: Basic Data Modeling for BI Reporting

Abstract:

Come learn about the basics of data modeling for your business intelligence and reporting needs. This course will cover several introductory modeling subjects, including:

SessionID: 105129

A Beginner's Guide to Becoming a Performance Tuner

Back to calendar

Event Date: 27-06-2020 - Session time: 15:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Andy Yun

Title: A Beginner's Guide to Becoming a Performance Tuner

Abstract:

Are you a relative newcomer to SQL Server and want to get into performance tuning? Or maybe you just want to expand your knowledge of hidden performance killers?

Then join me for a survey of worst practices that kill performance in SQL Server. In this demo-filled session, we will cover a mix of administrative and T-SQL development practices, making this session suitable for DBAs and developers alike! Topics include server configuration mistakes, T-SQL parallelism, and TempDB headaches.

When you leave, you'll be armed with knowledge and tools to get a jump start on your journey to specializing as a performance tuner.

This site is open source. Improve this page.