Build Schedule

Advanced Filters:
  • Track

    clear all











  • Speaker


  • Level


  • Session Type


Sessions Found: 25
???????? ?????????? ????????? ????????? ???? ?????? - ??? ??????????. ??? ???? ?? ?????, ? ????? ????????? ?????????. ?????? ????????????? ????????: 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: May 19

Time: 11:10 AM - 12:10 PM

Room: Predslava1

Evaluate Session

Hierarchies are the bread and butter of most business applications and you find them almost everywhere:
* Product Categories
* Sales Territories
* Bill of Material
* Calendar and Time
Even when there is a big need from a business perspective, the solutions in relational databases are mostly sort of awkward. The most flexible hierarchies are usually modeled as self-referenced tables. If you want to successfully query such self-referenced hierarchies, you will need either loops or recursive Common Table Expressions. SQL Server 2017 comes now with a different approach: Graph Database. 
Join this session for a journey through best practices to transform your hierarchies into useful information. We will have fun playing around with a sample database based on G. R. R. Martin’s famous “Game of Thrones”.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 19

Time: 1:30 PM - 2:30 PM

Room: Conference-Hall

Evaluate Session

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: May 19

Time: 10:00 AM - 11:00 AM

Room: Room AC

Evaluate Session

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: May 19

Time: 10:00 AM - 11:00 AM

Room: Predslava1

Evaluate Session

We will start with understanding of several typical architectures of migration to Cloud Enterprise Infrastructure. Than go deeper to internal of Cosmos DB and Spark on HDInsight as main components of Fast Data Processing and Big Data Analytic. We will also cover several approaches for building scalable BI solutions in Azure Cloud using Hadoop and Kafka. The presentation has lots of demos and samples from real projects.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 11:10 AM - 12:10 PM

Room: Predslava2

Evaluate Session

Azure Data Factory v2 is the new version of ADF. This version has the power of the first version and is more flexibility and new opportunities.  First, we can use SSIS packages in our data factory, second,  we have more opportunities for security our data and etc. If you want to know more  just come to my session  and I'll speak you about it
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 4:00 PM - 5:00 PM

Room: Room AC

Evaluate Session

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:
Extended Session (90 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 19

Time: 10:00 AM - 11:30 AM

Room: Conference-Hall

Evaluate Session

The past years have seen the explosive growth of large-scale distributed systems. This trend has changed the database world that is arguably without precedent in the history of the software industry. The result is a ompetitive database marketplace with a huge variety of platforms for us to choose from. But how do we go about making the right choices?

In this talk we will discuss how we can go about choosing the right database models for your application.  We will also look at how the choice of data models can help determine which technologies to include in your data tier.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: May 19

Time: 2:40 PM - 3:40 PM

Room: Predslava2

Evaluate Session

The backups are kind of an insurance policy for an administrators around the World. In case of the database administrator's work it is even more important as they take care of really important data. In this session we will see a different kinds of backups available in the Microsoft SQL Server and multiple ways to configure an automated tasks. In the end we will see how to restore the  backups we have taken in different scenarios (point in time restores, partial restores, etc).
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Beginner

Session Code:

Date: May 19

Time: 1:30 PM - 2:30 PM

Room: Room AC

Evaluate Session

Prepare for a surprising, intriguing, and even controversial session. 45 years after Codd defined the Relational Model, there are still so many parts misunderstood. For sure there are points where you will be surprised and change your view, even though you might have been convinced for years that your view is the correct one, and even if you learned this at a university. Please note that this is theoretical session, using a bit of logic and a bit of mathematics.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 19

Time: 2:40 PM - 3:40 PM

Room: Congress-Hall

Evaluate Session

So, you’re tasked to implement SQL Server AlwaysOn Availability Groups but don’t know where to start. You have a lot of different topologies to choose from but they’re all the more confusing. Creating effective design architecture is key. In this session, we will look at the different topologies – from simple ones to advance – that you can implement and how to build them. At the end of the session, you will walk away with the knowledge on how to build the right SQL Server AlwaysOn Availability Group topology that will address your high availability and disaster recovery requirements.

You will learn:

- Common design patterns and guidelines that you need to consider when building your architecture
- Proper selection of quorum configuration
- Network configuration for local and geographically dispersed replicas
- Combining SQL Server Failover Clustering with AlwaysOn Availability Groups
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Advanced

Session Code:

Date: May 19

Time: 11:10 AM - 12:10 PM

Room: Conference-Hall

Evaluate Session

You might have heard "don't use cursors, they are slow!". In this presentation, you will learn that normally you should write set-based statements instead, and I will explain why they generally are faster. But I will also look at situations where using a loop for one reason or another is preferrable, and you will learn that the best way to run a loop in most cases is exactly a cursor, provided that it is implemented properly. I will also gives some tips how you can troubleshoot performance problems with loops and what pitfalls you need to avoid.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 19

Time: 10:00 AM - 11:00 AM

Room: Congress-Hall

Evaluate Session

Self-Service Data Preparation aka Data Wrangling is becoming more and more popular in BigData and Enterprise world. Data Lake stores tons of different data and it is not easy to get value from it. Traditional approach doesn't work here, data analysts and data scientists have to wait until IT guys gather requirements and prepare a right dataset for them. Time from raw data to insights is too long. In this session, I invite you together look closer at Self-Service Data Prep and show how it would help to get insights and make decisions faster, onboard new data sources without IT, and increase efficiency for data analysts and data scientists.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Beginner

Session Code:

Date: May 19

Time: 4:00 PM - 5:00 PM

Room: Conference-Hall

Evaluate Session

Or how to visualize your data and find insights for beginner IoT developer
If you create an IoT solution today, you have a variety of components available to mix and match to make your solution, akin LEGO.
You get your hardware and firmware right and you get data from the sensors, now what? Of course, you would like to have, some data visualization easy and fast, and of course you would like to learn something from that data easy and fast. And it would be nice to have the results available on mobile devices, yes, yes easy and fast.
Now enter our two titan technologies in a match to the death oops data ?? trying to achieve these goals, you guess it easy fast (and cheap). 
And we will see them clash, from real hardware, to the big Azure cloud, to mobile devices, trying to outmatch each other.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 19

Time: 1:30 PM - 2:30 PM

Room: Predslava1

Evaluate Session

Migrating existing BI workloads to Cloud is not an easy task. IaaS, PaaS, networking, security - this can be overwhelming. During the session I will describe some of learnings from own real-world experiences, design mistakes and how to avoid them. Hopefully they will be helpful in your own journey from on-prem servers to Azure Analysis Services and Data Factory world!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 4:00 PM - 5:00 PM

Room: Predslava1

Evaluate Session

Moving your data warehouse to the cloud? In this session we will go through the consideration and components for data warehousing in the cloud and how these are used and integrated - and when to use which services when looking at:
- Data movement/migration
- Data storage
- Transformation
- Scheduling
- Deployment approach and methods

Second part of the session will focus on the differences and benefits of different approaches ( On-premises, IaaS, PaaS) the following perspectives to undertand and consider the right approach:
- Pricing
- Scalability
- Flexibility
- Strategic considerations
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 10:00 AM - 11:00 AM

Room: Predslava2

Evaluate Session

?? 2016 ?????? Microsoft ????????? ?? ?????? ???????????? ???? ? ??????????? ???????. ????? ????? ?????? ? 7 ?????? (1988 ???) ??????????????? ? ???????????? ??????? ??? ?????? 20 ?????. ? 2016 ?????? ???? ?????????? ????? ???????? ????, ????? ?????????? ??????????? ? 2017  ??????. ?? Batch Mode & Adaptive Query Processing, Query Store & Automatic Query Tunig. ?? ?????  ? ?????? ?????????? ? ???????????.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 19

Time: 4:00 PM - 5:00 PM

Room: Predslava2

Evaluate Session

Everything in life can be hacked… Even SQL Server… Don't believe me? See for yourself…
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: Intermedia

Session Code:

Date: May 19

Time: 4:00 PM - 5:00 PM

Room: Congress-Hall

Evaluate Session

Solving problem with performance for SSRS using internal and external tools.
SSRS logs, HTTP logs, Performance counters.
impact of the solution design on SSRS performance.
The best practice and recommendations for the SSRS deployment
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 19

Time: 11:10 AM - 12:10 PM

Room: Congress-Hall

Evaluate Session

This technical presentation shows how to manipulate data with versioning switched off, what to consider when building queries referencing multiple temporal Tables and building views.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 19

Time: 2:40 PM - 3:40 PM

Room: Room AC

Evaluate Session

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