Loading…

Log in to bookmark your favorites and sync them to your phone or calendar.

Data Platform & BI [clear filter]
Tuesday, May 21
 

10:00

SQL Injection: How it Works, How to Stop It
This session will explain and demonstrate exactly how a SQL Injection attack occurs. While the core vulnerability is easy to understand, exactly how hackers exploit that vulnerability is not. I'll show you how a hacker explores your database through SQL Injection to find vulnerabilities and sensitive data. Better still, I'll show you the errors that this exploration generates as a mechanism for monitoring your systems to find SQL Injection attacks. Finally, I'll show you the steps you should be taking to properly secure your systems in order to completely avoid SQL Injection attacks.

Speakers
avatar for Grant Fritchey

Grant Fritchey

Redgate Software
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk... Read More →


Tuesday May 21, 2019 10:00 - 11:00
Room 6

11:30

SQL Server Tuning: Is It a Server Problem or a Code Problem?
Your users are complaining that your SQL Server is slow - but is it a database problem, or not enough hardware? It's confusing because the developers always blame the sysadmins, and the sysadmins always blame the developers.

In one hour, you'll learn:

* The 3 metrics to monitor on every SQL Server: Batch Req/Sec, Data Size, and Wait Time Ratio
* Common hardware sizes for different ranges of metrics
* Whether more hardware can pay off for certain kinds of metrics
* Easy-to-read signs that there really is a code problem that hardware won't fix

The session will be relevant for SQL Server in virtualization, bare metal, cloud VMs, and even Azure SQL DB.

Speakers
avatar for Brent Ozar

Brent Ozar

Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz® and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com. He holds a bunch of certifications and awards including the rare Microsoft Certified Master.


Tuesday May 21, 2019 11:30 - 12:30
Room 9

13:45

Run Query Run - Simple Tricks to Run Queries Faster
Every single DBA and Developers have spent countless hours learning about how to tune queries. However, there are quite a few new DBAs and Developers in the last 10 years often wonder how they can get started with SQL SQL Server Performance Tuning, so they can be as proficient as experienced DBAs.
In this session, we will see how we can learn to various tricks derived from SQL Server which can help us run our queries faster. We will focus on new features introduced in SQL Server 2017 on-premises and Azure to tune our queries so they can run faster. 
After all, don't we all want to run our queries at flash speed!

Speakers
avatar for Pinal Dave

Pinal Dave

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4100 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years... Read More →


Tuesday May 21, 2019 13:45 - 14:45
Room 7

13:45

What Power BI users need to know about R
You’ve probably already seen that R icon in the Power BI GUI. It shows up when creating sources, transformations and reports. But the ugly textbox you got when you clicked upon those icons didn’t encourage you to proceed? In this session, you will learn just a few basic things about R that will greatly extend your Power BI data loading, transformation and reporting skills in Power BI Desktop and the Power BI service.



Speakers
avatar for Nico Jacobs

Nico Jacobs

Dr. Nico Jacobs is a Microsoft Business Intelligence and SQL Server trainer and consultant at U2U since 2004. Before that, he was a machine learning (data mining) researcher at the computer science department of the University of Leuven where he obtained a PhD in machine learning.At... Read More →


Tuesday May 21, 2019 13:45 - 14:45
Room 11

15:00

A Business and Technical Roadmap for Getting Started with Artificial Intelligence
Organisations need to know how to get started with Artificial Intelligence. This practical session offers organizations, small and large, with a helping hand in practical advice and demos using Microsoft Azure with Open Source technologies. For organizations who have no clue what they'd use AI for, the session will offer a practical framework: the Five 'C's of Artificial Intelligence, which is a framework to help you get started.
In order to provide a technical focus in getting started, R and Python will be shown in AzureML and Microsoft ML Server.

Speakers
avatar for Jennifer Stirrup

Jennifer Stirrup

Jen Stirrup is a data strategist and technologist, Microsoft Most Valuable Professional (MVP) and Microsoft Regional Director, founder of Data Relish Ltd, SQLFamily and community advocate, public speaker and blogger, published author and keynote speaker. Jen is the founder of a boutique... Read More →


Tuesday May 21, 2019 15:00 - 16:00
Room 4

16:30

Migrating SSIS to the Cloud
Integration Services is a mature ETL product that has been around for more than a decade. A true alternative is still missing in the Azure cloud, but you can migrate your existing projects to Azure. In this session, we'll cover the options you have for your migration project and we'll go into detail on how we can run SSIS packages in Azure Data Factory.

Speakers
avatar for Koen Verbeeck

Koen Verbeeck

Koen Verbeeck is a Business Intelligence professional working at AE. He helps client to get insight in their data and to improve their business intelligence solutions. Koen has over 7 years of experience in developing data warehouses, cubes and reports using the Microsoft data platform... Read More →


Tuesday May 21, 2019 16:30 - 17:30
Room 7

17:45

Artificial Intelligence: The Future of Software
Whether you realize it or not, we are currently entering the era of artificial intelligence. AI technologies will radically transform our economy, our society, and our lives. As a result, the software industry is preparing for a major transition as well. However, most developers do not yet possess the skills necessary to remain relevant in our new data-driven economy.

In this session, we will learn about modern artificial intelligence. We'll learn why it’s important and how it will impact you, your career, and our future. We’ll also learn how a series of modern technologies including The Internet of Things, Big Data, and machine learning are combining to create fully autonomous intelligent systems.

Speakers
avatar for Matthew Renze

Matthew Renze

Matthew Renze is a data science consultant, author, and public speaker. Over the past two decades, he has taught over 175,000 developers and IT professionals how to make better decisions with data science. His clients include small software start-ups to Fortune 100 companies across... Read More →


Tuesday May 21, 2019 17:45 - 18:45
Room 7
 
Wednesday, May 22
 

08:45

Azure Cosmos DB Part I - Introduction to Cosmos DB
This session presents an overview of Azure Cosmos DB, a globally distributed, massively scalable, low (single-digit millisecond) latency, fully managed NoSQL database service that is designed specifically for modern web and mobile applications. Like other NoSQL platforms, Cosmos DB supports a schema-free data model, built-in partitioning for sustained heavy-write ingestion, and replication for high availability. But only Cosmos DB offers turnkey global distribution, automatic indexing, and SLAs for guarantees on 99.99% availability, throughput, latency, and consistency.

We begin by explaining NoSQL databases in general, and how they compare with traditional relational database platforms. Then we tour the many features of Cosmos DB, including its multi-model capabilities which allow you to store and query schema-free JSON documents (using either SQL or MongoDB APIs), graphs (Gremlin API), and key/value entities (table API). You’ll learn about global distribution, scale-out partitioning, tunable consistency, custom indexing, and more. We’ll also discuss client development using the many available SDKs. Attend this session, and get up to speed on Cosmos DB today!

Speakers
avatar for Leonard Lobel

Leonard Lobel

Sleek Technologies, Inc.
Leonard Lobel (Microsoft MVP, Data Platform) is the chief technology officer and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National... Read More →


Wednesday May 22, 2019 08:45 - 09:45
Room 11

10:00

Azure Cosmos DB Part II – Building Cosmos DB Applications
In this intensive demo-packed session, you’ll learn how to write applications for Cosmos DB, and see how to work with the various Cosmos DB APIs. These APIs support a variety of data models, including the SQL API (for JSON documents), Table API for (key-value entities), Gremlin API (for graphs) and Cassandra (for columnar). Regardless what you choose as a data model of choice, you’ll learn how to provision throughput, and how to partition and globally distribute your data to deliver massive scale.

You’ll see how to migrate data from SQL Server to Cosmos DB, and how to write queries using Cosmos DB SQL. Then we’ll write data access code that creates and queries databases, collections, and documents, manages custom indexing policies, and defines users and permissions for resource-level access. We’ll also create, deploy, and execute server-side stored procedures, triggers and user-defined functions, using the Cosmos DB server-side programming model. Attend this session, and prepare to build Cosmos DB applications today!

Speakers
avatar for Leonard Lobel

Leonard Lobel

Sleek Technologies, Inc.
Leonard Lobel (Microsoft MVP, Data Platform) is the chief technology officer and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National... Read More →


Wednesday May 22, 2019 10:00 - 11:00
Room 11

11:30

Data Science for Developers
Data science is revolutionizing the world around us. We’re incorporating artificial intelligence, machine learning, and data-driven decision making into all aspects of our business. However, many software developers have yet to learn how to leverage these practices to create better software.

In this presentation, we’ll learn how expert developers are using data science to create better software. We’ll learn how to use data analytics, machine learning, and anticipatory design to create more intelligent software. In addition, we’ll learn how to use data from our dev-ops pipeline to improve our software development practices.

Speakers
avatar for Matthew Renze

Matthew Renze

Matthew Renze is a data science consultant, author, and public speaker. Over the past two decades, he has taught over 175,000 developers and IT professionals how to make better decisions with data science. His clients include small software start-ups to Fortune 100 companies across... Read More →


Wednesday May 22, 2019 11:30 - 12:30
Room 4

13:45

Microsoft Power BI Premium: Building enterprise-grade models
Power BI Premium enables you to build comprehensive, enterprise-scale analytic solutions that deliver actionable insights through familiar data visualization tools such as Microsoft Power BI and Microsoft Excel. This session will dive deep into exciting, new and upcoming features including aggregations for big data to unlock petabyte-scale datasets that was not possible before! We will uncover how the trillion-row demo was built in Power BI on top of HDI Spark. The session will focus on performance, scalability, and application lifecycle management (ALM). Learn how to use Power BI Premium to create semantic models that are reused throughout large, enterprise organizations

Speakers
avatar for Kasper De Jonge

Kasper De Jonge

Microsoft
Kasper de Jonge is a Principal Program Manager on the BI team at Microsoft, where he has worked on developing features for Power BI, Power Pivot and other Analysis Services products such as the Tabular model and Multidimensional cubes. He is a frequent speaker at conferences such... Read More →


Wednesday May 22, 2019 13:45 - 14:45
Room 6

15:00

Why is the Same Query Sometimes Slow?
You swear nothing has changed, but all of a sudden, out of nowhere, queries that used to be fast are suddenly slow. Even weirder, you take the slow query from the application, run it in SSMS, and it's totally fast! What's going on? You restart SQL Server or update statistics, and the problem seems to go away - but only for a few days or weeks, and then it comes right back. You're familiar enough with execution plans to realize that you're getting different plans, but...why? And how do you fix it long term?

In this session, you'll see live demos of the most common culprit: parameter sniffing. You'll learn how to recognize parameter sniffing when it strikes, understand what causes it, see how to fix it short term with the lowest impact possible, and learn 7 ways to fix it long term.

Speakers
avatar for Brent Ozar

Brent Ozar

Brent Ozar loves to make SQL Server faster and more reliable. He created sp_Blitz® and the SQL Server First Responder Kit, and he loves sharing knowledge at BrentOzar.com. He holds a bunch of certifications and awards including the rare Microsoft Certified Master.


Wednesday May 22, 2019 15:00 - 16:00
Room 8

16:30

Convince Your DBA to Support DevOps
You know that using DevOps methodologies successfully can lead to massive improvements in your ability to quickly and safely deliver more and better functionality to your business. However, you have an old-school DBA who refuses to get on board with automation and a shift-left mentality. This session is specifically designed to give you the tools and the language you need to talk to your DBA in a language they'll understand. You'll be able to convince them that not only is implementing DevOps good for the organization, it will lead to a safer database environment. Get your DBA into the modern age using the knowledge from this session.

Speakers
avatar for Grant Fritchey

Grant Fritchey

Redgate Software
Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk... Read More →


Wednesday May 22, 2019 16:30 - 17:30
Room 3

16:30

Kick Start! SQL Server 2017 / 2019 Performance Tips and Tricks
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2017 / 2019 has introduced many new features. In this 60 minute session, we will be learning quite a few of the new features of SQL Server 2017 / 2019. Here is the glimpse of the features we will cover in this session.
• Adaptive Query Plans
• Batch Mode Adaptive Join
• New cardinality estimate for optimal performance
• Adaptive Query Processing
• Indexing Improvements
• Introduction to Automatic Tuning
This 75 minutes will be the most productive time for any DBA and Developer, who wants to quickly jump start with SQL Server 2017 / 2019 and its new features.

Speakers
avatar for Pinal Dave

Pinal Dave

Pinal Dave is a SQL Server Performance Tuning Expert and an independent consultant. He has authored 11 SQL Server database books, 21 Pluralsight courses and has written over 4100 articles on the database technology on his blog at a https://blog.sqlauthority.com. Along with 16+ years... Read More →


Wednesday May 22, 2019 16:30 - 17:30
Room 8