Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 19
????? ???? ?????????????? ??? ????? ????????????? ?? ????????? «???? ??????????? ? ??? ?? ?? ???», ? ????? ? ?????? ???????????. ?? ????, ?? ?????????? ?? ??????? ? ??????????????, ??????????????? ?????? ?? ??????????, ?????? ?????? ????? ? ??????? ???????? ??????????.

?????????, ? ???????, ??? ????????? ????? ?? ???????? ???? Microsoft SQL Server ?????????? ? ??????, ?? ????????? ?????? ???????????? ??????????????? ??? ?????, ?????? ???? ?? ???? ????????? ?? ????????.

? ??? ?????:

1. ??????????
2. ?????????? ? ????????????
3. ????????? ??????????????
4. ???????? ? ?????????????? ? ?? ?? ????????
5. ?????????????
6. ???????? ????????? ??????????? ??? ?????
7. ???????? ??????? ? ???????????

???????? ??????????? ??? ??????? ???? ? ???? ????? ? ??? ???, ??? ?? ??? ??????? ? ??????????????? ??? ?????, ? ????? ???, ???? ???? ??? ????????? ?? ????????????.

??????????? ?????.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 29

Time: 3:10 PM - 4:10 PM

Room: Room B

Did you not get budget for that cool monitoring tool, but you still want to monitor your SQL Server? In this session I am going to show you 10 alerts that you should setup in your SQL Server instance. Going from CPU, IO, Corruption and Backups.

By the end of this session, your life as a DBA will be much easier with those alerts in place!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: September 29

Time: 12:50 PM - 1:50 PM

Room: Room B

Do you find query optimization a mystery? This session will straighten out your question marks.
You will se how queries are run, how indexes are used and get an insight into what query plans tell you.
Further on you'll be introduced to In-Memory and Column Store indexing to get a fair chance of 
selecting appropriate indexing for your query load.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 29

Time: 3:10 PM - 4:10 PM

Room: Room A

This session is Intro to AWS Redshift. 
Will give the overview of the architecture and important details
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Beginner

Session Code:

Date: September 29

Time: 10:55 AM - 11:55 AM

Room: Room C

In this session let us find about (technical overview)what are the foundations and design goals of Azure CosmosDB.  There are many benefits which will fit for web, mobile and globally distributed applications that need elastic scaling, high availability with a predictable performance which can elevate ease of development with NoSQL capabilities that every developer/architect/DBA should know about.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: September 29

Time: 3:10 PM - 4:10 PM

Room: Room B

How you know companies set their sights on making data-driven decisions.  Mastering data engineering is a business necessity.  So they need tool which can be simply and  powerfull at the same times. Now it's  Azure Databricks.   Built on Apache Spark™, Azure Databricks provides the scale, compatibility and reliability to expand your data engineering capabilities. Come to my session and I show you how you can scale mission-critical data cleansing, transformations, and manipulations to make business use cases such as real-time dashboards or fraud detection possible with Azure Databricks.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: September 29

Time: 9:45 AM - 10:45 AM

Room: Room B

We will cover the main aspects to migrate to one of the three architectures available in SQL Server in Azure from SQL Server On Premise. 

This session consists of:
-> What is the best platform for my environment? IaaS, PaaS, or SQL Datawarehouse.
-> Best Practices and best tools for our migration process depending on the platform chosen.
-> After the migration, we have several outstanding questions:
            Can I keep both environments synchronized?
             How is the performance of my database?
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: September 29

Time: 3:10 PM - 4:10 PM

Room: Room C

R is the first choice for data scientists for a good reason: besides accessing and transforming data and applying statistical methods and models to it, it has a wide variety of possibilities to visualize data. As visual perception of data is the key to understanding data, this capability is crucial. This session will give you a broad overview over available packages and diagram types you can build with them on the one hand, and a deep dive into common visualizations and their possibilities on the other hand. Impress yourself and your peers with stunning visualizations which will give you insights into data you could not achieve with other tools of Microsoft’s BI stack.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Analytics and Visualization

Level: Beginner

Session Code:

Date: September 29

Time: 9:45 AM - 10:45 AM

Room: Room C

We would like to describe a data migration project for Law Company from UK. 500M documents in more than 20 offices around the world were migrated from a legacy Document Management System to a new one. As the result, in total, over 200 TB of data were extracted, transferred, reshaped and loaded. The session will start from specifics of a pre-sale process, than cover in details "As Is" and "To Be" architecture, show the results of a PoC, which was done in Azure Cloud and finally describe delivery and results. During the presentation we will focus on specific aspects of Data Migration projects, scalability, security, etc. Also will discus several difficulties we dialed with. The session contains lots of architectural diagrams and examples of code.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Advanced

Session Code:

Date: September 29

Time: 4:20 PM - 5:20 PM

Room: Room A

Query tuning is a challenging task for a developer and database administrator - so how can we achieve this?

SQL Server mainly offers two different tools we can use for this purpose: DTA Database Tuning Advisor and Missing Index Dynamic Management Views.
But what are the differences in terms of reliability, usage, limitations and tuning recommendations?
So, we will try to answer these questions in this deep dive session (300-400).
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: September 29

Time: 9:45 AM - 10:45 AM

Room: Room A

A common requirement in database applications is that users want a function to search a set of data from a large set of possible search conditions. The challenge is to implement such searches in a way that is both maintenanble and efficient in terms of performance. This session looks at the two main techniques to implement such searches and highlights their strengths and limitaitons.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 29

Time: 2:00 PM - 3:00 PM

Room: Room B

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:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: September 29

Time: 10:55 AM - 11:55 AM

Room: Room B

Everthing is connected. Everything is accessible. Everything is hackable.
This is a security "worst" practices session for developers (yes, yes, the boring "best" practices are also included).
As always, should you or any of your colleagues be hacked or exploited, the Demo Gods will disavow any knowledge of the speakers' actions. This session will self-destruct in 60 minutes. Luck has nothing to do with it, Jim…
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: September 29

Time: 10:55 AM - 11:55 AM

Room: Room A

Real project experience: Causes and how to avoid
Sunstroke. Butterfly effect (How optimizer allocates memory for different  operations? Is it possible to change allocated memory in-fly (without query recompilation)? Some data types  save disk space and what about memory?) Sequence (is it good or bad), Silver bullet (not only SQ-92)
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 29

Time: 2:00 PM - 3:00 PM

Room: Room A

Admit to yourself that you’ve seen enough basic “R is coming to SQL Server” sessions with the same old examples!
Enough of that, in this session we'll walk through a real SQL Server Machine Learning Services scenario from idea to code and from deployment to monitoring & maintenance.
Learn how you can easily roll out your own Data Science projects or support the data scientists and analysts at your company.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: September 29

Time: 2:00 PM - 3:00 PM

Room: Room C

Every user wants to have his/hers reports generated quickly. But reality isn't so cute. Sometimes you have to wait and wait, and wait again while looking at the rotating green circle.
During my session you will learn how to monitor Reporting Services with the Execution Log.  I will show the structure of the log and some useful queries to get precise insights into report generating process. Analysing the log gives you a quick way to find bottlenecks and sources of your problems. Especially when you use a tool like Power BI or Excel to create a functional dashboard. You also will learn how to use R powered models in Power BI to predict problems with your reports execution.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: September 29

Time: 12:50 PM - 1:50 PM

Room: Room C

The current IoT devices are pretty powerful, so could very well run a version of SQL engine.
It would be a good idea?  What will be the use of it? How to make it work and make the most of it? 
How does all fit with the field gateway concept?  During the presentation, we will take a real word scenario, real hardware, and together we will try to answer these questions
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 29

Time: 4:20 PM - 5:20 PM

Room: Room C

Nothing is perfect, which means that your database may be not perfect as well. And one day you may decide that your database is slow and it's time to optimize it. But.. Where to start? When to end? What to look at? Which queries are slow? How to identify the real bottleneck? And so on, and so on. There are a lot of questions that should be answered in a process of performance tuning. 

In this session, we will find answers to all these questions going from collecting data for analysis, through identifying bottlenecks to optimization of the particular queries. On this way, we will learn performance tuning practical techniques and solve a bunch of issues in real-time. And despite I'm a big fan of Profiler and old-fashioned tools and technics, new, more interesting and useful instruments are available nowadays, so will use them to find the bottleneck and tune performance. Minimum of theory and a lot of practice.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: September 29

Time: 12:50 PM - 1:50 PM

Room: Room A

???????? ?????????? ????????? ????????? ???? ?????? - ??? ??????????. ??? ???? ?? ?????, ? ????? ????????? ?????????. ?????? ????????????? ????????: Backup, Recovery, Shrink, VLF, Replication, AlwaysOn, CDC, Best Practices.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: September 29

Time: 4:20 PM - 5:20 PM

Room: Room B

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