Build Schedule

Advanced Filters:
  • Track

    clear all




  • Speaker


  • Level


  • Session Type

Sessions Found: 21
Ever wanted to work with a BI Tool the way you search with Google aehm... Bing?
With Power BI there comes a new toolset called Q&A, which should enable you to do that.
Is it really like this? Does it work? How does it work?
This session will introduce Q&A, will have a look behind the scences of Q&A, how to build models
addressing natural language questions and a will review the usability
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track Big Data Analytics

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

If you want to conduct advanced Business Intelligence development and Business Analysis, then it is useful to understand data visualisation and have R as a tool in your toolset. In this intensive one hour session, we will look at the latest suite of Microsoft Business Intelligence tools - Microsoft Power BI in conjunction with R. The demos will be implemented in both tools in an end-to-end hour long session so that delegates can see when to use each technology in order to determine 'what to use' and 'when to use it', as well as seeing where the technologies complement each other. We will visualise the data according to data visualisation principles set out by Stephen Few amongst others.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track Big Data Analytics

Level: Advanced

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

DBAs do not always have time to work with some of the amazing visual data tools that are becoming common place now for analysts.  In this presentation I will show how in just a few very easy steps you can learn more than the basics of PowerView, PowerPivot and Data Mining using data you are already familiar with as a DBA, your SQL Server installation data. We will look at new and interesting way to load, transform, merge and analyze configuration and performance data for many servers simultaneously. I will also demonstrate how to best utilize that data for reports in Excel, SSRS and Visio to get the most out of automation, standardization and visualization with the new Power tools.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track DBA

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Around 80% of the work to create a data warehouse/BI solution is spent on the ETL phase. Although building an ETL solution can be a challenge, you can break down the project into at least two separate processes for easier management. One process is strictly related to business modeling, and therefore cannot be replicated. But the other is made up of purely technical processes that are always the same, regardless of the business environment we operate in, and thus can be highly automated. 

In this session, we will look at well-known patterns to solving common problems and how they can be automated with the help of specific tools and techniques that use metadata to reduce development time and bugs. Using these engineering techniques, you will be able to adopt an Agile approach to your BI solution.
Speaker:

Session Type:
Regular Session

Track:
Track BI

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Toda esta revolución de SQL Server 2014 no pasa desapercibida para nadie. Sin embargo, quizá podamos hacer que pase desapercibida la llega a nuestras organizaciones de esta nueva versión, ya que plantear una migración de forme directa es muy difícil que logre cristalizar. ¿Qué hacemos entonces? Aprenderemos algunas formas de conseguir que la implantación de SQL Server 2014 sea un proceso nada disruptivo que nos lleve, como quien no quiere la cosa, a una plataforma actualizada con todas las ventajas que ello supone.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track DBA

Level: Beginner

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

¿Quién no ha tenido problemas de rendimiento en las soluciones de BI? Monitorizar las consultas y los recursos se convierte en algo crucial para detectar problemas. Durante la sesión construiremos un sistema de monitorización que incorpora datos de DMVs, contadores de rendimiento y los nuevos Eventos Extendidos de SSAS, y que además puede realizar acciones automatizadas como cancelar consultas o enviar alertas a los administradores. ¿Quieres convertirte en el ojo que todo lo ve? No te pierdas la sesión.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track BI

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

This introductory session describes and demonstrates how to create a big data analytics solution with structured data by using Azure HDInsight and Excel 2013. This session will be of interest to those new to the concept of big data, new to self-service data modeling with Power Pivot, and for those interested to understand how big data can play a role in a self-service BI solution. Demonstrations will reinforce the introductory theory by showing how to store data files, and how to use Pig to transform data, and Hive to query data. The “big data” will then be retrieved and queried by using Power BI add-ins in Excel 2013, including Power Query, Power Pivot and Power View. 
Speaker:

Session Type:
Regular Session

Track:
Track Big Data Analytics

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

When it comes to clustered columnstore indexes, you may already understand row groups, delta stores, and compression methods, but come see how clustered columnstore indexes work with locking and blocking and when using different compression methods and techniques. We will also dive deep into Dictionaries creation and different methods for ETL processes.
Speaker:

Session Type:
Regular Session

Track:
Track BI

Level: Advanced

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

El tiempo entre que un dato está en el sistema transaccional y está disponible en nuestro DW puede ser un problema cuando se construye un sistema de información complejo. En la sesión veremos algunas técnicas combinadas que ayudan a minimizar estos tiempos para trabajar en tiempo semi-real.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track BI

Level: Advanced

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

En esta sesión veremos dos novedades que ofrece SQL Server 2014 para gestionar la concurrencia de las cargas transaccionales de los sistemas OLTP de forma muy transparente.La durabilidad diferida de transacciones permite "aligerar" el acceso al archivo de transacciones penalizando ligeramente la "transaccionalidad completa" de la operacion: Veremos pros y contras de esta operación. Las mejoras en gestión de bloqueos permitirán que operaciones de mantenimiento no se vean bloqueadas (o bloqueen) las operaciones del día a día del sistema transaccional.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track DBA

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Please join this session to see end to end exciting demos in a story format for two real world scenarios. We will use tools and technologies including Power Query, Power Pivot, Power View, Power Map, Power BI sites, Q&A, Windows Azure HD Insight, STORM,  APS, SAP BI Connector etc. All demos are based on real world implementations including Microsoft Cybercrime center,  a retail customer etc.Please join this interactive session to have an immersive and fun experience!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track Big Data Analytics

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Reporting Services es una tecnología madura que se ha ido transformando hasta proporcionarnos diferentes controles y funcionalidades a la hora de realizar nuestros informes. Podemos crear suscripciones, gráficas, alertas de datos... pero, ¿estamos sacando todo el partido que podemos sacarle? En esta sesión veremos como llevar a Reporting Services a limites que no te imaginarias. ¡Se acabaron los informes aburridos y poco interactivos!
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track BI

Level: Advanced

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Microsoft have released a distribution of Hadoop targeted at making big data accessible to everyone.  Hadoop is different to SQL Server.  Not necessarily better, just different.  It is a tool for a job.  if you have only ever worked with an RDBMS such as SQL Server then Hadoop is going to play with your mind a little and you are going to need to rethink a few things.
This session is going to take Hadoop and break it apart.  I will also look at some of the tooling Hive and Pig.
Keep an open mind and let me show you that Hadoop has lots to offer.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track Big Data Analytics

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

On-Premise Server are still here and will surely last for a while. Buying a server isn't s complex task, but buying the server that maximize the ROI of the money you spent on it is not an easy task, since there is so much choice that finding the correct machine is really not trivial. In this session we'll see the internals of a server, learning how memory, cpu, disks and all the rest works together.   Along with some basic numbers and math we'll see how to find the correct hardware needed and how to evaluate the server we're going to buy, before releasing it in production and realizing, too late, that it physically can't delivery the performance we need.
Speaker:

Session Type:
Regular Session

Track:
Track DBA

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

DML is used in  most cases without thinking about the multiple operations for the db engine. This session will give a deep dive into the internal storage engine down to record level.
After finishing the theory (and inside the theory) the differen DML commands and their tremendous operational tasks for the db engine will be investigated.
SEE, what a workload will be caused by a "forwarded record". What tremendous workload will occur in a page split. What happens if an existing record will be updated in fixed length attributes 
Speaker:

Session Type:
Regular Session

Track:
Track DBA

Level: Advanced

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

In-Memory OLTP aka Hekaton aka XTP is without a doubt one of the key features in brand new SQL Server 2014. By placing your data in memory and using native compile stored procedures you can boost and increase you SQL Server performance in times. But it is not so easy to implement as it may seem, you need to make a lot of changes in your code and even in your application architecture. In this session you'll learn what parts of your system can benefit by using In-Memory OLTP and what you should take into consideration before starting. As a bonus, I'll share my own experience of implementing In-Memory OLTP into a real production system.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track DBA

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Todo el mundo que trabaja con base de datos siempre se ha preguntado alguna vez qué son los planes de ejecución y como se leen. Saber leer un plan de ejecución nos va a dar información valiosísima de cara a mejorar el rendimiento de una consulta. En esta sesión vamos a centrarnos en aprender a leer T-SQL para interpretar lo que está haciendo SQL Server para devolvernos la información.
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track DBA

Level: Advanced

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

Did you know that Power View is not any longer limited to getting data from Tabular models ? Now that Power View users can connect to multidimensional BI Semantic Model (Cubes) we will have a look at how to get the best out of this interactive data exploration, visualization and presentation for multidimensional models. 
The session we'll present
- An understanding of the Multidimensional Model Objects in Power View
- How to create a Shared Report Data Source Connection to a Multidimensional Model
- How to create a Power View Report with a Multidimensional Model Data Source
- An visual exploration of a Multidimensional Model by using Power View
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track BI

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

La gestión de grandes volúmenes de información es cada día más común, y los datos de texto no son una excepción, desde nombres de clientes en una tabla hasta documentos completos digitalizados. Veremos qué opciones nos ofrece SQL Server para tratar textos y cómo podemos aplicarlas a ámbitos como buscadores difusos, gestión documental, enriquecimiento de data warehouses y más. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track Big Data Analytics

Level: Intermedia

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

You have worked with SQL Server Integration Services (SSIS) for a few years, but more often than not, you see performance problems with your packages. Some packages are running slow, while others are taking up more memory and CPU than before.

In this session, you will learn the internals of SSIS and why having a deep understanding is important to solve performance problems. You will also learn how the control flow engine and data flow engine work, what the impact on performance buffers have, and how execution trees are related to parallelism. 
Speaker:

Accompanying Materials:

No material found.

Session Type:
Regular Session

Track:
Track BI

Level: Advanced

Session Code:

Date: October 25

Time: 12:00 AM - 1:00 AM

Room: TBD

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