sqlsathistory

Nr: 948

Back to Main list

SQLSaturday #948 – Cincinnati – Virtual 2020

Start Time (24h) Speaker Track Title
12:15:00 Jon Moore Enterprise Database Administration Deployment Improve your daily productivity levels with SentryOne solutions
08:00:00 Bob Ward Enterprise Database Administration Deployment SQL Server By Example
09:15:00 Lucas Feiock Cloud Application Development Deployment Getting started with Azure Machine Learning
09:15:00 Buck Woody Professional Development Presentation Skills for the Technical Professional
09:15:00 Julie McLain-Harper Enterprise Database Administration Deployment Managing Availability Groups with PowerShell, Tips, Techniques, Cool Scripts!
09:15:00 Jim Donahoe Cloud Application Development Deployment Getting started with Azure SQL Database: What You Need To Know!
10:30:00 Anna Hoffman Cloud Application Development Deployment Azure SQL Database: Maximizing Cloud Performance and Availability
10:30:00 Vanessa Kesten BI Platform Architecture, Development Administration Charlie and the Data Factory
10:30:00 Sriharsh Adari Advanced Analysis Techniques Enable Real-time Analytics and Machine Learning with Azure Stream Analytics and Azure IoT
10:30:00 Matthew Groves Application Database Development Querying NoSQL with SQL: HAVING Your JSON Cake and SELECTing it too
11:40:00 Dave Mattingly Professional Development Achievement Unlocked: How to Get Promoted
11:40:00 Eugene Meidinger Analytics and Visualization Introduction to M (a.k.a Power Query)
11:40:00 Mark Beedle BI Information Delivery Power BI Data Modeling with Less Than Ideal Data Sources
11:40:00 Tracy Boggiano Enterprise Database Administration Deployment Using Open Source Software to Collect Performance Metrics
12:50:00 Jim Miller Application Database Development Azure Data Studio – Way Cool for Database Applications
12:50:00 Sam Nasr BI Information Delivery New Features in SSRS 2017
12:50:00 Slava Trofimov Analytics and Visualization Making Your Reports Faster – Introduction to Power BI Performance Tuning
12:50:00 Argenis Fernandez Enterprise Database Administration Deployment SQL Server Virtualization and I/O Patterns
14:00:00 Eugene Meidinger Analytics and Visualization An (Advanced) Introduction to DAX
14:00:00 Chris Smith Application Database Development A Better Way to Run MsSql (aka Can You Believe This is Even Possible?!?!)
14:00:00 Corey Hambrick Enterprise Database Administration Deployment AWS vs. Azure: What's The Difference For A DBA?
14:00:00 Alicia Moniz Advanced Analysis Techniques AI For Good: Cognitive Services Vision
15:10:00 Forrest McDaniel Application Database Development Query Plans For Visual Learners
15:10:00 Tracy Boggiano Professional Development More Common Than You Think: Mental Illness in Tech
15:10:00 Jim Miller Application Database Development Azure Data Studio – Way Cool for Azure and On-Prem SQL
15:10:00 Sam Nasr Application Database Development SQL Server Security Features
15:10:00 John Miner Strategy and Architecture Navigating Today's Azure SQL Services
16:20:00 Buck Woody Enterprise Database Administration Deployment SQL Server 2019 Big Data Clusters Architecture
16:20:00 Lisa Bohm Application Database Development SARGability: The Case of the Unused Index
16:20:00 Josh Handler Enterprise Database Administration Deployment Real World Use Cases Utilizing DbaTools.IO
16:20:00 Andy Mallon Application Database Development When to use indexing pro features

SessionID: 103185

Improve your daily productivity levels with SentryOne solutions

Back to calendar

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

Speaker: Jon Moore

Title: Improve your daily productivity levels with SentryOne solutions

Abstract:

In this session, Jon Moore will be diving into a quick, high-level overview of the vast monitoring, development analysis capabilities provided by SentryOne throughout most of the Microsoft stack. Whether you’re a DBA, developer, manager, business analyst or somewhere in between, SentryOne has something to take the pain out of your daily operations.

SessionID: 100961

SQL Server By Example

Back to calendar

Event Date: 16-05-2020 - Session time: 08:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Bob Ward

Title: SQL Server By Example

Abstract:

Sometimes there is no better way than to learn by example. In this session, you will learn key capabilities of SQL Server and Azure SQL by seeing demonstrations. This session is all about less slides and more demos! This session will show you demonstrations on topics such as containers, Kubernetes, performance, availability, and data virtualization. You will walk away with all the resources you need to try out everything you see on your own time.

SessionID: 100826

Getting started with Azure Machine Learning

Back to calendar

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

Speaker: Lucas Feiock

Title: Getting started with Azure Machine Learning

Abstract:

Azure Machine Learning is a managed service that integrates services together for a full end-to-end machine learning solution. Azure ML enables Data Scientists, Data Engineers, and Business Users faster development, deployment, and access to machine learning models. Services available for each role include zero-code/low-code designer, Python, R, Databricks, Azure Kubernetes Service, and many more. Workspaces keep assets and artifacts in one place for easy management. Models can be developed locally, trained in Azure, and deployed to any device or environment. In this session, we will cover the built-in tools of the service and see an end-to-end solution for a simple machine learning model.

SessionID: 101002

Presentation Skills for the Technical Professional

Back to calendar

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

Speaker: Buck Woody

Title: Presentation Skills for the Technical Professional

Abstract:

Whether you're new to presenting or an accomplished professional, all of us need to learn more about presentation skills. In this real-world session, Buck Woody, a Data Scientist from Microsoft will show you how to:

SessionID: 101519

Managing Availability Groups with PowerShell, Tips, Techniques, Cool Scripts!

Back to calendar

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

Speaker: Julie McLain-Harper

Title: Managing Availability Groups with PowerShell, Tips, Techniques, Cool Scripts!

Abstract:

Availability Groups can help an organization smoothly handle OLTP and Reporting Requests, as well as provide a site for Disaster Recovery in a data synchronous manner. As a DevOps DBA, managing the availability groups using PowerShell makes the job of deployment, upgrades, and security a breeze. The PowerShell SqlServer module has many useful functions to achieve the goal of simplifying administration of availability groups. I will share my experiences and also some additional custom scripts to help in managing your Availability Groups.

SessionID: 99658

Getting started with Azure SQL Database: What You Need To Know!

Back to calendar

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

Speaker: Jim Donahoe

Title: Getting started with Azure SQL Database: What You Need To Know!

Abstract:

Azure SQL Database offers a way quickly spin up new databases with minimal management requirements. However, the number of differences between on-premises SQL Server and Azure SQL Database can be overwhelming. Even worse, with DBaaS it’s not clear who is responsible for what anymore. In this session, we will cover all the basic steps of getting your first Azure SQL Database instance spun up. We’ll cover common gotchas, like firewall settings and resource locks. We’ll also dive into some more advanced options with templates, allowing you to make your processes reproducible. By the end of this presentation, you’ll understand if Azure SQL Database is the right choice for you and your needs. You’ll understand how it can simplify management and allow you to scale easily. Finally, you’ll have the confidence to go and create your own instance with ease.

SessionID: 100965

Azure SQL Database: Maximizing Cloud Performance and Availability

Back to calendar

Event Date: 16-05-2020 - Session time: 10:30:00 - Track: Cloud Application Development Deployment

Speaker: Anna Hoffman

Title: Azure SQL Database: Maximizing Cloud Performance and Availability

Abstract:

When you move to Azure SQL Database, you select a predefined set of allocated resources across several dimensions such as CPU, memory, storage, and more. For a typical business application you need to find a balance between cost, performance demands and availability requirements. Yet for your mission critical application your focus moves toward the highest availability (i.e. 99.995% uptime) and performance. In this session we’ll review best practices around how to select your Azure SQL database configuration that is optimized for a specific application pattern and how to maximize its performance and availability. We’ll review the natural advantages you can leverage from the Azure SQL Database ecosystem and detail factors to consider when optimizing for performance in the cloud, including application patterns and anti-patterns that you may encounter when migrating legacy applications from SQL Server to Azure SQL Database.

SessionID: 102644

Charlie and the Data Factory

Back to calendar

Event Date: 16-05-2020 - Session time: 10:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Vanessa Kesten

Title: Charlie and the Data Factory

Abstract:

Azure Data Factory is your golden ticket to moving and transforming data in Azure! On your tour of the factory you'll learn all the basics - Pipelines, Datasets, Connections and Triggers. Taking a closer look at pipelines, you'll see how to use a variety of activities, set up variables and parameters, and view debugging output. Next you'll learn how to monitor your pipelines and how using templates can improve your Data Factory experience. Finally you'll get to see the data mapping capabilities of Data Flows. By the end of your tour, you'll be saying that Azure Data Factory is Scrumdiddlyumptious!

SessionID: 102719

Enable Real-time Analytics and Machine Learning with Azure Stream Analytics and Azure IoT

Back to calendar

Event Date: 16-05-2020 - Session time: 10:30:00 - Track: Advanced Analysis Techniques

Speaker: Sriharsh Adari

Title: Enable Real-time Analytics and Machine Learning with Azure Stream Analytics and Azure IoT

Abstract:

As Organizations are looking to transform into data driven organizations. Stream analytics has emerged as an integral part of Enterprise Data platform architectures along with batch ETL. Stream analytics help to gain maximum value from user-interaction events, applications and machine logs. Ingesting, processing, and analyzing these data streams quickly and efficiently is critical in fraud detection, click stream analysis, sentiment analytics, online recommendations and IOT Scenarios among many examples. In this session we will look at options available in azure for real-time analytics and deep dive into Azure Stream Analytics. Build streaming jobs that can blend and aggregate data as it arrives to drive live Power BI dashboards. Plus, we’ll explore how a complete lambda architecture can be created when combining stream and batch data together and finally how it integrates with Azure ML.

SessionID: 99579

Querying NoSQL with SQL: HAVING Your JSON Cake and SELECTing it too

Back to calendar

Event Date: 16-05-2020 - Session time: 10:30:00 - Track: Application Database Development

Speaker: Matthew Groves

Title: Querying NoSQL with SQL: HAVING Your JSON Cake and SELECTing it too

Abstract:

Until recently, agile business had to choose between the benefits of JSON-based NoSQL databases and the benefits of SQL-based querying. NoSQL provides schema flexibility, high performance, and elastic scaling, while SQL provides expressive, independent data access. Recent convergence allows developers and organizations to have the best of both worlds.

Developers need to deliver apps that readily evolve, perform, and scale, all to match changing business needs. Organizations need rapid access to their operational data, using standard analytical tools, for insight into their business. In this session, you will learn the ways that SQL can be applied to NoSQL databases, and what additional features are needed to deal with JSON documents. SQL for JSON, JSON data modeling, indexing, and tool integration will be covered. This session will focus mainly on CosmosDb and Couchbase, but it will also touch on emerging relational approaches to JSON data.

SessionID: 100418

Achievement Unlocked: How to Get Promoted

Back to calendar

Event Date: 16-05-2020 - Session time: 11:40: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: 101240

Introduction to M (a.k.a Power Query)

Back to calendar

Event Date: 16-05-2020 - Session time: 11:40:00 - Track: Analytics and Visualization

Speaker: Eugene Meidinger

Title: Introduction to M (a.k.a Power Query)

Abstract:

When it comes to getting your data into Excel or Power BI, M is your best choice. The M Language (A.K.A Power Query) is a powerful tool for self-service data preparation. However, it's not clear where it fits compared to tools like SSIS or TSQL. It's also not clear what it's limitations are. This session will cover the basics of M and when to use it.

In this session, we'll demonstrate how M is a linear series of transformations, just like a set of steps from a recipe. We'll show how 80% of what you will ever need to do can be done from the GUI. We'll also talk about how to write custom code for that other 20%. By the end of this presentation, you'll be able to take any manual cleanup you do today and turn it into a repeatable process with M.

SessionID: 102704

Power BI Data Modeling with Less Than Ideal Data Sources

Back to calendar

Event Date: 16-05-2020 - Session time: 11:40:00 - Track: BI Information Delivery

Speaker: Mark Beedle

Title: Power BI Data Modeling with Less Than Ideal Data Sources

Abstract:

Ever get frustrated when watching Power BI training videos or reading through best practice documentation because the data sources that you have at work aren't anything like the pristine data warehouse sources from the video?

This course will provide guidance and tips for building a solid Power BI data model with less than ideal data sources. If you have ever struggled building a data model from super wide, flattened out excel spreadsheets, this course is for you. We'll start off with some flattened data sources and end up with a star schema that will impress any data warehouse architect!

SessionID: 99785

Using Open Source Software to Collect Performance Metrics

Back to calendar

Event Date: 16-05-2020 - Session time: 11:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Using Open Source Software to Collect Performance Metrics

Abstract:

Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? If only you knew what performance metrics to collect and had them for your existing instances to answer these questions.

In this session, we will discuss sp_whoisactive and Query Store to track what queries are running. Then, we will be combining three open source tools – Telegraf, InfluxDB, and Grafana – into an inexpensive and easy to set up system that collects performance metrics you can use to troubleshoot issues and answer important questions about your SQL Server instances, including your Linux SQL Server instances, Azure Managed Instances, and Azure SQL Databases. Attendees will see how easy it is to get good performance data and visualize it interactively, and combine with other tools to troubleshoot issues. Finally, we will look at a problem I solved using this solution as an example.

SessionID: 102187

Azure Data Studio – Way Cool for Database Applications

Back to calendar

Event Date: 16-05-2020 - Session time: 12:50:00 - Track: Application Database Development

Speaker: Jim Miller

Title: Azure Data Studio – Way Cool for Database Applications

Abstract:

Azure Data Studio (ADS) cross-platform database development tool which runs on Windows, Linux, and MacOS. ‘ADS’ supports SQL Server and Postgres (with more DB platforms soon) and works both on-prem and in the cloud. ADS is highly extensible, open source, and can dramatically change the way you work with databases.

In this session, we will provide a case study on how Azure Data Studio can directly integrate with an existing ELT/ETL database application. Topics include:

SessionID: 102219

New Features in SSRS 2017

Back to calendar

Event Date: 16-05-2020 - Session time: 12:50:00 - Track: BI Information Delivery

Speaker: Sam Nasr

Title: New Features in SSRS 2017

Abstract:

SQL Server Reporting Services 2017 offer many new features, making it more robust than ever. These features include Web Report Portal with KPI, Mobile Report Publisher, Redesigned report rendering engine supporting HTML5, and treemap sunburst chart types.

With intuitive interfaces and rich data visualization, business users and stake holders can now view valuable information, not just numbers. This session will cover requirements for installing and configuring SSIS, and how to quickly generate reports.

SessionID: 102720

Making Your Reports Faster – Introduction to Power BI Performance Tuning

Back to calendar

Event Date: 16-05-2020 - Session time: 12:50:00 - Track: Analytics and Visualization

Speaker: Slava Trofimov

Title: Making Your Reports Faster – Introduction to Power BI Performance Tuning

Abstract:

Even the most beautifully designed reports that provide the most brilliant insights may suffer from a crippling problem: slow performance. In this demo-rich session we will discuss the key factors that impact the performance of your Power BI reports and learn simple, practical guidelines for making your reports faster.

SessionID: 105006

SQL Server Virtualization and I/O Patterns

Back to calendar

Event Date: 16-05-2020 - Session time: 12:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Argenis Fernandez

Title: SQL Server Virtualization and I/O Patterns

Abstract:

In this session we will explore the SQL Server engine’s I/O patterns and how they play into virtualization infrastructure. With the knowledge you’ll gain in this session you will be able to have more educated conversations with your cloud/infrastructure/VM/storage administrators in order to get the most performance and use the best features for your SQL Server (or SQL in Azure/AWS/GCP) environments.

SessionID: 101238

An (Advanced) Introduction to DAX

Back to calendar

Event Date: 16-05-2020 - Session time: 14:00:00 - Track: Analytics and Visualization

Speaker: Eugene Meidinger

Title: An (Advanced) Introduction to DAX

Abstract:

Coming from the Excel world, DAX can look like Excel formulas on steroids. However, to be successful with DAX and Powerpivot, you'll need a completely different mental model. In this introduction to DAX, we won't spend too much time on the basics. Instead, we'll focus the concepts that make DAX unique. This will help you avoid the stumbling blocks of working with DAX. We will cover calculated columns, measures, aggregations, filtering, and iterators.

SessionID: 101945

A Better Way to Run MsSql (aka Can You Believe This is Even Possible?!?!)

Back to calendar

Event Date: 16-05-2020 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Chris Smith

Title: A Better Way to Run MsSql (aka Can You Believe This is Even Possible?!?!)

Abstract:

Ten years ago, if you said that we would someday run Sql Server not only on Linux, but on Linux ON WINDOWS, you'd have been laughed out of the room. Here in 2020, though, not only is it possible, but it's faster and easier than installing Sql Server the old-fashioned way!

In this talk, we'll discuss:

  1. The basics how to run Docker containers locally on Windows 10.
  2. How to get Sql Server for Linux running on it.
  3. How to connect to it locally for your development needs.

SessionID: 102130

AWS vs. Azure: What's The Difference For A DBA?

Back to calendar

Event Date: 16-05-2020 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Corey Hambrick

Title: AWS vs. Azure: What's The Difference For A DBA?

Abstract:

Everyone has strong opinions and reactions to which cloud database platform companies should be using but how different are they, really? What features does one cloud provider support that the other might not? How will normal DBA activities, such as backups and restores, change depending on the cloud provider your company uses? Join me in this session as I share my migration stories and discuss the results of my research about how AWS and Azure are different and how many of my daily tasks and tools changed as our company migrated to AWS. Come and listen as I share what I have learned on this journey from on-premises to the cloud. Join me and find out which platform I would use.

SessionID: 102750

AI For Good: Cognitive Services Vision

Back to calendar

Event Date: 16-05-2020 - Session time: 14:00:00 - Track: Advanced Analysis Techniques

Speaker: Alicia Moniz

Title: AI For Good: Cognitive Services Vision

Abstract:

Are you curious about the role that AI will play in predictive modeling? Are you wondering what the difference is between the Computer Vision API and the Custom Vision API? Do you want a quick introduction to get you up to speed on both, so that you can quickly build and deploy a Cognitive Services model?

Join us for an introduction to the Cognitive Services Computer Vision and Custom Vision APIs on Azure.

In this session, we will look at the basics of Cognitive Services Vision. First learn how to create your Cognitive Services model. Then you can see how to train and improve accuracy. Finally, we will step through python code in Azure Notebooks to call the APIs.

After this session, you will get up and running in Cognitive Services Vision in under an hour!

Prerequisites: Attendees should have an Azure account, as well as an account on Azure Notebooks. Experience with coding in python is helpful, but not required.

SessionID: 100639

Query Plans For Visual Learners

Back to calendar

Event Date: 16-05-2020 - Session time: 15:10:00 - Track: Application Database Development

Speaker: Forrest McDaniel

Title: Query Plans For Visual Learners

Abstract:

You’ve looked at query plans and done some tuning, but you’re not sure what’s going on underneath. Hash Match? Merge Join? Watch both come to life in animations, and more! See (not just hear) the inner workings of a plan, and learn about the details that matter for performance. When plans make sense, tuning will become easier, and maybe even fun!

SessionID: 100720

More Common Than You Think: Mental Illness in Tech

Back to calendar

Event Date: 16-05-2020 - Session time: 15:10:00 - Track: Professional Development

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

Azure Data Studio – Way Cool for Azure and On-Prem SQL

Back to calendar

Event Date: 16-05-2020 - Session time: 15:10:00 - Track: Application Database Development

Speaker: Jim Miller

Title: Azure Data Studio – Way Cool for Azure and On-Prem SQL

Abstract:

Azure Data Studio (ADS) cross-platform database development tool which runs on Windows, Linux, and MacOS. ‘ADS’ supports SQL Server and Postgres (with more DB platforms soon) and works both on-prem and in the cloud. ADS is highly extensible, open source, and can dramatically change the way you approach SQL coding.

In this session, we will cover ‘ADS’ features and capabilities such as

SessionID: 102217

SQL Server Security Features

Back to calendar

Event Date: 16-05-2020 - Session time: 15:10: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: 105008

Navigating Today's Azure SQL Services

Back to calendar

Event Date: 16-05-2020 - Session time: 15:10:00 - Track: Strategy and Architecture

Speaker: John Miner

Title: Navigating Today's Azure SQL Services

Abstract:

Five years ago there was a limited number of ways to deploy and use the SQL Server engine in the Azure Cloud. Today, there are many different services that one can choose.

How do you determine which service to use?

In this presentation we focus on key attributes of your data to pick the correct service. Certain services have limits on size, performance and movability of database. Other factors, such as the budget of your project, may also come into the decision making.

Transferring a database to the cloud is usually the easiest part of the project. Scheduling batch processes, executing maintenance jobs and providing alerts is usually part of the DBA equation. For companies that have a large amount of ETL packages, a lift and shift of this code might be a consideration. Other companies are more security conscious which means auditing, compliance, and threat detection are key factors in the decision.

At the end of the presentation, the attendee will have a broad knowledge of the Azure SQL services and when to apply each to a given project.

SessionID: 101003

SQL Server 2019 Big Data Clusters Architecture

Back to calendar

Event Date: 16-05-2020 - Session time: 16:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Buck Woody

Title: SQL Server 2019 Big Data Clusters Architecture

Abstract:

​In this session Buck Woody explains how Microsoft has implemented the SQL Server 2019 relational database engine in a big data cluster leverages an elastically scalable storage layer that integrates SQL Server and HDFS to scale to petabytes of data storage. You’ll see the three ways you can interact with massive amounts of data: Data Virtualization, Data Marts, and working with a complete Kubernetes Cluster in SQL Server. You’ll also learn common use case scenarios that leverage big data and the SQL server 2019 Big Data Cluster on-premises, in the cloud, and in a hybrid architecture. Learning Objectives: - Articulate the Big Data Landscape and the problems it addresses - Present the technology approaches to analyzing large, heterogenous data sets to an audience - Design a solution using SQL Server 2019’s Big Data Clusters architecture and programming model

SessionID: 102685

SARGability: The Case of the Unused Index

Back to calendar

Event Date: 16-05-2020 - Session time: 16:20:00 - Track: Application Database Development

Speaker: Lisa Bohm

Title: SARGability: The Case of the Unused Index

Abstract:

I just wrote some tSQL code, and made a perfect index! But wait, it's still slow and it's not being used! Why not?

We're going to take a look at indexes and how they work, and then do a deeper dive into the ways we write our code that will not allow it to use those wonderful indexes. Participants will come out with a deeper understanding of indexes and yet more coding anti-patterns to avoid!

SessionID: 102824

Real World Use Cases Utilizing DbaTools.IO

Back to calendar

Event Date: 16-05-2020 - Session time: 16:20:00 - Track: Enterprise Database Administration Deployment

Speaker: Josh Handler

Title: Real World Use Cases Utilizing DbaTools.IO

Abstract:

If you have been anywhere near the SQL community in the past year, you have heard of this cool new toolset call DBAtools. DBAtools is set of PowerShell commands that will help make every DBA's (including the accidental DBA's) life easier. With just a few piece of information, you can manage and report on your SQL instances, from one to many, with ease. This session is a quick overview of what DBAtools is, some of the things you can do with it, and then some real world examples that are taken from our daily uses. Our objective is that when you leave this session, you will be comfortable reporting on your instances, and be prepared to take the next steps, AUTOMATION!!

SessionID: 105014

When to use indexing pro features

Back to calendar

Event Date: 16-05-2020 - Session time: 16:20:00 - Track: Application Database Development

Speaker: Andy Mallon

Title: When to use indexing pro features

Abstract:

Using the right index for the right scenario can be the "go fast" button that keeps queries and customers happy.

Over the years, Microsoft has given us many different indexing options and flavors. Today there are many more considerations beyond "clustered or non clustered". We'll cover all those different flavor options: Filtered, Compressed, Columnstore, included columns, and Partitioning.

We'll cover an overview of what each of these options are, and then dive into some code examples to see how and when each of these work, and when the don't.

You will leave the session with a much better idea of how and when to use each of these special indexing flavors to meet your needs.