Build Schedule

Advanced Filters:
  • Track

    clear all



  • Speaker


  • Level


  • Session Type

Sessions Found: 12
About  columnstore Indexes
Speaker:

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: July 25

Time: 12:00 AM - 1:00 AM

Room:

???????? - ????? ????? ????????, ??? ?? ?????????? ?????? SQL Server’a. ?????? ? ??????? ????? ????-?????? ?? ????, ?????? ? ???? ??? ?????? ???????, ?? ????? ???????? ????????????, ?? ???? ???????????, ?????? ?? ??? ?????. ??? ????? ????????? ?????? ?????????? ?????, ????? ??? ?????, ? ??? ? ???? ???????? (???? ?????????) ?? ?????????? ? ???? ???????
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: July 25

Time: 10:00 AM - 11:00 AM

Room: Room 2

????? ? ? ?????? ?????????? ? ???????????, ? ???????: "?? ??? ? ??? ????? ???? ?????????". ?? ??? ????????? ?? ????, ??? ?????????? ?? ??????? ????? ??? ????????? ? ??????? ????. ?????? ??????, ????? ?????????? ? ??? ????????, ? ???? ???????????????? ?????? ????? ?? ??????, ?????????? ?????-???? ?????? ??????, ?? ?? ?????? ???? ??????. 

? ??????? ? ???????? ? ???, ??? ????? ?????????????? ??????????, ??? ? ??? ???? ?? ??????????, ??? ?? ????????? ? ??? ?????? ???? ???-?? ????? ?? ???. 
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: July 25

Time: 2:35 PM - 3:35 PM

Room: Room 2

About dependency between query syntax (adhoc query, query with local variables, stored procedures, local variable ) and query execution plan
Speaker:

Session Type:
Regular Session

Track:
Other

Level: Intermedia

Session Code:

Date: July 25

Time: 10:00 AM - 11:00 AM

Room: Room 1

The session is about methods and tools for continuous integration and delivery of databases in web development
Speaker:

Accompanying Materials:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: July 25

Time: 11:05 AM - 12:05 PM

Room: Room 1

The session will describe the typical schemes of the developers work with database and methods how to maintain the database up to date with the history of changes. There will be a demonstration of some methods.
Speaker:

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: July 25

Time: 3:40 PM - 4:40 PM

Room: Room 2

Almost any database query can be written in several ways. T-SQL, as any other query language, contains many language constructions and has a lot of aspects, that can both make life easier and more complex. Under "complex life", I understand bad readability and poor performance. In this session we will consider a number of typical tasks, solved with the help of T-SQL, and will look at effective and ineffective task solutions.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Other

Level: Beginner

Session Code:

Date: July 25

Time: 2:35 PM - 3:35 PM

Room: Room 1

SQL Server 2014 is full of new features and improvements. Some of them are "Killer" features like InMemory OLTP, Clustered Columnstore Indexes, Buffer Pool Extensions, etc., which are discussed a lot and we always can get a lot of information about them. And in the same time, SQL Server 2014 have several fantastic features and improvements, which are more hidden from our sight. In this session we will talk in details about these features and improvements. Query Fingerprints, Cardinality Estimator, Tempdb improvements, and more features will be covered in this session.
Speaker:

Session Type:
Regular Session

Track:
Other

Level: Advanced

Session Code:

Date: July 25

Time: 12:35 PM - 1:35 PM

Room: Room 1

Type of NULL (usage of functions nullif(), isnull(), coalesce()), features of function STR(), implicit conversion and indexes in SQL queries, etc.
Speaker:

Session Type:
Regular Session

Track:
Other

Level: Intermedia

Session Code:

Date: July 25

Time: 5:05 PM - 6:05 PM

Room: Room 1

NoSQL - MongoDB. Agility, scalability, performance. I am going to talk about the basis of NoSQL and MongoDB. Why some projects requires RDBMs and another NoSQL databases? What are the pros and cons to use NoSQL vs. SQL? How data are stored and transefed in MongoDB? What query language is used? How MongoDB supports high availability and automatic failover with the help of the replication? What is sharding and how it helps to support scalability?. The newest level of the concurrency - collection-level and document-level. Join the session, I promise that it will be interesting! :)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Beginner

Session Code:

Date: July 25

Time: 11:05 AM - 12:05 PM

Room: Room 2

NoSQL - MongoDB. Agility, scalability, performance. I am going to talk about the basis of NoSQL and MongoDB. Why some projects requires RDBMs and another NoSQL databases? What are the pros and cons to use NoSQL vs. SQL? How data are stored and transefed in MongoDB? What query language is used? How MongoDB supports high availability and automatic failover with the help of the replication? What is sharding and how it helps to support scalability?. The newest level of the concurrency - collection-level and document-level. Join the session, I promise that it will be interesting! :)
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: July 25

Time: 12:35 PM - 1:35 PM

Room: Room 2

In this sessions you will learn how to perform seamless upgrade from previous version of SQL Server (yes, even from version 2000!) to latest and greatest version of SQL Server. No matter if reason of upgrade is end of support or consolidation, you are upgrading from Express Edition or Enterprise – you will get set of best practices how to avoid most common issues and perform successful upgrade. On the session there will be not only theoretical knowledge but real life examples with demos.
Speaker:

Session Type:
Regular Session

Track:
Track 1

Level: Intermedia

Session Code:

Date: July 25

Time: 3:40 PM - 4:40 PM

Room: Room 1

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