Nr: 933
SQLSaturday #933 - Nashville 2020
SessionID: 100563
On-Site Registration non-printed SPEEDPASS
Event Date: 18-01-2020 - Session time: 08:30:00 - Track: Other
Speaker: SQLSaturday Nashville
Title: On-Site Registration non-printed SPEEDPASS
Abstract:
If you didn't print your speedpass you may stop in here to get one printed. If you didn't register you can also register in here. If you had issues printing/paying for lunch or any other questions you may stop by.
SessionID: 98888
Event Date: 18-01-2020 - Session time: 08:30:00 - Track: Database Adminstration
Speaker: Monica Rathbun
Abstract:
SessionID: 99178
User Experience Brilliance in Power BI Dashboards
Event Date: 18-01-2020 - Session time: 08:30:00 - Track: Professional Development
Speaker: Hilary Wilkie
Title: User Experience Brilliance in Power BI Dashboards
Abstract:
User Experience (UX) and Design Thinking are common buzz words around the office. What do these words have to do with BI and Dashboards, anyway?
Sure, Power BI itself is intuitive and user friendly, but are YOU building dashboards that people will actually use. If you want to get the business off of their beloved excel and onto your dashboards, this is how you will do it.
In this session, we will explore how to start using UX and the psychology behind it to empower you with intel that will make YOUR dashboards Kick Booty! We will show examples and arm with the tools/strategies to make the best dashboards your business has ever used.
SessionID: 99258
SQL Server Database Security: Do Your Part, Be Security Smart!
Event Date: 18-01-2020 - Session time: 08:30:00 - Track: Database Adminstration
Speaker: Julie McLain-Harper
Title: SQL Server Database Security: Do Your Part, Be Security Smart!
Abstract:
How can you make sure your SQL Server data doesn't get in the wrong hands? What are some common SQL Server specific security considerations? What are the best practices? When and where should they be implemented? What techniques for security can be used in SQL Server? What can I do as a DBA or Developer to ensure data is secured in all environments? Tips and troubleshooting from a real world Sr. DBA with DevOps experience will be presented to help attendees identify the most common but hardest to resolve issues. SQL Server security features, including a demo with scripts on how to use Transparent Data Encryption (TDE), will be shared.
SessionID: 99381
Keeping up with change in Office 365
Event Date: 18-01-2020 - Session time: 08:30:00 - Track: Other
Speaker: Daniel Glenn
Title: Keeping up with change in Office 365
Abstract:
Every month there are dozens of changes made throughout the services in Microsoft 365. The changes can bring brand new features, but also change aspects on which your business solutions are based.
How do you stay informed about the changes and prepare your environment for all the updates? How can you keep your users up-to-date with the features that are available and manage the process of change?
During this session, we will discuss how IT Pros and collaboration enablers can keep up with all the changes, promote adoption with your users, and help your organization stay focused on what you do best.
SessionID: 99654
Event Date: 18-01-2020 - Session time: 08:30:00 - Track: Database Application Development
Speaker: Kathi Kellenberger
Abstract:
SessionID: 99692
Data Bricks, Spark, Machine Learning and Azure Synapse Analytics
Event Date: 18-01-2020 - Session time: 08:30:00 - Track: Cloud Database/Application Development Deployment
Speaker: Simon Kingaby
Title: Data Bricks, Spark, Machine Learning and Azure Synapse Analytics
Abstract:
SessionID: 99794
Intro to Azure Data Factory
Event Date: 18-01-2020 - Session time: 08:30:00 - Track: Cloud Database/Application Development Deployment
Speaker: Olivia Albertson
Title: Intro to Azure Data Factory
Abstract:
Working with data doesn't need to be a hassle. Many developers hear the phrase "ETL" and shudder. Azure Data Factory makes moving data, kicking off procedures, and automating workflows easier and more streamlined than previous utilities. In my discussion, I will explain and demonstrate how to get started with Azure Data Factory, and some tips and tricks for ease of use.
SessionID: 99796
Introduction to the hybrid cloud
Event Date: 18-01-2020 - Session time: 08:30:00 - Track: BI Architecture Management
Speaker: Gilda Alvarez
Title: Introduction to the hybrid cloud
Abstract:
The Hybrid cloud is allowing workloads to move between private and public clouds as computing needs and costs change, hybrid cloud gives businesses greater flexibility and more data deployment option. The key to creating a successful hybrid cloud is to select the right hypervisor and wide-area network solution.
SessionID: 99809
Database Design Fundamentals
Event Date: 18-01-2020 - Session time: 08:30:00 - Track: Database Application Development
Speaker: Louis Davidson
Title: Database Design Fundamentals
Abstract:
SessionID: 100120
Event Date: 18-01-2020 - Session time: 09:45:00 - Track: BI Analytics and Visualization
Speaker: Sekou Tyler
Abstract:
SessionID: 101830
The Future of Azure Data Services: What are Azure Synapse Analyti
Event Date: 18-01-2020 - Session time: 09:45:00 - Track: Cloud Database/Application Development Deployment
Speaker: Josh Luedeman
Title: The Future of Azure Data Services: What are Azure Synapse Analyti
Abstract:
In this session, we will review the massive new changes in the user experience for Azure Synapse Analytics, formerly SQL Data Warehouse, and the great functionality Azure Arc can bring to your organization with hybrid Azure SQL PostgresSQL MI that can deploy to any cloud and on-premise. We will review the new features, the new user experience, talk about Kubernetes SQL, qualification for private previews, and discuss some frequently asked questions.
SessionID: 98856
Azure 101
Event Date: 18-01-2020 - Session time: 09:45:00 - Track: Cloud Database/Application Development Deployment
Speaker: Denny Cherry
Title: Azure 101
Abstract:
SessionID: 99020
Event Date: 18-01-2020 - Session time: 09:45:00 - Track: Database Adminstration
Speaker: Tracy Boggiano
Abstract:
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: 99095
Introduction to GitHub
Event Date: 18-01-2020 - Session time: 09:45:00 - Track: Database Application Development
Speaker: Joshua Higginbotham
Title: Introduction to GitHub
Abstract:
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.
SessionID: 99252
Event Date: 18-01-2020 - Session time: 09:45:00 - Track: Database Application Development
Speaker: Andy Yun
Abstract:
Join me for a deep dive into the storage engine to understand how SQL Server handles I/O. Concepts will be paired with T-SQL examples to illustrate the practical impacts.
When you leave, you'll be able to optimize your T-SQL reduce I/O and improve performance across the board.
SessionID: 99526
What You'll Love in SQL Server 2019
Event Date: 18-01-2020 - Session time: 09:45:00 - Track: Database Adminstration
Speaker: John Morehouse
Title: What You'll Love in SQL Server 2019
Abstract:
SessionID: 99769
Determining the Cost to Move to Azure
Event Date: 18-01-2020 - Session time: 09:45:00 - Track: Cloud Database/Application Development Deployment
Speaker: Dustin Dorsey
Title: Determining the Cost to Move to Azure
Abstract:
You have read all about moving to the cloud, spoken to colleagues who are on it and even attended events where they told you about how great it is, and YOU ARE SOLD! You recognize the benefits of storing your SQL Server workloads in the cloud and ready for things to happen. Everyone agrees its the right answer, however, there is one problem. Your organization need to understand the expected costs before moving forward. Understanding the cost to move to Azure and its run rate are questions several companies struggle with and has led to several choosing to stay in their current state. It is not because the cost is too high as some may expect, but oftentimes because simply no one has any idea what to expect.
In this session, I will walk you through steps that show you how to estimate the cost of your move to Azure and provide several unique considerations along the way that can have an impact on this. Next time someone asks how much, you will be ready!
SessionID: 99780
Building a Strong Foundation for Data Analysis
Event Date: 18-01-2020 - Session time: 09:45:00 - Track: BI Architecture Management
Speaker: Leslie Andrews
Title: Building a Strong Foundation for Data Analysis
Abstract:
SessionID: 98810
Inside the Database Engine
Event Date: 18-01-2020 - Session time: 11:00:00 - Track: Database Adminstration
Speaker: John Deardurff
Title: Inside the Database Engine
Abstract:
SessionID: 98858
Lessons Learned from a Successful Enterprise Power BI Deployment
Event Date: 18-01-2020 - Session time: 11:00:00 - Track: BI Architecture Management
Speaker: Steve Wake
Title: Lessons Learned from a Successful Enterprise Power BI Deployment
Abstract:
SessionID: 99307
A DBAs Guide to the Proper Handling of Corruption
Event Date: 18-01-2020 - Session time: 11:00:00 - Track: Database Adminstration
Speaker: Brandon Leach
Title: A DBAs Guide to the Proper Handling of Corruption
Abstract:
Corruption can strike at any time. As DBAs, how we alert, investigate, and respond can have a profound impact on our company. In this session we will learn how to detect and respond to various types of corruption. In this introductory session for beginners we will introduce the concepts around how to monitor and respond to corruption incidents in our databases.
First we will focus on ways to detect corruption early. This will include understanding tools available to us like DBCC CheckDB as well as the importance of testing our backups. We’ll also look at some sample scripts to automate corruption checks and common alerts we should have set up on our instances.
Then we will move onto how to properly manage an incident and discuss some common examples of corruption. We’ll look at how we can analyze the situation safely as well as point out various pitfalls that trip people up. We’ll also discuss when and how we may be able to fix corruption vs restoring the database.
SessionID: 99456
Data Virtualization with PolyBase
Event Date: 18-01-2020 - Session time: 11:00:00 - Track: Database Application Development
Speaker: Kevin Feasel
Title: Data Virtualization with PolyBase
Abstract:
PolyBase is Microsoft's data virtualization technology, allowing you to integrate SQL Server with external systems such as Hadoop and Azure Blob Storage. As of SQL Server 2019, PolyBase also allows you to connect to diverse systems such as Oracle, MongoDB, Cosmos DB, Teradata, Apache Spark, and even other SQL Server instances. In this talk, we will walk through the mechanics of PolyBase, showing how we can write T-SQL queries to access data from heterogeneous sources. We will investigate the Dynamic Management Views (DMVs) and other resources needed to tease out what the PolyBase engine is doing behind the scenes and where to go when things break down. Finally, we will look at several interesting use cases for PolyBase in the modern data environment.
SessionID: 99638
CosmosDB is the missing piece to your Data puzzle!
Event Date: 18-01-2020 - Session time: 11:00:00 - Track: Cloud Database/Application Development Deployment
Speaker: Hasan Savran
Title: CosmosDB is the missing piece to your Data puzzle!
Abstract:
I will cover the following topics in this session
Why do we need another database system?
How to setup Azure CosmosDB
How to create database and containers.
How much does it cost?
Multi-Model Apis
CosmosDB vs SQL Server
How to Import Data into CosmosDB
How to use Cosmos DB Emulator
CosmosDB Limitations
SessionID: 99664
How To Be The DBA When You Don't Have A DBA
Event Date: 18-01-2020 - Session time: 11:00:00 - Track: Database Adminstration
Speaker: Eric Cobb
Title: How To Be The DBA When You Don't Have A DBA
Abstract:
Not everyone has a full time Database Administrator on staff, and in many cases the responsibility of managing the database server falls on the developers. But as long as the backups are running successfully you're good, right? Not exactly. There is ongoing maintenance required to help ensure that your databases are running smoothly. Are your statistics out of date? Are your indexes fragmented? When was the last time the databases were checked for corruption? Has your SQL Server been tuned to fit your workload, or are you still running with the less optimal default settings?
Tailored to the "Non-DBA", this session will cover these topics and more to ensure that you can avoid some performance issues you may not even realize you're having. Discussing server settings, database configurations, and recommended maintenance, you will leave this session with the knowledge (and scripts!) you need to help ensure that your SQL Server and databases are in top shape.
SessionID: 99777
Checking in on Tabular Models: Making Them Work Better
Event Date: 18-01-2020 - Session time: 11:00:00 - Track: BI Architecture Management
Speaker: Kevin Wilkie
Title: Checking in on Tabular Models: Making Them Work Better
Abstract:
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 a few ways in which I've sped up tabular models to be leaner and faster.
SessionID: 99787
The Future Is Here for Containers!
Event Date: 18-01-2020 - Session time: 11:00:00 - Track: Cloud Database/Application Development Deployment
Speaker: Marsha Pierce
Title: The Future Is Here for Containers!
Abstract:
Demonstrate how to use docker swarm to quickly spin up many containers and persist the same data set to all of the containers. This is what every developer wants. Should your container be on premise or the cloud? Does it matter? Demonstrate how to move a container between on premise and the cloud with data.
SessionID: 100540
What is DevOps and Why Should DBAs Care?
Event Date: 18-01-2020 - Session time: 12:20:00 - Track: Database Adminstration
Speaker: Kathi Kellenberger
Title: What is DevOps and Why Should DBAs Care?
Abstract:
SessionID: 100566
Pure Storage - Lunch Session
Event Date: 18-01-2020 - Session time: 12:20:00 - Track: Other
Speaker: SQLSaturday Nashville
Title: Pure Storage - Lunch Session
Abstract:
hold
SessionID: 101353
Look Smart Save Money - Database Optimization, Consolidation, Capacity Planning w/ SQL Governor
Event Date: 18-01-2020 - Session time: 12:20:00 - Track: Database Adminstration
Speaker: Matt Gordon
Title: Look Smart Save Money - Database Optimization, Consolidation, Capacity Planning w/ SQL Governor
Abstract:
SessionID: 101556
Going Beyond Monitoring With SentryOne
Event Date: 18-01-2020 - Session time: 12:20:00 - Track: Other
Speaker: Andy Yun
Title: Going Beyond Monitoring With SentryOne
Abstract:
Hopefully, you are monitoring your SQL Servers using DIY scripts or a 3rd party tool. Active monitoring is invaluable to enable the operational DBA to identify and address issues quickly. But did you know that SentryOne offers capabilities beyond just monitoring? Join me and I'll show you how SentryOne provides environment wide visibility and aids in managing cross-server activities. I'll showcase how alerting can be tuned to be effective and not noise. And you'll discover how SentryOne can give you both operational and business value to address your application challenges.
SessionID: 101749
SQL Server in "The Cloud": High Availability and Disaster Recover
Event Date: 18-01-2020 - Session time: 12:20:00 - Track: Database Adminstration
Speaker: David Bermingham
Title: SQL Server in "The Cloud": High Availability and Disaster Recover
Abstract:
If you are considering moving your SQL Server instances to "The Cloud" you will need to have a plan in place for both high availability and disaster recovery. In this session, we will examine the three top public cloud providers and what they have to offer in terms of both high availability and disaster recovery. We will discuss where the providers are the same and where the differ. Some real life customer configurations will be presented. Cloud and Datacenter Management MVP Dave Bermingham will lead this session and encourages you to bring your questions specific to your environment.
SessionID: 101794
CozyRoc: Dynamic Data Flows in SSIS Without Programming
Event Date: 18-01-2020 - Session time: 12:20:00 - Track: BI Architecture Management
Speaker: Diane Schuster
Title: CozyRoc: Dynamic Data Flows in SSIS Without Programming
Abstract:
This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime. The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort. Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at run time without the need to change and redeploy the package. Columns and fields are mapped automatically at run time. Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.
SessionID: 102101
Python in SQL Server 2017 and 2019
Event Date: 18-01-2020 - Session time: 13:30:00 - Track: BI Architecture Management
Speaker: Chris Hyde
Title: Python in SQL Server 2017 and 2019
Abstract:
SQL Server 2017 and 2019 have arrived, bringing with them a host of exciting new features. Of particular interest to BI practitioners and data scientists is the integration of the Python programming language into the SQL ecosystem. This integration opens up a number of possibilities for in-database analytics and intelligent database applications, so let's get started! In this introductory session we'll briefly introduce the Python language and then look at how to install and administer Machine Learning Services. We'll start to demonstrate the power of Python by showing you how to create and run simple scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use Python to integrate data analytical methods in real-world situations, and wow your customers with the power of analytics!
SessionID: 98804
An Introduction to Azure Data Studio
Event Date: 18-01-2020 - Session time: 13:30:00 - Track: Database Adminstration
Speaker: Dave Bland
Title: An Introduction to Azure Data Studio
Abstract:
This session will provide a high level overview of Azure Data Studio and highlight some of the differences from SQL Server Management Studio. We cover saved connections, how to get both the actual and estimated Execution plans, workspaces and one of my favorite features, Notebooks. We also go over what an extension is and why I would want to use them.
SessionID: 98821
Applying Visual Design Best Practices in Power BI
Event Date: 18-01-2020 - Session time: 13:30:00 - Track: BI Analytics and Visualization
Speaker: Michael Hewitt
Title: Applying Visual Design Best Practices in Power BI
Abstract:
SessionID: 98882
The Psychology of Better Power BI Reporting
Event Date: 18-01-2020 - Session time: 13:30:00 - Track: BI Analytics and Visualization
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: 99050
Azure Data Services and Data Estate Modernization
Event Date: 18-01-2020 - Session time: 13:30:00 - Track: Cloud Database/Application Development Deployment
Speaker: Nikki Conley
Title: Azure Data Services and Data Estate Modernization
Abstract:
This presentation will cover Overview of Azure Data Strategy, Data modernization on premises, Data modernization to Azure as well and Globally Distributed Data and Cloud Scale Analytics. Attendees will learn about the different options for on premises modernization. After reviewing the option for modernization to Azure, we will cover how to migrate to the cloud using examples from the attendees. Next will be a brief overview of some of the global solutions available. Lastly, we will focus on how to ingest, store, prepare, serve, and report on all the data every company has.
SessionID: 99296
Moving Past Imposter Syndrome
Event Date: 18-01-2020 - Session time: 13:30:00 - Track: Professional Development
Speaker: Wendy Pastrick
Title: Moving Past Imposter Syndrome
Abstract:
We have heard a lot on recognizing Imposter Syndrome and how to address it. However, what if it’s not Imposter Syndrome after all? We will discuss working scenarios and how you approach or deal with them to determine “is it you or is it me?”
SessionID: 99695
Streamline Database Deployments
Event Date: 18-01-2020 - Session time: 13:30:00 - Track: Database Application Development
Speaker: Elizabeth Noble
Title: Streamline Database Deployments
Abstract:
Have you tried implementing source control? How has your continuous integration (CI) process gone?
This session is for developers, database administrators, database engineers, and data architects that want to automate their database deployments. Particularly for those individuals that have hit roadblocks along that way. We will discuss the differences between migration and stated-based deployment methods. We will also discuss options with branching and merging.
At the end of the session, attendees will know how to select the best deployment method for their environment. In addition, attendees will be familiar with branching and merging strategies that can be used as part of their continuous integration strategy.
Attendees should be familiar with general concepts about source control and be comfortable with Visual Studio or VS Code.
SessionID: 99773
Looking "Normal" and Seeing "Stars": Table Designs Working Together
Event Date: 18-01-2020 - Session time: 13:30:00 - Track: Database Application Development
Speaker: Deborah Melkin
Title: Looking "Normal" and Seeing "Stars": Table Designs Working Together
Abstract:
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: 99790
Database People and DevOps: The Fundamentals
Event Date: 18-01-2020 - Session time: 13:30:00 - Track: Database Application Development
Speaker: Stuart Ainsworth
Title: Database People and DevOps: The Fundamentals
Abstract:
DevOps is a software delivery philosophy that focuses on delivering quality, faster. The purpose of this session is to cover some of the basic principles of DevOps and how they apply to database development and administration. Everyone's environment is different, but the strategies discussed within can be translated into basic tactical gains that are easy to implement.
Topics covered include:
- a (VERY) brief history of DevOps
- why DBA's make the best DevOps engineers
- what admins can teach developers, and what developers can teach admins
SessionID: 99813
Learn How to Master DATETIME Functions Like a Boss in 59.5 Minutes or Less
Event Date: 18-01-2020 - Session time: 13:30:00 - Track: Database Application 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?
Do you know the date that Daylight Savings starts in Nashville 4 years from now?
Yup, those were silly questions. However, 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:
When to use DATETIME and DATETIME2 and why.
How do you filter date ranges that will make SQL Server run faster?
How language and date formatting affect EVERYTHING.
What's the best way to work with functions relating to the current date and time.
What's the best way to properly use SWITCHOFFSET, TODATETIMEOFFSET and AT TIME ZONE Functions.
So stop wasting time and get on board because it's about time for the plane to depart.
SessionID: 100569
Azure Data SQL Server: What to Use When
Event Date: 18-01-2020 - Session time: 14:50:00 - Track: Cloud Database/Application Development Deployment
Speaker: Rie Irish
Title: Azure Data SQL Server: What to Use When
Abstract:
In this session, you'll learn about the different options for your SQL deployments in Azure. After this session, you should be able to: ○ Understand the benefits of SQL Server in Azure ○ Articulate the key differentiators between SQL Server on-prem, in Azure VM, in Azure SQL DB (Single database, Elastic Pools, and Managed instance), and hybrid ○ Explain the different service tiers within Azure SQL DB, and evaluate what is best for your workloads and business requirements (Serverless, Hyperscale, General Purpose, Business Critical, etc)
SessionID: 98816
D.R.E.A.M (Data Rules Everything Around Me) - creating a data-driven business culture
Event Date: 18-01-2020 - Session time: 14:50:00 - Track: Professional Development
Speaker: Holly Rachel
Title: D.R.E.A.M (Data Rules Everything Around Me) - creating a data-driven business culture
Abstract:
Deploying a new Big Data initiative is a daunting undertaking in its own right, which can lead many business leaders to forget a crucial piece of the puzzle - changing company culture. What good is new technology if it does not align with the way people in the organization actually make decisions? This session dives into how company leadership can effectively get organization members not just tolerant of, but EXCITED about new technology initiatives.
Attendees will learn:
- Where a data-driven culture really starts
- Why so many companies fail miserably at obtaining the "data-driven culture"
- The single MOST important factor that determines a successful culture shift
SessionID: 98977
Introduction to Azure Streaming Analytics
Event Date: 18-01-2020 - Session time: 14:50:00 - Track: BI Analytics and Visualization
Speaker: Warren Sifre
Title: Introduction to Azure Streaming Analytics
Abstract:
This session will cover what is Streaming Analytics and the various use cases. We will demonstrate the creation of a Streaming Analytics process which will output the data to a dashboard for review. The intention is to provide insights in how this technology can potentially be leveraged by the SQL community.
SessionID: 99077
Event Date: 18-01-2020 - Session time: 14:50:00 - Track: Cloud Database/Application Development Deployment
Speaker: David Maxwell
Abstract:
In this session, we’ll cover three key performance tuning features; Automatic Tuning, Intelligent Insights, and Extended Events. Each of these will be reviewed specifically with a focus on how it applies to Azure SQL Databases. Attendees will learn how to take advantage of each of these features, allowing them to save both time and money, and ensuring that their Azure SQL Databases are performing at their best.
SessionID: 99129
Secrets of the Plan Cache
Event Date: 18-01-2020 - Session time: 14:50:00 - Track: Database Adminstration
Speaker: Peter Shore
Title: Secrets of the Plan Cache
Abstract:
SessionID: 99172
Goin' Fishin' on the Azure Data Lake
Event Date: 18-01-2020 - Session time: 14:50:00 - Track: BI Architecture Management
Speaker: Spencer Swindell
Title: Goin' Fishin' on the Azure Data Lake
Abstract:
SessionID: 99297
Turn Runbooks into Notebooks: Handling Maintenance and Emergencies with Azure Data Studio
Event Date: 18-01-2020 - Session time: 14:50:00 - Track: Database Adminstration
Speaker: Matt Gordon
Title: Turn Runbooks into Notebooks: Handling Maintenance and Emergencies with Azure Data Studio
Abstract:
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.
SessionID: 99574
The Submission of Power BI, albeit Kicking and Screaming.
Event Date: 18-01-2020 - Session time: 14:50:00 - Track: BI Analytics and Visualization
Speaker: Sarah Whitworth
Title: The Submission of Power BI, albeit Kicking and Screaming.
Abstract:
SessionID: 99771
Improve Your SSIS Deployments from 10 Minutes to 30 Seconds
Event Date: 18-01-2020 - Session time: 14:50:00 - Track: Powershell
Speaker: Michael McKinley
Title: Improve Your SSIS Deployments from 10 Minutes to 30 Seconds
Abstract:
Tired of remote desktopping into your server, copying over package assets, and manually deploying your SSIS updates? Come learn how you can use PowerShell to deploy packages from anywhere in just seconds, securely. In this course, we will look at a particular PowerShell use case, the code and best practices to make it work successfully enterprise-wide, how you can leverage PowerShell in other ways, and why you might want to use it to become a more efficient DBA.
Best practices include:
- Separating PowerShell creation responsibilities between DBAs and Developer community.
- Incorporating script into source control system.
- Enhancing security while utilizing remote deployment.
SessionID: 99812
PowerShell for the DBA
Event Date: 18-01-2020 - Session time: 14:50:00 - Track: Database Adminstration
Speaker: Amy Herold
Title: PowerShell for the DBA
Abstract:
In this session we will explore real-world examples and demonstrate how PowerShell can be leveraged by the DBA to not only improve efficiency but also streamline processes across an enterprise environment.