| Session Date/Time (dd-MM-YYYY 24h) | Speaker | Category | Track | Title |
|---|---|---|---|---|
| 25-04-2018 12:00 | Michael Otey | 24 Hours of PASS (60 minutes) | Database Administration and Development | The Windows DBA’s Jump Start for SQL Server on Linux |
| 25-04-2018 13:00 | Phil Ekins | 24 Hours of PASS (60 minutes) | Database Administration and Development | SQL Sprawl - Get a Handle on Your Infrastructure |
| 25-04-2018 14:00 | Manikantan Madhunapantula | 24 Hours of PASS (60 minutes) | Database Administration and Development | SQL Server Management - Taming Infrastructure and Application Usage |
| 25-04-2018 15:00 | Jesus Gil | 24 Hours of PASS (60 minutes) | Database Administration and Development | SQL Server 2017 on Linux |
| 25-04-2018 16:00 | Dustin Ryan | 24 Hours of PASS (60 minutes) | Database Administration and Development | Monitoring and Tuning Azure SQL Database |
| 25-04-2018 17:00 | Julie Lerman | 24 Hours of PASS (60 minutes) | Database Administration and Development | SQL Server Containers for Developers |
| 25-04-2018 18:00 | Kellyn Pot'Vin-Gorman | 24 Hours of PASS (60 minutes) | Database Administration and Development | Essential Linux for the DBA |
| 25-04-2018 19:00 | Joseph D'Antoni | 24 Hours of PASS (60 minutes) | Database Administration and Development | Pods, Containers, and SQL Server--What You Need to Know |
| 25-04-2018 20:00 | Kellyn Pot'Vin-Gorman | 24 Hours of PASS (60 minutes) | Database Administration and Development | Advanced Tools for the Linux DBA |
| 25-04-2018 21:00 | Swagatika Sarangi | 24 Hours of PASS (60 minutes) | Business Intelligence and Data Warehousing | Power BI for Master Data Management |
| 25-04-2018 22:00 | Stan Geiger | 24 Hours of PASS (60 minutes) | Database Administration and Development | Microsoft Business Intelligence on Linux |
| 25-04-2018 23:00 | Paul Turley | 24 Hours of PASS (60 minutes) | Business Intelligence and Data Warehousing | Nine Realms of Power BI |
| 26-04-2018 00:00 | Andrew Nakamura | 24 Hours of PASS (60 minutes) | Database Administration and Development | Goldilocks and The Three Linux Bears |
| 26-04-2018 01:00 | Bradley Ball | 24 Hours of PASS (60 minutes) | Database Administration and Development | SQL Server & Containers |
| 26-04-2018 02:00 | Swagatika Sarangi | 24 Hours of PASS (60 minutes) | Business Intelligence and Data Warehousing | Master Data Management Metrics |
| 26-04-2018 03:00 | Michael Otey | 24 Hours of PASS (60 minutes) | Database Administration and Development | What you Need to Know about SQL Server and Docker Containers |
| 26-04-2018 04:00 | Guy Glantser | 24 Hours of PASS (60 minutes) | Database Administration and Development | Monitoring Page Splits in SQL Server |
| 26-04-2018 05:00 | Marko Hotti | 24 Hours of PASS (60 minutes) | Database Administration and Development | Modernizing Mission-Critical Apps with SQL Server 2017 on Windows, Linux and Docker Containers |
| 26-04-2018 06:00 | Marek Maśko | 24 Hours of PASS (60 minutes) | Database Administration and Development | SQL Operations Studio – a New Multi-Platform tool for SQL Server Database Development, Administration, and Monitoring |
| 26-04-2018 07:00 | Marko Hotti | 24 Hours of PASS (60 minutes) | Database Administration and Development | SQL Server on Linux and Docker |
| 26-04-2018 08:00 | Hamid J. Fard | 24 Hours of PASS (60 minutes) | Database Administration and Development | How to Manage SQL Server Farm (Cross-Platforms) via SSMS? |
| 26-04-2018 09:00 | Lord Richard Douglas | 24 Hours of PASS (60 minutes) | Database Administration and Development | Investigate TempDB like Sherlock Holmes |
| 26-04-2018 10:00 | Andrew Pruski | 24 Hours of PASS (60 minutes) | Database Administration and Development | Manage SQL Server in Linux Containers using dbatools |
| 26-04-2018 11:00 | Martin Wild | 24 Hours of PASS (60 minutes) | Database Administration and Development | Lifting the Lid on SQL Server on Linux |
Event Date: 25-04-2018 12:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 25-04-2018 13:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 25-04-2018 14:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
the data needed to monitor SQL server instances. Use T-SQL, Powershell, and R to do aggregation, trend analysis and exposing this data to developers so that they can tune their application and understand how their application has been doing in terms of database load.
Event Date: 25-04-2018 15:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 25-04-2018 16:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 25-04-2018 17:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 25-04-2018 18:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
This session is taught by a multi-platform DBA who specializes in Oracle and SQL Server with almost two decades on Unix/Linux experience. The goal is to give you the most valuable fundamentals and commands that are important to the DBA when managing a database in a Non-Windows environment. We’ll learn:
You’ll leave feeling more at ease with Linux and have plenty of content and links to continue the learning after the session!
Event Date: 25-04-2018 19:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
--The benefits of flexibility of containers --How containers work, and how they are different from virtual machines --How SQL Server works with containers --How to get started with containers in your test environment
Join us for a demo filled session to learn about the future of infrastructure.
Event Date: 25-04-2018 20:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
We’ll cover cool commands and utilities that will ease management and navigation of a Linux system. Discovery utilities that grant powerful monitoring and performance of the environment. You’re only as good as the OS your database resides on and if you can’t get the information you need, you’re lost.
Key takeaways are:
Little known commands that provide great value.
Monitoring tools, inside and out
Utilities, including package and usage information.
Tracing- the good, the bad and the easy.
Event Date: 25-04-2018 21:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing
Integrating Master Data Services with Power BI, and presenting analytics on top only Master Data, can provide a high-end leverage to your organization. Whether it is a location model, a product model, a customer model etc., executives can highly be insightful from a report that contains all master data domains consolidated with a better visualization. Using individual subscription views from Master Data Services(SQL Server 2017) in Power Query, and utilizing all the cross referenced entities across models in MDS – can lead to a great one page report via Power BI.
Event Date: 25-04-2018 22:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 25-04-2018 23:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing
From simple desktop & published reports, to enterprise-scale and highly-secured solutions; we will demystify all these options & provide a roadmap to conquer the Nine Realms; from Midgard to Asgard, and from Desktop to Power BI Avenger.
Event Date: 26-04-2018 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
and fascinating place. Learning something new can be just like her experience. Sometimes it's too hard with too many commands to memorize at the command prompt. Other times, too easy, wasting our precious brain cells on topics we already have mastered. Then we stumble on a rare moment when things are just right. Have you ever had that golden moment?
In this session, we will focus on creating a VM Linux server to install SQL 2017 and connect to it using SQL Operations Manager and Visual Studio Code. We'll briefly meet Papa bear and talk about pre-installation steps in Hyper-V before installing a Linux server. We'll see by Mama bear by going over topics like repositories and package management. Then we will get it just right by installing SQL Server, SQL Operations Manager and Visual Studio Code on a Linux desktop taking those baby steps learning something new.
Attend this session to get the bear facts with starting your Goldilocks journey with SQL on Linux.
Event Date: 26-04-2018 01:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 26-04-2018 02:00 - Category: 24 Hours of PASS (60 minutes) - Track: Business Intelligence and Data Warehousing
Event Date: 26-04-2018 03:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 26-04-2018 04:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
In this session we are going to demonstrate all the possible options to monitor page splits in SQL Server, and we are going to show that all of these options are wrong. SQL Server is lying, and we're going to prove it. We will then demonstrate the only (documented) method to correctly monitor page splits in SQL Server as of today.
Event Date: 26-04-2018 05:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 26-04-2018 06:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
In this session, Marek Masko will take you on a journey through the SQLOps GUI and present main SQL Operation Studio features. He will explain how dashboards work and what you can do with them. You will learn how to use it to perform your usual daily tasks such as:
Connecting to databases, running queries, reviewing and exporting results;
Developing complex T-SQL code using new functionalities;
Performing various kinds of administrative tasks;
In addition to this, Marek will show you built-in monitoring functionalities, as well as easy to create widgets giving you amazing application extensibility.
Event Date: 26-04-2018 07:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 26-04-2018 08:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Event Date: 26-04-2018 09:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
After this session, you will have learned how to architect TempDB for better performance, how to create code more efficiently for TempDB, understand how space is utilized within TempDB, and have learned about queries and counters that will help diagnose where your bottlenecks are coming from.
Event Date: 26-04-2018 10:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Attendees will be taken through the following:
Event Date: 26-04-2018 11:00 - Category: 24 Hours of PASS (60 minutes) - Track: Database Administration and Development
Once the stage is set, Martin will cover tuning and performance on Linux and bring you through some new DMVs for Linux monitoring. He’ll then compare the plans produced on Linux vs. Windows for consistency… or not! To round out the webcast, get ready for a side-by-side benchmark session of workloads running on Windows and Linux. Martin will also show you some Quest tools, including monitoring and diagnostics solutions, along with some cool free tuning tools.