Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 28
If you are reading Azure IoT documentation you will stumble a lot on the “SQL-like query language” or “SQL-like language” syntagms.
In this presentation we will explore Azure IoT places where queries are used and see how to use them. And in the process to find out more about this “SQL-like” languages and how being a DB developer cam make you a IoT hero.
We will concentrate on the scenarios with the greatest impact, where a little SQL can solve you a lot of hassle.
So, we will leave no SQL query unturned ?? in Azure IoT Hub, Stream Analytics, Power Bi to name a few.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 18

Time: 2:40 PM - 3:40 PM

Room: Conference-Hall

The amount of data we collect, store and process is rapidly growing and goes hand in hand with growing amount of work related to managing it. Automation is a key if we want to stay in control and AIOps represents its next major level with potential to revolutionise IT operations. This session explains what AIOps is, provides common use cases and gives practical examples that help to avoid costly Sql Server disruptions and eliminate firefighting. Presented solution addresses limitations of Query Store and automates the identification and resolution of common performance issues.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 18

Time: 1:30 PM - 2:30 PM

Room: Room AC

In this session we will discuss about tempdb contention in SQL Server on-premises, Azure SQL Managed Instance and Azure SQL Database. We will analyze both, Allocation Contention and Metadata contention, describing in detail WHEN and HOW it occurs, How to diagnose it, Best Practices and how to prevent it. The session will have both approaches in on-premisses and in Azure Managed Instance: - Theoretical, to understand what and why it occurs. - Practical, with examples causing it, offering alternatives to solve it and to prevent it.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 18

Time: 11:10 AM - 12:10 PM

Room: Room AC

This session will cover the basics of dynamic SQL; how, why and when you may wish to use it with demos of use cases and scenarios where it can really save the day (trying to perform a search with a variable number of optional search terms, anyone?). We will also cover the performance and security impacts touching on the effect on query plans, index usage and security (SQL injection!) along with some best practices.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 18

Time: 4:00 PM - 5:00 PM

Room: Conference-Hall

What is Blockchain as Service? This session is more about Blockchain basics and the technical details of the Azure Workbench. With Blockchain Workbench, you can define blockchain applications using configuration and writing smart contract code. You can jumpstart blockchain application development and focus on defining your contract and writing business logic instead of building scaffolding and setting up supporting services.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 18

Time: 11:10 AM - 12:10 PM

Room: Room AC

Building a BI solution for a travel platform using AWS ... Or Google Cloud ... Or both .. Or custom services? 
Will share the experience of using different infrastructures and the overview of the tools for both
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 18

Time: 11:10 AM - 12:10 PM

Room: Congress-Hall

DBA is key when a database platform change occurs and necessary to support the application, release processes and there is a miracle waiting to happen!

Based on my experience DBA is left out in the key element of DEVOPS, this is unfortunate. DBAs have a lot to offer . 
In this session let us overview where exactly DBAs can make miracles with their magic wand, let's talk about process and procedures. To evaluate each change request to ensure that it is well thought out, is compliant with organizational best practices. Also review what Azure DevOps is offering to manage your cloud deployments.

Take away best practices associated in DEVOPS and DBA world.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 18

Time: 1:30 PM - 2:30 PM

Room: Conference-Hall

You have been working with SQL Server for several years and you feel quite comfortable with most of the available features. Even you have a checklist for installation/configuration of SQL Server to be compliant with corporate standards. However, somewhere on the back of the head you have a feeling that there is something more that can be done to secure your SQL Server. If you are willing to see how small reconfiguration can lead to compromise of your SQL Server join this session. There will be demos on live system showing how to leverage misconfiguration and how to prevent them from happening in the future. After the session you will have a set of checks that can be implemented on your system.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 18

Time: 2:40 PM - 3:40 PM

Room: Predslava1

You already know how easy it is to hack SQL Server… But how do you protect your local and cloud servers against enemy agent attacks?
This is a demo-driven session, suited for DBAs, developers and security consultants. Both exploits and security recommendations to avoid them will be covered.
Disclaimer: No actual crimes will be committed. Please do not send agents to my house again.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 18

Time: 10:00 AM - 11:00 AM

Room: Congress-Hall

This is story about we tried to do some data analysis for S3 logs, and found that AWS Athena allows to do it easy and fast using SQL queries. But for data analysis we need to have more powerful visualization tools - and Amazon Elastic Map Reduce (Hadoop as a Service) in fact are closely integrated with S3, Athena and other AWS services.  
Deployed in 2 clicks, Apache Zeppelin can query your data directly from S3 file storage and works with data using SQL or Spark (Scala) if You are brave enough. 
We used all this stuff only for one reason - delete unused packages from Artifactory, which grows up to 3 Tb and became a little bit expensive to host in Cloud. But the issue was - 'unused' definition was little bit unclear, and some deep analysis need to be made to make a proper decision. 
Golang application helps us to retrieve data from Artifactory, and Zeppelin and Spark SQL queries allowed to filter and visualize corresponding data.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 18

Time: 2:40 PM - 3:40 PM

Room: Predslava2

Have you heard that knowing machine learning is the easiest way to get rich quickly? Let’s test this statement. Kaggle is the place to do data science projects, why not to start there?
During this session we will solve simple Kaggle competition. Actually, we will submit two solutions. The first made with super-duper deep neural network (black-box approach). Then we will follow proven ML methodologies and solve the problem methodically. All that using SQL Server Machine Learning Services.
Minimum slides and maximum fun guaranteed.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: May 18

Time: 1:30 PM - 2:30 PM

Room: Congress-Hall

Polybase started as a technology which allows you to query data stored in Hadoop or Azure Blob Storage as if it were just another table within SQL Server. In SQL 'Aris' (2019), Polybase will grow further and add additional connectivity and querying potential.  

Come to this Beginner talk to learn how you can get started using Polybase in SQL Server right away, and learn about the 3 core EXTERNAL objects used in Polybase.  We will compare and contrast the differences and similarities between Polybase and Linked Servers.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 18

Time: 10:00 AM - 11:00 AM

Room: Room AC

This Azure SQL Database pre-con provides you the knowledge and tools necessary to understand the capabilities and usage of cloud databases. It will help you get familiar with the Azure SQL Database concepts. It will also help to learn how to migrate, manage, monitor and troubleshoot your Azure SQL Database solution. You will learn the difference between the Azure SQL Database (PaaS) and SQL Server on-premises and which benefits Azure SQL Database can have for your applications and SQL environment. After attending this pre-con, you will be able to:
•	Understand how Azure SQL Database works
•	Know the newest and most important features to manage your Azure SQL Database
•	Design scalable architectures
•	Design Disaster Recovery plans
•	Manage security on your Azure SQL Database
•	Monitor and troubleshoot Azure SQL Database
•	Face a migration project
Speaker:

Accompanying Materials:

No material found.

Session Type:
Precon Training (480 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 17

Time: 10:00 AM - 6:00 PM

Room: RoomB

The Intelligent query processing feature family includes features with broad impact that improve the performance of existing workloads with minimal implementation effort.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 18

Time: 4:00 PM - 5:00 PM

Room: Congress-Hall

This presentation provides a general overview of Oracle APEX.
What is Oracle APEX?
Oracle Application Express (APEX) is a low-code development platform that enables you to build stunning, scalable, secure apps, with world-class features, that can be deployed anywhere.
Are you an existing Oracle Database customer?
Then you have everything you need to start building useful, scalable apps now using Oracle APEX. If you know even a little bit of SQL, you can become wonderfully productive and start producing apps that you would have thought required a full-stack developer.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 18

Time: 11:10 AM - 12:10 PM

Room: Predslava2

With a few exceptions, SQL Server stores the execution plan for a query in the internal plan cache. In most cases, subsequent execution of a similar query will greatly benefit from this mechanism, but not in all cases.
In this session, you will learn why and under what circumstances SQL Server caches execution plans.
We will analyze the plan cache to identify performance issues, such as plan pollution, and how to avoid this.
You'll see the benefits and drawbacks of parameter sniffing for procedures and functions, and the differences between native compiled and interpreted stored procedures.
Furthermore, we will analyse how the settings ‘optimize for adhoc workloads’ and ‘forced parameterization’ influence query execution and the re-use of cached plans.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 18

Time: 2:40 PM - 3:40 PM

Room: Congress-Hall

Power BI Premium introduces a new developer layer for embedding Power BI in custom applications, and a new on-premises deployment option as well. Microsoft Power BI Embedded applications enables developers to integrate Power BI reports into their web or mobile applications so they don’t need to build custom solutions to visualize data for the users. It helps Independent Software Vendors to use Power BI data experiences within their applications.
This talk is abou the best practices designing and implementing in business solutions Power BI Embeded and Power Bi Premium: which version to use and how to take the best advantage from different version and tier of Power BI, offered from Microsoft.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 18

Time: 10:00 AM - 11:00 AM

Room: Conference-Hall

? ??????? ? ????????? ???????? ???? ????????? ? DAX, ????????? ????????? ? ???????????? ????????????? ????? ?????.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 18

Time: 1:30 PM - 2:30 PM

Room: Predslava2

Azure SQL usage seems to be easy and straightforward, but there are set of steps to make it truly reliable and properly secured. This talk is about following three important topics.

Are you ready for disaster, are your team take a proper drill? I`m sure you do, but in case you need a few tips and check list - you will obtain it. Usually, proper monitoring(including network impact), profiling and alerts are introduced after the first production issue, so this will be first point.

Security seems to be hot topic these days and there are few steps to secure your Elastic cluster proper way, plain Azure SQL Server firewall might be not enough. Security measures overview with best practices, vNet, user roles isolation, encryption at rest, secret maintenance with KeyVault, Security center and other tips.

Infrastructure as code is essential part of Azure and proper set of the environment crud scripts can really save your day at some point in future, also you can do useful stuff with T-SQL in
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 18

Time: 1:30 PM - 2:30 PM

Room: Predslava1

? ???? ??????? ? ???????? ?? ????????????? ???????????????? ????? ? ??????? PowerShell. ??????? ????????? community ??????? ? ?? ?????????????.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 18

Time: 11:10 AM - 12:10 PM

Room: Conference-Hall

Sessions Found: 28
Back to Top cage-aids
cage-aids
cage-aids
cage-aids