| Start Time (24h) | Speaker | Track | Title |
|---|---|---|---|
| 08:30:00 | John Miner | Data Science | Extend Power BI with Python |
| 08:30:00 | Alex Grinberg | Database Development | Advanced T-SQL Development with latest features. |
| 08:30:00 | Mike Walsh | Data Security | 4 Threats to your SQL Servers - Become Default: Secure |
| 08:30:00 | Matt Cushing | Professional/Personal Development | Networking 101: Getting Ready for a SQL Event |
| 08:30:00 | Paul Stanton | Database Development | SQL DevOps Simplified with Production Databases |
| 08:30:00 | Andy Yun | Database Development | Let's Dive Into SQL Server I/O To Improve T-SQL Performance |
| 08:30:00 | Bryan Cafferky | Data Science | Azure Databricks = Azure + Spark + Machine Learning Collaboration |
| 10:00:00 | Alex Grinberg | Database Administration | XML and JSON, does the DBA need it? |
| 10:00:00 | Steve Simon | Business Intelligence | SQL Server Reporting Services 2017 on Steroids!! |
| 10:00:00 | Christian Cote | Big Data | Feeding the modern data warehouse (Power BI, Azure Data Factory and Databricks) |
| 10:00:00 | John Wells | Database Development | Fundamentals That Will Improve Your Query Performance! |
| 10:00:00 | Elizabeth Noble | Database Development | Overcoming Challenges with Source Control and Continuous Integration. |
| 10:00:00 | Deborah Melkin | Data Architecture Design | Looking "Normal" and Seeing "Stars": Table Designs Working Together |
| 10:00:00 | Bryan Cafferky | Business Intelligence | Python with SQL: A Winning Combination |
| 12:30:00 | Kevin Feasel | Database Development | Approaching Zero: Minimizing Downtime During Deployments |
| 12:30:00 | Thomas Grohser | Professional/Personal Development | Why candidates fail the job interview in the first minute |
| 12:30:00 | Taiob Ali | Cloud Application Development Deployment | Performance Optimization with Azure SQL Database |
| 12:30:00 | Kathi Kellenberger | Data Science | Azure Machine Learning 101 |
| 12:30:00 | Michelle Gutzait | Optimization/Tuning | Top 10 FREE performance troubleshooting tools for SQL Server |
| 12:30:00 | Paresh Motiwala | Database Administration | Moving to SQL 2019- A primer for the unaware! |
| 14:00:00 | Greg Moore | Database Development | Pocket-sized Server: SQL Server for under $200! |
| 14:00:00 | Guy Glantser | Database Development | The Complete Guide to Temporary Tables and Table Variables |
| 14:00:00 | Rayis Imayev | Business Intelligence | Power BI with Maps: Choose Your Destination |
| 14:00:00 | Kathi Kellenberger | Database Administration | What is DevOps and Why Should DBAs Care? |
| 14:00:00 | Liz Amador | Analytics and Visualization | Designing Accessible Power BI Reports |
| 14:00:00 | Andy Levy | Database Administration | dbatools for the Uninitiated |
| 14:00:00 | Paresh Motiwala | Lightning Talks | Lightning Talks |
| 15:30:00 | Ray Kim | Professional/Personal Development | Blogging for Success: Advancing your career by blogging |
| 15:30:00 | John Miner | Cloud Application Development Deployment | Staging data for Azure SQL services |
| 15:30:00 | Sunil Kadimdiwan | Business Intelligence | Add Time Intelligence to Power BI |
| 15:30:00 | Mohamed Mawla | Cloud Application Development Deployment | From Zero to Hero: Start Machine Learning using Azure ML studio |
| 15:30:00 | Deji Akomolafe | Cloud Application Development Deployment | Successfully Virtualizing SQL Server on vSphere - Straight from the Source |
| 15:30:00 | Guy Glantser | Panel | Ask the Experts Panel |
Event Date: 20-07-2019 - Session time: 08:30:00 - Track: Data Science
Out of the box, Power BI has 29 visuals. There are 208 custom visuals that can be down loaded from Appsource.Microsoft.com.
While there are many choices, the business problem might not have an out of the box visual that can be customized the way you want. How do you solve this problem?
This is where the custom scripting with Python visual comes in.
At the end of the presentation you will know which libraries that you can use to extend your toolbox for both on premise and the azure service.
Event Date: 20-07-2019 - Session time: 08:30:00 - Track: Database Development
Event Date: 20-07-2019 - Session time: 08:30:00 - Track: Data Security
In this session, we'll explore 4 types of active threats to your data and organization. We'll talk about the various solutions available and help you see which threats you are vulnerable to if you've not gone far enough as we match threats and answers. Sadly, we'll share real stories of folks who've lost it all from these threats.
It's more than "take your backups, verify them, and periodically test them!" Ransomware and malicious outsiders (or insiders) eat your online backups for breakfast.
Leave prepared, not scared, as you adopt a "Default: Secure" posture and lead the charge, even if we are "only" DBAs.
Event Date: 20-07-2019 - Session time: 08:30:00 - Track: Professional/Personal Development
In this session, we'll go over steps you can take before, during and after the event to maximize the amount of great stuff you'll take away at the end (besides cool vendor swag). Not just keeping up on new technologies, but meeting new people, getting leads on solutions/opportunities, and an appreciation for the community you're in and what it has to offer.
Event Date: 20-07-2019 - Session time: 08:30:00 - Track: Database Development
Event Date: 20-07-2019 - Session time: 08:30:00 - Track: Database Development
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.
Event Date: 20-07-2019 - Session time: 08:30:00 - Track: Data Science
Event Date: 20-07-2019 - Session time: 10:00:00 - Track: Database Administration
Event Date: 20-07-2019 - Session time: 10:00:00 - Track: Business Intelligence
In this hands on presentation we shall be looking some of the more challenging techniques of extracting our data from our Multidimensional and Tabular Models, in addition to our Data Mining Models. We shall be utilizing concepts of ‘Openquery()’ and ‘linked servers’ as a means to extract data, in addition to looking at the way that these two concepts can help us extract our data utilizing MDX, DMX and DAX expressions; AND YET maintain the flexibility and the ability to utilize all those wonderful techniques that may be done with T-SQL.
Event Date: 20-07-2019 - Session time: 10:00:00 - Track: Big Data
Event Date: 20-07-2019 - Session time: 10:00:00 - Track: Database Development
Event Date: 20-07-2019 - Session time: 10:00:00 - Track: Database Development
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.
Event Date: 20-07-2019 - Session time: 10:00:00 - Track: Data Architecture Design
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.
Event Date: 20-07-2019 - Session time: 10:00:00 - Track: Business Intelligence
Event Date: 20-07-2019 - Session time: 12:30:00 - Track: Database Development
Event Date: 20-07-2019 - Session time: 12:30:00 - Track: Professional/Personal Development
Thomas will share what he misses in resumes and how to respond to questions better.
Event Date: 20-07-2019 - Session time: 12:30:00 - Track: Cloud Application Development Deployment
In this session I will show you 4 of those tools. You will learn how these tools can provide Performance overview of a database and recommendations that can improve workload performance. Find top resource consuming queries, deeper insight into your databases resource (DTU) consumption and learn when to let Azure automatically optimize your database. At the end of this session you will walk out knowing how to identify and tune Azure SQL database performance issues with built in tools in Azure Portal.
Event Date: 20-07-2019 - Session time: 12:30:00 - Track: Data Science
Microsoft addresses those problems with Azure Machine Learning, or Azure ML. Azure ML has built-in transforms for cleansing and munging data. It also contains a variety of configurable machine learning models that can be used without coding. Deploying the model is easy, and users can link to it directly with Excel or a custom application can be written.
If you are experienced in machine learning but haven’t seen Azure ML or if you are curious about machine learning and data science, this session is for you.
Event Date: 20-07-2019 - Session time: 12:30:00 - Track: Optimization/Tuning
Event Date: 20-07-2019 - Session time: 12:30:00 - Track: Database Administration
Event Date: 20-07-2019 - Session time: 14:00:00 - Track: Database Development
At the other end of the spectrum there's an amazing amount of power available in very small form-factors. This session will explore what can be done with cheap off the shelf "computers on a board" form factors and Linux to build cheap and easy to deploy small SQL solutions that can be useful for a variety of data collection activities.
Event Date: 20-07-2019 - Session time: 14:00:00 - Track: Database Development
The main difference in terms of performance is statistics, which exist for a temporary table, but do not exist for a table variable. For that reason, there can be a huge difference in performance of a stored procedure that uses one data structure or the other. In this session, we will demonstrate the differences and analyze performance for various use cases. We will cover all kinds of ways to work with these data structures, such as OPTION (RECOMPILE) and trace flag 2453. By the end of this session you will know exactly when and how to use each one in order to achieve the desired functionality with the best performance. This is a must session for every SQL Server developer.
Event Date: 20-07-2019 - Session time: 14:00:00 - Track: Business Intelligence
Power BI itself a great tool that could feed your appetite for an adventure using built-in and custom map visualizations. Let's explore them!
Event Date: 20-07-2019 - Session time: 14:00:00 - Track: Database Administration
Attend this session to learn how DevOps is changing the DBAs world for the better.
Event Date: 20-07-2019 - Session time: 14:00:00 - Track: Analytics and Visualization
Event Date: 20-07-2019 - Session time: 14:00:00 - Track: Database Administration
The department just decided to reorganize and consolidate databases to prepare for an upgrade to the next release of SQL Server. How are you going to manage all this?
It's time to automate with the dbatools Powershell module. We’ll briefly talk about the project itself, then take a tour of functions commonly used to manage SQL Server environments and data. When you leave, you’ll be ready to level up your administration toolkit and start reducing your daily workload.
Event Date: 20-07-2019 - Session time: 14:00:00 - Track: Lightning Talks
Paresh Motiwala: Use of three free MS tools for DB migration Taiob Ali: Extended Events - How to collect the first 10 or every 4th event Andy Yun: SQL Server Performance Troubleshooting: Bottom to Top... or Top to Bottom? Ray Kim: Business Cards: The most important networking tool! Michelle Guzait: How to be a rockstar resolving almost any SQL Server emergency issue. Deborah Melkin: The Solution Isn't the Problem Bryan Cafferky: Azure Machine Learning service and why the s is lower case
Event Date: 20-07-2019 - Session time: 15:30:00 - Track: Professional/Personal Development
In this presentation, I'll tell you how I got started with 'blogging, where it's taken me since then, and lessons I've learned along the way. We'll discuss 'blog platforms, how to get started, what to write about, and what to do (and what NOT to do) when writing articles.
Event Date: 20-07-2019 - Session time: 15:30:00 - Track: Cloud Application Development Deployment
Schema on write is represented by the traditional relational database table. Only a small portion of the total data owned by the company resides in the database.
Schema on read is represented by technologies such as Hadoop or PolyBase. All data owned by the company can reside in simple storage.
Today, we will learn how to stage data using Azure blob storage which can be ingested by both techniques.
1 – Grab some big data. 2 – Create blob storage account. 3 – Copy data to container. 4 – Azure SQL database plumbing. 5 – Loading data with BULK INSERT. 6 – Azure SQL data warehouse plumbing. 7 – Loading data with POLYBASE. 8 – Azure automation with RUNBOOKS.
Event Date: 20-07-2019 - Session time: 15:30:00 - Track: Business Intelligence
In this session you will learn how to use and apply DAX functions in Power BI, to develop Time and Date based dimensions and measures that will help answer such questions.
Event Date: 20-07-2019 - Session time: 15:30:00 - Track: Cloud Application Development Deployment
We will explore ML Azure offering, Some ML concepts, ML Studio, create an experiment from Scratch and show how ML can target common business challenges like demand projection or price targeting
Lots of hands-on
Event Date: 20-07-2019 - Session time: 15:30:00 - Track: Cloud Application Development Deployment
Event Date: 20-07-2019 - Session time: 15:30:00 - Track: Panel
Ask the Experts is an opportunity to find answers and resources to address ongoing challenges, learn more about our speakers, and maybe stump them : )