Start Time (24h) | Speaker | Track | Title |
---|---|---|---|
08:30:00 | Adam Anderson | Application Database Development | Environment Setup using automation tools like Docker, Powershell and Chocolatey |
08:30:00 | Phil Robinson | Analytics and Visualization | Data Preparation with Power BI Desktop M – Strategy, Tactics and Tips |
08:30:00 | Michael Wall | Strategy and Architecture | Azure Lift and Shift Best Practices |
08:30:00 | Angel Abundez | BI Platform Architecture, Development Administration | Automating Power BI Creations |
08:30:00 | Mitchell Bottel | Enterprise Database Administration Deployment | Tips, Tricks and Secrets for the SQL Professional |
09:45:00 | Brent Ozar | Enterprise Database Administration Deployment | What to Do When SQL Server is Unusually Slow |
09:45:00 | Armando Lacerda | Application Database Development | CosmosDB - Understanding the main factors for successful deployment |
09:45:00 | Hasan Savran | Analytics and Visualization | How to use GeoSpatial Data in SQL Server |
09:45:00 | Angel Abundez | BI Platform Architecture, Development Administration | Monitor Power BI |
09:45:00 | John Morehouse | Application Database Development | Temporal Tables – The New Hotness in Data Auditing |
11:00:00 | Armando Lacerda | BI Platform Architecture, Development Administration | Making Sense of the Power BI Ecosystem |
11:00:00 | Jeff Mlakar | Enterprise Database Administration Deployment | Environmental SQL Server Troubleshooting |
11:00:00 | Ted Stathakis | BI Platform Architecture, Development Administration | Reporting Services: A Smart Migration Strategy |
11:00:00 | Eric Courville | Cloud Application Development Deployment | Moving Databases to the cloud |
11:00:00 | Eric Freeman | Application Database Development | Improving the Performance of Functions |
12:15:00 | SQLSatSac Sponsor | Other | Snowflake: The Future of Data Warehousing (Zach Oxman Gabe Mullen) |
12:15:00 | SQLSatSac Sponsor | Other | SentryOne: Beyond Monitoring with SentryOne (Alec Pickup) |
13:30:00 | Ami Levin | Application Database Development | One key to rule them all - how to effectively destroy data consistency, and ruin query performance |
13:30:00 | Jeff Mlakar | Enterprise Database Administration Deployment | Database Corruption! Preventing Disaster to your Database. |
13:30:00 | Linda Groszyk | Professional Development | Breaking the Social Code: How to be Socially Intelligent at Work |
13:30:00 | John Morehouse | Enterprise Database Administration Deployment | Data Encryption for DBAs |
13:30:00 | Dan Hess | Other | Lightning Talks 1: Dan Hess, Dilip Nayak, Saru Radhakrishnan |
14:45:00 | Paul Stanton | Cloud Application Development Deployment | SQL DevOps Simplified with Production Databases |
14:45:00 | Hasan Savran | Cloud Application Development Deployment | Cosmos DB was the missing piece to my Data puzzle! |
14:45:00 | Reinhard Flügel | Application Database Development | Possibilities Limitations of System-Versioned Temporal Tables |
14:45:00 | Michael Wall | Enterprise Database Administration Deployment | PoSh on SSRS - Essential Skills to manage your RS with PowerShell |
14:45:00 | Ted Stathakis | Other | Lightning Talks 2: Ted Stathakis, Glenn Burnett, Alex Purice |
16:00:00 | Adam Anderson | Application Database Development | Database Testing |
16:00:00 | Robert Muir | Application Database Development | SQL Query 101 |
16:00:00 | Soumya Banerjee | BI Platform Architecture, Development Administration | A dive into Dimensional Modeling |
16:00:00 | Ami Levin | Strategy and Architecture | Big Data, Big Dupe: A little session about a big bunch of nonsense. |
16:00:00 | Christian Chanco | Analytics and Visualization | How to Query the Tabular Data Model using DAX |
Event Date: 17-08-2019 - Session time: 08:30:00 - Track: Application Database Development
This three tiered environment setup can work with or without Docker. In this session we will also cover using Chocolatey NuGet's, which sounds tasty, but it is also a very powerful method of installing software on Windows.
Event Date: 17-08-2019 - Session time: 08:30:00 - Track: Analytics and Visualization
In this presentation we will review traditional strategies for data cleanup, explore Power BI Desktop features for data exploration and look at Power BI Desktop configuration tips. Building readable, reusable and shareable cleanup scripts in M using the Power Query Advanced Editor will also be covered.
Event Date: 17-08-2019 - Session time: 08:30:00 - Track: Strategy and Architecture
Note, this session will exclusively deal with issues on a hybrid VM running SQL Server in Azure. We may cover general issues that affect SQL Azure instances such as storage issues.
Event Date: 17-08-2019 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration
Angel Abundez will present a wide-ranging overview of the data refresh setups common to Power BI data sources, going from DIY to more advanced scenarios that need IT support. Whether you’re automating reports for your department or for the enterprise, there’s something here for you.
You'll learn how to:
Set up your datasets in Excel and Power BI to be automated
Refresh data from files hosted on SharePoint, One Drive, and REST APIs (CSV, Excel, JSON, etc)
Pull data from on-premises and cloud data sources using the latest capabilities of Power Apps, the Power BI Service, and Azure
Automate your Power BI analysis in PowerBI.com, One Drive, or even your O365 mailbox
Work with cloud databases such as Amazon Redshift, Azure SQL DB, and Snowflake
Event Date: 17-08-2019 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 17-08-2019 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment
There’s gotta be a better way, right?
Good news – there is, and you’re about to learn how the pros do it. In one all-demo session, you’ll watch Brent Ozar use sp_WhoIsActive, sp_BlitzFirst, and sp_BlitzCache to solve several common emergencies. You’ll walk away with a written checklist to solve typical performance emergencies.
Event Date: 17-08-2019 - Session time: 09:45:00 - Track: Application Database Development
In this session packed with demos you will see how to cross the bridge between SQL Server and Cosmos DB back and forth; how to related items from both sides and what is required to design a CosmosDB deployment.
Event Date: 17-08-2019 - Session time: 09:45:00 - Track: Analytics and Visualization
I will introduce you to Spatial Data in the SQL server and show how to import data into SQL Server. We will focus on demonstrations of the SQL Server 2016 and JSON functions used to create geoJSON objects from Spatial Data. Next we will cache these objects by using In-Memory tables with the help of SQL Server 2017.
Event Date: 17-08-2019 - Session time: 09:45:00 - Track: BI Platform Architecture, Development Administration
By monitoring, you will truly understand what makes you an Administrator of Power BI. You'll see the different screens it takes to monitor everything in your tenant. Plus, you'll discover if there's a better way to monitor your tenant through collecting API data and analyzing it to derive some actionable insights for improved data governance in your companies.
BI expert Angel Abundez will demo the Power BI administrative screens you use today to monitor your tenant. Then he'll do some PowerShell development in VS Code to collect API data and see if it's possible to use that data in Power BI for added insights.
Event Date: 17-08-2019 - Session time: 09:45:00 - Track: Application Database Development
Event Date: 17-08-2019 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 17-08-2019 - Session time: 11:00:00 - Track: Enterprise Database Administration Deployment
In this session we will discuss both performance pitfalls and optimizations that can be made to the system outside of code changes. We will diagnose configurations commonly misapplied and review best practices in SQL Server, Windows Server, and VMware!
Event Date: 17-08-2019 - Session time: 11:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 17-08-2019 - Session time: 11:00:00 - Track: Cloud Application Development Deployment
Event Date: 17-08-2019 - Session time: 11:00:00 - Track: Application Database Development
Event Date: 17-08-2019 - Session time: 12:15:00 - Track: Other
Event Date: 17-08-2019 - Session time: 12:15:00 - Track: Other
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.
Alec Pickup
Event Date: 17-08-2019 - Session time: 13:30:00 - Track: Application Database Development
If I told you that these keys that you take for granted, are the primary factor that destroy your database's consistency, performance, scalability, and modularity, you'd probably think I'm crazy. But what if I can prove it, scientifically, and beyond any reasonable doubt? "It ain't what you don't know that gets you into trouble. It's what you know that just ain't so..." Join me on this fascinating journey down the rabbit hole, where we will shed new light on some of the most fundamental aspects of database design. You will experience hands-on how you can drastically improve your database consistency, simplify your queries, improve performance by orders of magnitude, allow for unprecedented scalability, and modularity. Prepare for a paradigm shift. By the end of this session, you will chant with me: "The key, the whole key, and nothing but the key, so help me Codd".
Event Date: 17-08-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
In this presentation we will explore database corruption, learn how to diagnose, and see what we can do to fix it. We will discuss the causes, dispel some myths, and learn what questions to ask. After this, we dive into discovering the root cause and putting a plan in place to stop it in the future. Demos will illustrate diagnosing, troubleshooting, and fixing database corruption. Prepare to break a database and go through the steps to return it back to a usable state.
Beginners will benefit along with others who may one day find themselves with a corrupt database. By the end of the session, you will have the tools and understanding necessary to take corrective action and prevent your databases from corruption!
Event Date: 17-08-2019 - Session time: 13:30:00 - Track: Professional Development
If you answered yes to any of these questions, then this session is for you! For many people, “social” does not come naturally and has to be explicitly taught. In this presentation, you will learn about the mindset that is required for developing new competencies, key cognitive skills needed for social success, and tools and strategies that you can use immediately with your team. This session is for people who have difficulty navigating the social world, as well as for their managers.
Event Date: 17-08-2019 - Session time: 13:30:00 - Track: Enterprise Database Administration Deployment
Event Date: 17-08-2019 - Session time: 13:30:00 - Track: Other
Dilip Nayak: Use Cases for Availability Groups Saru Radhakrishnan: Set Operations Using Inline Table-Valued Functions
Event Date: 17-08-2019 - Session time: 14:45:00 - Track: Cloud Application Development Deployment
Event Date: 17-08-2019 - Session time: 14:45:00 - Track: Cloud Application Development Deployment
Join me to see Cosmos DB in action with many demos! Don't miss it.
Event Date: 17-08-2019 - Session time: 14:45:00 - Track: Application Database Development
Event Date: 17-08-2019 - Session time: 14:45:00 - Track: Enterprise Database Administration Deployment
Event Date: 17-08-2019 - Session time: 14:45:00 - Track: Other
Glenn Burnett: Monitoring Failed Queries in SQL Server Alex Purice: SQL Server Replication 101
Event Date: 17-08-2019 - Session time: 16:00:00 - Track: Application Database Development
Event Date: 17-08-2019 - Session time: 16:00:00 - Track: Application Database Development
Event Date: 17-08-2019 - Session time: 16:00:00 - Track: BI Platform Architecture, Development Administration
Event Date: 17-08-2019 - Session time: 16:00:00 - Track: Strategy and Architecture
For over a decade, Big Data has managed to delude far too many smart, honest, hard-working data practitioners, with nothing but the best intentions. This session is a plea for your common sense and decency. Together, we will use history, facts, authority, and logic to expose it for what it really is. Layer by layer, we will peel off the Confusion, Illusion, Deception, Distraction and the Regression that is "Big Data". You will realize just how much progress and value Big Data has bestowed on us over the past decade. But more importantly, we will see what we can and must do to make data practice, and consequently the world, a better place. Brace yourself for a thought-provoking session, filled with "Aha" moments. I promise that after this session, you will never look at big data the same way as you did before you stepped into the room.
Event Date: 17-08-2019 - Session time: 16:00:00 - Track: Analytics and Visualization