Build Schedule

Advanced Filters:
  • Track

    clear all



  • Speaker


  • Level


  • Session Type


Sessions Found: 19
AI and Power BI? Yes! 
Azure Cognitive Service comes with a set of powerful, pretrained models for intelligent applications. At this point, four of them are exposed in Power BI: language detection, sentiment scoring, key phrase extraction, and image tagging. These models can be used on textual data or images.
During the 60 minutes of the sessions we will find out together the answer to the questions WHAT, HOW and the most important one, WHY.
Fun is guaranteed :)
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
AI&ML Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 08

Time: 1:20 PM - 2:20 PM

Room: R1

Azure Data Explorer is one of the newest offerings from Microsoft which went GA on the 7th of February. 
I am going to provide an overview of Azure Data Explorer, an interactive analytics service that will enable you to ask the questions on real time data. You can find answers in rapidly changing data generated by systems such as applications, websites, and IoT devices – anything really that generates volumes of streaming data that has potential to uncover a number of unknowns.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: June 08

Time: 9:40 AM - 10:40 AM

Room: R3

So everyone knows how to make some nice graphs in Power BI from Excel or SQL Server... But what about getting "intelligent" results from unusual data sources?
Disclaimer: A.I. will eventually take over the world. Unlike Doctor Evil, it won't ask for a ransom.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
AI&ML Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 08

Time: 9:40 AM - 10:40 AM

Room: R1

This talk is about intersection of IoT and artificial intelligence.
IoT solutions to generate more data than traditional systems and users can analyse.
Nowadays, AI enabled software solutions that optimize equipment and process performance for large industrial customers. These solutions use large volumes of real-time, batch data from equipment and processes in real time, and apply AI/ML algorithms to predict failures and anomalies as well as optimize performance.
The concept is explained in the context of Azure IoT and Azure AI platforms.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 08

Time: 2:30 PM - 3:30 PM

Room: R3

In a real data mining or machine learning project, you spend more than half of the time on data preparation and data understanding. The R language is extremely powerful in this area. The Python language is a match. Of course, you do work with data by using T-SQL. You will learn in this session how to get data understanding with really quickly prepared basic graphs and descriptive statistics analysis. You can do advanced data preparation with many data manipulation methods available out of the box and in additional packages from R and Python. After this session, you will understand what tasks data preparation involves, and what tools you have in SQL Server suite for these tasks.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
AI&ML Architecture, Development & Administration

Level: Advanced

Session Code:

Date: June 08

Time: 11:50 AM - 12:50 PM

Room: R1

An application that you administer stores sensitive data in the database and you would like to keep them safe in Microsoft SQL Server - how to approach this issue? What type of encryption should you use in your environment? On the session I will walk through available options in Microsoft SQL Server and show when to use encryption, how to identify threats, and countermeasure them by using options like Transparent Data Encryption, SSL certificates, Always Encrypted, etc. After this session, you will know a set of best practices that you can apply in your environment.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 08

Time: 2:30 PM - 3:30 PM

Room: R2

Consuming data from JSON is now much easier with the new built-in support introduced in SQL Server 2016!
During this session will talk about JSON representation and will explore the new functions used for handling the content from a JSON file. Based on some examples we'll transform a JSON text to relational table and then will export some data from SQL Server as JSON.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 08

Time: 9:40 AM - 10:40 AM

Room: R2

Like it wasn't enough that just anyone could use an ORM and start molesting a database, nowadays just anyone can use serverless and communicate with a database... and use ORM...
First of all, we're gonna focus on how to communicate with a database from your serverless system presuming that there aren't any parallel requests to the database. In that way, we'll first polish cold starts, memory/CPU consumption, and basically everything we need to worry about now when we're not running our code on servers with 10+ cores, and tens of GB of RAM.
Once we're done with the first task, we'll end up with something that can quickly and effortlessly communicate with our database. Which is perfect, except in cases where we handle thousands or more of parallel requests to the database which isn't scalable as serverless is.
That brings us to our second task- making sure our serverless system won't DDoS our databases :)
Come and find out how to approach this problems ;)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Beginner

Session Code:

Date: June 08

Time: 1:20 PM - 2:20 PM

Room: R3

Cognitive services can recognise objects, faces, describe images, understand speech, perform advanced searches and so much more.
If you are a developer and know nothing about Azure Cognitive Services for free, this is a good place to start.
Disclaimer: Cognitive services will never guess a doctor's handwriting. That's just impossible.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
AI&ML Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 08

Time: 11:50 AM - 12:50 PM

Room: R2

With the infrastructure increasingly moving to the cloud, developers are stuck with legacy tools, suboptimal for the new workflows. Current reality is slow and unreliable web applications bundled using Electron - or native applications that look like they are made 20 years ago.
We have started from scratch, imagining the ideal database manager for modern times. UI responds to your actions in less than 0.1 seconds and your data stays in the cloud. Connection switching is instant and the workspace is preserved between devices and application restarts.
A sneak peek - state of the art SQL code translation solution - removing vendor lock-in.
This is a work-in-progress report, detailing why it's so hard to get right and why does it take so long to make something seemingly simple - not a sales talk, not a self-congratulatory talk.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Advanced

Session Code:

Date: June 08

Time: 3:40 PM - 4:40 PM

Room: R3

Starting from the very beginning, in this session we will cross together the main features Power BI has to offer, starting with the powerful self-service ETL using M language when needed,  modeling our tables and finally using powerful features to create a great data visualization, allowing you to better understand all the power and flexibility of this tool and how it will fit into your solution
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
AI&ML Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: June 08

Time: 10:40 AM - 11:40 AM

Room: R1

Amazon Web Services (AWS) has multiple ways to host and support Microsoft SQL Server.  This session will review the Relational Database Service (RDS) offering of Microsoft SQL Server as well as using our virtual machine service (Elastic Compute Cloud, or EC2) to host SQL Server database services.  We will review options for security, availability, and reliability operations in both offerings and how to choose the optimal solution for your existing and new SQL Server workloads.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Advanced

Session Code:

Date: June 08

Time: 10:40 AM - 11:40 AM

Room: R3

The session presents SQL MI features and different tiers. We will also focus on lift and shift SQL onprem databases and objects hosted outside the database context to SQL MI . This also covers common issues, solutions and workarounds from various migration projects.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 08

Time: 11:50 AM - 12:50 PM

Room: R3

SQL Server 2016 brought support or the R language. SQL Server 2017 added a new language to the list, the Python language. Both languages target advanced analytics scenarios, popularly known as data science. For a SQL Server professional who wants to move in the data science area, the first question is which language to choose. In this presentation, you will learn basics about both languages. We will try to solve the same problem with both languages. This way, through demos with a lot of explanation, you will realize the most important differences between the two competing languages. You will understand which one is more appropriate for you to start with.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
AI&ML Architecture, Development & Administration

Level: Beginner

Session Code:

Date: June 08

Time: 2:30 PM - 3:30 PM

Room: R1

Automation and optimization for all related components to SQL Server: storage, memory, cpu, sql low level design, query plan etc
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: June 08

Time: 3:40 PM - 5:10 PM

Room: R2

Over the years, virtualization has matured from the exotic black magic realm to become a mainstream standard IT practice. "Virtualize First" is now a well-accepted default practice in most enterprises and any deviation is now considered an anomaly. In spite of this trend, many IT administrators and architects still have some reservations about virtualizing SQL Server workloads. They consider SQL too "critical" to be virtualized; they wonder and worry about scale about performance; they are looking for guidance and reassurance. If this is where you (or your clients) are today, be sure to attend this session. You will gain valuable insights from what others have done to successfully undertake similar tasks in their environments. We will talk about configuration pitfalls to avoid and also review the configuration and current performance data for some of the most demanding applications in customers environments. Got an SQL virtualization or performance question? Bring i
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: June 08

Time: 3:40 PM - 5:10 PM

Room: R2

To reach your desired business functionalities, it can be easy using some common T-SQL practices like MTVF , scalar functions , Temp tables, Union…etc and they might perform pretty well on development server coz neither adequate stress of users nor adequate volume of data exist there but actually they seem totally strange once going to live where they become performing badly ending up eventually with and sharp skew of performance and standstill cases sometimes , this is due to the lack of stress powers of T-SQL codes which should be considered largely for critical mission DBs in particular more therefore I am going to talk to you about How to capture expensive queries using different techniques ..?and How to optimize them in the shortest time using scientific ways ..? (10 different T-SQL Practices will be explained within this session)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 08

Time: 11:20 AM - 12:20 PM

Room: R2

Visual Studio is an excellent tool, praised by many as the best IDE there is. One of the important things that Visual Studio provides is productivity. Besides a plethora of built-in features, even more functionality can be added through extensions. This presentation is a short overview of some integrated features as well as a look into some extensions that improve productivity.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 08

Time: 10:40 AM - 11:40 AM

Room: R2

In an ideal world, we would not need any error handling, because there would be no errors. But in the real world we need to have error handling in our stored procedures. Error handling in SQL Server is a most confusing topic, because there are such great inconsistencies. But that does not mean that we as database developers can hide our head in the sand.

This presentation starts with a horror show of the many different actions SQL Server can take in case of an error. We will then learn how should deal with this - what we should do and what we should not and that with SET XACT_ABORT we get better consistency. We will learn how TRY-CATCH works in SQL Server, and we will get a recipe for how to write CATCH blocks. More generally, we will learn why it pays off to be simple-minded to survive in this maze. The session mainly looks at traditional T-SQL code, but the session ends with a quick look at natively compiled stored procedures, where everything is different.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: June 08

Time: 1:20 PM - 2:20 PM

Room: R2

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