Build Schedule

Advanced Filters:
  • Track

    clear all










  • Speaker


  • Level


  • Session Type



Sessions Found: 30
? ?????? ??????? ? ????????? ?????????? ?????? ???????? ?? ????????????? ? ???????????? ????????.
? ??? ????? ????????:
1. ??????????, ????????????, ????????????? ???????. ????? ??? ?????, ? ????? ??????? ?????????? ?? ????????? ? ?????? ??? ?????? ????.
2. ??? ????????? ?????? ???????, ????? ?? ????????? ??????????? ????????????? ????????.
3. ??? ????????? ??????????? ???????, ????? ?? ??????? SQL Server "???????? ??????".

????? ???? ?????? -  ?????, ? ????????,  ????????????!

? ??? ?? ????? ????????:
1. XML, Columnstore ???????.
2. ?????????? ??????????? ???????? ????????.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 21

Time: 4:30 PM - 5:30 PM

Room: Room3

MS SQL Server ????? ??? ?????????? ??? ?????????? ?????????? ??????? ?????: ????????? ?????? ?? ???????? ??????. ??????????, ?? ???????? ????? ??????????????? ??? ????????? ??'???? ????? (?? ????  ?????? ? ??????????? ???'???), ? ????????? ??????? - ??? ???????. ??????????, ?? ?????? ?? ???; ?? ????? ?? ?????? ???????????????? ??????????? ?? ??'????.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 21

Time: 4:30 PM - 5:30 PM

Room: Room5

2AM. We sleeping well. And our mobile ringing and ringing. Message: DISASTER! In this session (on slides) we are NOT talk about potential disaster (such BCM); we talk about: What happened NOW? Which tasks should have been finished BEFORE. Is virtual or physical SQL matter? We talk about systems, databases, peoples, encryption, passwords, certificates and users. In this session (on few demos) I'll show which part of our SQL Server Environment are critical and how to be prepared to disaster. In some documents I'll show You how to be BEST prepared.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: May 21

Time: 10:00 AM - 11:00 AM

Room: Room1

This is not your regular Agile yada yada BIML session. 
By now you already know that BIML is a great productivity enhancement to SSIS. You also know that you can build metadata driven solution and include C# code in your BIML scripts or snippets.  If you don't know what I'm talking about this session is not for you. If you - on the other hand - want to know how to build a modular BIML framework, do real C# development and include it in your BIML code so that you can pass custom objects around for optimized performance and code reuse then this session is for you. I promise you no more than 5 slides but a lot of demos and real life experience acquired from major BIML projects. We will also have a look at how to harness integration and unit tests in the setup with a twist of Continuous Integration.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Advanced

Session Code:

Date: May 21

Time: 2:00 PM - 3:00 PM

Room: Room3

Anomaly detection is one of the most advanced data mining and machine learning tasks. There are many statistical procedures and data mining algorithms that can be used for it, including Expectation-Maximization Clustering, and Principal Component Analysis. In this session, you will learn through presentation and demos how to detect the low quality data areas with some basic statistics and with advanced algorithms. You will see how you can use T-SQL queries, R code in SQL Server, SSAS Data Mining, and Azure ML for this complex task.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Advanced Analysis Techniques

Level: Advanced

Session Code:

Date: May 21

Time: 3:10 PM - 4:10 PM

Room: Room2

With Azure Data Lake a new SQL-based language called U-SQL has been introduced, that combines the familiarity of SQL with new extensions for Big Data processing and easier user-extensibility. In this session I will explain the main concepts of the new language and show examples of how to use it to query unstructured, semi-structured and structured data. Discover the similarities to the SQL and database objects you know and call out some of the important differences. We will discuss tools and practices to monitor, tune and improve performance of U-SQL. What parameters to look for, how to absorb metrics, what features to tune and how to make sure you can run massive scale Big Data environments.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 21

Time: 10:00 AM - 11:00 AM

Room: Room5

In order to ascertain the abilities of cloud computing platform, let us overview what is available & offered on Microsoft Azure.

Microsoft Azure has the ability to move, store and analyze data within the cloud. It is essential to evaluate multiple opportunities and options with Microsoft Azure data insights. In this session let us talk about strategies on data storage, data partitioning and availability options with Azure. A tour on how best these Azure components can help you achieve success for your Big Data platform.
Speaker:

Session Type:
Extended Session (90 minutes)

Track:
Advanced Analysis Techniques

Level: Intermedia

Session Code:

Date: May 21

Time: 11:10 AM - 12:40 PM

Room: Room4

Continuous Integration is not normally associate with data warehouse projects due to the perceived complexity of implementation.  John will be showing how modern tools make it simple to apply continuous integration techniques to data warehouse projects.  In particular, the session will cover: 

* Setting up SQL Server Data Tools for automated deployments: DAC Publish profiles & SQLPackage.exe

* Automating your build and deployments with PowerShell and psake

* Guide to configuring TeamCity as your build server

* Automated Integration and Regression testing of your Data Warehouse using NBi test framework

* Automating cube and tabular model deployment

* On-going management of OLAP databases using the SSAS Partition Manager
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Platform Architecture, Development & Administration

Level: Intermedia

Session Code:

Date: May 21

Time: 4:30 PM - 5:30 PM

Room: Room2

This was never showed before, a Hacker and DBA fighting against the time! The brilliant hacker mind trying to intrude and gain access inside of SQL Server to steal the most valued data using the Kalil Linux distribution when in other side the DBA avoing such achievement by using the security best practice and features available on SQL Server.

A Hacker's goal is to find vulnerabilities in a system and a DBA's goal is to make the environment secure and reliable. In this session we will learn how to protect SQL Server from the various forms of attacks that a smart hacker can throw at you. Let's dig in the Hacker thought process to understand the inception of the attack and how to defeat the invasion. Join with me in this internal session using SQL Server and Kali Linux for the ultimate security showdown!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 21

Time: 12:30 PM - 1:30 PM

Room: Room1

During this session we will talk about DevOps practices in general and also see some demos about how to automate your builds, how to manage your releases, how to manage different environments and create them on a fly.

I will show the demo app which consists of 3 parts - client app, server api and database. I will show how to automate builds for all parts of your project. I will show how to provide different configuration settings for different environments. I will show how you can create new environment on a fly, deploy your app there, run some integration and UI automation tests, etc. I will show how to automate all routine stuff and focused more on innovation, not maintenance.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Cloud Application Development & Deployment

Level: Intermedia

Session Code:

Date: May 21

Time: 4:30 PM - 5:30 PM

Room: Room4

A common requirement in database applications is that users need 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 isboth 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:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 21

Time: 3:10 PM - 4:10 PM

Room: Room1

With the release of the public preview versions of SQL Server 2016 we were finally able to play with, in my opinion, one of the most exciting new features in SQL Server 2016, the Query Store! The Query Store serves as a flight recorder for your query workload and provides valuable insights into the performance of your queries. It doesn’t stop there however, using the performance metrics the Query Store records, we can decide which Execution Plan SQL Server should use when executing a specific query. If those two features aren’t enough, the Query Store provides all this information inside easy-to-use reports and Dynamic Management Views (DMVs) removing a great deal of the complexity of query performance analysis.
During this session we will take a thorough look at the Query Store, it’s architecture, the build-in reporting, DMVs and the performance impact of enabling the Query Store. No matter if you are a DBA or developer, the Query Store has information that can help you!
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 21

Time: 2:00 PM - 3:00 PM

Room: Room1

The session begins with „JSON“ and shows with a syntax-comparison the similarities to XML.
Both the different operational scenarios and the technical background
of JSON and XML, however, require a different range of functions and language.
Therefore, initially, as far as practicable the parallels will be demonstrated.
Especially the T-SQL  extensions  „FOR JSON“  and  „OpenJSON“  are very similarly implemented in comparison to „FOR XML“ and „OpenXML“.
Furthermore the new functions  „IsJSON“,  „JSON_VALUE“ and  „JSON_QUERY“  are now contained in T-SQL. Do they also have these as T-SQL functions for XML or can these results be calculated with XML-methods?
Additionally, XML has some more features which concern saving ( and indexing ) and requesting 
(in particular with XQuery) in relational tables. These will also be demonstrated exemplary. 
The goal of the session is to show, when which language is of advantage in which case.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Intermedia

Session Code:

Date: May 21

Time: 10:00 AM - 11:00 AM

Room: Room2

There are a number of challenges while collaborating on database development. When someone in a team changes database objects in a shared database, another team member may overwrite those changes. This will lead to the data loss. The best way to resolve such challenges is to start using database version control. In this session, we will talk about the source control basics, and also have a look at how to start source controlling your SQL Server databases.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 21

Time: 10:00 AM - 11:00 AM

Room: Room3

DML operations mean lots of work for the database engine of Microsoft SQL Server. Understanding the details of a transaction may give you great benefits when planning workloads for INSERT, UPDATE and DELETE operations.
This session will demonstrate the huge difference of allocation data in a heap and in a clustered index. If you don't know the benefits of correct record size and / or you are wondering how you could release allocated data pages in a professional way this session may give you all the answers.

- data page allocation and its difference for heaps and clustered indexes
- what is the amount of translog when you update data in a heap and/or in a clustered index
- delete data from a heap and what is the huge difference to a clustered index?
- speed up ETL processes by usage of the right strategy for INSERTS and DELETES
- Page Splits vs. Forwarded Records
- do you really need a clustered index in a table? Pro's and Con's of clustered indexes for DML operations

Speaker:

Accompanying Materials:

Session Type:
Extended Session (90 minutes)

Track:
Professional Development

Level: Advanced

Session Code:

Date: May 21

Time: 11:10 AM - 12:40 PM

Room: Room1

SQL Server provides a wealth of excellent functionalities and tools that are able to greatly facilitate the life of a database administrator. During this session we will discuss the Policy Based Management and PowerShell, we’ll show how to manage not only a single SQL Server instance, but also multiple instances. All this in practical way – most of the time we will spent on demonstrations, not sterile theory.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Enterprise Database Administration & Deployment

Level: Intermedia

Session Code:

Date: May 21

Time: 3:10 PM - 4:10 PM

Room: Room5

PostgreSQL very popular RDBMS. In this talk I will describe interesting abilities of this database to handle Big Data, such as build-in data types and functions, various indexes, sharding methodology, various extensions, backup strategies.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Strategy and Architecture

Level: Intermedia

Session Code:

Date: May 21

Time: 2:00 PM - 3:00 PM

Room: Room2

? ???? ???????? ?? ????????? ??? ???????????? Power BI Desktop+Power BI Service ????? ????????? ??????? ???????, ??????? ???????? ?????????????? dashboards, ??????????? self-service ??????? ? BI ?? ????????? ???????????. ?? ????? ????? ?? ???????? ??????? ???????????? ????????? ????????? ?????? ? ????????????? ?????????????, ??????? ????? ???? ???????????? ??? ???????? ??????????? ??? ? ????????? ? ??????? ?????????????? ? ???????? ??????? Power BI Service.
? ????? ??? ?? ????? ??????????? ?????????? ???????????? BI ???????, ??????????? Power BI ? ?? ???????? ? ???????? ? ??????????. ?? ????????? ????? ?? ?????? ????? - ??? ???????????? PowerQuery ??? ??????????? ? ????????????? ?????? ?? ?????????? ??????????; PowerPivot ? DAX ??? ????????????? ??????, ???????? ?????????? ? KPI; ??? ????????? ????????????? ? ????????????? ?????? ? Power BI ????????? ????????? ??????? ????????????, ??? ???????????? ?????????? ?????? ? ??????????? ? ?????????????? Dashboards ? Groups ? Power BI Service
Speaker:

Accompanying Materials:

No material found.

Session Type:
Pre-Con Training (480 minutes)

Track:
Other

Level: Intermedia

Session Code:

Date: May 20

Time: 10:00 AM - 6:00 PM

Room: Room1

Power BI enables you to create beautiful and very informative dashboards for business users. You can use embedded connectors to many sorts of data sources for getting your data. Moreover, you can get data from real-time data sources as well, for instance monitoring systems, sensors, web sites etc, and get the most from your data. Join this session to learn how to use PowerBI REST API to add real-time dashboards.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
BI Information Delivery

Level: Intermedia

Session Code:

Date: May 21

Time: 11:10 AM - 12:10 PM

Room: Room3

During the session we will talk about how to avoid modification anomalies and  improve the performance of your DBMS.
Speaker:

Accompanying Materials:

Session Type:
Regular Session (60 minutes)

Track:
Application & Database Development

Level: Beginner

Session Code:

Date: May 21

Time: 3:10 PM - 4:10 PM

Room: Room4

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