Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type



Sessions Found: 28
?? ??? ???????? ? ????, ??? ?????? ???? ??? ??????????? ????? ????????? ??????????????? ?????????, ???????? ??????? ???? ??? ??? ????? ? ????????? ?? ???? ???????? ?????. ?? ??? ???? ? ????? ???, ??? ???? ?????? ??????????? ?????????? ? ?????????? ??? ? ?????? ???, ??? ??? ?????? ? ????? ?????? ???????????? ?? ??? ?????, ?? ???? ???????? ? ???? ???, ?? ? ????? ??? ?? ????????? ???????????, ??? ?? ?????? ????????? ??? ? ?????? ? ??????? ?? ?? ??????????? ?????? ? ????????????? CPU, ? ?? ??? ????? ??????????????? ??????????. ???????????, ??? ? ???? ???? "???????????" ???????? ?????????????? ??????? ????????? ?? 100500 ??????????? ?????, ??????? ?????? ??????? ?? ?????????? ???? ?????, ? ?? ?????? ??????? ? ???? ??? ???. ? ???? ???????? ? ??? ??????????? ????? ??????? ??? ?????? ? ????????. ??? ?????????????? ?????? ??? ???????? ??????????? ??????????? ?????, ??????? ? ??? ??????, ? ????????? ???????? ?????? ????????, ??????? ???? ???????? ??? ??????? ???? ?????.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 20

Time: 3:10 PM - 4:10 PM

Room: Green Room

? ??????????? ???? ????????, ?? ???? ??????????, ???? ????? ???? ?????????? ?  ?????????????. ?????????? ??????, ?? ???? ????????? ???????????? ??????????, ? ????? ?????? ? ???????? ??????? MS SQL Server.  ???? ?????? ?????????? ????????? ???????????? ?????????? ????????????? ???????.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 20

Time: 10:00 AM - 11:00 AM

Room: White Room

Anchor Modelling is a fantastic database modelling paradigm that uses sixth normal form (6NF) to store data and provides third normal form (3NF) views for ease of use. 

This session deep dives into all the concepts behind Anchor Modelling (and indeed databases generally!) and then takes you through how Anchor Modelling uses these concepts to move away from the traditional data warehouse paradigm to deliver a purely additive, agile database.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: May 20

Time: 11:10 AM - 12:40 PM

Room: Blue Room

Data Factory is a cloud-based data integration service that orchestrates and automates the movement and transformation of data. You can create data integration solutions using the Data Factory service that can ingest data from various data stores, transform/process the data, and publish result data to the data stores.   Cool.  What is it? It is cloudy ETL? Really? Why can't I used SSIS? What  is the difference between SSIS and Azure DataFactory?  So  come to my session and I can answer all question about Azure Data Factory.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: May 20

Time: 2:00 PM - 3:00 PM

Room: Yellow Room

Apache Kafka is the most popular open source stream-ingestion broker and can handle large numbers of reads and writes per second from thousands of clients. Apache Cassandra is an open source distributed database management system designed to handle large amounts of data across many commodity servers, providing high availability with no single point of failure. Kappa architecture based on Kafka and Cassandra clusters provides a powerful event processing solution for massive amounts of data produced by  real-time applications.
During the session we will dive into different aspects of building real-time streaming analytics, will review approaches of a kappa architecture implementation on Azure and will discuss experience of massive event processing and monitoring projects. All examples are taken from a real project for on-line monitoring of drones.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: May 20

Time: 11:10 AM - 12:10 PM

Room: White Room

Azure SQL DWH is based on MS SQL Server and supports T-SQL. It helps to DB/DWH developers start using it without many efforts. Unfortunately, there are several limitations that could bring difficulties in your job. For example, we can't use MERGE statement for Upsert tasks in DWH, there is no IDENTITY or SEQUENCE, differences in implementing partition switching  and so on. In this session, I'm going to cover several tips and tricks how we can handle with this limitations using available possibilities.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 20

Time: 2:00 PM - 3:00 PM

Room: White Room

Come round to talk about Application Lifecycle Management (ALM) and deployment/delivery of Business Intelligence (BI) Applications! You will learn how to manage and deploy a full stack BI solution with Team Foundation Server (TFS). I will share my view of end-to-end architecture of MS BI ALM and practical tips on how to make it happen with TFS toolkit, with specific examples for every MS BI project type. The presentation will also compare features of Release Manager and Octopus Deploy for your deployment needs will show a demo of continuous deployment for a typical BI project using TFS. The material does not assume prior knowledge of TFS administration, but some experience using Visual Studio database projects and general TFS terminology will be helpful.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: May 20

Time: 10:00 AM - 11:00 AM

Room: Red Room

Microsoft Power BI Embedded is a Microsoft Azure that 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. 
Microsoft Power BI Embedded helps Independent Software Vendors to use Power BI data experiences within their applications. Customers, who use applications with Power BI Embedded don’t need to have a Power BI account or to know anything about this Azure service. 
This talk is a practical session on Microsoft Power BI Embedded concept with many examples how to create custom BI solutions using this technology.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 20

Time: 2:00 PM - 3:00 PM

Room: Red Room

R language has for a long time been the most  popular for data processing and statistical analysis. Among R's strengths are vibrian community and extensive repository of libraries for performing all kinds of analyses. However, major deficiency with R are that is slow, memory-bound and hard to operationalize. 
Microsoft R Server (MRS) mitigate R limitations, and run multi-threaded analysis on a large dataset. The new release, MRS 9, goes even further. 
First off, it contains a Microsoft ML (machine learning) package - a collection of best-of-breed ML algorithms that have been battle-tested by Microsoft on a variety of its products. It includes improved logistic regression, fast boosted decision tree, fast random forest, GPU-accelerated Deep Neural Networks and One-Class Support Vector Machine (for outlisiers detections).
Secondly, MRS 9 allows R models to be exposed as Web services. Furthermore with MRS 9 models that are trained in one environment can even be moved to, and scored in, ot
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: May 20

Time: 10:00 AM - 11:00 AM

Room: Blue Room

BI teams usually not only deliver features , but also do the ad hoc reports, users support etc
This way BI is not a canonical development team and no pure development methodology works "out of the box" . 
In my talk I would like to share my experience choosing and adjusting one.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 20

Time: 3:10 PM - 4:10 PM

Room: White Room

In times past, Data Science was only for those elite few with a rare combination of skills including advanced knowledge of statistics.

Microsoft has been making sure that everyone can participate in the data revolution by giving people access to predictive API’s, in-database advanced analytics and drag-and-drop predictive experiments. All thanks to SQL Server 2016 and the Cortana Intelligence Suite in Azure.

These advances have given people with less knowledge of statistics and programming the ability to become what Gartner calls citizen data scientists.
Should we be worried about fools-with-tools or should we embrace the democratization of data science as the golden age of data?

Using a combination of theory and demo’s, we explore Microsoft’s solutions to ensure democratization of data science and the possible dangers that lurk below the surface.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 20

Time: 11:10 AM - 12:10 PM

Room: Yellow Room

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:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 20

Time: 4:30 PM - 5:30 PM

Room: Yellow Room

You probably know that with a stored procedure you can permit users to access or update data even if they have no direct permissions on the table. But you may have noticed that this does not work when the SP uses dynamic SQL. 

In this session you will learn why it is so and techniques how you can use to overcome this. You will also learn that the same techniques can be to permit users to perform specific actions they need to do without granting them general high-level permissions on database or server level by packaging these actions into a stored procedure. You will also learn why should should be careful with setting a database TRUSTWORTHY.

The session should be of interest both to DBAs and application developers that need to consider advanced permissions in their stored procedures.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 20

Time: 3:10 PM - 4:10 PM

Room: Blue Room

Microsoft surprised a lot of people with the announcement that SQL Server is going to be released for Linux. And there we have it - preview releases available in public are regularly delivered, working great and fast.
On my session I'll show details of solution that allowed this idea to come true. We'll see how to install, use and administer Linux version of SQL Server. We'll see it working as a service and in Docker containers. I'll give you details of why the second option is really interesting, or to say it more clearly - groundbreaking.
In addition to slides you're going to see lots of terminal windows, tools that are familiar to you and new stuff as well.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 20

Time: 4:30 PM - 5:30 PM

Room: Red Room

So you've started sending data into Azure IoT Hub or Event hub and you want to start querying and aggregating your data stream.
The preferred method of doing so is Stream Analytics, a subset of the T-SQL language.
Join me to take a closer look at the language, the possibilities and limitations of it and how to make it work for you.
We will look at inputs and outputs - and see some working samples.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: May 20

Time: 10:00 AM - 11:00 AM

Room: Yellow Room

SQL Server is a high frequently used piece of software which need to serve single requests and/or hundreds of thousands of requests in a minute. Within these different kinds of workloads Microsoft SQL Server has to handle the concurrency of tasks in a fashion manner. This demo driven session shows different scenarios where Microsoft SQL Server has to wait and manage hundreds of tasks. See, analyze and solve different wait stats due to their performance impact:
- CXPACKET: when a query goes parallel
- ASYNC_IO_COMPLETION: speed up IO operations (Growth / Backup / Restore)
- ASYNC_NETWORK_IO: What happens if your application refuses data?
- THREADPOOL starvation: crush of requests for Microsoft SQL Server
- PAGELATCH_xx: How does Microsoft SQL Server protects data?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 20

Time: 4:30 PM - 5:30 PM

Room: Blue Room

DML operations mean lot of work for the database engine of Microsoft SQL Server. Understanding the details of a DML transaction may give you great benefits when planning workloads for INSERT, UPDATE and DELETE operations.

Come and learn the differences of space allocation/deallocation between Clustered Indexes and Heaps in this demo oriented session. It will answer these questions:

What is the difference of data page allocation for heaps and clustered indexes?
What is the amount of transaction log when you update data in a heap and/or in a clustered index?
What are the differences when data are delete from a heap and clustered index?
Can ETL processes be improved by usage of the right strategy for INSERTS and DELETES?
What performance drawbacks have Page Splits and Forwarded Records for my application design?
Speaker:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
Application & Database Development

Level: Advanced

Session Code:

Date: May 20

Time: 11:10 AM - 12:40 PM

Room: Red Room

Analysis Services 2016 uses JSON as a format to store the metadata of a model and you can change it with C# using TOM (Tabular Object Model). The new object model has a one-to-one mapping between physical entities in the database and objects in the model. This is very usefull if you need to add or change measures without redeploying the whole project to server.
For example, you need to generate set of new measures every year or end users want to add measures themselves and so on.  Using TOM and meta-data table you can automate this process and save tons of time. Join this session for learning how to implement this.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Extended Session (90 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: May 20

Time: 11:10 AM - 12:40 PM

Room: Yellow Room

How easy is it to hack a SQL Server? 
In this session we'll see a few examples on how to exploit SQL Server, modify data and take control, while at the same time not leaving a trace.
We'll start by gaining access to a SQL Server (using some "creative" ways of making man-in-the-middle attacks), escalating privileges and tampering with data at the TDS protocol level (e.g. changing your income level and reverting without a trace after payment), and more. 
Most importantly, we'll also cover recommendations on how to avoid these attacks, and take a look at the pros and cons of new security features in SQL Server 2016.
This is a demo-driven session, suited for DBAs, developers and security consultants (Jedi level). 
Disclaimer: No actual state secrets will be revealed. Please do not send agents to my house again.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 20

Time: 2:00 PM - 3:00 PM

Room: Blue Room

How to implement best practices for SQL Server in a SharePoint Server farm
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Beginner

Session Code:

Date: May 20

Time: 2:00 PM - 3:00 PM

Room: Room D

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