Build Schedule

Advanced Filters:
  • Track

    clear all












  • Speaker


  • Level


  • Session Type

Sessions Found: 13
If you're using SQL Server 2012 or SQL Server 2014 as the database server for SharePoint 2013, you must perform particular set of steps to install SQL Server and then configure it specifically to host your SharePoint 2013 farm. In this session, we’ll walk through the installation process for SQL Server. I'll explain the post-installation configuration changes that are foreseen to SharePoint 2013. We’ll also have a look on how to configure SQL as SharePoint backups – all via PowerShell - for sure! As last point bottlenecks for HA/DR environments will be explained in a few steps.

After this session you will serve admirably the database back end to your SharePoint 2013 farm.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Jupiter 2

Level: Intermedia

Session Code:

Date: December 12

Time: 11:15 AM - 12:15 PM

Room: Jupiter 2

At the end of this session attendees are be able to read and understand the execution plans. This simple thing can enhance our productivity because it will help us to detect and potentially solve performance problems.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Jupiter 2

Level: Beginner

Session Code:

Date: December 12

Time: 1:15 PM - 2:15 PM

Room: Jupiter 2

Another in TheSQLGuru's very popular "Deep Dive" series, this time covering indexing.  You will learn about the internal structures of heaps, clustered indexes and nonclustered indexes.  We will examine included columns and covering indexes, filtered indexes, indexed views, indexing DMVs and finding the right indexes.  There are some incredibly helpful graphics as well as some nice samples to help you transition theory to practice.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Jupiter 1

Level: Advanced

Session Code:

Date: December 12

Time: 2:30 PM - 3:30 PM

Room: Jupiter 1

A few weeks ago Microsoft's Azure SQL Data Warehouse launched in limited public preview. Data is growing exponentially and companies have problems like storing, scaling, or analyzing etc. We will talk about new generation data warehouse that is an elastic data warehouse-as-a-service in Azure Platforms and compare similar technologies. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Adara

Level: Advanced

Session Code:

Date: December 12

Time: 3:45 PM - 4:45 PM

Room: Adara

In this session, make queries with SQL Server BI Power Desktop application on SharePoint and will give information about subtleties.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Jupiter 2

Level: Advanced

Session Code:

Date: December 12

Time: 1:15 PM - 2:15 PM

Room: Adara

With Microsoft Azure Stream Analytics and Event Hubs services, it will be more effective and usable to get IOT data and analyse this data. Content management has a important position in real world, such as websites and other interactive systems. So, with Stream Analytics service, analyse this click stream data is really getting easy. Additionally, it is possible to report this click stream data using PowerBI on Microsoft Azure. 

In this session, we will be talking about;

 - What's IOT?
- Microsoft Azure Stream Analytics 
- Microsoft Azure Event Hubs
- Microsoft PowerBI
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Adara

Level: Intermedia

Session Code:

Date: December 12

Time: 11:15 AM - 12:15 PM

Room: Adara

Social media are computer-mediated tools that allow people to create, share or exchange information, ideas, and pictures/videos in virtual communities and networks. To sum up Social Media is everything for your customers and Your company need to listen them to understand, make a custom offer or improve loyalty etc. Azure Stream Analytics and HDInsight platforms can solve this problem for you. We'll focus on how to get Twitter data using Stream Analytics and how to make data enrichment and storing using HDInsight and What is the problem about sentiment analytics using Azure Machine Learning.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Adara

Level: Advanced

Session Code:

Date: December 12

Time: 10:00 AM - 11:00 AM

Room: Adara

Columnstore indexes uses column-based data storage and query processing to achieve up to 10x query performance gains in your data warehouse over traditional row-oriented storage. It also makes you gain up to 10x data compression over the uncompressed data size. Beginning with SQL Server 2016 columnstore indexes enable operational analytics, the ability to run performant real-time analytics on a transactional workload. In this session we'll see how columnstore indexes work and how we can get most benefits from them in practice. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Jupiter 1

Level: Intermedia

Session Code:

Date: December 12

Time: 3:45 PM - 4:45 PM

Room: Jupiter 1

Today almost all the business applications/databases need High Availability and Disaster Recovery solutions for uninterrupted service continuity. In this session we'll have a look at High Availability and Disaster Recovery (HA/DR) Solutions of SQL Server and what is newly coming with SQL Server 2016. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Jupiter 1

Level: Intermedia

Session Code:

Date: December 12

Time: 10:00 AM - 11:00 AM

Room: Jupiter 1

We will cover most of the bases in this broad and deep coverage of table/index partitioning in the relational engine. Numerous demonstrations will help gel knowledge you can take back to the office and begin to apply to your environments to reap the many benefits of this fine addition to the product that has been significantly enhanced since SQL 2005.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Jupiter 2

Level: Advanced

Session Code:

Date: December 12

Time: 10:00 AM - 11:00 AM

Room: Jupiter 2

Query Optimization is one of the most interesting and most challenging aspects of working with SQL Server.  In this session, we will cover Query Design and Optimization for best performance. Firstly we will gather data for analysis, then we will identify bottlenecks, and finally we will optimize specific queries. All this will be done with small changes on our queries.
Speaker:

Session Type:
Regular Session (60 minutes)

Track:
Jupiter 2

Level: Intermedia

Session Code:

Date: December 12

Time: 2:30 PM - 3:30 PM

Room: Jupiter 2

The Internet of Things is becoming reality at a rapid pace. Many objects in the real world can be connected to the Internet. Cloud computing is the best option for the IoT backend. Microsoft Azure offers the best set of services, required for the Internet of Things solutions, including a wide set of storages, websites, cloud services, Azure Service Bus / Event Hubs, Mobile Services, AD authentication and many data platform and BI related products like Azure SQL Database, DocumentDB, Azure Storage, Azure Stream Analytics, Machine Learning, Power BI and more..  
This talk is about the main business cases and main architectural challenges, related to the actual and new IoT systems and particularly predictive services, based on Microsoft Azure.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Adara

Level: Intermedia

Session Code:

Date: December 12

Time: 2:30 PM - 3:30 PM

Room: Adara

In this demo-packed session, you will learn how/what to monitor to have confidence that AlwaysOn Availability Groups are working properly. We will also cover where to look for problems - Harden, REDO, DMVs, xEvent Logs, SQL error logs, cluster logs, etc.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session (60 minutes)

Track:
Jupiter 1

Level: Advanced

Session Code:

Date: December 12

Time: 11:15 AM - 12:15 PM

Room: Jupiter 1

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